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