public void AddOrUpdate(DetectorComment detectorComment) { var g = (from r in db.DetectorComments where r.CommentID == detectorComment.CommentID select r).FirstOrDefault(); if (g != null) { db.Entry(g).CurrentValues.SetValues(detectorComment); } else { db.DetectorComments.Add(detectorComment); } try { db.SaveChanges(); } catch (DbEntityValidationException e) { foreach (var eve in e.EntityValidationErrors) { Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:", eve.Entry.Entity.GetType().Name, eve.Entry.State); foreach (var ve in eve.ValidationErrors) { Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage); } } throw; } }
public void DeleteByID(int id) { var routePhaseDirection = db.RoutePhaseDirections.Where(r => r.Id == id).FirstOrDefault(); db.RoutePhaseDirections.Remove(routePhaseDirection); db.SaveChanges(); }
public Detector Add(Detector detector) { var 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) { var repository = ApplicationEventRepositoryFactory.Create(); var 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 AddOrUpdate(MetricComment metricComment) { var 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) { var repository = ApplicationEventRepositoryFactory.Create(); var 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); db.SaveChanges(); } }
public void DeleteByID(int routeID) { var route = (from r in db.Routes where r.Id == routeID select r).FirstOrDefault(); db.Routes.Remove(route); db.SaveChanges(); }
public ActionResult Create([Bind(Include = "Id,Email,EmailConfirmed,PasswordHash,SecurityStamp,PhoneNumber,PhoneNumberConfirmed,TwoFactorEnabled,LockoutEndDateUtc,LockoutEnabled,AccessFailedCount,UserName")] SPMUser sPMUser) { if (ModelState.IsValid) { db.Users.Add(sPMUser); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(sPMUser)); }
public ActionResult Create([Bind(Include = "Id,Name")] SPMRole sPMRole) { if (ModelState.IsValid) { db.IdentityRoles.Add(sPMRole); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(sPMRole)); }
public void AddToExcludedList(string signalId) { var excludedSignals = _db.DatabaseArchiveExcludedSignals .ToList(); if (GetExcludedSignalBySignalId(signalId) == null) { var newSignal = new DatabaseArchiveExcludedSignal(); newSignal.SignalId = signalId; _db.DatabaseArchiveExcludedSignals.Add(newSignal); _db.SaveChanges(); } }
public void Add(ActionLog entity) { if (entity.Actions == null) { entity.Actions = db.Actions .Where(a => entity.ActionIDs.Contains(a.ActionID)).ToList(); } if (entity.MetricTypes == null) { entity.MetricTypes = db.MetricTypes .Where(a => entity.MetricTypeIDs.Contains(a.MetricID)).ToList(); } db.ActionLogs.Add(entity); db.SaveChanges(); }
private static void UpdateSignalRecordsWithStartDateAndVersion() { SPM db = new SPM(); //db.Database.ExecuteSqlCommand("ALTER TABLE [dbo].[Signals] DROP CONSTRAINT [FK_dbo.Signals_dbo.VersionActions_VersionAction_ID] FOREIGN KEY ([VersionActionId]) REFERENCES [dbo].[VersionActions] ([ID])"); var signals = (from r in db.Signals select r).ToList(); var version = (from r in db.VersionActions where r.ID == 10 select r).FirstOrDefault(); foreach (var s in signals) { s.Start = s.FirstDate; s.VersionAction = version; } db.SaveChanges(); db.Database.ExecuteSqlCommand("ALTER TABLE [dbo].[Signals] ADD CONSTRAINT [FK_dbo.Signals_dbo.VersionActions_VersionAction_ID] FOREIGN KEY ([VersionActionId]) REFERENCES [dbo].[VersionActions] ([ID])"); db.Dispose(); }
public void Update(DetectionHardware DetectionHardware) { var g = (from r in db.DetectionHardwares where r.ID == DetectionHardware.ID select r).FirstOrDefault(); if (g != null) { db.Entry(g).CurrentValues.SetValues(DetectionHardware); db.SaveChanges(); } else { db.DetectionHardwares.Add(DetectionHardware); db.SaveChanges(); } }
public void Update(LaneType laneType) { var g = (from r in db.LaneTypes where r.LaneTypeID == laneType.LaneTypeID select r).FirstOrDefault(); if (g != null) { db.Entry(g).CurrentValues.SetValues(laneType); db.SaveChanges(); } else { db.LaneTypes.Add(laneType); db.SaveChanges(); } }
public void Update(ApplicationEvent applicationEvent) { var g = (from r in db.ApplicationEvents where r.ID == applicationEvent.ID select r).FirstOrDefault(); if (g != null) { db.Entry(g).CurrentValues.SetValues(applicationEvent); db.SaveChanges(); } else { db.ApplicationEvents.Add(applicationEvent); db.SaveChanges(); } }
public void Update(MovementType movementType) { var g = (from r in db.MovementTypes where r.MovementTypeID == movementType.MovementTypeID select r).FirstOrDefault(); if (g != null) { db.Entry(g).CurrentValues.SetValues(movementType); db.SaveChanges(); } else { db.MovementTypes.Add(movementType); db.SaveChanges(); } }
public void SetVersionToDeleted(int versionId) { var signal = (from r in _db.Signals where r.VersionID == versionId select r).FirstOrDefault(); if (signal != null) { signal.VersionActionId = 3; } _db.SaveChanges(); }
private static void UpdateSignalRecordsWithStartDateAndVersion() { SPM db = new SPM(); //db.Database.ExecuteSqlCommand("ALTER TABLE [dbo].[Signals] DROP CONSTRAINT [FK_dbo.Signals_dbo.VersionActions_VersionAction_ID] FOREIGN KEY ([VersionActionId]) REFERENCES [dbo].[VersionActions] ([ID])"); var signals = (from r in db.Signals select r).ToList(); var version = (from r in db.VersionActions where r.ID == 10 select r).FirstOrDefault(); var allMetricTypes = db.MetricTypes.ToList(); foreach (var s in signals) { s.Start = s.FirstDate; s.VersionAction = version; if (s.Comments == null) { s.Comments = new List <MetricComment>(); } if (_oldMetricCommentsList.Any(m => m.SignalId == s.SignalID)) { var listComments = _oldMetricCommentsList.Where(m => m.SignalId == s.SignalID).ToList(); foreach (var comment in listComments) { var metricTypeRelationships = _oldMetricCommentMetricTypesList .Where(t => t.MetricComment_CommentId == comment.CommentId).ToList(); List <MetricType> metricsToAddToComment = new List <MetricType>(); foreach (var metricType in allMetricTypes) { if (metricTypeRelationships.Select(r => r.MetricType_MetricID) .Contains(metricType.MetricID)) { metricsToAddToComment.Add(metricType); } } s.Comments.Add( new MetricComment { CommentText = comment.ComentText, SignalID = comment.SignalId, TimeStamp = comment.TimeStamp, VersionID = s.VersionID, MetricTypes = metricsToAddToComment }); } } } db.SaveChanges(); db.Database.ExecuteSqlCommand( "ALTER TABLE [dbo].[Signals] ADD CONSTRAINT [FK_dbo.Signals_dbo.VersionActions_VersionAction_ID] FOREIGN KEY ([VersionActionId]) REFERENCES [dbo].[VersionActions] ([ID])"); db.Dispose(); }
private static void CreateRoutes() { SPM db = new SPM(); foreach (var oldRoute in OldRouteList) { Route route = new Route(); route.RouteName = oldRoute.RouteName; route.RouteSignals = CreateRouteSignals(oldRoute, route, db); db.Routes.Add(route); } db.SaveChanges(); }
private static void UpdateApproachesWithVersionId() { SPM db = new SPM(); //db.Database.ExecuteSqlCommand( // "ALTER TABLE [dbo].[Approaches] DROP CONSTRAINT [FK_dbo.Approaches_dbo.Signals_VersionID] FOREIGN KEY ([VersionID]) REFERENCES [dbo].[Signals] ([VersionID]) "); var approaches = (from r in db.Approaches select r).ToList(); foreach (var a in approaches) { a.Signal = (from r in db.Signals where r.SignalID == a.SignalID select r).FirstOrDefault(); } db.SaveChanges(); db.Database.ExecuteSqlCommand( "ALTER TABLE [dbo].[Approaches] ADD CONSTRAINT [FK_dbo.Approaches_dbo.Signals_VersionID] FOREIGN KEY ([VersionID]) REFERENCES [dbo].[Signals] ([VersionID]) "); db.Dispose(); }
public void MoveRouteSignalUp(int routeId, int routeSignalId) { var route = db.Routes.Find(routeId); var signal = route.RouteSignals.FirstOrDefault(r => r.Id == routeSignalId); var order = signal.Order; var swapSignal = route.RouteSignals.FirstOrDefault(r => r.Order == order - 1); if (swapSignal != null) { signal.Order--; swapSignal.Order++; db.SaveChanges(); } }
private static void UpdateMetriCommentsWithVersionId() { SPM db = new SPM(); //db.Database.ExecuteSqlCommand( // "ALTER TABLE [dbo].[MetricComments] DROP CONSTRAINT [FK_dbo.MetricComments_dbo.Signals_VersionID] FOREIGN KEY ([VersionID]) REFERENCES [dbo].[Signals] ([VersionID])"); var comments = (from r in db.MetricComments select r).ToList(); foreach (var c in comments) { var oldSig = c.SignalID; c.VersionID = (from r in db.Signals where r.SignalID == oldSig select r.VersionID).FirstOrDefault(); } db.SaveChanges(); db.Database.ExecuteSqlCommand( "ALTER TABLE [dbo].[MetricComments] ADD CONSTRAINT [FK_dbo.MetricComments_dbo.Signals_VersionID] FOREIGN KEY ([VersionID]) REFERENCES [dbo].[Signals] ([VersionID])"); db.Dispose(); }
public void Update(SPMWatchDogErrorEvent SPMWatchDogErrorEvent) { var g = (from r in db.SPMWatchDogErrorEvents where r.ID == SPMWatchDogErrorEvent.ID select r).FirstOrDefault(); if (g != null) { db.Entry(g).CurrentValues.SetValues(SPMWatchDogErrorEvent); db.SaveChanges(); } else { db.SPMWatchDogErrorEvents.Add(SPMWatchDogErrorEvent); db.SaveChanges(); } }
private static void UpdateActionLogs() { SPM db = new SPM(); var allMetricTypes = db.MetricTypes.ToList(); foreach (var oldActionLog in _oldActionLogsList) { var currentActionLog = db.ActionLogs.Find(oldActionLog.ActionLogID); var metricTypeRelationships = _oldActionLogMetricTypesList.Where(a => a.ActionLog_ActionLogID == currentActionLog.ActionLogID).Select(a => a.MetricType_MetricID).ToList(); List <MetricType> metricsToAddToActionLog = new List <MetricType>(); foreach (var metricType in allMetricTypes) { if (metricTypeRelationships.Contains(metricType.MetricID)) { metricsToAddToActionLog.Add(metricType); } } if (currentActionLog != null) { currentActionLog.MetricTypes = metricsToAddToActionLog; } } db.SaveChanges(); }
PreemptionAggregation IPreemptAggregationDatasRepository.Add(PreemptionAggregation preemptionAggregation) { db.PreemptionAggregations.Add(preemptionAggregation); db.SaveChanges(); return(preemptionAggregation); }
public void AddOrUpdate(Approach approach) { var g = (from r in _db.Approaches where r.ApproachID == approach.ApproachID select r).FirstOrDefault(); if (approach.Detectors != null) { foreach (var det in approach.Detectors) { AddDetectiontypestoDetector(det); } } if (g != null) { try { _db.Entry(g).CurrentValues.SetValues(approach); _db.SaveChanges(); } catch (Exception ex) { var repository = ApplicationEventRepositoryFactory.Create(); var error = new ApplicationEvent { ApplicationName = "MOE.Common", Class = "Models.Repository.ApproachRepository", Function = "Update", Description = ex.Message, SeverityLevel = ApplicationEvent.SeverityLevels.High, Timestamp = DateTime.Now }; repository.Add(error); throw; } } else { try { foreach (var 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) { var repository = ApplicationEventRepositoryFactory.Create(); var error = new ApplicationEvent { ApplicationName = "MOE.Common", Class = "Models.Repository.ApproachRepository", Function = "Add", Description = ex.Message, SeverityLevel = ApplicationEvent.SeverityLevels.High, Timestamp = DateTime.Now }; repository.Add(error); throw; } } }
public void Add(FAQ item) { db.FAQs.Add(item); db.SaveChanges(); }
public void Save(DatabaseArchiveSettings databaseArchiveSettings) { db.Entry(databaseArchiveSettings).State = EntityState.Modified; db.SaveChanges(); }
public void Add(Menu menuItem) { db.Menus.Add(menuItem); db.SaveChanges(); }
public void Save() { db.SaveChanges(); }