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