public static TrackPoint ConvertToModel(TrackPointsHistoryTableDataModel modelTrackPoint)
{
var trackPointId = modelTrackPoint.EmployeeId ?? modelTrackPoint.VehicleId;
if (trackPointId == null)
return null;
var trackPoint = new TrackPoint
{
Heading = null,
Id = (Guid)trackPointId,
CollectedTimeStamp = modelTrackPoint.CollectedTimeStamp,
Latitude = (decimal?)modelTrackPoint.Latitude,
Longitude = (decimal?)modelTrackPoint.Longitude,
Speed = null,
Source = null,
RouteId = modelTrackPoint.RouteId,
Accuracy = modelTrackPoint.Accuracy
};
return trackPoint;
}
/// <summary>
/// Populates HistoricalTrackPoints design data on the Azure tables.
/// </summary>
public static void CreateHistoricalTrackPoints()
{
var coreEntitiesContainer = new CoreEntitiesContainer();
var businessAccountIds = coreEntitiesContainer.Parties.OfType<BusinessAccount>().Select(ba => ba.Id);
foreach (var businessAccountId in businessAccountIds)
{
var tableName = businessAccountId.TrackPointTableName();
var storageAccount = CloudStorageAccount.Parse(AzureServerHelpers.StorageConnectionString);
var serviceContext = new TrackPointsHistoryContext(storageAccount.TableEndpoint.ToString(), storageAccount.Credentials);
var tableClient = storageAccount.CreateCloudTableClient();
//Create the empty table once again
tableClient.CreateTableIfNotExist(tableName);
var serviceDate = DateTime.UtcNow;
var routes = coreEntitiesContainer.Routes.Where(r => r.Date == serviceDate.Date && r.OwnerBusinessAccountId == businessAccountId).OrderBy(r => r.Id);
//Do not setup design data for Test or Release
#if DEBUG
#region Setup Design Data for Historical Track Points
var numberOfRoutes = routes.Count();
var count = 1;
foreach (var route in routes)
{
var routeNumber = count % numberOfRoutes;
switch (routeNumber)
{
//This would be the 4th, 8th, etc
case 0:
var employees = route.Employees;
foreach (var employee in employees)
{
var latitude = 40.4599;
var longitude = -86.9309;
//Sets timeStamp to be 9:00 AM yesterday
var timeStamp = new DateTime(DateTime.UtcNow.Year, DateTime.UtcNow.Month, DateTime.UtcNow.Day, 9, 0, 0);
for (var totalCount = 1; totalCount <= 3; totalCount++)
{
var partitionKey = Guid.NewGuid().ToString();
for (var innerCount = 1; innerCount < 99; innerCount++)
{
//Create the object to be stored in the Azure table
var newTrackPoint = new TrackPointsHistoryTableDataModel(partitionKey, Guid.NewGuid().ToString())
{
EmployeeId = employee.Id,
VehicleId = null,
RouteId = route.Id,
Latitude = latitude,
Longitude = longitude,
CollectedTimeStamp = timeStamp,
Accuracy = 1
};
latitude = latitude + .001;
longitude = longitude + .001;
timeStamp = timeStamp.AddSeconds(30);
//Push to Azure Table
serviceContext.AddObject(tableName, newTrackPoint);
}
serviceContext.SaveChangesWithRetries(SaveChangesOptions.Batch);
}
}
break;
//This would be the 1st, 5th, etc
case 1:
employees = route.Employees;
foreach (var employee in employees)
{
var latitude = 40.4599;
var longitude = -86.9309;
//Sets timeStamp to be 9:00 AM yesterday
var timeStamp = new DateTime(DateTime.UtcNow.Year, DateTime.UtcNow.Month, DateTime.UtcNow.Day, 9, 0, 0);
for (var totalCount = 1; totalCount <= 3; totalCount++)
{
var partitionKey = Guid.NewGuid().ToString();
for (var innerCount = 1; innerCount <= 99; innerCount++)
{
//Create the object to be stored in the Azure table
var newTrackPoint = new TrackPointsHistoryTableDataModel(partitionKey, Guid.NewGuid().ToString())
{
EmployeeId = employee.Id,
VehicleId = null,
RouteId = route.Id,
Latitude = latitude,
Longitude = longitude,
CollectedTimeStamp = timeStamp,
Accuracy = 1
};
latitude = latitude - .001;
longitude = longitude + .001;
timeStamp = timeStamp.AddSeconds(30);
//Push to Azure Table
serviceContext.AddObject(tableName, newTrackPoint);
}
serviceContext.SaveChangesWithRetries(SaveChangesOptions.Batch);
}
}
break;
//This would be the 2nd, 6th, etc
case 2:
employees = route.Employees;
foreach (var employee in employees)
{
var latitude = 40.4599;
var longitude = -86.9309;
//Sets timeStamp to be 9:00 AM yesterday
var timeStamp = new DateTime(DateTime.UtcNow.Year, DateTime.UtcNow.Month, DateTime.UtcNow.Day, 9, 0, 0);
for (var totalCount = 1; totalCount <= 3; totalCount++)
{
var partitionKey = Guid.NewGuid().ToString();
for (var innerCount = 1; innerCount <= 99; innerCount++)
{
//Create the object to be stored in the Azure table
var newTrackPoint = new TrackPointsHistoryTableDataModel(partitionKey, Guid.NewGuid().ToString())
{
EmployeeId = employee.Id,
VehicleId = null,
RouteId = route.Id,
Latitude = latitude,
Longitude = longitude,
CollectedTimeStamp = timeStamp,
Accuracy = 2
};
latitude = latitude + .001;
longitude = longitude - .001;
timeStamp = timeStamp.AddSeconds(30);
//Push to Azure Table
serviceContext.AddObject(tableName, newTrackPoint);
}
serviceContext.SaveChangesWithRetries(SaveChangesOptions.Batch);
}
}
break;
//This would be the 3rd, 7th, etc
case 3:
employees = route.Employees;
foreach (var employee in employees)
{
var latitude = 40.4599;
var longitude = -86.9309;
//Sets timeStamp to be 9:00 AM yesterday
var timeStamp = new DateTime(DateTime.UtcNow.Year, DateTime.UtcNow.Month, DateTime.UtcNow.Day, 9, 0, 0);
for (var totalCount = 1; totalCount <= 3; totalCount++)
{
var partitionKey = Guid.NewGuid().ToString();
for (var innerCount = 1; innerCount <= 99; innerCount++)
{
//Create the object to be stored in the Azure table
var newTrackPoint = new TrackPointsHistoryTableDataModel(partitionKey, Guid.NewGuid().ToString())
{
EmployeeId = employee.Id,
VehicleId = null,
RouteId = route.Id,
Latitude = latitude,
Longitude = longitude,
CollectedTimeStamp = timeStamp,
Accuracy = 3
};
latitude = latitude - .001;
longitude = longitude - .001;
timeStamp = timeStamp.AddSeconds(30);
//Push to Azure Table
serviceContext.AddObject(tableName, newTrackPoint);
}
serviceContext.SaveChangesWithRetries(SaveChangesOptions.Batch);
}
}
break;
}
count++;
}
#endregion
#endif
}
}
/// <summary>
/// Takes a ModelTrackPoint and pushed it to the AzureTables
/// </summary>
/// <param name="currentBusinessAccount">The current BusinessAccount</param>
/// <param name="trackPoint">The Model TrackPoint to be pushed to AzureTables</param>
/// <param name="employee">The employee</param>
/// <param name="routeId">The Id of the Route that the vehicle or employee are currently on</param>
private void PushTrackPointToAzure(Core.Models.CoreEntities.BusinessAccount currentBusinessAccount, TrackPoint trackPoint, Core.Models.CoreEntities.Employee employee, Guid routeId)
{
//Get the storage account information from Azure
var storageAccount = CloudStorageAccount.Parse(AzureServerHelpers.StorageConnectionString);
//Create the Service Context for the TrackPointsHistory Tables
var serviceContext = new TrackPointsHistoryContext(storageAccount.TableEndpoint.ToString(), storageAccount.Credentials);
var tableName = CheckCreateTrackPointTable(storageAccount, currentBusinessAccount);
//Create the object to be stored in the Azure table
var newTrackPoint = new TrackPointsHistoryTableDataModel(Guid.NewGuid().ToString(), Guid.NewGuid().ToString())
{
EmployeeId = employee.Id,
VehicleId = new Guid(),
RouteId = routeId,
Latitude = (double?)trackPoint.Latitude,
Longitude = (double?)trackPoint.Longitude,
CollectedTimeStamp = trackPoint.CollectedTimeStamp,
Accuracy = trackPoint.Accuracy
};
//Push to Azure Table
serviceContext.AddObject(tableName, newTrackPoint);
//Saves the Tables
serviceContext.SaveChangesWithRetries();
}
