private void SetJobTitleList(int?type, bool allowBlank = true)
{
IJobTitleService js = new JobTitleService(Settings.Default.db);
JobTitleSearchModel jtsm = new JobTitleSearchModel();
List <JobTitle> jt = js.Search(jtsm).ToList();
List <SelectListItem> select = new List <SelectListItem>();
if (allowBlank)
{
select.Add(new SelectListItem {
Text = "", Value = ""
});
}
foreach (var it in jt)
{
if (type.HasValue && type.ToString().Equals(it.id))
{
select.Add(new SelectListItem {
Text = it.name, Value = it.id.ToString(), Selected = true
});
}
else
{
select.Add(new SelectListItem {
Text = it.name, Value = it.id.ToString(), Selected = false
});
}
}
ViewData["jobTitleList"] = select;
}
public IQueryable <JobTitle> Search(JobTitleSearchModel searchModel)
{
IQueryable <JobTitle> jobtitles = this.context.JobTitle;
if (!string.IsNullOrEmpty(searchModel.Name))
{
jobtitles = jobtitles.Where(c => c.name.Contains(searchModel.Name.Trim()));
}
return(jobtitles);
}
public JobTitleInfoModel GetJobTitleInfo(JobTitleSearchModel searchModel)
{
JobTitleInfoModel info = new JobTitleInfoModel();
DataContext dc = new DataContext(this.DbString);
IJobTitleRepository jobTitleRep = new JobTitleRepository(dc);
IQueryable <JobTitle> jobTitles = jobTitleRep.Search(searchModel);
info.jobTitleCount = dc.Context.GetTable <JobTitle>().Where(c => c.id.Equals(jobTitles.Count() > 0 ? jobTitles.First().id : -1)).Count();
return(info);
}
public ActionResult Search([Bind(Include = "Name")] JobTitleSearchModel q)
{
int pageIndex = 0;
int.TryParse(Request.QueryString.Get("page"), out pageIndex);
pageIndex = PagingHelper.GetPageIndex(pageIndex);
IJobTitleService ss = new JobTitleService(Settings.Default.db);
IPagedList <JobTitle> jobTitles = ss.Search(q).ToPagedList(pageIndex, Settings.Default.pageSize);
ViewBag.Query = q;
return(View("Index", jobTitles));
}
public ActionResult Index(int?page)
{
int pageIndex = PagingHelper.GetPageIndex(page);
JobTitleSearchModel q = new JobTitleSearchModel();
IJobTitleService ss = new JobTitleService(Settings.Default.db);
IPagedList <JobTitle> jobTitles = ss.Search(q).ToPagedList(pageIndex, Settings.Default.pageSize);
ViewBag.Query = q;
JobTitleInfoModel info = ss.GetJobTitleInfo(q);
ViewBag.Info = info;
return(View(jobTitles));
}
public IQueryable <JobTitle> Search(JobTitleSearchModel searchModel)
{
return(jobTitleRep.Search(searchModel));
}
