using Microsoft.EntityFrameworkCore;
using Renis.Database;
using Renis.Database.Models;

namespace Renis.Repositories;

public class CarRepository(ApplicationContext db) : ICarRepository
{
    private readonly ApplicationContext _db = db;

    public async Task<bool> AddCar(Car car)
    {
        _db.Cars.Add(car);
        return await Save();
    }

    public async Task<bool> DeleteCar(Car car)
    {
        _db.Cars.Remove(car);
        return await Save();
    }

    public async Task<Car?> GetCarById(long id)
    {
        return await _db.Cars.FirstOrDefaultAsync(x => x.Id == id);
    }

    public async Task<Car?> GetCarByNumber(string number)
    {
        return await _db.Cars.FirstOrDefaultAsync(x => x.Number == number);
    }

    public IQueryable<Car> GetCars()
    {
        return _db.Cars.AsQueryable();
    }

    public async Task<bool> Save()
    {
        return await _db.SaveChangesAsync() > 0;
    }

    public async Task<bool> UpdateCar(Car car)
    {
        _db.Cars.Update(car);
        return await Save();
    }
}