public List <Reservation> GetReservationen()
{
using (var context = new AutoReservationEntities())
{
return(context.Reservationen.Include(r => r.Kunde).Include(r => r.Auto).ToList());
}
}
/**
* AUTO
**/
public List <Auto> Autos()
{
using (var context = new AutoReservationEntities())
{
return(context.Autos.ToList());
}
}
//Reservation Insert(Reservation reservation)
public Reservation Insert(Reservation reservation)
{
using (var context = new AutoReservationEntities())
{
return(context.Reservationen.Attach(reservation));
}
}
//Reservation Get(Id)
public Reservation GetReservation(int id)
{
using (var context = new AutoReservationEntities())
{
return(context.Reservationen.Include("Auto").Include("Kunde").ToList().Find(i => i.ReservationNr == id));
}
}
public Auto FindAuto(int id)
{
using (var context = new AutoReservationEntities())
{
return(context.Autos.Find(id));
}
}
public IList <Kunde> GetAllKunde()
{
using (AutoReservationEntities context = new AutoReservationEntities())
{
return(context.Kunde.AsNoTracking().ToList());
}
}
//Kunde
//List<Kunde> GetAll()
public List <Kunde> GetKunden()
{
using (var context = new AutoReservationEntities())
{
return(context.Kunden.ToList());
}
}
public List <Auto> GetAutos()
{
using (var context = new AutoReservationEntities())
{
return((from a in context.Autos select a).ToList());
}
}
public Kunde GetKunde(int kundeId)
{
using (AutoReservationEntities context = new AutoReservationEntities())
{
return(context.Kunde.AsNoTracking().SingleOrDefault(x => x.Id == kundeId));
}
}
public Kunde GetKunde(int id)
{
using (var context = new AutoReservationEntities())
{
return((from k in context.Kunden where k.Id == id select k).FirstOrDefault());
}
}
public Reservation GetReservation(int reservationNr)
{
using (var context = new AutoReservationEntities())
{
return(context.Reservationen.Include(r => r.Kunde).Include(r => r.Auto).FirstOrDefault(r => r.ReservationNr == reservationNr));
}
}
public Auto GetAuto(int id)
{
using (var context = new AutoReservationEntities())
{
return((from a in context.Autos where a.Id == id select a).FirstOrDefault());
}
}
public List <Kunde> GetKunden()
{
using (var context = new AutoReservationEntities())
{
return((from k in context.Kunden select k).ToList());
}
}
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 static void InitializeTestData()
{
using (AutoReservationEntities context = new AutoReservationEntities())
{
var connection = (SqlConnection)context.Database.Connection;
var command = new SqlCommand();
command.Connection = connection;
connection.Open();
DeleteAll(command);
// Insert Autos
SetAutoIncrementOnTable(connection, "Auto", true);
InsertAutos(command);
SetAutoIncrementOnTable(connection, "Auto", false);
// Insert Kunden
SetAutoIncrementOnTable(connection, "Kunde", true);
InsertKunden(command);
SetAutoIncrementOnTable(connection, "Kunde", false);
// Insert Reservationen
SetAutoIncrementOnTable(connection, "Reservation", true);
InsertReservationen(command);
SetAutoIncrementOnTable(connection, "Reservation", false);
}
}
//Reservation
public IList <Reservation> GetReservationen()
{
using (var context = new AutoReservationEntities())
{
return(context.Reservationen.Include("Auto").Include("Kunde").ToList());
}
}
public Auto GetAuto(int autoId)
{
using (AutoReservationEntities context = new AutoReservationEntities())
{
return(context.Auto.AsNoTracking().SingleOrDefault(x => x.Id == autoId));
}
}
public Reservation GetReservation(int reservationNr)
{
using (AutoReservationEntities context = new AutoReservationEntities())
{
return(context.Reservation.Include(r => r.Auto).Include(r => r.Kunde).AsNoTracking().SingleOrDefault(x => x.ReservationNr == reservationNr));
}
}
//Auto Get(Id)
public Kunde GetKunde(int id)
{
using (var context = new AutoReservationEntities())
{
return(context.Kunden.Find(id));
}
}
public IList <Reservation> GetAllResevation()
{
using (AutoReservationEntities context = new AutoReservationEntities())
{
return(context.Reservation.Include(r => r.Auto).Include(r => r.Kunde).AsNoTracking().ToList());
}
}
public IList <Auto> GetAllAutos()
{
using (AutoReservationEntities context = new AutoReservationEntities())
{
return(context.Auto.AsNoTracking().ToList());
}
}
//Kunde Insert(Kunde kunde)
public Kunde Insert(Kunde kunde)
{
using (var context = new AutoReservationEntities())
{
return(context.Kunden.Attach(kunde));
}
}
public void CreateAuto(Auto auto)
{
using (var context = new AutoReservationEntities()){
context.AddToAutos(auto);
context.SaveChanges();
}
}
private static void HandleDbConcurrencyException <T>(AutoReservationEntities context, T original) where T : class
{
var databaseValue = context.Entry(original).GetDatabaseValues();
context.Entry(original).CurrentValues.SetValues(databaseValue);
throw new LocalOptimisticConcurrencyException <T>($"Update {typeof (T).Name}: Concurrency-Fehler", original);
}
public void AddReserveration(Reservation reservation)
{
using (AutoReservationEntities context = new AutoReservationEntities())
{
context.Reservation.Add(reservation);
context.SaveChanges();
}
}
public void AddAuto(Auto auto)
{
using (AutoReservationEntities context = new AutoReservationEntities())
{
context.Auto.Add(auto);
context.SaveChanges();
}
}
public void CreateKunde(Kunde kunde)
{
using (var context = new AutoReservationEntities())
{
context.AddToKunden(kunde);
context.SaveChanges();
}
}
public void CreateReservation(Reservation reservation)
{
using (var context = new AutoReservationEntities())
{
context.AddToReservationen(reservation);
context.SaveChanges();
}
}
public void AddKunde(Kunde kunde)
{
using (AutoReservationEntities context = new AutoReservationEntities())
{
context.Kunde.Add(kunde);
context.SaveChanges();
}
}
public Auto GetAutoById(int id)
{
using (var context = new AutoReservationEntities())
{
var auto = context.Autos.Where(a => a.Id == id).FirstOrDefault();
return(auto);
}
}
