private void manageToolStripMenuItem_Click(object sender, EventArgs e) { room r = new room(); this.Hide(); r.Show(); }
private void button3_Click(object sender, EventArgs e) { this.Hide(); room r = new room(); r.Show(); }
private void RefreshAll() { wordNo.SelectedIndex = -1; roomNo.SelectedIndex = -1; rroomtype.SelectedIndex = -1; bedCapacity.SelectedIndex = -1; sitCharge.SelectedIndex = -1; this.Close(); room r = new room(); r.Show(); }
private void button2_Click(object sender, EventArgs e) { SqlDataAdapter cc = new SqlDataAdapter(" SELECT room_no FROM room", c); DataTable dw = new DataTable(); cc.Fill(dw); foreach (DataRow item in dw.Rows) { int n = 0; string[] wn = new string[4]; wn[n] = item[0].ToString(); if (wordNo.Text == wn[n]) { MessageBox.Show("Already added.\n Add another."); this.Close(); room p = new room(); p.Show(); st = false; } } if (st) { if (wordNo.Text == "" || rroomtype.Text == "" || bedCapacity.Text == "") { MessageBox.Show("Fill all boxes"); } else { c.Open(); SqlCommand cm = new SqlCommand(@"INSERT INTO room (w_no, room_no, room_type, capacity, charge) VALUES ('" + wordNo.Text + "','" + roomNo.Text + "','" + rroomtype.Text + "','" + bedCapacity.Text + "','" + sitCharge.Text + "') ", c); cm.ExecuteNonQuery(); c.Close(); Display(); MessageBox.Show("Room added"); RefreshAll(); } st = false; } }