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();
}