public ActionResult UserExpenseGroups(UserExpenseGroupsQueryModel query) { var sql = @"select expense_group_name as ExpenseGroup, description as Descrption from user_expense_groups where user_name = @0 and active_flag = 'Y' order by 1"; var list = DataContext.Fetch <UserExpenseGroupsResult>(sql, _sessionState.UserName).ToList(); return(Json(list, JsonRequestBehavior.AllowGet)); }
public ActionResult UserExpenseGroups(UserExpenseGroupsQueryModel query) { var sql = @"select expense_group_name as ExpenseGroup, description as Descrption from user_expense_groups where user_name = @0 and active_flag = 'Y' order by 1"; var list = DataContext.Fetch<UserExpenseGroupsResult>(sql, _sessionState.UserName).ToList(); return Json(list, JsonRequestBehavior.AllowGet); }