public ManagerWelcomePageModel GetManagerWelcomePageModel(HttpSessionStateBase session)
{
ManagerWelcomePageModel model = new ManagerWelcomePageModel();
model.AdjustmentWPC = new List <AdjustmentWelcomePageComponent>();
foreach (Adjustment adj in db.Adjustments)
{
if (adj.status == "Submitted" && adj.needAuthority == session["EmployeeID"].ToString())
{
AdjustmentWelcomePageComponent adjWPC = new AdjustmentWelcomePageComponent();
adjWPC.AdjustmentID = adj.voucherId;
adjWPC.AdjustmentDate = adj.date.ToShortDateString();
adjWPC.AdjustmentCreator = adj.clerk;
adjWPC.AdjustmentStatus = adj.status;
model.AdjustmentWPC.Add(adjWPC);
}
}
return(model);
}
public ClerkWelcomePageModel GetClerkWelcomePageModel(HttpSessionStateBase session)
{
Dictionary <string, string> emplist = (Dictionary <string, string>)session["EmployeeList"];
ClerkWelcomePageModel model = new ClerkWelcomePageModel();
model.AdjustmentWPC = new List <AdjustmentWelcomePageComponent>();
model.DisbursementWPC = new List <DisbursementWelcomePageComponent>();
model.RequisitionWPC = new List <RequisitionWelcomePageComponent>();
model.RetrievalWPC = new List <RetrievalWelcomePageComponent>();
model.StockWPC = GetLowStockLevels();
foreach (Requisition req in db.Requisitions)
{
if (req.status == "Approved")
{
RequisitionWelcomePageComponent reqWPC = new RequisitionWelcomePageComponent();
reqWPC.RequisitionID = req.requisitionId;
reqWPC.RequisitionCreator = req.employee;
reqWPC.RequisitionStatus = req.status;
reqWPC.RequisitionApproveDate = req.approvalDate == null? null : req.approvalDate.ToString();
model.RequisitionWPC.Add(reqWPC);
}
}
foreach (Retrieval ret in db.Retrievals)
{
if (ret.status == "Pending")
{
RetrievalWelcomePageComponent retWPC = new RetrievalWelcomePageComponent();
retWPC.RetrievalID = ret.retrievalId;
retWPC.RetrievalCreationDate = ret.retrievalCreationDate.ToShortDateString();
retWPC.RetrievalCreator = ret.clerkId;
retWPC.RetrievalStatus = ret.status;
model.RetrievalWPC.Add(retWPC);
}
}
foreach (Disbursement disburse in db.Disbursements)
{
if (disburse.status == "Awaiting Collection")
{
DisbursementWelcomePageComponent disWPC = new DisbursementWelcomePageComponent();
disWPC.DisbursementID = disburse.disbursementId;
disWPC.DisbursementStatus = disburse.status;
disWPC.DisbursementCreationDate = disburse.disburseDate == null ? null: disburse.disburseDate.ToString();
disWPC.DisbursementRep = disburse.repID != null ? emplist[disburse.repID] : null;
Requisition requisitionDis = db.Requisitions.Where(x => x.disbursementId == disburse.disbursementId).FirstOrDefault();
if (requisitionDis != null)
{
disWPC.DisbursementDept = requisitionDis.departmentId;
disWPC.DisbursementRetID = requisitionDis.retrievalId;
Retrieval retDis = db.Retrievals.Find(requisitionDis.retrievalId);
if (retDis != null)
{
disWPC.DisbursementCreator = retDis.clerkId;
}
disWPC.DisburementCollectionPoint = db.DeptCollectionDetails.Find(disWPC.DisbursementDept).collectionPoint;
DateTime today = DateTime.Today;
if (today.DayOfWeek == DayOfWeek.Monday)
{
disWPC.DisbursementCollectDate = "Collection is today, " + today.ToString("dddd, dd MMMM yyyy");
}
else if (today.DayOfWeek == DayOfWeek.Sunday)
{
disWPC.DisbursementCollectDate = "Collection is tomorrow, " + today.ToString("dddd, dd MMMM yyyy");
}
else
{
int startInt = 8;
int daysToCome = startInt - (int)today.DayOfWeek;
disWPC.DisbursementCollectDate = "Collection is in " + daysToCome + " more days, on " + today.ToString("dddd, dd MMMM yyyy");
}
}
model.DisbursementWPC.Add(disWPC);
}
}
foreach (Adjustment adj in db.Adjustments)
{
if (adj.status == "Submitted" & adj.clerk == session["EmployeeID"].ToString())
{
AdjustmentWelcomePageComponent adjWPC = new AdjustmentWelcomePageComponent();
adjWPC.AdjustmentID = adj.voucherId;
adjWPC.AdjustmentDate = adj.date.ToShortDateString();
adjWPC.AdjustmentCreator = adj.clerk;
adjWPC.AdjustmentStatus = adj.status;
model.AdjustmentWPC.Add(adjWPC);
}
}
return(model);
}
