/// <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; return(_pURPurchaseHeaderWCF); }
/// <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="PURPurchaseHeaderPrimaryKey">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 PURPurchaseLineCollection</returns> public PURPurchaseLineCollection SelectAllByForeignKeyPurchaseHeaderIDPaged(PURPurchaseHeaderPrimaryKey pk, int pageSize, int skipPages, string orderByStatement) { PURPurchaseLineCollection pURPurchaseLineCollection = new PURPurchaseLineCollection(); foreach (POS.DataLayer.PURPurchaseLine _pURPurchaseLine in POS.DataLayer.PURPurchaseLineBase.SelectAllByForeignKeyPurchaseHeaderIDPaged(new POS.DataLayer.PURPurchaseHeaderPrimaryKey(pk.PurcaseHeaderID), pageSize, skipPages, orderByStatement)) { _pURPurchaseLineWCF = new PURPurchaseLine(); _pURPurchaseLineWCF.PurchaseLineID = _pURPurchaseLine.PurchaseLineID; _pURPurchaseLineWCF.PurchaseHeaderID = _pURPurchaseLine.PurchaseHeaderID; _pURPurchaseLineWCF.ProductID = _pURPurchaseLine.ProductID; _pURPurchaseLineWCF.TotalQty = _pURPurchaseLine.TotalQty; _pURPurchaseLineWCF.BonusQty = _pURPurchaseLine.BonusQty; _pURPurchaseLineWCF.DiscountRatio = _pURPurchaseLine.DiscountRatio; _pURPurchaseLineWCF.DiscountAmount = _pURPurchaseLine.DiscountAmount; _pURPurchaseLineWCF.Unitprice = _pURPurchaseLine.Unitprice; _pURPurchaseLineWCF.CreatedDate = _pURPurchaseLine.CreatedDate; _pURPurchaseLineWCF.CreatedBy = _pURPurchaseLine.CreatedBy; _pURPurchaseLineWCF.UpdateDate = _pURPurchaseLine.UpdateDate; _pURPurchaseLineWCF.UpdatedBy = _pURPurchaseLine.UpdatedBy; _pURPurchaseLineWCF.IsDeleted = _pURPurchaseLine.IsDeleted; _pURPurchaseLineWCF.DeleteDate = _pURPurchaseLine.DeleteDate; _pURPurchaseLineWCF.DeletedBy = _pURPurchaseLine.DeletedBy; pURPurchaseLineCollection.Add(_pURPurchaseLineWCF); } return(pURPurchaseLineCollection); }
/// <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="PURPurchaseHeaderPrimaryKey">Primary Key information based on which data is to be fetched.</param> /// /// <returns>object of class BDSupplierAccountCollection</returns> public BDSupplierAccountCollection SelectAllByForeignKeyPurcaseInvoiceID(PURPurchaseHeaderPrimaryKey pk) { BDSupplierAccountCollection bDSupplierAccountCollection = new BDSupplierAccountCollection(); foreach (POS.DataLayer.BDSupplierAccount _bDSupplierAccount in POS.DataLayer.BDSupplierAccountBase.SelectAllByForeignKeyPurcaseInvoiceID(new POS.DataLayer.PURPurchaseHeaderPrimaryKey(pk.PurcaseHeaderID))) { _bDSupplierAccountWCF = new BDSupplierAccount(); _bDSupplierAccountWCF.SupplierAccountId = _bDSupplierAccount.SupplierAccountId; _bDSupplierAccountWCF.PurcaseInvoiceID = _bDSupplierAccount.PurcaseInvoiceID; _bDSupplierAccountWCF.PurchaseDate = _bDSupplierAccount.PurchaseDate; _bDSupplierAccountWCF.SupplierID = _bDSupplierAccount.SupplierID; _bDSupplierAccountWCF.InvoiceNumber = _bDSupplierAccount.InvoiceNumber; _bDSupplierAccountWCF.TotalPrice = _bDSupplierAccount.TotalPrice; _bDSupplierAccountWCF.PaidAmount = _bDSupplierAccount.PaidAmount; _bDSupplierAccountWCF.IsVoid = _bDSupplierAccount.IsVoid; _bDSupplierAccountWCF.RemainingAmount = _bDSupplierAccount.RemainingAmount; _bDSupplierAccountWCF.CreateDate = _bDSupplierAccount.CreateDate; _bDSupplierAccountWCF.CreatedBy = _bDSupplierAccount.CreatedBy; _bDSupplierAccountWCF.updateDate = _bDSupplierAccount.updateDate; _bDSupplierAccountWCF.UpdatedBy = _bDSupplierAccount.UpdatedBy; _bDSupplierAccountWCF.IsDeleted = _bDSupplierAccount.IsDeleted; _bDSupplierAccountWCF.DeleteDate = _bDSupplierAccount.DeleteDate; _bDSupplierAccountWCF.DeletedBy = _bDSupplierAccount.DeletedBy; _bDSupplierAccountWCF.InvoiceType = _bDSupplierAccount.InvoiceType; bDSupplierAccountCollection.Add(_bDSupplierAccountWCF); } return(bDSupplierAccountCollection); }
///<summary> ///This method will Delete the object from the database ///</summary> ///<param name="pk" type="PURPurchaseHeaderPrimaryKey">Primary Key information based on which data is to be fetched.</param> /// <returns>True if succeeded</returns> public bool Delete(PURPurchaseHeaderPrimaryKey pk) { return(POS.DataLayer.PURPurchaseHeaderBase.Delete(new POS.DataLayer.PURPurchaseHeaderPrimaryKey(pk.PurcaseHeaderID))); }
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); } }
/// <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="PURPurchaseHeaderPrimaryKey">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 PURPurchaseReturnHeaderCollection</returns> public PURPurchaseReturnHeaderCollection SelectAllByForeignKeyOriginalHeaderIDPaged(PURPurchaseHeaderPrimaryKey pk, int pageSize, int skipPages, string orderByStatement) { PURPurchaseReturnHeaderCollection pURPurchaseReturnHeaderCollection = new PURPurchaseReturnHeaderCollection(); foreach (POS.DataLayer.PURPurchaseReturnHeader _pURPurchaseReturnHeader in POS.DataLayer.PURPurchaseReturnHeaderBase.SelectAllByForeignKeyOriginalHeaderIDPaged(new POS.DataLayer.PURPurchaseHeaderPrimaryKey(pk.PurcaseHeaderID), pageSize, skipPages, orderByStatement)) { _pURPurchaseReturnHeaderWCF = new PURPurchaseReturnHeader(); _pURPurchaseReturnHeaderWCF.PurchaseReturnID = _pURPurchaseReturnHeader.PurchaseReturnID; _pURPurchaseReturnHeaderWCF.ReturnDate = _pURPurchaseReturnHeader.ReturnDate; _pURPurchaseReturnHeaderWCF.OriginalHeaderID = _pURPurchaseReturnHeader.OriginalHeaderID; _pURPurchaseReturnHeaderWCF.CreatedBy = _pURPurchaseReturnHeader.CreatedBy; _pURPurchaseReturnHeaderWCF.CreateDate = _pURPurchaseReturnHeader.CreateDate; _pURPurchaseReturnHeaderWCF.UpdatedBy = _pURPurchaseReturnHeader.UpdatedBy; _pURPurchaseReturnHeaderWCF.UpdateDate = _pURPurchaseReturnHeader.UpdateDate; _pURPurchaseReturnHeaderWCF.IsDeleted = _pURPurchaseReturnHeader.IsDeleted; _pURPurchaseReturnHeaderWCF.DeletedBy = _pURPurchaseReturnHeader.DeletedBy; _pURPurchaseReturnHeaderWCF.DeleteDate = _pURPurchaseReturnHeader.DeleteDate; pURPurchaseReturnHeaderCollection.Add(_pURPurchaseReturnHeaderWCF); } return(pURPurchaseReturnHeaderCollection); }
/// <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="PURPurchaseHeaderPrimaryKey">Primary Key information based on which data is to be fetched.</param> /// /// <returns>object of class PURPurchaseReturnHeaderCollection</returns> public PURPurchaseReturnHeaderCollection SelectAllByForeignKeyOriginalHeaderID(PURPurchaseHeaderPrimaryKey pk) { PURPurchaseReturnHeaderCollection pURPurchaseReturnHeaderCollection = new PURPurchaseReturnHeaderCollection(); foreach (POS.DataLayer.PURPurchaseReturnHeader _pURPurchaseReturnHeader in POS.DataLayer.PURPurchaseReturnHeaderBase.SelectAllByForeignKeyOriginalHeaderID(new POS.DataLayer.PURPurchaseHeaderPrimaryKey(pk.PurcaseHeaderID))) { _pURPurchaseReturnHeaderWCF = new PURPurchaseReturnHeader(); _pURPurchaseReturnHeaderWCF.PurchaseReturnID = _pURPurchaseReturnHeader.PurchaseReturnID; _pURPurchaseReturnHeaderWCF.ReturnDate = _pURPurchaseReturnHeader.ReturnDate; _pURPurchaseReturnHeaderWCF.OriginalHeaderID = _pURPurchaseReturnHeader.OriginalHeaderID; _pURPurchaseReturnHeaderWCF.CreatedBy = _pURPurchaseReturnHeader.CreatedBy; _pURPurchaseReturnHeaderWCF.CreateDate = _pURPurchaseReturnHeader.CreateDate; _pURPurchaseReturnHeaderWCF.UpdatedBy = _pURPurchaseReturnHeader.UpdatedBy; _pURPurchaseReturnHeaderWCF.UpdateDate = _pURPurchaseReturnHeader.UpdateDate; _pURPurchaseReturnHeaderWCF.IsDeleted = _pURPurchaseReturnHeader.IsDeleted; _pURPurchaseReturnHeaderWCF.DeletedBy = _pURPurchaseReturnHeader.DeletedBy; _pURPurchaseReturnHeaderWCF.DeleteDate = _pURPurchaseReturnHeader.DeleteDate; pURPurchaseReturnHeaderCollection.Add(_pURPurchaseReturnHeaderWCF); } return(pURPurchaseReturnHeaderCollection); }
/// <summary> /// This method will delete 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="PURPurchaseHeaderPrimaryKey">Primary Key information based on which data is to be deleted.</param> /// /// <returns>True if succeeded</returns> public bool DeleteAllByForeignKeyOriginalHeaderID(PURPurchaseHeaderPrimaryKey pk) { return(POS.DataLayer.PURPurchaseReturnHeaderBase.DeleteAllByForeignKeyOriginalHeaderID(new POS.DataLayer.PURPurchaseHeaderPrimaryKey(pk.PurcaseHeaderID))); }
/// <summary> /// This method will delete 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="PURPurchaseHeaderPrimaryKey">Primary Key information based on which data is to be deleted.</param> /// /// <returns>True if succeeded</returns> public bool DeleteAllByForeignKeyPurcaseInvoiceID(PURPurchaseHeaderPrimaryKey pk) { return(POS.DataLayer.BDSupplierAccountBase.DeleteAllByForeignKeyPurcaseInvoiceID(new POS.DataLayer.PURPurchaseHeaderPrimaryKey(pk.PurcaseHeaderID))); }
/// <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="PURPurchaseHeaderPrimaryKey">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 BDSupplierAccountCollection</returns> public BDSupplierAccountCollection SelectAllByForeignKeyPurcaseInvoiceIDPaged(PURPurchaseHeaderPrimaryKey pk, int pageSize, int skipPages, string orderByStatement) { BDSupplierAccountCollection bDSupplierAccountCollection = new BDSupplierAccountCollection(); foreach (POS.DataLayer.BDSupplierAccount _bDSupplierAccount in POS.DataLayer.BDSupplierAccountBase.SelectAllByForeignKeyPurcaseInvoiceIDPaged(new POS.DataLayer.PURPurchaseHeaderPrimaryKey(pk.PurcaseHeaderID), pageSize, skipPages, orderByStatement)) { _bDSupplierAccountWCF = new BDSupplierAccount(); _bDSupplierAccountWCF.SupplierAccountId = _bDSupplierAccount.SupplierAccountId; _bDSupplierAccountWCF.PurcaseInvoiceID = _bDSupplierAccount.PurcaseInvoiceID; _bDSupplierAccountWCF.PurchaseDate = _bDSupplierAccount.PurchaseDate; _bDSupplierAccountWCF.SupplierID = _bDSupplierAccount.SupplierID; _bDSupplierAccountWCF.InvoiceNumber = _bDSupplierAccount.InvoiceNumber; _bDSupplierAccountWCF.TotalPrice = _bDSupplierAccount.TotalPrice; _bDSupplierAccountWCF.PaidAmount = _bDSupplierAccount.PaidAmount; _bDSupplierAccountWCF.IsVoid = _bDSupplierAccount.IsVoid; _bDSupplierAccountWCF.RemainingAmount = _bDSupplierAccount.RemainingAmount; _bDSupplierAccountWCF.CreateDate = _bDSupplierAccount.CreateDate; _bDSupplierAccountWCF.CreatedBy = _bDSupplierAccount.CreatedBy; _bDSupplierAccountWCF.updateDate = _bDSupplierAccount.updateDate; _bDSupplierAccountWCF.UpdatedBy = _bDSupplierAccount.UpdatedBy; _bDSupplierAccountWCF.IsDeleted = _bDSupplierAccount.IsDeleted; _bDSupplierAccountWCF.DeleteDate = _bDSupplierAccount.DeleteDate; _bDSupplierAccountWCF.DeletedBy = _bDSupplierAccount.DeletedBy; _bDSupplierAccountWCF.Depit = _bDSupplierAccount.Depit; _bDSupplierAccountWCF.Credit = _bDSupplierAccount.Credit; _bDSupplierAccountWCF.LstDayToPay = _bDSupplierAccount.LstDayToPay; _bDSupplierAccountWCF.ChequeNumber = _bDSupplierAccount.ChequeNumber; _bDSupplierAccountWCF.InvoiceType = _bDSupplierAccount.InvoiceType; bDSupplierAccountCollection.Add(_bDSupplierAccountWCF); } return(bDSupplierAccountCollection); }