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