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