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(); }
public SALSalesHeaderCollection HeaderSearch(string CustomerName, string InvoiceNumber) { SALSalesHeaderCollection sALSalesHeaderCollection = new SALSalesHeaderCollection(); foreach (POS.DataLayer.SALSalesHeader _sALSalesHeader in POS.DataLayer.SALSalesHeader.HeaderSearch(CustomerName, InvoiceNumber)) { SALSalesHeader _sALSalesHeaderWCF = new SALSalesHeader(); _sALSalesHeaderWCF.SalesHeaderID = _sALSalesHeader.SalesHeaderID; _sALSalesHeaderWCF.SalesDate = _sALSalesHeader.SalesDate; _sALSalesHeaderWCF.CustomerID = _sALSalesHeader.CustomerID; _sALSalesHeaderWCF.CustomerName = _sALSalesHeader.CustomerName; _sALSalesHeaderWCF.InvoiceNumber = _sALSalesHeader.InvoiceNumber; _sALSalesHeaderWCF.InvoiceDate = _sALSalesHeader.InvoiceDate; _sALSalesHeaderWCF.SellerID = _sALSalesHeader.SellerID; _sALSalesHeaderWCF.PaymentTypeID = _sALSalesHeader.PaymentTypeID; _sALSalesHeaderWCF.TotalPrice = _sALSalesHeader.TotalPrice; _sALSalesHeaderWCF.PaidAmount = _sALSalesHeader.PaidAmount; _sALSalesHeaderWCF.RemainingAmount = _sALSalesHeader.RemainingAmount; _sALSalesHeaderWCF.LastDayToPay = _sALSalesHeader.LastDayToPay; _sALSalesHeaderWCF.TotalDiscountAmount = _sALSalesHeader.TotalDiscountAmount; _sALSalesHeaderWCF.TotalDiscountRatio = _sALSalesHeader.TotalDiscountRatio; _sALSalesHeaderWCF.IsClosed = _sALSalesHeader.IsClosed; _sALSalesHeaderWCF.IsVoid = _sALSalesHeader.IsVoid; _sALSalesHeaderWCF.IsPrinted = _sALSalesHeader.IsPrinted; _sALSalesHeaderWCF.ServicePrice = _sALSalesHeader.ServicePrice; _sALSalesHeaderWCF.TaxTypeID = _sALSalesHeader.TaxTypeID; _sALSalesHeaderWCF.RefuseReasonID = _sALSalesHeader.RefuseReasonID; _sALSalesHeaderWCF.CreatedBy = _sALSalesHeader.CreatedBy; _sALSalesHeaderWCF.CreateDate = _sALSalesHeader.CreateDate; _sALSalesHeaderWCF.UpdatedBy = _sALSalesHeader.UpdatedBy; _sALSalesHeaderWCF.UpdateDate = _sALSalesHeader.UpdateDate; _sALSalesHeaderWCF.IsDeleted = _sALSalesHeader.IsDeleted; _sALSalesHeaderWCF.DeletedBy = _sALSalesHeader.DeletedBy; _sALSalesHeaderWCF.DeletDate = _sALSalesHeader.DeletDate; sALSalesHeaderCollection.Add(_sALSalesHeaderWCF); } return(sALSalesHeaderCollection); }
public SALSalesHeaderCollection HeaderSearch(string CustomerName, string InvoiceNumber) { SALSalesHeaderCollection sALSalesHeaderCollection = new SALSalesHeaderCollection(); foreach (POS.DataLayer.SALSalesHeader _sALSalesHeader in POS.DataLayer.SALSalesHeader.HeaderSearch(CustomerName, InvoiceNumber)) { SALSalesHeader _sALSalesHeaderWCF = new SALSalesHeader(); _sALSalesHeaderWCF.SalesHeaderID = _sALSalesHeader.SalesHeaderID; _sALSalesHeaderWCF.SalesDate = _sALSalesHeader.SalesDate; _sALSalesHeaderWCF.CustomerID = _sALSalesHeader.CustomerID; _sALSalesHeaderWCF.CustomerName = _sALSalesHeader.CustomerName; _sALSalesHeaderWCF.InvoiceNumber = _sALSalesHeader.InvoiceNumber; _sALSalesHeaderWCF.InvoiceDate = _sALSalesHeader.InvoiceDate; _sALSalesHeaderWCF.SellerID = _sALSalesHeader.SellerID; _sALSalesHeaderWCF.PaymentTypeID = _sALSalesHeader.PaymentTypeID; _sALSalesHeaderWCF.TotalPrice = _sALSalesHeader.TotalPrice; _sALSalesHeaderWCF.PaidAmount = _sALSalesHeader.PaidAmount; _sALSalesHeaderWCF.RemainingAmount = _sALSalesHeader.RemainingAmount; _sALSalesHeaderWCF.LastDayToPay = _sALSalesHeader.LastDayToPay; _sALSalesHeaderWCF.TotalDiscountAmount = _sALSalesHeader.TotalDiscountAmount; _sALSalesHeaderWCF.TotalDiscountRatio = _sALSalesHeader.TotalDiscountRatio; _sALSalesHeaderWCF.IsClosed = _sALSalesHeader.IsClosed; _sALSalesHeaderWCF.IsVoid = _sALSalesHeader.IsVoid; _sALSalesHeaderWCF.IsPrinted = _sALSalesHeader.IsPrinted; _sALSalesHeaderWCF.ServicePrice = _sALSalesHeader.ServicePrice; _sALSalesHeaderWCF.TaxTypeID = _sALSalesHeader.TaxTypeID; _sALSalesHeaderWCF.RefuseReasonID = _sALSalesHeader.RefuseReasonID; _sALSalesHeaderWCF.CreatedBy = _sALSalesHeader.CreatedBy; _sALSalesHeaderWCF.CreateDate = _sALSalesHeader.CreateDate; _sALSalesHeaderWCF.UpdatedBy = _sALSalesHeader.UpdatedBy; _sALSalesHeaderWCF.UpdateDate = _sALSalesHeader.UpdateDate; _sALSalesHeaderWCF.IsDeleted = _sALSalesHeader.IsDeleted; _sALSalesHeaderWCF.DeletedBy = _sALSalesHeader.DeletedBy; _sALSalesHeaderWCF.DeletDate = _sALSalesHeader.DeletDate; sALSalesHeaderCollection.Add(_sALSalesHeaderWCF); } return sALSalesHeaderCollection; }
/// <summary> /// This method will return an object representing the record matching the primary key information specified. /// </summary> /// /// <param name="pk" type="SALSalesHeaderPrimaryKey">Primary Key information based on which data is to be fetched.</param> /// /// <returns>object of class SALSalesHeader</returns> public SALSalesHeader SelectOne(SALSalesHeaderPrimaryKey pk) { _sALSalesHeaderWCF = new SALSalesHeader(); _sALSalesHeader = POS.DataLayer.SALSalesHeaderBase.SelectOne(new POS.DataLayer.SALSalesHeaderPrimaryKey(pk.SalesHeaderID)); _sALSalesHeaderWCF.SalesHeaderID = _sALSalesHeader.SalesHeaderID; _sALSalesHeaderWCF.SalesDate = _sALSalesHeader.SalesDate; _sALSalesHeaderWCF.CustomerID = _sALSalesHeader.CustomerID; _sALSalesHeaderWCF.InvoiceNumber = _sALSalesHeader.InvoiceNumber; _sALSalesHeaderWCF.InvoiceDate = _sALSalesHeader.InvoiceDate; _sALSalesHeaderWCF.SellerID = _sALSalesHeader.SellerID; _sALSalesHeaderWCF.PaymentTypeID = _sALSalesHeader.PaymentTypeID; _sALSalesHeaderWCF.TotalPrice = _sALSalesHeader.TotalPrice; _sALSalesHeaderWCF.PaidAmount = _sALSalesHeader.PaidAmount; _sALSalesHeaderWCF.RemainingAmount = _sALSalesHeader.RemainingAmount; _sALSalesHeaderWCF.LastDayToPay = _sALSalesHeader.LastDayToPay; _sALSalesHeaderWCF.TotalDiscountAmount = _sALSalesHeader.TotalDiscountAmount; _sALSalesHeaderWCF.TotalDiscountRatio = _sALSalesHeader.TotalDiscountRatio; _sALSalesHeaderWCF.IsClosed = _sALSalesHeader.IsClosed; _sALSalesHeaderWCF.IsVoid = _sALSalesHeader.IsVoid; _sALSalesHeaderWCF.IsPrinted = _sALSalesHeader.IsPrinted; _sALSalesHeaderWCF.ServicePrice = _sALSalesHeader.ServicePrice; _sALSalesHeaderWCF.TaxTypeID = _sALSalesHeader.TaxTypeID; _sALSalesHeaderWCF.RefuseReasonID = _sALSalesHeader.RefuseReasonID; _sALSalesHeaderWCF.CreatedBy = _sALSalesHeader.CreatedBy; _sALSalesHeaderWCF.CreateDate = _sALSalesHeader.CreateDate; _sALSalesHeaderWCF.UpdatedBy = _sALSalesHeader.UpdatedBy; _sALSalesHeaderWCF.UpdateDate = _sALSalesHeader.UpdateDate; _sALSalesHeaderWCF.IsDeleted = _sALSalesHeader.IsDeleted; _sALSalesHeaderWCF.DeletedBy = _sALSalesHeader.DeletedBy; _sALSalesHeaderWCF.DeletDate = _sALSalesHeader.DeletDate; _sALSalesHeaderWCF.InventoryID = _sALSalesHeader.InventoryID; _sALSalesHeaderWCF.FinalPrice = _sALSalesHeader.FinalPrice; _sALSalesHeaderWCF.ChequeNumber = _sALSalesHeader.ChequeNumber; return _sALSalesHeaderWCF; }
public bool SaveAccountUpdates(BDCustomerAccount _customerAccount) { #region select area SALSalesHeaderPrimaryKey purchaseHeaderpk = new SALSalesHeaderPrimaryKey(); purchaseHeaderpk.SalesHeaderID = _customerAccount.SalesInvoiceId; SALSalesHeader _salSalesHeader = _purchaseHeaderService.SelectOne(purchaseHeaderpk); BDCustomerAccountPrimaryKey customerAccountpk = new BDCustomerAccountPrimaryKey(); customerAccountpk.CustomerAccountNumber = _customerAccount.CustomerAccountNumber; BDCustomerAccount customerAccount = SelectOne(customerAccountpk); #endregion #region customer account area POS.DataLayer.BDCustomerAccount customerAccountDal = new POS.DataLayer.BDCustomerAccount(); customerAccountDal.CreateDate = customerAccount.CreateDate; customerAccountDal.CreatedBy = customerAccount.CreatedBy; customerAccountDal.DeletedDate = customerAccount.DeletedDate; customerAccountDal.DeletedBy = customerAccount.DeletedBy; customerAccountDal.InvoiceNumber = customerAccount.InvoiceNumber; customerAccountDal.IsDeleted = customerAccount.IsDeleted; customerAccountDal.IsVoid = customerAccount.IsVoid; customerAccountDal.SalesInvoiceId = customerAccount.SalesInvoiceId; customerAccountDal.SalesDate = customerAccount.SalesDate; customerAccountDal.CustomerAccountNumber = customerAccount.CustomerAccountNumber; customerAccountDal.CustomerID = customerAccount.CustomerID; customerAccountDal.UpdateDate = customerAccount.UpdateDate; customerAccountDal.UpdatedBy = customerAccount.UpdatedBy; ////////// Updated area customerAccountDal.PaidAmount = _customerAccount.PaidAmount; customerAccountDal.RemainingAmount = _customerAccount.RemainingAmount; customerAccountDal.TotalPrice = _customerAccount.TotalPrice; #endregion #region purchase area POS.DataLayer.SALSalesHeader _purchaseHeaderDAL = new POS.DataLayer.SALSalesHeader(); _purchaseHeaderDAL.SalesHeaderID = _salSalesHeader.SalesHeaderID; _purchaseHeaderDAL.SalesDate = _salSalesHeader.SalesDate; _purchaseHeaderDAL.CustomerID = _salSalesHeader.CustomerID; _purchaseHeaderDAL.CustomerName = _salSalesHeader.CustomerName; _purchaseHeaderDAL.InvoiceNumber = _salSalesHeader.InvoiceNumber; _purchaseHeaderDAL.InvoiceDate = _salSalesHeader.InvoiceDate; _purchaseHeaderDAL.SellerID = _salSalesHeader.SellerID; _purchaseHeaderDAL.PaymentTypeID = _salSalesHeader.PaymentTypeID; _purchaseHeaderDAL.LastDayToPay = _salSalesHeader.LastDayToPay; _purchaseHeaderDAL.TotalDiscountAmount = _salSalesHeader.TotalDiscountAmount; _purchaseHeaderDAL.TotalDiscountRatio = _salSalesHeader.TotalDiscountRatio; _purchaseHeaderDAL.IsClosed = _salSalesHeader.IsClosed; _purchaseHeaderDAL.IsVoid = _salSalesHeader.IsVoid; _purchaseHeaderDAL.IsPrinted = _salSalesHeader.IsPrinted; _purchaseHeaderDAL.ServicePrice = _salSalesHeader.ServicePrice; _purchaseHeaderDAL.TaxTypeID = _salSalesHeader.TaxTypeID; _purchaseHeaderDAL.RefuseReasonID = _salSalesHeader.RefuseReasonID; _purchaseHeaderDAL.CreatedBy = _salSalesHeader.CreatedBy; _purchaseHeaderDAL.CreateDate = _salSalesHeader.CreateDate; _purchaseHeaderDAL.UpdatedBy = _salSalesHeader.UpdatedBy; _purchaseHeaderDAL.UpdateDate = _salSalesHeader.UpdateDate; _purchaseHeaderDAL.IsDeleted = _salSalesHeader.IsDeleted; _purchaseHeaderDAL.DeletedBy = _salSalesHeader.DeletedBy; _purchaseHeaderDAL.DeletDate = _salSalesHeader.DeletDate; ///////////// updated area _purchaseHeaderDAL.TotalPrice = _customerAccount.TotalPrice; _purchaseHeaderDAL.PaidAmount = _customerAccount.PaidAmount; _purchaseHeaderDAL.RemainingAmount = _customerAccount.RemainingAmount; #endregion POS.DataLayer.BDCustomerAccount customerAccountObj = new DataLayer.BDCustomerAccount(); return(customerAccountObj.SaveAccountUpdates(_purchaseHeaderDAL, customerAccountDal)); }
/// <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 SALSalesHeader</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 SALSalesHeader in the form of an object of class SALSalesHeaderCollection</returns> public SALSalesHeaderCollection SelectByFieldPaged(string field, object fieldValue, object fieldValue2, TypeOperation typeOperation, int pageSize, int skipPages, string orderByStatement) { SALSalesHeaderCollection sALSalesHeaderCollection = new SALSalesHeaderCollection(); foreach (POS.DataLayer.SALSalesHeader _sALSalesHeader in POS.DataLayer.SALSalesHeaderBase.SelectByFieldPaged(field, fieldValue, fieldValue2, typeOperation, pageSize, skipPages, orderByStatement)) { _sALSalesHeaderWCF = new SALSalesHeader(); _sALSalesHeaderWCF.SalesHeaderID = _sALSalesHeader.SalesHeaderID; _sALSalesHeaderWCF.SalesDate = _sALSalesHeader.SalesDate; _sALSalesHeaderWCF.CustomerID = _sALSalesHeader.CustomerID; _sALSalesHeaderWCF.InvoiceNumber = _sALSalesHeader.InvoiceNumber; _sALSalesHeaderWCF.InvoiceDate = _sALSalesHeader.InvoiceDate; _sALSalesHeaderWCF.SellerID = _sALSalesHeader.SellerID; _sALSalesHeaderWCF.PaymentTypeID = _sALSalesHeader.PaymentTypeID; _sALSalesHeaderWCF.TotalPrice = _sALSalesHeader.TotalPrice; _sALSalesHeaderWCF.PaidAmount = _sALSalesHeader.PaidAmount; _sALSalesHeaderWCF.RemainingAmount = _sALSalesHeader.RemainingAmount; _sALSalesHeaderWCF.LastDayToPay = _sALSalesHeader.LastDayToPay; _sALSalesHeaderWCF.TotalDiscountAmount = _sALSalesHeader.TotalDiscountAmount; _sALSalesHeaderWCF.TotalDiscountRatio = _sALSalesHeader.TotalDiscountRatio; _sALSalesHeaderWCF.IsClosed = _sALSalesHeader.IsClosed; _sALSalesHeaderWCF.IsVoid = _sALSalesHeader.IsVoid; _sALSalesHeaderWCF.IsPrinted = _sALSalesHeader.IsPrinted; _sALSalesHeaderWCF.ServicePrice = _sALSalesHeader.ServicePrice; _sALSalesHeaderWCF.TaxTypeID = _sALSalesHeader.TaxTypeID; _sALSalesHeaderWCF.RefuseReasonID = _sALSalesHeader.RefuseReasonID; _sALSalesHeaderWCF.CreatedBy = _sALSalesHeader.CreatedBy; _sALSalesHeaderWCF.CreateDate = _sALSalesHeader.CreateDate; _sALSalesHeaderWCF.UpdatedBy = _sALSalesHeader.UpdatedBy; _sALSalesHeaderWCF.UpdateDate = _sALSalesHeader.UpdateDate; _sALSalesHeaderWCF.IsDeleted = _sALSalesHeader.IsDeleted; _sALSalesHeaderWCF.DeletedBy = _sALSalesHeader.DeletedBy; _sALSalesHeaderWCF.DeletDate = _sALSalesHeader.DeletDate; _sALSalesHeaderWCF.InventoryID = _sALSalesHeader.InventoryID; _sALSalesHeaderWCF.FinalPrice = _sALSalesHeader.FinalPrice; _sALSalesHeaderWCF.ChequeNumber = _sALSalesHeader.ChequeNumber; sALSalesHeaderCollection.Add(_sALSalesHeaderWCF); } return sALSalesHeaderCollection; }
/// <summary> /// This method will get row(s) from the database using the value of the field specified /// along with the details of the child table. /// </summary> /// /// <param name="pk" type="PaymentTypePrimaryKey">Primary Key information based on which data is to be fetched.</param> /// /// <returns>object of class SALSalesHeaderCollection</returns> public SALSalesHeaderCollection SelectAllByForeignKeyPaymentTypeID(PaymentTypePrimaryKey pk) { SALSalesHeaderCollection sALSalesHeaderCollection=new SALSalesHeaderCollection(); foreach (POS.DataLayer.SALSalesHeader _sALSalesHeader in POS.DataLayer.SALSalesHeaderBase.SelectAllByForeignKeyPaymentTypeID(new POS.DataLayer.PaymentTypePrimaryKey(pk.PaymentTypeID))) { _sALSalesHeaderWCF = new SALSalesHeader(); _sALSalesHeaderWCF.SalesHeaderID = _sALSalesHeader.SalesHeaderID; _sALSalesHeaderWCF.SalesDate = _sALSalesHeader.SalesDate; _sALSalesHeaderWCF.CustomerID = _sALSalesHeader.CustomerID; _sALSalesHeaderWCF.InvoiceNumber = _sALSalesHeader.InvoiceNumber; _sALSalesHeaderWCF.InvoiceDate = _sALSalesHeader.InvoiceDate; _sALSalesHeaderWCF.SellerID = _sALSalesHeader.SellerID; _sALSalesHeaderWCF.PaymentTypeID = _sALSalesHeader.PaymentTypeID; _sALSalesHeaderWCF.TotalPrice = _sALSalesHeader.TotalPrice; _sALSalesHeaderWCF.PaidAmount = _sALSalesHeader.PaidAmount; _sALSalesHeaderWCF.RemainingAmount = _sALSalesHeader.RemainingAmount; _sALSalesHeaderWCF.LastDayToPay = _sALSalesHeader.LastDayToPay; _sALSalesHeaderWCF.TotalDiscountAmount = _sALSalesHeader.TotalDiscountAmount; _sALSalesHeaderWCF.TotalDiscountRatio = _sALSalesHeader.TotalDiscountRatio; _sALSalesHeaderWCF.IsClosed = _sALSalesHeader.IsClosed; _sALSalesHeaderWCF.IsVoid = _sALSalesHeader.IsVoid; _sALSalesHeaderWCF.IsPrinted = _sALSalesHeader.IsPrinted; _sALSalesHeaderWCF.ServicePrice = _sALSalesHeader.ServicePrice; _sALSalesHeaderWCF.TaxTypeID = _sALSalesHeader.TaxTypeID; _sALSalesHeaderWCF.RefuseReasonID = _sALSalesHeader.RefuseReasonID; _sALSalesHeaderWCF.CreatedBy = _sALSalesHeader.CreatedBy; _sALSalesHeaderWCF.CreateDate = _sALSalesHeader.CreateDate; _sALSalesHeaderWCF.UpdatedBy = _sALSalesHeader.UpdatedBy; _sALSalesHeaderWCF.UpdateDate = _sALSalesHeader.UpdateDate; _sALSalesHeaderWCF.IsDeleted = _sALSalesHeader.IsDeleted; _sALSalesHeaderWCF.DeletedBy = _sALSalesHeader.DeletedBy; _sALSalesHeaderWCF.DeletDate = _sALSalesHeader.DeletDate; _sALSalesHeaderWCF.InventoryID = _sALSalesHeader.InventoryID; _sALSalesHeaderWCF.FinalPrice = _sALSalesHeader.FinalPrice; _sALSalesHeaderWCF.ChequeNumber = _sALSalesHeader.ChequeNumber; sALSalesHeaderCollection.Add(_sALSalesHeaderWCF); } return sALSalesHeaderCollection; }
/// <summary> /// This method will insert one new row into the database using the property Information /// </summary> /// /// <param name="sALSalesHeader" type="SALSalesHeader">This SALSalesHeader will be inserted in the database.</param> /// /// <returns>True if succeeded</returns> public bool Insert(SALSalesHeader sALSalesHeader) { _sALSalesHeader = new POS.DataLayer.SALSalesHeader(); _sALSalesHeader.SalesHeaderID=sALSalesHeader.SalesHeaderID; _sALSalesHeader.SalesDate=sALSalesHeader.SalesDate; _sALSalesHeader.CustomerID=sALSalesHeader.CustomerID; _sALSalesHeader.InvoiceNumber=sALSalesHeader.InvoiceNumber; _sALSalesHeader.InvoiceDate=sALSalesHeader.InvoiceDate; _sALSalesHeader.SellerID=sALSalesHeader.SellerID; _sALSalesHeader.PaymentTypeID=sALSalesHeader.PaymentTypeID; _sALSalesHeader.TotalPrice=sALSalesHeader.TotalPrice; _sALSalesHeader.PaidAmount=sALSalesHeader.PaidAmount; _sALSalesHeader.RemainingAmount=sALSalesHeader.RemainingAmount; _sALSalesHeader.LastDayToPay=sALSalesHeader.LastDayToPay; _sALSalesHeader.TotalDiscountAmount=sALSalesHeader.TotalDiscountAmount; _sALSalesHeader.TotalDiscountRatio=sALSalesHeader.TotalDiscountRatio; _sALSalesHeader.IsClosed=sALSalesHeader.IsClosed; _sALSalesHeader.IsVoid=sALSalesHeader.IsVoid; _sALSalesHeader.IsPrinted=sALSalesHeader.IsPrinted; _sALSalesHeader.ServicePrice=sALSalesHeader.ServicePrice; _sALSalesHeader.TaxTypeID=sALSalesHeader.TaxTypeID; _sALSalesHeader.RefuseReasonID=sALSalesHeader.RefuseReasonID; _sALSalesHeader.CreatedBy=sALSalesHeader.CreatedBy; _sALSalesHeader.CreateDate=sALSalesHeader.CreateDate; _sALSalesHeader.UpdatedBy=sALSalesHeader.UpdatedBy; _sALSalesHeader.UpdateDate=sALSalesHeader.UpdateDate; _sALSalesHeader.IsDeleted=sALSalesHeader.IsDeleted; _sALSalesHeader.DeletedBy=sALSalesHeader.DeletedBy; _sALSalesHeader.DeletDate=sALSalesHeader.DeletDate; _sALSalesHeader.InventoryID=sALSalesHeader.InventoryID; _sALSalesHeader.FinalPrice=sALSalesHeader.FinalPrice; _sALSalesHeader.ChequeNumber=sALSalesHeader.ChequeNumber; return _sALSalesHeader.Insert(); }