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();
}
}
}
