private void btnRemove_Click(object sender, EventArgs e)
{
this.t = 0;
int idx = dgvModOrder.CurrentRow.Index;
if (MessageBox.Show("Do you want Delete this product?", "Delete orderProduct", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
String sql = "Delete from ordersproducts where idorderproduct= " + dgvModOrder.Rows[idx].Cells[0].Value.ToString();
float total = Convert.ToSingle(txtTotal.Text);
t = Convert.ToSingle(dgvModOrder.Rows[idx].Cells[4].Value) * Convert.ToSingle(dgvModOrder.Rows[idx].Cells[5].Value);
total = total - t;
txtTotal.Text = total.ToString();
String sqlUpdate = "Update orders set Total=" + txtTotal.Text + "where idorder=" + this.idOrder;
GestorOrdersProduct.UpdateOrderProduct(sqlUpdate);
GestorOrdersProduct.deleteOrderProduct(sql);
dgvModOrder.Rows.RemoveAt(idx);
}
//restar cantidad del precio
}
public OrderProduct()
{
g = new GestorOrdersProduct();
}
