public ActionResult Restock(FormCollection forms) { if (forms is null) { throw new ArgumentNullException(nameof(forms)); } try { SqlConnection sqlConnection = new SqlConnection(CustomerController.connectionString); sqlConnection.Open(); SqlCommand sqlCommand = new SqlCommand("update Foods set FoodQty = FoodQty + " + forms["FoodQty"].ToString() + " where FoodId = " + forms["FoodId"].ToString() + ";", sqlConnection); SqlCommand sqlModifyDate = new SqlCommand("update Menus set MenuModifyDate = '" + DateTime.Now.ToString() + "' where MenuId = " + Session["AdminMenuId"].ToString() + ";", sqlConnection); sqlCommand.ExecuteNonQuery(); sqlModifyDate.ExecuteNonQuery(); sqlConnection.Close(); ViewBag.Status = "Restock"; return(View(foodContext.Foods.Find(long.Parse(forms["FoodId"].ToString())))); } catch (Exception e) { string exceptionMessage = DateTime.Now + " ActionResult : " + Request.RequestContext.RouteData.Values["action"].ToString() + "Exception : " + e.Message.ToString(); AdminAuthController.WriteExceptionToFile(exceptionMessage, out string fileExceptionMessage); return(Content(exceptionMessage + "\n" + fileExceptionMessage)); } }
public ActionResult AdminHome(List <Food> FoodList, FormCollection forms) { try { bool menuAvailable = bool.Parse(forms["MenuAvailable"].ToString()); long menuId = long.Parse(Session["AdminMenuId"].ToString()); List <Menu> MenuList = (from menu in foodContext.Menus where menu.MenuAvailable == menuAvailable where menu.MenuId == menuId select menu).ToList(); foreach (Menu m in MenuList) { m.MenuAvailable = !menuAvailable; } foodContext.SaveChanges(); Menu menuFound = foodContext.Menus.Find(Session["AdminMenuId"]); FoodList = (from food in foodContext.Foods where menuFound.MenuId == food.FoodMenuId && food.FoodQty < 50 orderby 1 select food).ToList(); return(View(FoodList)); } catch (Exception e) { string exceptionMessage = DateTime.Now + " ActionResult : " + Request.RequestContext.RouteData.Values["action"].ToString() + "Exception : " + e.Message.ToString(); AdminAuthController.WriteExceptionToFile(exceptionMessage, out string fileExceptionMessage); return(Content(exceptionMessage + "\n" + fileExceptionMessage)); } }
public ActionResult Graph() { try { return(Json(Result(), JsonRequestBehavior.AllowGet)); } catch (Exception e) { string exceptionMessage = DateTime.Now + " ActionResult : " + Request.RequestContext.RouteData.Values["action"].ToString() + "Exception : " + e.Message.ToString(); AdminAuthController.WriteExceptionToFile(exceptionMessage, out string fileExceptionMessage); return(Content(exceptionMessage + "\n" + fileExceptionMessage)); } }
public ActionResult DeleteItem(long foodId) { try { Food food = foodContext.Foods.Find(foodId); return(View(food)); } catch (Exception e) { string exceptionMessage = DateTime.Now + " ActionResult : " + Request.RequestContext.RouteData.Values["action"].ToString() + "Exception : " + e.Message.ToString(); AdminAuthController.WriteExceptionToFile(exceptionMessage, out string fileExceptionMessage); return(Content(exceptionMessage + "\n" + fileExceptionMessage)); } }
public ActionResult RestockItems() { try { Menu menu = foodContext.Menus.Find(Session["AdminMenuId"]); List <Food> FoodList = (from food in foodContext.Foods where menu.MenuId == food.FoodMenuId select food).ToList(); return(View(FoodList)); } catch (Exception e) { string exceptionMessage = DateTime.Now + " ActionResult : " + Request.RequestContext.RouteData.Values["action"].ToString() + "Exception : " + e.Message.ToString(); AdminAuthController.WriteExceptionToFile(exceptionMessage, out string fileExceptionMessage); return(Content(exceptionMessage + "\n" + fileExceptionMessage)); } }
public ActionResult AddNewItems(Food food) { try { food.FoodMenuId = long.Parse(Session["AdminMenuId"].ToString()); IList <Food> FoodList = (from foods in foodContext.Foods where food.FoodName == foods.FoodName select foods).ToList(); bool foodExists = false; foreach (Food foodSearch in FoodList) { if (foodSearch.FoodName == food.FoodName) { foodExists = true; break; } } if (foodExists || food.FoodName == null || food.FoodQty == 0 || food.FoodUnitPrice == 0 || food.FoodCategory == null || food.FoodType == null || food.FoodPhotoUrl == null) { ViewBag.Status = "FoodInvalid"; return(View("AddNewItems", food)); } else if (!foodExists) { foodContext.Foods.Add(food); if (ModelState.IsValid && foodContext.SaveChanges() > 0) { ViewBag.Status = "FoodRegistered"; return(View("AddNewItems", food)); } } else { ViewBag.Status = "FoodExists"; return(View("AddNewItems", food)); } return(View(food)); } catch (Exception e) { string exceptionMessage = DateTime.Now + " ActionResult : " + Request.RequestContext.RouteData.Values["action"].ToString() + "Exception : " + e.Message.ToString(); AdminAuthController.WriteExceptionToFile(exceptionMessage, out string fileExceptionMessage); return(Content(exceptionMessage + "\n" + fileExceptionMessage)); } }
public ActionResult DeleteItem(FormCollection form) { try { long foodId = long.Parse(form["FoodId"].ToString()); Food food = foodContext.Foods.Find(foodId); foodContext.Foods.Remove(food); foodContext.SaveChanges(); return(View()); } catch (Exception e) { string exceptionMessage = DateTime.Now + " ActionResult : " + Request.RequestContext.RouteData.Values["action"].ToString() + "Exception : " + e.Message.ToString(); AdminAuthController.WriteExceptionToFile(exceptionMessage, out string fileExceptionMessage); return(Content(exceptionMessage + "\n" + fileExceptionMessage)); } }
public ActionResult AddNewItems() { try { Food food = new Food(); if (food.FoodName != null) { return(View("AddNewItems", food)); } return(View(food)); } catch (Exception e) { string exceptionMessage = DateTime.Now + " ActionResult : " + Request.RequestContext.RouteData.Values["action"].ToString() + "Exception : " + e.Message.ToString(); AdminAuthController.WriteExceptionToFile(exceptionMessage, out string fileExceptionMessage); return(Content(exceptionMessage + "\n" + fileExceptionMessage)); } }
public ActionResult UpdateItem(FormCollection form) { try { long foodId = long.Parse(form["FoodId"].ToString()); string foodName = form["FoodName"].ToString(); long foodUnitPrice = long.Parse(form["FoodUnitPrice"].ToString()); string foodCategory = form["FoodCategory"].ToString(); string foodType = form["FoodType"].ToString(); string foodPhotoUrl = form["FoodPhotoUrl"].ToString(); SqlConnection sqlConnection = new SqlConnection(CustomerController.connectionString); sqlConnection.Open(); SqlCommand sqlCmd = new SqlCommand("update Foods set FoodName = '" + foodName + "', FoodUnitPrice = " + foodUnitPrice + ", FoodCategory = '" + foodCategory + "', FoodType = '" + foodType + "', FoodPhotoUrl = '" + foodPhotoUrl + "' where FoodId = " + foodId + ";", sqlConnection); sqlCmd.ExecuteNonQuery(); SqlCommand sqlCmdFetch = new SqlCommand("select * from Foods where FoodId = " + foodId + ";", sqlConnection); SqlDataReader sdr = sqlCmdFetch.ExecuteReader(); Food food = null; while (sdr.Read()) { food = new Food { FoodId = long.Parse(sdr[0].ToString()), FoodName = sdr[1].ToString(), FoodUnitPrice = long.Parse(sdr[3].ToString()), FoodCategory = sdr[4].ToString(), FoodType = sdr[5].ToString(), FoodPhotoUrl = sdr[6].ToString() }; ViewBag.Status = "updated"; } sqlConnection.Close(); return(View(food)); } catch (Exception e) { string exceptionMessage = DateTime.Now + " ActionResult : " + Request.RequestContext.RouteData.Values["action"].ToString() + "Exception : " + e.Message.ToString(); AdminAuthController.WriteExceptionToFile(exceptionMessage, out string fileExceptionMessage); return(Content(exceptionMessage + "\n" + fileExceptionMessage)); } }
// GET: Admin public ActionResult AdminHome(Admin admin) { try { Session["AdminModel"] = admin; Session["AdminFName"] = admin.AdminFName; Session["AdminId"] = admin.AdminId; Session["AdminMenuId"] = admin.AdminMenuId; Menu menu = foodContext.Menus.Find(Session["AdminMenuId"]); List <Food> FoodList = (from food in foodContext.Foods where menu.MenuId == food.FoodMenuId && food.FoodQty < 50 orderby 1 select food).ToList(); return(View(FoodList)); } catch (Exception e) { string exceptionMessage = DateTime.Now + " ActionResult : " + Request.RequestContext.RouteData.Values["action"].ToString() + "Exception : " + e.Message.ToString(); AdminAuthController.WriteExceptionToFile(exceptionMessage, out string fileExceptionMessage); return(Content(exceptionMessage + "\n" + fileExceptionMessage)); } }
public ActionResult AdminProfile(Admin admin, FormCollection form) { try { long adminId = long.Parse(form["AdminId"].ToString()); Admin currAdmin = foodContext.Admins.Find(adminId); bool validate = ValidateUniquePhoneUsername(admin, adminId); if (!validate) { ViewBag.Status = "KeyViolation"; } else { List <Admin> adminList = (from a in foodContext.Admins where a.AdminId == adminId select a).ToList(); foreach (Admin adm in adminList) { adm.AdminFName = admin.AdminFName; adm.AdminLName = admin.AdminLName; adm.AdminPhone = admin.AdminPhone; adm.AdminUsername = admin.AdminUsername; } if (ModelState.IsValid) { foodContext.SaveChanges(); } } Session["AdminModel"] = currAdmin; Session["AdminFName"] = currAdmin.AdminFName; return(View(currAdmin)); } catch (Exception e) { string exceptionMessage = DateTime.Now + " ActionResult : " + Request.RequestContext.RouteData.Values["action"].ToString() + "Exception : " + e.Message.ToString(); AdminAuthController.WriteExceptionToFile(exceptionMessage, out string fileExceptionMessage); return(Content(exceptionMessage + "\n" + fileExceptionMessage)); } }
public ActionResult AdminCustOrders() { try { SqlConnection sqlConnection = new SqlConnection(CustomerController.connectionString); sqlConnection.Open(); SqlCommand sqlCommand = new SqlCommand("SELECT DISTINCT O.OrderId, O.OrderDate, O.OrderCustId, CONCAT(C.CustFName,' ', C.CustLName) FROM ORDERS O INNER JOIN CUSTOMERS C ON O.OrderCustId = C.CustId INNER JOIN ORDERITEMS OI ON OI.OrderItemOrderId = O.OrderId INNER JOIN FOODS F ON OI.OrderItemFoodId = F.FoodId WHERE F.FoodMenuId = " + Session["AdminMenuId"].ToString() + " ORDER BY 1 DESC; ", sqlConnection); SqlDataReader sqlDataReader = sqlCommand.ExecuteReader(); List <CustOrdersModel> CustOrdersModelList = new List <CustOrdersModel>(); while (sqlDataReader.Read()) { CustOrdersModel custOrdersModel = new CustOrdersModel { CustOrderId = long.Parse(sqlDataReader[0].ToString()), CustOrderDate = DateTime.Parse(sqlDataReader[1].ToString()), CustId = long.Parse(sqlDataReader[2].ToString()), CustName = sqlDataReader[3].ToString(), CustMenuId = Session["AdminMenuId"].ToString() }; CustOrdersModelList.Add(custOrdersModel); } sqlConnection.Close(); return(View(CustOrdersModelList)); } catch (Exception e) { string exceptionMessage = DateTime.Now + " ActionResult : " + Request.RequestContext.RouteData.Values["action"].ToString() + "Exception : " + e.Message.ToString(); AdminAuthController.WriteExceptionToFile(exceptionMessage, out string fileExceptionMessage); return(Content(exceptionMessage + "\n" + fileExceptionMessage)); } }