public static void InsertOrder(int UserID, int ItemID, string Address, double Cost, int Quantity) { int random = 0; int deliverymanID = 1; var deliverymen = ManagerViewModel.GetDeliverymen(); while (random == 0) { System.Random r = new System.Random(System.DateTime.Now.Second); deliverymanID = r.Next(deliverymen.Count + 1); for (int i = 0; i < deliverymen.Count; i++) { if (deliverymanID == deliverymen[i].ID) { random = 1; } } } using (MySqlConnection conn = new MySqlConnection(ConfigurationManager.ConnectionStrings["DB"].ConnectionString)) { DataTable dt = new DataTable(); using (MySqlCommand cmd = new MySqlCommand("InsertOrder", conn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("UserID", UserID); cmd.Parameters.AddWithValue("ItemID", ItemID); cmd.Parameters.AddWithValue("Address", Address); cmd.Parameters.AddWithValue("Cost", Cost); cmd.Parameters.AddWithValue("Quantity", Quantity); cmd.Parameters.AddWithValue("DeliverymanID", deliverymanID); conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); } } }
public ActionResult Deliverymen() { return(View(ManagerViewModel.GetDeliverymen())); }
public static void UserSubmitReview(int UserID, int isVVIP, int ItemID, int ChefID, int DeliverymanID, int Rating, int DeliveryRating, int Approval, string Comment) { int Delivery_Approval = 0; if (DeliveryRating >= 3) { Delivery_Approval = 1; } else { Delivery_Approval = -1; } Deliveryman deliveryman = new Deliveryman(); var deliverymen = ManagerViewModel.GetDeliverymen(); for (int j = 0; j < deliverymen.Count; j++) { if (deliverymen[j].ID == DeliverymanID) { deliveryman = deliverymen[j]; } } if (Rating >= 3) { Approval = 1; } else { Approval = -1; } Chef chef = new Chef(); var ChefList = ManagerViewModel.GetChefs(); for (int i = 0; i < ChefList.Count; i++) { if (ChefList[i].ID == ChefID) { chef = ChefList[i]; } } if (isVVIP == 1) { Approval *= 2; Delivery_Approval *= 2; } chef.Approval += Approval; deliveryman.Approval += Delivery_Approval; using (MySqlConnection conn = new MySqlConnection(ConfigurationManager.ConnectionStrings["DB"].ConnectionString)) { DataTable dt = new DataTable(); using (MySqlCommand cmd = new MySqlCommand("UpdateChefApproval", conn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("ChefID", ChefID); cmd.Parameters.AddWithValue("Approval", chef.Approval); conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); } } using (MySqlConnection conn = new MySqlConnection(ConfigurationManager.ConnectionStrings["DB"].ConnectionString)) { DataTable dt = new DataTable(); using (MySqlCommand cmd = new MySqlCommand("UpdateDeliverymanApproval", conn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("DeliverymanID", DeliverymanID); cmd.Parameters.AddWithValue("Approval", deliveryman.Approval); conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); } } using (MySqlConnection conn = new MySqlConnection(ConfigurationManager.ConnectionStrings["DB"].ConnectionString)) { DataTable dt = new DataTable(); using (MySqlCommand cmd = new MySqlCommand("UserSubmitReview", conn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("UserID", UserID); cmd.Parameters.AddWithValue("ItemID", ItemID); cmd.Parameters.AddWithValue("ChefID", ChefID); cmd.Parameters.AddWithValue("Rating", Rating); cmd.Parameters.AddWithValue("Approval", Approval); cmd.Parameters.AddWithValue("Comment", Comment); conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); } } }