public int UpdateTrangThaiHoaDon(ObjHoaDon obj)
{
SqlParameter[] para =
{
new SqlParameter("HD_MAHD", obj.HD_MaHoaDon),
new SqlParameter("HD_TRANGTHAI", obj.HD_TrangThaiHoaDon),
new SqlParameter("HD_NGAYTRA", obj.HD_NgayTra)
};
return(db.ExcuteSQL("SP_HOADON_UPDATE_TRANGTHAI", para));
}
public int Update(ObjHoaDon obj)
{
SqlParameter[] para =
{
new SqlParameter("HD_MAHD", obj.HD_MaHoaDon),
new SqlParameter("PHG_MAPHONG", obj.PHG_MaPhong),
new SqlParameter("NV_MANV", obj.NV_MANV),
new SqlParameter("KH_MAKH", obj.KH_MaKH),
new SqlParameter("HD_NGAYHD", obj.HD_NgayHoaDon),
new SqlParameter("HD_SOLUONGKHACH", obj.HD_SoLuongKhach),
new SqlParameter("HD_NGAYTHUE", obj.HD_NgayThue)
};
return(db.ExcuteSQL("SP_HOADON_UPDATE", para));
}
public int InsertDK(ObjHoaDon obj)
{
SqlParameter[] para =
{
new SqlParameter("HD_MAHD", obj.HD_MaHoaDon),
new SqlParameter("PHG_MAPHONG", obj.PHG_MaPhong),
new SqlParameter("NV_MANV", obj.NV_MANV),
new SqlParameter("KH_MAKH", obj.KH_MaKH),
new SqlParameter("HD_SOLUONGKHACH", obj.HD_SoLuongKhach),
new SqlParameter("HD_NGAYTHUE", obj.HD_NgayThue),
new SqlParameter("HD_TRANGTHAI", obj.HD_TrangThaiHoaDon)
};
return(db.ExcuteSQL("SP_HOADON_INSERT_FROMDANGKY", para));
}
public int UpdateTrangThai(ObjHoaDon obj)
{
return(dal.UpdateTrangThaiHoaDon(obj));
}
public int Update(ObjHoaDon obj)
{
return(dal.Update(obj));
}
public int InsertDK(ObjHoaDon obj)
{
return(dal.InsertDK(obj));
}
