public LongLat QueryLocalSourceForLongLat(GoogleMapAddress add)
{
DataTable tb = Database.ExecutePCodeDatabaseQuery("SELECT longitude, latitude FROM tbl_postcodes WHERE postcode = '" + add.PostCode.Replace(" ", "") + "'");
if (tb.Rows.Count != 1)
{
return(null);
}
return(new LongLat(tb.Rows[0][0].ToString(), tb.Rows[0][1].ToString(), add.PostCode));;
}
public LongLat QueryGoogleForLongLat(GoogleMapAddress add)
{
if (add == null)
{
throw new NullReferenceException("Invalid LongLat Object. Cannot Load PostCode");
}
if (add.PostCode.Split(' ').Count() > 2)
{
throw new Exception("Invalid Postcode Format");
}
LongLat retVal;
try
{
retVal = QueryLocalSourceForLongLat(add);
}
catch (Exception e) { retVal = null; }
if (retVal == null)
{
try
{
LocationDetailsQuery qr = QueryGoogleForLocation(add.ToString());
if (qr.ErrorCode != null)
{
throw new Exception("Error Loading Location Details : " + qr.ErrorCode);
}
else if (qr.LongLat == null)
{
throw new PostCodeNotFoundException("Post Code Not Found For (" + add.PostCode + "," + add.Country + ")");
}
retVal = new LongLat(qr.LongLat.Split(',')[0], qr.LongLat.Split(',')[1], add.PostCode);
}
catch (Exception ex)
{
throw new Exception("Failed to get location details");
}
}
return(retVal);
}
public GoogleMapAddress QueryGoogleForAddress(LongLat ll)
{
// if (Add == null)
// throw new NullReferenceException("Invalid Address Object. Cannot Load LongLat");
GoogleMapAddress retVal;
try
{
retVal = QueryLocalSourceForAddress(ll);
}
catch (Exception ex) { retVal = null; }
if (retVal == null)
{
try
{
LocationDetailsQuery qr = QueryGoogleForLocation(ll.ToString());
if (qr.ErrorCode != null)
{
throw new Exception("Error Loading Location Details : " + qr.ErrorCode);
}
else if (qr.PCode == null)
{
throw new PostCodeNotFoundException("Post Code Not Found For (" + ll.Longatude + ", " + ll.Latatude + ")");
}
else if (qr.Country == null)
{
throw new CountryNotFoundException("Country Not Found For (" + ll.Longatude + ", " + ll.Latatude + ")");
}
retVal = new GoogleMapAddress(qr.PCode, qr.Country);
}
catch (Exception ex)
{
throw new Exception("Failed to get location details");
}
}
return(retVal);
}
public GoogleMapLocation(LongLat longlat, string tag = null)
{
this.LongLat = longlat;
this.Add = QueryGoogleForAddress(longlat);
this.Tag = tag;
}
public GoogleMapLocation(GoogleMapAddress add, string tag = null)
{
this.Add = add;
this.LongLat = QueryGoogleForLongLat(@add);
this.Tag = tag;
}
public GoogleMapLocation(GoogleMapAddress add, LongLat longlat, string tag = null)
{
this.Add = add;
this.LongLat = longlat;
this.Tag = tag;
}