public void UpdateTotalPrice()
{
TotalPrice = CheckOutApp.CalculateTotalPrice();
lblPriceTotal.Text = CheckOutApp.CalculateTotalPrice().ToString();
//MessageBox.Show(CheckOutApp.CalculateTotalPrice().ToString());
this.Refresh();
}
public static void InserOrdersDb(User user)
{
using (SqlConnection con = new SqlConnection(connectionString))
{
con.Open();
SqlCommand cmd = new SqlCommand("Insert into orderTable values ( @userID, @bill, @status, @address, @mobile);", con);
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@userID", user.UserName);
cmd.Parameters.AddWithValue("@bill", (float)CheckOutApp.CalculateTotalPrice());
cmd.Parameters.AddWithValue("@status", 0);
cmd.Parameters.AddWithValue("@address", user.Address);
cmd.Parameters.AddWithValue("@mobile", user.Mobile);
cmd.ExecuteNonQuery();
SqlCommand cmd2 = new SqlCommand("SELECT IDENT_CURRENT('orderTable')", con);
int id = Convert.ToInt32(cmd2.ExecuteScalar());
cmd2 = new SqlCommand("Insert into notification values (@userID, @message, @notified);", con);
cmd2.CommandType = CommandType.Text;
cmd2.Parameters.AddWithValue("@userID", user.UserName);
cmd2.Parameters.AddWithValue("@message", user.UserName + " has placed an order [" + id + "]");
cmd2.Parameters.AddWithValue("@notified", 0);
cmd2.ExecuteNonQuery();
foreach (CartItemApp cartItemApp in CheckOutApp.itemApps)
{
SqlCommand cmd3 = new SqlCommand("Insert into orderExtension values ( @orderID, @itemCode, @quantity);", con);
cmd3.CommandType = CommandType.Text;
cmd3.Parameters.AddWithValue("@orderID", id);
cmd3.Parameters.AddWithValue("@itemCode", Convert.ToInt32(cartItemApp.ItemCode));
cmd3.Parameters.AddWithValue("@quantity", cartItemApp.Quantity);
cmd3.ExecuteNonQuery();
}
con.Close();
Console.WriteLine("inserted orders");
}
}