public ShiftScheduleInfoModel GetShiftScheduleInfo(ShiftScheduleSearchModel searchModel) { ShiftScheduleInfoModel info = new ShiftScheduleInfoModel(); DataContext dc = new DataContext(this.DbString); IShiftScheduleRepository rep = new ShiftScheduleRepository(dc); IQueryable <ShiftSchedule> results = rep.Search(searchModel); info.shiftScheduleCount = dc.Context.GetTable <ShiftSchedule>().Where(c => c.id.Equals(results.Count() > 0 ? results.First().id : -1)).Count(); return(info); }
public ActionResult Index(int?page) { int pageIndex = PagingHelper.GetPageIndex(page); ShiftScheduleSearchModel q = new ShiftScheduleSearchModel(); IShiftScheduleService ss = new ShiftSheduleService(Settings.Default.db); IPagedList <ShiftSchedule> models = ss.Search(q).ToPagedList(pageIndex, Settings.Default.pageSize); ViewBag.Query = q; ShiftScheduleInfoModel info = ss.GetShiftScheduleInfo(q); ViewBag.Info = info; return(View(models)); }