public void Remove(int approachID) { Approach approach = db.Approaches.Find(approachID); if (approach != null) { try { db.Approaches.Remove(approach); 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.ApproachRepository"; error.Function = "Remove"; error.Description = ex.Message; error.SeverityLevel = ApplicationEvent.SeverityLevels.High; error.Timestamp = DateTime.Now; repository.Add(error); throw (ex); } } } }
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 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 MOE.Common.Models.Controller_Event_Log GetFirstEventBeforeDate(string signalID, int eventCode, DateTime date) { try { var events = (from s in db.Controller_Event_Log where s.SignalID == signalID && s.Timestamp >= date.AddDays(-1) && s.Timestamp < date && s.EventCode == eventCode select s).ToList(); events.Sort((x, y) => DateTime.Compare(x.Timestamp, y.Timestamp)); return(events.Last()); } catch (Exception ex) { MOE.Common.Models.Repositories.IApplicationEventRepository logRepository = MOE.Common.Models.Repositories.ApplicationEventRepositoryFactory.Create(); MOE.Common.Models.ApplicationEvent e = new MOE.Common.Models.ApplicationEvent(); e.ApplicationName = "MOE.Common"; e.Class = this.GetType().ToString(); e.Function = "GetEventsByEventCodesParamWithOffset"; e.SeverityLevel = MOE.Common.Models.ApplicationEvent.SeverityLevels.High; e.Description = ex.Message; e.Timestamp = DateTime.Now; logRepository.Add(e); throw; } }
public List <MOE.Common.Models.Controller_Event_Log> GetSignalEventsBetweenDates(string signalID, DateTime startTime, DateTime endTime) { try { return((from r in db.Controller_Event_Log where r.SignalID == signalID && r.Timestamp >= startTime && r.Timestamp < endTime select r).ToList()); } catch (Exception ex) { MOE.Common.Models.Repositories.IApplicationEventRepository logRepository = MOE.Common.Models.Repositories.ApplicationEventRepositoryFactory.Create(); MOE.Common.Models.ApplicationEvent e = new MOE.Common.Models.ApplicationEvent(); e.ApplicationName = "MOE.Common"; e.Class = this.GetType().ToString(); e.Function = "GetSignalEventsBetweenDates"; e.SeverityLevel = MOE.Common.Models.ApplicationEvent.SeverityLevels.High; e.Timestamp = DateTime.Now; e.Description = ex.Message; logRepository.Add(e); throw; } }
public List <MOE.Common.Models.Controller_Event_Log> GetEventsByEventCodesParamWithOffset(string signalID, DateTime startTime, DateTime endTime, List <int> eventCodes, int param, double offset) { try { var events = (from s in db.Controller_Event_Log where s.SignalID == signalID && s.Timestamp >= startTime && s.Timestamp <= endTime && s.EventParam == param && eventCodes.Contains(s.EventCode) select s).ToList(); events.Sort((x, y) => DateTime.Compare(x.Timestamp, y.Timestamp)); foreach (var cel in events) { cel.Timestamp = cel.Timestamp.AddMilliseconds(offset); } return(events); } catch (Exception ex) { MOE.Common.Models.Repositories.IApplicationEventRepository logRepository = MOE.Common.Models.Repositories.ApplicationEventRepositoryFactory.Create(); MOE.Common.Models.ApplicationEvent e = new MOE.Common.Models.ApplicationEvent(); e.ApplicationName = "MOE.Common"; e.Class = this.GetType().ToString(); e.Function = "GetEventsByEventCodesParamWithOffset"; e.SeverityLevel = MOE.Common.Models.ApplicationEvent.SeverityLevels.High; e.Timestamp = DateTime.Now; e.Description = ex.Message; logRepository.Add(e); throw; } }
public void UpdateByRouteAndApproachID(int routeID, int approachID, int newOrderNumber) { Models.ApproachRouteDetail RouteDetail = (from r in db.ApproachRouteDetails where r.ApproachRouteId == routeID && r.ApproachID == approachID select r).FirstOrDefault(); if (RouteDetail != null) { Models.ApproachRouteDetail newRouteDetail = new Models.ApproachRouteDetail(); newRouteDetail.ApproachOrder = newOrderNumber; try { db.Entry(RouteDetail).CurrentValues.SetValues(newRouteDetail); 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.ApproachRouteDetailsRepository"; error.Function = "UpdateByRouteAndApproachID"; error.Description = ex.Message; error.SeverityLevel = ApplicationEvent.SeverityLevels.High; error.Timestamp = DateTime.Now; repository.Add(error); throw; } } }
public void DeleteByRouteID(int routeID) { List <Models.ApproachRouteDetail> routes = (from r in db.ApproachRouteDetails where r.ApproachRouteId == routeID select r).ToList(); try { db.ApproachRouteDetails.RemoveRange(routes); 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.ApproachRouteDetailsRepository"; error.Function = "DeleteByRouteID"; error.Description = ex.Message; error.SeverityLevel = ApplicationEvent.SeverityLevels.High; error.Timestamp = DateTime.Now; repository.Add(error); throw; } }
public List <Models.ApproachRouteDetail> GetByRouteID(int routeID) { List <Models.ApproachRouteDetail> routes = (from r in db.ApproachRouteDetails where r.ApproachRouteId == routeID select r).ToList(); if (routes.Count > 0) { return(routes); } 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.ApproachRouteDetailsRepository"; 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 ApproachRouteDetail for this ID")); } } }
public Models.Approach GetApproachByApproachID(int approachID) { var approach = (from r in db.Approaches where r.ApproachID == approachID select r); if (approach != null) { return(approach.FirstOrDefault()); } 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.ApproachRepository"; error.Function = "GetApproachByApproachID"; error.Description = "No approach for ID. Attempted ID# = " + approachID.ToString(); error.SeverityLevel = ApplicationEvent.SeverityLevels.High; error.Timestamp = DateTime.Now; repository.Add(error); throw(new Exception("There is no Approach for this ID")); } } }
public MOE.Common.Business.TMC.TMCInfo CreateTMCChart(MOE.Common.Business.WCFServiceLibrary.TMCOptions options) { try { MOE.Common.Models.Repositories.IMetricTypeRepository metricTypeRepository = MOE.Common.Models.Repositories.MetricTypeRepositoryFactory.Create(); options.MetricType = metricTypeRepository.GetMetricsByID(options.MetricTypeID); options.CreateMetric(); return(options.TmcInfo); } catch (Exception ex) { MOE.Common.Models.Repositories.IApplicationEventRepository logRepository = MOE.Common.Models.Repositories.ApplicationEventRepositoryFactory.Create(); MOE.Common.Models.ApplicationEvent e = new MOE.Common.Models.ApplicationEvent(); e.ApplicationName = "MOEWCFServicLibrary"; e.Class = this.GetType().ToString(); e.Function = "CreateMetric"; e.SeverityLevel = MOE.Common.Models.ApplicationEvent.SeverityLevels.High; e.Description = ex.Message; e.Timestamp = DateTime.Now; logRepository.Add(e); throw; } //return options.MetricInfoList; }
public List <Tuple <string, string> > GetChartAndXmlFileLocations(MOE.Common.Business.WCFServiceLibrary.MetricOptions options) { try { MOE.Common.Models.Repositories.IMetricTypeRepository metricTypeRepository = MOE.Common.Models.Repositories.MetricTypeRepositoryFactory.Create(); options.MetricType = metricTypeRepository.GetMetricsByID(options.MetricTypeID); options.CreateMetric(); return(options.ResultChartAndXmlLocations); } catch (Exception ex) { MOE.Common.Models.Repositories.IApplicationEventRepository logRepository = MOE.Common.Models.Repositories.ApplicationEventRepositoryFactory.Create(); MOE.Common.Models.ApplicationEvent e = new MOE.Common.Models.ApplicationEvent(); e.ApplicationName = "MOEWCFServicLibrary"; e.Class = this.GetType().ToString(); e.Function = "ExportMetricData"; e.SeverityLevel = MOE.Common.Models.ApplicationEvent.SeverityLevels.High; e.Description = ex.Message + ex.InnerException; e.Timestamp = DateTime.Now; logRepository.Add(e); throw; } }
public void AddOrUpdate(MOE.Common.Models.Signal signal) { MOE.Common.Models.Signal g = (from r in db.Signals where r.SignalID == signal.SignalID select r).FirstOrDefault(); if (g == null) { db.Signals.Add(signal); try { 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.SignalRepository"; error.Function = "AddOrUpdate"; error.Description = ex.Message; error.SeverityLevel = ApplicationEvent.SeverityLevels.High; error.Timestamp = DateTime.Now; repository.Add(error); throw; } } else { Update(signal); //throw new Exception("Signal already exists in the database"); } }
public void AddOrUpdate(MOE.Common.Models.MetricComment metricComment) { MOE.Common.Models.MetricComment g = (from r in db.MetricComments where r.CommentID == metricComment.CommentID select r).FirstOrDefault(); if (g != null) { try { db.Entry(g).CurrentValues.SetValues(metricComment); 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.MetricCommentRepository"; error.Function = "AddOrUpdate"; error.Description = ex.Message; error.SeverityLevel = ApplicationEvent.SeverityLevels.High; error.Timestamp = DateTime.Now; repository.Add(error); throw; } } else { db.MetricComments.Add(metricComment); } }
public Detector Add(Models.Detector detector) { Models.Detector g = (from r in db.Detectors where r.ID == detector.ID select r).FirstOrDefault(); if (g == null) { detector.DetectionTypes = new List <DetectionType>(); detector.DetectionTypes = db.DetectionTypes.Where(dt => detector.DetectionTypeIDs.Contains(dt.DetectionTypeID)).ToList();; try { db.Detectors.Add(detector); 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.DetectorRepository"; error.Function = "Add"; error.Description = ex.Message; error.SeverityLevel = ApplicationEvent.SeverityLevels.High; error.Timestamp = DateTime.Now; repository.Add(error); throw; } } return(detector); }
public void Remove(int ID) { Models.Detector g = (from r in db.Detectors where r.ID == ID select r).FirstOrDefault(); if (g != null) { try { db.Detectors.Remove(g); 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.DetectorRepository"; error.Function = "Remove"; error.Description = ex.Message; error.SeverityLevel = ApplicationEvent.SeverityLevels.High; error.Timestamp = DateTime.Now; repository.Add(error); throw; } } }
//public List<MOE.Common.Business.ApproachVolume.MetricInfo> CreateMetricWithDataTable(MOE.Common.Business.WCFServiceLibrary.ApproachVolumeOptions options) //{ // List<string> result = new List<string>(); // try // { // options.CreateMetric(); // return options.TmcInfo; // } // catch (Exception ex) // { // MOE.Common.Models.Repositories.IApplicationEventRepository logRepository = // MOE.Common.Models.Repositories.ApplicationEventRepositoryFactory.Create(); // MOE.Common.Models.ApplicationEvent e = new MOE.Common.Models.ApplicationEvent(); // e.ApplicationName = "MOEWCFServicLibrary"; // e.Class = this.GetType().ToString(); // e.Function = "CreateMetric"; // e.SeverityLevel = MOE.Common.Models.ApplicationEvent.SeverityLevels.High; // e.Description = ex.Message; // e.Timestamp = DateTime.Now; // logRepository.Add(e); // throw; // } // return options.MetricInfoList; //} public List <MOE.Common.Business.ApproachVolume.MetricInfo> CreateMetricWithDataTable(MOE.Common.Business.WCFServiceLibrary.ApproachVolumeOptions options) { List <string> result = new List <string>(); try { MOE.Common.Models.Repositories.IMetricTypeRepository metricTypeRepository = MOE.Common.Models.Repositories.MetricTypeRepositoryFactory.Create(); options.MetricType = metricTypeRepository.GetMetricsByID(options.MetricTypeID); result = options.CreateMetric(); } catch (Exception ex) { MOE.Common.Models.Repositories.IApplicationEventRepository logRepository = MOE.Common.Models.Repositories.ApplicationEventRepositoryFactory.Create(); MOE.Common.Models.ApplicationEvent e = new MOE.Common.Models.ApplicationEvent(); e.ApplicationName = "MOEWCFServicLibrary"; e.Class = this.GetType().ToString(); e.Function = "CreateMetric"; e.SeverityLevel = MOE.Common.Models.ApplicationEvent.SeverityLevels.High; e.Description = ex.Message; e.Timestamp = DateTime.Now; logRepository.Add(e); throw; } return(options.MetricInfoList); }
public void AddOrUpdate(MOE.Common.Models.Approach approach) { MOE.Common.Models.Approach g = (from r in db.Approaches where r.ApproachID == approach.ApproachID select r).FirstOrDefault(); if (g != null) { try { db.Entry(g).CurrentValues.SetValues(approach); 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.ApproachRepository"; error.Function = "Update"; error.Description = ex.Message; error.SeverityLevel = ApplicationEvent.SeverityLevels.High; error.Timestamp = DateTime.Now; repository.Add(error); throw; } } else { try { foreach (Detector d in approach.Detectors) { if (d.DetectionTypes == null && d.DetectionTypeIDs != null) { d.DetectionTypes = db.DetectionTypes.Where(dt => d.DetectionTypeIDs.Contains(dt.DetectionTypeID)).ToList(); } } db.Approaches.Add(approach); 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.ApproachRepository"; error.Function = "Add"; error.Description = ex.Message; error.SeverityLevel = ApplicationEvent.SeverityLevels.High; error.Timestamp = DateTime.Now; repository.Add(error); throw; } } }
public void Add(Models.ApproachRouteDetail newRouteDetail) { try { db.ApproachRouteDetails.Add(newRouteDetail); 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.ApproachRouteDetailsRepository"; error.Function = "UpdateByRouteAndApproachID"; error.Description = ex.Message; error.SeverityLevel = ApplicationEvent.SeverityLevels.High; error.Timestamp = DateTime.Now; repository.Add(error); throw; } }
public void Update(Models.Detector detector) { Models.Detector g = (from r in db.Detectors where r.ID == detector.ID select r).FirstOrDefault(); if (g != null) { foreach (int i in detector.DetectionTypeIDs) { Models.DetectionType t = (from r in db.DetectionTypes where r.DetectionTypeID == i select r).FirstOrDefault(); detector.DetectionTypes.Add(t); } try { db.Entry(g).CurrentValues.SetValues(detector); 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.DetectorRepository"; error.Function = "Update"; error.Description = ex.Message; error.SeverityLevel = ApplicationEvent.SeverityLevels.High; error.Timestamp = DateTime.Now; repository.Add(error); throw; } } }