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