private void button2_Click(object sender, EventArgs e)
{
#region all statements of add informations
if (txtname.Text != string.Empty)
{
#region paramter
con.Open();
string name = txtname.Text;
Halls c1 = new Halls();
c1.Name = txtname.Text;
#endregion
c1.add1(c1);
con.Close();
}
else
{
MessageBox.Show("Please make sure that you have entered all the information");
}
#endregion
}
private void button3_Click(object sender, EventArgs e)
{
con.Open();
Halls c1 = new Halls();
string name = combhall.Text;
c1.delete1(name);
con.Close();
}
private void button1_Click(object sender, EventArgs e)
{
con.Open();
#region paramter
Halls c1 = new Halls();
string name = combhall.Text;
#endregion
dgv_search_cust.DataSource = c1.search1(name);
con.Close();
}
public displayhall()
{
InitializeComponent();
con.Open();
#region paramter
Halls c1 = new Halls();
#endregion
dgv_display_cust.DataSource = c1.display1();
con.Close();
}
public void edit1(Halls c1, string n)
{
try
{
#region Paramters
SqlCommand cmd;
#endregion
con.Open();
cmd = new SqlCommand("update Halls set Halls_Name='" + c1.Name + "'where Halls_Name='" + n + "'", con);
cmd.ExecuteNonQuery();
MessageBox.Show("Your Update was sucsessful");
con.Close();
}
catch (Exception)
{
MessageBox.Show("Please check Name ");
}
}
public void add1(Halls c2)
{
try
{
#region Paramters
SqlCommand cmd;
#endregion
con.Open();
cmd = new SqlCommand("insert into Halls (Halls_Name) values ('" + c2.Name + "') ", con);
cmd.ExecuteNonQuery();
MessageBox.Show("Your Registeration was sucsessful");
con.Close();
}
catch (Exception)
{
MessageBox.Show("Please check Name ");
}
}