/// <summary>
/// Get all the roles form the database.
/// </summary>
/// <returns>List of Rles</returns>
public List <RBACD.DatalayerDef.sRole> GetAllRoles()
{
List <RBACD.DatalayerDef.sRole> sRoleList = new List <RBACD.DatalayerDef.sRole>();
DataSet ds = new DataSet();
string sql = string.Empty;
try
{
sql = "Select securitygroupid,name,displayname from securitygroups order by name";
IDbConnection con = this.DbConnection;
IDbCommand dbCommand = DbConnection.CreateCommand();
dbCommand.CommandText = sql;
IDataReader DataReader = dbCommand.ExecuteReader();
while (DataReader.Read())
{
RBACD.DatalayerDef.sRole srole = new RBACD.DatalayerDef.sRole();
srole.RoleId = DataReader[0].ToString();
srole.RoleName = DataReader[1].ToString();
srole.RoleDescrition = DataReader[2].ToString();
sRoleList.Add(srole);
}
return(sRoleList);
}
catch
{
return(sRoleList);
}
}
/// <summary>
/// Get all the roles form the database.
/// </summary>
/// <returns>List of Rles</returns>
public List<RBACD.DatalayerDef.sRole> GetAllRoles()
{
List<RBACD.DatalayerDef.sRole> sRoleList = new List<RBACD.DatalayerDef.sRole>();
DataSet ds = new DataSet();
string sql = string.Empty;
try
{
sql = "Select securitygroupid,name,displayname from securitygroups order by name";
IDbConnection con = this.DbConnection;
IDbCommand dbCommand = DbConnection.CreateCommand();
dbCommand.CommandText = sql;
IDataReader DataReader = dbCommand.ExecuteReader();
while (DataReader.Read())
{
RBACD.DatalayerDef.sRole srole = new RBACD.DatalayerDef.sRole();
srole.RoleId = DataReader[0].ToString();
srole.RoleName = DataReader[1].ToString();
srole.RoleDescrition = DataReader[2].ToString();
sRoleList.Add(srole);
}
return sRoleList;
}
catch
{
return sRoleList;
}
}
