Beispiel #1
0
        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);
        }