public static PatientCondition[] GetByPatientID(int patient_id, bool inc_deleted = false)
    {
        DataTable tbl = GetDatatable_ByPatientID(patient_id, inc_deleted);

        PatientCondition[] list = new PatientCondition[tbl.Rows.Count];
        for (int i = 0; i < tbl.Rows.Count; i++)
        {
            list[i] = PatientConditionDB.LoadAll(tbl.Rows[i]);
        }
        return(list);
    }
    public static Hashtable GetHashtable_ByPatientID(int patient_id, bool inc_deleted = false)
    {
        Hashtable selectedConditions = new Hashtable();
        DataTable dt_pt_conditions   = GetDatatable_ByPatientID(patient_id, inc_deleted);

        for (int i = 0; i < dt_pt_conditions.Rows.Count; i++)
        {
            selectedConditions[Convert.ToInt32(dt_pt_conditions.Rows[i]["condition_condition_id"])] = PatientConditionDB.LoadAll(dt_pt_conditions.Rows[i]);
        }
        return(selectedConditions);
    }