public void Update(RoutesOfTown updateTown)
{
using (BusRoutesContext context = new BusRoutesContext())
{
var townFromBase = context.Towns
.Include(tn => tn.Routes.Select(rt => rt.Stations))
.FirstOrDefault(tn => tn.Id == updateTown.Id);
updateTown.Save(townFromBase);
}
}
public void Update(RoutesOfTown updateTown)
{
try
{
context.Entry(updateTown).Reload();
context.Entry(updateTown)
.Collection(rt => rt.Routes)
.Load();
}
catch (Exception ex)
{
log.Error(ex);
}
}
public void Save(RoutesOfTown saveTown)
{
try
{
if (saveTown.Id == 0)
{
context.Towns.Add(saveTown);
}
context.SaveChanges();
}
catch (Exception ex)
{
log.Error(ex);
}
}
public void Save(RoutesOfTown saveTown)
{
using (BusRoutesContext context = new BusRoutesContext())
{
if (saveTown.Id == 0)
{
context.Towns.Add(saveTown);
}
else
{
//load town with routes
var baseTown = context.Towns.Include(tn => tn.Routes)
.SingleOrDefault(tn => tn.Id == saveTown.Id);
var idsBaseRoutesNotIntoBaseTown = saveTown.Routes.Except(baseTown.Routes)
.Where(rt => rt.Id != 0).Select(rt => rt.Id).ToList();
var baseSavedRoutesNotIntoTown = context.Routes
.Where(rt => idsBaseRoutesNotIntoBaseTown.Contains(rt.Id)).ToList();
//attaching routes saved in database into town
foreach (var baseRoute in baseSavedRoutesNotIntoTown)
{
baseTown.Routes.Add(baseRoute);
}
//deleting old routes
//can erase new records from other users!!!!!
foreach (var route in baseTown.Routes.Except(saveTown.Routes).ToList())
{
baseTown.Routes.Remove(route);
}
}
context.SaveChanges();
}
}
public static void GenerateTestDataAndSave()
{
List <Station> stationsRoute11 = new List <Station>();
Route route11 = new Route(3452, 11, stationsRoute11.FirstOrDefault(), stationsRoute11.LastOrDefault(), stationsRoute11);
var beginStation = new Station(235235, 1, "Ivanovo", GetTodayDateTime(9, 45), null, "Ivanovo station. 5 min.", route11);
stationsRoute11.Add(beginStation);
stationsRoute11.Add(new Station(945853, 2, "Airport", GetTodayDateTime(9, 50), null, "Airport station. 15 min.", route11));
stationsRoute11.Add(new Station(124590, 3, "Lake", GetTodayDateTime(10, 10), null, "Lake station. 5 min. Temporarily closed.", route11));
var endStation = new Station(744935, 4, "Central station.", GetTodayDateTime(10, 30), null, "Central station. 7 min.", route11);
stationsRoute11.Add(endStation);
route11.Stations = stationsRoute11;
route11.BeginStation = beginStation;
route11.EndStation = endStation;
//List<Station> stationsRoute40 = new List<Station>();
//stationsRoute40.Add(new Station(495637, 1, "Square", GetTodayDateTime(9, 35), null, "Square station. 7 min."));
//stationsRoute40.Add(new Station(434588, 2, "BigShop", GetTodayDateTime(10, 50), null, "BigShop station. 5 min."));
//stationsRoute40.Add(new Station(324589, 3, "Stadium", GetTodayDateTime(11, 10), null, "Stadium station. 5 min."));
//stationsRoute40.Add(new Station(393428, 4, "River", GetTodayDateTime(12, 30), null, "River station. 11 min."));
//Route route40 = new Route(9983, 40, stationsRoute40.FirstOrDefault(), stationsRoute40.LastOrDefault(), stationsRoute40);
//List<Station> stationsRoute52 = new List<Station>();
//stationsRoute52.Add(new Station(866442, 1, "Forest", GetTodayDateTime(11, 35), GetTodayDateTime(11, 38), "Forest station. 12 min."));
//stationsRoute52.Add(new Station(124914, 2, "Farm", GetTodayDateTime(12, 38), GetTodayDateTime(12, 36), "Farm station. 4 min."));
//stationsRoute52.Add(new Station(146593, 3, "Circus", GetTodayDateTime(16, 10), null, "Circus station. 7 min."));
//stationsRoute52.Add(new Station(103801, 4, "Institute", GetTodayDateTime(18, 30), null, "Institute station. 10 min."));
//Route route52 = new Route(8875, 52, stationsRoute52.FirstOrDefault(), stationsRoute52.LastOrDefault(), stationsRoute52);
List <Route> routes = new List <Route>();
routes.Add(route11);
//routes.Add(route40);
//routes.Add(route52);
RoutesOfTown routesOfTown = new RoutesOfTown("Chester city routes", routes);
routesOfTown.Id = 33234;
using (BusRoutesContext context = new BusRoutesContext())
{
context.Towns.Add(routesOfTown);
context.SaveChanges();
}
}
public RoutesOfTownProcess(RoutesOfTown townRoutes)
{
_townRoutes = townRoutes;
}
public void AddToRoute(RoutesOfTown routesOfTown)
{
routesOfTown.Routes.Add(_route);
}