public void InsertCustomer_Order(Model.CustomerOrder Data)
{
//Customer_Order sql
string sql_ID = "insert into dbo.Customer_Order(Order_ID,Sale_Processing_Static) values('" + Data.Order_ID + "','False'); ";
string sql = "update dbo.Customer_Order set " +
"Customer_Email = '" + Data.Customer_Email + "'," +
"Order_Date = '" + DateTime.Now.ToString("yyyy/MM/dd") + "'," +
"Subscriber_Name = '" + Data.Subscriber_Name + "'," +
"Subscriber_Cellphone = '" + Data.Subscriber_Cellphone + "'," +
"Subscriber_Email = '" + Data.Subscriber_Email + "'," +
"Subscriber_Address = '" + Data.Subscriber_Address + "' where Order_ID = '" + Data.Order_ID + "';";
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["DBconn"].ConnectionString);
using (conn)
{
conn.Open();
SqlCommand cmd_sql_ID = new SqlCommand(sql_ID, conn);
SqlCommand cmd_sql = new SqlCommand(sql, conn);
SqlDataAdapter sqlAdapter_sql_ID = new SqlDataAdapter(cmd_sql_ID);
SqlDataAdapter sqlAdapter_sql = new SqlDataAdapter(cmd_sql);
try
{
cmd_sql_ID.ExecuteNonQuery();
cmd_sql.ExecuteNonQuery();
}
catch (Exception e)
{
conn.Close();
}
conn.Close();
}
//sql_Book_ID
}
public void InsertOrder_Books(Model.CustomerOrder Data, List <Model.ShippingCar> Data2)
{
for (int i = 0; i < Data2.Count; i++)
{
string sql = "insert into dbo.Order_Books(Order_ID,Book_ID,Order_Quantity) " +
"values('" + Data.Order_ID + "','" + Data2[i].Book_ID + "','" + Data2[i].Order_Quantity + "')";
string sql_update = "update dbo.Books_Management set Book_Quantity = Book_Quantity - '" + Data2[i].Order_Quantity + "'" +
"where Book_ID = '" + Data2[i].Book_ID + "'";
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["DBconn"].ConnectionString);
using (conn)
{
conn.Open();
SqlCommand cmd_sql = new SqlCommand(sql, conn);
SqlDataAdapter sqlAdapter_sql = new SqlDataAdapter(cmd_sql);
SqlCommand cmd_update = new SqlCommand(sql_update, conn);
SqlDataAdapter sqlAdapter_sql_update = new SqlDataAdapter(cmd_update);
try
{
cmd_update.ExecuteNonQuery();
cmd_sql.ExecuteNonQuery();
}
catch (Exception e)
{
conn.Close();
}
conn.Close();
}
}
}
public ActionResult Insert(Model.CustomerOrder Data, string Order_ID)
{
Service.SQLCheckOut SCO = new Service.SQLCheckOut();
Data.Customer_Email = Request.Cookies["cookie"]["Account"].ToString();
SCO.InsertCustomer_Order(Data);
Service.SQLGetShoppingCart SGSC = new Service.SQLGetShoppingCart();
List <Model.ShippingCar> Data2 = new List <Model.ShippingCar>();
Data2 = SGSC.Find(Data.Customer_Email);
SCO.InsertOrder_Books(Data, Data2);
Service.SQLDeleteShoppingCart SDSC = new Service.SQLDeleteShoppingCart();
SDSC.Delete_Cart();
return(RedirectToAction("Index", "DataShow", new { Order_ID = Order_ID }));
}