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