コード例 #1
0
        private void btndelete3_Click(object sender, EventArgs e)
        {
            cc = new ReservationDetailController();

            dt = new DataTable("SearchRecords");

            dt.Columns.Add("Reserve_ID", System.Type.GetType("System.String"));
            dt.Columns.Add("Customer_ID", System.Type.GetType("System.String"));
            dt.Columns.Add("Room_Type", System.Type.GetType("System.String"));
            dt.Columns.Add("Room_Number", System.Type.GetType("System.String"));
            dt.Columns.Add("Date_in", System.Type.GetType("System.String"));
            dt.Columns.Add("Date_out", System.Type.GetType("System.String"));
            dataGridView1.DataSource = dt;
            btndelete3.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");
                    btndelete3.Visible = false;
                }
            }
            searchType = 0;
            bool flag            = false;
            ReservationDetail cd = null;

            flag = int.TryParse(txtreserveid.Text, out id);
            cd   = cc.Searchcustomer(id);
            if (cd == null)
            {
                flag = false;
            }
            else
            {
                id         = cd.Customer_ID;
                searchType = 1;
                flag       = true;
            }
            if (flag)
            {
                dt.Rows.Clear();
                dt.Rows.Add(new object[] {
                    cd.Reserve_ID, cd.Customer_ID, cd.Room_Type, cd.Room_Number, cd.Date_In, cd.Date_Out
                });
                btndelete3.Visible = true;
            }
            else
            {
                dt.Rows.Clear();
                MessageBox.Show("Record Not Found");
                id = -1;
                btndelete3.Visible = false;
            }
        }
コード例 #2
0
        private void btnsearch_Click(object sender, EventArgs e)
        {
            int id;

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

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


            ReservationDetailController std = new ReservationDetailController();
            ReservationDetail           i   = std.Searchcustomer(id);

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

            dt = new DataTable();
            if (a == true)
            {
                dt.Columns.Add("Reserve_ID", System.Type.GetType("System.String"));
                dt.Columns.Add("Customer_ID", System.Type.GetType("System.String"));
                dt.Columns.Add("Room_Type", System.Type.GetType("System.String"));
                dt.Columns.Add("Room_Number", System.Type.GetType("System.String"));
                dt.Columns.Add("Date_in", System.Type.GetType("System.String"));
                dt.Columns.Add("Date_out", System.Type.GetType("System.String"));

                List <ReservationDetail> d = sc.GetAllitem();

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