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; }