public async Task <ActionResult> GetReports() { try { var useID = 0; var item = Session["useDetails"] as Users; useID = item.useID; var draw = Request.Form.GetValues("draw").FirstOrDefault(); var start = Request.Form.GetValues("start").FirstOrDefault(); var length = Request.Form.GetValues("length").FirstOrDefault(); var sortCulmn = Request.Form.GetValues("columns[" + Request.Form.GetValues("order[0][column]").FirstOrDefault() + "][name]").FirstOrDefault(); var sortColumnDir = Request.Form.GetValues("order[0][dir]").FirstOrDefault(); int pageSize = length != null?Convert.ToInt32(length) : 0; int skip = start != null?Convert.ToInt32(start) : 0; int totalRecords = 0; var date = Request.Form.GetValues("columns[3][search][value]").FirstOrDefault(); var to = Request.Form.GetValues("columns[0][search][value]").FirstOrDefault(); int month = 0; if (string.IsNullOrWhiteSpace(date)) { month = 0; } else { month = Convert.ToInt32(date); } List <TasksModel> taskModel = new List <TasksModel>(); taskModel = await rpVM.GetReports(item.useCompanyID, month); if (!string.IsNullOrWhiteSpace(to)) { taskModel = taskModel.Where(a => a.tasDelegatedTo == Convert.ToInt32(to)).ToList(); } if (!(string.IsNullOrEmpty(sortCulmn + "" + sortColumnDir))) { taskModel = taskModel.OrderBy(sortCulmn + " " + sortColumnDir).ToList(); } totalRecords = taskModel.Count(); var data = taskModel.Skip(skip).Take(pageSize).ToList(); return(Json(new { draw, recordsFiltered = totalRecords, recordsTotal = totalRecords, data }, JsonRequestBehavior.AllowGet)); } catch (Exception e) { return(View()); } }
public async Task <List <TasksModel> > GetReports(string date, int cmpID) { int month = 0; if (string.IsNullOrWhiteSpace(date)) { month = 0; } else { month = Convert.ToInt32(date); } List <TasksModel> taskModel = new List <TasksModel>(); taskModel = await rpVM.GetReports(cmpID, month); return(taskModel); }