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 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 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();
}
}
}
}
public static void EditPassengerData(Pass_in_trip pass_in_trip, string newPlace, string oldName, string newName)
{
EditPassengerDataInDB(newPlace, oldName, newName, pass_in_trip);
}
public static void DeletePassengerFromFlight(Pass_in_trip pass_In_Trip)
{
DeletePassengerFromPass_In_Flight(pass_In_Trip);
}
public static void AddNewPassInFlight(Pass_in_trip pass_In_Trip)
{
AddNewPassInTripToDB(pass_In_Trip);
}
