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