private void Form1_Load(object sender, EventArgs e)
{
ABCLogisticsGlobalGeoWebServiceReference.GeoWebService service = new ABCLogisticsGlobalGeoWebServiceReference.GeoWebService();
using (FFMCloudDataClassesDataContext context = new FFMCloudDataClassesDataContext())
{
var providers = (from o in context.FFM_Providers
where o.Latitude == null
select o).ToList();
int ProviderCount = providers.Count, SuccessCount = 0;
var globalContext = new ABCLogisticsGlobalDataClassesDataContext();
foreach (FFM_Provider provider in providers)
{
string zipcode = (from o in globalContext.Accounts
where o.AccountID == provider.AccountID.Value
select o.Postal).SingleOrDefault();
if (!string.IsNullOrEmpty(zipcode))
{
ABCLogisticsGlobalGeoWebServiceReference.GeoLocation loc = service.GeocodeZipCode(zipcode);
if (loc != null)
{
provider.Latitude = loc.Latitude;
provider.Longitude = loc.Longitude;
context.SubmitChanges();
SuccessCount++;
}
}
}
textBox.Text = ProviderCount.ToString() + " " + SuccessCount.ToString();
}
}
/// <remarks/>
public void GetRouteDistanceAsync(GeoLocation fromAddress, GeoLocation toAddress)
{
this.GetRouteDistanceAsync(fromAddress, toAddress, null);
}
