public static async Task RentToPersonAsync(Guid carId, Person person) { using (var context = new RentalCarsContext()) { var result = context.Cars.Where(c => c.CarId == carId).FirstOrDefault(); if (result != null) { result.Person = person; result.Rented = true; } var historyResult = context.Histories.Where(h => h.CNP == person.CNP).FirstOrDefault(); if (historyResult == null) { History h = History.Create(person.FirstName, person.LastName, person.CNP, person.FromDate, person.ToDate); context.Histories.Add(h); } else { historyResult.Counter += 1; historyResult.FromDate = person.FromDate; historyResult.ToDate = person.ToDate; } await context.SaveChangesAsync(); } }
public static async Task SavePersonAsync(Person person) { using (var context = new RentalCarsContext()) { context.People.Add(person); await context.SaveChangesAsync(); } }
public static async Task SaveUserAsync(User user) { using (var context = new RentalCarsContext()) { context.Users.Add(user); await context.SaveChangesAsync(); } }
public static async Task SaveCarAsync(Car car) { using (var context = new RentalCarsContext()) { context.Cars.Add(car); await context.SaveChangesAsync(); } }
public static async Task FreeCar(Guid carId) { using (var context = new RentalCarsContext()) { var result = context.Cars.Where(c => c.CarId == carId).FirstOrDefault(); var personResult = context.People.Where(p => p.Car.CarId == carId).FirstOrDefault(); if (result != null) { result.Person = null; result.Rented = false; //context.People.Remove(result.Person); personResult.Car = null; await context.SaveChangesAsync(); } } }