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