public List <Dormitory> GetDormitories()
{
_logger.LogInfo("Getting Dormitories");
var query = "SELECT * FROM [Dormitories] ORDER BY [Number]";
var dormitories = new List <Dormitory>();
using (var reader = _dbConnection.ExecuteReader(query))
{
while (reader.Read())
{
dormitories.Add(new Dormitory()
{
Id = Convert.ToInt32(reader["Id"]),
Description = reader["Description"].ToString(),
Address = reader["Address"].ToString(),
Number = Convert.ToInt32(reader["Number"]),
Comendant = _administratorService.GetAdministratorById(Convert.ToInt32(reader["ComendantId"])),
Floors = _floorService.GetFloorsByDormitoryId(Convert.ToInt32(reader["Id"]))
});
}
}
return(dormitories);
}
public List <Floor> GetFloorByDormitoryId(int dormitoryId)
{
_logger.LogInfo("API HttpGet api/floors/dormitory/{dormitoryId}");
try
{
return(_floorService.GetFloorsByDormitoryId(dormitoryId));
}
catch (System.Exception e)
{
_logger.LogError("API HttpGet api/floors/dormitory/{dormitoryId} " + e.Message);
throw e;
}
}