// Redirected getters~
public static List <Staff> GetStaffsByDetails(int id)
{
return(StaffManager.Merge(Database.Tables.STAFFS, ManagerHelper.GetEqualComparator(Database.Tables.Staffs.DetailsId, id)));
}
public static List <PostalCode> GetPostcodesByCode(string code)
{
return(PostcodeManager.Merge(Database.Tables.POSTAL_CODES, ManagerHelper.GetLikeComparator(Database.Tables.PostalCodes.Code, code)));
}
public static List <City> GetCitiesByName(string name)
{
return(CityManager.Merge(Database.Tables.CITIES, ManagerHelper.GetLikeComparator(Database.Tables.Cities.Name, name)));
}
public static List <State> GetStatesByCountry(int countryId)
{
return(StateManager.Merge(Database.Tables.STATES, ManagerHelper.GetLikeComparator(Database.Tables.States.CountryId, countryId)));
}
public static List <PostalCode> GetPostcodesByCity(string name)
{
return(PostcodeManager.Merge(Database.Tables.POSTAL_CODES, ManagerHelper.GetInLikeComparator(Database.Tables.PostalCodes.CityId, Database.Tables.CITIES, Database.Tables.Cities.Name, name)));
}
public static List <Appointment> GetAppointmentsByStatus(bool cancelled)
{
return(AppointmentManager.Merge(Database.Tables.APPOINTMENTS, ManagerHelper.GetEqualComparator(Database.Tables.Appointments.Cancelled, cancelled ? 1 : 0)));
}
public static List <Medication> GetMedicationByName(string name)
{
return(MedicationManager.Merge(Database.Tables.MEDICATIONS, ManagerHelper.GetEqualComparator(Database.Tables.Medications.Name, name)));
}
// Other getters~
public static List <TestResult> GetTestResultsByPatient(int id)
{
return(TestResultManager.Merge(Database.Tables.TEST_RESULTS, ManagerHelper.GetEqualComparator(Database.Tables.TestResults.PatientId, id)));
}
public static List <TestResult> GetTestResultsByLicenseNo(string license)
{
return(TestResultManager.Merge(Database.Tables.TEST_RESULTS, ManagerHelper.GetEqualComparator(Database.Tables.TestResults.MedicalLicenseNo, license)));
}
public static List <Patient> GetPatientsByDateOfBirth(DateTime dob)
{
return(PatientManager.Merge(Database.Tables.PATIENTS, ManagerHelper.GetInEqualComparator(Database.Tables.Patients.DetailsId, Database.Tables.PERSONAL_DETAILS, Database.Tables.PersonalDetails.DateOfBirth, dob)));
}
public static List <Patient> GetPatientsByPostcode(int id)
{
return(PatientManager.Merge(Database.Tables.PATIENTS, ManagerHelper.GetInEqualComparator(Database.Tables.Patients.DetailsId, Database.Tables.PERSONAL_DETAILS, Database.Tables.PersonalDetails.PostcodeId, id)));
}
public static List <Patient> GetPatientsByAddress(string address)
{
return(PatientManager.Merge(Database.Tables.PATIENTS, ManagerHelper.GetInLikeComparator(Database.Tables.Patients.DetailsId, Database.Tables.PERSONAL_DETAILS, Database.Tables.PersonalDetails.Address, address)));
}
public static List <Patient> GetPatientsByLastName(string name)
{
return(PatientManager.Merge(Database.Tables.PATIENTS, ManagerHelper.GetInLikeComparator(Database.Tables.Patients.DetailsId, Database.Tables.PERSONAL_DETAILS, Database.Tables.PersonalDetails.LastName, name)));
}
// Redirected getters~
public static List <Patient> GetPatientsByDetails(int id)
{
return(PatientManager.Merge(Database.Tables.PATIENTS, ManagerHelper.GetEqualComparator(Database.Tables.Patients.DetailsId, id)));
}
public static List <Prescription> GetPrescriptionsByEndDate(DateTime date)
{
return(PrescriptionManager.Merge(Database.Tables.PRESCRIPTIONS, ManagerHelper.GetEqualComparator(Database.Tables.Prescriptions.EndDate, QueryElement.DateOf(date))));
}
public static List <TestResult> GetTestResultsByName(string name)
{
return(TestResultManager.Merge(Database.Tables.TEST_RESULTS, ManagerHelper.GetLikeComparator(Database.Tables.TestResults.Name, name)));
}
public static List <Appointment> GetAppointmentsByStaff(int id)
{
return(AppointmentManager.Merge(Database.Tables.APPOINTMENTS, ManagerHelper.GetEqualComparator(Database.Tables.Appointments.MedicalStaffId, id)));
}
public static List <TestResult> GetTestResultsByDescription(string desc)
{
return(TestResultManager.Merge(Database.Tables.TEST_RESULTS, ManagerHelper.GetLikeComparator(Database.Tables.TestResults.Description, desc)));
}
public static List <Appointment> GetAppointmentsByDateAndTime(DateTime dt)
{
return(AppointmentManager.Merge(Database.Tables.APPOINTMENTS, ManagerHelper.GetEqualComparator(Database.Tables.Appointments.DateAppointed, dt)));
}
public static List <TestResult> GetTestResultsByRemark(string remark)
{
return(TestResultManager.Merge(Database.Tables.TEST_RESULTS, ManagerHelper.GetLikeComparator(Database.Tables.TestResults.Remark, remark)));
}
public static List <State> GetStatesByName(string name)
{
return(StateManager.Merge(Database.Tables.STATES, ManagerHelper.GetLikeComparator(Database.Tables.States.Name, name)));
}
public static List <TestResult> GetTestResultsByStaff(MedicalStaff staff)
{
return(TestResultManager.Merge(Database.Tables.TEST_RESULTS, ManagerHelper.GetEqualComparator(Database.Tables.TestResults.MedicalLicenseNo, staff.LicenseNo)));
}
public static List <Country> GetCountriesByName(string name)
{
return(CountryManager.Merge(Database.Tables.COUNTRIES, ManagerHelper.GetEqualComparator(Database.Tables.Countries.Name, name)));
}
public static List <Prescription> GetPrescriptionsByStaff(int id)
{
return(PrescriptionManager.Merge(Database.Tables.PRESCRIPTIONS, ManagerHelper.GetEqualComparator(Database.Tables.Prescriptions.PrescriberId, id)));
}
public static List <State> GetStatesByCountry(string name)
{
return(StateManager.Merge(Database.Tables.STATES, ManagerHelper.GetInLikeComparator(Database.Tables.States.CountryId, Database.Tables.COUNTRIES, Database.Tables.Countries.Name, name)));
}
public static List <Prescription> GetPrescriptionsByName(string name)
{
return(PrescriptionManager.Merge(Database.Tables.PRESCRIPTIONS, ManagerHelper.GetEqualComparator(Database.Tables.Prescriptions.Name, name)));
}
public static List <PostalCode> GetPostcodesByCity(int cityId)
{
return(PostcodeManager.Merge(Database.Tables.POSTAL_CODES, ManagerHelper.GetEqualComparator(Database.Tables.PostalCodes.CityId, cityId)));
}
public static List <Prescription> GetPrescriptionsByRemark(string remark)
{
return(PrescriptionManager.Merge(Database.Tables.PRESCRIPTIONS, ManagerHelper.GetEqualComparator(Database.Tables.Prescriptions.Remark, remark)));
}
public static List <City> GetCitiesByState(int stateId)
{
return(CityManager.Merge(Database.Tables.CITIES, ManagerHelper.GetEqualComparator(Database.Tables.Cities.StateId, stateId)));
}
public static List <WorkingDays> GetWorkingDaysByStaff(int id)
{
return(WorkingDaysManager.Merge(Database.Tables.WORKING_DAYS, ManagerHelper.GetEqualComparator(Database.Tables.WorkingDays.StaffId, id)));
}
