public bool EditGuest(Guest guestWithNewValues) { using (MotelDBEntities dbContext = new MotelDBEntities()) { var query = from guest in dbContext.Guests where guest.GuestId == guestWithNewValues.GuestId select guest; Guest selectedGuest = query.First(); // I know the Guest exists // *************************************** /* * selectedGuest.Type = guestWithNewValues.Type; * selectedGuest.NoOfBeds = guestWithNewValues.NoOfBeds; * selectedGuest.Availability = guestWithNewValues.Availability; * selectedGuest.RatePerDay = guestWithNewValues.RatePerDay; */ // *************************************** // dbContext.Guests.Remove(selectedCustomer); dbContext.SaveChanges(); // *************************************** // dbContext.Guests.Add(selectedGuest); // dbContext.SaveChanges(); // *************************************** } return(true); }
public void AddRoom(Room room) { using (MotelDBEntities dbContext = new MotelDBEntities()) { dbContext.Rooms.Add(room); dbContext.SaveChanges(); } }
public void AddGuest(Guest guest) { using (MotelDBEntities dbContext = new MotelDBEntities()) { dbContext.Guests.Add(guest); dbContext.SaveChanges(); } }
public List <Room> GetAllRooms() { using (MotelDBEntities dbContext = new MotelDBEntities()) { var query = from room in dbContext.Rooms select room; return(query.ToList <Room>()); } }
public List <Guest> GetAllGuests() { using (MotelDBEntities dbContext = new MotelDBEntities()) { var query = from guest in dbContext.Guests select guest; return(query.ToList <Guest>()); } }
public bool EditRoom(Room roomWithNewValues) { using (MotelDBEntities dbContext = new MotelDBEntities()) { var query = from room in dbContext.Rooms where room.RoomId == roomWithNewValues.RoomId select room; Room selectedRoom = query.First(); // I know the Room exists // *************************************** selectedRoom.Type = roomWithNewValues.Type; selectedRoom.NoOfBeds = roomWithNewValues.NoOfBeds; selectedRoom.Availability = roomWithNewValues.Availability; selectedRoom.RatePerDay = roomWithNewValues.RatePerDay; // *************************************** // dbContext.Rooms.Remove(selectedCustomer); dbContext.SaveChanges(); // *************************************** // dbContext.Rooms.Add(selectedRoom); // dbContext.SaveChanges(); // *************************************** } return(true); }