public ImportJobResult Process(string filePath, int subscriberId, bool syncLocations, bool syncJobs, bool saveToDatabase)
{
int locationErrorCount = 0;
int createdJobCount = 0;
var errorJobCount = 0;
int updatedJobCount = 0;
int existingJobCount = 0;
int recreatedRouteStopCount = 0;
var result = ImportJobs(filePath, subscriberId);
var locationsByCustomerNumber = result.GetCompanyLocations(subscriberId, true);
Location matchingLocation = null;
locationsByCustomerNumber.TryGetValue("1863", out matchingLocation);
if (syncLocations)
{
var persistedLocations = SyncLocations(locationsByCustomerNumber.Values, subscriberId, out locationErrorCount);
if (syncJobs)
{
var extractedJobs = result.GetJobs(persistedLocations.ToDictionary(p => p.LegacyId), StopActions, subscriberId);
Console.WriteLine("Detected {0} jobs", extractedJobs.Count);
foreach (var job in extractedJobs)
{
var routeStops = job.RouteStops.Select(x =>
new PAI.Drayage.Optimization.Model.Orders.RouteStop
{
Id = x.Id,
ExecutionTime =
x.StopDelay.HasValue ? new TimeSpan(x.StopDelay.Value) : (TimeSpan?)null,
Location = new PAI.Drayage.Optimization.Model.Location
{
Id = x.Location.Id,
DisplayName = x.Location.DisplayName,
Latitude = x.Location.Latitude.HasValue ? x.Location.Latitude.Value : 0,
Longitude = x.Location.Longitude.HasValue ? x.Location.Longitude.Value : 0
},
PostTruckConfig = new TruckConfiguration(),
PreTruckConfig = new TruckConfiguration(),
QueueTime = null,
StopAction =
PAI.Drayage.Optimization.Model.Orders.StopActions.Actions.First(
y => y.ShortName == x.StopAction.ShortName),
WindowEnd = new TimeSpan(x.WindowEnd),
WindowStart = new TimeSpan(x.WindowStart)
}).ToList();
var drayageJob = new PAI.Drayage.Optimization.Model.Orders.Job
{
Id = job.Id,
DisplayName = job.OrderNumber,
EquipmentConfiguration = new EquipmentConfiguration(),
IsFlatbed = job.IsFlatbed,
IsHazmat = job.IsHazmat,
RouteStops = routeStops
};
var validationResult = _validationService.ValidateJob(drayageJob, true, _distanceService);
job.IsValid = validationResult.Successful;
if (!validationResult.Successful)
{
if (job.RouteStops.Any(x => _validationService.InvalidTimes.Contains(new TimeSpan(x.WindowStart)) || _validationService.InvalidTimes.Contains(new TimeSpan(x.WindowEnd))))
{
job.RouteStops.First().StopAction = _stopActionService.GetById(Drayage.Optimization.Model.Orders.StopActions.DropOffLoadedWithChassis.Id);
}
ReportErrors.AddError(job.LegacyId + "\n" + validationResult.Errors.Aggregate((a, b) => a + "\n" + b));
errorJobCount++;
}
Job matchingJob = _jobService.SelectWithAll().FirstOrDefault(p => p.LegacyId == job.LegacyId);
if (matchingJob != null)
{
if (job.JobStatus == JobStatus.Completed)
{
Console.WriteLine("Order is already complete: {0}", job.LegacyId);
continue;
}
if (job.IsChangedFrom(matchingJob))
{
var updateResult = matchingJob.UpdateFrom(job);
if (updateResult.IsRouteStopsRecreated)
{
recreatedRouteStopCount++;
}
if (updateResult.IsJobError)
{
errorJobCount++;
}
if (saveToDatabase)
{
_jobService.Update(matchingJob);
}
updatedJobCount++;
}
else
{
existingJobCount++;
}
continue;
}
Console.WriteLine("Adding new job");
createdJobCount++;
if (saveToDatabase)
{
_jobService.Insert(job);
}
}
}
}
_syncLogEntryService.AddEntry(subscriberId, "Import Complete", "File: " + new FileInfo(filePath).Name,
errorJobCount, updatedJobCount, createdJobCount, existingJobCount, recreatedRouteStopCount,
locationErrorCount);
return(result);
}
