//For the Fire Station Points
public static Task UpdateFireStationLocations(List <FireStationServicesDTO> fireStations)
{
DataModel db = new DataModel();
List <PointsOfInterest> pointsOfInterests = db.PointsOfInterest.ToList();
foreach (var fireStation in fireStations)
{
PointsOfInterest existingPointsOfInterest =
pointsOfInterests.FirstOrDefault(x => x.Name == fireStation.Name);
if (existingPointsOfInterest == null)
{
PointsOfInterest pointsOfInterestModel = new PointsOfInterest();
pointsOfInterestModel.Name = fireStation.Name;
pointsOfInterestModel.Latitude = fireStation.Location.Coordinates[1].ToString();
pointsOfInterestModel.Longitude = fireStation.Location.Coordinates[0].ToString();
pointsOfInterestModel.Type = "Fire Station";
var latLongLocation = new Loc(Convert.ToDouble(pointsOfInterestModel.Latitude), Convert.ToDouble(pointsOfInterestModel.Longitude));
pointsOfInterestModel.Location = QuadrantIdentifier.getLocationInCalgary(latLongLocation);
db.PointsOfInterest.Add(pointsOfInterestModel);
}
}
db.SaveChanges();
return(Task.FromResult(0));
}
public static Task UpdateTransitLRTStations(List <TransitLRTStationsDTO> transitLRTStations)
{
DataModel db = new DataModel();
List <PointsOfInterest> pointsOfInterests = db.PointsOfInterest.ToList();
foreach (var transitLRTStation in transitLRTStations)
{
PointsOfInterest existingPointsOfInterest =
pointsOfInterests.FirstOrDefault(x => x.Name == transitLRTStation.Stationnam);
if (existingPointsOfInterest == null)
{
PointsOfInterest pointsOfInterestModel = new PointsOfInterest();
pointsOfInterestModel.Name = transitLRTStation.Stationnam;
pointsOfInterestModel.Latitude = transitLRTStation.Latitude;
pointsOfInterestModel.Longitude = transitLRTStation.Longitude;
pointsOfInterestModel.Type = "CTrain";
var latLongLocation = new Loc(Convert.ToDouble(transitLRTStation.Latitude), Convert.ToDouble(transitLRTStation.Longitude));
pointsOfInterestModel.Location = QuadrantIdentifier.getLocationInCalgary(latLongLocation);
db.PointsOfInterest.Add(pointsOfInterestModel);
}
}
db.SaveChanges();
return(Task.FromResult(0));
}
//For the Police Station Locations
public static Task UpdatePoliceLocations(List <PoliceServiceOfficesDTO> policeStations)
{
DataModel db = new DataModel();
List <PointsOfInterest> pointsOfInterests = db.PointsOfInterest.ToList();
foreach (var policeStation in policeStations)
{
PointsOfInterest existingPointsOfInterest =
pointsOfInterests.FirstOrDefault(x => x.Name == policeStation.Name);
if (existingPointsOfInterest == null)
{
PointsOfInterest pointsOfInterestModel = new PointsOfInterest();
pointsOfInterestModel.Name = policeStation.Name;
//Police Station api has longitude and latitude wrong so I had to switch them around
pointsOfInterestModel.Latitude = policeStation.Longitude;
pointsOfInterestModel.Longitude = policeStation.Latitude.ToString();
pointsOfInterestModel.Type = "Police Station";
var latLongLocation = new Loc(Convert.ToDouble(pointsOfInterestModel.Latitude), Convert.ToDouble(pointsOfInterestModel.Longitude));
pointsOfInterestModel.Location = QuadrantIdentifier.getLocationInCalgary(latLongLocation);
db.PointsOfInterest.Add(pointsOfInterestModel);
}
}
db.SaveChanges();
return(Task.FromResult(0));
}
//For the Recreational Facilities
public static Task UpdateRecreationalLocations(List <RecreationFacilitiesDTO> recreationFacilities)
{
DataModel db = new DataModel();
List <PointsOfInterest> pointsOfInterests = db.PointsOfInterest.ToList();
foreach (var recreationFacility in recreationFacilities)
{
PointsOfInterest existingPointsOfInterest =
pointsOfInterests.FirstOrDefault(x => x.Name == recreationFacility.ComplexName);
if (existingPointsOfInterest == null)
{
PointsOfInterest pointsOfInterestModel = new PointsOfInterest();
pointsOfInterestModel.Name = recreationFacility.ComplexName;
pointsOfInterestModel.Latitude = recreationFacility.Latitude.ToString();
pointsOfInterestModel.Longitude = recreationFacility.Longitude.ToString();
pointsOfInterestModel.Type = recreationFacility.FacilityType;
var latLongLocation = new Loc(Convert.ToDouble(pointsOfInterestModel.Latitude), Convert.ToDouble(pointsOfInterestModel.Longitude));
pointsOfInterestModel.Location = QuadrantIdentifier.getLocationInCalgary(latLongLocation);
db.PointsOfInterest.Add(pointsOfInterestModel);
}
}
db.SaveChanges();
return(Task.FromResult(0));
}
private static void addQuadrantToEvent(Event eventModel)
{
double lat, lng;
if (Double.TryParse(eventModel.Latitude, out lat) && Double.TryParse(eventModel.Longitude, out lng))
{
eventModel.Quadrant = QuadrantIdentifier.getLocationInCalgary(new Loc(lat, lng));
}
}
