public List <HoaDon> DSHoaDonTheoPhong(string ma)
{
HoaDonDAL dal = new HoaDonDAL();
HopDongDAL hddal = new HopDongDAL();
return(dal.TimHDTheoPhong(ma));
}
public HopDong LayThongTinKH(string cm)
{
HopDongDAL dal = new HopDongDAL();
HopDong hd = dal.LayThongTinKH(cm);
return(hd);
}
public int Add_GiaoDich(HopDongDAL hopdongDAL)
{
string query = "insert into HOPDONG values('" + hopdongDAL.maHopDong + "', '" + hopdongDAL.maKhachHang + "', '" + hopdongDAL.maNhanVien + "', '" + hopdongDAL.maCanHo + "','" + hopdongDAL.ngayGiaoDich + "');";
//MessageBox.Show(query);
return(DataProvider.Instance.ExcuteNonQuery(query));
}
public int Update_GiaoDich(HopDongDAL hopdongDAL)
{
string query = "UPDATE HOPDONG SET maKhachHang='" + hopdongDAL.maKhachHang + "', maNhanVien='" + hopdongDAL.maNhanVien + "', maCanHo='" + hopdongDAL.maCanHo + "', ngayGiaoDich='" + hopdongDAL.ngayGiaoDich + "' where maHopDong='" + hopdongDAL.maHopDong + "';";
MessageBox.Show(query);
return(DataProvider.Instance.ExcuteNonQuery(query));
}
public EditGiaoDich(HopDongDAL hd)
{
InitializeComponent();
maHopDong_suaGiaoDich.Text = hd.maHopDong;
maKhachHang_suaGiaoDich.Text = hd.maKhachHang;
maNhanVien_suaGiaoDich.Text = hd.maNhanVien;
maCanHo_suaGiaoDich.Text = hd.maCanHo;
dateTimePicker_ngayGiaoDich.Text = hd.ngayGiaoDich;
}
public bool ThemHopDong(HopDong hd)
{
HopDongDAL dal = new HopDongDAL();
if (dal.KTTrung(hd.MaHopDong))
{
return false;
}
bool kq = dal.ThemHopDong(hd);
return kq;
}
public bool XoaHopDong(string mhd)
{
HopDongDAL dal = new HopDongDAL();
if (dal.KTcoCTHD(mhd))
{
return false;
}
else
{
bool kq = dal.XoaHopDong(mhd);
return kq;
}
}
public List <HopDong> DSHopDong()
{
HopDongDAL dal = new HopDongDAL();
return(dal.DSHopDong());
}
public bool KTTrungMaPhong(string maphong)
{
HopDongDAL dal = new HopDongDAL();
return dal.KTTrungMaPhong(maphong);
}
public List<HopDong> LayThongTinHopDongMaHopDong(string chuoi)
{
HopDongDAL dal = new HopDongDAL();
return dal.LayThongTinHopDongMaHopDong(chuoi);
}
public bool SuaHopDong(HopDong hd)
{
HopDongDAL dal = new HopDongDAL();
return dal.SuaHopDong(hd);
}
public List<HopDong> TaiDSHopDong()
{
HopDongDAL dal = new HopDongDAL();
List<HopDong> dshd = dal.TaiDSHopDong();
return dshd;
}
public HopDong LayThongTinHopDong(string mhd)
{
HopDongDAL dal = new HopDongDAL();
HopDong hd = dal.LayThongTinHopDong(mhd);
return hd;
}
public int Del_GiaoDich(HopDongDAL hopdongDAL)
{
string query = "DELETE HOPDONG WHERE maHopDong='" + hopdongDAL.maHopDong + "'";
return(DataProvider.Instance.ExcuteNonQuery(query));
}
