public async Task UpdateAsync(GeographicArea geographicAreaToSave)
{
Stopwatch timespan = Stopwatch.StartNew();
try
{
db.Entry(geographicAreaToSave).State = EntityState.Modified;
await db.SaveChangesAsync();
timespan.Stop();
log.TraceApi("SQL Database", "GeographicAreaRepository.UpdateAsync", timespan.Elapsed, "geographicAreaToSave={0}", geographicAreaToSave);
}
catch (Exception e)
{
log.Error(e, "Error in GeographicAreaRepository.UpdateAsync(geographicAreaToSave={0})", geographicAreaToSave);
throw;
}
}
public async Task CreateAsync(GeographicArea geographicAreaToAdd)
{
Stopwatch timespan = Stopwatch.StartNew();
try
{
db.GeographicAreas.Add(geographicAreaToAdd);
await db.SaveChangesAsync();
timespan.Stop();
log.TraceApi("SQL Database", "GeographicAreaRepository.CreateAsync", timespan.Elapsed, "geographicAreaToAdd={0}", geographicAreaToAdd);
}
catch (Exception e)
{
log.Error(e, "Error in GeographicAreaRepository.CreateAsync(geographicAreaToAdd={0})", geographicAreaToAdd);
throw;
}
}
public async Task DeleteAsync(int geographicAreaID)
{
Stopwatch timespan = Stopwatch.StartNew();
try
{
GeographicArea geographicArea = await db.GeographicAreas.FindAsync(geographicAreaID);
db.GeographicAreas.Remove(geographicArea);
await db.SaveChangesAsync();
timespan.Stop();
log.TraceApi("SQL Database", "GeographicAreaRepository.DeleteAsync", timespan.Elapsed, "geographicAreaID={0}", geographicAreaID);
}
catch (Exception e)
{
log.Error(e, "Error in GeographicAreaRepository.DeleteAsync(geographicAreaID={0})", geographicAreaID);
throw;
}
}
public List <TransportType> FindTransportTypeByGeographicArea(int geographicAreaID)
{
Stopwatch timespan = Stopwatch.StartNew();
try
{
GeographicArea geographicArea = db.GeographicAreas.Where(p => p.GeographicAreaID == geographicAreaID).Single();
var result = geographicArea.GeographicAreaTransportTypes.Select(s => s.TransportType).ToList();
timespan.Stop();
log.TraceApi("SQL Database", "GeographicAreaTransportTypeRepository.FindTransportTypeByGeographicArea", timespan.Elapsed, "geographicAreaID={0}", geographicAreaID);
return(result);
}
catch (Exception e)
{
log.Error(e, "Error in GeographicAreaTransportTypeRepository.FindTransportTypeByGeographicArea(geographicAreaID={0})", geographicAreaID);
throw;
}
}
