private void button3_Click(object sender, EventArgs e)
        {
            cc = new RoomDetailController();

            dt = new DataTable("SearchRecords");

            dt.Columns.Add("Room_Number", System.Type.GetType("System.String"));
            dt.Columns.Add("Room_Type", System.Type.GetType("System.String"));
            dt.Columns.Add("Phone", System.Type.GetType("System.String"));
            dt.Columns.Add("Reserved", System.Type.GetType("System.String"));

            dataGridView1.DataSource = dt;
            btndelete.Visible        = false;
            DialogResult dr = MessageBox.Show("You want to delete the record ?", "Confirm", MessageBoxButtons.YesNo);

            if (dr == DialogResult.Yes)
            {
                if (id != -1)
                {
                    cc.DeleteRecord(id);

                    dt.Rows.Clear();
                    MessageBox.Show("Record Deleted");
                    btndelete.Visible = false;
                }
            }
            searchType = 0;
            bool       flag = false;
            RoomDetail cd   = null;

            flag = int.TryParse(txtnumber.Text, out id);
            cd   = cc.Searchcustomer(id);
            if (cd == null)
            {
                flag = false;
            }
            else
            {
                id         = cd.Room_Number;
                searchType = 1;
                flag       = true;
            }
            if (flag)
            {
                dt.Rows.Clear();
                dt.Rows.Add(new object[] {
                    cd.Room_Number, cd.Room_Type, cd.Phone, cd.Reserved
                });
                btndelete.Visible = true;
            }
            else
            {
                dt.Rows.Clear();
                MessageBox.Show("Record Not Found");
                id = -1;
                btndelete.Visible = false;
            }
        }
        private void btnsearch_Click(object sender, EventArgs e)
        {
            int id;

            bool flag = int.TryParse(txtnumber.Text, out id);

            if (!flag)
            {
                MessageBox.Show("Invalid ID");
                return;
            }


            RoomDetailController std = new RoomDetailController();
            RoomDetail           i   = std.Searchcustomer(id);

            if (i != null)
            {
                a = true;
                txtnumber.Text = i.Room_Number.ToString();
            }
            else
            {
                a = false;
                MessageBox.Show("Record Not Found");
            }
            RoomDetailController sc = new RoomDetailController();

            dt = new DataTable();
            if (a == true)
            {
                dt.Columns.Add("Room_Number", System.Type.GetType("System.String"));
                dt.Columns.Add("Room_Type", System.Type.GetType("System.String"));
                dt.Columns.Add("Phone", System.Type.GetType("System.String"));
                dt.Columns.Add("Reserved", System.Type.GetType("System.String"));
                List <RoomDetail> d = sc.GetAllitem();

                foreach (var s in d)
                {
                    if (id == s.Room_Number)
                    {
                        dt.Rows.Add(new object[] { s.Room_Number, s.Room_Type, s.Phone, s.Reserved });
                    }
                }
                dataGridView1.DataSource = dt;
            }
        }