public List <Parking> GetParkings(int carId)
{
using var context = new CarParkingContext();
return(context.Cars.Join(context.CarParkings, car => car.Id, carParking => carParking.CarId,
(c, cp) => new
{
car = c,
carParking = cp
}).Join(context.Parkings, t2 => t2.carParking.ParkingId, parking => parking.Id,
(t3, k) => new
{
car = t3.car,
parking = k,
carParking = t3.carParking
}).Where(I => I.car.Id == carId).Select(I => new Parking
{
Section = I.parking.Section,
Id = I.parking.Id
}).ToList());
}
public List <Table> GetAllData()
{
using var context = new CarParkingContext();
return(context.Set <Table>().ToList());
}
public Table GetWithIdParkings(int id)
{
using var context = new CarParkingContext();
return(context.Set <Table>().Find(id));
}
public void Remove(Table table)
{
using var context = new CarParkingContext();
context.Set <Table>().Remove(table);
context.SaveChanges();
}
