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