public ParkingInstance GetParkingInstanceById(int id)
{
using (ParkingSystemContext Ctx = new ParkingSystemContext())
{
return(Ctx.ParkingInstances.Where(t => t.Id == id).Select(t => t).FirstOrDefault());
}
}
public ParkingSpace GetParkingSpaceByLevelAndSpot(int level, int spot)
{
using (ParkingSystemContext Ctx = new ParkingSystemContext())
{
return(Ctx.ParkingSpaces.Where(t => t.Level == level && t.Spot == spot).Select(t => t).FirstOrDefault());
}
}
public bool DeleteCar(int carId)
{
try
{
using (ParkingSystemContext Ctx = new ParkingSystemContext())
{
var car = Ctx.Cars.Where(t => t.Id == carId).Select(t => t).FirstOrDefault();
if (car != null)
{
Ctx.Cars.Remove(car);
Ctx.SaveChanges();
return(true);
}
else
{
return(false);
}
}
}
catch (Exception ex)
{
return(false);
}
}
public Car GetCarByPlate(string LicensePlate)
{
using (ParkingSystemContext Ctx = new ParkingSystemContext())
{
return(Ctx.Cars.Where(t => t.LicensePlate.Equals(LicensePlate)).Select(t => t).FirstOrDefault());
}
}
public Car GetCarById(int id)
{
using (ParkingSystemContext Ctx = new ParkingSystemContext())
{
return(Ctx.Cars.Where(t => t.Id == id).Select(t => t).FirstOrDefault());
}
}
public ParkingInstance GetParkingInstanceBySpace(int level, int spot)
{
using (ParkingSystemContext Ctx = new ParkingSystemContext())
{
return((from ps in Ctx.ParkingSpaces
join pi in Ctx.ParkingInstances on ps.Id equals pi.ParkingSpaceId
where ps.Level == level && ps.Spot == spot
select pi).FirstOrDefault());
}
}
public ParkingInstance GetParkingInstanceByCar(string LicensePlate)
{
using (ParkingSystemContext Ctx = new ParkingSystemContext())
{
return((from car in Ctx.Cars
join pi in Ctx.ParkingInstances on car.Id equals pi.CarId
where car.LicensePlate.Equals(LicensePlate)
select pi).FirstOrDefault());
}
}
public int AddParkingSpace(ParkingSpace pSpace)
{
using (ParkingSystemContext Ctx = new ParkingSystemContext())
{
Ctx.ParkingSpaces.Add(pSpace);
Ctx.SaveChanges();
}
return(pSpace.Id);
}
public int AddCar(Car car)
{
using (ParkingSystemContext Ctx = new ParkingSystemContext())
{
Ctx.Cars.Add(car);
Ctx.SaveChanges();
}
return(car.Id);
}
public ParkingSpace GetParkingSpaceByOwner(string ownerName)
{
using (ParkingSystemContext Ctx = new ParkingSystemContext())
{
return((from car in Ctx.Cars
join pi in Ctx.ParkingInstances on car.Id equals pi.CarId
join ps in Ctx.ParkingSpaces on pi.ParkingSpaceId equals ps.Id
where car.OwnerName.Equals(ownerName)
select ps).FirstOrDefault());
}
}
public int AddParkingInstance(int carId, int spaceId)
{
using (ParkingSystemContext Ctx = new ParkingSystemContext())
{
ParkingInstance pInstance = new ParkingInstance();
pInstance.CarId = carId;
pInstance.ParkingSpaceId = spaceId;
pInstance.StartTime = DateTime.UtcNow;
Ctx.ParkingInstances.Add(pInstance);
Ctx.SaveChanges();
return(pInstance.Id);
}
}
public bool DeleteParkingInstanceBySpace(int pInstanceId)
{
try
{
using (ParkingSystemContext Ctx = new ParkingSystemContext())
{
var pInstance = Ctx.ParkingInstances.Where(t => t.Id == pInstanceId).Select(t => t).FirstOrDefault();
if (pInstance != null)
{
Ctx.ParkingInstances.Remove(pInstance);
Ctx.SaveChanges();
return(true);
}
else
{
return(false);
}
}
}
catch (Exception ex)
{
return(false);
}
}
