static public TestGuardian BuildTestGuardianFromDataBase(string guardianId, string patientId)
{
if ((guardianId != "") && (patientId != ""))
{
string findIdRealationTypeString =
"SELECT TOP(1) * FROM mm_Person2Person WHERE IdPerson = '" + patientId + "' AND IdPersonRelated = '" + guardianId + "'";
using (SqlConnection connection = Global.GetSqlConnection())
{
SqlCommand IdInstitution = new SqlCommand(findIdRealationTypeString, connection);
Guardian g = new Guardian();
using (SqlDataReader IdRelationTypeReader = IdInstitution.ExecuteReader())
{
while (IdRelationTypeReader.Read())
{
g.IdRelationType = Convert.ToByte(IdRelationTypeReader["IdRelationType"]);
if (Convert.ToString(IdRelationTypeReader["UnderlyingDocument"]) != "")
{
g.UnderlyingDocument = Convert.ToString(IdRelationTypeReader["UnderlyingDocument"]);
}
else
{
g.UnderlyingDocument = null;
}
}
}
TestGuardian guard = new TestGuardian(g);
guard.person = TestPerson.BuildPersonFromDataBaseData(guardianId);
return(guard);
}
}
return(null);
}
static public TestDoctor BuildTestDoctorFromDataBase(string doctorId)
{
if (doctorId != null)
{
using (SqlConnection connection = Global.GetSqlConnection())
{
string findDoctor = "SELECT TOP(1) * FROM Doctor, nsi.DoctorSpec WHERE Doctor.IdDoctor = '" + doctorId + "' AND Doctor.IdSpeciality = nsi.DoctorSpec.IdSpeciality";
SqlCommand doc = new SqlCommand(findDoctor, connection);
using (SqlDataReader doctorReader = doc.ExecuteReader())
{
while (doctorReader.Read())
{
string IdPerson = Convert.ToString(doctorReader["IdPerson"]);
MedicalStaff ms = new MedicalStaff();
ms.IdPosition = Convert.ToUInt16(doctorReader["IdPosition"]);
ms.IdSpeciality = Convert.ToUInt16(doctorReader["Code"]);
ms.IdLpu = Convert.ToString(doctorReader["IdLpu"]);
if (Data.type == Type.oid)
{
string findIdInstitutionalString =
"SELECT TOP(1) * FROM Institution WHERE IdInstitution = '" + ms.IdLpu + "'";
using (SqlConnection connection2 = Global.GetSqlConnection())
{
SqlCommand IdInstitution = new SqlCommand(findIdInstitutionalString, connection2);
using (SqlDataReader IdInstitutional = IdInstitution.ExecuteReader())
{
while (IdInstitutional.Read())
{
ms.IdLpu = IdInstitutional["IdFedNsi"].ToString();
}
}
}
}
TestDoctor p = new TestDoctor(ms);
p.person = TestPerson.BuildPersonFromDataBaseData(IdPerson);
return(p);
}
}
}
}
return(null);
}
