public TestAmbStep(StepAmb sa, string caseLpu)
{
if (sa != null)
{
ambStep = sa;
step = new TestStepBase(sa, caseLpu);
if (sa.MedRecords != null)
{
records = new List<TestMedRecord>();
foreach (object i in sa.MedRecords)
{
Service s = i as Service;
if (s != null)
records.Add(new TestService(s, caseLpu));
AppointedMedication am = i as AppointedMedication;
if (am != null)
records.Add(new TestAppointedMedication(am, caseLpu));
Diagnosis diag = i as Diagnosis;
if ((diag != null) && (diag.DiagnosisInfo.IdDiagnosisType != TestDiagnosis.IdClinicMainDiagnosis))
records.Add(new TestDiagnosis(diag, caseLpu));
ClinicMainDiagnosis cmd = i as ClinicMainDiagnosis;
if ((cmd != null) && (cmd.DiagnosisInfo.IdDiagnosisType == TestDiagnosis.IdClinicMainDiagnosis))
records.Add(new TestClinicMainDiagnosis(cmd, caseLpu));
Referral r = i as Referral;
if (r != null)
records.Add(new TestReferral(r, caseLpu));
LaboratoryReport lr = i as LaboratoryReport;
if (lr != null)
records.Add(new TestLaboratoryReport(lr, caseLpu));
}
}
}
}
public void AddAmbStep_SameIdMin()
{
using (TestPixServiceClient PixClient = new TestPixServiceClient())
{
PatientDto patient = (new SetData()).PatientSet();
PixClient.AddPatient(Global.GUID, Data.idlpu, patient);
}
using (TestEmkServiceClient EmkClient = new TestEmkServiceClient())
{
CaseAmb caseAmb = (new SetData()).MinCaseAmbSetForCreate();
EmkClient.CreateCase(Global.GUID, caseAmb);
StepAmb stepAmb = (new SetData()).MinOtherStepAmbSet();
stepAmb.IdStepMis = CaseAmbData.step.IdStepMis;
EmkClient.AddStepToCase(Global.GUID, Data.idlpu, caseAmb.IdPatientMis, caseAmb.IdCaseMis, stepAmb);
}
if (Global.errors == "")
{
Assert.Pass();
}
else
{
Assert.Fail(Global.errors);
}
}
public void AddAmbCaseRef_ToStep()
{
using (TestPixServiceClient PixClient = new TestPixServiceClient())
{
PatientDto patient = (new SetData()).PatientSet();
PixClient.AddPatient(Global.GUID, Data.idlpu, patient);
}
using (TestEmkServiceClient EmkClient = new TestEmkServiceClient())
{
CaseAmb caseAmb = (new SetData()).MinCaseAmbSet();
StepAmb stepAmb = (new SetData()).MinStepAmbSet();
stepAmb.MedRecords = new List <MedRecord>
{
MedRecordData.referral
};
caseAmb.Steps = new List <StepAmb>
{
stepAmb
};
EmkClient.AddCase(Global.GUID, caseAmb);
}
if (Global.errors == "")
{
Assert.Pass();
}
else
{
Assert.Fail(Global.errors);
}
}
public void AddAmbStep_Ref()
{
using (TestPixServiceClient PixClient = new TestPixServiceClient())
{
PatientDto patient = (new SetData()).PatientSet();
PixClient.AddPatient(Global.GUID, Data.idlpu, patient);
}
using (TestEmkServiceClient EmkClient = new TestEmkServiceClient())
{
CaseAmb caseAmb = (new SetData()).MinCaseAmbSetForCreate();
EmkClient.CreateCase(Global.GUID, caseAmb);
StepAmb stepAmb = (new SetData()).MinOtherStepAmbSet();
stepAmb.MedRecords = new List <MedRecord>
{
MedRecordData.referral
};
EmkClient.AddStepToCase(Global.GUID, Data.idlpu, caseAmb.IdPatientMis, caseAmb.IdCaseMis, stepAmb);
}
if (Global.errors == "")
{
Assert.Pass();
}
else
{
Assert.Fail(Global.errors);
}
}
public void AddStepToCaseAmbCaseWithAppointedMedicationMin()
{
using (TestPixServiceClient c = new TestPixServiceClient())
{
PatientDto patient = (new SetData()).PatientSet();
c.AddPatient(Global.GUID, Data.idlpu, patient);
}
using (TestEmkServiceClient client = new TestEmkServiceClient())
{
CaseAmb caseAmb = (new SetData()).MinCaseAmbSetForCreate();
client.CreateCase(Global.GUID, caseAmb);
StepAmb stepAmb = (new SetData()).MinStepAmbSet();
stepAmb.MedRecords = new List <MedRecord>
{
(new SetData()).MinAppointedMedication()
};
client.AddStepToCase(Global.GUID, Data.idlpu, caseAmb.IdPatientMis, caseAmb.IdCaseMis, stepAmb);
}
if (Global.errors == "")
{
Assert.Pass();
}
else
{
Assert.Fail(Global.errors);
}
}
public void AddAmbStep_OtherIdFull()
{
using (TestPixServiceClient PixClient = new TestPixServiceClient())
{
PatientDto patient = (new SetData()).PatientSet();
PixClient.AddPatient(Global.GUID, Data.idlpu, patient);
}
using (TestEmkServiceClient EmkClient = new TestEmkServiceClient())
{
CaseAmb caseAmb = (new SetData()).MinCaseAmbSetForCreate();
EmkClient.CreateCase(Global.GUID, caseAmb);
StepAmb stepAmb = CaseAmbData.otherStep;
stepAmb.MedRecords = new List <MedRecord>
{
(new SetData()).MinService(),
(new SetData()).MinAppointedMedication(),
(new SetData()).MinDiagnosis(),
MedRecordData.clinicMainDiagnosis,
MedRecordData.referral,
(new SetData()).MinLaboratoryReport()
};
EmkClient.AddStepToCase(Global.GUID, Data.idlpu, caseAmb.IdPatientMis, caseAmb.IdCaseMis, stepAmb);
}
if (Global.errors == "")
{
Assert.Pass();
}
else
{
Assert.Fail(Global.errors);
}
}
public void CreateAmbCaseWithLaboratoryReportFull()
{
using (TestPixServiceClient c = new TestPixServiceClient())
{
PatientDto patient = (new SetData()).PatientSet();
c.AddPatient(Global.GUID, Data.idlpu, patient);
}
using (TestEmkServiceClient client = new TestEmkServiceClient())
{
CaseAmb caseAmb = (new SetData()).MinCaseAmbSetForCreate();
caseAmb.MedRecords = new List <MedRecord>
{
MedRecordData.LaboratoryReport
};
StepAmb stepAmb = (new SetData()).MinStepAmbSet();
stepAmb.MedRecords = new List <MedRecord>
{
MedRecordData.LaboratoryReport,
(new SetData()).MinLaboratoryReport()
};
caseAmb.Steps = new List <StepAmb>
{
stepAmb
};
client.CreateCase(Global.GUID, caseAmb);
}
if (Global.errors == "")
{
Assert.Pass();
}
else
{
Assert.Fail(Global.errors);
}
}
public void UpdateFullAmbCase_AfterClose()
{
using (TestPixServiceClient PixClient = new TestPixServiceClient())
{
PatientDto patient = (new SetData()).PatientSet();
PixClient.AddPatient(Global.GUID, Data.idlpu, patient);
}
using (TestEmkServiceClient EmkClient = new TestEmkServiceClient())
{
CaseAmb caseAmb = (new SetData()).MinCaseAmbSetForCreate();
EmkClient.CreateCase(Global.GUID, caseAmb);
caseAmb = (new SetData()).MinCaseAmbSetForClose();
EmkClient.CloseCase(Global.GUID, caseAmb);
CaseAmb caseAmbUpdate = (new SetData()).FullCaseAmbSet();
SetData set = new SetData();
caseAmb.MedRecords = new List <MedRecord>
{
set.MinService(),
set.MinTfomsInfo(),
set.MinDiagnosis(),
MedRecordData.clinicMainDiagnosis,
set.MinRefferal(),
set.MinSickList(),
set.MinDischargeSummary(),
set.MinLaboratoryReport(),
set.MinConsultNote()
};
StepAmb stepAmb = (new SetData()).MinStepAmbSet();
stepAmb.MedRecords = new List <MedRecord>
{
set.MinService(),
set.MinAppointedMedication(),
set.MinDiagnosis(),
MedRecordData.clinicMainDiagnosis,
set.MinRefferal(),
set.MinLaboratoryReport(),
};
caseAmbUpdate.Steps = new List <StepAmb>
{
stepAmb
};
EmkClient.UpdateCase(Global.GUID, caseAmbUpdate);
}
if (Global.errors == "")
{
Assert.Pass();
}
else
{
Assert.Fail(Global.errors);
}
}
public void UpdateFullAmbCase_AfterClose()
{
using (TestPixServiceClient PixClient = new TestPixServiceClient())
{
PatientDto patient = (new SetData()).PatientSet();
PixClient.AddPatient("D500E893-166B-4724-9C78-D0DBE1F1C48D", "1.2.643.5.1.13.3.25.78.118", patient);
}
using (TestEmkServiceClient EmkClient = new TestEmkServiceClient())
{
CaseAmb caseAmb = (new SetData()).MinCaseAmbSetForCreate();
EmkClient.CreateCase("D500E893-166B-4724-9C78-D0DBE1F1C48D", caseAmb);
caseAmb = (new SetData()).MinCaseAmbSetForClose();
EmkClient.CloseCase("D500E893-166B-4724-9C78-D0DBE1F1C48D", caseAmb);
CaseAmb caseAmbUpdate = (new SetData()).FullCaseAmbSet();
SetData set = new SetData();
caseAmb.MedRecords = new MedRecord[]
{
set.MinService(),
set.MinTfomsInfo(),
set.MinDiagnosis(),
MedRecordData.clinicMainDiagnosis,
MedRecordData.referral,
MedRecordData.sickList,
set.MinDischargeSummary(),
set.MinLaboratoryReport(),
set.MinConsultNote()
};
StepAmb stepAmb = (new SetData()).MinStepAmbSet();
stepAmb.MedRecords = new MedRecord[]
{
set.MinService(),
set.MinAppointedMedication(),
set.MinDiagnosis(),
MedRecordData.clinicMainDiagnosis,
MedRecordData.referral,
set.MinLaboratoryReport(),
};
caseAmb.Steps = new StepAmb[]
{
stepAmb
};
EmkClient.UpdateCase("D500E893-166B-4724-9C78-D0DBE1F1C48D", caseAmbUpdate);
}
if (Global.errors == "")
{
Assert.Pass();
}
else
{
Assert.Fail(Global.errors);
}
}
public void UpdateFullAmbCase_AfterAdd()
{
using (TestPixServiceClient PixClient = new TestPixServiceClient())
{
PatientDto patient = (new SetData()).PatientSet();
PixClient.AddPatient(Global.GUID, Data.idlpu, patient);
}
using (TestEmkServiceClient EmkClient = new TestEmkServiceClient())
{
CaseAmb caseAmbAdd = (new SetData()).MinCaseAmbSet();
EmkClient.AddCase(Global.GUID, caseAmbAdd);
CaseAmb caseAmb = (new SetData()).FullCaseAmbSet();
SetData set = new SetData();
caseAmb.MedRecords = new List <MedRecord>
{
MedRecordData.service,
MedRecordData.tfomsInfo,
MedRecordData.diagnosis,
MedRecordData.clinicMainDiagnosis,
MedRecordData.referral,
MedRecordData.sickList,
MedRecordData.dischargeSummary,
MedRecordData.LaboratoryReport,
MedRecordData.consultNote,
};
StepAmb stepAmb = (new SetData()).MinStepAmbSet();
stepAmb.MedRecords = new List <MedRecord>
{
set.MinService(),
set.MinAppointedMedication(),
set.MinDiagnosis(),
MedRecordData.clinicMainDiagnosis,
MedRecordData.referral,
set.MinLaboratoryReport(),
};
caseAmb.Steps = new List <StepAmb>
{
stepAmb
};
EmkClient.UpdateCase(Global.GUID, caseAmb);
}
if (Global.errors == "")
{
Assert.Pass();
}
else
{
Assert.Fail(Global.errors);
}
}
public StepAmb MinOtherStepAmbSet()
{
StepAmb stepAmb = new StepAmb
{
DateStart = CaseAmbData.otherStep.DateStart,
DateEnd = CaseAmbData.otherStep.DateEnd,
IdStepMis = CaseAmbData.otherStep.IdStepMis,
IdPaymentType = CaseAmbData.otherStep.IdPaymentType,
IdVisitPlace = CaseAmbData.otherStep.IdVisitPlace,
IdVisitPurpose = CaseAmbData.otherStep.IdVisitPurpose,
Doctor = MinDoctorSet(),
};
return(stepAmb);
}
public void CancelFullAmbCase()
{
using (TestPixServiceClient PixClient = new TestPixServiceClient())
{
PatientDto patient = (new SetData()).PatientSet();
PixClient.AddPatient(Global.GUID, Data.idlpu, patient);
}
using (TestEmkServiceClient EmkClient = new TestEmkServiceClient())
{
CaseAmb caseAmb = (new SetData()).FullCaseAmbSetForCreate();
SetData set = new SetData();
caseAmb.MedRecords = new List <MedRecord>
{
set.MinService(),
set.MinTfomsInfo(),
set.MinDiagnosis(),
MedRecordData.clinicMainDiagnosis,
MedRecordData.referral,
MedRecordData.sickList,
set.MinLaboratoryReport(),
};
StepAmb stepAmb = (new SetData()).MinStepAmbSet();
stepAmb.MedRecords = new List <MedRecord>
{
set.MinService(),
set.MinAppointedMedication(),
set.MinDiagnosis(),
MedRecordData.clinicMainDiagnosis,
MedRecordData.referral,
set.MinLaboratoryReport(),
};
caseAmb.Steps = new List <StepAmb>
{
stepAmb
};
EmkClient.CreateCase(Global.GUID, caseAmb);
EmkClient.CancelCase(Global.GUID, Data.idlpu, caseAmb.IdPatientMis, caseAmb.IdCaseMis);
}
if (Global.errors == "")
{
Assert.Pass();
}
else
{
Assert.Fail(Global.errors);
}
}
public void AddFullDispCase()
{
using (TestPixServiceClient PixClient = new TestPixServiceClient())
{
PatientDto patient = (new SetData()).PatientSet();
PixClient.AddPatient(Global.GUID, Data.idlpu, patient);
}
using (TestEmkServiceClient EmkClient = new TestEmkServiceClient())
{
CaseAmb caseAmb = (new SetData()).FullCaseDispSet();
SetData set = new SetData();
caseAmb.MedRecords = new List <MedRecord>
{
set.MinService(),
set.MinTfomsInfo(),
set.MinDiagnosis(),
MedRecordData.clinicMainDiagnosis,
set.MinDispensaryOne(),
set.MinLaboratoryReport(),
};
StepAmb stepAmb = (new SetData()).MinStepAmbSet();
stepAmb.MedRecords = new List <MedRecord>
{
set.MinService(),
set.MinAppointedMedication(),
set.MinDiagnosis(),
MedRecordData.clinicMainDiagnosis,
set.MinRefferal(),
set.MinLaboratoryReport(),
};
caseAmb.Steps = new List <StepAmb> {
stepAmb
};
EmkClient.AddCase(Global.GUID, caseAmb);
}
if (Global.errors == "")
{
Assert.Pass();
}
else
{
Assert.Fail(Global.errors);
}
}
public TestAmbStep(StepAmb sa, string caseLpu)
{
if (sa != null)
{
ambStep = sa;
step = new TestStepBase(sa, caseLpu);
if (sa.MedRecords != null)
{
records = new List <TestMedRecord>();
foreach (object i in sa.MedRecords)
{
Service s = i as Service;
if (s != null)
{
records.Add(new TestService(s, caseLpu));
}
AppointedMedication am = i as AppointedMedication;
if (am != null)
{
records.Add(new TestAppointedMedication(am, caseLpu));
}
Diagnosis diag = i as Diagnosis;
if ((diag != null) && (diag.DiagnosisInfo.IdDiagnosisType != TestDiagnosis.IdClinicMainDiagnosis))
{
records.Add(new TestDiagnosis(diag, caseLpu));
}
ClinicMainDiagnosis cmd = i as ClinicMainDiagnosis;
if ((cmd != null) && (cmd.DiagnosisInfo.IdDiagnosisType == TestDiagnosis.IdClinicMainDiagnosis))
{
records.Add(new TestClinicMainDiagnosis(cmd, caseLpu));
}
Referral r = i as Referral;
if (r != null)
{
records.Add(new TestReferral(r, caseLpu));
}
LaboratoryReport lr = i as LaboratoryReport;
if (lr != null)
{
records.Add(new TestLaboratoryReport(lr, caseLpu));
}
}
}
}
}
public void AddAmbStep_CloseCase()
{
using (TestPixServiceClient PixClient = new TestPixServiceClient())
{
PatientDto patient = (new SetData()).PatientSet();
PixClient.AddPatient(Global.GUID, Data.idlpu, patient);
}
using (TestEmkServiceClient EmkClient = new TestEmkServiceClient())
{
CaseAmb caseAmb = (new SetData()).MinCaseAmbSet();
EmkClient.AddCase(Global.GUID, caseAmb);
StepAmb stepAmb = (new SetData()).MinStepAmbSet();
EmkClient.AddStepToCase(Global.GUID, Data.idlpu, caseAmb.IdPatientMis, caseAmb.IdCaseMis, stepAmb);
}
Assert.IsTrue(Global.errors1.Contains(" - Случай обслуживания закрыт"), "Случай обслуживания был добавлен");
}
public void AddStepToCase(string guid, string idLpu, string idPatientMis, string idCaseMis, StepBase s)
{
try
{
StepAmb sa = s as StepAmb;
if ((object)sa != null)
{
client.AddStepToCase(guid, idLpu, idPatientMis, idCaseMis, s);
TestAmbStep example = new TestAmbStep(sa, idLpu);
if (!example.CheckStepInDataBase(guid, idPatientMis, idLpu, idCaseMis))
{
Global.errors1.AddRange(Global.errors2);
}
}
StepStat ss = s as StepStat;
if ((object)ss != null)
{
client.AddStepToCase(guid, idLpu, idPatientMis, idCaseMis, s);
TestStatStep example = new TestStatStep(ss, idLpu);
if (!example.CheckStepInDataBase(guid, idPatientMis, idLpu, idCaseMis))
{
Global.errors1.AddRange(Global.errors2);
}
}
}
catch (System.ServiceModel.FaultException <List <PixServiseTests.EMKServise.RequestFault> > e)
{
getErrors(e.Detail);
}
catch (System.ServiceModel.FaultException <PixServiseTests.EMKServise.RequestFault[]> e)
{
getErrors(e.Detail);
}
catch (System.ServiceModel.FaultException <PixServiseTests.EMKServise.RequestFault> e)
{
Global.errors1.Add(e.Detail.PropertyName + " - " + e.Detail.Message);
getErrors(e.Detail.Errors);
}
}
public void UpdateAmbCaseWithAppointedMedicationMin()
{
using (TestPixServiceClient c = new TestPixServiceClient())
{
PatientDto patient = (new SetData()).PatientSet();
c.AddPatient(Global.GUID, Data.idlpu, patient);
}
using (TestEmkServiceClient client = new TestEmkServiceClient())
{
CaseAmb caseAmb = (new SetData()).MinCaseAmbSet();
client.AddCase(Global.GUID, caseAmb);
caseAmb.MedRecords = new List <MedRecord>
{
(new SetData()).MinClinicMainDiagnosis(),
(new SetData()).MinAppointedMedication()
};
StepAmb stepAmb = (new SetData()).MinStepAmbSet();
stepAmb.MedRecords = new List <MedRecord>
{
(new SetData()).MinAppointedMedication()
};
caseAmb.Steps = new List <StepAmb>
{
stepAmb
};
client.UpdateCase(Global.GUID, caseAmb);
}
if (Global.errors == "")
{
Assert.Pass();
}
else
{
Assert.Fail(Global.errors);
}
}
public StepAmb MinStepAmbSet()
{
StepAmb stepAmb = new StepAmb
{
DateStart = CaseAmbData.step.DateStart,
DateEnd = CaseAmbData.step.DateEnd,
IdStepMis = CaseAmbData.step.IdStepMis,
IdPaymentType = CaseAmbData.step.IdPaymentType,
IdVisitPlace = CaseAmbData.step.IdVisitPlace,
IdVisitPurpose = CaseAmbData.step.IdVisitPurpose,
Doctor = MinDoctorSet(),
};
return stepAmb;
}
private List<EMKServise.StepAmb> ConvertAmbSteps(StepAmb[] ca)
{
if ((object)ca != null)
{
List<EMKServise.StepAmb> l = new List<EMKServise.StepAmb>();
foreach (StepAmb i in ca)
{
EMKServise.StepAmb esa = new EMKServise.StepAmb();
if (i.Comment != "")
esa.Comment = i.Comment;
if (i.DateEnd != DateTime.MinValue)
esa.DateEnd = i.DateEnd;
if (i.DateStart != DateTime.MinValue)
esa.DateStart = i.DateStart;
esa.Doctor = ConvertMedicalStaff(i.Doctor);
esa.IdPaymentType = i.IdPaymentType;
if (i.IdStepMis != "")
esa.IdStepMis = i.IdStepMis;
esa.IdVisitPlace = i.IdVisitPlace;
esa.IdVisitPurpose = i.IdVisitPurpose;
esa.MedRecords = ConvertMedRecords(i.MedRecords);
l.Add(esa);
}
return l;
}
return null;
}
static public List <TestAmbStep> BuildAmbTestStepsFromDataBase(string idCase, string caseLpu)
{
List <TestAmbStep> ambSteps = new List <TestAmbStep>();
if (idCase != string.Empty)
{
List <TestStepBase> steps = TestStepBase.BuildTestStepsFromDataBase(idCase, caseLpu);
using (SqlConnection connection = Global.GetSqlConnection())
{
foreach (TestStepBase i in steps)
{
string findSteps = "SELECT * FROM AmbStep WHERE IdStep = '" + i.idStep + "'";
SqlCommand stepsCommand = new SqlCommand(findSteps, connection);
using (SqlDataReader stepsReader = stepsCommand.ExecuteReader())
{
while (stepsReader.Read())
{
StepAmb sa = new StepAmb();
if (stepsReader["IdVisitPlace"].ToString() != "")
{
sa.IdVisitPlace = Convert.ToByte(stepsReader["IdVisitPlace"]);
}
else
{
sa.IdVisitPlace = 0;
}
if (stepsReader["IdVisitPurpose"].ToString() != "")
{
sa.IdVisitPurpose = Convert.ToByte(stepsReader["IdVisitPurpose"]);
}
else
{
sa.IdVisitPurpose = 0;
}
TestAmbStep st = new TestAmbStep(sa, caseLpu);
st.step = i;
st.records = new List <TestMedRecord>();
List <TestService> s = TestService.BuildServiseFromDataBaseData(i.idStep);
if (!Global.IsEqual(s, null))
{
st.records.AddRange(s);
}
List <TestAppointedMedication> am = TestAppointedMedication.BuildAppointedMedicationFromDataBaseDate(i.idStep);
if (!Global.IsEqual(am, null))
{
st.records.AddRange(am);
}
List <TestDiagnosis> diag = TestDiagnosis.BuildDiagnosisFromDataBaseDate(i.idStep);
if (!Global.IsEqual(diag, null))
{
st.records.AddRange(diag);
}
TestClinicMainDiagnosis acdm = TestClinicMainDiagnosis.BuildTestClinicMainDiagnosisFromDataBaseDate(i.idStep);
if (!Global.IsEqual(acdm, null))
{
st.records.Add(acdm);
}
List <TestReferral> trl = TestReferral.BuildReferralFromDataBaseData(i.idStep);
if (!Global.IsEqual(trl, null))
{
st.records.AddRange(trl);
}
List <TestLaboratoryReport> tlr = TestLaboratoryReport.BuildLaboratoryReportFromDataBaseData(i.idStep);
if (!Global.IsEqual(tlr, null))
{
st.records.AddRange(tlr);
}
if (st.records.Count == 0)
{
st.records = null;
}
ambSteps.Add(st);
}
}
}
}
}
if (ambSteps.Count != 0)
{
return(ambSteps);
}
else
{
return(null);
}
}
public static List<TestAmbStep> BuildAmbTestStepsFromDataBase(string idCase, string caseLpu)
{
List<TestAmbStep> ambSteps = new List<TestAmbStep>();
if (idCase != string.Empty)
{
List<TestStepBase> steps = TestStepBase.BuildTestStepsFromDataBase(idCase, caseLpu);
using (SqlConnection connection = Global.GetSqlConnection())
{
foreach (TestStepBase i in steps)
{
string findSteps = "SELECT * FROM AmbStep WHERE IdStep = '" + i.idStep + "'";
SqlCommand stepsCommand = new SqlCommand(findSteps, connection);
using (SqlDataReader stepsReader = stepsCommand.ExecuteReader())
{
while (stepsReader.Read())
{
StepAmb sa = new StepAmb();
if (stepsReader["IdVisitPlace"].ToString() != "")
sa.IdVisitPlace = Convert.ToByte(stepsReader["IdVisitPlace"]);
else
sa.IdVisitPlace = 0;
if (stepsReader["IdVisitPurpose"].ToString() != "")
sa.IdVisitPurpose = Convert.ToByte(stepsReader["IdVisitPurpose"]);
else
sa.IdVisitPurpose = 0;
TestAmbStep st = new TestAmbStep(sa, caseLpu);
st.step = i;
st.records = new List<TestMedRecord>();
List<TestService> s = TestService.BuildServiseFromDataBaseData(i.idStep);
if (!Global.IsEqual(s, null))
st.records.AddRange(s);
List<TestAppointedMedication> am = TestAppointedMedication.BuildAppointedMedicationFromDataBaseDate(i.idStep);
if (!Global.IsEqual(am, null))
st.records.AddRange(am);
List<TestDiagnosis> diag = TestDiagnosis.BuildDiagnosisFromDataBaseDate(i.idStep);
if (!Global.IsEqual(diag, null))
st.records.AddRange(diag);
TestClinicMainDiagnosis acdm = TestClinicMainDiagnosis.BuildTestClinicMainDiagnosisFromDataBaseDate(i.idStep);
if (!Global.IsEqual(acdm, null))
st.records.Add(acdm);
List<TestReferral> trl = TestReferral.BuildReferralFromDataBaseData(i.idStep);
if (!Global.IsEqual(trl, null))
st.records.AddRange(trl);
List<TestLaboratoryReport> tlr = TestLaboratoryReport.BuildLaboratoryReportFromDataBaseData(i.idStep);
if (!Global.IsEqual(tlr, null))
st.records.AddRange(tlr);
if (st.records.Count == 0)
st.records = null;
ambSteps.Add(st);
}
}
}
}
}
if (ambSteps.Count != 0)
return ambSteps;
else
return null;
}
