public Booking GetBookingById(int bookingId)
{
using (var context = new CarRentalsContext())
{
return(context.Bookings.FirstOrDefault(b => b.ID == bookingId));
}
}
public void CreateCar(Car car)
{
var context = new CarRentalsContext();
context.Cars.Add(car);
context.SaveChanges();
}
public void CreateCustomer(Customer customer)
{
var context = new CarRentalsContext();
context.Customers.Add(customer);
context.SaveChanges();
}
public void DeleteCustomer(Customer customer)
{
var context = new CarRentalsContext();
context.Customers.Remove(customer);
context.SaveChanges();
}
public Customer GetCustomerById(int customerId)
{
using (var context = new CarRentalsContext())
{
return(context.Customers.FirstOrDefault(c => c.ID == customerId));
}
}
public void CreateBooking(Booking booking)
{
var context = new CarRentalsContext();
context.Bookings.Add(booking);
context.SaveChanges();
}
public void DeleteCar(Car car)
{
var context = new CarRentalsContext();
context.Cars.Remove(car);
context.SaveChanges();
}
public Car GetCarById(int id)
{
using (var context = new CarRentalsContext())
{
return(context.Cars.FirstOrDefault(c => c.ID == id));
}
}
public void DeleteBooking(Booking booking)
{
var context = new CarRentalsContext();
context.Bookings.Remove(booking);
context.SaveChanges();
}
public List <Booking> GetAllBookings()
{
using (var context = new CarRentalsContext())
{
return(context.Bookings.ToList());
}
}
public List <Car> GetAllCars()
{
using (var context = new CarRentalsContext())
{
return(context.Cars.ToList());
}
}
public Car GetCarByRegnum(string regNo)
{
using (var context = new CarRentalsContext())
{
return(context.Cars.FirstOrDefault(c => c.RegistrationNo == regNo));
}
}
public Car GetCarByBrand(string brand)
{
using (var context = new CarRentalsContext())
{
return(context.Cars.FirstOrDefault(c => c.Brand == brand));
}
}
public List <Customer> GetAllCustomer()
{
using (var context = new CarRentalsContext())
{
return(context.Customers.ToList());
}
}
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 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 DeleteCarById(int carId)
{
var context = new CarRentalsContext();
var car = context.Cars.Where(c => c.ID == carId).FirstOrDefault();
context.Cars.Remove(car);
context.SaveChanges();
}
public List <Car> GetAvalibleCars(DateTime dateFrom, DateTime dateTo)
{
using (var context = new CarRentalsContext())
{
var carIds = context.Bookings.Where(x => x.StartTime <= dateFrom && x.EndTime <= dateTo)
.Select(x => x.CarID).Distinct().ToArray();
var result = context.Cars.Where(x => !carIds.Contains(x.ID)).ToList();
return(result);
}
}
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();
}
}
