public AbsenceRecrodInfoModel GetAbsenceRecrodInfo(AbsenceRecrodSearchModel searchModel)
{
AbsenceRecrodInfoModel info = new AbsenceRecrodInfoModel();
DataContext dc = new DataContext(this.DbString);
IAbsenceRecrodRepository rep = new AbsenceRecrodRepository(dc);
IQueryable <AbsenceRecrod> results = rep.Search(searchModel);
info.absenceRecordCount = dc.Context.GetTable <AbsenceRecrod>().Where(c => c.id.Equals(results.Count() > 0 ? results.First().id : -1)).Count();
return(info);
}
public ActionResult Index(int?page)
{
SetDropDownList(null);
int pageIndex = PagingHelper.GetPageIndex(page);
AbsenceRecrodSearchModel q = new AbsenceRecrodSearchModel();
IAbsenceRecordService ss = new AbsenceRecordService(Settings.Default.db);
IPagedList <AbsenceRecrod> models = ss.Search(q).ToPagedList(pageIndex, Settings.Default.pageSize);
ViewBag.Query = q;
AbsenceRecrodInfoModel info = ss.GetAbsenceRecrodInfo(q);
ViewBag.Info = info;
return(View(models));
}