/// <summary> /// This method will return a list of objects representing all records in the table. /// </summary> /// /// <returns>list of objects of class SALSalesLine in the form of object of SALSalesLineCollection </returns> public SALSalesLineCollection SelectAll() { SALSalesLineCollection sALSalesLineCollection = new SALSalesLineCollection(); foreach (POS.DataLayer.SALSalesLine _sALSalesLine in POS.DataLayer.SALSalesLineBase.SelectAll()) { _sALSalesLineWCF = new SALSalesLine(); _sALSalesLineWCF.SalesLineID = _sALSalesLine.SalesLineID; _sALSalesLineWCF.SalesHeaderID = _sALSalesLine.SalesHeaderID; _sALSalesLineWCF.ProductID = _sALSalesLine.ProductID; _sALSalesLineWCF.TotalQty = _sALSalesLine.TotalQty; _sALSalesLineWCF.TotalBonus = _sALSalesLine.TotalBonus; _sALSalesLineWCF.DiscountAmount = _sALSalesLine.DiscountAmount; _sALSalesLineWCF.DiscountRatio = _sALSalesLine.DiscountRatio; _sALSalesLineWCF.UnitPrice = _sALSalesLine.UnitPrice; _sALSalesLineWCF.CreatedBy = _sALSalesLine.CreatedBy; _sALSalesLineWCF.CreateDate = _sALSalesLine.CreateDate; _sALSalesLineWCF.UpdatedBy = _sALSalesLine.UpdatedBy; _sALSalesLineWCF.UpdateDate = _sALSalesLine.UpdateDate; _sALSalesLineWCF.IsDeleted = _sALSalesLine.IsDeleted; _sALSalesLineWCF.DeletedBy = _sALSalesLine.DeletedBy; _sALSalesLineWCF.DeleteDate = _sALSalesLine.DeleteDate; sALSalesLineCollection.Add(_sALSalesLineWCF); } return(sALSalesLineCollection); }
/// <summary> /// This method will return a list of objects representing the specified number of entries from the specified record number in the table. /// </summary> /// /// <param name="pageSize" type="int">Number of records returned.</param> /// <param name="skipPages" type="int">The number of missing pages.</param> /// <param name="orderByStatement" type="string">The field value to number.</param> /// /// <returns>list of objects of class SALSalesLine in the form of an object of class SALSalesLineCollection </returns> public SALSalesLineCollection SelectAllPaged(int?pageSize, int?skipPages, string orderByStatement) { SALSalesLineCollection sALSalesLineCollection = new SALSalesLineCollection(); foreach (POS.DataLayer.SALSalesLine _sALSalesLine in POS.DataLayer.SALSalesLineBase.SelectAllPaged(pageSize, skipPages, orderByStatement)) { _sALSalesLineWCF = new SALSalesLine(); _sALSalesLineWCF.SalesLineID = _sALSalesLine.SalesLineID; _sALSalesLineWCF.SalesHeaderID = _sALSalesLine.SalesHeaderID; _sALSalesLineWCF.ProductID = _sALSalesLine.ProductID; _sALSalesLineWCF.TotalQty = _sALSalesLine.TotalQty; _sALSalesLineWCF.TotalBonus = _sALSalesLine.TotalBonus; _sALSalesLineWCF.DiscountAmount = _sALSalesLine.DiscountAmount; _sALSalesLineWCF.DiscountRatio = _sALSalesLine.DiscountRatio; _sALSalesLineWCF.UnitPrice = _sALSalesLine.UnitPrice; _sALSalesLineWCF.CreatedBy = _sALSalesLine.CreatedBy; _sALSalesLineWCF.CreateDate = _sALSalesLine.CreateDate; _sALSalesLineWCF.UpdatedBy = _sALSalesLine.UpdatedBy; _sALSalesLineWCF.UpdateDate = _sALSalesLine.UpdateDate; _sALSalesLineWCF.IsDeleted = _sALSalesLine.IsDeleted; _sALSalesLineWCF.DeletedBy = _sALSalesLine.DeletedBy; _sALSalesLineWCF.DeleteDate = _sALSalesLine.DeleteDate; sALSalesLineCollection.Add(_sALSalesLineWCF); } return(sALSalesLineCollection); }
/// <summary> /// This method will return a list of objects representing the specified number of entries from the specified record number in the table /// using the value of the field specified /// </summary> /// /// <param name="field" type="string">Field of the class SALSalesLine</param> /// <param name="fieldValue" type="object">Value for the field specified.</param> /// <param name="fieldValue2" type="object">Value for the field specified.</param> /// <param name="typeOperation" type="TypeOperation">Operator that is used if fieldValue2=null or fieldValue2="".</param> /// <param name="orderByStatement" type="string">The field value to number.</param> /// <param name="pageSize" type="int">Number of records returned.</param> /// <param name="skipPages" type="int">The number of missing pages.</param> /// /// <returns>List of object of class SALSalesLine in the form of an object of class SALSalesLineCollection</returns> public SALSalesLineCollection SelectByFieldPaged(string field, object fieldValue, object fieldValue2, TypeOperation typeOperation, int pageSize, int skipPages, string orderByStatement) { SALSalesLineCollection sALSalesLineCollection = new SALSalesLineCollection(); foreach (POS.DataLayer.SALSalesLine _sALSalesLine in POS.DataLayer.SALSalesLineBase.SelectByFieldPaged(field, fieldValue, fieldValue2, typeOperation, pageSize, skipPages, orderByStatement)) { _sALSalesLineWCF = new SALSalesLine(); _sALSalesLineWCF.SalesLineID = _sALSalesLine.SalesLineID; _sALSalesLineWCF.SalesHeaderID = _sALSalesLine.SalesHeaderID; _sALSalesLineWCF.ProductID = _sALSalesLine.ProductID; _sALSalesLineWCF.TotalQty = _sALSalesLine.TotalQty; _sALSalesLineWCF.TotalBonus = _sALSalesLine.TotalBonus; _sALSalesLineWCF.DiscountAmount = _sALSalesLine.DiscountAmount; _sALSalesLineWCF.DiscountRatio = _sALSalesLine.DiscountRatio; _sALSalesLineWCF.UnitPrice = _sALSalesLine.UnitPrice; _sALSalesLineWCF.CreatedBy = _sALSalesLine.CreatedBy; _sALSalesLineWCF.CreateDate = _sALSalesLine.CreateDate; _sALSalesLineWCF.UpdatedBy = _sALSalesLine.UpdatedBy; _sALSalesLineWCF.UpdateDate = _sALSalesLine.UpdateDate; _sALSalesLineWCF.IsDeleted = _sALSalesLine.IsDeleted; _sALSalesLineWCF.DeletedBy = _sALSalesLine.DeletedBy; _sALSalesLineWCF.DeleteDate = _sALSalesLine.DeleteDate; sALSalesLineCollection.Add(_sALSalesLineWCF); } return(sALSalesLineCollection); }
public int SaveTransaction(SALSalesHeader sALSalesHeader, SALSalesLineCollection sALSalesLineCollection) { oDatabaseHelper = new DatabaseHelper(); bool ExecutionState = false; int salesHeaderID = -1; oDatabaseHelper.BeginTransaction(); if (InsertHeader(oDatabaseHelper, sALSalesHeader, out salesHeaderID)) { foreach (SALSalesLine sALSalesLine in sALSalesLineCollection) { if (!InsertDetails(oDatabaseHelper, sALSalesLine, salesHeaderID)) { ExecutionState = false; break; } else ExecutionState = true; } if (ExecutionState) oDatabaseHelper.CommitTransaction(); else oDatabaseHelper.RollbackTransaction(); } return salesHeaderID; }
/// <summary> /// This method will return a list of objects representing all records in the table. /// </summary> /// /// <returns>list of objects of class SALSalesLine in the form of object of SALSalesLineCollection </returns> public SALSalesLineCollection SelectAll() { SALSalesLineCollection sALSalesLineCollection = new SALSalesLineCollection(); foreach (POS.DataLayer.SALSalesLine _sALSalesLine in POS.DataLayer.SALSalesLineBase.SelectAll()) { _sALSalesLineWCF = new SALSalesLine(); _sALSalesLineWCF.SalesLineID = _sALSalesLine.SalesLineID; _sALSalesLineWCF.SalesHeaderID = _sALSalesLine.SalesHeaderID; _sALSalesLineWCF.ProductID = _sALSalesLine.ProductID; _sALSalesLineWCF.TotalQty = _sALSalesLine.TotalQty; _sALSalesLineWCF.TotalBonus = _sALSalesLine.TotalBonus; _sALSalesLineWCF.DiscountAmount = _sALSalesLine.DiscountAmount; _sALSalesLineWCF.DiscountRatio = _sALSalesLine.DiscountRatio; _sALSalesLineWCF.UnitPrice = _sALSalesLine.UnitPrice; _sALSalesLineWCF.CreatedBy = _sALSalesLine.CreatedBy; _sALSalesLineWCF.CreateDate = _sALSalesLine.CreateDate; _sALSalesLineWCF.UpdatedBy = _sALSalesLine.UpdatedBy; _sALSalesLineWCF.UpdateDate = _sALSalesLine.UpdateDate; _sALSalesLineWCF.IsDeleted = _sALSalesLine.IsDeleted; _sALSalesLineWCF.DeletedBy = _sALSalesLine.DeletedBy; _sALSalesLineWCF.DeleteDate = _sALSalesLine.DeleteDate; sALSalesLineCollection.Add(_sALSalesLineWCF); } return sALSalesLineCollection; }
private void GetSalesOrderData(int salesHeaderID) { SALSalesHeaderPrimaryKey pk = new SALSalesHeaderPrimaryKey(); pk.SalesHeaderID = salesHeaderID; _sALSalesHeader = _sALSalesHeaderWrapper.SelectOne(pk); sALSalesLineCollection = _sALSalesLinerWrapper.SelectByField(salesHeaderID); }
public bool UpdateCloseSALSalesOrder(SALSalesHeader sALSalesHeader, SALSalesLineCollection sALSalesLineCollection) { POS.DataLayer.SALSalesHeader _sALSalesHeader = new POS.DataLayer.SALSalesHeader(); _sALSalesHeader.SalesHeaderID = sALSalesHeader.SalesHeaderID; _sALSalesHeader.SalesDate = DateTime.Now; _sALSalesHeader.CustomerID = sALSalesHeader.CustomerID; _sALSalesHeader.InvoiceNumber = sALSalesHeader.InvoiceNumber; _sALSalesHeader.InvoiceDate = sALSalesHeader.InvoiceDate; _sALSalesHeader.InventoryID = sALSalesHeader.InventoryID; _sALSalesHeader.SellerID = GlobalVariables.CurrentUser.UserID; _sALSalesHeader.PaymentTypeID = sALSalesHeader.PaymentTypeID; _sALSalesHeader.TotalPrice = sALSalesHeader.TotalPrice; _sALSalesHeader.FinalPrice = sALSalesHeader.FinalPrice; _sALSalesHeader.PaidAmount = sALSalesHeader.PaidAmount; _sALSalesHeader.RemainingAmount = sALSalesHeader.RemainingAmount; _sALSalesHeader.LastDayToPay = sALSalesHeader.LastDayToPay; _sALSalesHeader.TotalDiscountAmount = sALSalesHeader.TotalDiscountAmount; _sALSalesHeader.TotalDiscountRatio = sALSalesHeader.TotalDiscountRatio; _sALSalesHeader.IsClosed = true; _sALSalesHeader.IsVoid = false; _sALSalesHeader.IsPrinted = false; _sALSalesHeader.ServicePrice = sALSalesHeader.ServicePrice; _sALSalesHeader.TaxTypeID = sALSalesHeader.TaxTypeID; _sALSalesHeader.RefuseReasonID = null; _sALSalesHeader.CreatedBy = GlobalVariables.CurrentUser.UserID; _sALSalesHeader.CreateDate = DateTime.Now; _sALSalesHeader.UpdatedBy = GlobalVariables.CurrentUser.UserID; _sALSalesHeader.UpdateDate = DateTime.Now; _sALSalesHeader.IsDeleted = false; _sALSalesHeader.DeletedBy = null; _sALSalesHeader.DeletDate = null; _sALSalesHeader.ChequeNumber = sALSalesHeader.ChequeNumber; POS.DataLayer.SALSalesLineCollection _sALSalesLineCollection = new DataLayer.SALSalesLineCollection(); foreach (SALSalesLine sALSalesLine in sALSalesLineCollection) { POS.DataLayer.SALSalesLine _sALSalesLine = new POS.DataLayer.SALSalesLine(); _sALSalesLine.ProductID = sALSalesLine.ProductID; _sALSalesLine.TotalQty = sALSalesLine.TotalQty; _sALSalesLine.TotalBonus = sALSalesLine.TotalBonus; _sALSalesLine.DiscountAmount = sALSalesLine.DiscountAmount; _sALSalesLine.DiscountRatio = sALSalesLine.DiscountRatio; _sALSalesLine.UnitPrice = sALSalesLine.UnitPrice; _sALSalesLine.CreatedBy = GlobalVariables.CurrentUser.UserID; _sALSalesLine.CreateDate = DateTime.Now; _sALSalesLine.UpdatedBy = GlobalVariables.CurrentUser.UserID;; _sALSalesLine.UpdateDate = DateTime.Now; _sALSalesLine.IsDeleted = false; _sALSalesLine.DeletedBy = null; _sALSalesLine.DeleteDate = null; _sALSalesLineCollection.Add(_sALSalesLine); } POS.DataLayer.SALSalesLine sALSalesLineObj = new DataLayer.SALSalesLine(); return(sALSalesLineObj.UpdateTransaction(_sALSalesHeader, _sALSalesLineCollection)); }
public int SaveCloseSALSalesOrder(SALSalesHeader sALSalesHeader, SALSalesLineCollection sALSalesLineCollection) { POS.DataLayer.SALSalesHeader _sALSalesHeader = new POS.DataLayer.SALSalesHeader(); _sALSalesHeader.SalesDate = DateTime.Now; _sALSalesHeader.CustomerID = sALSalesHeader.CustomerID; _sALSalesHeader.InvoiceDate = sALSalesHeader.InvoiceDate; _sALSalesHeader.InventoryID = sALSalesHeader.InventoryID; _sALSalesHeader.SellerID = GlobalVariables.CurrentUser.UserID; _sALSalesHeader.PaymentTypeID = sALSalesHeader.PaymentTypeID; _sALSalesHeader.TotalPrice = sALSalesHeader.TotalPrice; _sALSalesHeader.FinalPrice = sALSalesHeader.FinalPrice; _sALSalesHeader.PaidAmount = sALSalesHeader.PaidAmount; _sALSalesHeader.RemainingAmount = sALSalesHeader.RemainingAmount; _sALSalesHeader.LastDayToPay = sALSalesHeader.LastDayToPay; _sALSalesHeader.TotalDiscountAmount = sALSalesHeader.TotalDiscountAmount; _sALSalesHeader.TotalDiscountRatio = sALSalesHeader.TotalDiscountRatio; _sALSalesHeader.IsClosed = true; _sALSalesHeader.IsVoid = false; _sALSalesHeader.IsPrinted = false; _sALSalesHeader.ServicePrice = sALSalesHeader.ServicePrice; _sALSalesHeader.TaxTypeID = sALSalesHeader.TaxTypeID; _sALSalesHeader.RefuseReasonID = null; _sALSalesHeader.CreatedBy = GlobalVariables.CurrentUser.UserID; _sALSalesHeader.CreateDate = DateTime.Now; _sALSalesHeader.UpdatedBy = null; _sALSalesHeader.UpdateDate = null; _sALSalesHeader.IsDeleted = false; _sALSalesHeader.DeletedBy = null; _sALSalesHeader.DeletDate = null; _sALSalesHeader.ChequeNumber = sALSalesHeader.ChequeNumber; POS.DataLayer.SALSalesLineCollection _sALSalesLineCollection = new DataLayer.SALSalesLineCollection(); foreach (SALSalesLine sALSalesLine in sALSalesLineCollection) { POS.DataLayer.SALSalesLine _sALSalesLine = new POS.DataLayer.SALSalesLine(); _sALSalesLine.ProductID = sALSalesLine.ProductID; _sALSalesLine.TotalQty = sALSalesLine.TotalQty; _sALSalesLine.TotalBonus = sALSalesLine.TotalBonus; _sALSalesLine.DiscountAmount = sALSalesLine.DiscountAmount; _sALSalesLine.DiscountRatio = sALSalesLine.DiscountRatio; _sALSalesLine.UnitPrice = sALSalesLine.UnitPrice; _sALSalesLine.CreatedBy = GlobalVariables.CurrentUser.UserID; _sALSalesLine.CreateDate = DateTime.Now; _sALSalesLine.UpdatedBy = null; _sALSalesLine.UpdateDate = null; _sALSalesLine.IsDeleted = false; _sALSalesLine.DeletedBy = null; _sALSalesLine.DeleteDate = null; _sALSalesLineCollection.Add(_sALSalesLine); } POS.DataLayer.SALSalesLine sALSalesLineObj = new DataLayer.SALSalesLine(); return sALSalesLineObj.SaveTransaction(_sALSalesHeader, _sALSalesLineCollection); }
public frmSalesOrderAddEdit() { InitializeComponent(); _bDTaxTypeWrapper = new BDTaxTypeWrapper(); _paymentTypeWrapper = new PaymentTypeWrapper(); _bDCustomerWrapper = new BDCustomerWrapper(); sALSalesLineCollection = new SALSalesLineCollection(); _sALSalesHeader = new SALSalesHeader(); _sALSalesLinerWrapper = new SALSalesLinerWrapper(); _iNVInventoryWrapper = new INVInventoryWrapper(); FillCustomerCBX(); FillPaymentTypeCBX(); FillTaxTypeCBX(); FillInventoryCBX(); }
/// <summary> /// Populates the fields for multiple objects from the columns found in an open reader. /// </summary> /// /// <param name="rdr" type="IDataReader">An object that implements the IDataReader interface</param> /// /// <returns>Object of SALSalesLineCollection</returns> /// /// <remarks> /// /// <RevisionHistory> /// Author Date Description /// DLGenerator 3/7/2015 2:37:16 PM Created function /// /// </RevisionHistory> /// /// </remarks> /// internal static SALSalesLineCollection PopulateObjectsFromReaderWithCheckingReader(IDataReader rdr, DatabaseHelper oDatabaseHelper) { SALSalesLineCollection list = new SALSalesLineCollection(); if (rdr.Read()) { SALSalesLine obj = new SALSalesLine(); PopulateObjectFromReader(obj, rdr); list.Add(obj); while (rdr.Read()) { obj = new SALSalesLine(); PopulateObjectFromReader(obj, rdr); list.Add(obj); } oDatabaseHelper.Dispose(); return list; } else { oDatabaseHelper.Dispose(); return null; } }
/// <summary> /// Populates the fields for multiple objects from the columns found in an open reader. /// </summary> /// /// <param name="rdr" type="IDataReader">An object that implements the IDataReader interface</param> /// /// <returns>Object of SALSalesLineCollection</returns> /// /// <remarks> /// /// <RevisionHistory> /// Author Date Description /// DLGenerator 3/7/2015 2:37:16 PM Created function /// /// </RevisionHistory> /// /// </remarks> /// internal static SALSalesLineCollection PopulateObjectsFromReader(IDataReader rdr) { SALSalesLineCollection list = new SALSalesLineCollection(); while (rdr.Read()) { SALSalesLine obj = new SALSalesLine(); PopulateObjectFromReader(obj,rdr); list.Add(obj); } return list; }
public bool UpdateTransaction(SALSalesHeader sALSalesHeader, SALSalesLineCollection sALSalesLineCollection) { oDatabaseHelper = new DatabaseHelper(); bool ExecutionState = false; oDatabaseHelper.BeginTransaction(); if (UpdateHeader(oDatabaseHelper, sALSalesHeader)) { if (DeleteDetails(oDatabaseHelper, (int)sALSalesHeader.SalesHeaderID, (int)sALSalesHeader.SellerID)) { foreach (SALSalesLine sALSalesLine in sALSalesLineCollection) { if (!InsertDetails(oDatabaseHelper, sALSalesLine, (int)sALSalesHeader.SalesHeaderID)) { ExecutionState = false; break; } else ExecutionState = true; } if (ExecutionState) oDatabaseHelper.CommitTransaction(); else oDatabaseHelper.RollbackTransaction(); } else ExecutionState = false; } else ExecutionState = false; return ExecutionState; }
/// <summary> /// This method will return a list of objects representing the specified number of entries from the specified record number in the table /// using the value of the field specified /// </summary> /// /// <param name="field" type="string">Field of the class SALSalesLine</param> /// <param name="fieldValue" type="object">Value for the field specified.</param> /// <param name="fieldValue2" type="object">Value for the field specified.</param> /// <param name="typeOperation" type="TypeOperation">Operator that is used if fieldValue2=null or fieldValue2="".</param> /// <param name="orderByStatement" type="string">The field value to number.</param> /// <param name="pageSize" type="int">Number of records returned.</param> /// <param name="skipPages" type="int">The number of missing pages.</param> /// /// <returns>List of object of class SALSalesLine in the form of an object of class SALSalesLineCollection</returns> public SALSalesLineCollection SelectByFieldPaged(string field, object fieldValue, object fieldValue2, TypeOperation typeOperation, int pageSize, int skipPages, string orderByStatement) { SALSalesLineCollection sALSalesLineCollection = new SALSalesLineCollection(); foreach (POS.DataLayer.SALSalesLine _sALSalesLine in POS.DataLayer.SALSalesLineBase.SelectByFieldPaged(field, fieldValue, fieldValue2, typeOperation, pageSize, skipPages, orderByStatement)) { _sALSalesLineWCF = new SALSalesLine(); _sALSalesLineWCF.SalesLineID = _sALSalesLine.SalesLineID; _sALSalesLineWCF.SalesHeaderID = _sALSalesLine.SalesHeaderID; _sALSalesLineWCF.ProductID = _sALSalesLine.ProductID; _sALSalesLineWCF.TotalQty = _sALSalesLine.TotalQty; _sALSalesLineWCF.TotalBonus = _sALSalesLine.TotalBonus; _sALSalesLineWCF.DiscountAmount = _sALSalesLine.DiscountAmount; _sALSalesLineWCF.DiscountRatio = _sALSalesLine.DiscountRatio; _sALSalesLineWCF.UnitPrice = _sALSalesLine.UnitPrice; _sALSalesLineWCF.CreatedBy = _sALSalesLine.CreatedBy; _sALSalesLineWCF.CreateDate = _sALSalesLine.CreateDate; _sALSalesLineWCF.UpdatedBy = _sALSalesLine.UpdatedBy; _sALSalesLineWCF.UpdateDate = _sALSalesLine.UpdateDate; _sALSalesLineWCF.IsDeleted = _sALSalesLine.IsDeleted; _sALSalesLineWCF.DeletedBy = _sALSalesLine.DeletedBy; _sALSalesLineWCF.DeleteDate = _sALSalesLine.DeleteDate; sALSalesLineCollection.Add(_sALSalesLineWCF); } return sALSalesLineCollection; }
/// <summary> /// This method will return a list of objects representing the specified number of entries from the specified record number in the table. /// </summary> /// /// <param name="pageSize" type="int">Number of records returned.</param> /// <param name="skipPages" type="int">The number of missing pages.</param> /// <param name="orderByStatement" type="string">The field value to number.</param> /// /// <returns>list of objects of class SALSalesLine in the form of an object of class SALSalesLineCollection </returns> public SALSalesLineCollection SelectAllPaged(int? pageSize, int? skipPages, string orderByStatement) { SALSalesLineCollection sALSalesLineCollection = new SALSalesLineCollection(); foreach (POS.DataLayer.SALSalesLine _sALSalesLine in POS.DataLayer.SALSalesLineBase.SelectAllPaged(pageSize, skipPages, orderByStatement)) { _sALSalesLineWCF = new SALSalesLine(); _sALSalesLineWCF.SalesLineID = _sALSalesLine.SalesLineID; _sALSalesLineWCF.SalesHeaderID = _sALSalesLine.SalesHeaderID; _sALSalesLineWCF.ProductID = _sALSalesLine.ProductID; _sALSalesLineWCF.TotalQty = _sALSalesLine.TotalQty; _sALSalesLineWCF.TotalBonus = _sALSalesLine.TotalBonus; _sALSalesLineWCF.DiscountAmount = _sALSalesLine.DiscountAmount; _sALSalesLineWCF.DiscountRatio = _sALSalesLine.DiscountRatio; _sALSalesLineWCF.UnitPrice = _sALSalesLine.UnitPrice; _sALSalesLineWCF.CreatedBy = _sALSalesLine.CreatedBy; _sALSalesLineWCF.CreateDate = _sALSalesLine.CreateDate; _sALSalesLineWCF.UpdatedBy = _sALSalesLine.UpdatedBy; _sALSalesLineWCF.UpdateDate = _sALSalesLine.UpdateDate; _sALSalesLineWCF.IsDeleted = _sALSalesLine.IsDeleted; _sALSalesLineWCF.DeletedBy = _sALSalesLine.DeletedBy; _sALSalesLineWCF.DeleteDate = _sALSalesLine.DeleteDate; sALSalesLineCollection.Add(_sALSalesLineWCF); } return sALSalesLineCollection; }