public void UpdateAuto(Auto modified, Auto original)
{
using (var context = new AutoReservationEntities())
{
try
{
context.Autos.Attach(original);
context.Autos.ApplyCurrentValues(modified);
context.SaveChanges();
}
catch (OptimisticConcurrencyException)
{
modified.EntityKey = original.EntityKey;
context.Refresh(RefreshMode.StoreWins, modified);
context.SaveChanges();
throw new LocalOptimisticConcurrencyException <Auto>(
"Konflikt beim Ändern eines Wertes der Klasse Auto")
{
Entity = modified
};
}
}
}
public void CreateAuto(Auto auto)
{
using (var context = new AutoReservationEntities()){
context.AddToAutos(auto);
context.SaveChanges();
}
}
public void AddKunde(Kunde kunde)
{
using (AutoReservationEntities context = new AutoReservationEntities())
{
context.Kunde.Add(kunde);
context.SaveChanges();
}
}
public void CreateKunde(Kunde kunde)
{
using (var context = new AutoReservationEntities())
{
context.AddToKunden(kunde);
context.SaveChanges();
}
}
public void AddAuto(Auto auto)
{
using (AutoReservationEntities context = new AutoReservationEntities())
{
context.Auto.Add(auto);
context.SaveChanges();
}
}
public void AddReserveration(Reservation reservation)
{
using (AutoReservationEntities context = new AutoReservationEntities())
{
context.Reservation.Add(reservation);
context.SaveChanges();
}
}
public void CreateReservation(Reservation reservation)
{
using (var context = new AutoReservationEntities())
{
context.AddToReservationen(reservation);
context.SaveChanges();
}
}
public void DeleteReservation(Reservation reservation)
{
using (var context = new AutoReservationEntities())
{
context.Reservationen.Attach(reservation);
context.Reservationen.DeleteObject(reservation);
context.SaveChanges();
}
}
public void DeleteKunde(Kunde kunde)
{
using (var context = new AutoReservationEntities())
{
context.Kunden.Attach(kunde);
context.Kunden.DeleteObject(kunde);
context.SaveChanges();
}
}
public int InsertReservation(Reservation reservation)
{
using (var context = new AutoReservationEntities())
{
context.AddToReservationen(reservation);
context.SaveChanges();
return(reservation.ReservationNr);
}
}
public int InsertKunde(Kunde kunde)
{
using (var context = new AutoReservationEntities())
{
context.AddToKunden(kunde);
context.SaveChanges();
return(kunde.Id);
}
}
public int InsertAuto(Auto auto)
{
using (var context = new AutoReservationEntities())
{
context.AddToAutos(auto);
context.SaveChanges();
return(auto.Id);
}
}
public void DeleteAuto(Auto auto)
{
using (AutoReservationEntities context = new AutoReservationEntities())
{
context.Auto.Attach(auto);
context.Auto.Remove(auto);
context.SaveChanges();
}
}
public Kunde InsertKunde(Kunde kunde)
{
using (var context = new AutoReservationEntities())
{
var newKunde = context.Kunden.Add(kunde);
context.SaveChanges();
return(newKunde);
}
}
public Reservation InsertReservation(Reservation reservation)
{
using (var context = new AutoReservationEntities())
{
var newReservation = context.Reservationen.Add(reservation);
context.SaveChanges();
return(newReservation);
}
}
public void DeleteKunde(Kunde kunde)
{
using (AutoReservationEntities context = new AutoReservationEntities())
{
context.Kunde.Attach(kunde);
context.Kunde.Remove(kunde);
context.SaveChanges();
}
}
public Auto InsertAuto(Auto auto)
{
using (var context = new AutoReservationEntities())
{
var newAuto = context.Autos.Add(auto);
context.SaveChanges();
return(newAuto);
}
}
public void DeleteReservation(Reservation reservation)
{
using (AutoReservationEntities context = new AutoReservationEntities())
{
context.Reservation.Attach(reservation);
context.Reservation.Remove(reservation);
context.SaveChanges();
}
}
public void DeleteAuto(Auto auto)
{
using (var context = new AutoReservationEntities())
{
context.Autos.Attach(auto);
context.Autos.DeleteObject(auto);
context.SaveChanges();
}
}
public void UpdateAuto(Auto original, Auto modified)
{
context.Autos.Attach(original);
context.Entry(original).CurrentValues.SetValues(modified);
try
{
context.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
HandleDbConcurrencyException(context, original);
}
context.Entry(original).State = EntityState.Detached;
}
public Auto DeleteAuto(Auto auto)
{
using (var context = new AutoReservationEntities())
{
context.Autos.Attach(auto);
var deletedAuto = context.Autos.Remove(auto);
context.SaveChanges();
return(deletedAuto);
}
}
public Reservation DeleteReservation(Reservation reservation)
{
using (var context = new AutoReservationEntities())
{
context.Reservationen.Attach(reservation);
var deletedReservation = context.Reservationen.Remove(reservation);
context.SaveChanges();
return(deletedReservation);
}
}
public Kunde DeleteKunde(Kunde kunde)
{
using (var context = new AutoReservationEntities())
{
context.Kunden.Attach(kunde);
var deletedKunde = context.Kunden.Remove(kunde);
context.SaveChanges();
return(deletedKunde);
}
}
public void UpdateReservation(Reservation modified, Reservation original)
{
using (var context = new AutoReservationEntities())
{
try
{
context.Reservationen.Attach(original);
context.Reservationen.ApplyCurrentValues(modified);
context.SaveChanges();
}
catch (OptimisticConcurrencyException)
{
modified.EntityKey = original.EntityKey;
context.Refresh(RefreshMode.StoreWins, modified);
context.SaveChanges();
throw new LocalOptimisticConcurrencyException <Reservation>("Update Reservation: Concurrency-Fehler")
{
Entity = modified
};
}
}
}
public void AddKunden(Kunde kunde)
{
using (var context = new AutoReservationEntities())
{
try
{
context.Kunden.Add(kunde);
context.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
HandleDbConcurrencyException(context, kunde);
}
}
}
public void AddReservation(Reservation res)
{
using (var context = new AutoReservationEntities())
{
try
{
context.Reservationen.Add(res);
context.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
HandleDbConcurrencyException(context, res);
}
}
}
public void AddAuto(Auto auto)
{
using (var context = new AutoReservationEntities())
{
try
{
context.Autos.Add(auto);
context.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
HandleDbConcurrencyException(context, auto);
}
}
}
public void UpdateKunde(Kunde modified, Kunde original)
{
using (AutoReservationEntities context = new AutoReservationEntities())
{
try
{
context.Kunde.Attach(original);
context.Entry(original).CurrentValues.SetValues(modified);
context.SaveChanges();
}
catch (DbUpdateConcurrencyException e)
{
HandleDbConcurrencyException(context, original);
}
}
}
public virtual void UpdateReservation(Reservation original, Reservation modified)
{
using (var context = new AutoReservationEntities())
{
try
{
context.Reservationen.Attach(original);
context.Entry(original).CurrentValues.SetValues(modified);
context.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
HandleDbConcurrencyException(context, original);
}
}
}
public Reservation UpdateReservation(Reservation modified, Reservation original)
{
using (var context = new AutoReservationEntities())
{
try {
context.Reservationen.Attach(original);
context.Entry(original).CurrentValues.SetValues(modified);
context.SaveChanges();
return(modified);
}
catch (DbUpdateConcurrencyException e)
{
HandleDbConcurrencyException <Reservation>(context, original);
return(null);
}
}
}
