public static void DeleteCity(City city)
{
using (var dbContext = new TrainContext())
{
dbContext.Cities.Attach(city);
dbContext.Cities.Remove(city);
dbContext.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 AddCity(City city)
{
using (var context = new TrainContext())
{
var citi = context.Set<City>();
citi.Add(city);
context.SaveChanges();
}
}
public static void DeleteTrain(Train train)
{
using (var db = new TrainContext())
{
db.Trains.Attach(train);
db.Trains.Remove(train);
db.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 EditTrain(Train train)
{
using (var db = new TrainContext())
{
var result = db.Trains.SingleOrDefault(t => t.ID == train.ID);
if (result != null)
{
result.Info = train.Info;
result.NumberOfSeats = train.NumberOfSeats;
result.Seats = train.Seats;
db.SaveChanges();
}
}
}
public static void EditSchedule(Schedule sch)
{
using (var db = new TrainContext())
{
var result = db.Schedules.SingleOrDefault(s => s.ID == sch.ID);
if (result != null)
{
result.StartingCity = sch.StartingCity;
result.FinalCity = sch.FinalCity;
result.TicketPrice = sch.TicketPrice;
result.Train = sch.Train;
result.TripDuration = sch.TripDuration;
result.DateAndTime = sch.DateAndTime;
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();
}
}
private static void UpdateMoneyInUserCreditcard(int userID, int ticketID)
{
using (var db = new TrainContext())
{
double ticketPrice = GetTicketPrice(ticketID);
double discount = Discout(userID);
int userCreditcardID = 0;
var credicardID = (from u in db.Users
where u.ID == userID
select u.CreditCardID);
foreach (var item in credicardID)
{
userCreditcardID = item;
}
var update = db.CreditCards.SingleOrDefault(c => c.ID == userCreditcardID);
if (update != null)
{
update.Amount -= (ticketPrice - (ticketPrice * discount));
db.SaveChanges();
}
}
}
private static void UpdateTicketAvailbality(int ticketID)
{
using (var db = new TrainContext())
{
var availble = db.Tickets.SingleOrDefault(t => t.ID == ticketID);
if (availble != null)
{
availble.Available = false;
db.SaveChanges();
}
}
}
