public ActionResult Login(Models.Employee e) { if (ModelState.IsValid) { using (MusciToolkitDBEntities db = new MusciToolkitDBEntities()) { var obj = db.Employees.Where(a => a.EmployeeID.Equals(e.EmployeeID) && a.Password.Equals(e.Password)).FirstOrDefault(); if (obj != null) { Session["UserID"] = obj.EmployeeID.ToString(); Session["UserRole"] = obj.EmployeeRole.EmpRole.ToString(); Session["UserName"] = obj.FirstName.ToString(); Session["EmpLoginError"] = ""; Session["PassLoginError"] = ""; ViewBag.UserName = Session["UserName"]; if (Session["UserRole"].Equals("Manager")) { return View("ManagerMenu"); } else if (Session["UserRole"].Equals("Admin")) { return View("AdminView"); } else if (Session["UserRole"].Equals("Employee")) { return View("EmployeeMenu"); } } else { Models.Employee a = db.Employees.Find(e.EmployeeID); if (a == null) { Session["EmpLoginError"] = "Invalid employee ID"; Session["PassLoginError"] = ""; } else { Session["PassLoginError"] = "Invalid password"; Session["EmpLoginError"] = ""; } } } } return View(e); }
// Get a poWithItems object based on a given purchase order ID and db instance public poWithItems getOrderWithItems(int givenID, MusciToolkitDBEntities dbInstance) { var ansPO = db.PurchaseOrders.SingleOrDefault(x => x.PurchaseOrderID == givenID); var ansList = db.PurchaseOrderItems.Where(x => x.PurchaseOrderID == givenID); // Declare total line price for each PurchaseOrderItem in the list.. Shoutout to Luke!! foreach (var each in ansList) { double currLineCost = (double)each.Quantity * (double)each.Inventory.NetPrice; each.totalPrice = currLineCost; } db.SaveChanges(); var ans = new poWithItems(ansPO, ansList); poTotalSet(ans); return(ans); }
public soWithItems getOrderWithItems(int givenID, MusciToolkitDBEntities dbInstance) { var ansSO = db.Sales.SingleOrDefault(x => x.SaleID == givenID); var ansList = db.SaleItems.Where(x => x.SaleID == givenID); int currLineItem = 0; foreach (var each in ansList) { double currLineCost = each.Quantity * (double)each.Inventory.SalePrice; currLineItem += each.Quantity; each.TotalSIPrice = currLineCost; each.TotalSI = currLineItem; each.Returned = 0; } db.SaveChanges(); var ans = new soWithItems(ansSO, ansList); soTotalSet(ans); db.SaveChanges(); return(ans); }