// Select House public House Select(int id) { using (RentalContext db = new RentalContext()) { return(db.houses.Find(id)); } }
// Select Boat public Boat Select(int id) { using (RentalContext db = new RentalContext()) { return(db.boats.Find(id)); } }
// Read InvoiceLine public List <InvoiceLine> Read() { using (RentalContext db = new RentalContext()) { return(null); } }
// Select InvoiceLine public InvoiceLine Select(int id) { using (RentalContext db = new RentalContext()) { return(db.invoiceLines.Find(id)); } }
// Read Rent public List <Rent> Read() { using (RentalContext db = new RentalContext()) { return(null); } }
// Select Car public Car Select(int id) { using (RentalContext db = new RentalContext()) { return(db.cars.Find(id)); } }
// Create Client public void Create(Client client) { using (RentalContext db = new RentalContext()) { db.clients.Add(client); } }
// Select Employee public Employee Select(int id) { using (RentalContext db = new RentalContext()) { return(db.employees.Find(id)); } }
// Select Client public Client Select(int id) { using (RentalContext db = new RentalContext()) { return(db.clients.Find(id)); } }
// Create Boat public void Create(Boat boat) { using (RentalContext db = new RentalContext()) { db.boats.Add(boat); db.SaveChanges(); } }
// Delete Boat public void Delete(int id) { using (RentalContext db = new RentalContext()) { Boat findBoat = db.boats.Find(id); findBoat.active = false; db.SaveChanges(); } }
// Update Boat public void Update(Boat boat) { using (RentalContext db = new RentalContext()) { Boat findBoat = db.boats.Find(boat.id); findBoat.costPerDay = boat.costPerDay; findBoat.description = boat.description; findBoat.numPassengers = boat.numPassengers; findBoat.type = boat.type; findBoat.brand = boat.brand; findBoat.model = boat.model; findBoat.competitorCode = boat.competitorCode; db.SaveChanges(); } }
// Read Boat public List <Boat> Read() { using (RentalContext db = new RentalContext()) { List <Boat> boats = new List <Boat>(); foreach (Boat item in db.boats) { if (item.active == true) { boats.Add(item); } } return(boats); } }
// Delete InvoiceLine public void Delete(InvoiceLine invoiceLine) { using (RentalContext db = new RentalContext()) { } }
// Delete House public void Delete(House house) { using (RentalContext db = new RentalContext()) { } }
// Delete Car public void Delete(Car car) { using (RentalContext db = new RentalContext()) { } }
// Delete Employee public void Delete(Employee employee) { using (RentalContext db = new RentalContext()) { } }
// Update Client public void Update(Client client) { using (RentalContext db = new RentalContext()) { } }
// Delete Rent public void Delete(Rent rent) { using (RentalContext db = new RentalContext()) { } }
// Update Invoice public void Update(Invoice invoice) { using (RentalContext db = new RentalContext()) { } }