public static void AddCity(City city) { using (var context = new TrainContext()) { var citi = context.Set<City>(); citi.Add(city); context.SaveChanges(); } }
public static void AddTrain(Train train) { using (var db = new TrainContext()) { var tr = db.Set<Train>(); tr.Add(train); db.SaveChanges(); } }
public static void AddUser(User user) { using (var db = new TrainContext()) { var us = db.Set<User>(); us.Add(user); db.SaveChanges(); } }
public static void AddSchedule(Schedule sch) { List<Schedule> otherSchedules = ListSchedule(); using (var db = new TrainContext()) { foreach (var item in otherSchedules.Where(s => s.Train == sch.Train)) { if (item.Train == sch.Train) { if (!IntersectDates(sch.DateAndTime, item.DateAndTime, sch.TripDuration, item.TripDuration)) { throw new Exception("Train is unvailable for this trip"); } } } var addshedule = db.Set<Schedule>(); addshedule.Add(sch); db.SaveChanges(); } }