public static void Callback(Api api, DitAddress address)
{
var thing = _actionsLines.Where(x => x.GetInternalReference() == address.Reference).FirstOrDefault();
if (thing != null)
{
var path = "Addresses.csv";
var data = $"{address.Id},{address.Status},{address.Instructions},{address.Name},{address.Reference},{address.Warehouses},{address.Address},{address.Coordinates}";
File.AppendAllLines(path, new[] { data });
}
else
{
var path = "Report.txt";
var data = $"{thing.GetInternalReference()} Not found in DIT";
File.AppendAllLines(path, new[] { data });
}
}
static void Main(string[] args)
{
List <DitAddress> list = new List <DitAddress>();
var clientId = "371";
var api = new Api("https://rest.trackmatic.co.za/api/v1", clientId, "9408065009082");
api.Authenticate("yase191!");
string fname = @"Waltons.xlsx"; //Read from xls
Console.WriteLine("Reading file " + fname + ".");
IWorkbook workBook = WorkbookFactory.Create(new FileStream(Path.GetFullPath(fname), FileMode.Open, FileAccess.Read, FileShare.ReadWrite));
for (int i = 0; i < NumberOfSheets(workBook); i++)
{
ISheet sheet = workBook.GetSheetAt(i);
for (int row = 1; row <= sheet.LastRowNum; row++)
{
////PER Row
var cell0 = (sheet.GetRow(row).GetCell(0, MissingCellPolicy.CREATE_NULL_AS_BLANK)).ToString();
var cell1 = (sheet.GetRow(row).GetCell(1, MissingCellPolicy.CREATE_NULL_AS_BLANK)).ToString();
var cell2 = (sheet.GetRow(row).GetCell(2, MissingCellPolicy.CREATE_NULL_AS_BLANK)).ToString();
var cell3 = (sheet.GetRow(row).GetCell(3, MissingCellPolicy.CREATE_NULL_AS_BLANK)).ToString();
//var cell4 = (sheet.GetRow(row).GetCell(4, MissingCellPolicy.CREATE_NULL_AS_BLANK)).ToString();
//var cell5 = (sheet.GetRow(row).GetCell(5, MissingCellPolicy.CREATE_NULL_AS_BLANK)).ToString();
//var cell6 = (sheet.GetRow(row).GetCell(6, MissingCellPolicy.CREATE_NULL_AS_BLANK)).ToString();
var cell7 = (sheet.GetRow(row).GetCell(7, MissingCellPolicy.CREATE_NULL_AS_BLANK)).ToString();
var cell8 = (sheet.GetRow(row).GetCell(8, MissingCellPolicy.CREATE_NULL_AS_BLANK)).ToString();
var cell9 = (sheet.GetRow(row).GetCell(9, MissingCellPolicy.CREATE_NULL_AS_BLANK)).ToString();
var cell10 = (sheet.GetRow(row).GetCell(10, MissingCellPolicy.CREATE_NULL_AS_BLANK)).ToString();
var cell11 = (sheet.GetRow(row).GetCell(11, MissingCellPolicy.CREATE_NULL_AS_BLANK)).ToString();
var cell12 = (sheet.GetRow(row).GetCell(12, MissingCellPolicy.CREATE_NULL_AS_BLANK)).ToString();
var cell13 = (sheet.GetRow(row).GetCell(13, MissingCellPolicy.CREATE_NULL_AS_BLANK)).ToString();
var address = new DitAddress
{
Id = $"{clientId}/{cell1}",
ClientId = clientId,
Address = new StructuredAddress
{
Street = RemoveZaf(cell10),
Suburb = RemoveZaf(cell11),
City = RemoveZaf(cell12),
PostalCode = RemoveZaf(cell13),
},
Name = cell3,
Reference = $"{cell1}",
ZoneReference = cell7,
Status = EDitStatus.New,
Coordinates = new OCoord
{
Longitude = Convert.ToDouble(cell9),
Latitude = Convert.ToDouble(cell8),
},
BusinessInfo = new DitBusinessInfo
{
RegistrationNumber = cell2,
}
};
list.Add(address);
}
}
Console.WriteLine(Upload(api, list));
}
