public static DataTable getRent()
{
return(DTBill.exec("SELECT * FROM PHIEUTHUE"));
}
public static DataTable getRoom()
{
return(DTBill.exec("SELECT * FROM PHONG"));
}
public static DataTable getNhanVien()
{
string sql = "SELECT * FROM NHANVIEN";
return(DTBill.exec(sql));
}
public static DataTable getChiTietHoaDon(int mhd)
{
string sql = "SELECT * FROM CHITIETHOADON WHERE MaHD=N'" + mhd.ToString() + "'";
return(DTBill.exec(sql));
}
public static DataTable get_email_byEmail(string email)
{
string sql = "SELECT * FROM TAIKHOAN WHERE email='" + email + "'";
return(DTBill.exec(sql));
}
public static DataTable get_user_byUsername(string username)
{
string sql = "SELECT * FROM TAIKHOAN WHERE Username='******'";
return(DTBill.exec(sql));
}
