private List <Roles> GetRoles(SqlInstance instance)
{
List <Roles> result = new List <Roles>();
string query = @"SELECT * FROM [KB].[dbo].[Roles]";
DataTable dt = SqlInstance.GetSqlDataTable(query, this.Sql);
try {
result = dt.ToList <Roles>();
}
catch (Exception e) {
Console.WriteLine(e);
throw;
}
return(result);
}
private List <KBMenu> GetMenus(SqlInstance instance)
{
List <KBMenu> result = new List <KBMenu>();
string query = @"SELECT * FROM [KB].[dbo].[Menu] where IdMenuType = 4";
DataTable dt = SqlInstance.GetSqlDataTable(query, this.Sql);
try {
result = dt.ToList <KBMenu>();
}
catch (Exception e) {
Console.WriteLine(e);
throw;
}
return(result);
}