public Form4(int guest_id, int room_id)
{
this.Guest = Guest.GetById(guest_id);
this.Room = Room.GetById(room_id);
InitializeComponent();
this.Load += Form4_Load;
}
private void UpdateRoom(DataGridViewRow row)
{
int id = Convert.ToInt32(row.Cells["id"].Value);
Room room = Room.GetById(id);
room.Room_Number = Convert.ToInt32(row.Cells["room_number"].Value);
room.Room_Capacity = Convert.ToInt32(row.Cells["room_capacity"].Value);
room.Price_Per_Day = Convert.ToInt32(row.Cells["price_per_day"].Value);
room.Floor = Convert.ToInt32(row.Cells["floor"].Value);
room.Room_Type = RoomType.GetById(Convert.ToInt32(row.Cells["room_type_id"].Value));
room.isEmpty = Convert.ToBoolean(row.Cells["is_empty"].Value);
room.Update();
}
private void ReserveRoom(int id)
{
MessageBox.Show("reserve");
Room room = Room.GetById(id);
if (room.isEmpty)
{
Form form3 = new Form3(id);
form3.Show();
}
else
{
MessageBox.Show("This room is not empty");
}
}
public Room Save()
{
Database db = new Database();
Dictionary <string, string> data = new Dictionary <string, string>();
data["room_number"] = Room_Number.ToString();
data["price_per_day"] = Price_Per_Day.ToString();
data["room_capacity"] = Room_Capacity.ToString();
data["floor"] = Floor.ToString();
data["is_empty"] = isEmpty.ToString();
data["room_type_id"] = Room_Type.Id.ToString();
db.Insert(TableName, data);
//Solve this part more efficient way
Database db_1 = new Database();
DataTable dt = db_1.Read("SELECT MAX(id) FROM " + TableName);
int id = Convert.ToInt32(dt.Rows[0][0].ToString());
return(Room.GetById(id));
}
