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