public static PhongDetail LoadChiTietPhong(int idPhong)
{
PhongDetail phongDetail = new PhongDetail();
string query = string.Format("exec pro_LoadThongTinChiTietPhong '{0}'", idPhong);
DataTable dt = DataProvider.Instance.ExcuteQuery(query);
phongDetail.IdPhong = idPhong;
phongDetail.GhiChu = dt.Rows[0]["GhiChu"].ToString();
phongDetail.TinhTrang = int.Parse(dt.Rows[0]["TinhTrang"].ToString());
phongDetail.DsKhachThue = new List <Dictionary>();
if (phongDetail.TinhTrang == 1)
{
query = string.Format("exec pro_LoadDSKhachThuePhong '{0}'", idPhong);
dt = DataProvider.Instance.ExcuteQuery(query);
phongDetail.IdPhieuThue = int.Parse(dt.Rows[0]["idPhieuThue"].ToString());
DateTime date = (DateTime)dt.Rows[0]["NgayThue"];
phongDetail.NgayThue = date.ToString("dd/MM/yyyy HH:mm");
foreach (DataRow item in dt.Rows)
{
Dictionary dsKhachThue = new Dictionary();
dsKhachThue.Id = int.Parse(item["STT"].ToString());
dsKhachThue.Name = item["TenKhachHang"].ToString();
phongDetail.DsKhachThue.Add(dsKhachThue);
}
}
return(phongDetail);
}
void DatLai()
{
lblTenPhong.Text = "";
idPhong = -1;
PhongDetail phongDetail = new PhongDetail();
phongDetail.DsKhachThue = new List <Dictionary>();
txtTinhTrang.Text = "";
txtNgayThue.Text = "";
txtGhiChu.Text = "";
dtgDSKhachThue.DataSource = phongDetail.DsKhachThue;
}
private void Btn_Click(object sender, EventArgs e)
{
Button btn = ((sender as Button));
lblTenPhong.Text = btn.Text;
idPhong = int.Parse(btn.Name);
PhongDetail phongDetail = PhongDAO.LoadChiTietPhong(int.Parse(btn.Name));
if (phongDetail.TinhTrang == 0)
{
txtTinhTrang.Text = "Còn trống";
txtNgayThue.Text = "";
}
else
{
txtTinhTrang.Text = "Đã thuê";
txtNgayThue.Text = phongDetail.NgayThue;
}
txtGhiChu.Text = phongDetail.GhiChu;
dtgDSKhachThue.DataSource = phongDetail.DsKhachThue;
}
