public void initializeData()
{
try
{
conn.Open();
MySqlCommand comm = new MySqlCommand("SELECT * FROM room WHERE id =" + roomId, conn);
MySqlDataAdapter adp = new MySqlDataAdapter(comm);
DataTable dt = new DataTable();
adp.Fill(dt);
if (dt.Rows.Count > 0)
{
txtRoomNumber.Text = dt.Rows[0]["roomNumber"].ToString();
roomTypeId = dt.Rows[0]["roomTypeId"].ToString();
cmbFloor.Text = dt.Rows[0]["floorLevel"].ToString();
txtDesc.Text = dt.Rows[0]["description"].ToString();
}
conn.Close();
}
catch (Exception ee)
{
MessageBox.Show("Nah!" + ee);
conn.Close();
}
RoomDataService myRoomDataServ = new RoomDataService();
RoomTypeInfo lesbian = new RoomTypeInfo();
MessageBox.Show(roomTypeId.ToString());
//string why =
lesbian = myRoomDataServ.getRoomTypeByInt(Convert.ToInt32(roomTypeId));
MessageBox.Show(lesbian.TypeName);
cmbRoomType.Text = lesbian.TypeName;
}
private void cmbRoomTypes_SelectedIndexChanged(object sender, EventArgs e)
{
RoomDataService myRoomDataService = new RoomDataService();
RoomTypeInfo myRoomTypeInfo = new RoomTypeInfo();
myRoomTypeInfo = myRoomDataService.getRoomTypeByName(cmbRoomTypes.Text);
TypeId = myRoomTypeInfo.TypeId;
}