private void btnDelRow_Click(object sender, EventArgs e)
{
try
{
foreach (DataGridViewRow row in dgvInvoice.SelectedRows)
{
dgvInvoice.Rows.Remove(row);
double addSum = 0.0;
for (int x = 0; x < dgvInvoice.Rows.Count; x++)
{
addSum = addSum + Convert.ToDouble(dgvInvoice.Rows[x].Cells[3].Value);
}
txtGTotal.Text = Convert.ToString(addSum);
String updateQuery = "UPDATE products SET QUANTITY = QUANTITY + '" + txtq1.Text + "' WHERE PRODUCT_NAME = '" + txtpn1.Text + "' ";
dbConnect connect = new dbConnect();
connect.Update(updateQuery);
}
txtq1.Text = "";
loadPsProduct();
}
catch (Exception error)
{
MessageBox.Show(error.Message);
}
}
private void btnCart_Emp_Click(object sender, EventArgs e)
{
Int32.TryParse(txt_Qty.Text, out int quantity);
Int32.TryParse(txtActualQty.Text, out int totalQuantity);
//quantity <= totalQuantity && quantity > 0 && txt_Qty.Text != ""
try
{
if (quantity <= totalQuantity && quantity > 0 && txt_Qty.Text != "")
{
Double.TryParse(txt_Price.Text, out Double price);
Double.TryParse(txt_Qty.Text, out Double qty);
Int32.TryParse(txt_Qty.Text, out int qty_1);
double total = price * qty;
string stringTotal = total.ToString();
//MessageBox.Show(txt_Qty.Text + ' ' + txtActualQty.Text);
dgvInvoice.Rows.Add(txt_Pname.Text, txt_Price.Text, txt_Qty.Text, stringTotal);
double addSum = 0.0;
for (int x = 0; x < dgvInvoice.Rows.Count; x++)
{
addSum = addSum + Convert.ToDouble(dgvInvoice.Rows[x].Cells[3].Value);
}
txtGTotal.Text = Convert.ToString(addSum);
String updateQuery = "UPDATE products SET QUANTITY = QUANTITY - '" + qty_1 + "' WHERE PRODUCT_ID = '" + txt_pid.Text + "' ";
dbConnect connect = new dbConnect();
connect.Update(updateQuery);
}
else
{
MessageBox.Show("Invalid value for the quantity");
}
}
catch (Exception error)
{
MessageBox.Show(error.Message);
}
txt_Qty.Text = "";
loadPsProduct();
}
private void btnU_Price_Click(object sender, EventArgs e)
{
String updateQuery = "UPDATE products SET PRICE = '" + txtPrice.Text + "' WHERE PRODUCT_ID= '" + txtPID.Text + "' ";
if (txtPrice.Text != "" && txtPID.Text != "")
{
dbConnect connect = new dbConnect();
connect.Update(updateQuery);
}
else
{
MessageBox.Show("Invalid Entry");
}
loadProduct();
}