private void FillDataGrid()
{
var entities = (from n in DataContext.LP_Careers
where n.DateDeleted == null
orderby n.OrderIndex, n.DateCreated
select n).ToList();
var converter = new CareerEntityModelConverter(DataContext);
var models = (from n in entities
let m = converter.Convert(n)
select m).ToList();
var model = new CareersModel();
model.List = models;
careersControl.Model = model;
}
private void FillCareers()
{
var parentID = DataConverter.ToNullableGuid(Request["ID"]);
var currentLanguage = LanguageUtil.GetLanguage();
var query = from n in DataContext.LP_Careers
where n.DateDeleted == null && (n.Language == currentLanguage || n.Language == null || n.Language == "")
select n;
if (parentID == null)
{
query = from n in query
where n.ParentID == null
select n;
}
else
{
query = from n in query
where n.ParentID == parentID
select n;
}
query = from n in query
orderby n.OrderIndex, n.DateCreated
select n;
var entities = query.ToList();
var converter = new CareerEntityModelConverter(DataContext);
var models = (from n in entities
let m = converter.Convert(n)
select m).ToList();
var model = new CareersModel();
model.List = models;
careersControl.Model = model;
}
public string GetAllProducts(CareersModel model)
{
long resultCount = 0;
var pageSize = 5;
var page = Convert.ToDouble(model.Page);
if (ModelState.IsValid)
{
var careersContentId = model.CTID;
int jobCount = 0;
String Department = model.Department;
String Team = model.Team;
String Country = model.Country;
Logger.Info <CareersModel>(jobCount + "fffffffffff page:" + page + "Department: " + Department + " Team:" + Team + "Country :" + Country);
if (Department != "all" && Team == "all" && Country == "all")
{
jobsResult = Umbraco.Content(Guid.Parse(careersContentId)).Children()
.Where(x => x.IsVisible())
.Where(x => (string.Join(",", x.Value <IEnumerable <string> >("jobDepartment")).ToLower().Contains(Department.ToLower())));
}
else if (Department != "all" && Team == "all" && Country != "all")
{
jobsResult = Umbraco.Content(Guid.Parse(careersContentId)).Children()
.Where(x => x.IsVisible())
.Where(x => x.Value <IPublishedContent>("country") != null)
.Where(x => x.Value <IPublishedContent>("country").Value <string>("locationName").ToLower() == Country.ToLower())
.Where(x => (string.Join(",", x.Value <IEnumerable <string> >("jobDepartment")).ToLower().Contains(Department.ToLower())));
}
else if (Department == "all" && Team == "all" && Country == "all")
{
jobsResult = Umbraco.Content(Guid.Parse(careersContentId)).Children()
.Where(x => x.IsVisible());
}
else if (Department != "all" && Team != "all" && Country == "all")
{
jobsResult = Umbraco.Content(Guid.Parse(careersContentId)).Children()
.Where(x => (string.Join(",", x.Value <IEnumerable <string> >("jobDepartment")).ToLower().Contains(Department.ToLower())))
.Where(x => (string.Join(",", x.Value <IEnumerable <string> >("team")).ToLower().Contains(Team.ToLower())))
.Where(x => x.IsVisible());
}
else if (Department != "all" && Country != "all" && Team != "all")
{
jobsResult = Umbraco.Content(Guid.Parse(careersContentId)).Children()
.Where(x => x.IsVisible())
.Where(x => x.Value <IPublishedContent>("country") != null)
.Where(x => x.Value <IPublishedContent>("country").Value <string>("locationName").ToLower() == Country.ToLower())
.Where(x => (string.Join(",", x.Value <IEnumerable <string> >("jobDepartment")).ToLower().Contains(Department.ToLower())))
.Where(x => (string.Join(",", x.Value <IEnumerable <string> >("team")).ToLower().Contains(Team.ToLower())));
}
else if (Department == "all" && Country != "all" && Team == "all")
{
jobsResult = Umbraco.Content(Guid.Parse(careersContentId)).Children()
.Where(x => x.IsVisible())
.Where(x => x.Value <IPublishedContent>("country") != null)
.Where(x => x.Value <IPublishedContent>("country").Value <string>("locationName").ToLower() == Country.ToLower());
}
resultCount = jobsResult != null && jobsResult.Any() ? jobsResult.Count() : 0;
var totalPages = (int)Math.Ceiling((double)resultCount / (double)pageSize);
if (page > totalPages)
{
page = totalPages;
}
else if (page < 1)
{
page = 1;
}
Logger.Info <CareersModel>(jobCount + "fffffffffff");
if (resultCount > 0)
{
foreach (var jobsearchItem in jobsResult.Skip(((int)page - 1) * pageSize).Take(pageSize))
{
CareersModel item = new CareersModel();
item.Name = jobsearchItem.Name;
item.Url = jobsearchItem.Url;
//item.Location = jobsearchItem.Value("jobLocation").ToString();
listCareers.Add(item);
/*jobs = jobsearchItem.Name;*/
}
Logger.Info <CareersModel>(jobCount + "fffffffffff" + JsonConvert.SerializeObject(listCareers), JsonConvert.SerializeObject(listCareers));
PaginationModel pagination = new PaginationModel();
pagination.Careers = listCareers;
pagination.Page = page;
pagination.Total = totalPages;
return(JsonConvert.SerializeObject(pagination));
}
else
{
PaginationModel pagination = new PaginationModel();
pagination.Total = 0;
return(JsonConvert.SerializeObject(pagination));
}
}
/* return name;*/
return(JsonConvert.SerializeObject(jobsResult));
/*return JsonConvert.SerializeObject(data);*/
}
