private void btnReplace_Click(object sender, EventArgs e) { db = new db_MiletecDataContext(); if (txtNoofDamages.Text != "Damages (Quanity)" && txtDeliveryNo.Text != "Delivery No." && txtTransactionID.Text != "Transaction ID") { var query_StockQty = db.sp_RetrieveStocksQuantity(txtproductid.Text, productName); foreach (sp_RetrieveStocksQuantityResult entry in query_StockQty.ToList()) { productID = entry.productid.ToString(); qtyLeft = int.Parse(entry.availqty.ToString()); qtydamages = qtyLeft - int.Parse(txtNoofDamages.Text); if (txtproductid.Text == productID) { db.sp_Update_StocksQty(txtproductid.Text, qtydamages); } } if (qtyLeft >= int.Parse(txtNoofDamages.Text)) { if (Convert.ToInt32(txtNoofDamages.Text) > Convert.ToInt32(dgvTransactionDetails.CurrentRow.Cells[4].Value.ToString())) { MessageBox.Show("Quantity is larger than the ordered quantity"); } else { MessageBox.Show("Damaged product replaced!!", "Successful", MessageBoxButtons.OK, MessageBoxIcon.Information); db.sp_insert_DamagesAndReplacement(txtReplacementNo.Text, txtTransactionID.Text, txtDeliveryNo.Text, txtproductid.Text, productName, DateTime.Now, int.Parse(txtNoofDamages.Text)); dgvReplacements.Rows.Add(txtproductid.Text, productName, txtNoofDamages.Text); } } else if (qtyLeft < int.Parse(txtNoofDamages.Text)) { var query_StockQty1 = db.sp_RetrieveStocksQuantity(txtproductid.Text, productName); foreach (sp_RetrieveStocksQuantityResult entry in query_StockQty1.ToList()) { productID = entry.productid.ToString(); qtyLeft = int.Parse(entry.availqty.ToString()); qtydamages = qtyLeft + int.Parse(txtNoofDamages.Text); if (txtproductid.Text == productID) { db.sp_Update_StocksQty(txtproductid.Text, qtydamages); } } MessageBox.Show("Low Stocks"); } } else { MessageBox.Show("Please fill up everything first!!", "NOTE", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void btnProceed_Click(object sender, EventArgs e) { db = new db_MiletecDataContext(); if (txtOrderID.Text != "Order No.") { if (dgvProductDetails.CurrentRow.Cells[3].Value.ToString() == "Delivered") { MessageBox.Show("Product was already delivered!!"); dgvProductDetails.Rows.Remove(dgvProductDetails.CurrentRow); } else if (txtOrderID.Text != "Order No." && txtDeliveryNo.Text != "Delivery No.") { db.sp_DeliveryDetails(txtDeliveryNo.Text, txtOrderID.Text, txtProdID.Text, DateTime.Parse(dtpDate.Text), ProductName, int.Parse(Qty)); dgvDeliverditems.Rows.Add(txtProdID.Text, ProductName, DateTime.Now); lblreceivedby.Text = Form1.name.ToString(); MessageBox.Show("Successfully delivered!!"); db.sp_update_tblOrderDetails(txtOrderID.Text, txtProdID.Text, "Delivered"); var query_Price = db.sp_RetrieveStocksQuantity(txtProdID.Text, ProductName); foreach (sp_RetrieveStocksQuantityResult entry in query_Price.ToList()) { oldQty = int.Parse(entry.availqty.ToString()); newQty = int.Parse(Qty) + oldQty; if (txtProdID.Text == "ProductID-0001") { db.sp_Update_StocksQty(txtProdID.Text, newQty); } else if (txtProdID.Text == "Product-0002") { db.sp_Update_StocksQty(txtProdID.Text, newQty); } else { db.sp_Update_StocksQty(txtProdID.Text, newQty); } } dgvProductDetails.Rows.Remove(dgvProductDetails.CurrentRow); } else { MessageBox.Show("Please Add first the OrderID that you want to be delivered!", "NOTE", MessageBoxButtons.OK, MessageBoxIcon.Error); } } //GenDelID(txtDeliveryNo); }