public ActionResult Chefs() { return(View(ManagerViewModel.GetChefs())); }
public ActionResult Login(Login l) { DataSet ds; List <Login> Users = new List <Login>(); using (MySqlConnection conn = new MySqlConnection(ConfigurationManager.ConnectionStrings["DB"].ConnectionString)) { ds = MySqlHelper.ExecuteDataset(conn, "GetUsers"); } foreach (DataRow row in ds.Tables[0].Rows) { Login u = new Login(); u.Username = row["username"].ToString(); u.ID = (int)row["ID"]; u.Password = row["password"].ToString(); u.isVerified = (bool)row["is_verified"]; u.isVIP = (bool)row["is_VIP"]; u.isSuspended = Convert.ToBoolean(row["is_suspended"]); Users.Add(u); } var Chefs = ManagerViewModel.GetChefs(); var user = Users.Where(x => x.Username.Equals(l.Username) && x.Password.Equals(l.Password)).FirstOrDefault(); if (user == null) { var chef = Chefs.Where(x => x.Username.Equals(l.Username) && x.Password.Equals(l.Password)).FirstOrDefault(); if (chef != null) { FormsAuthentication.SetAuthCookie(chef.Username, true); return(RedirectToAction("Menu", "Admin/Chef")); } else if (l.Username == "Manager" && l.Password == "theboss") { FormsAuthentication.SetAuthCookie(l.Username, true); return(RedirectToAction("Users", "Admin/Manager")); } } if (user != null && user.isSuspended) { ModelState.AddModelError("Password", "Your account has been suspended and your balance has been emptied."); return(View()); } if (user != null && user.isVerified) { FormsAuthentication.SetAuthCookie(user.Username, true); return(RedirectToAction("MyMenu", "Home", new { ID = user.ID })); } if (user != null && !user.isVerified) { ModelState.AddModelError("Password", "A manager has not verified your account yet. Please wait 3-5 business days."); return(View()); } ModelState.Remove("Password"); ModelState.AddModelError("Password", "The username or password is incorrect."); return(View()); }
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(); } } }