public void CreateBooking(Booking booking)
{
var context = new CarRentalsContext();
context.Bookings.Add(booking);
context.SaveChanges();
}
public void DeleteBooking(Booking booking)
{
var context = new CarRentalsContext();
context.Bookings.Remove(booking);
context.SaveChanges();
}
public void DeleteCustomer(Customer customer)
{
var context = new CarRentalsContext();
context.Customers.Remove(customer);
context.SaveChanges();
}
public void CreateCustomer(Customer customer)
{
var context = new CarRentalsContext();
context.Customers.Add(customer);
context.SaveChanges();
}
public void DeleteCar(Car car)
{
var context = new CarRentalsContext();
context.Cars.Remove(car);
context.SaveChanges();
}
public void CreateCar(Car car)
{
var context = new CarRentalsContext();
context.Cars.Add(car);
context.SaveChanges();
}
public void DeleteBookingById(int bookingId)
{
var context = new CarRentalsContext();
var booking = context.Bookings.Where(b => b.ID == bookingId).FirstOrDefault();
context.Bookings.Remove(booking);
context.SaveChanges();
}
public void DeleteCustomerById(int customerId)
{
var context = new CarRentalsContext();
var customer = context.Customers.Where(c => c.ID == customerId).FirstOrDefault();
context.Customers.Remove(customer);
context.SaveChanges();
}
public void DeleteCarById(int carId)
{
var context = new CarRentalsContext();
var car = context.Cars.Where(c => c.ID == carId).FirstOrDefault();
context.Cars.Remove(car);
context.SaveChanges();
}
public void UpdateCustomer(int id, Customer customer)
{
using (var context = new CarRentalsContext())
{
var existingCustomer = context.Customers.Where(x => x.ID == id).Select(x => x).FirstOrDefault();
existingCustomer.FirstName = customer.FirstName;
existingCustomer.LastName = customer.LastName;
existingCustomer.Email = customer.Email;
existingCustomer.PhoneNumber = customer.PhoneNumber;
context.SaveChanges();
}
}