// GET: User/EmployeeGrants
public ActionResult Index()
{
ViewBag.EmployeeSubscriptions = employeeSubscriptions;
SubscriptionVwViewModel model = new SubscriptionVwViewModel();
SubscriptionVwFilter filter = new SubscriptionVwFilter();
filter.EmployeeId = int.Parse(CurrentUser.UserName);
model.List = SubscriptionVwServices.Get(filter, db);
return(View(model));
}
public List <SubscriptionVw> GetPage(SubscriptionVwFilter filter, int pageIndex, int pageSize)
{
return(ExecuteQuery <SubscriptionVw>(filter.ToString(pageIndex, pageSize, ParameterReplacementOption.BracketEnclosedNumber), filter.ExtractValues().ToArray()).ToList <SubscriptionVw>());
}
public int GetTotalRowCount(SubscriptionVwFilter filter)
{
return(ExecuteQuery <Scalar <int> >(filter.GetTotalRowCountStatement(ParameterReplacementOption.BracketEnclosedNumber), filter.ExtractValues().ToArray()).First <Scalar <int> >().Value);
}
public List <SubscriptionVw> Get(SubscriptionVwFilter filter)
{
return(ExecuteQuery <SubscriptionVw>(filter.ToString(ParameterReplacementOption.BracketEnclosedNumber), filter.ExtractValues().ToArray()).ToList <SubscriptionVw>());
}
