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