public static List<Type> GetEditableTypes()
{
using (var context = new viadflib.DataContext())
{
return context.Types.Where(x => x.ShowInWeb && !x.IsWalkingType).OrderBy(x => x.ID).ToList();
}
}
public static List<Route> GetAllRoutes(StatusEnum status)
{
using (var context = new viadflib.DataContext())
{
return context.Routes.Where(x => x.Status == (int)status).OrderBy(x => x.ID).ToList();
}
}
public static List<Route> GetAllRoutesWithPieces(Type type)
{
using (var context = new viadflib.DataContext())
{
var dlo = new System.Data.Linq.DataLoadOptions();
dlo.LoadWith<Route>(x => x.RoutePieces);
context.LoadOptions = dlo;
return context.Routes.Where(x => x.Status > (int)StatusEnum.New && x.TypeID == type.ID).OrderBy(x => x.ID).ToList();
}
}
public static List<Route> GetAllRoutesForIds(List<int> routeIds)
{
if (routeIds.Count == 0)
{
return new List<Route>();
}
using (var context = new viadflib.DataContext())
{
var dlo = new System.Data.Linq.DataLoadOptions();
dlo.LoadWith<Route>(x => x.Type);
context.LoadOptions = dlo;
return context.Routes.Where(x => routeIds.Contains(x.ID)).ToList();
}
}
