public ActionResult DeleteConfirmed(string id, string sessionId) { if (sessionId == null) { return(RedirectToAction("Login", "Login")); } StoreClerk storeclerk = db.StoreClerks.Where(p => p.SessionId == sessionId).FirstOrDefault(); StoreManager storeManager = db.StoreManagers.Where(p => p.SessionId == sessionId).FirstOrDefault(); StoreSupervisor storeSupervisor = db.StoreSupervisors.Where(p => p.SessionId == sessionId).FirstOrDefault(); StationeryCatalog stationeryCatalog = db.StationeryCatalogs.Find(id); db.StationeryCatalogs.Remove(stationeryCatalog); db.SaveChanges(); if (storeclerk != null) { return(RedirectToAction("Index", "StationeryCatalogs", new { sessionId = sessionId })); } else if (storeManager != null) { return(RedirectToAction("Index", "StationeryCatalogs", new { sessionId = sessionId })); } else if (storeSupervisor != null) { return(RedirectToAction("Index", "StationeryCatalogs", new { sessionId = sessionId })); } else { return(RedirectToAction("Login", "Login")); } }
public ActionResult DeleteConfirmed(string id) { StationeryCatalog stationeryCatalog = db.StationeryCatalogs.Find(id); db.StationeryCatalogs.Remove(stationeryCatalog); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "ItemNumber,Category,Description,ReorderLevel,ReorderQuantity,UnitOfMeasure,BinNumber,Price,SupplierCode1,SupplierCode2,SupplierCode3,Balance")] StationeryCatalog stationeryCatalog) { if (ModelState.IsValid) { db.Entry(stationeryCatalog).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(stationeryCatalog)); }
// GET: StationeryCatalogReport/Delete/5 public ActionResult Delete(string id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } StationeryCatalog stationeryCatalog = db.StationeryCatalogs.Find(id); if (stationeryCatalog == null) { return(HttpNotFound()); } return(View(stationeryCatalog)); }
public ActionResult Create([Bind(Include = "ItemNumber,Category,Description,ReorderLevel,ReorderQuantity,UnitOfMeasure,BinNumber,Price,SupplierCode1,SupplierCode2,SupplierCode3,Balance")] StationeryCatalog stationeryCatalog) { if (ModelState.IsValid) { db.StationeryCatalogs.Add(stationeryCatalog); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.SupplierCode1 = new SelectList(db.SupplierLists, "SupplierCode", "SupplierName", stationeryCatalog.SupplierCode1); ViewBag.SupplierCode2 = new SelectList(db.SupplierLists, "SupplierCode", "SupplierName", stationeryCatalog.SupplierCode2); ViewBag.SupplierCode3 = new SelectList(db.SupplierLists, "SupplierCode", "SupplierName", stationeryCatalog.SupplierCode3); return(View(stationeryCatalog)); }
// GET: RequisitionReport/Edit/5 public ActionResult Edit(string id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } StationeryCatalog stationeryCatalog = db.StationeryCatalogs.Find(id); if (stationeryCatalog == null) { return(HttpNotFound()); } ViewBag.SupplierCode1 = new SelectList(db.SupplierLists, "SupplierCode", "SupplierName", stationeryCatalog.SupplierCode1); ViewBag.SupplierCode2 = new SelectList(db.SupplierLists, "SupplierCode", "SupplierName", stationeryCatalog.SupplierCode2); ViewBag.SupplierCode3 = new SelectList(db.SupplierLists, "SupplierCode", "SupplierName", stationeryCatalog.SupplierCode3); return(View(stationeryCatalog)); }
public ActionResult Create([Bind(Include = "ItemNumber,Category,Description,ReorderLevel,ReorderQuantity,UnitOfMeasure,BinNumber,Price,SupplierCode1,SupplierCode2,SupplierCode3,Balance")] StationeryCatalog stationeryCatalog, string sessionId) { if (sessionId == null) { return(RedirectToAction("Login", "Login")); } StoreClerk storeclerk = db.StoreClerks.Where(p => p.SessionId == sessionId).FirstOrDefault(); StoreManager storeManager = db.StoreManagers.Where(p => p.SessionId == sessionId).FirstOrDefault(); StoreSupervisor storeSupervisor = db.StoreSupervisors.Where(p => p.SessionId == sessionId).FirstOrDefault(); ViewBag.SupplierCode1 = new SelectList(db.SupplierLists, "SupplierCode", "SupplierName", stationeryCatalog.SupplierCode1); ViewBag.SupplierCode2 = new SelectList(db.SupplierLists, "SupplierCode", "SupplierName", stationeryCatalog.SupplierCode2); ViewBag.SupplierCode3 = new SelectList(db.SupplierLists, "SupplierCode", "SupplierName", stationeryCatalog.SupplierCode3); if (storeclerk != null) { if (ModelState.IsValid) { db.StationeryCatalogs.Add(stationeryCatalog); db.SaveChanges(); } return(RedirectToAction("Index", "StationeryCatalogs", new { sessionId = sessionId })); } else if (storeManager != null) { if (ModelState.IsValid) { db.StationeryCatalogs.Add(stationeryCatalog); db.SaveChanges(); } return(RedirectToAction("Index", "StationeryCatalogs", new { sessionId = sessionId })); } else if (storeSupervisor != null) { if (ModelState.IsValid) { db.StationeryCatalogs.Add(stationeryCatalog); db.SaveChanges(); } return(RedirectToAction("Index", "StationeryCatalogs", new { sessionId = sessionId })); } else { return(RedirectToAction("Login", "Login")); } }
public ActionResult Edit(List <RForm> commitedRetrievalForm, string sessionId) { if (sessionId == null) { return(RedirectToAction("Login", "Login")); } StoreClerk storeclerk = db.StoreClerks.Where(p => p.SessionId == sessionId).FirstOrDefault(); StoreManager storeManager = db.StoreManagers.Where(p => p.SessionId == sessionId).FirstOrDefault(); StoreSupervisor storeSupervisor = db.StoreSupervisors.Where(p => p.SessionId == sessionId).FirstOrDefault(); if (ModelState.IsValid) { List <string> departmentList = new List <string>(); int outstandingListCount = db.OutstandingLists.Count(); //update retrieval form status to "Submitted" StationeryRetrievalForm existingStationeryRetrievalForm = db.StationeryRetrievalForms.Find(commitedRetrievalForm[0].stationeryRetrievalFormDetail.FormNumber); existingStationeryRetrievalForm.Status = "Submitted"; foreach (RForm commitedFormDetail in commitedRetrievalForm) { //Update actual values into retrieval form details StationeryRetrievalFormDetail existingStationeryRetrievalFormDetail = db.StationeryRetrievalFormDetails.Find(commitedFormDetail.stationeryRetrievalFormDetail.FormDetailsNumber); existingStationeryRetrievalFormDetail.Actual = commitedFormDetail.stationeryRetrievalFormDetail.Actual; //update stationery catalog StationeryCatalog existingCatalog = db.StationeryCatalogs.Find(commitedFormDetail.stationeryRetrievalFormDetail.ItemNumber); existingCatalog.Balance -= commitedFormDetail.stationeryRetrievalFormDetail.Actual; //add the department code to our department list created above, to generate disbursement list by department below if (!departmentList.Contains(commitedFormDetail.stationeryRetrievalFormDetail.DepartmentCode)) { departmentList.Add(commitedFormDetail.stationeryRetrievalFormDetail.DepartmentCode); } //If insufficient inventory, generate a outstanding list object for each retrieval form detail if (commitedFormDetail.stationeryRetrievalFormDetail.Needed > commitedFormDetail.stationeryRetrievalFormDetail.Actual) { outstandingListCount++; OutstandingList outstandingItem = new OutstandingList { OutstandingListNumber = outstandingListCount.ToString(), RetrievalFormDetailsNumber = commitedFormDetail.stationeryRetrievalFormDetail.FormDetailsNumber, Status = "Outstanding" }; db.OutstandingLists.Add(outstandingItem); } db.SaveChanges(); } //create a single disbursement list for each department foreach (string deptCode in departmentList) { DisbursementList dl = new DisbursementList { ListNumber = (db.DisbursementLists.Count() + 1).ToString(), DepartmentCode = deptCode, Date = DateTime.Today, Status = "Pending" }; db.DisbursementLists.Add(dl); db.SaveChanges(); DepartmentList dept = db.DepartmentLists.Where(x => x.DepartmentCode == deptCode).FirstOrDefault(); string Eid = dept.RepresentativeId; Employee repo = db.Employees.Find(Eid); string emailAddress = repo.EmailAddress; string pointId = dept.CollectionPoint; CollectionPoint point = db.CollectionPoints.Find(pointId); string subject = "Your items are ready for collection"; string message = "<p>Dear " + repo.UserName + "." + "</p><br/><p>Your items are ready for collection</p><br/><p>Collection point and time: " + point.CollectionPointName + "---" + point.CollectionTime + "</p><br/><p>Stationery Management Team</p>"; util.SendEmail(emailAddress, subject, message); int disbursementListDetailsCount = db.DisbursementListDetails.Count(); foreach (RForm commitedFormDetail in commitedRetrievalForm) { if (commitedFormDetail.stationeryRetrievalFormDetail.DepartmentCode.Equals(deptCode)) { disbursementListDetailsCount++; DisbursementListDetail dld = new DisbursementListDetail { ListDetailsNumber = disbursementListDetailsCount.ToString(), ListNumber = dl.ListNumber, ItemNumber = commitedFormDetail.stationeryRetrievalFormDetail.ItemNumber, Quantity = commitedFormDetail.stationeryRetrievalFormDetail.Actual }; db.DisbursementListDetails.Add(dld); db.SaveChanges(); } } } return(RedirectToAction("Index", "StationeryRetrievalForms", new { sessionId = sessionId })); } if (storeclerk != null) { int num = db.RequisitionForms.Where(x => x.Status == "Approved").Count(); int numDisbuserment = db.DisbursementLists.Where(x => x.Status == "Pending").Count(); int numOutS = db.OutstandingLists.Where(x => x.Status == "Awaiting Goods").Count(); int numRetrive = db.StationeryRetrievalForms.Where(x => x.Status == "Pending").Count(); int numPO = db.PurchaseOrders.Where(x => x.Status == "Not Submitted").Count(); int numStock = db.StockAdjustmentVouchers.Where(x => x.Status == "Pending").Count(); ViewData["sumTotal"] = (num + numDisbuserment + numOutS + numRetrive + numPO + numStock).ToString(); ViewData["sessionId"] = storeclerk.SessionId; ViewData["username"] = storeclerk.UserName; return(View(commitedRetrievalForm)); } else if (storeManager != null) { int num = db.RequisitionForms.Where(x => x.Status == "Approved").Count(); int numDisbuserment = db.DisbursementLists.Where(x => x.Status == "Pending").Count(); int numOutS = db.OutstandingLists.Where(x => x.Status == "Awaiting Goods").Count(); int numRetrive = db.StationeryRetrievalForms.Where(x => x.Status == "Pending").Count(); int numPO = db.PurchaseOrders.Where(x => x.Status == "Not Submitted").Count(); int numStock = db.StockAdjustmentVouchers.Where(x => x.Status == "Pending").Count(); ViewData["sumTotal"] = (num + numDisbuserment + numOutS + numRetrive + numPO + numStock).ToString(); ViewData["sessionId"] = storeManager.SessionId; ViewData["username"] = storeManager.UserName; return(View(commitedRetrievalForm)); } else if (storeSupervisor != null) { int num = db.RequisitionForms.Where(x => x.Status == "Approved").Count(); int numDisbuserment = db.DisbursementLists.Where(x => x.Status == "Pending").Count(); int numOutS = db.OutstandingLists.Where(x => x.Status == "Awaiting Goods").Count(); int numRetrive = db.StationeryRetrievalForms.Where(x => x.Status == "Pending").Count(); int numPO = db.PurchaseOrders.Where(x => x.Status == "Not Submitted").Count(); int numStock = db.StockAdjustmentVouchers.Where(x => x.Status == "Pending").Count(); ViewData["sumTotal"] = (num + numDisbuserment + numOutS + numRetrive + numPO + numStock).ToString(); ViewData["sessionId"] = storeSupervisor.SessionId; ViewData["username"] = storeSupervisor.UserName; return(View(commitedRetrievalForm)); } else { return(RedirectToAction("Login", "Login")); } }
public JsonResult PostRetrieval(Retrieval Details) { List <RetrievalItem> cc = JsonConvert.DeserializeObject <List <RetrievalItem> >(Details.RetData[0]); if (ModelState.IsValid) { List <string> departmentList = new List <string>(); int outstandingListCount = db.OutstandingLists.Count(); //update retrieval form status to "Submitted" StationeryRetrievalForm existingStationeryRetrievalForm = db.StationeryRetrievalForms.Find(cc[0].FormNumber); existingStationeryRetrievalForm.Status = "Submitted"; foreach (RetrievalItem commitedFormDetail in cc) { //Update actual values into retrieval form details StationeryRetrievalFormDetail existingStationeryRetrievalFormDetail = db.StationeryRetrievalFormDetails.Find(commitedFormDetail.FormDetailsnumber); existingStationeryRetrievalFormDetail.Actual = Convert.ToInt32(commitedFormDetail.Actual); //update stationery catalog StationeryCatalog existingCatalog = db.StationeryCatalogs.Find(commitedFormDetail.ItemNumber); existingCatalog.Balance -= Convert.ToInt32(commitedFormDetail.Actual); //add the department code to our department list created above, to generate disbursement list by department below if (!departmentList.Contains(commitedFormDetail.Dept)) { departmentList.Add(commitedFormDetail.Dept); } //If insufficient inventory, add the item code to our item code list created above, so that we can generate a Outstanding List by item code if (Convert.ToInt32(commitedFormDetail.Needed) > Convert.ToInt32(commitedFormDetail.Actual)) { outstandingListCount++; OutstandingList outstandingItem = new OutstandingList { OutstandingListNumber = outstandingListCount.ToString(), RetrievalFormDetailsNumber = commitedFormDetail.FormDetailsnumber, Status = "Outstanding" }; db.OutstandingLists.Add(outstandingItem); } db.SaveChanges(); } //create a single disbursement list for each department foreach (string deptCode in departmentList) { DisbursementList dl = new DisbursementList { ListNumber = (db.DisbursementLists.Count() + 1).ToString(), DepartmentCode = deptCode, Date = DateTime.Today, Status = "Pending" }; db.DisbursementLists.Add(dl); db.SaveChanges(); DepartmentList dept = db.DepartmentLists.Where(x => x.DepartmentCode == deptCode).FirstOrDefault(); string Eid = dept.RepresentativeId; Employee repo = db.Employees.Find(Eid); string emailAddress = repo.EmailAddress; string pointId = dept.CollectionPoint; CollectionPoint point = db.CollectionPoints.Find(pointId); string subject = "Your items are ready for collection"; string message = "<p>Dear " + repo.UserName + "." + "</p><br/><p>Your items are ready for collection</p><br/><p>Collection point and time: " + point.CollectionPointName + "---" + point.CollectionTime + "</p><br/><p>Stationery Management Team</p>"; util.SendEmail(emailAddress, subject, message); int disbursementListDetailsCount = db.DisbursementListDetails.Count(); foreach (RetrievalItem commitedFormDetail in cc) { if (commitedFormDetail.Dept.Equals(deptCode)) { disbursementListDetailsCount++; DisbursementListDetail dld = new DisbursementListDetail { ListDetailsNumber = disbursementListDetailsCount.ToString(), ListNumber = dl.ListNumber, ItemNumber = commitedFormDetail.ItemNumber, Quantity = Convert.ToInt32(commitedFormDetail.Actual) }; db.DisbursementListDetails.Add(dld); db.SaveChanges(); } } } } return(Json(new { status = "success" })); }
// GET: StationeryCatalogs/Details/5 public ActionResult Details(string id, string sessionId) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } if (sessionId == null) { return(RedirectToAction("Login", "Login")); } StoreClerk storeclerk = db.StoreClerks.Where(p => p.SessionId == sessionId).FirstOrDefault(); StoreManager storeManager = db.StoreManagers.Where(p => p.SessionId == sessionId).FirstOrDefault(); StoreSupervisor storeSupervisor = db.StoreSupervisors.Where(p => p.SessionId == sessionId).FirstOrDefault(); List <StockAdjustmentVoucher> stockAdjustmentVouchers = db.StockAdjustmentVouchers.ToList(); List <StockAdjustmentVoucherDetail> stockAdjustmentVoucherDetails = db.StockAdjustmentVoucherDetails.ToList(); var adjustJoinResult = (from savd in stockAdjustmentVoucherDetails join sav in stockAdjustmentVouchers on savd.AdjustmentVoucherNumber equals sav.AdjustmentVoucherNumber into table1 from sav in table1.ToList() select new RetrievalHistory { date = sav.Date, name = ("Stock Adjustment" + " " + sav.AdjustmentVoucherNumber), quantity = (int)savd.QuantityAdjusted, stockAdjustmentVoucherDetail = savd }).Where(x => x.stockAdjustmentVoucherDetail.ItemNumber == id && x.stockAdjustmentVoucherDetail.StockAdjustmentVoucher.Status == "Approved"); List <StationeryRetrievalFormDetail> stationeryRetrievalFormDetails = db.StationeryRetrievalFormDetails.ToList(); List <StationeryRetrievalForm> stationeryRetrievalForms = db.StationeryRetrievalForms.ToList(); List <DepartmentList> departmentLists = db.DepartmentLists.ToList(); var retrievalJoinResult = (from srf in stationeryRetrievalForms join srfd in stationeryRetrievalFormDetails on srf.FormNumber equals srfd.FormNumber into table1 from srfd in table1.ToList() join d in departmentLists on srfd.DepartmentCode equals d.DepartmentCode into table2 from d in table2.ToList() select new RetrievalHistory { date = srf.Date, name = d.DepartmentName, quantity = (int)srfd.Actual * -1, stationeryRetrievalFormDetail = srfd }).Where(x => x.stationeryRetrievalFormDetail.ItemNumber == id); List <PurchaseOrder> purchaseOrders = db.PurchaseOrders.ToList(); List <PurchaseOrderDetail> purchaseOrderDetails = db.PurchaseOrderDetails.ToList(); List <SupplierList> suppliers = db.SupplierLists.ToList(); var purchaseJoinResult = (from pod in purchaseOrderDetails join p in purchaseOrders on pod.PONumber equals p.PONumber into table1 from p in table1.ToList() join s in suppliers on p.SupplierCode equals s.SupplierCode into table2 from s in table2.ToList() select new RetrievalHistory { // result selector date = p.ReceivedDate, name = s.SupplierName, quantity = (int)pod.Quantity, purchaseOrderDetail = pod }).Where(x => x.purchaseOrderDetail.ItemNumber == id); var unionRetrievalPurchase = retrievalJoinResult.Concat(purchaseJoinResult); var unionRetrievalPurchaseAdjust = unionRetrievalPurchase.Concat(adjustJoinResult); var sortedResult = from u in unionRetrievalPurchaseAdjust orderby u.date select u; ViewBag.history = sortedResult; StationeryCatalog stationeryCatalog = db.StationeryCatalogs.Find(id); if (stationeryCatalog == null && sessionId != null) { return(HttpNotFound()); } //lxl-126-149 if (storeclerk != null) { int num = db.RequisitionForms.Where(x => x.Status == "Approved").Count(); int numDisbuserment = db.DisbursementLists.Where(x => x.Status == "Pending").Count(); int numOutS = db.OutstandingLists.Where(x => x.Status == "Awaiting Goods").Count(); int numRetrive = db.StationeryRetrievalForms.Where(x => x.Status == "Pending").Count(); int numPO = db.PurchaseOrders.Where(x => x.Status == "Not Submitted").Count(); int numStock = db.StockAdjustmentVouchers.Where(x => x.Status == "Pending").Count(); ViewData["sumTotal"] = (num + numDisbuserment + numOutS + numRetrive + numPO + numStock).ToString(); ViewData["sessionId"] = storeclerk.SessionId; ViewData["username"] = storeclerk.UserName; ViewData["tag"] = "storeclerk"; return(View(stationeryCatalog)); } else if (storeManager != null) { int num = db.RequisitionForms.Where(x => x.Status == "Approved").Count(); int numDisbuserment = db.DisbursementLists.Where(x => x.Status == "Pending").Count(); int numOutS = db.OutstandingLists.Where(x => x.Status == "Awaiting Goods").Count(); int numRetrive = db.StationeryRetrievalForms.Where(x => x.Status == "Pending").Count(); int numPO = db.PurchaseOrders.Where(x => x.Status == "Not Submitted").Count(); int numStock = db.StockAdjustmentVouchers.Where(x => x.Status == "Pending").Count(); ViewData["sumTotal"] = (num + numDisbuserment + numOutS + numRetrive + numPO + numStock).ToString(); ViewData["sessionId"] = storeManager.SessionId; ViewData["username"] = storeManager.UserName; ViewData["tag"] = "storeManager"; return(View(stationeryCatalog)); } else if (storeSupervisor != null) { int num = db.RequisitionForms.Where(x => x.Status == "Approved").Count(); int numDisbuserment = db.DisbursementLists.Where(x => x.Status == "Pending").Count(); int numOutS = db.OutstandingLists.Where(x => x.Status == "Awaiting Goods").Count(); int numRetrive = db.StationeryRetrievalForms.Where(x => x.Status == "Pending").Count(); int numPO = db.PurchaseOrders.Where(x => x.Status == "Not Submitted").Count(); int numStock = db.StockAdjustmentVouchers.Where(x => x.Status == "Pending").Count(); ViewData["sumTotal"] = (num + numDisbuserment + numOutS + numRetrive + numPO + numStock).ToString(); ViewData["sessionId"] = storeSupervisor.SessionId; ViewData["username"] = storeSupervisor.UserName; ViewData["tag"] = "storeSupervisor"; return(View(stationeryCatalog)); } else { return(RedirectToAction("Login", "Login")); } }
// GET: StationeryCatalogs/Delete/5 public ActionResult Delete(string id, string sessionId) { if (sessionId == null) { return(RedirectToAction("Login", "Login")); } StoreClerk storeclerk = db.StoreClerks.Where(p => p.SessionId == sessionId).FirstOrDefault(); StoreManager storeManager = db.StoreManagers.Where(p => p.SessionId == sessionId).FirstOrDefault(); StoreSupervisor storeSupervisor = db.StoreSupervisors.Where(p => p.SessionId == sessionId).FirstOrDefault(); if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } StationeryCatalog stationeryCatalog = db.StationeryCatalogs.Find(id); if (stationeryCatalog == null) { return(HttpNotFound()); } if (storeclerk != null) { int num = db.RequisitionForms.Where(x => x.Status == "Approved").Count(); int numDisbuserment = db.DisbursementLists.Where(x => x.Status == "Pending").Count(); int numOutS = db.OutstandingLists.Where(x => x.Status == "Awaiting Goods").Count(); int numRetrive = db.StationeryRetrievalForms.Where(x => x.Status == "Pending").Count(); int numPO = db.PurchaseOrders.Where(x => x.Status == "Not Submitted").Count(); int numStock = db.StockAdjustmentVouchers.Where(x => x.Status == "Pending").Count(); ViewData["sumTotal"] = (num + numDisbuserment + numOutS + numRetrive + numPO + numStock).ToString(); ViewData["sessionId"] = storeclerk.SessionId; ViewData["username"] = storeclerk.UserName; ViewData["tag"] = "storeclerk"; return(View(stationeryCatalog)); } else if (storeManager != null) { int num = db.RequisitionForms.Where(x => x.Status == "Approved").Count(); int numDisbuserment = db.DisbursementLists.Where(x => x.Status == "Pending").Count(); int numOutS = db.OutstandingLists.Where(x => x.Status == "Awaiting Goods").Count(); int numRetrive = db.StationeryRetrievalForms.Where(x => x.Status == "Pending").Count(); int numPO = db.PurchaseOrders.Where(x => x.Status == "Not Submitted").Count(); int numStock = db.StockAdjustmentVouchers.Where(x => x.Status == "Pending").Count(); ViewData["sumTotal"] = (num + numDisbuserment + numOutS + numRetrive + numPO + numStock).ToString(); ViewData["sessionId"] = storeManager.SessionId; ViewData["username"] = storeManager.UserName; ViewData["tag"] = "storeManager"; return(View(stationeryCatalog)); } else if (storeSupervisor != null) { int num = db.RequisitionForms.Where(x => x.Status == "Approved").Count(); int numDisbuserment = db.DisbursementLists.Where(x => x.Status == "Pending").Count(); int numOutS = db.OutstandingLists.Where(x => x.Status == "Awaiting Goods").Count(); int numRetrive = db.StationeryRetrievalForms.Where(x => x.Status == "Pending").Count(); int numPO = db.PurchaseOrders.Where(x => x.Status == "Not Submitted").Count(); int numStock = db.StockAdjustmentVouchers.Where(x => x.Status == "Pending").Count(); ViewData["sumTotal"] = (num + numDisbuserment + numOutS + numRetrive + numPO + numStock).ToString(); ViewData["sessionId"] = storeSupervisor.SessionId; ViewData["username"] = storeSupervisor.UserName; ViewData["tag"] = "storeSupervisor"; return(View(stationeryCatalog)); } else { return(RedirectToAction("Login", "Login")); } }