private static void EditTripInDB(Trip trip)
{
using (var db = new AirlinesEntities())
{
using (var transaction = db.Database.BeginTransaction())
{
try
{
foreach (var t in db.Trip)
{
if (t.trip_no.Equals(trip.trip_no))
{
t.ID_comp = trip.ID_comp;
t.plane = trip.plane;
t.time_in = trip.time_in;
t.time_out = trip.time_out;
t.town_from = trip.town_from;
t.town_to = trip.town_to;
break;
}
}
db.SaveChanges();
transaction.Commit();
}
catch (Exception ex) { transaction.Rollback(); }
}
}
}
private static void AddNewCompanyToDB(Company company)
{
using (var db = new AirlinesEntities())
{
using (var transaction = db.Database.BeginTransaction())
{
try
{
db.Company.Add(company);
db.SaveChanges();
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
}
}
}
}
private static void AddNewPassInTripToDB(Pass_in_trip pass_In_Trip)
{
using (var db = new AirlinesEntities())
{
using (var transaction = db.Database.BeginTransaction())
{
try
{
db.Pass_in_trip.Add(pass_In_Trip);
db.SaveChanges();
transaction.Commit();
}
catch
{
transaction.Rollback();
}
}
}
}
private static void DeleteTripFromDB(Trip trip)
{
using (var db = new AirlinesEntities())
{
using (var transaction = db.Database.BeginTransaction())
{
try
{
db.Trip.Remove(trip);
db.SaveChanges();
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
}
}
}
}
private static void AddPassengerToDB(Passenger pass)
{
using (var db = new AirlinesEntities())
{
using (var transaction = db.Database.BeginTransaction())
{
try
{
db.Passenger.Add(pass);
db.SaveChanges();
transaction.Commit();
}
catch
{
transaction.Rollback();
}
}
}
}
private static void AddNewTripToDB(Trip trip)
{
using (var db = new AirlinesEntities())
{
using (var transaction = db.Database.BeginTransaction())
{
try
{
db.Trip.Add(trip);
db.SaveChanges();
transaction.Commit();
}
catch (Exception Ex)
{
transaction.Rollback();
}
}
}
}
private static void DeletePassengerFromPass_In_Flight(Pass_in_trip pass)
{
using (var db = new AirlinesEntities())
{
Pass_in_trip pt = db.Pass_in_trip.Where(p => p.trip_no.Equals(pass.trip_no) && p.date.Equals(pass.date) && p.ID_psg.Equals(pass.ID_psg)).FirstOrDefault();
using (var transaction = db.Database.BeginTransaction())
{
try
{
db.Pass_in_trip.Remove(pt);
db.SaveChanges();
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
}
}
}
}
private static void AddNewPassInTripToDB(int _TripN, DateTime _tripDate, int _passID, string _passSeat)
{
using (var db = new AirlinesEntities())
{
using (var transaction = db.Database.BeginTransaction())
{
try
{
db.Pass_in_trip.Add(new Pass_in_trip {
trip_no = _TripN, date = _tripDate, ID_psg = _passID, place = _passSeat
});
db.SaveChanges();
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
}
}
}
}
private static void EditPassengerDataInDB(string newPassPlace, string oldPassName, string newPassName, Pass_in_trip trip)
{
using (var db = new AirlinesEntities())
{
using (var transaction = db.Database.BeginTransaction())
{
try
{
Passenger passTochange = db.Passenger.Where(pass => pass.name == oldPassName).First();
passTochange.name = newPassName;
Pass_in_trip pass_in_tripToChange = db.Pass_in_trip.Where(pit => pit.trip_no.Equals(trip.trip_no) && pit.date.Equals(trip.date) && pit.ID_psg.Equals(trip.ID_psg)).First();
pass_in_tripToChange.place = newPassPlace;
db.SaveChanges();
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
}
}
}
}
