public void UpdateByID(int routeID, string newDescription) { Models.ApproachRoute route = (from r in db.ApproachRoutes where r.ApproachRouteId == routeID select r).FirstOrDefault(); if (route != null) { Models.ApproachRoute newroute = new Models.ApproachRoute(); newroute.ApproachRouteId = route.ApproachRouteId; newroute.RouteName = newDescription; try { db.Entry(route).CurrentValues.SetValues(newroute); db.SaveChanges(); } catch (Exception ex) { MOE.Common.Models.Repositories.IApplicationEventRepository repository = MOE.Common.Models.Repositories.ApplicationEventRepositoryFactory.Create(); MOE.Common.Models.ApplicationEvent error = new ApplicationEvent(); error.ApplicationName = "MOE.Common"; error.Class = "Models.Repository.ApproachRouteRepository"; error.Function = "UpdateByID"; error.Description = ex.Message; error.SeverityLevel = ApplicationEvent.SeverityLevels.High; error.Timestamp = DateTime.Now; repository.Add(error); throw; } } }
public Models.ApproachRoute GetRouteByName(string routeName) { Models.ApproachRoute route = (from r in db.ApproachRoutes where r.RouteName == routeName select r).FirstOrDefault(); return(route); }
public Models.ApproachRoute GetRouteByID(int routeID) { Models.ApproachRoute route = (from r in db.ApproachRoutes where r.ApproachRouteId == routeID select r).FirstOrDefault(); if (route != null) { return(route); } else { { MOE.Common.Models.Repositories.IApplicationEventRepository repository = MOE.Common.Models.Repositories.ApplicationEventRepositoryFactory.Create(); MOE.Common.Models.ApplicationEvent error = new ApplicationEvent(); error.ApplicationName = "MOE.Common"; error.Class = "Models.Repository.ApproachRouteRepository"; error.Function = "GetByRouteID"; error.Description = "No ApproachRoute for ID. Attempted ID# = " + routeID.ToString(); error.SeverityLevel = ApplicationEvent.SeverityLevels.High; error.Timestamp = DateTime.Now; repository.Add(error); throw (new Exception("There is no ApproachRoute for this ID")); } } }
public void ConvertApproachDetailDirections() { Console.WriteLine("Creating Approaches"); List <MOE.Common.Models.ApproachRoute> ApproachRoutes = new List <Models.ApproachRoute>(); foreach (var ApproachRouteRow in RouteTable) { MOE.Common.Models.ApproachRoute approachRoute = new Models.ApproachRoute(); approachRoute.RouteName = ApproachRouteRow.RouteName; approachRoute.ApproachRouteId = ApproachRouteRow.ApproachRouteId; approachRoute.ApproachRouteDetails = new List <Models.ApproachRouteDetail>(); ApproachRoutes.Add(approachRoute); } foreach (var DetailRow in RouteDetailTable) { var approachRoute = ApproachRoutes.Where(ar => ar.ApproachRouteId == DetailRow.ApproachRouteId).FirstOrDefault(); var approach = db.Approaches .Where(a => a.SignalID == DetailRow.SignalID && a.DirectionType.Description == DetailRow.Direction) .FirstOrDefault(); if (approach != null) { Models.ApproachRouteDetail ard = new Models.ApproachRouteDetail(); ard.ApproachOrder = DetailRow.ApproachOrder; ard.ApproachID = approach.ApproachID; approachRoute.ApproachRouteDetails.Add(ard); } } db.ApproachRoutes.AddRange(ApproachRoutes); Console.WriteLine("Saving Approaches"); db.SaveChanges(); }
public void DeleteByID(int routeID) { Models.ApproachRoute route = (from r in db.ApproachRoutes where r.ApproachRouteId == routeID select r).FirstOrDefault(); db.ApproachRoutes.Remove(route); db.SaveChanges(); }
public void Add(Models.ApproachRoute newRoute) { try { db.ApproachRoutes.Add(newRoute); db.SaveChanges(); } catch (Exception ex) { MOE.Common.Models.Repositories.IApplicationEventRepository repository = MOE.Common.Models.Repositories.ApplicationEventRepositoryFactory.Create(); MOE.Common.Models.ApplicationEvent error = new ApplicationEvent(); error.ApplicationName = "MOE.Common"; error.Class = "Models.Repository.ApproachRouteRepository"; error.Function = "Add"; error.Description = ex.Message; error.SeverityLevel = ApplicationEvent.SeverityLevels.High; error.Timestamp = DateTime.Now; repository.Add(error); throw; } }
public List <Models.RouteSignal> GetRouteDetails(Models.ApproachRoute Route) { MOE.Common.Models.Repositories.IApproachRouteDetailRepository ardr = MOE.Common.Models.Repositories.ApproachRouteDetailRepositoryFactory.Create(); return(ardr.GetByRouteID(Route.Id)); }