private void btnCancelProduct_Click(object sender, EventArgs e)
{
this.Hide();
ChooseProducts chp = new ChooseProducts(clientID, orderID, index);
chp.ShowDialog();
this.Close();
}
private void btnAddProductToCart_Click(object sender, EventArgs e)
{
if (txtQuantity.Text == "")
{
MessageBox.Show("Please enter quantity");
}
else
{
SqlConnection con = new SqlConnection(@"Data Source=DESKTOP-P74G1IQ\SQLEXPRESS;Initial Catalog=GroceryStore;Integrated Security=True");
con.Open();
SqlCommand newCmd = new SqlCommand("INSERT INTO Product_Order (Order_ID, Product_ID, Product_Quantity) VALUES (@OrderID, @ProductID, @Quantity)", con);
newCmd.Parameters.Add("@OrderID", SqlDbType.Int)
.Value = orderID;
newCmd.Parameters.Add("@ProductID", SqlDbType.Int)
.Value = value;
newCmd.Parameters.Add("@Quantity", SqlDbType.Decimal)
.Value = System.Convert.ToDecimal(txtQuantity.Text);
try
{
newCmd.ExecuteNonQuery();
}
catch (Exception)
{
MessageBox.Show("You already added " + lblProductName.Text + " to your cart");
this.Close();
}
SqlCommand cmd1 = new SqlCommand("select Order_ID from \"Order\" where (Client_ID = '" + clientID + "')", con);
SqlDataReader reader = cmd1.ExecuteReader();
while (reader.Read())
{
orderID = reader.GetInt32(0);
}
con.Close();
this.Hide();
ChooseProducts chp = new ChooseProducts(clientID, orderID, index);
chp.ShowDialog();
this.Close();
}
}
private void pictureBox2_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(@"Data Source=DESKTOP-P74G1IQ\SQLEXPRESS;Initial Catalog=GroceryStore;Integrated Security=True");
con.Open();
SqlCommand command = new SqlCommand("insert into \"Order\" (Client_ID, Order_Date) values ('" + clientID + "', GetDate())", con);
SqlCommand cmd1 = new SqlCommand("select Order_ID from \"Order\" where (Client_ID = '" + clientID + "')", con);
command.ExecuteNonQuery();
SqlDataReader reader = cmd1.ExecuteReader();
while (reader.Read())
{
orderID = reader.GetInt32(0);
}
con.Close();
index = 2;
this.Hide();
ChooseProducts cp = new ChooseProducts(clientID, orderID, index);
cp.ShowDialog();
this.Close();
}
