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