public override bool Equals(Object obj)
{
TestDoctor p = obj as TestDoctor;
if ((object)p == null)
{
return(false);
}
if (this.doctor == p.doctor)
{
return(true);
}
if ((this.doctor == null) || (p.doctor == null))
{
return(false);
}
if ((Global.IsEqual(this.contacts, this.contacts)) &&
(Global.IsEqual(this.lpu, this.lpu)) &&
(Global.IsEqual(this.person, this.person)) &&
(Global.IsEqual(this.position, this.position)) &&
(Global.IsEqual(this.role, this.role)) &&
(Global.IsEqual(this.speciality, this.speciality)))
{
return(true);
}
else
{
this.FindMismatch(p);
Global.errors3.Add("несовпадение TestDoctor");
return(false);
}
}
private void FindMismatch(TestDoctor r)
{
if (Global.GetLength(this.contacts) != Global.GetLength(this.contacts))
{
Global.errors3.Add("Несовпадение длины contacts TestDoctor");
}
if (Global.GetLength(this.lpu) != Global.GetLength(this.lpu))
{
Global.errors3.Add("Несовпадение длины lpu TestDoctor");
}
if (Global.GetLength(this.person) != Global.GetLength(this.person))
{
Global.errors3.Add("Несовпадение длины person TestDoctor");
}
if (Global.GetLength(this.position) != Global.GetLength(this.position))
{
Global.errors3.Add("Несовпадение длины position TestDoctor");
}
if (Global.GetLength(this.role) != Global.GetLength(this.role))
{
Global.errors3.Add("Несовпадение длины role TestDoctor");
}
if (Global.GetLength(this.speciality) != Global.GetLength(this.speciality))
{
Global.errors3.Add("Несовпадение длины speciality TestDoctor");
}
}
static public TestReferralSource BuildSourceFromDataBaseData(string idReferral)
{
using (NpgsqlConnection connection = Global.GetSqlConnection())
{
string findPatient = "SELECT id_source_lpu_case_mis, id_referral_source_mo_mis, id_source_lpu 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())
{
ReferralSource p = new ReferralSource();
while (personFromDataBase.Read())
{
if (personFromDataBase["id_source_lpu_case_mis"] != DBNull.Value)
{
p.IdCaseMis = Convert.ToString(personFromDataBase["id_source_lpu_case_mis"]);
}
if (personFromDataBase["id_referral_source_mo_mis"] != DBNull.Value)
{
p.IdReferralMis = Convert.ToString(personFromDataBase["id_referral_source_mo_mis"]);
}
TestReferralSource pers = new TestReferralSource(p);
pers.lpu = TestCoding.BuildCodingFromDataBaseData(Convert.ToString(personFromDataBase["id_source_lpu"]));
pers.docs = TestDoctor.BuildDoctorFromDataBaseData(idReferral, Convert.ToString(personFromDataBase["id_source_lpu"]));
pers.diag = TestMainDiagnosis.BuildTestMainDiagnosisInfoFromDataBaseData(idReferral, Convert.ToString(personFromDataBase["id_source_lpu"]));
return(pers);
}
}
}
return(new TestReferralSource(null));
}
static public List <TestDoctor> BuildDoctorFromDataBaseData(string idReferral)
{
List <TestDoctor> docs = new List <TestDoctor>();
using (NpgsqlConnection c = Global.GetSqlConnection())
{
string findDoctorsIds = "SELECT * FROM public.referral_doctor WHERE id_referral = '" + idReferral + "'";
NpgsqlCommand fd = new NpgsqlCommand(findDoctorsIds, c);
using (NpgsqlDataReader idr = fd.ExecuteReader())
{
if (idr["id_doctor"] != DBNull.Value)
{
string idDoctor = idr["id_doctor"].ToString();
using (NpgsqlConnection connection = Global.GetSqlConnection())
{
string findDoctor = "SELECT * FROM public.doctor WHERE id_doctor = '" + idDoctor + "' ORDER BY id_doctor DESC LIMIT 1";
NpgsqlCommand doc = new NpgsqlCommand(findDoctor, connection);
using (NpgsqlDataReader doctorFromDataBase = doc.ExecuteReader())
{
Doctor p = new Doctor();
while (doctorFromDataBase.Read())
{
TestDoctor doctor = new TestDoctor(p);
if (doctorFromDataBase["id_doctor_role"] != DBNull.Value)
{
doctor.role = TestCoding.BuildCodingFromDataBaseData(Convert.ToString(doctorFromDataBase["id_doctor_role"]));
}
if (doctorFromDataBase["id_doctor_speciality"] != DBNull.Value)
{
doctor.speciality = TestCoding.BuildCodingFromDataBaseData(Convert.ToString(doctorFromDataBase["id_doctor_speciality"]));
}
if (doctorFromDataBase["id_lpu"] != DBNull.Value)
{
doctor.lpu = TestCoding.BuildCodingFromDataBaseData(Convert.ToString(doctorFromDataBase["id_lpu"]));
}
if (doctorFromDataBase["id_position"] != DBNull.Value)
{
doctor.position = TestCoding.BuildCodingFromDataBaseData(Convert.ToString(doctorFromDataBase["id_position"]));
}
if (doctorFromDataBase["id_person"] != DBNull.Value)
{
doctor.person = TestPerson.BuildPersonFromDataBaseData(Convert.ToString(doctorFromDataBase["id_person"]), Convert.ToString(doctorFromDataBase["id_doctor_mis"]));
}
if (doctorFromDataBase["id_person"] != DBNull.Value)
{
doctor.cnts = TestContact.BuildContactsFromDataBaseData(Convert.ToString(doctorFromDataBase["id_person"]));
}
docs.Add(doctor);
}
}
}
}
}
}
return((docs.Count != 0) ? docs : null);
}
static public TestReferralTarget BuildTargetFromDataBaseData(string idReferral)
{
using (NpgsqlConnection connection = Global.GetSqlConnection())
{
string findPatient = "SELECT id_target_lpu, is_referral_review_target_mo, referral_review_date_target_mo, reception_appoint_date, reception_appoint_time_comment, reception_appoint_additional_comment, id_target_lpu_case_mis FROM public.referral WHERE id_referral = '" + idReferral + "' ORDER BY record_created DESC LIMIT 1";
NpgsqlCommand person = new NpgsqlCommand(findPatient, connection);
using (NpgsqlDataReader personFromDataBase = person.ExecuteReader())
{
ReferralTarget p = new ReferralTarget();
while (personFromDataBase.Read())
{
//зачем тут диагнозы и доктора и ReferralReviewDate и IsReferralReviewed?
if (personFromDataBase["id_target_lpu_case_mis"] != DBNull.Value)
{
p.IdCaseMis = Convert.ToString(personFromDataBase["id_target_lpu_case_mis"]);
}
if (personFromDataBase["is_referral_review_target_mo"] != DBNull.Value)
{
p.IsReferralReviewed = Convert.ToBoolean(personFromDataBase["is_referral_review_target_mo"]);
}
if (personFromDataBase["reception_appoint_additional_comment"] != DBNull.Value)
{
p.ReceptionAppointComment = Convert.ToString(personFromDataBase["reception_appoint_additional_comment"]);
}
if (personFromDataBase["reception_appoint_time_comment"] != DBNull.Value)
{
p.ReceptionAppointTime = Convert.ToString(personFromDataBase["reception_appoint_time_comment"]);
}
if (personFromDataBase["reception_appoint_date"] != DBNull.Value)
{
p.ReceptionAppointDate = Convert.ToDateTime(personFromDataBase["reception_appoint_date"]);
}
if (personFromDataBase["referral_review_date_target_mo"] != DBNull.Value)
{
p.ReferralReviewDate = Convert.ToDateTime(personFromDataBase["referral_review_date_target_mo"]);
}
TestReferralTarget pers = new TestReferralTarget(p);
pers.lpu = TestCoding.BuildCodingFromDataBaseData(Convert.ToString(personFromDataBase["id_target_lpu"]));
pers.docs = TestDoctor.BuildDoctorFromDataBaseData(idReferral,
Convert.ToString(personFromDataBase["id_target_lpu"]));
pers.diag = TestMainDiagnosis.BuildTestMainDiagnosisInfoFromDataBaseData(idReferral,
Convert.ToString(personFromDataBase["id_target_lpu"]));
return(pers);
}
}
}
return(null);
}
public static List<TestDoctor> BuildDoctorFromDataBaseData(string idReferral)
{
List<TestDoctor> docs = new List<TestDoctor>();
using (NpgsqlConnection c = Global.GetSqlConnection())
{
string findDoctorsIds = "SELECT * FROM public.referral_doctor WHERE id_referral = '" + idReferral + "'";
NpgsqlCommand fd = new NpgsqlCommand(findDoctorsIds, c);
using (NpgsqlDataReader idr = fd.ExecuteReader())
{
if (idr["id_doctor"] != DBNull.Value)
{
string idDoctor = idr["id_doctor"].ToString();
using (NpgsqlConnection connection = Global.GetSqlConnection())
{
string findDoctor = "SELECT * FROM public.doctor WHERE id_doctor = '" + idDoctor + "' ORDER BY id_doctor DESC LIMIT 1";
NpgsqlCommand doc = new NpgsqlCommand(findDoctor, connection);
using (NpgsqlDataReader doctorFromDataBase = doc.ExecuteReader())
{
Doctor p = new Doctor();
while (doctorFromDataBase.Read())
{
TestDoctor doctor = new TestDoctor(p);
if (doctorFromDataBase["id_doctor_role"] != DBNull.Value)
doctor.role = TestCoding.BuildCodingFromDataBaseData(Convert.ToString(doctorFromDataBase["id_doctor_role"]));
if (doctorFromDataBase["id_doctor_speciality"] != DBNull.Value)
doctor.speciality = TestCoding.BuildCodingFromDataBaseData(Convert.ToString(doctorFromDataBase["id_doctor_speciality"]));
if (doctorFromDataBase["id_lpu"] != DBNull.Value)
doctor.lpu = TestCoding.BuildCodingFromDataBaseData(Convert.ToString(doctorFromDataBase["id_lpu"]));
if (doctorFromDataBase["id_position"] != DBNull.Value)
doctor.position = TestCoding.BuildCodingFromDataBaseData(Convert.ToString(doctorFromDataBase["id_position"]));
if (doctorFromDataBase["id_person"] != DBNull.Value)
doctor.person = TestPerson.BuildPersonFromDataBaseData(Convert.ToString(doctorFromDataBase["id_person"]), Convert.ToString(doctorFromDataBase["id_doctor_mis"]));
if (doctorFromDataBase["id_person"] != DBNull.Value)
doctor.cnts = TestContact.BuildContactsFromDataBaseData(Convert.ToString(doctorFromDataBase["id_person"]));
docs.Add(doctor);
}
}
}
}
}
}
return (docs.Count != 0) ? docs : null;
}
private void FindMismatch(TestDoctor r)
{
if (Global.GetLength(this.contacts) != Global.GetLength(this.contacts))
Global.errors3.Add("Несовпадение длины contacts TestDoctor");
if (Global.GetLength(this.lpu) != Global.GetLength(this.lpu))
Global.errors3.Add("Несовпадение длины lpu TestDoctor");
if (Global.GetLength(this.person) != Global.GetLength(this.person))
Global.errors3.Add("Несовпадение длины person TestDoctor");
if (Global.GetLength(this.position) != Global.GetLength(this.position))
Global.errors3.Add("Несовпадение длины position TestDoctor");
if (Global.GetLength(this.role) != Global.GetLength(this.role))
Global.errors3.Add("Несовпадение длины role TestDoctor");
if (Global.GetLength(this.speciality) != Global.GetLength(this.speciality))
Global.errors3.Add("Несовпадение длины speciality TestDoctor");
}
