private void button1UpdateR_Click(object sender, EventArgs e)
{
string keyWord = textBoxname.Text;
SqlConnection conn = new SqlConnection(myconnstr);
SqlDataAdapter sda = new SqlDataAdapter("Select * from tbl_room where roomName LIKE '%" + keyWord + "%'", conn);
DataTable DTs = new DataTable();
sda.Fill(DTs);
Regex regex = new Regex(@"^[0-9]+$");
if (comboBoxBuildingName.Text == "")
{
MessageBox.Show("Please Select Building name !");
}
else if (comboBoxFloorNo.Text == "")
{
MessageBox.Show("Please Select Floor No !");
}
else if (textBoxname.Text == "")
{
MessageBox.Show("Room name is required !");
}
else if (DTs.Rows.Count != 0)
{
MessageBox.Show("Room name is already used, Please use another name !");
}
else if (textBoxcapacity.Text == "")
{
MessageBox.Show("Capacity are required !");
}
else if (!regex.IsMatch(textBoxcapacity.Text))
{
MessageBox.Show("Capacity fields must only numeric value!");
}
else if (comboBoxType.Text == "")
{
MessageBox.Show("Room Type is required !!!");
}
else
{
//Get the value from the input fields
r.RoomId = int.Parse(textBoxID.Text);
r.BuildingName = comboBoxBuildingName.Text;
r.Types = comboBoxType.Text;
r.FloorNo = int.Parse(comboBoxFloorNo.Text);
r.Capacity = int.Parse(textBoxcapacity.Text);
r.RoomName = textBoxname.Text;
//Insert data into data base using Insert method
bool success = r.Update(r);
if (success == true)
{
MessageBox.Show("New Building Successfully Updated!");
DataTable dt = r.Select();
dataGridViewRoom.DataSource = dt;
clear();
}
else
{
MessageBox.Show("Failed to update building, Try again!!");
}
}
}
