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