public static TestProfileMedService BuildProfileMedServiceFromDataBaseData(string idLPU) { using (NpgsqlConnection connection = Global.GetSqlConnection()) { string findProfileMedService = "SELECT * FROM public.lpu_profile WHERE id_lpu = '" + idLPU + "'"; NpgsqlCommand person = new NpgsqlCommand(findProfileMedService, connection); using (NpgsqlDataReader ProfileMedServiceReader = person.ExecuteReader()) { while (ProfileMedServiceReader.Read()) { ProfileMedService profileMedService = new ProfileMedService(); if (ProfileMedServiceReader["address"] != DBNull.Value) profileMedService.Address = Convert.ToString(ProfileMedServiceReader["address"]); if (ProfileMedServiceReader["comment"] != DBNull.Value) profileMedService.Comment = Convert.ToString(ProfileMedServiceReader["comment"]); if (ProfileMedServiceReader["contact_value"] != DBNull.Value) profileMedService.ContactValue = Convert.ToString(ProfileMedServiceReader["contact_value"]); if (ProfileMedServiceReader["date_end"] != DBNull.Value) profileMedService.EndDate = Convert.ToDateTime(ProfileMedServiceReader["date_end"]); if (ProfileMedServiceReader["site"] != DBNull.Value) profileMedService.Site = Convert.ToString(ProfileMedServiceReader["site"]); if (ProfileMedServiceReader["date_begin"] != DBNull.Value) profileMedService.StartDate = Convert.ToDateTime(ProfileMedServiceReader["date_begin"]); TestProfileMedService tProfileMedService = new TestProfileMedService(profileMedService); if (ProfileMedServiceReader["id_profile_med_service"] != DBNull.Value) tProfileMedService.idProfileMedService = TestCoding.BuildCodingFromDataBaseData(Convert.ToString(ProfileMedServiceReader["id_profile_med_service"])); return tProfileMedService; } } } return null; }
static public TestProfileMedService BuildProfileMedServiceFromDataBaseData(string idLPU) { using (NpgsqlConnection connection = Global.GetSqlConnection()) { string findProfileMedService = "SELECT * FROM public.lpu_profile WHERE id_lpu = '" + idLPU + "'"; NpgsqlCommand person = new NpgsqlCommand(findProfileMedService, connection); using (NpgsqlDataReader ProfileMedServiceReader = person.ExecuteReader()) { while (ProfileMedServiceReader.Read()) { ProfileMedService profileMedService = new ProfileMedService(); if (ProfileMedServiceReader["address"] != DBNull.Value) { profileMedService.Address = Convert.ToString(ProfileMedServiceReader["address"]); } if (ProfileMedServiceReader["comment"] != DBNull.Value) { profileMedService.Comment = Convert.ToString(ProfileMedServiceReader["comment"]); } if (ProfileMedServiceReader["contact_value"] != DBNull.Value) { profileMedService.ContactValue = Convert.ToString(ProfileMedServiceReader["contact_value"]); } if (ProfileMedServiceReader["date_end"] != DBNull.Value) { profileMedService.EndDate = Convert.ToDateTime(ProfileMedServiceReader["date_end"]); } if (ProfileMedServiceReader["site"] != DBNull.Value) { profileMedService.Site = Convert.ToString(ProfileMedServiceReader["site"]); } if (ProfileMedServiceReader["date_begin"] != DBNull.Value) { profileMedService.StartDate = Convert.ToDateTime(ProfileMedServiceReader["date_begin"]); } TestProfileMedService tProfileMedService = new TestProfileMedService(profileMedService); if (ProfileMedServiceReader["id_profile_med_service"] != DBNull.Value) { tProfileMedService.idProfileMedService = TestCoding.BuildCodingFromDataBaseData(Convert.ToString(ProfileMedServiceReader["id_profile_med_service"])); } return(tProfileMedService); } } } return(null); }
public void UpdateMedServiceProfile(Credentials cr, ProfileMedService p) { try { client.UpdateMedServiceProfile(cr, p); if (new TestProfileMedService(p) != TestProfileMedService.BuildProfileMedServiceFromDataBaseData(cr.Organization)) { Global.errors1.Add("Несовпадение"); Global.errors1.AddRange(Global.errors2); } } catch (System.ServiceModel.FaultException <MqTests.WebReference.MqFault> e) { getErrors(e.Detail); Global.errors1.Add("ЭКСЕПШН"); } }
public void FullUpdateMedServiceProfile() { using (MqServiceClient mq = new MqServiceClient()) { Credentials cr = new Credentials { Organization = idLpu, Token = guid }; ProfileMedService medServ = (new SetData()).FullUpdateMedServiceProfile(); mq.UpdateMedServiceProfile(cr, medServ); Options options = new Options { DateReport = OptionData.options.DateReport, Target = new ReferralTarget { Lpu = new Coding { Code = idLpu, System = Dictionary.MO, Version = "1" } }, ReferralInfo = new ReferralInfo { ProfileMedService = medServ.IdProfileMedService } }; var result = mq.GetQueueInfo(cr, options); } if (Global.errors == "") { Assert.Pass(); } else { Assert.Fail(Global.errors); } }
public TestProfileMedService(ProfileMedService j) { profileMedService = j; }
public void UpdateMedServiceProfile(Credentials cr, ProfileMedService p) { try { client.UpdateMedServiceProfile(cr, p); if (new TestProfileMedService(p) != TestProfileMedService.BuildProfileMedServiceFromDataBaseData(cr.Organization)) { Global.errors1.Add("Несовпадение"); Global.errors1.AddRange(Global.errors2); } } catch (System.ServiceModel.FaultException<MqTests.WebReference.MqFault[]> e) { getErrors(e.Detail); } catch (System.ServiceModel.FaultException<MqTests.WebReference.MqFault> e) { Global.errors1.Add(e.Detail.PropertyName + " - " + e.Detail.Message); } }