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;
}
}
