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; }