public IList <SecurityUser> GetUsersByName(string query, int fetchCount)
{
return(db.GetList <SecurityUser>(string.Concat("select user_id, user_name from security.security_users where user_name like @text || '%' order by user_name fetch first ", fetchCount.ToString(), " rows only"),
new { text = query }));
}
public IList <Menu> GetAll()
{
return(db.GetList <Menu>("SELECT menu_id, menu_name, menu_url, parent_id FROM security.menus"));
}
public IList <Role> GetRoles()
{
return(db.GetList <Role>("select role_id, role_name from security.roles"));
}