Example #1
0
        private void DatPhong_Click(object sender, EventArgs e)
        {
            Button btn = new Button();

            panelDP.Controls.Add(btn);

            panelDV.Hide();
            panelNP.Hide();
            panelHD.Hide();
            panelDP.Show();

            DP_CBMaDP.Hide();
            DP_CBMaKH.Hide();
            DP_CBNgay.Hide();
            DP_CBPhong.Hide();
            DP_CBTenKH.Hide();


            connectDatabase();
            SqlDataAdapter sqlDa = new SqlDataAdapter("SELECT * FROM LOAIPHONG", sqlCon);

            dtTable = new DataTable();
            sqlDa.Fill(dtTable);

            String ItemRowName = "";

            foreach (DataRow dr in dtTable.Rows)
            {
                if (dr["TENLOAI"].ToString() != ItemRowName)
                {
                    DP_LoaiPhong.Items.Add(dr["TENLOAI"]);
                }
                ItemRowName = dr["TENLOAI"].ToString();
            }


            sqlDa = new SqlDataAdapter("SELECT * FROM PHONG", sqlCon);

            dtTable = new DataTable();
            sqlDa.Fill(dtTable);

            ItemRowName = "";

            foreach (DataRow dr in dtTable.Rows)
            {
                if (dr["MAPHONG"].ToString() != ItemRowName)
                {
                    DP_MaPhong.Items.Add(dr["MAPHONG"]);
                }
                ItemRowName = dr["MAPHONG"].ToString();
            }

            sqlCon.Close();
        }
Example #2
0
        /// <summary>
        ///
        /// </summary>
        /// <param Đặt phong ="sender"></param>
        /// <param name="e"></param>

        private bool DP_KiemTraThongTin()
        {
            if (DP_MaKH.Text == "")
            {
                DP_CBMaKH.Show();
                return(false);
            }
            else
            {
                DP_CBMaKH.Hide();
            }

            if (DP_TenKH.Text == "")
            {
                DP_CBTenKH.Show();
                return(false);
            }
            else
            {
                DP_CBTenKH.Hide();
            }

            if (DP_MaDP.Text == "")
            {
                DP_CBMaDP.Show();
                return(false);
            }
            else
            {
                DP_CBMaDP.Hide();
            }
            if (DP_MaPhong.Text == "")
            {
                DP_CBPhong.Show();
                return(false);
            }
            else
            {
                DP_CBPhong.Hide();
            }

            if (DP_NgayDen.Value < DateTime.Now || DP_NgayDen.Value >= DP_NgayDi.Value)
            {
                DP_CBNgay.Show();
                return(false);
            }

            else
            {
                DP_CBNgay.Hide();
            }

            return(true);
        }