public static string GetStationNameById(int id) { TrainCommanderEntities db = new TrainCommanderEntities(); return((from o in db.Station where o.Id == id select o.name).First()); }
public static Train AddTrain() { TrainCommanderEntities db = new TrainCommanderEntities(); Train train = new Train { is_double = false, seat_number = 350, remaining_seat = 350 }; db.Train.Add(train); return(train); }
private static void AddSuperTrip(SuperTrip superTrip) { TrainCommanderEntities db = new TrainCommanderEntities(); if (!db.SuperTrip.Any(o => o.id_departure_station == superTrip.id_departure_station && o.id_arrival_station == superTrip.id_arrival_station && o.departure_date == superTrip.departure_date)) { db.SuperTrip.Add(superTrip); } db.SaveChanges(); }
public static string GetStationSNCFId(string name) { TrainCommanderEntities db = new TrainCommanderEntities(); string idSncf; var search = (from o in db.Station where o.name.ToLower() == name.ToLower() select o).FirstOrDefault(); if (search.id_sncf == null) { idSncf = GetIDFromPlace(name); search.id_sncf = idSncf; db.SaveChanges(); } return(search.id_sncf); }
public static int GetStationIdByName(string name) { TrainCommanderEntities db = new TrainCommanderEntities(); int returnVar = 0; try { returnVar = (from o in db.Station where o.name == name select o.Id).First(); } catch (EntityCommandCompilationException ex) { System.Diagnostics.Debug.WriteLine(ex.Message); return(returnVar); } return(returnVar); }
public static Station GetStationBySNCFName(string name) { TrainCommanderEntities db = new TrainCommanderEntities(); Station station = new Station(); var query = (from o in db.Station where o.name == name select o).FirstOrDefault(); if (query == null) { station.name = name; db.Station.Add(station); db.SaveChanges(); } else { station = query; } return(station); }
public static List <Trip> ConvertToListTrip(List <SNCFTrip> sncfTrips) { TrainCommanderEntities db = new TrainCommanderEntities(); List <Trip> trips = new List <Trip>(); foreach (SNCFTrip sncfTrip in sncfTrips) { Station departure = GetStationBySNCFName(sncfTrip.departure); Station arrival = GetStationBySNCFName(sncfTrip.arrival); Trip trip = new Trip { id_departure_station = departure.Id, id_arrival_station = arrival.Id, departure_date = DateTime.ParseExact(sncfTrip.departure_date_time, "yyyyMMddTHHmmss", CultureInfo.InvariantCulture), arrival_date = DateTime.ParseExact(sncfTrip.arrival_date_time, "yyyyMMddTHHmmss", CultureInfo.InvariantCulture), price = sncfTrip.price }; trips.Add(trip); } return(trips); }
private static void AddTrips(List <Trip> trips) { TrainCommanderEntities db = new TrainCommanderEntities(); DateTime departure_date = trips.First().departure_date; DateTime arrival_date = trips.Last().arrival_date; foreach (Trip trip in trips) { if (!db.Trip.Any(o => o.id_departure_station == trip.id_departure_station && o.id_arrival_station == trip.id_arrival_station && o.departure_date == trip.departure_date)) { SuperTrip supertrip = (from o in db.SuperTrip where o.departure_date == departure_date && o.arrival_date == arrival_date select o).FirstOrDefault(); trip.SuperTrip.Add(supertrip); trip.Train = AddTrain(); db.Trip.Add(trip); db.SaveChanges(); } } }