public ActionResult ShowMonthlySummary() { try { MonthlySummaryViewModel monthlysummary = new MonthlySummaryViewModel(); MontlyBusReport obj = new MontlyBusReport(); obj = BusinessAccessLayer.BALSupport.BALGetVivraniReports(19, DateTime.Now.Date); // monthlysummary.monthlyreport.VivraniSum = monthlysummary.monthlyreport.lstVivraniReports.Sum(m => m.Amount); return(PartialView(@"~/Views\\Reports\_MainSummary.cshtml", obj)); } catch (Exception ex) { throw; } }
public static MontlyBusReport GetVivraniReports(int busnumber, int month, int year) { MontlyBusReport montllybusreoprt = new MontlyBusReport(); List <VivraniReports> lstreports = new List <VivraniReports>(); List <FuleReopts> lstfule = new List <FuleReopts>(); using (var item = new GMOUMISEntity()) { lstreports = (from r in item.tmp_cashvivrani where r.bus_number == busnumber && r.vivrani_inserted_date.Month == month && r.vivrani_inserted_date.Year == year group r by new { r.cash_vivrani_id, r.vivrani_inserted_date } into g select new VivraniReports { VivraniNumber = g.Key.cash_vivrani_id, VivraniDate = g.Key.vivrani_inserted_date, Amount = g.Sum(m => m.amount) }).ToList(); // lstreports = item.tmp_cashvivrani.Where(m => m.bus_number == busnumber && m.vivrani_inserted_date.Month == month && m.vivrani_inserted_date.Year == year).GroupBy(m => m.cash_vivrani_id).Select(ml => new VivraniReports { Amount = ml.Sum(c => c.amount), VivraniNumber = ml.First().cash_vivrani_id }).ToList(); montllybusreoprt.lstVivraniReports = lstreports; var data = (from r in item.tbl_ChitFuel where r.vechilenumber == busnumber && r.inserteddate.Value.Month == month && r.inserteddate.Value.Year == year group r by new { r.dieselchitno } into g select new FuleReopts { ChitNumber = g.Key.dieselchitno, FuleDate = g.Select(m => m.inserteddate.Value).FirstOrDefault(), Amount = g.Sum(m => m.price) }).ToList(); montllybusreoprt.lstFuleReposrts = data; } try { using (var item = new GMOUMISEntity()) { var data = (from b in item.tblBus join bd in item.tblBusDetails on b.busid equals bd.bus_id join bo in item.tblBusOwnerDetails on b.busid equals bo.bus_id join bins in item.tblBusInsuranceDeatils on b.busid equals bins.bus_id where b.busid == 205 select new MontlyBusReport { BusNumber = b.bus_number, AccountName = "", AccountNumber = "", BankName = "", Dipo = item.tblSets.Where(m => m.setid == bd.bus_operating_center).Select(m => m.station).FirstOrDefault() }).FirstOrDefault(); montllybusreoprt.BusNumber = data.BusNumber; montllybusreoprt.Dipo = data.Dipo; } } catch (Exception) { throw; } // select m.bus_number,k.bus_owner_name, (select station from dbo.tblSets where setid=l.bus_operating_center) as Station //from dbo.tblBus m join dbo.tblBusOwnerDetails K on ( m.busid=K.bus_id) join //dbo.tblBusDetails l on ( m.busid=l.bus_id) //where m.busid=205 return(montllybusreoprt); }