static public TestDispensaryOne BuildSickListFromDataBaseData(string idStep)
{
if (idStep != "")
{
List <TestAttachment> lta = TestAttachment.BuildTestAttacmentFromDataBase(idStep, idDispensaryOne);
if (lta != null)
{
foreach (TestAttachment i in lta)
{
using (SqlConnection connection = Global.GetSqlConnection())
{
string findDO = "SELECT TOP(1) * FROM DispensaryStage1, DispensaryStage1HealthGroup WHERE DispensaryStage1.idDispensaryStage1 = (SELECT MAX(idDispensaryStage1) FROM DispensaryStage1 WHERE IdMedDocument = '" + i.idMedDocument + "') AND DispensaryStage1.idDispensaryStage1 = DispensaryStage1HealthGroup.idDispensaryStage1";
SqlCommand DOcommand = new SqlCommand(findDO, connection);
using (SqlDataReader DOReader = DOcommand.ExecuteReader())
{
while (DOReader.Read())
{
DispensaryOne r = new DispensaryOne();
r.HealthGroup = new HealthGroup();
r.HealthGroup.HealthGroupInfo = new HealthGroupInfo();
if (DOReader["IsGuested"].ToString() != "")
{
r.IsGuested = Convert.ToBoolean(DOReader["IsGuested"]);
}
if (DOReader["HasExtraResearchRefferal"].ToString() != "")
{
r.HasExtraResearchRefferal = Convert.ToBoolean(DOReader["HasExtraResearchRefferal"]);
}
if (DOReader["IsUnderObservation"].ToString() != "")
{
r.IsUnderObservation = Convert.ToBoolean(DOReader["IsUnderObservation"]);
}
if (DOReader["HasExpertCareRefferal"].ToString() != "")
{
r.HasExpertCareRefferal = Convert.ToBoolean(DOReader["HasExpertCareRefferal"]);
}
if (DOReader["HasPrescribeCure"].ToString() != "")
{
r.HasPrescribeCure = Convert.ToBoolean(DOReader["HasPrescribeCure"]);
}
if (DOReader["HasHealthResortRefferal"].ToString() != "")
{
r.HasHealthResortRefferal = Convert.ToBoolean(DOReader["HasHealthResortRefferal"]);
}
if (DOReader["HasSecondStageRefferal"].ToString() != "")
{
r.HasSecondStageRefferal = Convert.ToBoolean(DOReader["HasSecondStageRefferal"]);
}
if (DOReader["IdHealthGroup"].ToString() != "")
{
r.HealthGroup.HealthGroupInfo.IdHealthGroup = Convert.ToByte(DOReader["IdHealthGroup"]);
}
if (DOReader["Date"].ToString() != "")
{
r.HealthGroup.HealthGroupInfo.Date = Convert.ToDateTime(DOReader["Date"]);
}
r.Header = i.DocHead;
r.CreationDate = i.CreationDate;
TestDispensaryOne tdo = new TestDispensaryOne(r);
if (DOReader["IdDoctor"].ToString() != "")
{
tdo.hdDoctor = TestDoctor.BuildTestDoctorFromDataBase((DOReader["IdDoctor"]).ToString());
}
if (DOReader["idDispensaryStage1"].ToString() != "")
{
tdo.recom = TestRecommendation.BuildSickListFromDataBaseData(DOReader["idDispensaryStage1"].ToString());
}
tdo.doctor = TestDoctor.BuildTestDoctorFromDataBase(i.IdDoctor);
tdo.attachment = i;
return(tdo);
}
}
}
}
}
}
return(null);
}
