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 override bool Equals(Object obj) { TestIdentityDocument p = obj as TestIdentityDocument; if ((object)p == null) { return(false); } if (this.document == p.document) { return(true); } if ((this.document == null) || (p.document == null)) { return(false); } if ((this.document.DocN == p.document.DocN) && (this.document.DocS == p.document.DocS) && (this.document.ExpiredDate == p.document.ExpiredDate) && (this.document.IdDocumentType == p.document.IdDocumentType) && (this.document.IdProvider == p.document.IdProvider) && (this.document.IssuedDate == p.document.IssuedDate) && (this.document.ProviderName == p.document.ProviderName) && (this.document.RegionCode == p.document.RegionCode)) { return(true); } else { this.FindMismatch(p); Global.errors3.Add("несовпадение TestIdentityDocument"); return(false); } }
private void FindMismatch(TestIdentityDocument b) { if (this.document.DocN != b.document.DocN) { Global.errors3.Add("Несовпадение DocN TestDocument"); } if (this.document.DocS != b.document.DocS) { Global.errors3.Add("Несовпадение DocS TestDocument"); } if (this.document.ExpiredDate != b.document.ExpiredDate) { Global.errors3.Add("Несовпадение ExpiredDate TestDocument"); } if (this.document.IdDocumentType != b.document.IdDocumentType) { Global.errors3.Add("Несовпадение IdDocumentType TestDocument"); } if (this.document.IdProvider != b.document.IdProvider) { Global.errors3.Add("Несовпадение IdProvider TestDocument"); } if (this.document.IssuedDate != b.document.IssuedDate) { Global.errors3.Add("Несовпадение IssuedDate TestDocument"); } if (this.document.ProviderName != b.document.ProviderName) { Global.errors3.Add("Несовпадение ProviderName TestDocument"); } if (this.document.RegionCode != b.document.RegionCode) { Global.errors3.Add("Несовпадение RegionCode TestDocument"); } }
static public List <TestIdentityDocument> BuildDocumentsFromDataBaseData(string idPerson) { List <TestIdentityDocument> documents = new List <TestIdentityDocument>(); using (SqlConnection connection = Global.GetSqlConnection()) { foreach (int i in Enum.GetValues(typeof(docs))) { string findPatient = "SELECT TOP(1) * FROM Document WHERE IdDocument = (SELECT MAX(IdDocument) FROM Document WHERE IdPerson = '" + idPerson + "' AND IdDocumentType = '" + i + "')"; SqlCommand person = new SqlCommand(findPatient, connection); using (SqlDataReader documentReader = person.ExecuteReader()) { // bool a = documentReader.Read(); while (documentReader.Read()) { IdentityDocument doc = new IdentityDocument(); if (documentReader["DocN"].ToString() != "") { doc.DocN = Convert.ToString(documentReader["DocN"]); } if (documentReader["ProviderName"].ToString() != "") { doc.ProviderName = Convert.ToString(documentReader["ProviderName"]); } if (documentReader["IdDocumentType"].ToString() != "") { doc.IdDocumentType = Convert.ToByte(documentReader["IdDocumentType"]); } if (documentReader["DocS"].ToString() != "") { doc.DocS = Convert.ToString(documentReader["DocS"]); } if (documentReader["IdProvider"].ToString() != "") { doc.IdProvider = Convert.ToInt32(documentReader["IdProvider"]); } if (documentReader["IssuedDate"].ToString() != "") { doc.IssuedDate = Convert.ToDateTime(documentReader["IssuedDate"]); } if (documentReader["ExpiredDate"].ToString() != "") { doc.ExpiredDate = Convert.ToDateTime(documentReader["ExpiredDate"]); } if (documentReader["RegionCode"].ToString() != "") { doc.RegionCode = Convert.ToString(documentReader["RegionCode"]); } TestIdentityDocument document = new TestIdentityDocument(doc); documents.Add(document); } } } } if (documents.Count != 0) { return(documents); } else { return(null); } }
public static List<TestIdentityDocument> BuildDocumentsFromDataBaseData(string idPerson) { List<TestIdentityDocument> documents = new List<TestIdentityDocument>(); using (SqlConnection connection = Global.GetSqlConnection()) { foreach (int i in Enum.GetValues(typeof(docs))) { string findPatient = "SELECT TOP(1) * FROM Document WHERE IdDocument = (SELECT MAX(IdDocument) FROM Document WHERE IdPerson = '" + idPerson + "' AND IdDocumentType = '" + i + "')"; SqlCommand person = new SqlCommand(findPatient, connection); using (SqlDataReader documentReader = person.ExecuteReader()) { // bool a = documentReader.Read(); while (documentReader.Read()) { IdentityDocument doc = new IdentityDocument(); if (documentReader["DocN"].ToString() != "") doc.DocN = Convert.ToString(documentReader["DocN"]); if (documentReader["ProviderName"].ToString() != "") doc.ProviderName = Convert.ToString(documentReader["ProviderName"]); if (documentReader["IdDocumentType"].ToString() != "") doc.IdDocumentType = Convert.ToByte(documentReader["IdDocumentType"]); if (documentReader["DocS"].ToString() != "") doc.DocS = Convert.ToString(documentReader["DocS"]); if (documentReader["IdProvider"].ToString() != "") doc.IdProvider = Convert.ToInt32(documentReader["IdProvider"]); if (documentReader["IssuedDate"].ToString() != "") doc.IssuedDate = Convert.ToDateTime(documentReader["IssuedDate"]); if (documentReader["ExpiredDate"].ToString() != "") doc.ExpiredDate = Convert.ToDateTime(documentReader["ExpiredDate"]); if (documentReader["RegionCode"].ToString() != "") doc.RegionCode = Convert.ToString(documentReader["RegionCode"]); TestIdentityDocument document = new TestIdentityDocument(doc); documents.Add(document); } } } } if (documents.Count != 0) return documents; else return null; }
private void FindMismatch(TestIdentityDocument b) { if (this.document.DocN != b.document.DocN) Global.errors3.Add("Несовпадение DocN TestDocument"); if (this.document.DocS != b.document.DocS) Global.errors3.Add("Несовпадение DocS TestDocument"); if (this.document.ExpiredDate != b.document.ExpiredDate) Global.errors3.Add("Несовпадение ExpiredDate TestDocument"); if (this.document.IdDocumentType != b.document.IdDocumentType) Global.errors3.Add("Несовпадение IdDocumentType TestDocument"); if (this.document.IdProvider != b.document.IdProvider) Global.errors3.Add("Несовпадение IdProvider TestDocument"); if (this.document.IssuedDate != b.document.IssuedDate) Global.errors3.Add("Несовпадение IssuedDate TestDocument"); if (this.document.ProviderName != b.document.ProviderName) Global.errors3.Add("Несовпадение ProviderName TestDocument"); if (this.document.RegionCode != b.document.RegionCode) Global.errors3.Add("Несовпадение RegionCode TestDocument"); }