private void button2_Click(object sender, EventArgs e)
{
Patrick_Hotel_DatabaseEntities db = new Patrick_Hotel_DatabaseEntities();
int oldRoomId = int.Parse(dataGridView1.CurrentRow.Cells[3].Value.ToString());
var oldRoomNumber = (from x in db.Room where x.RoomId == oldRoomId select x.RoomNumber).FirstOrDefault();
int guestId = int.Parse(guestIdLbl.Text);
string guestName = textBox2.Text;
string documentId = textBox3.Text;
string newRoomNumber = textBox4.Text;
int paymentTotal = int.Parse(textBox7.Text);
int deposit = int.Parse(textBox8.Text);
gc.updateGuest(guestId, guestName, documentId, oldRoomNumber, newRoomNumber, paymentTotal, deposit);
dataGridView1.DataSource = gc.loadData();
dataGridView2.DataSource = gc.loadRoom();
}
