private void add_Click(object sender, EventArgs e)
{
string name = RoomNumber.Text;
if (name == null)
{
MessageBox.Show("Please Enter Room Name!");
}
studyroomsModal stm = new studyroomsModal();
stm.Name = name;
stm.add();
}
private void delete_Click(object sender, EventArgs e)
{
string name1 = RoomNumber.Text;
if (name1 == null)
{
MessageBox.Show("Please Select a row!");
}
studyroomsModal stm = new studyroomsModal();
stm.id = idd;
stm.delete();
}
public void add(studyroomsModal std)
{
try
{
string Query = "insert into studyrooms(Name) values('" + std.Name + "');";
MySqlCommand MyCommand2 = new MySqlCommand(Query, cnn);
MySqlDataReader MyReader2;
cnn.Open();
MyReader2 = MyCommand2.ExecuteReader();
MessageBox.Show("Save Data");
while (MyReader2.Read())
{
}
cnn.Close();
}
catch (Exception ex)
{
}
}
public void delete(studyroomsModal std)
{
try
{
string Query = "delete from studyrooms where id='" + std.id + "';";
MySqlCommand MyCommand2 = new MySqlCommand(Query, cnn);
MySqlDataReader MyReader2;
cnn.Open();
MyReader2 = MyCommand2.ExecuteReader();
MessageBox.Show("Data Deleted");
while (MyReader2.Read())
{
}
cnn.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public void update(studyroomsModal std)
{
try
{
string Query = "update studyrooms set Name='" + std.Name + "' where id='" + std.id + "';";
MySqlCommand MyCommand2 = new MySqlCommand(Query, cnn);
MySqlDataReader MyReader2;
cnn.Open();
MyReader2 = MyCommand2.ExecuteReader();
MessageBox.Show("Data Updated");
while (MyReader2.Read())
{
}
cnn.Close();//Connection closed here
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
