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 Search([Bind(Include = "staffNr,absenceTypeId,durStart,durEnd")] AbsenceRecrodSearchModel q) { SetDropDownList(null); int pageIndex = 0; int.TryParse(Request.QueryString.Get("page"), out pageIndex); pageIndex = PagingHelper.GetPageIndex(pageIndex); IAbsenceRecordService ss = new AbsenceRecordService(Settings.Default.db); IPagedList <AbsenceRecrod> models = ss.Search(q).ToPagedList(pageIndex, Settings.Default.pageSize); ViewBag.Query = q; return(View("Index", models)); }
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)); }
public IQueryable <AbsenceRecrod> Search(AbsenceRecrodSearchModel searchModel) { IQueryable <AbsenceRecrod> q = this.context.AbsenceRecrod; if (!string.IsNullOrEmpty(searchModel.staffNr)) { q = q.Where(c => c.staffNr.Contains(searchModel.staffNr.Trim())); } if (!string.IsNullOrEmpty(searchModel.absenceTypeId)) { q = q.Where(c => c.absenceTypeId.Equals(searchModel.absenceTypeId)); } if (searchModel.durStart.HasValue) { q = q.Where(s => s.absenceDate >= searchModel.durStart.Value); } if (searchModel.durEnd.HasValue) { q = q.Where(s => s.absenceDate <= searchModel.durEnd.Value); } return(q.OrderByDescending(s => s.absenceDate)); }
public IQueryable <AbsenceRecrod> Search(AbsenceRecrodSearchModel searchModel) { return(rep.Search(searchModel)); }