//Reservation Insert(Reservation reservation) public Reservation Insert(Reservation reservation) { using (var context = new AutoReservationEntities()) { return context.Reservationen.Attach(reservation); } }
public void AddResevation(Reservation reservation) { using (AutoReservationEntities context = new AutoReservationEntities()) { context.AddToReservationen(reservation); context.SaveChanges(); } }
public void CreateReservation(Reservation created) { using (var ctx = new AutoReservationEntities()) { ctx.AddToReservationen(created); ctx.SaveChanges(); } }
public void DeleteReservation(Reservation reservation) { using (AutoReservationEntities context = new AutoReservationEntities()) { context.Reservationen.Attach(reservation); context.Reservationen.DeleteObject(reservation); context.SaveChanges(); } }
//Reservation Delete(Reservation reservation) public Reservation Delete(Reservation reservation) { using (var context = new AutoReservationEntities()) { context.Reservationen.Attach(reservation); context.Reservationen.Remove(reservation); return reservation; } }
public void DeleteReservation(Reservation res) { using (var ctx = new AutoReservationEntities()) { ctx.Reservationen.Attach(res); ctx.Reservationen.DeleteObject(res); ctx.SaveChanges(); } }
public static List<Reservation> InitializeReservationTestData() { List<Reservation> reservationListTestData = new List<Reservation>(); Reservation test1 = new Reservation(); test1.Von = new DateTime(2020, 1, 10); test1.Bis = new DateTime(2020, 1, 20); reservationListTestData.Add(test1); return reservationListTestData; }
public void DeleteReservation(Reservation reservationDelete) { using (AutoReservationEntities context = new AutoReservationEntities()) { try { context.Reservationen.Attach(reservationDelete); context.DeleteObject(reservationDelete); context.SaveChanges(); } catch (OptimisticConcurrencyException ex) { throw new LocalOptimisticConcurrencyException<Reservation>(ex.Message); } } }
//Reservation Update(Reservation modified, Reservation original) public Reservation Update(Reservation modified, Reservation original) { using (var context = new AutoReservationEntities()) { try { context.Reservationen.Attach(original); context.Entry(original).CurrentValues.SetValues(modified); return modified; } catch (DbUpdateConcurrencyException e) { HandleDbConcurrencyException<Reservation>(context, original); return null; } } }
public void EditReservation(Reservation reservationOriginal, Reservation reservationModified) { using (AutoReservationEntities context = new AutoReservationEntities()) { try { context.Reservationen.Attach(reservationOriginal); context.Reservationen.ApplyCurrentValues(reservationModified); context.SaveChanges(); } catch (OptimisticConcurrencyException ex) { Console.WriteLine("AutoReservationBusinessComponent ConcurrencyException"); //context.AcceptAllChanges(); context.Refresh(System.Data.Objects.RefreshMode.StoreWins, reservationModified); throw new LocalOptimisticConcurrencyException<Reservation>(ex.Message); } } }
public void UpdateReservation(Reservation modifiedReservation, Reservation originalReservation) { try { using (AutoReservationEntities context = new AutoReservationEntities()) { context.Reservationen.Attach(originalReservation); context.Reservationen.ApplyCurrentValues(modifiedReservation); context.SaveChanges(); } } catch (OptimisticConcurrencyException) { throw new LocalOptimisticConcurrencyException<Reservation>("Reservation wurde bereits verändert."); } }
public void UpdateReservation(Reservation modified, Reservation original) { using (AutoReservationEntities context = new AutoReservationEntities()) { try { context.Reservationen.Attach(original); modified.EntityKey = original.EntityKey; context.Reservationen.ApplyCurrentValues(modified); context.SaveChanges(); } catch (OptimisticConcurrencyException e) { context.Refresh(System.Data.Objects.RefreshMode.StoreWins, modified); throw new LocalOptimisticConcurrencyException<Reservation>("update conflict") { Entity = modified }; } } }
/// <summary> /// Create a new Reservation object. /// </summary> /// <param name="reservationNr">Initial value of the ReservationNr property.</param> /// <param name="autoId">Initial value of the AutoId property.</param> /// <param name="kundeId">Initial value of the KundeId property.</param> /// <param name="von">Initial value of the Von property.</param> /// <param name="bis">Initial value of the Bis property.</param> public static Reservation CreateReservation(global::System.Int32 reservationNr, global::System.Int32 autoId, global::System.Int32 kundeId, global::System.DateTime von, global::System.DateTime bis) { Reservation reservation = new Reservation(); reservation.ReservationNr = reservationNr; reservation.AutoId = autoId; reservation.KundeId = kundeId; reservation.Von = von; reservation.Bis = bis; return reservation; }
public void Test_UpdateReservation() { Auto meinAuto = Target.GetAutoById(2); Kunde meinKunde = Target.GetKundeById(1); Reservation meinReservation = new Reservation { Auto = meinAuto, AutoId = 2, Kunde = meinKunde, KundeId = 1, ReservationNr = 1, Von = new System.DateTime(1960, 2, 2), Bis = new System.DateTime(1960, 2, 5) }; Reservation meinOriginalReservation = Target.GetReservationByNr(1); Target.UpdateReservation(meinReservation, meinOriginalReservation); Reservation meinInsertedReservation = Target.GetReservationByNr(1); Assert.AreEqual(meinReservation.Auto.Marke, meinInsertedReservation.Auto.Marke); Assert.AreEqual(meinReservation.Auto.Tagestarif, meinInsertedReservation.Auto.Tagestarif); Assert.AreEqual(meinReservation.AutoId, meinInsertedReservation.AutoId); Assert.AreEqual(meinReservation.Von, meinInsertedReservation.Von); Assert.AreEqual(meinReservation.Bis, meinInsertedReservation.Bis); }
public void UpdateReservation(Reservation modified, Reservation original) { using (var ctx = new AutoReservationEntities()) { try { ctx.Reservationen.Attach(original); ctx.Reservationen.ApplyCurrentValues(modified); ctx.SaveChanges(); } catch (LocalOptimisticConcurrencyException<Kunde>) { ctx.Refresh(RefreshMode.StoreWins, original); ctx.SaveChanges(); } } }
/// <summary> /// Deprecated Method for adding a new object to the Reservationen EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead. /// </summary> public void AddToReservationen(Reservation reservation) { base.AddObject("Reservationen", reservation); }
public void Test_InsertReservation() { List<Auto> autos = Target.LoadAutos(); List<Kunde> kunden = Target.LoadKunden(); if (autos.Count > 0 && kunden.Count > 0) { Reservation res = new Reservation(); res.KundeId = kunden[0].Id; res.AutoId = autos[0].Id; res.Von = new DateTime(2015, 11, 30); res.Bis = new DateTime(2015, 12, 13); Target.InsertReservation(res); Assert.IsTrue(res.ReservationNr > 0); } else { Assert.Inconclusive("Cannot run test, since there are no cars or customers available."); } }
public void InsertReservationTest() { Reservation reservation = new Reservation(); reservation.Von = new DateTime(1900, 10, 10); reservation.Bis = new DateTime(1980, 10, 10); Kunde kunde = Target.getKunde(3); reservation.KundeId = kunde.Id; Auto auto = Target.getAuto(2); reservation.AutoId = auto.Id; Reservation resultReservation = Target.addReservation(reservation); Assert.AreEqual(4, resultReservation.ReservationsNr); Assert.AreEqual(new DateTime(1900, 10, 10), resultReservation.Von); Assert.AreEqual(new DateTime(1980, 10, 10), resultReservation.Bis); Assert.AreEqual(3, resultReservation.Kunde.Id); Assert.AreEqual(2, resultReservation.Auto.Id); }