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