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