public JsonResult GetReport(DateTime Start, DateTime Finish) { using (my_testContext db = new my_testContext()) { DateTime start = DateTime.Now; var md = Config.instance .zones .Select((z, idx) => new ZoneReport { Num = idx + 1, zone_name = z.zone_name, BriketCount = db.ObjectTrack .Where(r => r.X >= z.x1 && r.X <= z.x2 && r.CrtDate >= Start && r.CrtDate <= Finish) .Select(a => a.ObjectId) .Distinct() .Count() }) .ToArray(); DateTime finish = DateTime.Now; return(Json(new { zones = md, query_time = (finish - start).Milliseconds })); } }
public IActionResult Index() { using (my_testContext db = new my_testContext()) { DateTime Start_Date = db.ObjectTrack .Min(a => a.CrtDate), Finish_Date = db.ObjectTrack .Max(a => a.CrtDate) .AddMinutes(1); //DateTime.Now; return(View(new Init_params { start_dt = Start_Date, finish_dt = Finish_Date })); } }