public static int?GetDistance(string depCountry, string depCity, string depSuburb,
string destCountry, string destCity, string destSuburb)
{
//get from db
using (var db = new StallEntities())
{
var id = BuilId(depCountry, depCity, depSuburb, destCountry, destCity, destSuburb);
var dbResult = GetDistance(id, db);
if (dbResult != null)
{
return(dbResult);
}
//call google map api
var glResult = GoogleMapHelper.GetSuburbDistanceFromGoogleMapApi(depCountry, depCity, depSuburb, destCountry, destCity, destSuburb,
GreenspotConfiguration.AccessAccounts["google.map"].Secret);
if (glResult == null)
{
StallApplication.SysError($"[GOOGLE DISTANCE]failed to get distance {depCountry},{depCity},{depSuburb} to {destCountry},{destCity},{destSuburb}");
return(null);
}
else
{
//save to db
var distance = new SuburbDistance()
{
ID = id,
DepartureCountryCode = depCountry,
DepartureCity = depCity,
DepartureSuburb = depSuburb,
DestinationCountryCode = destCountry,
DestinationCity = destCity,
DestinationSuburb = destSuburb,
Meters = glResult.Value
};
db.SuburbDistances.Add(distance);
db.SaveChanges();
return(glResult.Value);
}
}
}
