public static List <RouteScheduleSummary> GetSchedules() { using (var db = new TrolleyTracker.Models.TrolleyTrackerContext()) { var currentDateTime = UTCToLocalTime.LocalTimeFromUTC(DateTime.UtcNow); var fixedRouteSchedules = (from route in db.Routes from routeSchedule in db.RouteSchedules orderby routeSchedule.StartTime, routeSchedule.Route.ShortName where (routeSchedule.RouteID == route.ID) select routeSchedule).ToList <RouteSchedule>(); var today = currentDateTime.Date; var routeScheduleOverrideList = (from rso in db.RouteScheduleOverrides orderby rso.OverrideDate, rso.StartTime, rso.NewRoute.ShortName select rso).ToList <RouteScheduleOverride>(); var scheduleToDate = new Dictionary <RouteSchedule, DateTime>(); var routeSchedules = BuildScheduleView.BuildEffectiveRouteSchedule(currentDateTime, 7, fixedRouteSchedules, scheduleToDate, routeScheduleOverrideList); var schedules = new List <RouteScheduleSummary>(); foreach (var routeSchedule in routeSchedules) { schedules.Add(new RouteScheduleSummary(routeSchedule)); } return(schedules); } }
public ActionResult CreateConfirm(FormCollection collection) { var resultText = "Unknown error"; var errorText = ""; try { using (var db = new TrolleyTracker.Models.TrolleyTrackerContext()) { var strRouteID = collection.Get("RouteID"); int routeID = Convert.ToInt32(strRouteID); var route = db.Routes.Find(routeID); resultText = ""; var jsonShapes = collection.Get("RouteShapeJSON"); if (jsonShapes != null && strRouteID != null) { RemoveOldShape(routeID, db); SaveNewRouteShape(db, route, jsonShapes); var jsonStops = collection.Get("NewRouteStops"); var newStopCount = SaveNewRouteStops(db, jsonStops); var assignStops = new AssignStopsToRoutes(); assignStops.UpdateStopsForRoute(db, routeID); logger.Info($"Modified route shape of '{route.ShortName}' - '{route.LongName}, added {newStopCount} stops.'"); resultText = $"Route path for {route.ShortName} Saved, added {newStopCount} stops."; } } } catch (DbEntityValidationException dbEx) { foreach (var validationErrors in dbEx.EntityValidationErrors) { foreach (var validationError in validationErrors.ValidationErrors) { logger.Info("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage); } } errorText = "Oops - Shape save exception. This has been logged"; logger.Error(dbEx, "Exception processing route shape"); } catch (Exception ex) { // Unexpected error in parse or preview errorText = "Oops - Shape save exception. This has been logged"; logger.Error(ex, "Exception processing route shape"); } ViewBag.RouteID = GetRouteSelectList(null); ViewBag.ErrorMessage = errorText; ViewBag.Message = resultText; return(View("Create")); }
public void UpdateStopsForAllRoutes() { using (var db = new TrolleyTracker.Models.TrolleyTrackerContext()) { var routes = from Route in db.Routes select Route; foreach (var route in routes) { UpdateStopsForRoute(db, route.ID); } } }
public void UpdateStopsForAllRoutes() { using (var db = new TrolleyTracker.Models.TrolleyTrackerContext()) { var routes = from Route in db.Routes select Route; foreach (var route in routes) { UpdateStopsForRoute(db, route.ID); } } }
public IHttpActionResult PostLocation(int id, LocationUpdate locationUpdate) { if (AppSettingsInterface.UseSyncromatics) { return(Ok()); // Disregard beacon if using Syncromatics } if (!ModelState.IsValid) { return(BadRequest(ModelState)); } using (var db = new TrolleyTracker.Models.TrolleyTrackerContext()) { var trolley = (from Trolley t in db.Trolleys where t.Number == id select t).FirstOrDefault <Trolley>(); if (trolley == null) { return(NotFound()); } if ((locationUpdate.Lat < -90.0) || (locationUpdate.Lat > 90)) { return(BadRequest("Invalid latitude")); } if ((locationUpdate.Lon < -180.0) || (locationUpdate.Lon > 180)) { return(BadRequest("Invalid longitude")); } trolley.CurrentLat = locationUpdate.Lat; trolley.CurrentLon = locationUpdate.Lon; trolley.LastBeaconTime = UTCToLocalTime.LocalTimeFromUTC(DateTime.UtcNow); if (lastTrolleyWriteTime.ContainsKey(trolley.Number)) { if ((DateTime.Now - lastTrolleyWriteTime[trolley.Number]).TotalSeconds > 30.0) { db.SaveChanges(); lastTrolleyWriteTime[trolley.Number] = DateTime.Now; } } else { lastTrolleyWriteTime.Add(trolley.Number, DateTime.Now); } TrolleyCache.UpdateTrolley(trolley); StopArrivalTime.UpdateTrolleyStopArrivalTime(trolley); return(Ok()); } }
// GET: api/Routes public List <RouteSummary> GetRoutes() { using (var db = new TrolleyTracker.Models.TrolleyTrackerContext()) { var routes = db.Routes; var summaryRoutes = new List <RouteSummary>(); foreach (var route in routes) { var summaryRoute = new RouteSummary(route); summaryRoutes.Add(summaryRoute); } return(summaryRoutes); } }
public IHttpActionResult GetRouteSchedule(int id) { using (var db = new TrolleyTracker.Models.TrolleyTrackerContext()) { RouteSchedule routeSchedule = db.RouteSchedules.Find(id); if (routeSchedule == null) { return(NotFound()); } var routeScheduleSummary = new RouteScheduleSummary(routeSchedule); return(Ok(routeScheduleSummary)); } }
// GET: api/Trolleys/5/Location public Trolley Get(int id) { if (!ModelState.IsValid) { return(null); } using (var db = new TrolleyTracker.Models.TrolleyTrackerContext()) { var trolley = (from Trolley t in db.Trolleys where t.Number == id select t).FirstOrDefault <Trolley>(); return(trolley); } }
private Trolley GetTrolleyByNumber(int trolleyNumber) { using (var db = new TrolleyTracker.Models.TrolleyTrackerContext()) { Trolley trolley = (from Trolley t in db.Trolleys where t.Number == trolleyNumber select t).FirstOrDefault <Trolley>(); if (trolley == null) { SingleLog(SingleLogType.UnmatchedSyncromaticsVehicle, $"Unable to find Trolley {trolleyNumber}"); } return(trolley); } }
private async Task SaveTrolleyToDB(Trolley trolley) { using (var db = new TrolleyTracker.Models.TrolleyTrackerContext()) { Trolley dbTrolley = (from Trolley t in db.Trolleys where t.ID == trolley.ID select t).FirstOrDefault <Trolley>(); dbTrolley.CurrentLat = trolley.CurrentLat; dbTrolley.CurrentLon = trolley.CurrentLon; dbTrolley.LastBeaconTime = trolley.LastBeaconTime; dbTrolley.IconColorRGB = trolley.IconColorRGB; dbTrolley.Capacity = trolley.Capacity; dbTrolley.PassengerLoad = trolley.PassengerLoad; await db.SaveChangesAsync(cancellationToken); } }
const double MinStopProximity = 20.0; // Meters #endregion Fields #region Methods /// <summary> /// Recalculate which routes the stops belong to, and the order. /// Call after any change to route or stops /// </summary> /// <param name="routeID">Route being recalculated</param> /// <param name="shapePoints"></param> /// <param name="stopPoints"></param> public void UpdateRouteStops(TrolleyTrackerContext db, int routeID, List<Coordinate> shapePoints, List<Stop> stops) { RemovePreviousRouteStops(db, routeID); var route = (from Route in db.Routes where Route.ID == routeID select Route).FirstOrDefault<Route>(); // A stop is considered to belong to a route if it's within MinStopProximity meters of the route path var routeStopList = new List<Stop>(); if (route.FlagStopsOnly) { // No stops to generate return; } for (int i=1; i< shapePoints.Count; i++) { for (int s=0; s< stops.Count; s++) { var stop = stops[s]; var stopPosition = new Coordinate(0, stop.Lat, stop.Lon, null); Coordinate closest = null; var distance = FindDistanceToSegment(stopPosition, shapePoints[i], shapePoints[i - 1], out closest); if (distance < MinStopProximity) { if (!routeStopList.Contains(stop)) { routeStopList.Add(stop); } //break; // Bug? How to handle case of ordering multiple stops in a long straight segment } } } for (int i=0; i < routeStopList.Count; i++) { var newRouteStop = db.RouteStops.Create(); newRouteStop.RouteID = routeID; newRouteStop.StopID = routeStopList[i].ID; newRouteStop.StopSequence = i; db.RouteStops.Add(newRouteStop); } db.SaveChanges(); }
public IHttpActionResult GetRoute(int id) { using (var db = new TrolleyTracker.Models.TrolleyTrackerContext()) { Route route = db.Routes.Find(id); if (route == null) { return(NotFound()); } // Assemble route + Stops + Shape var routeDetail = new RouteDetail(route); routeDetail.AddRouteDetail(db, route); return(Ok(routeDetail)); } }
// GET: Stops/Regular // Mapped as - GET: api/v1/Stops/Regular public List <GeoJSONSummary> Get() { using (var db = new TrolleyTracker.Models.TrolleyTrackerContext()) { var stops = (from stop in db.Stops from routeSchedule in db.RouteSchedules from routeStop in db.RouteStops where (routeSchedule.Route.ID == routeStop.RouteID && routeStop.StopID == stop.ID) //select stop); select stop).Select(stop => stop).ToList().Distinct(new StopComparer()).OrderBy(stop => stop.Name); var geoJSONStopsList = new List <GeoJSONSummary>(); foreach (var stop in stops) { geoJSONStopsList.Add(new GeoJSONSummary(stop)); } return(geoJSONStopsList); } }
public static RouteScheduleViewModel ConfigureScheduleView(TrolleyTrackerContext db, bool calculateEffectiveSchedule) { var vm = new RouteScheduleViewModel(); var routeSchedules = from rs in db.RouteSchedules.Include(rs => rs.Route) orderby rs.DayOfWeek, rs.StartTime ascending select rs; vm.RouteSchedules = (System.Data.Entity.Infrastructure.DbQuery<RouteSchedule>)routeSchedules; if (calculateEffectiveSchedule) { var routeScheduleOverrideList = (from rso in db.RouteScheduleOverrides.Include(rso => rso.NewRoute) orderby rso.OverrideDate, rso.StartTime, rso.NewRoute.ShortName select rso).ToList<RouteScheduleOverride>(); var routeScheduleList = routeSchedules.ToList<RouteSchedule>(); vm.EffectiveRouteSchedules = BuildEffectiveRouteSchedule(routeScheduleList, routeScheduleOverrideList); } vm.Options = new MvcScheduleGeneralOptions { Layout = LayoutEnum.Horizontal, SeparateDateHeader = false, FullTimeScale = true, TimeScaleInterval = 60, StartOfTimeScale = new TimeSpan(6, 0, 0), EndOfTimeScale = new TimeSpan(23, 59, 59), IncludeEndValue = false, ShowValueMarks = true, ItemCss = "normal", AlternatingItemCss = "normal2", RangeHeaderCss = "heading", TitleCss = "heading", AutoSortTitles = false, BackgroundCss = "empty" }; return vm; }
private void RemovePreviousRouteStops(TrolleyTrackerContext db, int routeID) { var routeStops = from RouteStop rs in db.RouteStops where rs.RouteID == routeID select rs; foreach (var rs in routeStops) { db.RouteStops.Remove(rs); } db.SaveChanges(); }
public void UpdateStopsForRoute(TrolleyTrackerContext db, int routeID) { var shapes = (from Shape in db.Shapes where Shape.RouteID == routeID orderby Shape.Sequence select Shape).ToList<Shape>(); var shapePoints = new List<Coordinate>(); foreach (var shape in shapes) { var coord = new Coordinate(shape.Lat, shape.Lon); shapePoints.Add(coord); } var stops = (from Stop s in db.Stops select s).ToList<Stop>(); UpdateRouteStops(db, routeID, shapePoints, stops); }
private void RemoveOldShape(int routeID, TrolleyTrackerContext db) { // Slow way //var oldShapes = from shape in db.Shapes // where shape.RouteID == routeID // select shape; //foreach(var shape in oldShapes) //{ // db.Shapes.Remove(shape); //} //db.SaveChanges(); // delete existing records db.Database.ExecuteSqlCommand("DELETE FROM Shapes WHERE RouteID = " + routeID); }
public ActionResult Create(FormCollection collection) { try { Coordinate lastCoordinate = null; var strRouteID = collection.Get("RouteID"); // Parse Geo-JSON formatted route coordinates var jsonShapes = collection.Get("JSONText"); if (jsonShapes != null && strRouteID != null) { int routeID = Convert.ToInt32(strRouteID); using (var db = new TrolleyTracker.Models.TrolleyTrackerContext()) { RemoveOldShape(routeID, db); JavaScriptSerializer jss = new JavaScriptSerializer(); jss.RegisterConverters(new JavaScriptConverter[] { new DynamicJsonConverter() }); dynamic shapeData = jss.Deserialize(jsonShapes, typeof(object)) as dynamic; var features = shapeData.features; var geometryBlock = features[0]; var geometry = geometryBlock["geometry"]; var geoJSONtype = geometry["type"]; var coordinates = geometry["coordinates"]; int segmentCount = coordinates.Count; if (geoJSONtype == "LineString") segmentCount = 1; int sequence = 0; double totalDistance = 0.0; for (int seg = 0; seg < segmentCount; seg++) { var coordArray = coordinates[seg]; if (geoJSONtype == "LineString") coordArray = coordinates; int nodeCount = coordArray.Count; for (int i = 0; i < nodeCount; i++) { var node = coordArray[i]; var strLon = node[0]; var strLat = node[1]; var lon = Convert.ToDouble(strLon); var lat = Convert.ToDouble(strLat); var thisCoordinate = new Coordinate(0, lat, lon, null); double distance = 0.0; if (lastCoordinate != null) { distance = thisCoordinate.GreatCircleDistance(lastCoordinate); } lastCoordinate = thisCoordinate; totalDistance += distance; var dbShape = new TrolleyTracker.Models.Shape(); dbShape.Lat = lat; dbShape.Lon = lon; dbShape.RouteID = routeID; dbShape.Sequence = sequence; dbShape.DistanceTraveled = totalDistance; sequence++; db.Shapes.Add(dbShape); } } db.SaveChanges(); var assignStops = new AssignStopsToRoutes(); assignStops.UpdateStopsForRoute(db, routeID); } } return RedirectToAction("Index"); } catch { return View(); } }
public ActionResult Create(FormCollection collection) { try { Coordinate lastCoordinate = null; var strRouteID = collection.Get("RouteID"); // Parse Geo-JSON formatted route coordinates var jsonShapes = collection.Get("JSONText"); if (jsonShapes != null && strRouteID != null) { int routeID = Convert.ToInt32(strRouteID); using (var db = new TrolleyTracker.Models.TrolleyTrackerContext()) { RemoveOldShape(routeID, db); JavaScriptSerializer jss = new JavaScriptSerializer(); jss.RegisterConverters(new JavaScriptConverter[] { new DynamicJsonConverter() }); dynamic shapeData = jss.Deserialize(jsonShapes, typeof(object)) as dynamic; var features = shapeData.features; var geometryBlock = features[0]; var geometry = geometryBlock["geometry"]; var geoJSONtype = geometry["type"]; var coordinates = geometry["coordinates"]; int segmentCount = coordinates.Count; if (geoJSONtype == "LineString") { segmentCount = 1; } int sequence = 0; double totalDistance = 0.0; for (int seg = 0; seg < segmentCount; seg++) { var coordArray = coordinates[seg]; if (geoJSONtype == "LineString") { coordArray = coordinates; } int nodeCount = coordArray.Count; for (int i = 0; i < nodeCount; i++) { var node = coordArray[i]; var strLon = node[0]; var strLat = node[1]; var lon = Convert.ToDouble(strLon); var lat = Convert.ToDouble(strLat); var thisCoordinate = new Coordinate(lat, lon); double distance = 0.0; if (lastCoordinate != null) { distance = thisCoordinate.GreatCircleDistance(lastCoordinate); } lastCoordinate = thisCoordinate; totalDistance += distance; var dbShape = new TrolleyTracker.Models.Shape(); dbShape.Lat = lat; dbShape.Lon = lon; dbShape.RouteID = routeID; dbShape.Sequence = sequence; dbShape.DistanceTraveled = totalDistance; sequence++; db.Shapes.Add(dbShape); } } db.SaveChanges(); var assignStops = new AssignStopsToRoutes(); assignStops.UpdateStopsForRoute(db, routeID); var route = db.Routes.Find(routeID); logger.Info($"Modified route shape of '{route.Description}' - '{route.LongName}'"); } } return(RedirectToAction("Index")); } catch (Exception ex) { ViewBag.Message = "Shape save exception"; logger.Error(ex, "Exception saving route shape"); ViewBag.RouteID = new SelectList(db.Routes, "ID", "ShortName"); return(View()); } }