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