/// <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="INVInventoryPrimaryKey">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 SALSalesReturnHeaderCollection</returns> public SALSalesReturnHeaderCollection SelectAllByForeignKeyInventoryIDPaged(INVInventoryPrimaryKey pk, int pageSize, int skipPages, string orderByStatement) { SALSalesReturnHeaderCollection sALSalesReturnHeaderCollection = new SALSalesReturnHeaderCollection(); foreach (POS.DataLayer.SALSalesReturnHeader _sALSalesReturnHeader in POS.DataLayer.SALSalesReturnHeaderBase.SelectAllByForeignKeyInventoryIDPaged(new POS.DataLayer.INVInventoryPrimaryKey(pk.InventoryID), pageSize, skipPages, orderByStatement)) { _sALSalesReturnHeaderWCF = new SALSalesReturnHeader(); _sALSalesReturnHeaderWCF.SlaesReturnHeaderID = _sALSalesReturnHeader.SlaesReturnHeaderID; _sALSalesReturnHeaderWCF.ReturnDate = _sALSalesReturnHeader.ReturnDate; _sALSalesReturnHeaderWCF.OriginalSalesHeadeID = _sALSalesReturnHeader.OriginalSalesHeadeID; _sALSalesReturnHeaderWCF.CreatedBy = _sALSalesReturnHeader.CreatedBy; _sALSalesReturnHeaderWCF.CreateDate = _sALSalesReturnHeader.CreateDate; _sALSalesReturnHeaderWCF.UpdatedBy = _sALSalesReturnHeader.UpdatedBy; _sALSalesReturnHeaderWCF.UpdateDate = _sALSalesReturnHeader.UpdateDate; _sALSalesReturnHeaderWCF.IsDeleted = _sALSalesReturnHeader.IsDeleted; _sALSalesReturnHeaderWCF.DeletedBy = _sALSalesReturnHeader.DeletedBy; _sALSalesReturnHeaderWCF.DeleteDate = _sALSalesReturnHeader.DeleteDate; _sALSalesReturnHeaderWCF.IsClosed = _sALSalesReturnHeader.IsClosed; _sALSalesReturnHeaderWCF.IsVoid = _sALSalesReturnHeader.IsVoid; _sALSalesReturnHeaderWCF.InventoryID = _sALSalesReturnHeader.InventoryID; _sALSalesReturnHeaderWCF.ReturnMoney = _sALSalesReturnHeader.ReturnMoney; sALSalesReturnHeaderCollection.Add(_sALSalesReturnHeaderWCF); } return(sALSalesReturnHeaderCollection); }
private void initEntity(int inventoryId) { INVInventoryPrimaryKey pk = new INVInventoryPrimaryKey(); pk.InventoryID = inventoryId; _invInventory = _invInventoryWrapper.SelectOne(pk); txt_InventoryName.Text =_invInventory.InventoryName; txt_Notes.Text = _invInventory.Notes; }
/// <summary> /// This method will return an object representing the record matching the primary key information specified. /// </summary> /// /// <param name="pk" type="INVInventoryPrimaryKey">Primary Key information based on which data is to be fetched.</param> /// /// <returns>object of class INVInventory</returns> public INVInventory SelectOne(INVInventoryPrimaryKey pk) { _iNVInventoryWCF = new INVInventory(); _iNVInventory = POS.DataLayer.INVInventoryBase.SelectOne(new POS.DataLayer.INVInventoryPrimaryKey(pk.InventoryID)); _iNVInventoryWCF.InventoryID = _iNVInventory.InventoryID; _iNVInventoryWCF.InventoryName = _iNVInventory.InventoryName; _iNVInventoryWCF.Notes = _iNVInventory.Notes; return(_iNVInventoryWCF); }
/// <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="INVInventoryPrimaryKey">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 SelectAllByForeignKeyInventoryIDPaged(INVInventoryPrimaryKey pk, int pageSize, int skipPages, string orderByStatement) { PURPurchaseHeaderCollection pURPurchaseHeaderCollection = new PURPurchaseHeaderCollection(); foreach (POS.DataLayer.PURPurchaseHeader _pURPurchaseHeader in POS.DataLayer.PURPurchaseHeaderBase.SelectAllByForeignKeyInventoryIDPaged(new POS.DataLayer.INVInventoryPrimaryKey(pk.InventoryID), 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); }
public override void btn_Delete_Click(object sender, EventArgs e) { int? productGroupID = 0; if (dgrid_Result.Rows[dgrid_Result.SelectedCells[0].RowIndex].Cells["InventoryID"].Value != null) { if (MessageBox.Show("هل نت متأكد من حذف المخزن؟", "تحذير", MessageBoxButtons.YesNo) == DialogResult.Yes) { productGroupID = Convert.ToInt32(dgrid_Result.Rows[dgrid_Result.SelectedCells[0].RowIndex].Cells["InventoryID"].Value); INVInventoryPrimaryKey productGroupPK = new INVInventoryPrimaryKey(); productGroupPK.InventoryID = productGroupID; _invInventoryWrapper.Delete(productGroupPK); } else { return; } } else { MessageBox.Show("لابد من اختيار مخزن"); } InitiateGrid(); }
///<summary> ///This method will Delete the object from the database ///</summary> ///<param name="pk" type="INVInventoryPrimaryKey">Primary Key information based on which data is to be fetched.</param> /// <returns>True if succeeded</returns> public bool Delete(INVInventoryPrimaryKey pk) { return(POS.DataLayer.INVInventoryBase.Delete(new POS.DataLayer.INVInventoryPrimaryKey(pk.InventoryID))); }
/// <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="INVInventoryPrimaryKey">Primary Key information based on which data is to be deleted.</param> /// /// <returns>True if succeeded</returns> public bool DeleteAllByForeignKeyInventoryID(INVInventoryPrimaryKey pk) { return(POS.DataLayer.PURPurchaseHeaderBase.DeleteAllByForeignKeyInventoryID(new POS.DataLayer.INVInventoryPrimaryKey(pk.InventoryID))); }