static public TestPerson BuildPersonFromDataBaseData(string personId)
{
string mis = GetIDMIS(personId);
if (personId != null)
{
using (SqlConnection connection = Global.GetSqlConnection())
{
string findPatient = "SELECT TOP(1) * FROM Person WHERE IdPerson = '" + personId + "'";
SqlCommand person = new SqlCommand(findPatient, connection);
using (SqlDataReader personFromDataBase = person.ExecuteReader())
{
PersonWithIdentity p = new PersonWithIdentity();
while (personFromDataBase.Read())
{
if (personFromDataBase["BirthDate"].ToString() != "")
{
p.Birthdate = Convert.ToDateTime(personFromDataBase["BirthDate"]);
}
p.Sex = Convert.ToByte(personFromDataBase["IdSex"]);
}
p.IdPersonMis = mis;
TestPerson pers = new TestPerson(p);
pers.name = TestHumanName.BuildHumanNameFromDataBaseData(personId);
pers.documents = TestIdentityDocument.BuildDocumentsFromDataBaseData(personId);
return(pers);
}
}
}
return(null);
}
public static TestPerson BuildPersonFromDataBaseData(string personId)
{
string mis = GetIDMIS(personId);
if (personId != null)
{
using (SqlConnection connection = Global.GetSqlConnection())
{
string findPatient = "SELECT TOP(1) * FROM Person WHERE IdPerson = '" + personId + "'";
SqlCommand person = new SqlCommand(findPatient, connection);
using (SqlDataReader personFromDataBase = person.ExecuteReader())
{
PersonWithIdentity p = new PersonWithIdentity();
while (personFromDataBase.Read())
{
if (personFromDataBase["BirthDate"].ToString() != "")
p.Birthdate = Convert.ToDateTime(personFromDataBase["BirthDate"]);
p.Sex = Convert.ToByte(personFromDataBase["IdSex"]);
}
p.IdPersonMis = mis;
TestPerson pers = new TestPerson(p);
pers.name = TestHumanName.BuildHumanNameFromDataBaseData(personId);
pers.documents = TestIdentityDocument.BuildDocumentsFromDataBaseData(personId);
return pers;
}
}
}
return null;
}
public TestPerson(PersonWithIdentity p)
{
person = p;
if (person.Sex == 0)
person.Sex = 3;
name = new TestHumanName(p.HumanName);
if ((p.Documents != null) && (Global.GetLength(p.Documents) != 0))
{
List<TestIdentityDocument> doc = new List<TestIdentityDocument>();
foreach (IdentityDocument d in p.Documents)
{
doc.Add(new TestIdentityDocument(d));
}
documents = doc;
}
}
public TestPerson(PersonWithIdentity p)
{
person = p;
if (person.Sex == 0)
{
person.Sex = 3;
}
name = new TestHumanName(p.HumanName);
if ((p.Documents != null) && (Global.GetLength(p.Documents) != 0))
{
List <TestIdentityDocument> doc = new List <TestIdentityDocument>();
foreach (IdentityDocument d in p.Documents)
{
doc.Add(new TestIdentityDocument(d));
}
documents = doc;
}
}
private EMKServise.PersonWithIdentity ConvertPersonWithIdentity(PersonWithIdentity c)
{
if ((object)c != null)
{
EMKServise.PersonWithIdentity ep = new EMKServise.PersonWithIdentity();
if (c.Birthdate != DateTime.MinValue)
{
ep.Birthdate = c.Birthdate;
}
ep.Documents = ConvertDocuments(c.Documents.ToList <IdentityDocument>());
ep.HumanName = ConvertHumanName(c.HumanName);
if (c.IdPersonMis != "")
{
ep.IdPersonMis = c.IdPersonMis;
}
ep.Sex = c.Sex;
return(ep);
}
else
{
return(null);
}
}
private EMKServise.PersonWithIdentity ConvertPersonWithIdentity(PersonWithIdentity c)
{
if ((object)c != null)
{
EMKServise.PersonWithIdentity ep = new EMKServise.PersonWithIdentity();
if (c.Birthdate != DateTime.MinValue)
ep.Birthdate = c.Birthdate;
ep.Documents = ConvertDocuments(c.Documents.ToList<IdentityDocument>());
ep.HumanName = ConvertHumanName(c.HumanName);
if (c.IdPersonMis != "")
ep.IdPersonMis = c.IdPersonMis;
ep.Sex = c.Sex;
return ep;
}
else
return null;
}
