public List <RoleDAL> GetRoles(int skip, int take)
{
List <RoleDAL> proposedReturnValue = new List <RoleDAL>();
try
{
EnsureConnected();
using (SqlCommand command = new SqlCommand("GetRoles", _connection))
{
command.CommandType = System.Data.CommandType.StoredProcedure;
command.Parameters.AddWithValue("@Skip", skip);
command.Parameters.AddWithValue("@Take", take);
using (SqlDataReader reader = command.ExecuteReader())
{
RoleMapper m = new RoleMapper(reader);
while (reader.Read())
{
RoleDAL r = m.RoleFromReader(reader);
proposedReturnValue.Add(r);
}
}
}
}
catch (Exception ex) when(Log(ex))
{
}
return(proposedReturnValue);
}
//Method Called FindRole
public RoleDAL FindRoleByRoleID(int RoleID)
{
RoleDAL propsosedReturnValue = null;
try
{
EnsureConnected();
using (SqlCommand command = new SqlCommand("FindRoleByRoleID", _connection))
{
command.CommandType = System.Data.CommandType.StoredProcedure;
command.Parameters.AddWithValue("@RoleID", RoleID);
//need to configure the Text, Type and Parameters.
using (SqlDataReader reader = command.ExecuteReader())
{
RoleMapper mapper = new RoleMapper(reader);
int count = 0;
while (reader.Read())
{
propsosedReturnValue = mapper.RoleFromReader(reader);
count++;
}
if (count > 1)
{
throw new Exception($"Found more than 1 Role with key {RoleID}");
}
}
}
}
catch (Exception ex) when(Log(ex))
{
}
return(propsosedReturnValue);
}
public List <RoleDAL> RolesGetAll(int skip, int take)
{
List <RoleDAL> ExpectedReturnValue = new List <RoleDAL>();
try
{
EnsureConnected();
using (SqlCommand command = new SqlCommand("RolesGetAll", conn))
{
command.CommandType = System.Data.CommandType.StoredProcedure;
command.Parameters.AddWithValue("@skip", skip);
command.Parameters.AddWithValue("@take", take);
using (SqlDataReader reader = command.ExecuteReader())
{
RoleMapper RM = new RoleMapper(reader);
while (reader.Read())
{
RoleDAL info = RM.ToRole(reader);
ExpectedReturnValue.Add(info);
}
}
}
}
catch (Exception ex) when(Log(ex))
{
}
return(ExpectedReturnValue);
}
public RoleDAL Role_FindByRoleID(int roleID)
{
RoleDAL ProposedReturnValue = null;
try
{
EnsureConnected();
using (SqlCommand command = new SqlCommand("Role_FindByRoleID", _connection))
{
command.CommandType = System.Data.CommandType.StoredProcedure;
command.Parameters.AddWithValue("@RoleID", roleID);
using (SqlDataReader reader = command.ExecuteReader())
{
RoleMapper mapper = new RoleMapper(reader);
int count = 0;
while (reader.Read())
{
ProposedReturnValue = mapper.RoleFromReader(reader);
count++;
}
if (count > 1)
{
throw new Exception($"Found more than 1 Role with key {roleID}");
}
}
}
}
catch (Exception ex) when(Log(ex))
{
// No access to scope - Exception thrown before entering
}
return(ProposedReturnValue);
}
public RoleDAL RoleFindByID(int RoleID)
{
RoleDAL ExpectedReturnValue = null;
try
{
EnsureConnected();
using (SqlCommand command = new SqlCommand("RoleFindByID", conn))
{
command.CommandType = System.Data.CommandType.StoredProcedure;
command.Parameters.AddWithValue("@RoleID", RoleID);
using (SqlDataReader reader = command.ExecuteReader())
{
RoleMapper RM = new RoleMapper(reader);
int count = 0;
while (reader.Read())
{
ExpectedReturnValue = RM.ToRole(reader);
count++;
}
if (count > 1)
{
throw new Exception($"{count} Multiple Roles found for ID {RoleID}");
}
}
}
}
catch (Exception ex) when(Log(ex))
{
}
return(ExpectedReturnValue);
}
public List <RoleDAL> GetRoles(int skip, int take)
{
List <RoleDAL> rv = new List <RoleDAL>();
try
{
EnsureConnected();
using (SqlCommand command = new SqlCommand("GetRoles", Con))
{
command.CommandType = System.Data.CommandType.StoredProcedure;
command.Parameters.AddWithValue("@skip", skip);
command.Parameters.AddWithValue("@take", take);
using (SqlDataReader reader = command.ExecuteReader())
{
RoleMapper mapper = new RoleMapper(reader);
while (reader.Read())
{
RoleDAL c = mapper.ToRole(reader);
rv.Add(c);
}
}
}
}
catch (Exception ex)
{
Log(ex);
throw;
}
return(rv);
}
// ----- Read ----- //
public List <RoleDAL> Roles_Get(int skip, int take)
{
List <RoleDAL> proposedReturnValue = new List <RoleDAL>();
try
{
EnsureConnected();
using (SqlCommand command = new SqlCommand("Roles_Get", _connection))
{
command.CommandType = System.Data.CommandType.StoredProcedure;
command.Parameters.AddWithValue("@Skip", skip);
command.Parameters.AddWithValue("@Take", take);
using (SqlDataReader reader = command.ExecuteReader())
{
RoleMapper mapper = new RoleMapper(reader);
while (reader.Read())
{
RoleDAL reading = mapper.RoleFromReader(reader);
proposedReturnValue.Add(reading);
}
}
}
}
catch (Exception ex) when(Log(ex))
{
// No access to scope - Exception thrown before entering
}
return(proposedReturnValue);
}
public RoleDAL FindRoleByUserName(string UserName)
{
RoleDAL rv = null;
try
{
EnsureConnected();
using (SqlCommand command = new SqlCommand("FindRoleByUserName", Con))
{
command.CommandType = System.Data.CommandType.StoredProcedure;
command.Parameters.AddWithValue("@UserName", UserName);
using (SqlDataReader reader = command.ExecuteReader())
{
RoleMapper mapper = new RoleMapper(reader);
if (reader.Read())
{
rv = mapper.ToRole(reader);
}
}
}
}
catch (Exception ex)
{
Log(ex);
throw;
}
return(rv);
}
public RoleDAL RoleFindByID(int RoleID)
{ // retrieve a role by ID (we dont expect multiple records here)
RoleDAL ReturnValue = null;
CheckConnection();
try
{
using (SqlCommand command = new SqlCommand("RoleFindByID", _con))
{
command.CommandType = System.Data.CommandType.StoredProcedure;
command.Parameters.AddWithValue("@RoleID", RoleID);
using (SqlDataReader reader = command.ExecuteReader())
{
RoleMapper rm = new RoleMapper(reader);
int count = 0;
while (reader.Read())
{
ReturnValue = rm.ToRole(reader);
count++;
}
if (count > 1)
{
throw new Exception($"{count} Multiple Roles found for ID {RoleID}");
}
}
}
}
catch (Exception oops) when(Error.Log(oops))
{
//it's all done in the error.log
}
return(ReturnValue);
}
public List <RoleDAL> RolesGetAll(int Skip, int Take)
{
List <RoleDAL> proposedReturnValue = new List <RoleDAL>();
try
{
EnsureConnected();
using (SqlCommand command = new SqlCommand("RolesGetAll", _con))
{
command.CommandType = System.Data.CommandType.StoredProcedure;
command.Parameters.AddWithValue("@skip", Skip);
command.Parameters.AddWithValue("@take", Take);
using (SqlDataReader reader = command.ExecuteReader())
{
RoleMapper rm = new RoleMapper(reader);
while (reader.Read())
{
RoleDAL item = rm.ToRole(reader);
proposedReturnValue.Add(item);
}
}
}
}
catch (Exception ex) when(Log(ex))
{
// stays empty
}
return(proposedReturnValue);
}
public RoleDAL RoleFindByID(int RoleID)
{
RoleDAL proposedreturnValue = null;
try
{
EnsureConnected();
using (SqlCommand command = new SqlCommand("RoleFindByID", _con))
{
command.CommandType = System.Data.CommandType.StoredProcedure;
command.Parameters.AddWithValue("@RoleID", RoleID); //QuotesQuotesQuotes
using (SqlDataReader reader = command.ExecuteReader())
{
RoleMapper rm = new RoleMapper(reader);
int count = 0;
while (reader.Read())
{
proposedreturnValue = rm.ToRole(reader);
count++;
}
if (count > 1)
{
throw new Exception($"Multiple Roles found for ID {RoleID}");
}
}
}
}
catch (Exception ex) when(Log(ex))
{
// stays empty
}
return(proposedreturnValue);
}
public List <RoleDAL> RoleGetAll(int Skip, int Take)
{ // retrieves all Roles
List <RoleDAL> ReturnValue = new List <RoleDAL>();
CheckConnection();
try
{
using (SqlCommand command = new SqlCommand("RolesGetAll", _con))
{
command.CommandType = System.Data.CommandType.StoredProcedure;
command.Parameters.AddWithValue("@skip", Skip);
command.Parameters.AddWithValue("@take", Take);
using (SqlDataReader reader = command.ExecuteReader())
{
RoleMapper rm = new RoleMapper(reader);
while (reader.Read())
{
RoleDAL item = rm.ToRole(reader);
ReturnValue.Add(item);
}
}
}
}
catch (Exception oops) when(Error.Log(oops))
{
//it's all done in the error.log
}
return(ReturnValue);
}
public RoleDAL RoleFindbyID(int RoleID)
{
RoleDAL proposedReturnValue = null;
EnsureConnected();
using (SqlCommand command = new SqlCommand("RoleFindByID", sec))
{
command.CommandType = System.Data.CommandType.StoredProcedure;
command.Parameters.AddWithValue("RoleID", @RoleID);
using (SqlDataReader reader = command.ExecuteReader())
{
RoleMapper rm = new RoleMapper(reader);
int count = 0;
while (reader.Read())
{
proposedReturnValue = rm.ToRole(reader);
count++;
}
if (count > 1)
{
throw new Exception($"{ count } many roles were found for ID { RoleID}");
}
}
}
return(proposedReturnValue);
}
public RoleDAL RoleFromReader(SqlDataReader reader)
{
RoleDAL proposedReturnValue = new RoleDAL();
proposedReturnValue.RoleID = GetInt32OrDefault(reader, OffsetToRoleID);
proposedReturnValue.RoleName = GetStringOrDefault(reader, OffsetToRoleName);
return(proposedReturnValue);
}
public RoleDAL ToRole(SqlDataReader reader)
{
RoleDAL proposedReturnValue = new RoleDAL();
proposedReturnValue.RoleID = reader.GetInt32(OffsetToRoleID);
proposedReturnValue.RoleName = reader.GetString(OffsetToRoleName);
return(proposedReturnValue);
}
public RoleDAL ToRole(SqlDataReader r)
{
RoleDAL rv = new RoleDAL();
rv.RoleID = GetInt32OrZero(r, RoleIDOrdinal);
rv.Role = GetStringOrNull(r, RoleOrdinal);
return(rv);
}
public RoleDAL RoleFromReader(SqlDataReader reader)
{
RoleDAL ProposedReturnValue = new RoleDAL();
ProposedReturnValue.RoleID = reader.GetInt32(OffsetToRoleID);
ProposedReturnValue.RoleName = reader.GetString(OffsetToRoleName);
return(ProposedReturnValue);
}
public RoleDAL ToRole(SqlDataReader reader)
{ // use the checked offset to write the info to appropriate fields
RoleDAL ReturnValue = new RoleDAL();
ReturnValue.RoleID = reader.GetInt32(OffsetToRoleID);
ReturnValue.RoleName = reader.GetString(OffsetToRoleName);
return(ReturnValue);
}
public RoleDAL ToRole(SqlDataReader r) //different from ctor used many times in loops
{
RoleDAL rv = new RoleDAL();
rv.RoleID = GetInt32OrZero(r, RoleIDOrdinal);
rv.Role = GetStringOrNull(r, RoleOrdinal);
return(rv);
}
//taking method called RoleFromReader from RoleDAL with parameters (reader from sql data reader)
public RoleDAL RoleFromReader(System.Data.SqlClient.SqlDataReader reader)
{
//accessing RoleDAL and making new RoleDAL properties
RoleDAL propsedReturnValue = new RoleDAL();
//New RoleDAL value = mapper(sqlreader, rolemapper)
propsedReturnValue.RoleID = GetInt32OrDefault(reader, OffsetToRoleID);
propsedReturnValue.RoleName = GetStringOrDefault(reader, OffsetToRoleName);
return(propsedReturnValue);
}
public RoleDAL RoleFromReader(System.Data.SqlClient.SqlDataReader reader)
{
RoleDAL proposedReturnValue = new RoleDAL();
// ----- Roles ----- //
proposedReturnValue.RoleID = reader.GetInt32(offsetToRoleID);
proposedReturnValue.RoleName = reader.GetString(offsetToRoleName);
proposedReturnValue.RolePermissions = reader.GetString(offsetToRolePermissions);
return(proposedReturnValue);
}
public RoleDAL ToRole(SqlDataReader reader)
// RoleFromReader
// FromReader
// ReaderToRole
{
RoleDAL ExpectedReturnValue = new RoleDAL();
ExpectedReturnValue.RoleID = reader.GetInt32(OffsetToRoleID);
ExpectedReturnValue.RoleName = reader.GetString(OffsetToRoleName);
return(ExpectedReturnValue);
}
public RoleBLL(DataAccessLayer.RoleDAL role)
{
RoleID = role.RoleID;
RoleName = role.RoleName;
}
public RoleBLL(DataAccessLayer.RoleDAL dal)
{
this.RoleID = dal.RoleID;
this.RoleName = dal.RoleName;
}
