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); }