public JsonResult DataHandler(DatatablesRequest request) { try { var all = db.Job.AsQueryable(); var queryFiltered = all.SearchForDataTables(request); queryFiltered = queryFiltered.Sort(request) as IQueryable <Job>; var finalquery = queryFiltered.Skip(request.Start).Take(request.Length); ReponseToDatatables <Job> result = new ReponseToDatatables <Job> { draw = request.Draw, data = finalquery.ToList(), recordsFiltered = queryFiltered.Count(), recordsTotal = all.Count(), //yadcf_data_0 = db.TB_Pick.Select(a=>new Yadcf_SourceServer { value = a.PickID+"", label = a.JobRef}).ToList(), //yadcf_data_1 = db.TB_Pick.Select(a => new Yadcf_SourceServer { value = a.PickID + "", label = a.JobRef }).ToList(), //yadcf_data_2 = db.TB_Pick.Select(a => new Yadcf_SourceServer { value = a.PickID + "", label = a.JobRef }).ToList(), }; return(new JsonNetResult { Data = result }); } catch (Exception ex) { return(Json(new { error = ex.Message }, JsonRequestBehavior.AllowGet)); } }
public JsonResult DataHandler(DatatablesRequest request) { try { long id = 0; var all = db.Job .Include(a => a.Company) .Include(a => a.JobType) .AsNoTracking(); if (!string.IsNullOrEmpty(Session["CompanyID"] + "")) { id = Convert.ToInt64(Session["CompanyID"] + ""); all = db.Job.Where(a => a.CompanyID == id) .Include(a => a.Company) .Include(a => a.JobType) .AsNoTracking(); } var queryFiltered = all.SearchForDataTables(request); queryFiltered = queryFiltered.Sort(request) as IQueryable <Job>; var finalquery = queryFiltered.Skip(request.Start).Take(request.Length); ReponseToDatatables <Job> result = new ReponseToDatatables <Job> { draw = request.Draw, data = finalquery.ToList(), recordsFiltered = queryFiltered.Count(), recordsTotal = all.Count() }; if (request.FilterBase != null) { foreach (var dtFilterBase in request.FilterBase) { Type itemType = result.GetType(); try { var field = itemType.GetProperty("yadcf_data_" + dtFilterBase.Ydacf_Number); if (field != null) { var bbb = db.Job.Select("new (" + dtFilterBase.Ydacf_FieldName + " as label, " + dtFilterBase.Ydacf_FieldName + " as value)"); field.SetValue(result, bbb.Distinct().ToListAsync().Result); } } catch (Exception) { // ignored } } } return(new JsonNetResult { Data = result }); } catch (Exception ex) { return(Json(new { error = ex.Message }, JsonRequestBehavior.AllowGet)); } }
public JsonResult DataHandler(DatatablesRequest request) { try { var all = db.WorkingStatus .AsNoTracking(); var queryFiltered = all.SearchForDataTables(request); queryFiltered = queryFiltered.Sort(request) as IQueryable <WorkingStatus>; var finalquery = queryFiltered.Skip(request.Start).Take(request.Length); ReponseToDatatables <WorkingStatus> result = new ReponseToDatatables <WorkingStatus> { draw = request.Draw, data = finalquery.ToList(), recordsFiltered = queryFiltered.Count(), recordsTotal = all.Count() }; if (request.FilterBase != null) { foreach (var dtFilterBase in request.FilterBase) { Type itemType = result.GetType(); try { var field = itemType.GetProperty("yadcf_data_" + dtFilterBase.Ydacf_Number); if (field != null) { var bbb = db.WorkingStatus.Select("new (" + dtFilterBase.Ydacf_FieldName + " as label, " + dtFilterBase.Ydacf_FieldName + " as value)"); field.SetValue(result, bbb.Distinct().ToListAsync().Result); } } catch (Exception) { // ignored } } } return(new JsonNetResult { Data = result }); } catch (Exception ex) { return(Json(new { error = ex.Message }, JsonRequestBehavior.AllowGet)); } }
public JsonResult DataHandler(DatatablesRequest request) { try { long id = 0; var all = db.Users .Include(a => a.Roles.Select(b => b.Role)) .AsNoTracking(); if (!string.IsNullOrEmpty(Session["UserTypeID"] + "")) { id = Convert.ToInt64(Session["UserTypeID"] + ""); all = db.Users.Include(a => a.UserType) .Include(a => a.Roles.Select(b => b.Role)) .Where(a => a.UserType.UserTypeID == id) .AsNoTracking(); } var queryFiltered = all.SearchForDataTables(request); queryFiltered = queryFiltered.Sort(request) as IQueryable <ApplicationUser>; var finalquery = queryFiltered.Skip(request.Start).Take(request.Length); var lstFinal = new List <ApplicationUser>(); foreach (var user in finalquery.ToList()) { if (user.Roles != null) { user.UserRole = user.Roles.Select(a => new MultipleCheckboxClass() { id = a.RoleId, name = a.Role.Name }).ToList(); } lstFinal.Add(user); } var UserRoleOptions = new Dictionary <string, List <CommonModel> > { { "UserRole[].id", db.Roles.Select(a => new CommonModel() { value = a.Id, label = a.Name + "" }).ToList() } }; ReponseToDatatables <ApplicationUser> result = new ReponseToDatatables <ApplicationUser> { draw = request.Draw, data = lstFinal, recordsFiltered = queryFiltered.Count(), recordsTotal = all.Count(), options = UserRoleOptions }; if (request.FilterBase != null) { foreach (var dtFilterBase in request.FilterBase) { Type itemType = result.GetType(); try { var field = itemType.GetProperty("yadcf_data_" + dtFilterBase.Ydacf_Number); if (field != null) { var bbb = db.Users.Select("new (" + dtFilterBase.Ydacf_FieldName + " as label, " + dtFilterBase.Ydacf_FieldName + " as value)"); field.SetValue(result, bbb.Distinct().ToListAsync().Result); } } catch (Exception) { // ignored } } } return(new JsonNetResult { Data = result }); } catch (Exception ex) { return(Json(new { error = ex.Message }, JsonRequestBehavior.AllowGet)); } }
public JsonResult DataHandler(DatatablesRequest request) { try { long id = 0; var all = db.Company .Include(a => a.Location) .Include(a => a.CompanyZone) .Include(a => a.ListCompanyZone.Select(b => b.Zone)) .Include(a => a.ListJob) .AsNoTracking(); if (!string.IsNullOrEmpty(Session["ZoneID"] + "")) { id = Convert.ToInt64(Session["ZoneID"] + ""); all = db.Company .Include(a => a.Location) .Include(a => a.ListCompanyZone.Select(b => b.Zone)) .Include(a => a.ListJob) .Where(a => a.ListCompanyZone.Any(b => b.Zone.ZoneID == id)) .AsNoTracking(); } var queryFiltered = all.SearchForDataTables(request); queryFiltered = queryFiltered.Sort(request) as IQueryable <Company>; var finalquery = queryFiltered.Skip(request.Start).Take(request.Length); var lstFinal = new List <Company>(); foreach (var company in finalquery.ToList()) { company.CompanyZone = company.ListCompanyZone.Select(a => new MultipleCheckboxClass() { id = a.ZoneID, name = a.Zone.ZoneName }).ToList(); company.ListCompanyZone = null; lstFinal.Add(company); } var CompanyZoneOptions = new Dictionary <string, List <CommonModel> > { { "CompanyZone[].id", db.Zone.Select(a => new CommonModel() { value = a.ZoneID, label = a.ZoneName + "" }).ToList() } }; ReponseToDatatables <Company> result = new ReponseToDatatables <Company> { draw = request.Draw, data = lstFinal, recordsFiltered = queryFiltered.Count(), recordsTotal = all.Count(), files = CommonFunction.GenListImageJSON(db.Company.Where(a => !string.IsNullOrEmpty(a.Logo)).Select(a => a.Logo).ToList()), options = CompanyZoneOptions }; if (request.FilterBase != null) { foreach (var dtFilterBase in request.FilterBase) { Type itemType = result.GetType(); try { var field = itemType.GetProperty("yadcf_data_" + dtFilterBase.Ydacf_Number); if (field != null) { var bbb = db.Company.Select("new (" + dtFilterBase.Ydacf_FieldName + " as label, " + dtFilterBase.Ydacf_FieldName + " as value)"); field.SetValue(result, bbb.Distinct().ToListAsync().Result); } } catch (Exception) { // ignored } } } return(new JsonNetResult { Data = result }); } catch (Exception ex) { return(Json(new { error = ex.Message }, JsonRequestBehavior.AllowGet)); } }