private void LoadRoom() { foreach (CheckBox chk in dicRoom.Values) { if (!chk.Enabled) { chk.Enabled = true; } } lstTrong.Clear(); lstDaDat.Clear(); lstTatCa.Clear(); int iDPhong, value; string sql = "SELECT IDPhong FROM Phong"; if (cboLoaiPhong.Text != "Tất cả") { sql += " WHERE IDPhong IN(SELECT IDPhong FROM Phong WHERE IDLoaiPhong IN(SELECT IDLoaiPhong FROM LoaiPhong WHERE Ten = N'" + cboLoaiPhong.Text + "'))"; } DataTable dt = new PhongBLL().GetPhong(sql); foreach (DataRow dr in dt.Rows) { iDPhong = Convert.ToInt32(dr["IDPhong"]); sql = "SELECT COUNT(IDPhong) FROM Phong WHERE IDPhong = " + iDPhong + " AND TrangThai = 1" + " AND(IDPhong IN(SELECT IDPhong FROM ChiTietDatPhong WHERE IDPhong = " + iDPhong + " AND(NgayNhan > '" + Convert.ToDateTime(dateNgayTra.EditValue).ToString("yyyy-MM-dd") + "' OR NgayTra < '" + Convert.ToDateTime(dateNgayNhan.EditValue).ToString("yyyy-MM-dd") + "')) OR(IDPhong NOT IN(SELECT IDPhong FROM ChiTietDatPhong WHERE IDPhong = " + iDPhong + " AND(NgayNhan <= '" + Convert.ToDateTime(dateNgayTra.EditValue).ToString("yyyy-MM-dd") + "' OR NgayTra >= '" + Convert.ToDateTime(dateNgayNhan.EditValue).ToString("yyyy-MM-dd") + "'))))"; value = (int)new ExecuteBLL().ExecuteScalar(sql); if (value == 1) { lstTrong.Add(iDPhong); if (dicRoom[iDPhong].BackColor == lblPlaced.BackColor) { dicRoom[iDPhong].BackColor = lblEmpty.BackColor; } } else { lstDaDat.Add(iDPhong); dicRoom[iDPhong].Enabled = false; dicRoom[iDPhong].BackColor = lblPlaced.BackColor; } lstTatCa.Add(iDPhong); } ShowRoom(); }
private void cboLoaiPhong_SelectedIndexChanged(object sender, EventArgs e) { foreach (CheckBox chk in picDisplay.Controls) { if (chk.Visible) { chk.Visible = false; } } string sql = "SELECT IDPhong FROM Phong"; if (cboLoaiPhong.Text != "Tất cả") { sql += " WHERE IDPhong IN(SELECT IDPhong FROM Phong WHERE IDLoaiPhong IN(SELECT IDLoaiPhong FROM LoaiPhong WHERE Ten = N'" + cboLoaiPhong.Text + "'))"; } DataTable dt = new PhongBLL().GetPhong(sql); foreach (DataRow dr in dt.Rows) { dicRoom[Convert.ToInt32(dr[0])].Visible = true; } }