public override bool Equals(Object obj) { TestAdditional p = obj as TestAdditional; if ((object)p == null) { return(false); } if (this.additional == p.additional) { return(true); } if ((this.additional == null) || (p.additional == null)) { return(false); } if ((this.additional.AllergyIodine == p.additional.AllergyIodine) && (this.additional.Height == p.additional.Height) && (this.additional.Weight == p.additional.Weight)) { return(true); } else { this.FindMismatch(p); Global.errors3.Add("несовпадение TestAdditional"); return(false); } }
static public TestAdditional BuildAdditionalFromDataBaseData(string idReferral) { using (NpgsqlConnection connection = Global.GetSqlConnection()) { string findPatient = "SELECT patient_allergy_iodine, patient_hight, patient_weight FROM public.referral WHERE id_referral = '" + idReferral + "' ORDER BY id_referral DESC LIMIT 1"; NpgsqlCommand person = new NpgsqlCommand(findPatient, connection); using (NpgsqlDataReader personFromDataBase = person.ExecuteReader()) { Additional p = new Additional(); while (personFromDataBase.Read()) { //что делать с DateSpecified и Мисами? if (personFromDataBase["patient_allergy_iodine"] != DBNull.Value) { p.AllergyIodine = Convert.ToString(personFromDataBase["patient_allergy_iodine"]); } if (personFromDataBase["patient_hight"] != DBNull.Value) { p.Height = Convert.ToString(personFromDataBase["patient_hight"]); } if (personFromDataBase["patient_weight"] != DBNull.Value) { p.Weight = Convert.ToString(personFromDataBase["patient_weight"]); } TestAdditional pers = new TestAdditional(p); return(pers); } } } return(null); }
static public TestReferralSurvey BuildAdditionalFromDataBaseData(string idReferral) { using (NpgsqlConnection connection = Global.GetSqlConnection()) { string findPatient = "SELECT id_survey_organ, survey_comment, id_referral, id_survey_type FROM public.referral WHERE id_referral = '" + idReferral + "' ORDER BY id_referral DESC LIMIT 1"; NpgsqlCommand person = new NpgsqlCommand(findPatient, connection); using (NpgsqlDataReader personFromDataBase = person.ExecuteReader()) { Survey p = new Survey(); while (personFromDataBase.Read()) { //что делать с DateSpecified и Мисами? if (personFromDataBase["survey_comment"] != DBNull.Value) { p.Comment = Convert.ToString(personFromDataBase["survey_comment"]); } TestReferralSurvey pers = new TestReferralSurvey(p); if (personFromDataBase["id_referral"] != DBNull.Value) { pers.additional = TestAdditional.BuildAdditionalFromDataBaseData(Convert.ToString(personFromDataBase["id_referral"])); } if (personFromDataBase["id_survey_organ"] != DBNull.Value) { pers.surveyOrgan = TestCoding.BuildCodingFromDataBaseData(Convert.ToString(personFromDataBase["id_survey_organ"])); } if (personFromDataBase["id_survey_type"] != DBNull.Value) { pers.surveyType = TestCoding.BuildCodingFromDataBaseData(Convert.ToString(personFromDataBase["id_survey_type"])); } return(pers); } } } return(null); }
public TestReferralSurvey(Survey r) { survey = r ?? new Survey(); additional = new TestAdditional(survey.Additional); surveyOrgan = new TestCoding(survey.SurveyOrgan); surveyType = new TestCoding(survey.SurveyType); }
public static TestAdditional BuildAdditionalFromDataBaseData(string idReferral) { using (NpgsqlConnection connection = Global.GetSqlConnection()) { string findPatient = "SELECT patient_allergy_iodine, patient_hight, patient_weight FROM public.referral WHERE id_referral = '" + idReferral + "' ORDER BY id_referral DESC LIMIT 1"; NpgsqlCommand person = new NpgsqlCommand(findPatient, connection); using (NpgsqlDataReader personFromDataBase = person.ExecuteReader()) { Additional p = new Additional(); while (personFromDataBase.Read()) { //что делать с DateSpecified и Мисами? if (personFromDataBase["patient_allergy_iodine"] != DBNull.Value) p.AllergyIodine = Convert.ToString(personFromDataBase["patient_allergy_iodine"]); if (personFromDataBase["patient_hight"] != DBNull.Value) p.Height = Convert.ToString(personFromDataBase["patient_hight"]); if (personFromDataBase["patient_weight"] != DBNull.Value) p.Weight = Convert.ToString(personFromDataBase["patient_weight"]); TestAdditional pers = new TestAdditional(p); return pers; } } } return null; }
public TestReferralSurvey(Survey r) { if (r != null) survey = r; else survey = new Survey(); additional = new TestAdditional(survey.Additional); if (survey.SurveyOrgan != null) surveyOrgan = new TestCoding(survey.SurveyOrgan); if (survey.SurveyType != null) surveyType = new TestCoding(survey.SurveyType); }
private void FindMismatch(TestAdditional r) { if (this.additional.AllergyIodine != r.additional.AllergyIodine) { Global.errors3.Add("Несовпадение AllergyIodine TestAdditional"); } if (this.additional.Height != r.additional.Height) { Global.errors3.Add("Несовпадение Height TestAdditional"); } if (this.additional.Weight != r.additional.Weight) { Global.errors3.Add("Несовпадение Weight TestAdditional"); } }
public TestReferralSurvey(Survey r) { if (r != null) { survey = r; } else { survey = new Survey(); } additional = new TestAdditional(survey.Additional); if (survey.SurveyOrgan != null) { surveyOrgan = new TestCoding(survey.SurveyOrgan); } if (survey.SurveyType != null) { surveyType = new TestCoding(survey.SurveyType); } }
private void FindMismatch(TestAdditional r) { if (this.additional.AllergyIodine != r.additional.AllergyIodine) Global.errors3.Add("Несовпадение AllergyIodine TestAdditional"); if (this.additional.Height != r.additional.Height) Global.errors3.Add("Несовпадение Height TestAdditional"); if (this.additional.Weight != r.additional.Weight) Global.errors3.Add("Несовпадение Weight TestAdditional"); }