public Vehicle GetCarByID(int id) { using (var context = new DealershipContext()) { return context.Vehicles.FirstOrDefault(c=>c.VehicleID == id); } }
public void AddRequest(RequestInfo newRequest) { using (var context = new DealershipContext()) { context.Requests.Add(newRequest); context.SaveChanges(); } }
public void AddCar(Vehicle newCar) { using (var context = new DealershipContext()) { context.Vehicles.Add(newCar); context.SaveChanges(); } }
public void DeleteCarByID(int id) { using (var context = new DealershipContext()) { var car = context.Vehicles.Where(c => c.VehicleID == id); foreach(var c in car) { context.Vehicles.Remove(c); } context.SaveChanges(); } }
public List<RequestInfo> GetAllRequests() { List<RequestInfo> requests = new List<RequestInfo>(); using (var context = new DealershipContext()) { var request = context.Requests.ToList(); foreach (var r in request) { requests.Add(r); } } return requests; }
public List<Vehicle> GetAllCars() { List<Vehicle> vehicles = new List<Vehicle>(); using (var context = new DealershipContext()) { var car = context.Vehicles.ToList(); foreach (var c in car) { vehicles.Add(c); } } return vehicles; }
public void UpdateRequest( RequestInfo request,int status) { using (var context = new DealershipContext()) { context.Requests.Where(x => x.RequestInfoID == request.RequestInfoID); request.RequestStatus = status; context.SaveChanges(); } }
public RequestInfo GetRequestByID(int id) { using (var context = new DealershipContext()) { return context.Requests.FirstOrDefault(r => r.RequestInfoID == id); } }