public static async Task <List <Car> > GetCarsAsync() { using (var context = new RentalCarsContext()) { return(await context.Cars.ToListAsync()); } }
public static async Task <User> GetUserByUsernameAsync(string username) { using (var context = new RentalCarsContext()) { return(await context.Users.Where(u => u.Username == username).FirstOrDefaultAsync()); } }
public static async Task <bool> PersonAlreadyExist(Person person) { using (var context = new RentalCarsContext()) { return(await context.People.Where(p => p.PersonId == person.PersonId).FirstOrDefaultAsync() != null); } }
public static async Task <Car> GetCarById(Guid carId) { using (var context = new RentalCarsContext()) { return(await context.Cars.Where(c => c.CarId == carId).FirstOrDefaultAsync()); } }
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 <Person> GetPersonByCNP(string CNP) { using (var context = new RentalCarsContext()) { return(await context.People.Where(p => p.CNP == CNP).FirstOrDefaultAsync()); } }
public static async Task <Car> GetCarByCNP(string CNP) { using (var context = new RentalCarsContext()) { return(await context.Cars.Where(c => c.Person.CNP == CNP).FirstOrDefaultAsync()); } }
public static async Task <History> GetHistoryByCNP(string CNP) { using (var context = new RentalCarsContext()) { return(await context.Histories.Where(h => h.CNP == CNP).FirstOrDefaultAsync()); } }
public static async Task <Person> GetPersonByCardId(Guid carId) { using (var context = new RentalCarsContext()) { return(await context.People.Where(p => p.Car.CarId == carId).FirstOrDefaultAsync()); } }
public static async Task <bool> CarAlreadyExist(Car car) { using (var context = new RentalCarsContext()) { return(await context.Cars.Where(c => c.CarPlate == car.CarPlate).FirstOrDefaultAsync() != null); } }
public static async Task <List <History> > GetHistoryAsync() { using (var context = new RentalCarsContext()) { return(await context.Histories.ToListAsync()); } }
public static async Task SavePersonAsync(Person person) { using (var context = new RentalCarsContext()) { context.People.Add(person); 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 SaveUserAsync(User user) { using (var context = new RentalCarsContext()) { context.Users.Add(user); await context.SaveChangesAsync(); } }
public static async Task <bool> LogInAsync(User user) { using (var context = new RentalCarsContext()) { var userFromDB = await context.Users.Where(u => u.Username == user.Username && u.Password == user.Password).FirstOrDefaultAsync(); return(userFromDB != null); } }
public static bool CheckPersonByCNP(string cnp) { using (var context = new RentalCarsContext()) { var result = context.People.Where(p => p.CNP == cnp).FirstOrDefault(); if (result == null) { return(false); } return(true); } }
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(); } } }