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();
}
public static Room GetById(int id)
{
Database db = new Database();
DataTable dt = db.Read("Select * from " + TableName + " WHERE id=" + id);
Room room = new HotelManagement.Room();
var data = dt.Rows[0];
room.Id = id;
room.Price_Per_Day = Convert.ToInt32(data["price_per_day"]);
room.Room_Capacity = Convert.ToInt32(data["room_capacity"]);
room.Room_Type = RoomType.GetById(Convert.ToInt32(data["room_type_id"]));
room.isEmpty = Convert.ToBoolean(data["is_empty"]);
return(room);
}
private void room_save_Click(object sender, EventArgs e)
{
MessageBox.Show("Click");
//Create new room
Room room = new Room();
room.Id = Convert.ToInt32(this.room_number.Text);
room.Room_Capacity = Convert.ToInt32(this.room_capacity.Text);
room.Room_Number = Convert.ToInt32(this.room_capacity.Text);
room.Price_Per_Day = Convert.ToInt32(this.price_per_day.Text);
room.Floor = Convert.ToInt32(this.floor.Text);
room.Room_Type =RoomType.GetById( Convert.ToInt32(room_types.SelectedValue));
room.Save();
//Form2 form2 = new Form2();
// form2.Show();
this.Close();
}