ayanova7/source/bizobjects/AyaLib/GZTW.AyaNova.BLL/WorkorderQuotePickList.cs

///////////////////////////////////////////////////////////
//  WorkorderQuotePickList.cs
//  Implementation of Class WorkorderQuotePickList
//  CSLA type: Read only collection 
//  Created on: 8-Oct-2015  
//  Object design: John  
//  Coded:  8-Oct-2015  
///////////////////////////////////////////////////////////

using System;
using System.Data;
using GZTW.Data;
using CSLA.Data;
using CSLA;

namespace GZTW.AyaNova.BLL 
{
	/// <summary>
    /// Lightweight read only list of <see cref="WorkorderQuotePickList.WorkorderQuotePickListInfo"/> objects representing <see cref="Workorder"/> objects.
    /// Fetched by client for selection in UI.
	/// </summary>
	[Serializable]
	public class WorkorderQuotePickList : ReadOnlyCollectionBase 
	{		
		#region Data structure
		/// <summary>
		///
		/// </summary>
		[Serializable]
		public struct WorkorderQuotePickListInfo 
		{		
			
			internal Guid mID;
			internal string mQuoteNumber;
			internal DateTime mRequestedDate;
			internal string mSummary;
			
			

			//Public properties
            /// <summary>
            /// <see cref="Workorder"/> object ID
            /// </summary>
			public Guid ID {get{return mID;}}
		
            /// <summary>
            /// <see cref="Workorder"/> object's <see cref="WorkorderQuote"/> number
            /// </summary>
			public string QuoteNumber {get{return mQuoteNumber;}}

            /// <summary>
            /// 
            /// </summary>
			public string Summary {get{return mSummary;}}
            /// <summary>
            /// 
            /// </summary>
			public DateTime RequestedDate {get{return mRequestedDate;}}
			
			
			 
			
			
			

			/// <summary>
			///
			/// </summary>
			/// <param name="obj"></param>
			public bool Equals(WorkorderQuotePickListInfo obj)
			{
				return this.mID.Equals(obj.mID);
			}

		}//end WorkorderQuotePickListInfo
		#endregion

		#region Constructor
        /// <summary>
        /// 
        /// </summary>
		protected WorkorderQuotePickList()
		{
			//			AllowSort=false;
			//			AllowFind=true;
			//			AllowEdit=false;
			//			AllowNew=false;
			//			AllowRemove=false;
		}

		#endregion
		
		#region Business properties and methods

		/// <summary>
		/// Get item by index
		/// </summary>
		/// <param name="Item"></param>
		public WorkorderQuotePickListInfo this[int Item]
		{

			get
			{
				return (WorkorderQuotePickListInfo) List[Item];
			}
		}


		/// <summary>
		/// Returns WorkorderQuotePickListInfo item that matches passed in itemid value
		/// </summary>
		/// <param name="ItemID"></param>
		public WorkorderQuotePickListInfo this[Guid ItemID]
		{

			get
			{
				foreach (WorkorderQuotePickListInfo child in List)
				{
					if(child.mID==ItemID) return child;
				}
				throw new ArgumentException("WorkorderQuotePickList: ID not found:\r\n"+ItemID.ToString());
				
			}
		}
		#endregion

		#region contains
		/// <summary>
		/// Check if item in collection
		/// </summary>		
		/// <param name="obj"></param>
		public bool Contains(WorkorderQuotePickListInfo obj)
		{
			foreach (WorkorderQuotePickListInfo child in List)
			{
				if(child.Equals(obj)) return true;
			}
			return false;

		}
		#endregion

		#region Static methods
		/// <summary>
		/// Get all Quotes for client specified
		/// </summary>
		/// <param name="ClientID">Client ID</param>
        /// <returns>list of <see cref="WorkorderQuotePickList.WorkorderQuotePickListInfo"/> objects</returns>
		public static WorkorderQuotePickList GetListByClient(Guid ClientID)
		{
			return (WorkorderQuotePickList) DataPortal.Fetch(new Criteria(ClientID, Guid.Empty));
		}

        /// <summary>
        /// Get all quotes for client specified
        /// except one specified in workorder id parameter
        /// </summary>
        /// <param name="ClientID">Client ID</param>
        /// <param name="WorkorderId">Guid of quote that should not be included in return list</param>
        /// <returns>list of <see cref="WorkorderQuotePickList.WorkorderQuotePickListInfo"/> objects</returns>
        public static WorkorderQuotePickList GetListByClient(Guid ClientID, Guid WorkorderId)
        {
            return (WorkorderQuotePickList)DataPortal.Fetch(new Criteria(ClientID, WorkorderId));
        }
		


		#endregion

		#region DAL DATA ACCESS
		/// 
		/// <param name="Criteria"></param>
		protected override void DataPortal_Fetch(object Criteria)
		{
			Criteria crit = (Criteria)Criteria;	
			
			SafeDataReader dr = null;	
			try
			{			
				DBCommandWrapper dbCommandWrapper = DBUtil.DB.GetSqlStringCommandWrapper(
					//************************************************************
					"SELECT aWorkorder.aID, AWORKORDERQUOTE.aQuoteNumber, " +
					" AWORKORDERQUOTE.AQUOTEREQUESTDATE, aWorkorder.aSummary " +
					"FROM aWorkorder INNER JOIN AWORKORDERQUOTE " +
					"ON aWorkorder.aID = AWORKORDERQUOTE.aWorkorderID " +
					"WHERE(aWorkorder.aClientID " +
					"= @ClientID) AND (aWorkorder.aWorkorderType " +
					"= @WorkorderType) ORDER BY AWORKORDERQUOTE.AQUOTENUMBER DESC "
					//************************************************************
					);
				dbCommandWrapper.AddInParameter("@ClientID",DbType.Guid,crit.ClientID);
				//dbCommandWrapper.AddInParameter("@aFalse",DbType.Boolean,false);
				dbCommandWrapper.AddInParameter("@WorkorderType",DbType.Int16,(int)WorkorderTypes.Quote);
				dr = new SafeDataReader(DBUtil.DB.ExecuteReader(dbCommandWrapper));
							
				
				while(dr.Read()) 
				{
					//*******************************************
					WorkorderQuotePickListInfo info=new WorkorderQuotePickListInfo();					
					info.mID=dr.GetGuid("aID");
                    if (info.mID == crit.WorkorderID)
                        continue;//case 1975
					info.mQuoteNumber=dr.GetInt32("aQuoteNumber").ToString();
					info.mSummary=dr.GetString("aSummary");
                    info.mRequestedDate = DBUtil.ToLocal(dr.GetDateTime("AQUOTEREQUESTDATE"));
					InnerList.Add(info);
					//*******************************************
				}
			}
			finally
			{
				if(dr!=null) dr.Close();
			}	

			
		}
		#endregion		

		#region criteria
		/// <summary>
		/// Criteria for identifying existing object
		/// </summary>
		[Serializable]
			private class Criteria
		{

						
			public Guid ClientID;
            public Guid WorkorderID;
			
			public Criteria(Guid _ClientID, Guid _WorkorderID )
			{					
				ClientID=_ClientID;
                WorkorderID = _WorkorderID;
				
			}
			
		}
		#endregion
		
	}//end WorkorderQuotePickList

}//end namespace GZTW.AyaNova.BLL