public override RoleInfo GetRole(Guid roleId, string roleName)
{
DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT RoleId, RoleName as [Name], r.Description FROM aspnet_Roles r WHERE 1=1");
if (roleId != Guid.Empty)
{
sqlStringCommand.CommandText = sqlStringCommand.CommandText + " AND RoleId = @RoleId";
this.database.AddInParameter(sqlStringCommand, "RoleId", DbType.Guid, roleId);
}
if (!string.IsNullOrEmpty(roleName))
{
sqlStringCommand.CommandText = sqlStringCommand.CommandText + " AND RoleName = @RoleName";
this.database.AddInParameter(sqlStringCommand, "RoleName", DbType.String, roleName);
}
RoleInfo info = null;
using (IDataReader reader = this.database.ExecuteReader(sqlStringCommand))
{
if (reader.Read())
{
info = MemberRoleProvider.PopulateRoleFromIDataReader(reader);
}
reader.Close();
}
return(info);
}
public override RoleInfo GetRole(Guid roleId, string roleName)
{
System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT RoleId, RoleName as [Name], r.Description FROM aspnet_Roles r WHERE 1=1");
if (roleId != Guid.Empty)
{
System.Data.Common.DbCommand expr_22 = sqlStringCommand;
expr_22.CommandText += " AND RoleId = @RoleId";
this.database.AddInParameter(sqlStringCommand, "RoleId", System.Data.DbType.Guid, roleId);
}
if (!string.IsNullOrEmpty(roleName))
{
System.Data.Common.DbCommand expr_59 = sqlStringCommand;
expr_59.CommandText += " AND RoleName = @RoleName";
this.database.AddInParameter(sqlStringCommand, "RoleName", System.Data.DbType.String, roleName);
}
RoleInfo result = null;
using (System.Data.IDataReader dataReader = this.database.ExecuteReader(sqlStringCommand))
{
if (dataReader.Read())
{
result = MemberRoleProvider.PopulateRoleFromIDataReader(dataReader);
}
dataReader.Close();
}
return(result);
}
public override ArrayList GetRoles()
{
DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT RoleId, RoleName as [Name], Description FROM aspnet_Roles order by RoleId");
ArrayList list = new ArrayList();
using (IDataReader reader = this.database.ExecuteReader(sqlStringCommand))
{
while (reader.Read())
{
RoleInfo info = MemberRoleProvider.PopulateRoleFromIDataReader(reader);
list.Add(info);
}
reader.Close();
}
return(list);
}
public override ArrayList GetRoles()
{
System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT RoleId, RoleName as [Name], Description FROM aspnet_Roles where RoleId<>'625a27cc-7a55-41d6-8449-c6fe736003e5' and RoleId<>'5a26c830-b998-4569-bffc-c5ceae774a7a' order by RoleId");
ArrayList arrayList = new ArrayList();
using (System.Data.IDataReader dataReader = this.database.ExecuteReader(sqlStringCommand))
{
while (dataReader.Read())
{
RoleInfo value = MemberRoleProvider.PopulateRoleFromIDataReader(dataReader);
arrayList.Add(value);
}
dataReader.Close();
}
return(arrayList);
}
public override ArrayList GetRoles()
{
System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT RoleId, RoleName as [Name], Description FROM aspnet_Roles order by RoleId");
ArrayList arrayList = new ArrayList();
using (System.Data.IDataReader dataReader = this.database.ExecuteReader(sqlStringCommand))
{
while (dataReader.Read())
{
RoleInfo value = MemberRoleProvider.PopulateRoleFromIDataReader(dataReader);
arrayList.Add(value);
}
dataReader.Close();
}
return(arrayList);
}
public override ArrayList GetRoles(int userId)
{
DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT DISTINCT R.RoleId, RoleName as [Name], Description FROM aspnet_UsersInRoles U, aspnet_Roles R WHERE U.RoleId = R.RoleId AND U.UserId = @UserId order by R.RoleId");
ArrayList list = new ArrayList();
this.database.AddInParameter(sqlStringCommand, "UserId", DbType.Int32, userId);
using (IDataReader reader = this.database.ExecuteReader(sqlStringCommand))
{
while (reader.Read())
{
RoleInfo info = MemberRoleProvider.PopulateRoleFromIDataReader(reader);
list.Add(info);
}
reader.Close();
}
return(list);
}
