/// <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="BDProductPrimaryKey">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 SelectAllByForeignKeyProductIDPaged(BDProductPrimaryKey pk, int pageSize, int skipPages, string orderByStatement) { PURPurchaseLineCollection pURPurchaseLineCollection = new PURPurchaseLineCollection(); foreach (POS.DataLayer.PURPurchaseLine _pURPurchaseLine in POS.DataLayer.PURPurchaseLineBase.SelectAllByForeignKeyProductIDPaged(new POS.DataLayer.BDProductPrimaryKey(pk.ProductID), 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); }
private void initEntity(int productId) { try { BDProductPrimaryKey pk = new BDProductPrimaryKey(); pk.ProductID = productId; _bdProduct = _bdProductWrapper.SelectOne(pk); loadUI(); } catch (Exception ex) { MessageBox.Show("حدث خطأ برجاء تكرار العمليه مره اخرى واذا تكرر الخطا برجاءالاتصال بالشخص المصمم للبرنامج وارسال رسالة الخطا التى ستظهر بعد قليل له"); MessageBox.Show(ex.Message); } }
/// <summary> /// This method will return an object representing the record matching the primary key information specified. /// </summary> /// /// <param name="pk" type="BDProductPrimaryKey">Primary Key information based on which data is to be fetched.</param> /// /// <returns>object of class BDProduct</returns> public BDProduct SelectOne(BDProductPrimaryKey pk) { _bDProductWCF = new BDProduct(); _bDProduct = POS.DataLayer.BDProductBase.SelectOne(new POS.DataLayer.BDProductPrimaryKey(pk.ProductID)); _bDProductWCF.ProductID = _bDProduct.ProductID; _bDProductWCF.ProductName = _bDProduct.ProductName; _bDProductWCF.ProductGroupID = _bDProduct.ProductGroupID; _bDProductWCF.ProductCode = _bDProduct.ProductCode; _bDProductWCF.IsAcceptBatch = _bDProduct.IsAcceptBatch; _bDProductWCF.ProductPrice = _bDProduct.ProductPrice; _bDProductWCF.IsFixedPrice = _bDProduct.IsFixedPrice; _bDProductWCF.HasDiscount = _bDProduct.HasDiscount; _bDProductWCF.DiscountAmount = _bDProduct.DiscountAmount; _bDProductWCF.DescountRatio = _bDProduct.DescountRatio; _bDProductWCF.IsActive = _bDProduct.IsActive; _bDProductWCF.Notes = _bDProduct.Notes; return(_bDProductWCF); }
/// <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="BDProductPrimaryKey">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 INVAdjustStockCollection</returns> public INVAdjustStockCollection SelectAllByForeignKeyProductIDPaged(BDProductPrimaryKey pk, int pageSize, int skipPages, string orderByStatement) { INVAdjustStockCollection iNVAdjustStockCollection = new INVAdjustStockCollection(); foreach (POS.DataLayer.INVAdjustStock _iNVAdjustStock in POS.DataLayer.INVAdjustStockBase.SelectAllByForeignKeyProductIDPaged(new POS.DataLayer.BDProductPrimaryKey(pk.ProductID), pageSize, skipPages, orderByStatement)) { _iNVAdjustStockWCF = new INVAdjustStock(); _iNVAdjustStockWCF.AdjustStockID = _iNVAdjustStock.AdjustStockID; _iNVAdjustStockWCF.ProductID = _iNVAdjustStock.ProductID; _iNVAdjustStockWCF.BatchID = _iNVAdjustStock.BatchID; _iNVAdjustStockWCF.Qty = _iNVAdjustStock.Qty; _iNVAdjustStockWCF.AdjustReasonID = _iNVAdjustStock.AdjustReasonID; _iNVAdjustStockWCF.CreatedBy = _iNVAdjustStock.CreatedBy; _iNVAdjustStockWCF.CredateDate = _iNVAdjustStock.CredateDate; _iNVAdjustStockWCF.UpdatedBy = _iNVAdjustStock.UpdatedBy; _iNVAdjustStockWCF.UpdateDate = _iNVAdjustStock.UpdateDate; iNVAdjustStockCollection.Add(_iNVAdjustStockWCF); } return(iNVAdjustStockCollection); }
/// <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="BDProductPrimaryKey">Primary Key information based on which data is to be fetched.</param> /// /// <returns>object of class INVAdjustStockCollection</returns> public INVAdjustStockCollection SelectAllByForeignKeyProductID(BDProductPrimaryKey pk) { INVAdjustStockCollection iNVAdjustStockCollection = new INVAdjustStockCollection(); foreach (POS.DataLayer.INVAdjustStock _iNVAdjustStock in POS.DataLayer.INVAdjustStockBase.SelectAllByForeignKeyProductID(new POS.DataLayer.BDProductPrimaryKey(pk.ProductID))) { _iNVAdjustStockWCF = new INVAdjustStock(); _iNVAdjustStockWCF.AdjustStockID = _iNVAdjustStock.AdjustStockID; _iNVAdjustStockWCF.ProductID = _iNVAdjustStock.ProductID; _iNVAdjustStockWCF.BatchID = _iNVAdjustStock.BatchID; _iNVAdjustStockWCF.Qty = _iNVAdjustStock.Qty; _iNVAdjustStockWCF.AdjustReasonID = _iNVAdjustStock.AdjustReasonID; _iNVAdjustStockWCF.CreatedBy = _iNVAdjustStock.CreatedBy; _iNVAdjustStockWCF.CredateDate = _iNVAdjustStock.CredateDate; _iNVAdjustStockWCF.UpdatedBy = _iNVAdjustStock.UpdatedBy; _iNVAdjustStockWCF.UpdateDate = _iNVAdjustStock.UpdateDate; iNVAdjustStockCollection.Add(_iNVAdjustStockWCF); } return(iNVAdjustStockCollection); }
new private bool Validate() { bool isValid = false; bool isValidProduct = false; int ProductID=0; int InvProductID=0; int? oldStockTypeId = dgrid_stock.SelectedRows.Count > 0 ? int.Parse(dgrid_stock.SelectedRows[0].Cells["col_StockTypeID"].Value.ToString()) : 0; string BatchID = dgrid_batches.SelectedRows.Count > 0 ? dgrid_batches.SelectedRows[0].Cells["col_batch"].Value.ToString() : ""; DateTime? ExpiryDate = dgrid_batches.SelectedRows.Count > 0 ? Convert.ToDateTime(dgrid_batches.SelectedRows[0].Cells["col_expiry"].Value.ToString()) : (DateTime?)null; decimal oldQty = dgrid_batches.SelectedRows.Count > 0 ? Convert.ToDecimal(dgrid_batches.SelectedRows[0].Cells["col_batchQty"].Value.ToString()) : dgrid_stock.SelectedRows.Count>0? Convert.ToDecimal(dgrid_stock.SelectedRows[0].Cells["col_qty"].Value.ToString()):0; int AdjustReasonID = 0; int StockTypeID = 0; int InventoryID = 0; decimal Qty = num_Qty.Value; if (dgrid_stock.SelectedRows.Count > 0) int.TryParse(dgrid_stock.SelectedRows[0].Cells["col_invProductStock"].Value.ToString(), out InvProductID); if (cbx_AdjustReason.SelectedValue != null) int.TryParse(cbx_AdjustReason.SelectedValue.ToString(), out AdjustReasonID); if (cbx_StockTypeTO.SelectedValue != null) int.TryParse(cbx_StockTypeTO.SelectedValue.ToString(), out StockTypeID); if (cbx_Store.SelectedValue != null) int.TryParse(cbx_Store.SelectedValue.ToString(), out InventoryID); if (InvProductID > 0) { isValidProduct = true; INVProductStockPrimaryKey ispk = new INVProductStockPrimaryKey(); ispk.ProductStockID = InvProductID; var invPS = _invProductStockWrapper.SelectOne(ispk); ProductID = invPS.ProductID.Value; BDProductPrimaryKey pk = new BDProductPrimaryKey(); pk.ProductID = invPS.ProductID; if (_ProductWrapper.SelectOne(pk).IsAcceptBatch == true) isValidProduct = (!string.IsNullOrEmpty(BatchID) && ExpiryDate.HasValue); } if (!isValidProduct || AdjustReasonID == 0 || StockTypeID == 0 || InventoryID == 0 || Qty == 0 || Qty > oldQty || oldStockTypeId == StockTypeID) isValid= false; else { isValid = true; if (_isEdit) { INVAdjustStock _EditNewAdjustStock = _adjustStock; _EditNewAdjustStock.Qty *= -1; _adjustStockCollection.Add(_EditNewAdjustStock); INVAdjustStock _EditOldAdjustStock = _adjustStock; _adjustStock.StockTypeID = _adjustStock.OldStockTypeID; _adjustStockCollection.Add(_EditOldAdjustStock); } _adjustStock.ProductID = ProductID; _adjustStock.AdjustReasonID = AdjustReasonID; _adjustStock.AdjustStockID = _adjustStockID; _adjustStock.BatchID = null; _adjustStock.InventoryID = InventoryID; _adjustStock.StockTypeID = StockTypeID; _adjustStock.OldStockTypeID = oldStockTypeId; _adjustStock.Qty = Qty; _adjustStock.BatchNumber = BatchID; _adjustStock.ExpiryDate = ExpiryDate; if (_isEdit) { _adjustStock.UpdateDate = DateTime.Now; _adjustStock.UpdatedBy = GlobalVariables.CurrentUser.UserID; } else { _adjustStock.CredateDate = DateTime.Now; _adjustStock.CreatedBy = GlobalVariables.CurrentUser.UserID; } _adjustStockCollection.Add(_adjustStock); INVAdjustStock _oldAdjustStock = new INVAdjustStock(); _oldAdjustStock.ProductID = ProductID; _oldAdjustStock.AdjustReasonID = AdjustReasonID; _oldAdjustStock.AdjustStockID = _adjustStockID; _oldAdjustStock.BatchID = null; _oldAdjustStock.InventoryID = InventoryID; _oldAdjustStock.StockTypeID = oldStockTypeId; _oldAdjustStock.Qty = (-1 * Qty); _oldAdjustStock.BatchNumber = BatchID; _oldAdjustStock.ExpiryDate = ExpiryDate; if (_isEdit) { _oldAdjustStock.UpdateDate = DateTime.Now; _oldAdjustStock.UpdatedBy = GlobalVariables.CurrentUser.UserID; } else { _oldAdjustStock.CredateDate = DateTime.Now; _oldAdjustStock.CreatedBy = GlobalVariables.CurrentUser.UserID; } _adjustStockCollection.Add(_oldAdjustStock); } return isValid; }
///<summary> ///This method will Delete the object from the database ///</summary> ///<param name="pk" type="BDProductPrimaryKey">Primary Key information based on which data is to be fetched.</param> /// <returns>True if succeeded</returns> public bool Delete(BDProductPrimaryKey pk) { return(POS.DataLayer.BDProductBase.Delete(new POS.DataLayer.BDProductPrimaryKey(pk.ProductID))); }
private void dgrd_OrderLines_CellValueChanged(object sender, DataGridViewCellEventArgs e) { if (e.RowIndex != -1 && e.ColumnIndex == dgrd_OrderLines.Columns["ProductName"].Index) { BDProductPrimaryKey pk = new BDProductPrimaryKey(); pk.ProductID = Convert.ToInt32(dgrd_OrderLines.Rows[e.RowIndex].Cells["ProductName"].Value); BDProduct _product = _productWrapper.SelectOne(pk); dgrd_OrderLines.Rows[e.RowIndex].Cells["IsAcceptBatch"].Value = _product.IsAcceptBatch; if (_product.IsAcceptBatch == true) { dgrd_OrderLines.Rows[e.RowIndex].Cells["BatchNumber"].ReadOnly = false; dgrd_OrderLines.Rows[e.RowIndex].Cells["ExpiryDate"].ReadOnly = false; } else { dgrd_OrderLines.Rows[e.RowIndex].Cells["BatchNumber"].ReadOnly = true; dgrd_OrderLines.Rows[e.RowIndex].Cells["ExpiryDate"].ReadOnly = true; } } if (e.RowIndex != -1 && e.ColumnIndex == dgrd_OrderLines.Columns["TotalQty"].Index || e.RowIndex != -1 && e.ColumnIndex == dgrd_OrderLines.Columns["PurchasePrice"].Index) { CalculateTotal(); } }
private void dgrd_ReturnOrderLines_CellValueChanged(object sender, DataGridViewCellEventArgs e) { try { var senderGrid = (DataGridView)sender; if (e.RowIndex != -1 && (e.ColumnIndex == senderGrid.Columns["TotalQty"].Index /*|| e.ColumnIndex == senderGrid.Columns["UnitPrice"].Index*/) && !string.IsNullOrEmpty(senderGrid.Rows[e.RowIndex].Cells["TotalQty"].Value.ToString())) { if (Convert.ToInt32(senderGrid.Rows[e.RowIndex].Cells["ProductName"].Value) == -1) { MessageBox.Show("أختر صنف أولا"); return; } if (Convert.ToInt32(senderGrid.Rows[e.RowIndex].Cells["StockType"].Value) == -1) { MessageBox.Show("أختر نوع مرتجع أولا"); return; } VSALSalesOrder vSALSalesOrder = vSALSalesOrderCollection.Where(a => a.ProductID == Convert.ToInt32(senderGrid.Rows[e.RowIndex].Cells["ProductName"].Value)).SingleOrDefault(); if (Convert.ToInt32(senderGrid.Rows[e.RowIndex].Cells["TotalQty"].Value) > vSALSalesOrder.TotalQty) { MessageBox.Show("الكمية المرتجعه اكبر من الكميه المدخله فى الفاتوره الاصليه"); return; } if (senderGrid.Rows[e.RowIndex].Cells["UnitPrice"].Value != null && senderGrid.Rows[e.RowIndex].Cells["TotalQty"].Value != null) tbx_Total.Text = (CalculateTotal(Convert.ToDouble(senderGrid.Rows[e.RowIndex].Cells["UnitPrice"].Value) * Convert.ToDouble(senderGrid.Rows[e.RowIndex].Cells["TotalQty"].Value))).ToString(); else return; } if (e.RowIndex != -1 && e.ColumnIndex == senderGrid.Columns["ProductName"].Index) { VSALSalesOrder vSALSalesOrder = vSALSalesOrderCollection.Where(a => a.ProductID == Convert.ToInt32(senderGrid.Rows[e.RowIndex].Cells["ProductName"].Value)).SingleOrDefault(); if (vSALSalesOrder == null) { MessageBox.Show("هذا الصنف غير موجود بالفاتورة الاصليه"); senderGrid.Rows[e.RowIndex].ErrorText = "هذا الصنف غير موجود بالفاتورة الاصليه"; //senderGrid.Rows[e.RowIndex].Cells["ProductName"].Value = null; senderGrid.Rows[e.RowIndex].Cells["ProductName"].Style.BackColor = Color.Red; return; } BDProductPrimaryKey pk = new BDProductPrimaryKey(); pk.ProductID = Convert.ToInt32(senderGrid.Rows[e.RowIndex].Cells["ProductName"].Value); BDProduct _product = bDProductWrapper.SelectOne(pk); senderGrid.Rows[e.RowIndex].Cells["IsAcceptBatch"].Value = _product.IsAcceptBatch; if (_product.IsAcceptBatch == true) { senderGrid.Rows[e.RowIndex].Cells["BatchNumber"].ReadOnly = false; senderGrid.Rows[e.RowIndex].Cells["ExpiryDate"].ReadOnly = false; } else { senderGrid.Rows[e.RowIndex].Cells["BatchNumber"].ReadOnly = true; senderGrid.Rows[e.RowIndex].Cells["ExpiryDate"].ReadOnly = true; } senderGrid.Rows[e.RowIndex].Cells["UnitPrice"].Value = vSALSalesOrder.FinalPrice; } if (e.RowIndex != -1 && e.ColumnIndex == senderGrid.Columns["ExpiryDate"].Index) { if (Convert.ToInt32(senderGrid.Rows[e.RowIndex].Cells["ProductName"].Value) == -1) { MessageBox.Show("أختر صنف أولا"); return; } DateTime result; if (!DateTime.TryParse(senderGrid.Rows[e.RowIndex].Cells["ExpiryDate"].Value.ToString(), out result)) { MessageBox.Show("صيغة تاريخ الصلاحية غير صحيحة لابد ان تكون (يوم -شهر -سنة)"); senderGrid.Rows[e.RowIndex].Cells["ExpiryDate"].Style.BackColor = Color.Red; senderGrid.Rows[e.RowIndex].Cells["ExpiryDate"].Value = ""; } else { senderGrid.Rows[e.RowIndex].Cells["ExpiryDate"].Style.BackColor = Color.White; } } } catch (Exception ex) { MessageBox.Show("حدث خطأ برجاء تكرار العمليه مره اخرى واذا تكرر الخطا برجاءالاتصال بالشخص المصمم للبرنامج وارسال رسالة الخطا التى ستظهر بعد قليل له"); MessageBox.Show(ex.Message); } }
/// <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="BDProductPrimaryKey">Primary Key information based on which data is to be deleted.</param> /// /// <returns>True if succeeded</returns> public bool DeleteAllByForeignKeyProductID(BDProductPrimaryKey pk) { return(POS.DataLayer.PURPurchaseLineBase.DeleteAllByForeignKeyProductID(new POS.DataLayer.BDProductPrimaryKey(pk.ProductID))); }
/// <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="BDProductPrimaryKey">Primary Key information based on which data is to be deleted.</param> /// /// <returns>True if succeeded</returns> public bool DeleteAllByForeignKeyProductID(BDProductPrimaryKey pk) { return(POS.DataLayer.INVAdjustStockBase.DeleteAllByForeignKeyProductID(new POS.DataLayer.BDProductPrimaryKey(pk.ProductID))); }
public override void btn_Delete_Click(object sender, EventArgs e) { int? productID = 0; if (dgrid_Result.Rows[dgrid_Result.SelectedCells[0].RowIndex].Cells["ProductID"].Value != null) { if (MessageBox.Show("هل نت متأكد من حذف الصنف؟", "تحذير", MessageBoxButtons.YesNo) == DialogResult.Yes) { productID = Convert.ToInt32(dgrid_Result.Rows[dgrid_Result.SelectedCells[0].RowIndex].Cells["ProductID"].Value); BDProductPrimaryKey productPK = new BDProductPrimaryKey(); productPK.ProductID = productID; _bdProductWrapper.Delete(productPK); } else { return; } } else { MessageBox.Show("لابد من اختيار الصنف"); } InitiateGrid(); }