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