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)); }
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)); }
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); }