public void executeDSPrintReport(dischargeSummaryScheduleVo job)
{           
    EdischargeSTHKSummaryVoCollection summaries = getSTHKPatientDocuments();
    if (summaries != null && summaries.size() > 0)
    {
        System.out.println( "executeDSPrintReport " + summaries.size());
        try 
        {
            saveReports(summaries,job,"discharge Summary Report",DocumentCategory.disCHARGE_SUMMARY);
        }
        catch (Exception e) 
        {
            getDomainFactory().close();
        }
    }       
}

public dischargeSummaryScheduleVo getJob(String jobDesc) 
{
    DomainFactory factory = getDomainFactory();
    String sql = "from dischargeSummarySchedule";               
    List jobs = factory.find(sql);
    if (jobs.size() > 0)
    {
        for (int i = 0 ; i < jobs.size(); i ++)
        {
            dischargeSummaryScheduleVo voDSS = dischargeSummaryScheduleVoAssembler.create((dischargeSummarySchedule) jobs.get(i));

            StringBuffer sb = new StringBuffer();               
            sb.append(voDSS.getJobType().getText().toString());

            if (jobDesc.equals(sb.toString())) {
                return voDSS;
            }
        }
    }

    return null;        
}

public void executeDSPrintReport(dischargeSummaryScheduleVo job)
{
    dischargeReportDetailVoCollection dischargeReportsDetails = null;

    do
    {
        dischargeReportsDetails = getPatientDocuments();

        if (dischargeReportsDetails != null && dischargeReportsDetails.size() > 0)
        {
            try
            {
                saveReports(dischargeReportsDetails,DocumentCategory.disCHARGE_SUMMARY);
            }
            catch (Exception e)
            {
                getDomainFactory().close();
                break;
            }
        }
    }
    while (getMorePatientDocuments);
}

public dischargeSummaryScheduleVo getJob(String jobDesc) 
{
    DomainFactory factory = getDomainFactory();
    String sql = "from dischargeSummarySchedule";               
    List jobs = factory.find(sql);
    if (jobs.size() > 0)
    {
        for (int i = 0 ; i < jobs.size(); i ++)
        {
            dischargeSummaryScheduleVo voDSS = dischargeSummaryScheduleVoAssembler.create((dischargeSummarySchedule) jobs.get(i));

            StringBuffer sb = new StringBuffer();               
            sb.append(voDSS.getJobType().getText().toString());

            if (jobDesc.equals(sb.toString())) {
                return voDSS;
            }
        }
    }

    return null;        
}

public dischargeSummaryScheduleVo getJob(String jobDesc) 
{
    DomainFactory factory = getDomainFactory();
    String sql = "from dischargeSummarySchedule";               
    List jobs = factory.find(sql);
    if (jobs.size() > 0)
    {
        for (int i = 0 ; i < jobs.size(); i ++)
        {
            dischargeSummaryScheduleVo voDSS = dischargeSummaryScheduleVoAssembler.create((dischargeSummarySchedule) jobs.get(i));

            StringBuffer sb = new StringBuffer();               
            sb.append(voDSS.getJobType().getText().toString());

            if (jobDesc.equals(sb.toString())) {
                return voDSS;
            }
        }
    }

    return null;        
}

public void executeDSPrintReport(dischargeSummaryScheduleVo job)
{           
    EdischargeSTHKSummaryVoCollection summaries = getSTHKPatientDocuments();
    if (summaries != null && summaries.size() > 0)
    {
        System.out.println( "executeDSPrintReport " + summaries.size());
        try 
        {
            saveReports(summaries,DocumentCategory.disCHARGE_SUMMARY);
        }
        catch (Exception e) 
        {
            getDomainFactory().close();
        }
    }       
}

public dischargeSummaryScheduleVo getJob(String jobDesc) 
{
    DomainFactory factory = getDomainFactory();
    String sql = "from dischargeSummarySchedule";               
    List jobs = factory.find(sql);
    if (jobs.size() > 0)
    {
        for (int i = 0 ; i < jobs.size(); i ++)
        {
            dischargeSummaryScheduleVo voDSS = dischargeSummaryScheduleVoAssembler.create((dischargeSummarySchedule) jobs.get(i));

            StringBuffer sb = new StringBuffer();               
            sb.append(voDSS.getJobType().getText().toString());

            if (jobDesc.equals(sb.toString())) {
                return voDSS;
            }
        }
    }

    return null;        
}

public void executeDSPrintReport(dischargeSummaryScheduleVo job)
{           
    EdischargeSTHKSummaryVoCollection summaries = getSTHKPatientDocuments();
    if (summaries != null && summaries.size() > 0)
    {
        System.out.println( "executeDSPrintReport " + summaries.size());
        try 
        {
            saveReports(summaries,DocumentCategory.disCHARGE_SUMMARY);
        }
        catch (Exception e) 
        {
            getDomainFactory().close();
        }
    }       
}

public dischargeSummaryScheduleVo getJob(String jobDesc) 
{
    DomainFactory factory = getDomainFactory();
    String sql = "from dischargeSummarySchedule";               
    List jobs = factory.find(sql);
    if (jobs.size() > 0)
    {
        for (int i = 0 ; i < jobs.size(); i ++)
        {
            dischargeSummaryScheduleVo voDSS = dischargeSummaryScheduleVoAssembler.create((dischargeSummarySchedule) jobs.get(i));

            StringBuffer sb = new StringBuffer();               
            sb.append(voDSS.getJobType().getText().toString());

            if (jobDesc.equals(sb.toString())) {
                return voDSS;
            }
        }
    }

    return null;        
}

@Override
protected void onFormOpen(Object[] args) throws PresentationLogicException 
{
    if (args.length > 0)
    {
        populateGrid((dischargeSummaryScheduleVo)args[0]);                  
    }       
}

private void populateGrid(dischargeSummaryScheduleVo dischargeSummary)
{
    if (dischargeSummary == null)
        return;

    form.GrdList().getRows().clear();
    FailedEmailsDetailsVoCollection FailedEmails = dischargeSummary.getFailedEmails();

    for (int j = 0 ; FailedEmails != null && j < FailedEmails.size() ; j++)
    {
        FailedEmailsDetailsVo FailedEmail = FailedEmails.get(j);

        GrdListRow row = form.GrdList().getRows().newRow();
        row.setValue(FailedEmail);

        if (FailedEmail.getJobTypeIsNotNull())
            row.setColJobType(FailedEmail.getJobType().getText());          
        if (FailedEmail.getGPNameIsNotNull())
            row.setColGPName(FailedEmail.getGPName());
        if (FailedEmail.getEmailAddressIsNotNull())
            row.setColEmailAddress(FailedEmail.getEmailAddress());
        if (FailedEmail.getPatientNameIsNotNull())
            row.setColPatient(FailedEmail.getPatientName());
        if (FailedEmail.getinitialDateTimeIsNotNull())
            row.setColInitialDateTime(FailedEmail.getinitialDateTime().toString());
        if (FailedEmail.getFailedDateTimeIsNotNull())
            row.setColFailedDateTime(FailedEmail.getFailedDateTime().toString());
        if (FailedEmail.getSuccessfulDateTimeIsNotNull())
            row.setColSuccessfulSent(FailedEmail.getSuccessfulDateTime().toString());
    }
}

public void save(dischargeSummaryScheduleVo batch) throws StaleObjectException
{
    if(batch == null) {
        throw new CodingRuntimeException("dischargeSummaryScheduleVo is null");
    }
    if (!batch.isValidated()) {
        throw new DomainRuntimeException("dischargeSummaryScheduleVo not validated");
    }

    DomainFactory factory = getDomainFactory();
    factory.save(dischargeSummaryScheduleVoAssembler.extractdischargeSummarySchedule(factory,batch));
}

public dischargeSummaryScheduleVo getdischargeSummarySchedule(dischargeSummaryScheduleRefVo voRef)
{
    if(voRef == null)
        throw new CodingRuntimeException("Cannot get dischargeSummaryScheduleVo for null dischargeSummaryScheduleRefVo");

    DomainFactory factory = getDomainFactory();
    dischargeSummarySchedule dodischargeSummarySchedule = (dischargeSummarySchedule) factory.getDomainObject(dischargeSummarySchedule.class,voRef.getID_dischargeSummarySchedule());
    return dischargeSummaryScheduleVoAssembler.create(dodischargeSummarySchedule);
}

public void executeSUPpprintReport(dischargeSummaryScheduleVo job) 
{           
    EdischargeSTHKSummaryVoCollection summaries = getSTHKSuppPatientDocuments();
    if (summaries != null && summaries.size() > 0)
    {
        try
        {
            saveReports(summaries,"Supplementary Report",DocumentCategory.disCHARGE_SUPPLEMENTARY);
        }
        catch(Exception e)
        {
            getDomainFactory().close();                 
        }
    }       
}

@Override
protected void onFormOpen(Object[] args) throws PresentationLogicException 
{
    if (args.length > 0)
    {
        populateGrid((dischargeSummaryScheduleVo)args[0]);                  
    }       
}

private void populateGrid(dischargeSummaryScheduleVo dischargeSummary)
{
    if (dischargeSummary == null)
        return;

    form.GrdList().getRows().clear();
    FailedEmailsDetailsVoCollection FailedEmails = dischargeSummary.getFailedEmails();

    for (int j = 0 ; FailedEmails != null && j < FailedEmails.size() ; j++)
    {
        FailedEmailsDetailsVo FailedEmail = FailedEmails.get(j);

        GrdListRow row = form.GrdList().getRows().newRow();
        row.setValue(FailedEmail);

        if (FailedEmail.getJobTypeIsNotNull())
            row.setColJobType(FailedEmail.getJobType().getText());          
        if (FailedEmail.getGPNameIsNotNull())
            row.setColGPName(FailedEmail.getGPName());
        if (FailedEmail.getEmailAddressIsNotNull())
            row.setColEmailAddress(FailedEmail.getEmailAddress());
        if (FailedEmail.getPatientNameIsNotNull())
            row.setColPatient(FailedEmail.getPatientName());
        if (FailedEmail.getinitialDateTimeIsNotNull())
            row.setColInitialDateTime(FailedEmail.getinitialDateTime().toString());
        if (FailedEmail.getFailedDateTimeIsNotNull())
            row.setColFailedDateTime(FailedEmail.getFailedDateTime().toString());
        if (FailedEmail.getSuccessfulDateTimeIsNotNull())
            row.setColSuccessfulSent(FailedEmail.getSuccessfulDateTime().toString());
    }
}

public void save(dischargeSummaryScheduleVo batch) throws StaleObjectException
{
    if(batch == null) {
        throw new CodingRuntimeException("dischargeSummaryScheduleVo is null");
    }
    if (!batch.isValidated()) {
        throw new DomainRuntimeException("dischargeSummaryScheduleVo not validated");
    }

    DomainFactory factory = getDomainFactory();
    factory.save(dischargeSummaryScheduleVoAssembler.extractdischargeSummarySchedule(factory,batch));
}

public dischargeSummaryScheduleVo getdischargeSummarySchedule(dischargeSummaryScheduleRefVo voRef)
{
    if(voRef == null)
        throw new CodingRuntimeException("Cannot get dischargeSummaryScheduleVo for null dischargeSummaryScheduleRefVo");

    DomainFactory factory = getDomainFactory();
    dischargeSummarySchedule dodischargeSummarySchedule = (dischargeSummarySchedule) factory.getDomainObject(dischargeSummarySchedule.class,voRef.getID_dischargeSummarySchedule());
    return dischargeSummaryScheduleVoAssembler.create(dodischargeSummarySchedule);
}

public void executeSUPpprintReport(dischargeSummaryScheduleVo job) 
{           
    dischargeReportDetailVoCollection dischargeReportsDetails = getSuppPatientDocuments();
    if (dischargeReportsDetails != null && dischargeReportsDetails.size() > 0)
    {
        try
        {
            saveReports(dischargeReportsDetails,DocumentCategory.disCHARGE_SUPPLEMENTARY);
        }
        catch(Exception e)
        {
            getDomainFactory().close();                 
        }
    }       
}

public void save(dischargeSummaryScheduleVo batch) throws StaleObjectException
{
    if(batch == null) {
        throw new CodingRuntimeException("dischargeSummaryScheduleVo is null");
    }
    if (!batch.isValidated()) {
        throw new DomainRuntimeException("dischargeSummaryScheduleVo not validated");
    }

    DomainFactory factory = getDomainFactory();
    factory.save(dischargeSummaryScheduleVoAssembler.extractdischargeSummarySchedule(factory,batch));
}

public dischargeSummaryScheduleVo getdischargeSummarySchedule(dischargeSummaryScheduleRefVo voRef)
{
    if(voRef == null)
        throw new CodingRuntimeException("Cannot get dischargeSummaryScheduleVo for null dischargeSummaryScheduleRefVo");

    DomainFactory factory = getDomainFactory();
    dischargeSummarySchedule dodischargeSummarySchedule = (dischargeSummarySchedule) factory.getDomainObject(dischargeSummarySchedule.class,voRef.getID_dischargeSummarySchedule());
    return dischargeSummaryScheduleVoAssembler.create(dodischargeSummarySchedule);
}

public void executeDSPrintReport(dischargeSummaryScheduleVo job)
{           
     EdischargeSTHKSummaryVoCollection summaries = getSTHKPatientDocuments();
    if (summaries != null && summaries.size() > 0)
    {
        try 
        {
            saveReports(summaries,DocumentCategory.disCHARGE_SUMMARY);
        }
        catch (Exception e) 
        {
            getDomainFactory().close();
        }
    }       
}

public void executeSUPpprintReport(dischargeSummaryScheduleVo job) 
{           
    EdischargeSTHKSummaryVoCollection summaries = getSTHKSuppPatientDocuments();
    if (summaries != null && summaries.size() > 0)
    {
        try
        {
            saveReports(summaries,DocumentCategory.disCHARGE_SUPPLEMENTARY);
        }
        catch(Exception e)
        {
            getDomainFactory().close();                 
        }
    }       
}

public void save(dischargeSummaryScheduleVo batch) throws StaleObjectException
{
    if(batch == null) {
        throw new CodingRuntimeException("dischargeSummaryScheduleVo is null");
    }
    if (!batch.isValidated()) {
        throw new DomainRuntimeException("dischargeSummaryScheduleVo not validated");
    }

    DomainFactory factory = getDomainFactory();
    factory.save(dischargeSummaryScheduleVoAssembler.extractdischargeSummarySchedule(factory,batch));
}

public dischargeSummaryScheduleVo getdischargeSummarySchedule(dischargeSummaryScheduleRefVo voRef)
{
    if(voRef == null)
        throw new CodingRuntimeException("Cannot get dischargeSummaryScheduleVo for null dischargeSummaryScheduleRefVo");

    DomainFactory factory = getDomainFactory();
    dischargeSummarySchedule dodischargeSummarySchedule = (dischargeSummarySchedule) factory.getDomainObject(dischargeSummarySchedule.class,voRef.getID_dischargeSummarySchedule());
    return dischargeSummaryScheduleVoAssembler.create(dodischargeSummarySchedule);
}

public void executeSUPpprintReport(dischargeSummaryScheduleVo job) 
{           
    EdischargeSTHKSummaryVoCollection summaries = getSTHKSuppPatientDocuments();
    if (summaries != null && summaries.size() > 0)
    {
        try
        {
            saveReports(summaries,DocumentCategory.disCHARGE_SUPPLEMENTARY);
        }
        catch(Exception e)
        {
            getDomainFactory().close();                 
        }
    }       
}

@Override
protected void onFormOpen(Object[] args) throws PresentationLogicException 
{
    if (args.length > 0)
    {
        populateGrid((dischargeSummaryScheduleVo)args[0]);                  
    }       
}

private void populateGrid(dischargeSummaryScheduleVo dischargeSummary)
{
    if (dischargeSummary == null)
        return;

    form.GrdList().getRows().clear();
    FailedEmailsDetailsVoCollection FailedEmails = dischargeSummary.getFailedEmails();

    for (int j = 0 ; FailedEmails != null && j < FailedEmails.size() ; j++)
    {
        FailedEmailsDetailsVo FailedEmail = FailedEmails.get(j);

        GrdListRow row = form.GrdList().getRows().newRow();
        row.setValue(FailedEmail);

        if (FailedEmail.getJobTypeIsNotNull())
            row.setColJobType(FailedEmail.getJobType().getText());          
        if (FailedEmail.getGPNameIsNotNull())
            row.setColGPName(FailedEmail.getGPName());
        if (FailedEmail.getEmailAddressIsNotNull())
            row.setColEmailAddress(FailedEmail.getEmailAddress());
        if (FailedEmail.getPatientNameIsNotNull())
            row.setColPatient(FailedEmail.getPatientName());
        if (FailedEmail.getinitialDateTimeIsNotNull())
            row.setColInitialDateTime(FailedEmail.getinitialDateTime().toString());
        if (FailedEmail.getFailedDateTimeIsNotNull())
            row.setColFailedDateTime(FailedEmail.getFailedDateTime().toString());
        if (FailedEmail.getSuccessfulDateTimeIsNotNull())
            row.setColSuccessfulSent(FailedEmail.getSuccessfulDateTime().toString());
    }
}

public void save(dischargeSummaryScheduleVo batch) throws StaleObjectException
{
    if(batch == null) {
        throw new CodingRuntimeException("dischargeSummaryScheduleVo is null");
    }
    if (!batch.isValidated()) {
        throw new DomainRuntimeException("dischargeSummaryScheduleVo not validated");
    }

    DomainFactory factory = getDomainFactory();
    factory.save(dischargeSummaryScheduleVoAssembler.extractdischargeSummarySchedule(factory,batch));
}

public dischargeSummaryScheduleVo getdischargeSummarySchedule(dischargeSummaryScheduleRefVo voRef)
{
    if(voRef == null)
        throw new CodingRuntimeException("Cannot get dischargeSummaryScheduleVo for null dischargeSummaryScheduleRefVo");

    DomainFactory factory = getDomainFactory();
    dischargeSummarySchedule dodischargeSummarySchedule = (dischargeSummarySchedule) factory.getDomainObject(dischargeSummarySchedule.class,voRef.getID_dischargeSummarySchedule());
    return dischargeSummaryScheduleVoAssembler.create(dodischargeSummarySchedule);
}

public void executeSUPpprintReport(dischargeSummaryScheduleVo job) 
{           
    EdischargeSTHKSummaryVoCollection summaries = getSTHKSuppPatientDocuments();
    if (summaries != null && summaries.size() > 0)
    {
        try
        {
            saveReports(summaries,DocumentCategory.disCHARGE_SUPPLEMENTARY);
        }
        catch(Exception e)
        {
            getDomainFactory().close();                 
        }
    }       
}

private void populateGrid()
{
    form.GrdJob().getRows().clear();

    dischargeSummaryScheduleVoCollection voCol = domain.getJobs();
    dischargeSummaryScheduleVo summaryScheduleVo = null;

    for (int j = 0 ; voCol != null && j < voCol.size() ; j++)
    {
        summaryScheduleVo = voCol.get(j);

        GrdJobrow row = form.GrdJob().getRows().newRow();
        row.setValue(summaryScheduleVo);
        if (summaryScheduleVo.getCreationDateIsNotNull())
            row.setcolCreatedOn(summaryScheduleVo.getCreationDate());
        if (summaryScheduleVo.getTriggerFrequencyIsNotNull())
            row.setcolFrequency(summaryScheduleVo.getTriggerFrequency());
        if (summaryScheduleVo.getLastRunIsNotNull())
            row.setcolLastRun(summaryScheduleVo.getLastRun().toString());
        if (summaryScheduleVo.getNextRunIsNotNull())
            row.setcolNextRun(summaryScheduleVo.getNextRun().toString());
        if (summaryScheduleVo.getPrintedLettersNoIsNotNull())
            row.setcolNumberLettersPrinted(summaryScheduleVo.getPrintedLettersNo());                
        if (summaryScheduleVo.getGeneratedLeettersNoIsNotNull())
            row.setcolNumberLettersGenerated(summaryScheduleVo.getGeneratedLeettersNo());
        if (summaryScheduleVo.getSuccessfulEmailsNoIsNotNull())
            row.setcolSuccessfulSentEmail(summaryScheduleVo.getSuccessfulEmailsNo());
        if (summaryScheduleVo.getFailedEmailsNoIsNotNull())         
            row.setcolFailedSentEmail(summaryScheduleVo.getFailedEmailsNo());           
        row.setcolJob("Print Report");
        row.setValue(summaryScheduleVo);

        if (summaryScheduleVo.getJobTypeIsNotNull())
        {
            row.setcolType(summaryScheduleVo.getJobType().toString());              
            form.cmbJobType().removeRow(summaryScheduleVo.getJobType());
        }
    }

    updateControlState();
}

private void populateGrid()
{
    form.GrdJob().getRows().clear();

    dischargeSummaryScheduleVoCollection voCol = domain.getJobs();
    dischargeSummaryScheduleVo summaryScheduleVo = null;

    for (int j = 0 ; voCol != null && j < voCol.size() ; j++)
    {
        summaryScheduleVo = voCol.get(j);

        GrdJobrow row = form.GrdJob().getRows().newRow();
        row.setValue(summaryScheduleVo);
        if (summaryScheduleVo.getCreationDateIsNotNull())
            row.setcolCreatedOn(summaryScheduleVo.getCreationDate());
        if (summaryScheduleVo.getTriggerFrequencyIsNotNull())
            row.setcolFrequency(summaryScheduleVo.getTriggerFrequency());
        if (summaryScheduleVo.getLastRunIsNotNull())
            row.setcolLastRun(summaryScheduleVo.getLastRun().toString());
        if (summaryScheduleVo.getNextRunIsNotNull())
            row.setcolNextRun(summaryScheduleVo.getNextRun().toString());
        if (summaryScheduleVo.getPrintedLettersNoIsNotNull())
            row.setcolNumberLettersPrinted(summaryScheduleVo.getPrintedLettersNo());                
        if (summaryScheduleVo.getGeneratedLeettersNoIsNotNull())
            row.setcolNumberLettersGenerated(summaryScheduleVo.getGeneratedLeettersNo());
        if (summaryScheduleVo.getSuccessfulEmailsNoIsNotNull())
            row.setcolSuccessfulSentEmail(summaryScheduleVo.getSuccessfulEmailsNo());
        if (summaryScheduleVo.getFailedEmailsNoIsNotNull())         
            row.setcolFailedSentEmail(summaryScheduleVo.getFailedEmailsNo());
        if (summaryScheduleVo.getSealedEnvelopePatientsNo() != null)
            row.setcolSealedEnvelops(summaryScheduleVo.getSealedEnvelopePatientsNo());
        row.setcolJob("Print Report");
        row.setValue(summaryScheduleVo);

        if (summaryScheduleVo.getJobTypeIsNotNull())
        {
            row.setcolType(summaryScheduleVo.getJobType().toString());              
            form.cmbJobType().removeRow(summaryScheduleVo.getJobType());
        }
    }

    updateControlState();
}

public CSPrimaryDiagnosisAndPoceduresVo listPrimaryDiagnosisAndProblems(CareSpellRefVo careSpellRefVo)
{
    if (careSpellRefVo == null)
        throw new CodingRuntimeException("Cannot list Primary Diagnosis/Problems for null CareSpellRefVo");

    DomainFactory factory = getDomainFactory();

    StringBuffer diagnosisQuery = new StringBuffer();
    diagnosisQuery.append("select c1_1.diagnosis.id,c1_1.diagnosis.diagnosisDescription");
    diagnosisQuery.append(" from CsPrimaryDiagnosis as c1_1");
    diagnosisQuery.append(" where ");
    diagnosisQuery.append(" (c1_1.isActive = :ACTIVE and c1_1.episodeOfCare.careSpell.id = :CARESPELL_ID)");
    diagnosisQuery.append(" and c1_1.isRIE is null and c1_1.diagnosis.isRIE is null");

    StringBuffer problemsQuery = new StringBuffer();
    problemsQuery.append("select  c1_1.patientProblem.id,c1_1.patientProblem.patientProblem");
    problemsQuery.append(" from CsPrimaryProblem as c1_1");
    problemsQuery.append(" where");
    problemsQuery.append(" (c1_1.isActive = :ACTIVE and c1_1.careContext.episodeOfCare.careSpell.id = :CARESPELL_ID)");
    problemsQuery.append(" and c1_1.isRIE is null and c1_1.patientProblem.isRIE is null");

    ArrayList params = new ArrayList();
    params.add("ACTIVE");
    params.add("CARESPELL_ID");

    ArrayList values = new ArrayList();
    values.add(Boolean.TRUE);
    values.add(careSpellRefVo.getID_CareSpell());

    List diagnosisList = factory.find(diagnosisQuery.toString(),params,values);
    List problemsList = factory.find(problemsQuery.toString(),values);

    CSPrimaryDiagnosisAndPoceduresVo voPrimary = new CSPrimaryDiagnosisAndPoceduresVo();
    voPrimary.setPrimaryDiagnosis(new CSPatientSummaryDiagnosisVoCollection());
    voPrimary.setPrimaryProcedures(new CSPatientSummaryProcedureVoCollection());

    for (int i = 0; diagnosisList != null && i < diagnosisList.size(); i++)
    {
        Object[] diagObjects = (Object[]) diagnosisList.get(i);
        if (diagObjects != null)
        {
            CSPatientSummaryDiagnosisVo voCSPatientSummaryDiagnosis = new CSPatientSummaryDiagnosisVo();
            if (diagObjects[0] instanceof Integer)
            {
                voCSPatientSummaryDiagnosis.setID_CSPatientSummaryDiagnosis((Integer) diagObjects[0]);
            }

            if (diagObjects[1] instanceof String)
            {
                voCSPatientSummaryDiagnosis.setDiagnosisName((String) diagObjects[1]);
            }
            voPrimary.getPrimaryDiagnosis().add(voCSPatientSummaryDiagnosis);
        }
    }

    for (int i = 0; i < problemsList.size(); i++)
    {
        Object[] procObjects = (Object[]) problemsList.get(i);
        if (procObjects != null)
        {
            CSPatientSummaryProcedureVo voCSPatientSummaryProcedure = new CSPatientSummaryProcedureVo();
            if (procObjects[0] instanceof Integer)
            {
                voCSPatientSummaryProcedure.setID_CSPatientSummaryProcedure((Integer) procObjects[0]);
            }

            if (procObjects[1] instanceof String)
            {
                voCSPatientSummaryProcedure.setProcedureName((String) procObjects[1]);
            }
            voPrimary.getPrimaryProcedures().add(voCSPatientSummaryProcedure);
        }
    }

    return voPrimary;
}

public CSPrimaryDiagnosisAndPoceduresVo listPrimaryDiagnosisAndProblems(CareSpellRefVo careSpellRefVo)
{
    if(careSpellRefVo == null)
        throw new CodingRuntimeException("Cannot list Primary Diagnosis/Problems for null CareSpellRefVo");

    DomainFactory factory = getDomainFactory();

    StringBuffer diagnosisQuery = new StringBuffer();
    diagnosisQuery.append("select c1_1.diagnosis.id,values);

    CSPrimaryDiagnosisAndPoceduresVo voPrimary = new CSPrimaryDiagnosisAndPoceduresVo();
    voPrimary.setPrimaryDiagnosis(new CSPatientSummaryDiagnosisVoCollection());
    voPrimary.setPrimaryProcedures(new CSPatientSummaryProcedureVoCollection());

    for (int i = 0; diagnosisList != null && i < diagnosisList.size(); i++)
    {
        Object[] diagObjects = (Object[]) diagnosisList.get(i);
        if(diagObjects != null)
        {
            CSPatientSummaryDiagnosisVo voCSPatientSummaryDiagnosis = new CSPatientSummaryDiagnosisVo();
            if(diagObjects[0] instanceof Integer)
            {
                voCSPatientSummaryDiagnosis.setID_CSPatientSummaryDiagnosis((Integer)diagObjects[0]);
            }

            if(diagObjects[1] instanceof String)
            {
                voCSPatientSummaryDiagnosis.setDiagnosisName((String)diagObjects[1]);
            }
            voPrimary.getPrimaryDiagnosis().add(voCSPatientSummaryDiagnosis);
        }
    }

    for (int i = 0; i < problemsList.size(); i++)
    {
        Object[] procObjects = (Object[]) problemsList.get(i);
        if(procObjects != null)
        {
            CSPatientSummaryProcedureVo voCSPatientSummaryProcedure = new CSPatientSummaryProcedureVo();
            if(procObjects[0] instanceof Integer)
            {
                voCSPatientSummaryProcedure.setID_CSPatientSummaryProcedure((Integer)procObjects[0]);
            }

            if(procObjects[1] instanceof String)
            {
                voCSPatientSummaryProcedure.setProcedureName((String)procObjects[1]);
            }
            voPrimary.getPrimaryProcedures().add(voCSPatientSummaryProcedure);
        }
    }

    return voPrimary;
}

public CSPrimaryDiagnosisAndPoceduresVo listPrimaryDiagnosisAndProblems(CareSpellRefVo careSpellRefVo)
{
    if (careSpellRefVo == null)
        throw new CodingRuntimeException("Cannot list Primary Diagnosis/Problems for null CareSpellRefVo");

    DomainFactory factory = getDomainFactory();

    StringBuffer diagnosisQuery = new StringBuffer();
    diagnosisQuery.append("select c1_1.diagnosis.id,values);

    CSPrimaryDiagnosisAndPoceduresVo voPrimary = new CSPrimaryDiagnosisAndPoceduresVo();
    voPrimary.setPrimaryDiagnosis(new CSPatientSummaryDiagnosisVoCollection());
    voPrimary.setPrimaryProcedures(new CSPatientSummaryProcedureVoCollection());

    for (int i = 0; diagnosisList != null && i < diagnosisList.size(); i++)
    {
        Object[] diagObjects = (Object[]) diagnosisList.get(i);
        if (diagObjects != null)
        {
            CSPatientSummaryDiagnosisVo voCSPatientSummaryDiagnosis = new CSPatientSummaryDiagnosisVo();
            if (diagObjects[0] instanceof Integer)
            {
                voCSPatientSummaryDiagnosis.setID_CSPatientSummaryDiagnosis((Integer) diagObjects[0]);
            }

            if (diagObjects[1] instanceof String)
            {
                voCSPatientSummaryDiagnosis.setDiagnosisName((String) diagObjects[1]);
            }
            voPrimary.getPrimaryDiagnosis().add(voCSPatientSummaryDiagnosis);
        }
    }

    for (int i = 0; i < problemsList.size(); i++)
    {
        Object[] procObjects = (Object[]) problemsList.get(i);
        if (procObjects != null)
        {
            CSPatientSummaryProcedureVo voCSPatientSummaryProcedure = new CSPatientSummaryProcedureVo();
            if (procObjects[0] instanceof Integer)
            {
                voCSPatientSummaryProcedure.setID_CSPatientSummaryProcedure((Integer) procObjects[0]);
            }

            if (procObjects[1] instanceof String)
            {
                voCSPatientSummaryProcedure.setProcedureName((String) procObjects[1]);
            }
            voPrimary.getPrimaryProcedures().add(voCSPatientSummaryProcedure);
        }
    }

    return voPrimary;
}

public CSPrimaryDiagnosisAndPoceduresVo listPrimaryDiagnosisAndProblems(CareSpellRefVo careSpellRefVo)
{
    if(careSpellRefVo == null)
        throw new CodingRuntimeException("Cannot list Primary Diagnosis/Problems for null CareSpellRefVo");

    DomainFactory factory = getDomainFactory();

    StringBuffer diagnosisQuery = new StringBuffer();
    diagnosisQuery.append("select c1_1.diagnosis.id,values);

    CSPrimaryDiagnosisAndPoceduresVo voPrimary = new CSPrimaryDiagnosisAndPoceduresVo();
    voPrimary.setPrimaryDiagnosis(new CSPatientSummaryDiagnosisVoCollection());
    voPrimary.setPrimaryProcedures(new CSPatientSummaryProcedureVoCollection());

    for (int i = 0; diagnosisList != null && i < diagnosisList.size(); i++)
    {
        Object[] diagObjects = (Object[]) diagnosisList.get(i);
        if(diagObjects != null)
        {
            CSPatientSummaryDiagnosisVo voCSPatientSummaryDiagnosis = new CSPatientSummaryDiagnosisVo();
            if(diagObjects[0] instanceof Integer)
            {
                voCSPatientSummaryDiagnosis.setID_CSPatientSummaryDiagnosis((Integer)diagObjects[0]);
            }

            if(diagObjects[1] instanceof String)
            {
                voCSPatientSummaryDiagnosis.setDiagnosisName((String)diagObjects[1]);
            }
            voPrimary.getPrimaryDiagnosis().add(voCSPatientSummaryDiagnosis);
        }
    }

    for (int i = 0; i < problemsList.size(); i++)
    {
        Object[] procObjects = (Object[]) problemsList.get(i);
        if(procObjects != null)
        {
            CSPatientSummaryProcedureVo voCSPatientSummaryProcedure = new CSPatientSummaryProcedureVo();
            if(procObjects[0] instanceof Integer)
            {
                voCSPatientSummaryProcedure.setID_CSPatientSummaryProcedure((Integer)procObjects[0]);
            }

            if(procObjects[1] instanceof String)
            {
                voCSPatientSummaryProcedure.setProcedureName((String)procObjects[1]);
            }
            voPrimary.getPrimaryProcedures().add(voCSPatientSummaryProcedure);
        }
    }

    return voPrimary;
}

public CSPrimaryDiagnosisAndPoceduresVo listPrimaryDiagnosisAndProblems(CareSpellRefVo careSpellRefVo)
{
    if (careSpellRefVo == null)
        throw new CodingRuntimeException("Cannot list Primary Diagnosis/Problems for null CareSpellRefVo");

    DomainFactory factory = getDomainFactory();

    StringBuffer diagnosisQuery = new StringBuffer();
    diagnosisQuery.append("select c1_1.diagnosis.id,values);

    CSPrimaryDiagnosisAndPoceduresVo voPrimary = new CSPrimaryDiagnosisAndPoceduresVo();
    voPrimary.setPrimaryDiagnosis(new CSPatientSummaryDiagnosisVoCollection());
    voPrimary.setPrimaryProcedures(new CSPatientSummaryProcedureVoCollection());

    for (int i = 0; diagnosisList != null && i < diagnosisList.size(); i++)
    {
        Object[] diagObjects = (Object[]) diagnosisList.get(i);
        if (diagObjects != null)
        {
            CSPatientSummaryDiagnosisVo voCSPatientSummaryDiagnosis = new CSPatientSummaryDiagnosisVo();
            if (diagObjects[0] instanceof Integer)
            {
                voCSPatientSummaryDiagnosis.setID_CSPatientSummaryDiagnosis((Integer) diagObjects[0]);
            }

            if (diagObjects[1] instanceof String)
            {
                voCSPatientSummaryDiagnosis.setDiagnosisName((String) diagObjects[1]);
            }
            voPrimary.getPrimaryDiagnosis().add(voCSPatientSummaryDiagnosis);
        }
    }

    for (int i = 0; i < problemsList.size(); i++)
    {
        Object[] procObjects = (Object[]) problemsList.get(i);
        if (procObjects != null)
        {
            CSPatientSummaryProcedureVo voCSPatientSummaryProcedure = new CSPatientSummaryProcedureVo();
            if (procObjects[0] instanceof Integer)
            {
                voCSPatientSummaryProcedure.setID_CSPatientSummaryProcedure((Integer) procObjects[0]);
            }

            if (procObjects[1] instanceof String)
            {
                voCSPatientSummaryProcedure.setProcedureName((String) procObjects[1]);
            }
            voPrimary.getPrimaryProcedures().add(voCSPatientSummaryProcedure);
        }
    }

    return voPrimary;
}

public CSPrimaryDiagnosisAndPoceduresVo listPrimaryDiagnosisAndProblems(CareSpellRefVo careSpellRefVo)
{
    if(careSpellRefVo == null)
        throw new CodingRuntimeException("Cannot list Primary Diagnosis/Problems for null CareSpellRefVo");

    DomainFactory factory = getDomainFactory();

    StringBuffer diagnosisQuery = new StringBuffer();
    diagnosisQuery.append("select c1_1.diagnosis.id,values);

    CSPrimaryDiagnosisAndPoceduresVo voPrimary = new CSPrimaryDiagnosisAndPoceduresVo();
    voPrimary.setPrimaryDiagnosis(new CSPatientSummaryDiagnosisVoCollection());
    voPrimary.setPrimaryProcedures(new CSPatientSummaryProcedureVoCollection());

    for (int i = 0; diagnosisList != null && i < diagnosisList.size(); i++)
    {
        Object[] diagObjects = (Object[]) diagnosisList.get(i);
        if(diagObjects != null)
        {
            CSPatientSummaryDiagnosisVo voCSPatientSummaryDiagnosis = new CSPatientSummaryDiagnosisVo();
            if(diagObjects[0] instanceof Integer)
            {
                voCSPatientSummaryDiagnosis.setID_CSPatientSummaryDiagnosis((Integer)diagObjects[0]);
            }

            if(diagObjects[1] instanceof String)
            {
                voCSPatientSummaryDiagnosis.setDiagnosisName((String)diagObjects[1]);
            }
            voPrimary.getPrimaryDiagnosis().add(voCSPatientSummaryDiagnosis);
        }
    }

    for (int i = 0; i < problemsList.size(); i++)
    {
        Object[] procObjects = (Object[]) problemsList.get(i);
        if(procObjects != null)
        {
            CSPatientSummaryProcedureVo voCSPatientSummaryProcedure = new CSPatientSummaryProcedureVo();
            if(procObjects[0] instanceof Integer)
            {
                voCSPatientSummaryProcedure.setID_CSPatientSummaryProcedure((Integer)procObjects[0]);
            }

            if(procObjects[1] instanceof String)
            {
                voCSPatientSummaryProcedure.setProcedureName((String)procObjects[1]);
            }
            voPrimary.getPrimaryProcedures().add(voCSPatientSummaryProcedure);
        }
    }

    return voPrimary;
}

public CSPrimaryDiagnosisAndPoceduresVo listPrimaryDiagnosisAndProblems(CareSpellRefVo careSpellRefVo)
{
    if (careSpellRefVo == null)
        throw new CodingRuntimeException("Cannot list Primary Diagnosis/Problems for null CareSpellRefVo");

    DomainFactory factory = getDomainFactory();

    StringBuffer diagnosisQuery = new StringBuffer();
    diagnosisQuery.append("select c1_1.diagnosis.id,c1_1.diagnosis.diagnosisDescription");
    diagnosisQuery.append(" from CsPrimaryDiagnosis as c1_1");
    diagnosisQuery.append(" where ");
    diagnosisQuery.append(" (c1_1.isActive = :ACTIVE and c1_1.episodeOfCare.careSpell.id = :CARESPELL_ID)");
    diagnosisQuery.append(" and c1_1.isRIE is null and c1_1.diagnosis.isRIE is null");

    StringBuffer problemsQuery = new StringBuffer();
    problemsQuery.append("select  c1_1.patientProblem.id,c1_1.patientProblem.patientProblem");
    problemsQuery.append(" from CsPrimaryProblem as c1_1");
    problemsQuery.append(" where");
    problemsQuery.append(" (c1_1.isActive = :ACTIVE and c1_1.careContext.episodeOfCare.careSpell.id = :CARESPELL_ID)");
    problemsQuery.append(" and c1_1.isRIE is null and c1_1.patientProblem.isRIE is null");

    ArrayList params = new ArrayList();
    params.add("ACTIVE");
    params.add("CARESPELL_ID");

    ArrayList values = new ArrayList();
    values.add(Boolean.TRUE);
    values.add(careSpellRefVo.getID_CareSpell());

    List diagnosisList = factory.find(diagnosisQuery.toString(),params,values);
    List problemsList = factory.find(problemsQuery.toString(),values);

    CSPrimaryDiagnosisAndPoceduresVo voPrimary = new CSPrimaryDiagnosisAndPoceduresVo();
    voPrimary.setPrimaryDiagnosis(new CSPatientSummaryDiagnosisVoCollection());
    voPrimary.setPrimaryProcedures(new CSPatientSummaryProcedureVoCollection());

    for (int i = 0; diagnosisList != null && i < diagnosisList.size(); i++)
    {
        Object[] diagObjects = (Object[]) diagnosisList.get(i);
        if (diagObjects != null)
        {
            CSPatientSummaryDiagnosisVo voCSPatientSummaryDiagnosis = new CSPatientSummaryDiagnosisVo();
            if (diagObjects[0] instanceof Integer)
            {
                voCSPatientSummaryDiagnosis.setID_CSPatientSummaryDiagnosis((Integer) diagObjects[0]);
            }

            if (diagObjects[1] instanceof String)
            {
                voCSPatientSummaryDiagnosis.setDiagnosisName((String) diagObjects[1]);
            }
            voPrimary.getPrimaryDiagnosis().add(voCSPatientSummaryDiagnosis);
        }
    }

    for (int i = 0; i < problemsList.size(); i++)
    {
        Object[] procObjects = (Object[]) problemsList.get(i);
        if (procObjects != null)
        {
            CSPatientSummaryProcedureVo voCSPatientSummaryProcedure = new CSPatientSummaryProcedureVo();
            if (procObjects[0] instanceof Integer)
            {
                voCSPatientSummaryProcedure.setID_CSPatientSummaryProcedure((Integer) procObjects[0]);
            }

            if (procObjects[1] instanceof String)
            {
                voCSPatientSummaryProcedure.setProcedureName((String) procObjects[1]);
            }
            voPrimary.getPrimaryProcedures().add(voCSPatientSummaryProcedure);
        }
    }

    return voPrimary;
}

public CSPrimaryDiagnosisAndPoceduresVo listPrimaryDiagnosisAndProblems(CareSpellRefVo careSpellRefVo)
{
    if(careSpellRefVo == null)
        throw new CodingRuntimeException("Cannot list Primary Diagnosis/Problems for null CareSpellRefVo");

    DomainFactory factory = getDomainFactory();

    StringBuffer diagnosisQuery = new StringBuffer();
    diagnosisQuery.append("select c1_1.diagnosis.id,values);

    CSPrimaryDiagnosisAndPoceduresVo voPrimary = new CSPrimaryDiagnosisAndPoceduresVo();
    voPrimary.setPrimaryDiagnosis(new CSPatientSummaryDiagnosisVoCollection());
    voPrimary.setPrimaryProcedures(new CSPatientSummaryProcedureVoCollection());

    for (int i = 0; diagnosisList != null && i < diagnosisList.size(); i++)
    {
        Object[] diagObjects = (Object[]) diagnosisList.get(i);
        if(diagObjects != null)
        {
            CSPatientSummaryDiagnosisVo voCSPatientSummaryDiagnosis = new CSPatientSummaryDiagnosisVo();
            if(diagObjects[0] instanceof Integer)
            {
                voCSPatientSummaryDiagnosis.setID_CSPatientSummaryDiagnosis((Integer)diagObjects[0]);
            }

            if(diagObjects[1] instanceof String)
            {
                voCSPatientSummaryDiagnosis.setDiagnosisName((String)diagObjects[1]);
            }
            voPrimary.getPrimaryDiagnosis().add(voCSPatientSummaryDiagnosis);
        }
    }

    for (int i = 0; i < problemsList.size(); i++)
    {
        Object[] procObjects = (Object[]) problemsList.get(i);
        if(procObjects != null)
        {
            CSPatientSummaryProcedureVo voCSPatientSummaryProcedure = new CSPatientSummaryProcedureVo();
            if(procObjects[0] instanceof Integer)
            {
                voCSPatientSummaryProcedure.setID_CSPatientSummaryProcedure((Integer)procObjects[0]);
            }

            if(procObjects[1] instanceof String)
            {
                voCSPatientSummaryProcedure.setProcedureName((String)procObjects[1]);
            }
            voPrimary.getPrimaryProcedures().add(voCSPatientSummaryProcedure);
        }
    }

    return voPrimary;
}

public CSPrimaryDiagnosisAndPoceduresVo listPrimaryDiagnosisAndProblems(CareSpellRefVo careSpellRefVo)
{
    if (careSpellRefVo == null)
        throw new CodingRuntimeException("Cannot list Primary Diagnosis/Problems for null CareSpellRefVo");

    DomainFactory factory = getDomainFactory();

    StringBuffer diagnosisQuery = new StringBuffer();
    diagnosisQuery.append("select c1_1.diagnosis.id,values);

    CSPrimaryDiagnosisAndPoceduresVo voPrimary = new CSPrimaryDiagnosisAndPoceduresVo();
    voPrimary.setPrimaryDiagnosis(new CSPatientSummaryDiagnosisVoCollection());
    voPrimary.setPrimaryProcedures(new CSPatientSummaryProcedureVoCollection());

    for (int i = 0; diagnosisList != null && i < diagnosisList.size(); i++)
    {
        Object[] diagObjects = (Object[]) diagnosisList.get(i);
        if (diagObjects != null)
        {
            CSPatientSummaryDiagnosisVo voCSPatientSummaryDiagnosis = new CSPatientSummaryDiagnosisVo();
            if (diagObjects[0] instanceof Integer)
            {
                voCSPatientSummaryDiagnosis.setID_CSPatientSummaryDiagnosis((Integer) diagObjects[0]);
            }

            if (diagObjects[1] instanceof String)
            {
                voCSPatientSummaryDiagnosis.setDiagnosisName((String) diagObjects[1]);
            }
            voPrimary.getPrimaryDiagnosis().add(voCSPatientSummaryDiagnosis);
        }
    }

    for (int i = 0; i < problemsList.size(); i++)
    {
        Object[] procObjects = (Object[]) problemsList.get(i);
        if (procObjects != null)
        {
            CSPatientSummaryProcedureVo voCSPatientSummaryProcedure = new CSPatientSummaryProcedureVo();
            if (procObjects[0] instanceof Integer)
            {
                voCSPatientSummaryProcedure.setID_CSPatientSummaryProcedure((Integer) procObjects[0]);
            }

            if (procObjects[1] instanceof String)
            {
                voCSPatientSummaryProcedure.setProcedureName((String) procObjects[1]);
            }
            voPrimary.getPrimaryProcedures().add(voCSPatientSummaryProcedure);
        }
    }

    return voPrimary;
}

public CSPrimaryDiagnosisAndPoceduresVo listPrimaryDiagnosisAndProblems(CareSpellRefVo careSpellRefVo)
{
    if(careSpellRefVo == null)
        throw new CodingRuntimeException("Cannot list Primary Diagnosis/Problems for null CareSpellRefVo");

    DomainFactory factory = getDomainFactory();

    StringBuffer diagnosisQuery = new StringBuffer();
    diagnosisQuery.append("select c1_1.diagnosis.id,values);

    CSPrimaryDiagnosisAndPoceduresVo voPrimary = new CSPrimaryDiagnosisAndPoceduresVo();
    voPrimary.setPrimaryDiagnosis(new CSPatientSummaryDiagnosisVoCollection());
    voPrimary.setPrimaryProcedures(new CSPatientSummaryProcedureVoCollection());

    for (int i = 0; diagnosisList != null && i < diagnosisList.size(); i++)
    {
        Object[] diagObjects = (Object[]) diagnosisList.get(i);
        if(diagObjects != null)
        {
            CSPatientSummaryDiagnosisVo voCSPatientSummaryDiagnosis = new CSPatientSummaryDiagnosisVo();
            if(diagObjects[0] instanceof Integer)
            {
                voCSPatientSummaryDiagnosis.setID_CSPatientSummaryDiagnosis((Integer)diagObjects[0]);
            }

            if(diagObjects[1] instanceof String)
            {
                voCSPatientSummaryDiagnosis.setDiagnosisName((String)diagObjects[1]);
            }
            voPrimary.getPrimaryDiagnosis().add(voCSPatientSummaryDiagnosis);
        }
    }

    for (int i = 0; i < problemsList.size(); i++)
    {
        Object[] procObjects = (Object[]) problemsList.get(i);
        if(procObjects != null)
        {
            CSPatientSummaryProcedureVo voCSPatientSummaryProcedure = new CSPatientSummaryProcedureVo();
            if(procObjects[0] instanceof Integer)
            {
                voCSPatientSummaryProcedure.setID_CSPatientSummaryProcedure((Integer)procObjects[0]);
            }

            if(procObjects[1] instanceof String)
            {
                voCSPatientSummaryProcedure.setProcedureName((String)procObjects[1]);
            }
            voPrimary.getPrimaryProcedures().add(voCSPatientSummaryProcedure);
        }
    }

    return voPrimary;
}

public CSPrimaryDiagnosisAndPoceduresVo listPrimaryDiagnosisAndProblems(CareSpellRefVo careSpellRefVo)
{
    if (careSpellRefVo == null)
        throw new CodingRuntimeException("Cannot list Primary Diagnosis/Problems for null CareSpellRefVo");

    DomainFactory factory = getDomainFactory();

    StringBuffer diagnosisQuery = new StringBuffer();
    diagnosisQuery.append("select c1_1.diagnosis.id,values);

    CSPrimaryDiagnosisAndPoceduresVo voPrimary = new CSPrimaryDiagnosisAndPoceduresVo();
    voPrimary.setPrimaryDiagnosis(new CSPatientSummaryDiagnosisVoCollection());
    voPrimary.setPrimaryProcedures(new CSPatientSummaryProcedureVoCollection());

    for (int i = 0; diagnosisList != null && i < diagnosisList.size(); i++)
    {
        Object[] diagObjects = (Object[]) diagnosisList.get(i);
        if (diagObjects != null)
        {
            CSPatientSummaryDiagnosisVo voCSPatientSummaryDiagnosis = new CSPatientSummaryDiagnosisVo();
            if (diagObjects[0] instanceof Integer)
            {
                voCSPatientSummaryDiagnosis.setID_CSPatientSummaryDiagnosis((Integer) diagObjects[0]);
            }

            if (diagObjects[1] instanceof String)
            {
                voCSPatientSummaryDiagnosis.setDiagnosisName((String) diagObjects[1]);
            }
            voPrimary.getPrimaryDiagnosis().add(voCSPatientSummaryDiagnosis);
        }
    }

    for (int i = 0; i < problemsList.size(); i++)
    {
        Object[] procObjects = (Object[]) problemsList.get(i);
        if (procObjects != null)
        {
            CSPatientSummaryProcedureVo voCSPatientSummaryProcedure = new CSPatientSummaryProcedureVo();
            if (procObjects[0] instanceof Integer)
            {
                voCSPatientSummaryProcedure.setID_CSPatientSummaryProcedure((Integer) procObjects[0]);
            }

            if (procObjects[1] instanceof String)
            {
                voCSPatientSummaryProcedure.setProcedureName((String) procObjects[1]);
            }
            voPrimary.getPrimaryProcedures().add(voCSPatientSummaryProcedure);
        }
    }

    return voPrimary;
}

public CSPrimaryDiagnosisAndPoceduresVo listPrimaryDiagnosisAndProblems(CareSpellRefVo careSpellRefVo)
{
    if(careSpellRefVo == null)
        throw new CodingRuntimeException("Cannot list Primary Diagnosis/Problems for null CareSpellRefVo");

    DomainFactory factory = getDomainFactory();

    StringBuffer diagnosisQuery = new StringBuffer();
    diagnosisQuery.append("select c1_1.diagnosis.id,values);

    CSPrimaryDiagnosisAndPoceduresVo voPrimary = new CSPrimaryDiagnosisAndPoceduresVo();
    voPrimary.setPrimaryDiagnosis(new CSPatientSummaryDiagnosisVoCollection());
    voPrimary.setPrimaryProcedures(new CSPatientSummaryProcedureVoCollection());

    for (int i = 0; diagnosisList != null && i < diagnosisList.size(); i++)
    {
        Object[] diagObjects = (Object[]) diagnosisList.get(i);
        if(diagObjects != null)
        {
            CSPatientSummaryDiagnosisVo voCSPatientSummaryDiagnosis = new CSPatientSummaryDiagnosisVo();
            if(diagObjects[0] instanceof Integer)
            {
                voCSPatientSummaryDiagnosis.setID_CSPatientSummaryDiagnosis((Integer)diagObjects[0]);
            }

            if(diagObjects[1] instanceof String)
            {
                voCSPatientSummaryDiagnosis.setDiagnosisName((String)diagObjects[1]);
            }
            voPrimary.getPrimaryDiagnosis().add(voCSPatientSummaryDiagnosis);
        }
    }

    for (int i = 0; i < problemsList.size(); i++)
    {
        Object[] procObjects = (Object[]) problemsList.get(i);
        if(procObjects != null)
        {
            CSPatientSummaryProcedureVo voCSPatientSummaryProcedure = new CSPatientSummaryProcedureVo();
            if(procObjects[0] instanceof Integer)
            {
                voCSPatientSummaryProcedure.setID_CSPatientSummaryProcedure((Integer)procObjects[0]);
            }

            if(procObjects[1] instanceof String)
            {
                voCSPatientSummaryProcedure.setProcedureName((String)procObjects[1]);
            }
            voPrimary.getPrimaryProcedures().add(voCSPatientSummaryProcedure);
        }
    }

    return voPrimary;
}

public DementiaEdischargeCheckVo getDementiaStatus(PASEventRefVo voPasEventRef)
{
    if (voPasEventRef == null)
        throw new CodingRuntimeException("No pasEvent specified for getDementiaStatus");

    DomainFactory factory = getDomainFactory();

    StringBuffer hqlConditions = new StringBuffer();

    String hql = "select d1_1 from Dementia as d1_1 left join d1_1.admissionDetail as a1_1 where"; 

    ArrayList<String> markers = new ArrayList<String>();
    ArrayList<Object> values = new ArrayList<Object>();

    hqlConditions.append(" (d1_1.isRIE is null OR d1_1.isRIE = 0) and a1_1.pasEvent.id = :pe"); //WDEV-17656
    markers.add("pe");
    values.add(voPasEventRef.getID_PASEvent());

    hqlConditions.append(" and (d1_1.isExcludedFromWorklist is null or d1_1.isExcludedFromWorklist = :exc)");
    markers.add("exc");
    values.add(Boolean.FALSE);

    List<?> list = factory.find((hql + hqlConditions.toString() + " ").toString(),markers,values);

    if (list == null || list.size() == 0)
        return null;

    return DementiaEdischargeCheckVoAssembler.createDementiaEdischargeCheckVoCollectionFromDementia(list).get(0);
}

public DementiaEdischargeCheckVo getDementiaStatus(PASEventRefVo voPasEventRef)
{
    if (voPasEventRef == null)
        throw new CodingRuntimeException("No pasEvent specified for getDementiaStatus");

    DomainFactory factory = getDomainFactory();

    StringBuffer hqlConditions = new StringBuffer();

    String hql = "select d1_1 from Dementia as d1_1 left join d1_1.admissionDetail as a1_1 where"; 

    ArrayList<String> markers = new ArrayList<String>();
    ArrayList<Object> values = new ArrayList<Object>();

    hqlConditions.append(" (d1_1.isRIE is null OR d1_1.isRIE = 0) and a1_1.pasEvent.id = :pe"); //WDEV-17656
    markers.add("pe");
    values.add(voPasEventRef.getID_PASEvent());

    hqlConditions.append(" and (d1_1.isExcludedFromWorklist is null or d1_1.isExcludedFromWorklist = :exc)");
    markers.add("exc");
    values.add(Boolean.FALSE);

    List<?> list = factory.find((hql + hqlConditions.toString() + " ").toString(),values);

    if (list == null || list.size() == 0)
        return null;

    return DementiaEdischargeCheckVoAssembler.createDementiaEdischargeCheckVoCollectionFromDementia(list).get(0);
}

public DementiaEdischargeCheckVo getDementiaStatus(PASEventRefVo voPasEventRef)
{
    if (voPasEventRef == null)
        throw new CodingRuntimeException("No pasEvent specified for getDementiaStatus");

    DomainFactory factory = getDomainFactory();

    StringBuffer hqlConditions = new StringBuffer();

    String hql = "select d1_1 from Dementia as d1_1 left join d1_1.admissionDetail as a1_1 where"; 

    ArrayList<String> markers = new ArrayList<String>();
    ArrayList<Object> values = new ArrayList<Object>();

    hqlConditions.append(" (d1_1.isRIE is null OR d1_1.isRIE = 0) and a1_1.pasEvent.id = :pe"); //WDEV-17656
    markers.add("pe");
    values.add(voPasEventRef.getID_PASEvent());

    hqlConditions.append(" and (d1_1.isExcludedFromWorklist is null or d1_1.isExcludedFromWorklist = :exc)");
    markers.add("exc");
    values.add(Boolean.FALSE);

    List<?> list = factory.find((hql + hqlConditions.toString() + " ").toString(),values);

    if (list == null || list.size() == 0)
        return null;

    return DementiaEdischargeCheckVoAssembler.createDementiaEdischargeCheckVoCollectionFromDementia(list).get(0);
}

private void search() 
{
    clearResults();

    EdischargeSearchCriteriaVo voCriteria = populateSearchCriteria();

    dischargeDetailsVoCollection dischargeDetails = domain.searchByCriteria(voCriteria);

    //start WDEV-14703
    if (dischargeDetails == null || dischargeDetails.size() == 0)
    {
        engine.showMessage("No matching discharged patients found.");
        return;
    }
    //end

    populatedischargesGrid(dischargeDetails);

    if (voCriteria != null && voCriteria.getColumnSortOrder() != null)
    {
        setSortOrderForColumn(voCriteria.getColumnSortOrder().getColumnId(),voCriteria.getColumnSortOrder().getSortOrder());
    }
}

public dischargeDetailsVo getdischargeDetailsForCareContext(CareContextRefVo careContext)   
{
    if(careContext == null ||
            careContext.getID_CareContext() == null)
        throw new CodingRuntimeException("CareContext is null or id not provided for getdischargeDetailsForCareContext");   

    DomainFactory factory = getDomainFactory();
    List dischargeDetails = factory.find("select dd from dischargeDetails as dd left join dd.careContext as cc where cc.id = :idCareContext",new String[]{"idCareContext"},new Object[]{careContext.getID_CareContext()});
    dischargeDetailsVoCollection discharge = dischargeDetailsVoAssembler.createdischargeDetailsVoCollectionFromdischargeDetails(dischargeDetails);      

    return discharge != null && discharge.size() > 0 ? (discharge.get(0) != null ? discharge.get(0) : null) : null;
}

/**
* get discharge Details
*/
public ims.clinical.vo.dischargeDetailsVo getdischargeDetails(ims.core.admin.vo.CareContextRefVo careContextRefvo)
{
    if(careContextRefvo == null)
        throw new CodingRuntimeException("careContextRefVo Filter not provided for list call. ");

    if(careContextRefvo != null)
    {
        DomainFactory factory = getDomainFactory();
        StringBuffer hql = new StringBuffer(" from dischargeDetails dd where "); 
        String andStr = " ";

        ArrayList<String> markers = new ArrayList<String>();
        ArrayList<Serializable> values = new ArrayList<Serializable>();

        hql.append(andStr + " dd.careContext.id = :careContextId");
            markers.add("careContextId");
        values.add(careContextRefvo.getID_CareContext());
        andStr = " and ";   

        List list = factory.find(hql.toString(),markers,values);
        if(list != null && list.size() > 0)
        { 
            dischargeDetailsVoCollection voColl = dischargeDetailsVoAssembler.createdischargeDetailsVoCollectionFromdischargeDetails(list);
            if(voColl != null && voColl.size() > 0)
                return voColl.get(0);
        }
    }
    return null;
}

public dischargeDetailsVo getdischargeDetails(CareContextRefVo careContextRefvo) 
{
    if(careContextRefvo == null)
        throw new CodingRuntimeException("careContextRefVo Filter not provided for list call. ");

    if(careContextRefvo != null)
    {
        DomainFactory factory = getDomainFactory();
        StringBuffer hql = new StringBuffer(" from dischargeDetails dd where "); 
        String andStr = " ";

        ArrayList<String> markers = new ArrayList<String>();
        ArrayList<Serializable> values = new ArrayList<Serializable>();

        hql.append(andStr + " dd.careContext.id = :careContextId");
            markers.add("careContextId");
        values.add(careContextRefvo.getID_CareContext());
        andStr = " and ";   

        List list = factory.find(hql.toString(),values);
        if(list != null && list.size() > 0)
        { 
            dischargeDetailsVoCollection voColl = dischargeDetailsVoAssembler.createdischargeDetailsVoCollectionFromdischargeDetails(list);
            if(voColl != null && voColl.size() > 0)
                return voColl.get(0);
        }
    }
    return null;
}

/**
* get discharge Details
*/
public ims.clinical.vo.dischargeDetailsVo getdischargeDetails(ims.core.admin.vo.CareContextRefVo careContextRefvo)
{
    if(careContextRefvo == null)
        throw new CodingRuntimeException("careContextRefVo Filter not provided for list call. ");

    if(careContextRefvo != null)
    {
        DomainFactory factory = getDomainFactory();
        StringBuffer hql = new StringBuffer(" from dischargeDetails dd where "); 
        String andStr = " ";

        ArrayList<String> markers = new ArrayList<String>();
        ArrayList<Serializable> values = new ArrayList<Serializable>();

        hql.append(andStr + " dd.careContext.id = :careContextId");
            markers.add("careContextId");
        values.add(careContextRefvo.getID_CareContext());
        andStr = " and ";   

        List list = factory.find(hql.toString(),values);
        if(list != null && list.size() > 0)
        { 
            dischargeDetailsVoCollection voColl = dischargeDetailsVoAssembler.createdischargeDetailsVoCollectionFromdischargeDetails(list);
            if(voColl != null && voColl.size() > 0)
                return voColl.get(0);
        }
    }
    return null;
}

public dischargeDetailsVo getdischargeDetailsForCareContext(CareContextRefVo careContext)   
{
    if(careContext == null ||
            careContext.getID_CareContext() == null)
        throw new CodingRuntimeException("CareContext is null or id not provided for getdischargeDetailsForCareContext");   

    DomainFactory factory = getDomainFactory();
    List dischargeDetails = factory.find("select dd from dischargeDetails as dd left join dd.careContext as cc where cc.id = :idCareContext",new Object[]{careContext.getID_CareContext()});
    dischargeDetailsVoCollection discharge = dischargeDetailsVoAssembler.createdischargeDetailsVoCollectionFromdischargeDetails(dischargeDetails);      

    return discharge != null && discharge.size() > 0 ? (discharge.get(0) != null ? discharge.get(0) : null) : null;
}

public dischargeDetailsVo getdischargeDetailsForCareContext(CareContextRefVo careContext)   
{
    if(careContext == null ||
            careContext.getID_CareContext() == null)
        throw new CodingRuntimeException("CareContext is null or id not provided for getdischargeDetailsForCareContext");   

    DomainFactory factory = getDomainFactory();
    List dischargeDetails = factory.find("select dd from dischargeDetails as dd left join dd.careContext as cc where cc.id = :idCareContext",new Object[]{careContext.getID_CareContext()});
    dischargeDetailsVoCollection discharge = dischargeDetailsVoAssembler.createdischargeDetailsVoCollectionFromdischargeDetails(dischargeDetails);      

    return discharge != null && discharge.size() > 0 ? (discharge.get(0) != null ? discharge.get(0) : null) : null;
}

public dischargeDetailsVo getdischargeDetailsForCareContext(CareContextRefVo careContext)   
{
    if(careContext == null ||
            careContext.getID_CareContext() == null)
        throw new CodingRuntimeException("CareContext is null or id not provided for getdischargeDetailsForCareContext");   

    DomainFactory factory = getDomainFactory();
    List dischargeDetails = factory.find("select dd from dischargeDetails as dd left join dd.careContext as cc where cc.id = :idCareContext",new Object[]{careContext.getID_CareContext()});
    dischargeDetailsVoCollection discharge = dischargeDetailsVoAssembler.createdischargeDetailsVoCollectionFromdischargeDetails(dischargeDetails);      

    return discharge != null && discharge.size() > 0 ? (discharge.get(0) != null ? discharge.get(0) : null) : null;
}

public dischargeDetailsVo getdischargeDetailsForCareContext(CareContextRefVo careContext)   
{
    if(careContext == null ||
            careContext.getID_CareContext() == null)
        throw new CodingRuntimeException("CareContext is null or id not provided for getdischargeDetailsForCareContext");   

    DomainFactory factory = getDomainFactory();
    List dischargeDetails = factory.find("select dd from dischargeDetails as dd left join dd.careContext as cc where cc.id = :idCareContext",new Object[]{careContext.getID_CareContext()});
    dischargeDetailsVoCollection discharge = dischargeDetailsVoAssembler.createdischargeDetailsVoCollectionFromdischargeDetails(dischargeDetails);      

    return discharge != null && discharge.size() > 0 ? (discharge.get(0) != null ? discharge.get(0) : null) : null;
}

/**
* get discharge Details
*/
public ims.clinical.vo.dischargeDetailsVo getdischargeDetails(ims.core.admin.vo.CareContextRefVo careContextRefvo)
{
    if(careContextRefvo == null)
        throw new CodingRuntimeException("careContextRefVo Filter not provided for list call. ");

    if(careContextRefvo != null)
    {
        DomainFactory factory = getDomainFactory();
        StringBuffer hql = new StringBuffer(" from dischargeDetails dd where "); 
        String andStr = " ";

        ArrayList<String> markers = new ArrayList<String>();
        ArrayList<Serializable> values = new ArrayList<Serializable>();

        hql.append(andStr + " dd.careContext.id = :careContextId");
            markers.add("careContextId");
        values.add(careContextRefvo.getID_CareContext());
        andStr = " and ";   

        List list = factory.find(hql.toString(),values);
        if(list != null && list.size() > 0)
        { 
            dischargeDetailsVoCollection voColl = dischargeDetailsVoAssembler.createdischargeDetailsVoCollectionFromdischargeDetails(list);
            if(voColl != null && voColl.size() > 0)
                return voColl.get(0);
        }
    }
    return null;
}

public dischargeDetailsVo getdischargeDetails(CareContextRefVo careContextRefvo) 
{
    if(careContextRefvo == null)
        throw new CodingRuntimeException("careContextRefVo Filter not provided for list call. ");

    if(careContextRefvo != null)
    {
        DomainFactory factory = getDomainFactory();
        StringBuffer hql = new StringBuffer(" from dischargeDetails dd where "); 
        String andStr = " ";

        ArrayList<String> markers = new ArrayList<String>();
        ArrayList<Serializable> values = new ArrayList<Serializable>();

        hql.append(andStr + " dd.careContext.id = :careContextId");
            markers.add("careContextId");
        values.add(careContextRefvo.getID_CareContext());
        andStr = " and ";   

        List list = factory.find(hql.toString(),values);
        if(list != null && list.size() > 0)
        { 
            dischargeDetailsVoCollection voColl = dischargeDetailsVoAssembler.createdischargeDetailsVoCollectionFromdischargeDetails(list);
            if(voColl != null && voColl.size() > 0)
                return voColl.get(0);
        }
    }
    return null;
}

/**
* get discharge Details
*/
public ims.clinical.vo.dischargeDetailsVo getdischargeDetails(ims.core.admin.vo.CareContextRefVo careContextRefvo)
{
    if(careContextRefvo == null)
        throw new CodingRuntimeException("careContextRefVo Filter not provided for list call. ");

    if(careContextRefvo != null)
    {
        DomainFactory factory = getDomainFactory();
        StringBuffer hql = new StringBuffer(" from dischargeDetails dd where "); 
        String andStr = " ";

        ArrayList<String> markers = new ArrayList<String>();
        ArrayList<Serializable> values = new ArrayList<Serializable>();

        hql.append(andStr + " dd.careContext.id = :careContextId");
            markers.add("careContextId");
        values.add(careContextRefvo.getID_CareContext());
        andStr = " and ";   

        List list = factory.find(hql.toString(),values);
        if(list != null && list.size() > 0)
        { 
            dischargeDetailsVoCollection voColl = dischargeDetailsVoAssembler.createdischargeDetailsVoCollectionFromdischargeDetails(list);
            if(voColl != null && voColl.size() > 0)
                return voColl.get(0);
        }
    }
    return null;
}

public dischargeDetailsVo getdischargeDetailsForCareContext(CareContextRefVo careContext)   
{
    if(careContext == null ||
            careContext.getID_CareContext() == null)
        throw new CodingRuntimeException("CareContext is null or id not provided for getdischargeDetailsForCareContext");   

    DomainFactory factory = getDomainFactory();
    List dischargeDetails = factory.find("select dd from dischargeDetails as dd left join dd.careContext as cc where cc.id = :idCareContext",new Object[]{careContext.getID_CareContext()});
    dischargeDetailsVoCollection discharge = dischargeDetailsVoAssembler.createdischargeDetailsVoCollectionFromdischargeDetails(dischargeDetails);      

    return discharge != null && discharge.size() > 0 ? (discharge.get(0) != null ? discharge.get(0) : null) : null;
}

public dischargeDetailsVo getdischargeDetailsForCareContext(CareContextRefVo careContext)   
{
    if(careContext == null ||
            careContext.getID_CareContext() == null)
        throw new CodingRuntimeException("CareContext is null or id not provided for getdischargeDetailsForCareContext");   

    DomainFactory factory = getDomainFactory();
    List dischargeDetails = factory.find("select dd from dischargeDetails as dd left join dd.careContext as cc where cc.id = :idCareContext",new Object[]{careContext.getID_CareContext()});
    dischargeDetailsVoCollection discharge = dischargeDetailsVoAssembler.createdischargeDetailsVoCollectionFromdischargeDetails(dischargeDetails);      

    return discharge != null && discharge.size() > 0 ? (discharge.get(0) != null ? discharge.get(0) : null) : null;
}

/**
* get discharge Details
*/
public ims.clinical.vo.dischargeDetailsVo getdischargeDetails(ims.core.admin.vo.CareContextRefVo careContextRefvo)
{
    if(careContextRefvo == null)
        throw new CodingRuntimeException("careContextRefVo Filter not provided for list call. ");

    if(careContextRefvo != null)
    {
        DomainFactory factory = getDomainFactory();
        StringBuffer hql = new StringBuffer(" from dischargeDetails dd where "); 
        String andStr = " ";

        ArrayList<String> markers = new ArrayList<String>();
        ArrayList<Serializable> values = new ArrayList<Serializable>();

        hql.append(andStr + " dd.careContext.id = :careContextId");
            markers.add("careContextId");
        values.add(careContextRefvo.getID_CareContext());
        andStr = " and ";   

        List list = factory.find(hql.toString(),values);
        if(list != null && list.size() > 0)
        { 
            dischargeDetailsVoCollection voColl = dischargeDetailsVoAssembler.createdischargeDetailsVoCollectionFromdischargeDetails(list);
            if(voColl != null && voColl.size() > 0)
                return voColl.get(0);
        }
    }
    return null;
}

public dischargeDetailsVo getdischargeDetails(CareContextRefVo careContextRefvo) 
{
    if(careContextRefvo == null)
        throw new CodingRuntimeException("careContextRefVo Filter not provided for list call. ");

    if(careContextRefvo != null)
    {
        DomainFactory factory = getDomainFactory();
        StringBuffer hql = new StringBuffer(" from dischargeDetails dd where "); 
        String andStr = " ";

        ArrayList<String> markers = new ArrayList<String>();
        ArrayList<Serializable> values = new ArrayList<Serializable>();

        hql.append(andStr + " dd.careContext.id = :careContextId");
            markers.add("careContextId");
        values.add(careContextRefvo.getID_CareContext());
        andStr = " and ";   

        List list = factory.find(hql.toString(),values);
        if(list != null && list.size() > 0)
        { 
            dischargeDetailsVoCollection voColl = dischargeDetailsVoAssembler.createdischargeDetailsVoCollectionFromdischargeDetails(list);
            if(voColl != null && voColl.size() > 0)
                return voColl.get(0);
        }
    }
    return null;
}

/**
* get discharge Details
*/
public ims.clinical.vo.dischargeDetailsVo getdischargeDetails(ims.core.admin.vo.CareContextRefVo careContextRefvo)
{
    if(careContextRefvo == null)
        throw new CodingRuntimeException("careContextRefVo Filter not provided for list call. ");

    if(careContextRefvo != null)
    {
        DomainFactory factory = getDomainFactory();
        StringBuffer hql = new StringBuffer(" from dischargeDetails dd where "); 
        String andStr = " ";

        ArrayList<String> markers = new ArrayList<String>();
        ArrayList<Serializable> values = new ArrayList<Serializable>();

        hql.append(andStr + " dd.careContext.id = :careContextId");
            markers.add("careContextId");
        values.add(careContextRefvo.getID_CareContext());
        andStr = " and ";   

        List list = factory.find(hql.toString(),values);
        if(list != null && list.size() > 0)
        { 
            dischargeDetailsVoCollection voColl = dischargeDetailsVoAssembler.createdischargeDetailsVoCollectionFromdischargeDetails(list);
            if(voColl != null && voColl.size() > 0)
                return voColl.get(0);
        }
    }
    return null;
}

public dischargeDetailsVo getdischargeDetailsForCareContext(CareContextRefVo careContext)   
{
    if(careContext == null ||
            careContext.getID_CareContext() == null)
        throw new CodingRuntimeException("CareContext is null or id not provided for getdischargeDetailsForCareContext");   

    DomainFactory factory = getDomainFactory();
    List dischargeDetails = factory.find("select dd from dischargeDetails as dd left join dd.careContext as cc where cc.id = :idCareContext",new Object[]{careContext.getID_CareContext()});
    dischargeDetailsVoCollection discharge = dischargeDetailsVoAssembler.createdischargeDetailsVoCollectionFromdischargeDetails(dischargeDetails);      

    return discharge != null && discharge.size() > 0 ? (discharge.get(0) != null ? discharge.get(0) : null) : null;
}