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