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); }
//ROLE public RoleDal FindRoleByID(int RoleID) { RoleDal ProposedReturnValue = null; try { EnsureConnected(); using (SqlCommand command = new SqlCommand("FindRoleByID", _connection)) { command.CommandType = System.Data.CommandType.StoredProcedure; command.Parameters.AddWithValue("@RoleID", RoleID); using (SqlDataReader reader = command.ExecuteReader()) { RoleMapper m = new RoleMapper(reader); int count = 0; while (reader.Read()) { ProposedReturnValue = m.RoleFromReader(reader); count++; } if (count > 1) { throw new Exception($"Found more than 1 Role with key{ RoleID}"); } } } } catch (Exception ex) when(Log(ex)) { } return(ProposedReturnValue); }
public RoleDal RoleFromReader(System.Data.SqlClient.SqlDataReader reader) { RoleDal proposedReturnValue = new RoleDal(); proposedReturnValue.RoleID = reader.GetInt32(OffsetToRoleID); proposedReturnValue.Role = reader.GetString(OffsetToRole); return(proposedReturnValue); }