// GET: CostReport
public ActionResult Index(FormCollection collection)
{
DateTime date_start = (collection["date_start"] == null) ? DateTime.Now : Convert.ToDateTime(collection["date_start"]);
DateTime date_end = (collection["date_end"] == null) ? DateTime.Now : Convert.ToDateTime(collection["date_end"]);
ViewBag.date_start = "" + (date_start.Day < 10 ? "0" : "") + date_start.Day + "." + (date_start.Month < 10 ? "0" : "") + date_start.Month + "." + date_start.Year;
ViewBag.date_end = "" + (date_end.Day < 10 ? "0" : "") + date_end.Day + "." + (date_end.Month < 10 ? "0" : "") + date_end.Month + "." + date_end.Year;
var reportdata = db.get_cost_report(date_start, date_end);
//var reportdata = db.ViewРасходГСМ.Where(x => x.Дата_рейса > date_start && x.Дата_рейса < date_end);
//reportdata = reportdata.OrderBy(x => x.Дата_рейса);
double sum3 = 0;
double sum4 = 0;
double sum5 = 0;
foreach (Putilin2018.Models.get_cost_report_Result x in reportdata)
{
sum3 += (double)x.fuel_paid;
sum4 += (double)x.repair_paid;
sum5 += (double)x.total_paid;
}
ViewBag.sum3 = sum3;
ViewBag.sum4 = sum4;
ViewBag.sum5 = sum5;
reportdata.OrderBy(x => x.groupname);
return(View(reportdata.ToList().OrderBy(x => x.groupname)));
}
