A .NET wrapper library for adding external data load functionality to the AB API

Usage

Create a new .NET Standard class library project in Visual Studio. The built DLL must be named WFD.ApApi.ExternalData.Services

Cr

public class ExternalData : IExternalData { public async Task>> LoadNominals(IServiceProvider service, String inputFile) { var response = new ApiResponseObject>();

// First load file
var fileContents = File.ReadAllLines(inputFile);
var nominals = new List();

foreach (var file in fileContents)
{
  // line parts
  var lineParts = file.Split(',');

  var nominal = new NominalCodeDTO();
  nominal.BusinessUnitName = lineParts[0];
  nominal.Code = lineParts[1];
  nominal.Description = lineParts[2];

  nominals.Add(nominal);
}

var nominalService = service.GetService();
response = await nominalService.CreateList("", nominals);

return response;

}

public async Task>> LoadSuppliers(IServiceProvider service, String inputFile) { var response = new ApiResponseObject>();

// First load file
var fileContents = File.ReadAllLines(inputFile);
var toCreateList = new List();

foreach (var file in fileContents)
{
  // line parts
  var lineParts = file.Split(',');

  var supplier = new SupplierDTO();
  supplier.BusinessUnitName = lineParts[0];
  supplier.AccountCode = lineParts[1];
  supplier.Name = lineParts[2];
  supplier.AddressLine1 = lineParts[3];
  supplier.AddressLine2 = lineParts[4];
  supplier.AddressLine2 = lineParts[5];
  supplier.AddressLine2 = lineParts[6];
  supplier.AddressLine2 = lineParts[7];
  supplier.Postcode = lineParts[8];
  supplier.ForeignId = lineParts[9];

  toCreateList.Add(supplier);
}

var supplierService = service.GetService();

response = await supplierService.CreateList("", toCreateList);

return response;

}

public async Task>> LoadTaxCodes(IServiceProvider service, String inputFile) { throw new NotImplementedException(); }

public async Task>> LoadBusinessUnits(IServiceProvider service, String inputFile) { throw new NotImplementedException(); }

public async Task>> LoadDepartments(IServiceProvider service, String inputFile) { throw new NotImplementedException(); }

public async Task>> LoadCostCentres(IServiceProvider service, String inputFile) { throw new NotImplementedException(); }

}