public ActionResult DocsDashBoard()
{
using (var dbContext = new SCMSEntities())
{
DocsDashBoard model = new DocsDashBoard();
model.OrCreated = dbContext.OrderRequests.Count(p => p.CountryProgrammeId == countryProg.Id);
model.OrApproved = dbContext.OrderRequests.Count(p => p.IsReviewed == true && p.IsAuthorized == false && p.CountryProgrammeId == countryProg.Id);
model.OrOngoing = dbContext.OrderRequests.Count(p => p.IsAuthorized == true && p.CountryProgrammeId == countryProg.Id);
if (dbContext.OrderRequests.Count(p => p.CountryProgrammeId == countryProg.Id) > 0)
{
model.OrTotalValue = (decimal)dbContext.OrderRequests.Where(q => q.IsAuthorized == true && q.CountryProgrammeId == countryProg.Id).Sum(p => p.TotalAmount);
}
model.TaTotalValue = 0;
model.PoCreated = dbContext.PurchaseOrders.Count(p => p.CountryProgrammeId == countryProg.Id);
model.PoApproved = dbContext.PurchaseOrders.Count(p => p.IsApproved && p.CountryProgrammeId == countryProg.Id);
model.PoOngoing = dbContext.PurchaseOrders.Count(p => p.IsApproved && p.CountryProgrammeId == countryProg.Id);
if (dbContext.PurchaseOrders.Count(p => p.CountryProgrammeId == countryProg.Id && p.IsApproved == true) > 0)
{
model.PoTotalValue = (decimal)dbContext.PurchaseOrders.Where(q => q.IsApproved == true && q.CountryProgrammeId == countryProg.Id).Sum(p => p.TotalAmount);
}
return(View(model));
}
}
public ActionResult MasterBDashBoard()
{
using (var dbContext = new SCMSEntities())
{
DocsDashBoard model = new DocsDashBoard();
model.OrCreated = dbContext.OrderRequests.Count();
model.OrApproved = dbContext.OrderRequests.Count(p => p.IsReviewed == true && p.IsAuthorized == false);
model.OrOngoing = dbContext.OrderRequests.Count(p => p.IsAuthorized == true);
model.OrTotalValue = (decimal)dbContext.OrderRequests.Where(q => q.IsAuthorized == true).Sum(p => p.TotalAmount);
model.PoCreated = dbContext.PurchaseOrders.Count();
model.PoApproved = dbContext.PurchaseOrders.Count(p => p.IsApproved);
model.PoOngoing = dbContext.PurchaseOrders.Count(p => p.IsApproved);
return(View(model));
}
}
