public List <GeographicArea> FindGeographicAreasBySaleModality(int saleModalityID)
{
Stopwatch timespan = Stopwatch.StartNew();
try
{
SaleModality saleModality = db.SaleModalitys.Where(p => p.SaleModalityID == saleModalityID).Single();
var result = saleModality.SaleModalityGeographicAreas.Select(s => s.GeographicArea).ToList();
timespan.Stop();
log.TraceApi("SQL Database", "SaleModalityGeographicAreaRepository.FindGeographicAreasBySaleModality", timespan.Elapsed, "saleModalityID={0}", saleModalityID);
return(result);
}
catch (Exception e)
{
log.Error(e, "Error in SaleModalityGeographicAreaRepository.FindGeographicAreasBySaleModality(saleModalityID={0})", saleModalityID);
throw;
}
}
public async Task <List <DeliveryAmount> > FindDeliveryAmountsBySaleModalityAsync(int saleModalityID)
{
Stopwatch timespan = Stopwatch.StartNew();
try
{
SaleModality saleModality = await db.SaleModalitys.Where(p => p.SaleModalityID == saleModalityID).SingleAsync();
var result = saleModality.SaleModalityDeliveryAmounts.Select(s => s.DeliveryAmount).ToList();
timespan.Stop();
log.TraceApi("SQL Database", "SaleModalityDeliveryAmountRepository.FindDeliveryAmountsBySaleModalityAsync", timespan.Elapsed, "saleModalityID={0}", saleModalityID);
return(result);
}
catch (Exception e)
{
log.Error(e, "Error in SaleModalityDeliveryAmountRepository.FindDeliveryAmountsBySaleModalityAsync(saleModalityID={0})", saleModalityID);
throw;
}
}