public JsonResult Table(dtParam param) { var query = db.Orders.AsNoTracking(); Models.DataTableModel.dtOrder res = new Models.DataTableModel.dtOrder(); res.data = res.GetData(param, query); res.draw = param.Draw; res.recordsTotal = query.Count(); res.recordsFiltered = res.Count(param, query); return(Json(res)); }
public JsonResult ReportData(dtParam param) { var query = db.Orders.AsNoTracking().Where(s => s.OrderDate <= param.repEnd && s.OrderDate >= param.repStart); Models.DataTableModel.dtOrder res = new Models.DataTableModel.dtOrder(); res.data = res.GetData(param, query); res.draw = param.Draw; res.recordsTotal = db.Orders.AsNoTracking().Count(); res.recordsFiltered = res.Count(param, query); return(Json(res)); }