public BusinessCentralHelper(ConnectorConfig config, string entity, ILogger log)
{
this.config = config;
this.log = log;
this.apiEndpoint = String.Format(config.BcWebServiceMainUrl, config.BcWebServiceCompany, entity);
this.apiEndpoint4C = String.Format(config.BcWebServiceCustUrl, config.BcWebServiceCompany, entity);
var authData = string.Format("{0}:{1}", config.BcWebServiceUser, config.BcWebServicePassword);
this.authHeaderValue = Convert.ToBase64String(Encoding.UTF8.GetBytes(authData));
}
public static async void Run([HttpTrigger(AuthorizationLevel.Function, "get", Route = null)]
HttpRequest req,
ILogger log,
ExecutionContext context)
{
log.LogInformation("C# HTTP trigger function processed a request.");
// Load configuration
var config = new ConfigurationBuilder()
.SetBasePath(context.FunctionAppDirectory)
.AddJsonFile("local.settings.json", optional: true, reloadOnChange: true)
.AddEnvironmentVariables()
.Build();
var appConfig = new ConnectorConfig(config);
var azureMapHelper = new AzureMapHelper(appConfig);
var apiCustomer = new NavHelper(appConfig, log);
var odataNextLink = string.Empty;
do
{
var customers = await apiCustomer.Get <Nav_Customers>("Prime365Customers", odataNextLink);
if (customers.OdataNextLink != null)
{
odataNextLink = customers.OdataNextLink.ToString();
}
else
{
odataNextLink = string.Empty;
}
var counter = 0;
if (customers != null && customers.Value != null && customers.Value.Count > 0)
{
customers.Value = customers.Value.Where(a => a.Prime365Lat == 0).ToList();
foreach (var customer in customers.Value)
{
var azureResult = azureMapHelper.Get_Nav_CustomerCoordinates(customer);
var filter = string.Format("(No='{0}')", customer.No);
await apiCustomer.UpdateCustomer("Prime365Customers", customer, azureResult, filter);
log.LogInformation(string.Format("Customer : {0} - Completed {1} of {2}", customer.No, (counter++).ToString(), customers.Value.Count.ToString()));
}
}
} while (!string.IsNullOrEmpty(odataNextLink));
}
public AzureMapHelper(ConnectorConfig config)
{
this.config = config;
this.AzureMapEndpoint = config.AzureMapEndpoint;
this.AzureMapKey = config.AzureMapKey;
}
public NavHelper(ConnectorConfig config, ILogger log)
{
this.config = config;
this.log = log;
}
public static async void Run([HttpTrigger(AuthorizationLevel.Function, "get", Route = null)]
HttpRequest req,
ILogger log,
ExecutionContext context)
{
log.LogInformation("C# HTTP trigger function processed a request.");
// Load configuration
var config = new ConfigurationBuilder()
.SetBasePath(context.FunctionAppDirectory)
.AddJsonFile("local.settings.json", optional: true, reloadOnChange: true)
.AddEnvironmentVariables()
.Build();
var appConfig = new ConnectorConfig(config);
var azureMapHelper = new AzureMapHelper(appConfig);
//CUSTOMERS
var apiCustomer = new BusinessCentralHelper(appConfig, "ApiCustomersCoords", log);
var customers = apiCustomer.GetCustomers();
var counter = 0;
if (customers != null && customers.Value != null && customers.Value.Count > 0)
{
customers.Value = customers.Value.Where(a => a.NblLatitude == 0).ToList();
foreach (var customer in customers.Value)
{
var azureResult = azureMapHelper.Get_Bc_CustomerCoordinates(customer);
var filter = string.Format("(no='{0}')", customer.No);
await apiCustomer.UpdateCustomer(customer, azureResult, filter);
log.LogInformation(string.Format("Customer : {0} - Completed {1} of {2}", customer.No, (counter++).ToString(), customers.Value.Count.ToString()));
}
}
else
{
log.LogInformation(string.Format("All customers already processed"));
}
// SHIP TO ADDRESS
/*
* var apiShipToAddress = new BusinessCentralHelper(appConfig, "ApiShipToAddressCoords", log);
* var shipToAddresses = apiShipToAddress.GetShipToAddress();
*
* counter = 0;
* if (shipToAddresses != null && shipToAddresses.Value != null && shipToAddresses.Value.Count > 0)
* {
* shipToAddresses.Value = shipToAddresses.Value.Where(a => a.Latitude == 0).ToList();
* foreach (var shipToAddress in shipToAddresses.Value)
* {
* var azureResult = azureMapHelper.Get_Bc_ShipToAddressCoordinates(shipToAddress);
* var filter = string.Format("(code='{0}',customerNo='{1}')", shipToAddress.Code, shipToAddress.customerNo);
* await apiShipToAddress.UpdateShipToAddress(shipToAddress, azureResult, filter);
* log.LogInformation(string.Format("Ship To Address : {0} - Completed {1} of {2}", shipToAddress.Code, (counter++).ToString(), shipToAddresses.Value.Count.ToString()));
* }
*
* }
* else
* log.LogInformation(string.Format("All ship to address already processed"));
*
*/
}