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