private void SetDegreeTypeList(int?type, bool allowBlank = true) { IDegreeTypeService dts = new DegreeTypeService(Settings.Default.db); DegreeTypeSearchModel dtsm = new DegreeTypeSearchModel(); List <DegreeType> dt = dts.Search(dtsm).ToList(); List <SelectListItem> select = new List <SelectListItem>(); if (allowBlank) { select.Add(new SelectListItem { Text = "", Value = "" }); } foreach (var it in dt) { 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["degreeTypeList"] = select; }
public IQueryable <DegreeType> Search(DegreeTypeSearchModel searchModel) { IQueryable <DegreeType> degreetypes = this.context.DegreeType; if (!string.IsNullOrEmpty(searchModel.Name)) { degreetypes = degreetypes.Where(c => c.name.Contains(searchModel.Name.Trim())); } return(degreetypes); }
public DegreeTypeInfoModel GetDegreeTypeInfo(DegreeTypeSearchModel searchModel) { DegreeTypeInfoModel info = new DegreeTypeInfoModel(); DataContext dc = new DataContext(this.DbString); IDegreeTypeRepository degreeTypeRep = new DegreeTypeRepository(dc); IQueryable <DegreeType> degreeType = degreeTypeRep.Search(searchModel); info.degreeTypeCount = dc.Context.GetTable <DegreeType>().Where(c => c.id.Equals(degreeType.Count() > 0 ? degreeType.First().id : -1)).Count(); return(info); }
public ActionResult Search([Bind(Include = "Name")] DegreeTypeSearchModel q) { int pageIndex = 0; int.TryParse(Request.QueryString.Get("page"), out pageIndex); pageIndex = PagingHelper.GetPageIndex(pageIndex); IDegreeTypeService ss = new DegreeTypeService(Settings.Default.db); IPagedList <DegreeType> degreeTypes = ss.Search(q).ToPagedList(pageIndex, Settings.Default.pageSize); ViewBag.Query = q; return(View("Index", degreeTypes)); }
public ActionResult Index(int?page) { int pageIndex = PagingHelper.GetPageIndex(page); DegreeTypeSearchModel q = new DegreeTypeSearchModel(); IDegreeTypeService ss = new DegreeTypeService(Settings.Default.db); IPagedList <DegreeType> degreeTypes = ss.Search(q).ToPagedList(pageIndex, Settings.Default.pageSize); ViewBag.Query = q; DegreeTypeInfoModel info = ss.GetDegreeTypeInfo(q); ViewBag.Info = info; return(View(degreeTypes)); }
public IQueryable <DegreeType> Search(DegreeTypeSearchModel searchModel) { return(degreeTypeRep.Search(searchModel)); }