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