// GET: User/EmployeeGrants
public ActionResult Index()
{
ViewBag.EmployeeDebts = employeeDebts;
DebtVwViewModel model = new DebtVwViewModel();
DebtVwFilter filter = new DebtVwFilter();
filter.EmployeeId = int.Parse(CurrentUser.UserName);
model.List = DebtVwServices.Get(filter, db);
return(View(model));
}
public int GetTotalRowCount(DebtVwFilter filter)
{
return(ExecuteQuery <Scalar <int> >(filter.GetTotalRowCountStatement(ParameterReplacementOption.BracketEnclosedNumber), filter.ExtractValues().ToArray()).First <Scalar <int> >().Value);
}
public List <DebtVw> GetPage(DebtVwFilter filter, int pageIndex, int pageSize)
{
return(ExecuteQuery <DebtVw>(filter.ToString(pageIndex, pageSize, ParameterReplacementOption.BracketEnclosedNumber), filter.ExtractValues().ToArray()).ToList <DebtVw>());
}
public List <DebtVw> Get(DebtVwFilter filter)
{
return(ExecuteQuery <DebtVw>(filter.ToString(ParameterReplacementOption.BracketEnclosedNumber), filter.ExtractValues().ToArray()).ToList <DebtVw>());
}