// GET: User/EmployeeGrants public ActionResult Index() { ViewBag.EmployeeGrants = employeeGrants; GrantVwViewModel model = new GrantVwViewModel(); GrantVwFilter filter = new GrantVwFilter(); filter.ProductEmployeeId = int.Parse(CurrentUser.UserName); model.List = GrantVwServices.Get(filter, db); return(View(model)); }
public int GetTotalRowCount(GrantVwFilter filter) { return(ExecuteQuery <Scalar <int> >(filter.GetTotalRowCountStatement(ParameterReplacementOption.BracketEnclosedNumber), filter.ExtractValues().ToArray()).First <Scalar <int> >().Value); }
public List <GrantVw> GetPage(GrantVwFilter filter, int pageIndex, int pageSize) { return(ExecuteQuery <GrantVw>(filter.ToString(pageIndex, pageSize, ParameterReplacementOption.BracketEnclosedNumber), filter.ExtractValues().ToArray()).ToList <GrantVw>()); }
public List <GrantVw> Get(GrantVwFilter filter) { return(ExecuteQuery <GrantVw>(filter.ToString(ParameterReplacementOption.BracketEnclosedNumber), filter.ExtractValues().ToArray()).ToList <GrantVw>()); }