public int SavePURPurchaseOrder(PURPurchaseHeader pURPurchaseHeader, PURPurchaseLineCollection pURPurchaseLineCollection) { POS.DataLayer.PURPurchaseHeader _pURPurchaseHeader = new POS.DataLayer.PURPurchaseHeader(); _pURPurchaseHeader.PurcaseHeaderID = pURPurchaseHeader.PurcaseHeaderID; _pURPurchaseHeader.PurchaseDate = DateTime.Now; _pURPurchaseHeader.SupplierID = pURPurchaseHeader.SupplierID; _pURPurchaseHeader.InventoryID = pURPurchaseHeader.InventoryID; _pURPurchaseHeader.InvoiceNumber = pURPurchaseHeader.InvoiceNumber; _pURPurchaseHeader.InvoiceDate = pURPurchaseHeader.InvoiceDate; // _pURPurchaseHeader.SellerID = GlobalVariables.CurrentUser.UserID; _pURPurchaseHeader.PaymentTypeID = pURPurchaseHeader.PaymentTypeID; _pURPurchaseHeader.TotalPrice = pURPurchaseHeader.TotalPrice; _pURPurchaseHeader.PaidAmount = pURPurchaseHeader.PaidAmount; _pURPurchaseHeader.RemainingAmount = pURPurchaseHeader.RemainingAmount; _pURPurchaseHeader.LastDayToPay = pURPurchaseHeader.LastDayToPay; _pURPurchaseHeader.ChequeNumber = pURPurchaseHeader.ChequeNumber; _pURPurchaseHeader.TotalDiscountAmount = pURPurchaseHeader.TotalDiscountAmount; _pURPurchaseHeader.TotalDiscountRatio = pURPurchaseHeader.TotalDiscountRatio; _pURPurchaseHeader.IsClosed = false; _pURPurchaseHeader.IsVoid = false; _pURPurchaseHeader.IsPrinted = false; _pURPurchaseHeader.ServicePrice = pURPurchaseHeader.ServicePrice; _pURPurchaseHeader.TaxTypeID = pURPurchaseHeader.TaxTypeID; _pURPurchaseHeader.RefuseReasonID = null; _pURPurchaseHeader.CreatedBy = GlobalVariables.CurrentUser.UserID; _pURPurchaseHeader.CreateDate = DateTime.Now; _pURPurchaseHeader.UpdatedBy = null; _pURPurchaseHeader.updateDate = null; _pURPurchaseHeader.IsDeleted = false; _pURPurchaseHeader.DeletedBy = null; _pURPurchaseHeader.DeleteDate = null; POS.DataLayer.PURPurchaseLineCollection _pURPurchaseLineCollection = new DataLayer.PURPurchaseLineCollection(); foreach (PURPurchaseLine pURPurchaseLine in pURPurchaseLineCollection) { POS.DataLayer.PURPurchaseLine _pURPurchaseLine = new POS.DataLayer.PURPurchaseLine(); _pURPurchaseLine.ProductID = pURPurchaseLine.ProductID; _pURPurchaseLine.TotalQty = pURPurchaseLine.TotalQty; _pURPurchaseLine.BonusQty = pURPurchaseLine.BonusQty; _pURPurchaseLine.DiscountAmount = pURPurchaseLine.DiscountAmount; _pURPurchaseLine.DiscountRatio = pURPurchaseLine.DiscountRatio; _pURPurchaseLine.Unitprice = pURPurchaseLine.Unitprice; _pURPurchaseLine.BatchNumber = pURPurchaseLine.BatchNumber; _pURPurchaseLine.ExpiryDate = pURPurchaseLine.ExpiryDate; _pURPurchaseLine.BatchQty = pURPurchaseLine.BatchQty; _pURPurchaseLine.CreatedBy = GlobalVariables.CurrentUser.UserID; _pURPurchaseLine.CreatedDate = DateTime.Now; _pURPurchaseLine.UpdatedBy = null; _pURPurchaseLine.UpdateDate = null; _pURPurchaseLine.IsDeleted = false; _pURPurchaseLine.DeletedBy = null; _pURPurchaseLine.DeleteDate = null; _pURPurchaseLineCollection.Add(_pURPurchaseLine); } POS.DataLayer.PURPurchaseLine pURPurchaseLineObj = new DataLayer.PURPurchaseLine(); return pURPurchaseLineObj.SaveTransaction(_pURPurchaseHeader, _pURPurchaseLineCollection); }
public int SavePURPurchaseOrder(PURPurchaseHeader pURPurchaseHeader, PURPurchaseLineCollection pURPurchaseLineCollection) { POS.DataLayer.PURPurchaseHeader _pURPurchaseHeader = new POS.DataLayer.PURPurchaseHeader(); _pURPurchaseHeader.PurcaseHeaderID = pURPurchaseHeader.PurcaseHeaderID; _pURPurchaseHeader.PurchaseDate = DateTime.Now; _pURPurchaseHeader.SupplierID = pURPurchaseHeader.SupplierID; _pURPurchaseHeader.InventoryID = pURPurchaseHeader.InventoryID; _pURPurchaseHeader.InvoiceNumber = pURPurchaseHeader.InvoiceNumber; _pURPurchaseHeader.InvoiceDate = pURPurchaseHeader.InvoiceDate; // _pURPurchaseHeader.SellerID = GlobalVariables.CurrentUser.UserID; _pURPurchaseHeader.PaymentTypeID = pURPurchaseHeader.PaymentTypeID; _pURPurchaseHeader.TotalPrice = pURPurchaseHeader.TotalPrice; _pURPurchaseHeader.PaidAmount = pURPurchaseHeader.PaidAmount; _pURPurchaseHeader.RemainingAmount = pURPurchaseHeader.RemainingAmount; _pURPurchaseHeader.LastDayToPay = pURPurchaseHeader.LastDayToPay; _pURPurchaseHeader.ChequeNumber = pURPurchaseHeader.ChequeNumber; _pURPurchaseHeader.TotalDiscountAmount = pURPurchaseHeader.TotalDiscountAmount; _pURPurchaseHeader.TotalDiscountRatio = pURPurchaseHeader.TotalDiscountRatio; _pURPurchaseHeader.IsClosed = false; _pURPurchaseHeader.IsVoid = false; _pURPurchaseHeader.IsPrinted = false; _pURPurchaseHeader.ServicePrice = pURPurchaseHeader.ServicePrice; _pURPurchaseHeader.TaxTypeID = pURPurchaseHeader.TaxTypeID; _pURPurchaseHeader.RefuseReasonID = null; _pURPurchaseHeader.CreatedBy = GlobalVariables.CurrentUser.UserID; _pURPurchaseHeader.CreateDate = DateTime.Now; _pURPurchaseHeader.UpdatedBy = null; _pURPurchaseHeader.updateDate = null; _pURPurchaseHeader.IsDeleted = false; _pURPurchaseHeader.DeletedBy = null; _pURPurchaseHeader.DeleteDate = null; POS.DataLayer.PURPurchaseLineCollection _pURPurchaseLineCollection = new DataLayer.PURPurchaseLineCollection(); foreach (PURPurchaseLine pURPurchaseLine in pURPurchaseLineCollection) { POS.DataLayer.PURPurchaseLine _pURPurchaseLine = new POS.DataLayer.PURPurchaseLine(); _pURPurchaseLine.ProductID = pURPurchaseLine.ProductID; _pURPurchaseLine.TotalQty = pURPurchaseLine.TotalQty; _pURPurchaseLine.BonusQty = pURPurchaseLine.BonusQty; _pURPurchaseLine.DiscountAmount = pURPurchaseLine.DiscountAmount; _pURPurchaseLine.DiscountRatio = pURPurchaseLine.DiscountRatio; _pURPurchaseLine.Unitprice = pURPurchaseLine.Unitprice; _pURPurchaseLine.BatchNumber = pURPurchaseLine.BatchNumber; _pURPurchaseLine.ExpiryDate = pURPurchaseLine.ExpiryDate; _pURPurchaseLine.BatchQty = pURPurchaseLine.BatchQty; _pURPurchaseLine.CreatedBy = GlobalVariables.CurrentUser.UserID; _pURPurchaseLine.CreatedDate = DateTime.Now; _pURPurchaseLine.UpdatedBy = null; _pURPurchaseLine.UpdateDate = null; _pURPurchaseLine.IsDeleted = false; _pURPurchaseLine.DeletedBy = null; _pURPurchaseLine.DeleteDate = null; _pURPurchaseLineCollection.Add(_pURPurchaseLine); } POS.DataLayer.PURPurchaseLine pURPurchaseLineObj = new DataLayer.PURPurchaseLine(); return(pURPurchaseLineObj.SaveTransaction(_pURPurchaseHeader, _pURPurchaseLineCollection)); }
private PURPurchaseHeader CollectHeaderData() { PURPurchaseHeader _pURPurchaseHeader = new PURPurchaseHeader(); if (CurrentHeaderID != 0 && CurrentHeaderID != null) { _pURPurchaseHeader.PurcaseHeaderID = CurrentHeaderID; } _pURPurchaseHeader.SupplierID = Convert.ToInt32(cbx_Supplier.SelectedValue); _pURPurchaseHeader.InvoiceDate = dtb_Date.Value.Date; _pURPurchaseHeader.InvoiceNumber = txt_invoiceNumber.Text; _pURPurchaseHeader.PaidAmount = string.IsNullOrEmpty(num_Paied.Text) ? 0 : Convert.ToDecimal(num_Paied.Text); _pURPurchaseHeader.RemainingAmount = string.IsNullOrEmpty(num_Remaining.Text) ? 0 : Convert.ToDecimal(num_Remaining.Text); _pURPurchaseHeader.PaymentTypeID = Convert.ToInt32(cbx_PaymentType.SelectedValue); if ((int)cbx_PaymentType.SelectedValue == 2) { _pURPurchaseHeader.LastDayToPay = dtb_LastTimeToPay.Value.Date; _pURPurchaseHeader.ChequeNumber = null; //_pURPurchaseHeader.che } else if ((int)cbx_PaymentType.SelectedValue == 3) { _pURPurchaseHeader.LastDayToPay = null; _pURPurchaseHeader.ChequeNumber = Convert.ToDecimal(txt_chequeNumber.Text); } else { _pURPurchaseHeader.LastDayToPay = null; _pURPurchaseHeader.ChequeNumber = null; } _pURPurchaseHeader.ServicePrice = string.IsNullOrEmpty(num_OtherPayments.Text) ? 0 : Convert.ToDecimal(num_OtherPayments.Text); _pURPurchaseHeader.TaxTypeID = cbx_TaxType.SelectedIndex == -1 ? null : (int?)(cbx_TaxType.SelectedValue); decimal total = Convert.ToDecimal(txt_Total.Text); // decimal discountRatio = (Convert.ToDecimal(txt_DiscountRatio.Text.Trim(new char[] { '%' })) / 100); _pURPurchaseHeader.TotalDiscountRatio = Convert.ToDouble(txt_DiscountAmount.Text); _pURPurchaseHeader.TotalDiscountAmount = 0; _pURPurchaseHeader.TotalPrice = Convert.ToDecimal(txt_Total.Text); _pURPurchaseHeader.InventoryID = Convert.ToInt32(cbx_Inventory.SelectedValue); _pURPurchaseHeader.TotalPrice = total; return(_pURPurchaseHeader); }
private void LoadLines(int HeaderID) { try { PURPurchaseHeaderPrimaryKey headerKey = new PURPurchaseHeaderPrimaryKey(); headerKey.PurcaseHeaderID = HeaderID; PURPurchaseHeaderService headerService = new PURPurchaseHeaderService(); PURPurchaseHeader selectedHeader = headerService.SelectOne(headerKey); PURPurchaseLineWrapper LineService = new PURPurchaseLineWrapper(); PURPurchaseLineCollection selectedLines = LineService.SelectByHeaderID(HeaderID); LoadHeaderControls(selectedHeader); LoadGridLines(selectedLines); } catch (Exception ex) { MessageBox.Show("حدث خطأ برجاء تكرار العمليه مره اخرى واذا تكرر الخطا برجاءالاتصال بالشخص المصمم للبرنامج وارسال رسالة الخطا التى ستظهر بعد قليل له"); MessageBox.Show(ex.Message); } }
private void LoadHeaderControls(PURPurchaseHeader Header) { dtb_Date.Value = Header.InvoiceDate.Value; cbx_Inventory.SelectedValue = Header.InventoryID; cbx_Supplier.SelectedValue = Header.SupplierID; cbx_PaymentType.SelectedValue = Header.PaymentTypeID; txt_Total.Text = Header.TotalPrice.ToString(); txt_DiscountAmount.Text = Header.TotalDiscountAmount.ToString(); num_Paied.Text = Header.PaidAmount.ToString(); txt_invoiceNumber.Text = Header.InvoiceNumber; num_Remaining.Text = Header.RemainingAmount.ToString(); if (Header.PaymentTypeID == 2) { dtb_LastTimeToPay.Value = Header.LastDayToPay.Value; } else if (Header.PaymentTypeID == 3) { txt_chequeNumber.Text = Header.ChequeNumber.ToString(); } if (Header.TaxTypeID != null) { cbx_TaxType.SelectedValue = Header.TaxTypeID; } num_OtherPayments.Text = Header.ServicePrice.ToString(); if (Header.IsClosed == true) { pnl_headerData.Enabled = false; // pnl_footer.Enabled = false; grb_lineData.Enabled = false; btn_Save.Enabled = false; btn_ClosePrint.Enabled = false; btn_Print.Enabled = false; cbx_Supplier.Enabled = false; dtb_Date.Enabled = false; cbx_TaxType.Enabled = false; num_OtherPayments.Enabled = false; num_Paied.Enabled = false; } // txt_DiscountRatio.Text = Header.TotalDiscountRatio.ToString(); }
private PURPurchaseHeader CollectHeaderData() { PURPurchaseHeader _pURPurchaseHeader = new PURPurchaseHeader(); _pURPurchaseHeader.SupplierID = Convert.ToInt32(cbx_Supplier.SelectedValue); _pURPurchaseHeader.InvoiceDate = dtb_Date.Value.Date; _pURPurchaseHeader.LastDayToPay = dtb_LastTimeToPay.Value.Date; _pURPurchaseHeader.PaidAmount = string.IsNullOrEmpty(num_Paied.Text) ? 0 : Convert.ToDecimal(num_Paied.Text); _pURPurchaseHeader.RemainingAmount = string.IsNullOrEmpty(num_Remaining.Text) ? 0 : Convert.ToDecimal(num_Remaining.Text); _pURPurchaseHeader.PaymentTypeID = Convert.ToInt32(cbx_PaymentType.SelectedValue); _pURPurchaseHeader.ServicePrice = string.IsNullOrEmpty(num_OtherPayments.Text) ? 0 : Convert.ToDecimal(num_OtherPayments.Text); _pURPurchaseHeader.TaxTypeID = cbx_TaxType.SelectedIndex == -1 ? null : (int?)(cbx_TaxType.SelectedValue); decimal total = Convert.ToDecimal(txt_Total.Text); decimal discountRatio = (Convert.ToDecimal(txt_DiscountRatio.Text.Trim(new char[] { '%' })) / 100); _pURPurchaseHeader.TotalDiscountAmount = total * discountRatio; _pURPurchaseHeader.TotalDiscountRatio = (double)discountRatio; _pURPurchaseHeader.TotalPrice = Convert.ToDecimal(txt_Total.Text); _pURPurchaseHeader.InventoryID = Convert.ToInt32(cbx_Inventory.SelectedValue); return(_pURPurchaseHeader); }
public PURPurchaseHeaderCollection HeaderSearch(int InventoryID, DateTime FromDate, DateTime ToDate, string SupplierName, string InvoiceNumber) { PURPurchaseHeaderCollection PURPurcaseHeaderCollection = new PURPurchaseHeaderCollection(); foreach (POS.DataLayer.PURPurchaseHeader _pURPurchaseHeader in POS.DataLayer.PURPurchaseHeader.HeaderSearch(InventoryID, FromDate, ToDate, SupplierName, InvoiceNumber)) { PURPurchaseHeader _pURPurchaseHeaderWCF = new PURPurchaseHeader(); _pURPurchaseHeaderWCF.PurcaseHeaderID = _pURPurchaseHeader.PurcaseHeaderID; _pURPurchaseHeaderWCF.PurchaseDate = _pURPurchaseHeader.PurchaseDate; _pURPurchaseHeaderWCF.SupplierID = _pURPurchaseHeader.SupplierID; _pURPurchaseHeaderWCF.SupplierName = _pURPurchaseHeader.SupplierName; _pURPurchaseHeaderWCF.InvoiceNumber = _pURPurchaseHeader.InvoiceNumber; _pURPurchaseHeaderWCF.InvoiceDate = _pURPurchaseHeader.InvoiceDate; // _pURPurchaseHeaderWCF.SellerID = _pURPurchaseHeader.SellerID; _pURPurchaseHeaderWCF.PaymentTypeID = _pURPurchaseHeader.PaymentTypeID; _pURPurchaseHeaderWCF.TotalPrice = _pURPurchaseHeader.TotalPrice; _pURPurchaseHeaderWCF.PaidAmount = _pURPurchaseHeader.PaidAmount; _pURPurchaseHeaderWCF.RemainingAmount = _pURPurchaseHeader.RemainingAmount; _pURPurchaseHeaderWCF.LastDayToPay = _pURPurchaseHeader.LastDayToPay; _pURPurchaseHeaderWCF.TotalDiscountAmount = _pURPurchaseHeader.TotalDiscountAmount; _pURPurchaseHeaderWCF.TotalDiscountRatio = _pURPurchaseHeader.TotalDiscountRatio; _pURPurchaseHeaderWCF.IsClosed = _pURPurchaseHeader.IsClosed; _pURPurchaseHeaderWCF.IsVoid = _pURPurchaseHeader.IsVoid; _pURPurchaseHeaderWCF.IsPrinted = _pURPurchaseHeader.IsPrinted; _pURPurchaseHeaderWCF.ServicePrice = _pURPurchaseHeader.ServicePrice; _pURPurchaseHeaderWCF.TaxTypeID = _pURPurchaseHeader.TaxTypeID; _pURPurchaseHeaderWCF.RefuseReasonID = _pURPurchaseHeader.RefuseReasonID; _pURPurchaseHeaderWCF.CreatedBy = _pURPurchaseHeader.CreatedBy; _pURPurchaseHeaderWCF.CreateDate = _pURPurchaseHeader.CreateDate; _pURPurchaseHeaderWCF.UpdatedBy = _pURPurchaseHeader.UpdatedBy; _pURPurchaseHeaderWCF.updateDate = _pURPurchaseHeader.updateDate; _pURPurchaseHeaderWCF.IsDeleted = _pURPurchaseHeader.IsDeleted; _pURPurchaseHeaderWCF.DeletedBy = _pURPurchaseHeader.DeletedBy; _pURPurchaseHeaderWCF.DeleteDate = _pURPurchaseHeader.DeleteDate; PURPurcaseHeaderCollection.Add(_pURPurchaseHeaderWCF); } return(PURPurcaseHeaderCollection); }
public PURPurchaseHeaderCollection HeaderSearch(int InventoryID,DateTime FromDate,DateTime ToDate ,string SupplierName, string InvoiceNumber) { PURPurchaseHeaderCollection PURPurcaseHeaderCollection = new PURPurchaseHeaderCollection(); foreach (POS.DataLayer.PURPurchaseHeader _pURPurchaseHeader in POS.DataLayer.PURPurchaseHeader.HeaderSearch(InventoryID,FromDate, ToDate ,SupplierName, InvoiceNumber)) { PURPurchaseHeader _pURPurchaseHeaderWCF = new PURPurchaseHeader(); _pURPurchaseHeaderWCF.PurcaseHeaderID = _pURPurchaseHeader.PurcaseHeaderID; _pURPurchaseHeaderWCF.PurchaseDate = _pURPurchaseHeader.PurchaseDate; _pURPurchaseHeaderWCF.SupplierID = _pURPurchaseHeader.SupplierID; _pURPurchaseHeaderWCF .SupplierName = _pURPurchaseHeader.SupplierName; _pURPurchaseHeaderWCF.InvoiceNumber = _pURPurchaseHeader.InvoiceNumber; _pURPurchaseHeaderWCF.InvoiceDate = _pURPurchaseHeader.InvoiceDate; // _pURPurchaseHeaderWCF.SellerID = _pURPurchaseHeader.SellerID; _pURPurchaseHeaderWCF.PaymentTypeID = _pURPurchaseHeader.PaymentTypeID; _pURPurchaseHeaderWCF.TotalPrice = _pURPurchaseHeader.TotalPrice; _pURPurchaseHeaderWCF.PaidAmount = _pURPurchaseHeader.PaidAmount; _pURPurchaseHeaderWCF.RemainingAmount = _pURPurchaseHeader.RemainingAmount; _pURPurchaseHeaderWCF.LastDayToPay = _pURPurchaseHeader.LastDayToPay; _pURPurchaseHeaderWCF.TotalDiscountAmount = _pURPurchaseHeader.TotalDiscountAmount; _pURPurchaseHeaderWCF.TotalDiscountRatio = _pURPurchaseHeader.TotalDiscountRatio; _pURPurchaseHeaderWCF.IsClosed = _pURPurchaseHeader.IsClosed; _pURPurchaseHeaderWCF.IsVoid = _pURPurchaseHeader.IsVoid; _pURPurchaseHeaderWCF.IsPrinted = _pURPurchaseHeader.IsPrinted; _pURPurchaseHeaderWCF.ServicePrice = _pURPurchaseHeader.ServicePrice; _pURPurchaseHeaderWCF.TaxTypeID = _pURPurchaseHeader.TaxTypeID; _pURPurchaseHeaderWCF.RefuseReasonID = _pURPurchaseHeader.RefuseReasonID; _pURPurchaseHeaderWCF.CreatedBy = _pURPurchaseHeader.CreatedBy; _pURPurchaseHeaderWCF.CreateDate = _pURPurchaseHeader.CreateDate; _pURPurchaseHeaderWCF.UpdatedBy = _pURPurchaseHeader.UpdatedBy; _pURPurchaseHeaderWCF.updateDate = _pURPurchaseHeader.updateDate; _pURPurchaseHeaderWCF.IsDeleted = _pURPurchaseHeader.IsDeleted; _pURPurchaseHeaderWCF.DeletedBy = _pURPurchaseHeader.DeletedBy; _pURPurchaseHeaderWCF.DeleteDate = _pURPurchaseHeader.DeleteDate; PURPurcaseHeaderCollection.Add(_pURPurchaseHeaderWCF); } return PURPurcaseHeaderCollection; }
/// <summary> /// This method will return an object representing the record matching the primary key information specified. /// </summary> /// /// <param name="pk" type="PURPurchaseHeaderPrimaryKey">Primary Key information based on which data is to be fetched.</param> /// /// <returns>object of class PURPurchaseHeader</returns> public PURPurchaseHeader SelectOne(PURPurchaseHeaderPrimaryKey pk) { _pURPurchaseHeaderWCF = new PURPurchaseHeader(); _pURPurchaseHeader = POS.DataLayer.PURPurchaseHeaderBase.SelectOne(new POS.DataLayer.PURPurchaseHeaderPrimaryKey(pk.PurcaseHeaderID)); _pURPurchaseHeaderWCF.PurcaseHeaderID = _pURPurchaseHeader.PurcaseHeaderID; _pURPurchaseHeaderWCF.PurchaseDate = _pURPurchaseHeader.PurchaseDate; _pURPurchaseHeaderWCF.PaymentTypeID = _pURPurchaseHeader.PaymentTypeID; _pURPurchaseHeaderWCF.SupplierID = _pURPurchaseHeader.SupplierID; _pURPurchaseHeaderWCF.InvoiceNumber = _pURPurchaseHeader.InvoiceNumber; _pURPurchaseHeaderWCF.CreateDate = _pURPurchaseHeader.CreateDate; _pURPurchaseHeaderWCF.CreatedBy = _pURPurchaseHeader.CreatedBy; _pURPurchaseHeaderWCF.updateDate = _pURPurchaseHeader.updateDate; _pURPurchaseHeaderWCF.UpdatedBy = _pURPurchaseHeader.UpdatedBy; _pURPurchaseHeaderWCF.IsDeleted = _pURPurchaseHeader.IsDeleted; _pURPurchaseHeaderWCF.DeleteDate = _pURPurchaseHeader.DeleteDate; _pURPurchaseHeaderWCF.TotalPrice = _pURPurchaseHeader.TotalPrice; _pURPurchaseHeaderWCF.ServicePrice = _pURPurchaseHeader.ServicePrice; _pURPurchaseHeaderWCF.PaidAmount = _pURPurchaseHeader.PaidAmount; _pURPurchaseHeaderWCF.IsClosed = _pURPurchaseHeader.IsClosed; _pURPurchaseHeaderWCF.IsVoid = _pURPurchaseHeader.IsVoid; _pURPurchaseHeaderWCF.IsPrinted = _pURPurchaseHeader.IsPrinted; _pURPurchaseHeaderWCF.RefuseReasonID = _pURPurchaseHeader.RefuseReasonID; _pURPurchaseHeaderWCF.TotalDiscountAmount = _pURPurchaseHeader.TotalDiscountAmount; _pURPurchaseHeaderWCF.TotalDiscountRatio = _pURPurchaseHeader.TotalDiscountRatio; _pURPurchaseHeaderWCF.TaxTypeID = _pURPurchaseHeader.TaxTypeID; _pURPurchaseHeaderWCF.RemainingAmount = _pURPurchaseHeader.RemainingAmount; _pURPurchaseHeaderWCF.LastDayToPay = _pURPurchaseHeader.LastDayToPay; _pURPurchaseHeaderWCF.DeletedBy = _pURPurchaseHeader.DeletedBy; _pURPurchaseHeaderWCF.Notes = _pURPurchaseHeader.Notes; _pURPurchaseHeaderWCF.InventoryID = _pURPurchaseHeader.InventoryID; _pURPurchaseHeaderWCF.InvoiceDate = _pURPurchaseHeader.InvoiceDate; _pURPurchaseHeaderWCF.ChequeNumber = _pURPurchaseHeader.ChequeNumber; return _pURPurchaseHeaderWCF; }
public bool SaveAccountUpdates(BDSupplierAccount _supplierAccount) { #region select area PURPurchaseHeaderPrimaryKey purchaseHeaderpk = new PURPurchaseHeaderPrimaryKey(); purchaseHeaderpk.PurcaseHeaderID = _supplierAccount.PurcaseInvoiceID; PURPurchaseHeader _pURPurchaseHeader = _purchaseHeaderService.SelectOne(purchaseHeaderpk); BDSupplierAccountPrimaryKey supplierAccountpk = new BDSupplierAccountPrimaryKey(); supplierAccountpk.SupplierAccountId = _supplierAccount.SupplierAccountId; BDSupplierAccount supplierAccount = SelectOne(supplierAccountpk); #endregion #region supplier account area POS.DataLayer.BDSupplierAccount supplierAccountDal = new POS.DataLayer.BDSupplierAccount(); supplierAccountDal.CreateDate = supplierAccount.CreateDate; supplierAccountDal.CreatedBy = supplierAccount.CreatedBy; supplierAccountDal.DeleteDate = supplierAccount.DeleteDate; supplierAccountDal.DeletedBy = supplierAccount.DeletedBy; supplierAccountDal.InvoiceNumber = supplierAccount.InvoiceNumber; supplierAccountDal.IsDeleted = supplierAccount.IsDeleted; supplierAccountDal.IsVoid = supplierAccount.IsVoid; supplierAccountDal.PurcaseInvoiceID = supplierAccount.PurcaseInvoiceID; supplierAccountDal.PurchaseDate = supplierAccount.PurchaseDate; supplierAccountDal.SupplierAccountId = supplierAccount.SupplierAccountId; supplierAccountDal.SupplierID = supplierAccount.SupplierID; supplierAccountDal.updateDate = supplierAccount.updateDate; supplierAccountDal.UpdatedBy = supplierAccount.UpdatedBy; ////////// Updated area supplierAccountDal.PaidAmount = _supplierAccount.PaidAmount; supplierAccountDal.RemainingAmount = _supplierAccount.RemainingAmount; supplierAccountDal.TotalPrice = _supplierAccount.TotalPrice; #endregion #region purchase area POS.DataLayer.PURPurchaseHeader _purchaseHeaderDAL = new POS.DataLayer.PURPurchaseHeader(); _purchaseHeaderDAL.PurcaseHeaderID = _pURPurchaseHeader.PurcaseHeaderID; _purchaseHeaderDAL.PurchaseDate = _pURPurchaseHeader.PurchaseDate; _purchaseHeaderDAL.SupplierID = _pURPurchaseHeader.SupplierID; _purchaseHeaderDAL.SupplierName = _pURPurchaseHeader.SupplierName; _purchaseHeaderDAL.InvoiceNumber = _pURPurchaseHeader.InvoiceNumber; _purchaseHeaderDAL.InvoiceDate = _pURPurchaseHeader.InvoiceDate; _purchaseHeaderDAL.PaymentTypeID = _pURPurchaseHeader.PaymentTypeID; _purchaseHeaderDAL.LastDayToPay = _pURPurchaseHeader.LastDayToPay; _purchaseHeaderDAL.TotalDiscountAmount = _pURPurchaseHeader.TotalDiscountAmount; _purchaseHeaderDAL.TotalDiscountRatio = _pURPurchaseHeader.TotalDiscountRatio; _purchaseHeaderDAL.IsClosed = _pURPurchaseHeader.IsClosed; _purchaseHeaderDAL.IsVoid = _pURPurchaseHeader.IsVoid; _purchaseHeaderDAL.IsPrinted = _pURPurchaseHeader.IsPrinted; _purchaseHeaderDAL.ServicePrice = _pURPurchaseHeader.ServicePrice; _purchaseHeaderDAL.TaxTypeID = _pURPurchaseHeader.TaxTypeID; _purchaseHeaderDAL.RefuseReasonID = _pURPurchaseHeader.RefuseReasonID; _purchaseHeaderDAL.CreatedBy = _pURPurchaseHeader.CreatedBy; _purchaseHeaderDAL.CreateDate = _pURPurchaseHeader.CreateDate; _purchaseHeaderDAL.UpdatedBy = _pURPurchaseHeader.UpdatedBy; _purchaseHeaderDAL.updateDate = _pURPurchaseHeader.updateDate; _purchaseHeaderDAL.IsDeleted = _pURPurchaseHeader.IsDeleted; _purchaseHeaderDAL.DeletedBy = _pURPurchaseHeader.DeletedBy; _purchaseHeaderDAL.DeleteDate = _pURPurchaseHeader.DeleteDate; ///////////// updated area _purchaseHeaderDAL.TotalPrice = _supplierAccount.TotalPrice; _purchaseHeaderDAL.PaidAmount = _supplierAccount.PaidAmount; _purchaseHeaderDAL.RemainingAmount = _supplierAccount.RemainingAmount; #endregion POS.DataLayer.BDSupplierAccount supplierAccountObj = new DataLayer.BDSupplierAccount(); return(supplierAccountObj.SaveAccountUpdates(_purchaseHeaderDAL, supplierAccountDal)); }
/// <summary> /// This method will return a list of objects representing all records in the table. /// </summary> /// /// <returns>list of objects of class PURPurchaseHeader in the form of object of PURPurchaseHeaderCollection </returns> public PURPurchaseHeaderCollection SelectAll() { PURPurchaseHeaderCollection pURPurchaseHeaderCollection = new PURPurchaseHeaderCollection(); foreach (POS.DataLayer.PURPurchaseHeader _pURPurchaseHeader in POS.DataLayer.PURPurchaseHeaderBase.SelectAll()) { _pURPurchaseHeaderWCF = new PURPurchaseHeader(); _pURPurchaseHeaderWCF.PurcaseHeaderID = _pURPurchaseHeader.PurcaseHeaderID; _pURPurchaseHeaderWCF.PurchaseDate = _pURPurchaseHeader.PurchaseDate; _pURPurchaseHeaderWCF.PaymentTypeID = _pURPurchaseHeader.PaymentTypeID; _pURPurchaseHeaderWCF.SupplierID = _pURPurchaseHeader.SupplierID; _pURPurchaseHeaderWCF.InvoiceNumber = _pURPurchaseHeader.InvoiceNumber; _pURPurchaseHeaderWCF.CreateDate = _pURPurchaseHeader.CreateDate; _pURPurchaseHeaderWCF.CreatedBy = _pURPurchaseHeader.CreatedBy; _pURPurchaseHeaderWCF.updateDate = _pURPurchaseHeader.updateDate; _pURPurchaseHeaderWCF.UpdatedBy = _pURPurchaseHeader.UpdatedBy; _pURPurchaseHeaderWCF.IsDeleted = _pURPurchaseHeader.IsDeleted; _pURPurchaseHeaderWCF.DeleteDate = _pURPurchaseHeader.DeleteDate; _pURPurchaseHeaderWCF.TotalPrice = _pURPurchaseHeader.TotalPrice; _pURPurchaseHeaderWCF.ServicePrice = _pURPurchaseHeader.ServicePrice; _pURPurchaseHeaderWCF.PaidAmount = _pURPurchaseHeader.PaidAmount; _pURPurchaseHeaderWCF.IsClosed = _pURPurchaseHeader.IsClosed; _pURPurchaseHeaderWCF.IsVoid = _pURPurchaseHeader.IsVoid; _pURPurchaseHeaderWCF.IsPrinted = _pURPurchaseHeader.IsPrinted; _pURPurchaseHeaderWCF.RefuseReasonID = _pURPurchaseHeader.RefuseReasonID; _pURPurchaseHeaderWCF.TotalDiscountAmount = _pURPurchaseHeader.TotalDiscountAmount; _pURPurchaseHeaderWCF.TotalDiscountRatio = _pURPurchaseHeader.TotalDiscountRatio; _pURPurchaseHeaderWCF.TaxTypeID = _pURPurchaseHeader.TaxTypeID; _pURPurchaseHeaderWCF.RemainingAmount = _pURPurchaseHeader.RemainingAmount; _pURPurchaseHeaderWCF.LastDayToPay = _pURPurchaseHeader.LastDayToPay; _pURPurchaseHeaderWCF.DeletedBy = _pURPurchaseHeader.DeletedBy; _pURPurchaseHeaderWCF.Notes = _pURPurchaseHeader.Notes; _pURPurchaseHeaderWCF.InventoryID = _pURPurchaseHeader.InventoryID; _pURPurchaseHeaderWCF.InvoiceDate = _pURPurchaseHeader.InvoiceDate; _pURPurchaseHeaderWCF.ChequeNumber = _pURPurchaseHeader.ChequeNumber; pURPurchaseHeaderCollection.Add(_pURPurchaseHeaderWCF); } return pURPurchaseHeaderCollection; }
/// <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 PURPurchaseHeader</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 PURPurchaseHeader in the form of an object of class PURPurchaseHeaderCollection</returns> public PURPurchaseHeaderCollection SelectByFieldPaged(string field, object fieldValue, object fieldValue2, TypeOperation typeOperation, int pageSize, int skipPages, string orderByStatement) { PURPurchaseHeaderCollection pURPurchaseHeaderCollection = new PURPurchaseHeaderCollection(); foreach (POS.DataLayer.PURPurchaseHeader _pURPurchaseHeader in POS.DataLayer.PURPurchaseHeaderBase.SelectByFieldPaged(field, fieldValue, fieldValue2, typeOperation, pageSize, skipPages, orderByStatement)) { _pURPurchaseHeaderWCF = new PURPurchaseHeader(); _pURPurchaseHeaderWCF.PurcaseHeaderID = _pURPurchaseHeader.PurcaseHeaderID; _pURPurchaseHeaderWCF.PurchaseDate = _pURPurchaseHeader.PurchaseDate; _pURPurchaseHeaderWCF.PaymentTypeID = _pURPurchaseHeader.PaymentTypeID; _pURPurchaseHeaderWCF.SupplierID = _pURPurchaseHeader.SupplierID; _pURPurchaseHeaderWCF.InvoiceNumber = _pURPurchaseHeader.InvoiceNumber; _pURPurchaseHeaderWCF.CreateDate = _pURPurchaseHeader.CreateDate; _pURPurchaseHeaderWCF.CreatedBy = _pURPurchaseHeader.CreatedBy; _pURPurchaseHeaderWCF.updateDate = _pURPurchaseHeader.updateDate; _pURPurchaseHeaderWCF.UpdatedBy = _pURPurchaseHeader.UpdatedBy; _pURPurchaseHeaderWCF.IsDeleted = _pURPurchaseHeader.IsDeleted; _pURPurchaseHeaderWCF.DeleteDate = _pURPurchaseHeader.DeleteDate; _pURPurchaseHeaderWCF.TotalPrice = _pURPurchaseHeader.TotalPrice; _pURPurchaseHeaderWCF.ServicePrice = _pURPurchaseHeader.ServicePrice; _pURPurchaseHeaderWCF.PaidAmount = _pURPurchaseHeader.PaidAmount; _pURPurchaseHeaderWCF.IsClosed = _pURPurchaseHeader.IsClosed; _pURPurchaseHeaderWCF.IsVoid = _pURPurchaseHeader.IsVoid; _pURPurchaseHeaderWCF.IsPrinted = _pURPurchaseHeader.IsPrinted; _pURPurchaseHeaderWCF.RefuseReasonID = _pURPurchaseHeader.RefuseReasonID; _pURPurchaseHeaderWCF.TotalDiscountAmount = _pURPurchaseHeader.TotalDiscountAmount; _pURPurchaseHeaderWCF.TotalDiscountRatio = _pURPurchaseHeader.TotalDiscountRatio; _pURPurchaseHeaderWCF.TaxTypeID = _pURPurchaseHeader.TaxTypeID; _pURPurchaseHeaderWCF.RemainingAmount = _pURPurchaseHeader.RemainingAmount; _pURPurchaseHeaderWCF.LastDayToPay = _pURPurchaseHeader.LastDayToPay; _pURPurchaseHeaderWCF.DeletedBy = _pURPurchaseHeader.DeletedBy; _pURPurchaseHeaderWCF.Notes = _pURPurchaseHeader.Notes; _pURPurchaseHeaderWCF.InventoryID = _pURPurchaseHeader.InventoryID; _pURPurchaseHeaderWCF.InvoiceDate = _pURPurchaseHeader.InvoiceDate; _pURPurchaseHeaderWCF.ChequeNumber = _pURPurchaseHeader.ChequeNumber; pURPurchaseHeaderCollection.Add(_pURPurchaseHeaderWCF); } return pURPurchaseHeaderCollection; }
/// <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="BDSupplierPrimaryKey">Primary Key information based on which data is to be fetched.</param> /// <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>object of class PURPurchaseHeaderCollection</returns> public PURPurchaseHeaderCollection SelectAllByForeignKeySupplierIDPaged(BDSupplierPrimaryKey pk, int pageSize, int skipPages, string orderByStatement) { PURPurchaseHeaderCollection pURPurchaseHeaderCollection=new PURPurchaseHeaderCollection(); foreach (POS.DataLayer.PURPurchaseHeader _pURPurchaseHeader in POS.DataLayer.PURPurchaseHeaderBase.SelectAllByForeignKeySupplierIDPaged(new POS.DataLayer.BDSupplierPrimaryKey(pk.SupplierID), pageSize, skipPages, orderByStatement)) { _pURPurchaseHeaderWCF = new PURPurchaseHeader(); _pURPurchaseHeaderWCF.PurcaseHeaderID = _pURPurchaseHeader.PurcaseHeaderID; _pURPurchaseHeaderWCF.PurchaseDate = _pURPurchaseHeader.PurchaseDate; _pURPurchaseHeaderWCF.PaymentTypeID = _pURPurchaseHeader.PaymentTypeID; _pURPurchaseHeaderWCF.SupplierID = _pURPurchaseHeader.SupplierID; _pURPurchaseHeaderWCF.InvoiceNumber = _pURPurchaseHeader.InvoiceNumber; _pURPurchaseHeaderWCF.CreateDate = _pURPurchaseHeader.CreateDate; _pURPurchaseHeaderWCF.CreatedBy = _pURPurchaseHeader.CreatedBy; _pURPurchaseHeaderWCF.updateDate = _pURPurchaseHeader.updateDate; _pURPurchaseHeaderWCF.UpdatedBy = _pURPurchaseHeader.UpdatedBy; _pURPurchaseHeaderWCF.IsDeleted = _pURPurchaseHeader.IsDeleted; _pURPurchaseHeaderWCF.DeleteDate = _pURPurchaseHeader.DeleteDate; _pURPurchaseHeaderWCF.TotalPrice = _pURPurchaseHeader.TotalPrice; _pURPurchaseHeaderWCF.ServicePrice = _pURPurchaseHeader.ServicePrice; _pURPurchaseHeaderWCF.PaidAmount = _pURPurchaseHeader.PaidAmount; _pURPurchaseHeaderWCF.IsClosed = _pURPurchaseHeader.IsClosed; _pURPurchaseHeaderWCF.IsVoid = _pURPurchaseHeader.IsVoid; _pURPurchaseHeaderWCF.IsPrinted = _pURPurchaseHeader.IsPrinted; _pURPurchaseHeaderWCF.RefuseReasonID = _pURPurchaseHeader.RefuseReasonID; _pURPurchaseHeaderWCF.TotalDiscountAmount = _pURPurchaseHeader.TotalDiscountAmount; _pURPurchaseHeaderWCF.TotalDiscountRatio = _pURPurchaseHeader.TotalDiscountRatio; _pURPurchaseHeaderWCF.TaxTypeID = _pURPurchaseHeader.TaxTypeID; _pURPurchaseHeaderWCF.RemainingAmount = _pURPurchaseHeader.RemainingAmount; _pURPurchaseHeaderWCF.LastDayToPay = _pURPurchaseHeader.LastDayToPay; _pURPurchaseHeaderWCF.DeletedBy = _pURPurchaseHeader.DeletedBy; _pURPurchaseHeaderWCF.Notes = _pURPurchaseHeader.Notes; _pURPurchaseHeaderWCF.InventoryID = _pURPurchaseHeader.InventoryID; _pURPurchaseHeaderWCF.InvoiceDate = _pURPurchaseHeader.InvoiceDate; _pURPurchaseHeaderWCF.ChequeNumber = _pURPurchaseHeader.ChequeNumber; pURPurchaseHeaderCollection.Add(_pURPurchaseHeaderWCF); } return pURPurchaseHeaderCollection; }
/// <summary> /// This method will insert one new row into the database using the property Information /// </summary> /// /// <param name="pURPurchaseHeader" type="PURPurchaseHeader">This PURPurchaseHeader will be inserted in the database.</param> /// /// <returns>True if succeeded</returns> public bool Insert(PURPurchaseHeader pURPurchaseHeader) { _pURPurchaseHeader = new POS.DataLayer.PURPurchaseHeader(); _pURPurchaseHeader.PurcaseHeaderID=pURPurchaseHeader.PurcaseHeaderID; _pURPurchaseHeader.PurchaseDate=pURPurchaseHeader.PurchaseDate; _pURPurchaseHeader.PaymentTypeID=pURPurchaseHeader.PaymentTypeID; _pURPurchaseHeader.SupplierID=pURPurchaseHeader.SupplierID; _pURPurchaseHeader.InvoiceNumber=pURPurchaseHeader.InvoiceNumber; _pURPurchaseHeader.CreateDate=pURPurchaseHeader.CreateDate; _pURPurchaseHeader.CreatedBy=pURPurchaseHeader.CreatedBy; _pURPurchaseHeader.updateDate=pURPurchaseHeader.updateDate; _pURPurchaseHeader.UpdatedBy=pURPurchaseHeader.UpdatedBy; _pURPurchaseHeader.IsDeleted=pURPurchaseHeader.IsDeleted; _pURPurchaseHeader.DeleteDate=pURPurchaseHeader.DeleteDate; _pURPurchaseHeader.TotalPrice=pURPurchaseHeader.TotalPrice; _pURPurchaseHeader.ServicePrice=pURPurchaseHeader.ServicePrice; _pURPurchaseHeader.PaidAmount=pURPurchaseHeader.PaidAmount; _pURPurchaseHeader.IsClosed=pURPurchaseHeader.IsClosed; _pURPurchaseHeader.IsVoid=pURPurchaseHeader.IsVoid; _pURPurchaseHeader.IsPrinted=pURPurchaseHeader.IsPrinted; _pURPurchaseHeader.RefuseReasonID=pURPurchaseHeader.RefuseReasonID; _pURPurchaseHeader.TotalDiscountAmount=pURPurchaseHeader.TotalDiscountAmount; _pURPurchaseHeader.TotalDiscountRatio=pURPurchaseHeader.TotalDiscountRatio; _pURPurchaseHeader.TaxTypeID=pURPurchaseHeader.TaxTypeID; _pURPurchaseHeader.RemainingAmount=pURPurchaseHeader.RemainingAmount; _pURPurchaseHeader.LastDayToPay=pURPurchaseHeader.LastDayToPay; _pURPurchaseHeader.DeletedBy=pURPurchaseHeader.DeletedBy; _pURPurchaseHeader.Notes=pURPurchaseHeader.Notes; _pURPurchaseHeader.InventoryID=pURPurchaseHeader.InventoryID; _pURPurchaseHeader.InvoiceDate=pURPurchaseHeader.InvoiceDate; _pURPurchaseHeader.ChequeNumber=pURPurchaseHeader.ChequeNumber; return _pURPurchaseHeader.Insert(); }