public string GetWwtpNameForId(int id)
{
try
{
return(_dbViewAccessor.GetWaterPlants().FirstOrDefault(x => x.waterPlantId == id).waterPlantName);
}
catch (Exception e)
{
throw new Exception($"Could not retreive the wastewater treatment plant name for the id [{id}]");
}
}
public List <vWaterPlant> GetWaterPlants()
{
try
{
var result = _dbAccessor.GetWaterPlants();
return(result.ToList());
}
catch (Exception e)
{
throw new HttpException((int)HttpStatusCode.BadRequest, $"Data could not be retreived. Reason: {e.Message}");
}
}