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