static public TestClinicMainDiagnosis BuildTestClinicMainDiagnosisFromDataBaseDate(string idStep)
{
using (SqlConnection connection = Global.GetSqlConnection())
{
string findTD = "SELECT TOP(1) * FROM Diagnosis WHERE IdDiagnosis = (SELECT MAX(IdDiagnosis) FROM Diagnosis WHERE IdStep = '" + idStep + "' AND IdDiagnosisType = '" + TestDiagnosis.IdClinicMainDiagnosis + "' AND IdParentDiagnosis is NULL)";
SqlCommand TDcommand = new SqlCommand(findTD, connection);
using (SqlDataReader TDReader = TDcommand.ExecuteReader())
{
while (TDReader.Read())
{
if (TDReader["IdParentDiagnosis"].ToString() == "")
{
ClinicMainDiagnosis d = new ClinicMainDiagnosis();
TestClinicMainDiagnosis td = new TestClinicMainDiagnosis(d);
td._diagnosis = TestDiagnosis.BuildDiagnosisFromDataBaseDate(idStep, TDReader["IdDiagnosis"].ToString());
td.diagnosInfo = TestDiagnosisInfo.BuildDiagnosisFromDataBaseDate(TDReader["IdDiagnosis"].ToString());
if (TDReader["IdDiagnosedDoctor"].ToString() != "")
{
td.doctor = TestDoctor.BuildTestDoctorFromDataBase(TDReader["IdDiagnosedDoctor"].ToString());
}
return(td);
}
}
}
}
return(null);
}
static public List <TestLaboratoryReport> BuildLaboratoryReportFromDataBaseData(string idStep)
{
List <TestLaboratoryReport> llr = new List <TestLaboratoryReport>();
if (idStep != "")
{
List <TestAttachment> lta = TestAttachment.BuildTestAttacmentFromDataBase(idStep, idLaboratoryReport);
if (lta != null)
{
foreach (TestAttachment i in lta)
{
LaboratoryReport r = new LaboratoryReport();
r.CreationDate = i.CreationDate;
r.Header = i.DocHead;
TestLaboratoryReport tr = new TestLaboratoryReport(r);
tr.attachment = i;
tr.doctor = TestDoctor.BuildTestDoctorFromDataBase(i.IdDoctor);
llr.Add(tr);
}
}
}
if (llr.Count != 0)
{
return(llr);
}
else
{
return(null);
}
}
static public List <TestForm027U> BuildForm027UFromDataBaseData(string idStep)
{
List <TestForm027U> form = new List <TestForm027U>();
if (idStep != "")
{
List <TestAttachment> lta = TestAttachment.BuildTestAttacmentFromDataBase(idStep, idForm027U);
if (lta != null)
{
foreach (TestAttachment i in lta)
{
Form027U r = new Form027U();
r.CreationDate = i.CreationDate;
r.Header = i.DocHead;
TestForm027U tr = new TestForm027U(r);
tr.attachment = i;
tr.doctor = TestDoctor.BuildTestDoctorFromDataBase(i.IdDoctor);
form.Add(tr);
}
}
}
if (form.Count != 0)
{
return(form);
}
else
{
return(null);
}
}
static public TestParticipant BuildTestParticipantFromDataBase(string idCase, string idDoctor, byte idPersonRole)
{
Participant p = new Participant();
p.IdRole = idPersonRole;
TestParticipant part = new TestParticipant(p);
part.doctor = TestDoctor.BuildTestDoctorFromDataBase(idDoctor);
return(part);
}
public bool CheckDoctorInDataBase(string mis)
{
TestDoctor doc = TestDoctor.BuildTestDoctorFromDataBase(mis);
if (this != doc)
{
this.FindMismatch(doc);
return(false);
}
return(true);
}
static public List <TestDiagnosis> BuildDiagnosisFromDataBaseDate(string IdStep, string IdParentDiagnosis = "")
{
List <TestDiagnosis> tdList = new List <TestDiagnosis>();
if (IdStep != "")
{
using (SqlConnection connection = Global.GetSqlConnection())
{
string findTD = "";
if (IdParentDiagnosis == "")
{
findTD = "SELECT * FROM Diagnosis WHERE IdStep = '" + IdStep + "' AND IdDiagnosisType <> '" + IdClinicMainDiagnosis + "' AND IdParentDiagnosis IS NULL";
}
else
{
findTD = "SELECT * FROM Diagnosis WHERE IdStep = '" + IdStep + "' AND IdDiagnosisType <> '" + IdClinicMainDiagnosis + "' AND IdParentDiagnosis = '" + IdParentDiagnosis + "'";
}
SqlCommand TDcommand = new SqlCommand(findTD, connection);
using (SqlDataReader TDReader = TDcommand.ExecuteReader())
{
while (TDReader.Read())
{
Diagnosis d = new Diagnosis();
TestDiagnosis td = new TestDiagnosis(d);
td.info = TestDiagnosisInfo.BuildDiagnosisFromDataBaseDate(TDReader["IdDiagnosis"].ToString());
if (TDReader["IdDiagnosedDoctor"].ToString() != "")
{
td.doctor = TestDoctor.BuildTestDoctorFromDataBase(TDReader["IdDiagnosedDoctor"].ToString());
}
tdList.Add(td);
}
}
}
}
if (tdList.Count != 0)
{
return(tdList);
}
else
{
return(null);
}
}
static public List <TestRecommendation> BuildSickListFromDataBaseData(string idDispensaryStage1)
{
List <TestRecommendation> llr = new List <TestRecommendation>();
if (idDispensaryStage1 != "")
{
using (SqlConnection connection = Global.GetSqlConnection())
{
string findR = "SELECT * FROM Recommendation WHERE idDispensaryStage1 = '" + idDispensaryStage1 + "'";
SqlCommand Rcommand = new SqlCommand(findR, connection);
using (SqlDataReader RReader = Rcommand.ExecuteReader())
{
while (RReader.Read())
{
Recommendation r = new Recommendation();
if (RReader["Text"].ToString() != "")
{
r.Text = RReader["Text"].ToString();
}
if (RReader["Date"].ToString() != "")
{
r.Date = Convert.ToDateTime(RReader["Date"]);
}
TestRecommendation tr = new TestRecommendation(r);
if (RReader["IdDoctor"].ToString() != "")
{
tr.doctor = TestDoctor.BuildTestDoctorFromDataBase(RReader["IdDoctor"].ToString());
}
llr.Add(tr);
}
}
}
}
if (llr.Count != 0)
{
return(llr);
}
else
{
return(null);
}
}
static public TestDischargeSummary BuildSickListFromDataBaseData(string idStep)
{
if (idStep != "")
{
List <TestAttachment> lta = TestAttachment.BuildTestAttacmentFromDataBase(idStep, idEpicrisis);
if (lta != null)
{
foreach (TestAttachment i in lta)
{
DischargeSummary r = new DischargeSummary();
r.CreationDate = i.CreationDate;
r.Header = i.DocHead;
TestDischargeSummary tr = new TestDischargeSummary(r);
tr.attachment = i;
tr.doctor = TestDoctor.BuildTestDoctorFromDataBase(i.IdDoctor);
return(tr);
}
}
}
return(null);
}
static public TestConsultNote BuildSickListFromDataBaseData(string idStep)
{
if (idStep != "")
{
List <TestAttachment> lta = TestAttachment.BuildTestAttacmentFromDataBase(idStep, idConsultNote);
if (lta != null)
{
foreach (TestAttachment i in lta)
{
ConsultNote r = new ConsultNote();
r.CreationDate = i.CreationDate;
r.Header = i.DocHead;
TestConsultNote tr = new TestConsultNote(r);
tr.attachment = i;
tr.doctor = TestDoctor.BuildTestDoctorFromDataBase(i.IdDoctor);
return(tr);
}
}
}
return(null);
}
static public TestCaseBase BuildBaseCaseFromDataBaseData(string guid, string idlpu, string mis, string idPerson)
{
//idPerson = TestPerson.GetPersonId(guid, idlpu, idPerson);
string caseId = GetCaseId(guid, idlpu, mis, idPerson);
if (caseId != null)
{
using (SqlConnection connection = Global.GetSqlConnection())
{
string IdDoctor = "";
string IdGuardian = "";
int idCaseT = 0;
bool isCanceld = false;
CaseBase p = new CaseBase();
string findCase = "SELECT TOP(1) * FROM \"Case\" WHERE IdCase = '" + caseId + "'";
SqlCommand caseCommand = new SqlCommand(findCase, connection);
using (SqlDataReader caseReader = caseCommand.ExecuteReader())
{
while (caseReader.Read())
{
if (caseReader["CloseDate"].ToString() != "")
{
p.CloseDate = Convert.ToDateTime(caseReader["CloseDate"]);
}
else
{
p.CloseDate = DateTime.MinValue;
}
if (caseReader["Comment"].ToString() != "")
{
p.Comment = Convert.ToString(caseReader["Comment"]);
}
else
{
p.Comment = null;
}
if (caseReader["HistoryNumber"].ToString() != "")
{
p.HistoryNumber = Convert.ToString(caseReader["HistoryNumber"]);
}
else
{
p.HistoryNumber = null;
}
if (caseReader["IdCaseAidType"].ToString() != "")
{
p.IdCaseAidType = Convert.ToByte(caseReader["IdCaseAidType"]);
}
else
{
p.IdCaseAidType = 0;
}
if (caseReader["IdCaseMis"].ToString() != "")
{
p.IdCaseMis = Convert.ToString(caseReader["IdCaseMis"]);
}
else
{
p.IdCaseMis = null;
}
if (caseReader["IdCaseResult"].ToString() != "")
{
p.IdCaseResult = Convert.ToByte(caseReader["IdCaseResult"]);
}
else
{
p.IdCaseResult = 0;
}
if (caseReader["IdCasePaymentType"].ToString() != "")
{
p.IdPaymentType = Convert.ToByte(caseReader["IdCasePaymentType"]);
}
else
{
p.IdPaymentType = 0;
}
if (caseReader["OpenDate"].ToString() != "")
{
p.OpenDate = Convert.ToDateTime(caseReader["OpenDate"]);
}
else
{
p.OpenDate = DateTime.MinValue;
}
if (caseReader["IDDoctor"].ToString() != "")
{
IdDoctor = Convert.ToString(caseReader["IDDoctor"]);
}
if (caseReader["IdGuardian"].ToString() != "")
{
IdGuardian = Convert.ToString(caseReader["IDGuardian"]);
}
if (caseReader["IdCaseType"].ToString() != "")
{
idCaseT = Convert.ToInt32(caseReader["IdCaseType"]);
}
isCanceld = Convert.ToBoolean(caseReader["IsCancelled"]);
}
}
findCase = "SELECT * FROM mm_AccessRole2Case WHERE IdCase = '" + caseId + "'";
caseCommand = new SqlCommand(findCase, connection);
using (SqlDataReader caseReader = caseCommand.ExecuteReader())
{
while (caseReader.Read())
{
switch (caseReader["IdAccessRole"].ToString())
{
case "1":
p.Confidentiality = Convert.ToByte(caseReader["IdPrivacyLevel"]);
break;
case "2":
p.DoctorConfidentiality = Convert.ToByte(caseReader["IdPrivacyLevel"]);
break;
case "3":
p.CuratorConfidentiality = Convert.ToByte(caseReader["IdPrivacyLevel"]);
break;
}
}
}
p.IdCaseMis = mis;
p.IdLpu = idlpu;
TestCaseBase cb = new TestCaseBase(guid, p);
cb.idCaseType = idCaseT;
cb.isCanceld = isCanceld;
if (IdDoctor != "")
{
cb.doctorInCharge = TestDoctor.BuildTestDoctorFromDataBase(IdDoctor);
}
else
{
cb.doctorInCharge = null;
}
if (IdGuardian != "")
{
cb.guardian = TestGuardian.BuildTestGuardianFromDataBase(IdGuardian, idPerson);
}
else
{
cb.guardian = null;
}
if (idPerson != "")
{
cb.patient = TestPatient.BuildPatientFromDataBaseData(patientId: idPerson);
}
else
{
cb.patient = null;
}
findCase = "SELECT * FROM mm_Author2Case WHERE IdCase = '" + caseId + "'";
caseCommand = new SqlCommand(findCase, connection);
using (SqlDataReader caseReader = caseCommand.ExecuteReader())
{
while (caseReader.Read())
{
switch (caseReader["IdAuthorshipType"].ToString())
{
case "1":
cb.autor = TestParticipant.BuildTestParticipantFromDataBase(caseId, Convert.ToString(caseReader["IdDoctor"]), 1);
break;
case "3":
cb.authenticator = TestParticipant.BuildTestParticipantFromDataBase(caseId, Convert.ToString(caseReader["IdDoctor"]), 3);
break;
case "4":
cb.legalAuthenticator = TestParticipant.BuildTestParticipantFromDataBase(caseId, Convert.ToString(caseReader["IdDoctor"]), 4);
break;
}
}
}
return(cb);
}
}
return(null);
}
static public List <TestStepBase> BuildTestStepsFromDataBase(string idCase, string stepLpu)
{
List <TestStepBase> steps = new List <TestStepBase>();
if (idCase != string.Empty)
{
using (SqlConnection connection = Global.GetSqlConnection())
{
string findSteps = "SELECT * FROM Step WHERE IdCase = '" + idCase + "'";
SqlCommand stepsCommand = new SqlCommand(findSteps, connection);
using (SqlDataReader stepsReader = stepsCommand.ExecuteReader())
{
while (stepsReader.Read())
{
StepBase sb = new StepBase();
if (stepsReader["Comment"].ToString() != "")
{
sb.Comment = Convert.ToString(stepsReader["Comment"]);
}
else
{
sb.Comment = null;
}
if (stepsReader["DateEnd"].ToString() != "")
{
sb.DateEnd = Convert.ToDateTime(stepsReader["DateEnd"]);
}
else
{
sb.DateEnd = DateTime.MinValue;
}
if (stepsReader["DateStart"].ToString() != "")
{
sb.DateStart = Convert.ToDateTime(stepsReader["DateStart"]);
}
else
{
sb.DateStart = DateTime.MinValue;
}
if (stepsReader["IdPaymentType"].ToString() != "")
{
sb.IdPaymentType = Convert.ToByte(stepsReader["IdPaymentType"]);
}
else
{
sb.IdPaymentType = 0;
}
if (stepsReader["IdStepMis"].ToString() != "")
{
sb.IdStepMis = Convert.ToString(stepsReader["IdStepMis"]);
}
else
{
sb.IdStepMis = null;
}
TestStepBase step = new TestStepBase(sb, stepLpu);
if (stepsReader["IdDoctor"].ToString() != "")
{
step.doctor = TestDoctor.BuildTestDoctorFromDataBase(stepsReader["IdDoctor"].ToString());
}
else
{
step.doctor = null;
}
step.idStep = Convert.ToString(stepsReader["IdStep"]);
steps.Add(step);
}
}
}
}
if (steps.Count != 0)
{
return(steps);
}
else
{
return(null);
}
}
static public List <TestSickList> BuildSickListFromDataBaseData(string idStep, string patientId)
{
List <TestSickList> tsl = new List <TestSickList>();
if (idStep != "")
{
List <TestAttachment> lta = TestAttachment.BuildTestAttacmentFromDataBase(idStep, idSickList);
if (lta != null)
{
foreach (TestAttachment i in lta)
{
using (SqlConnection connection = Global.GetSqlConnection())
{
string findSL = "SELECT * FROM SickList WHERE IdMedDocument = '" + i.idMedDocument + "'";
SqlCommand SLcommand = new SqlCommand(findSL, connection);
using (SqlDataReader SLReader = SLcommand.ExecuteReader())
{
while (SLReader.Read())
{
SickList r = new SickList();
r.SickListInfo = new SickListInfo();
if (SLReader["Number"].ToString() != "")
{
r.SickListInfo.Number = Convert.ToString(SLReader["Number"]);
}
if (SLReader["DateStart"].ToString() != "")
{
r.SickListInfo.DateStart = Convert.ToDateTime(SLReader["DateStart"]);
}
if (SLReader["DateEnd"].ToString() != "")
{
r.SickListInfo.DateEnd = Convert.ToDateTime(SLReader["DateEnd"]);
}
if (SLReader["IdRDisabilityDocStatus"].ToString() != "")
{
r.SickListInfo.DisabilityDocState = Convert.ToByte(SLReader["IdRDisabilityDocStatus"]);
}
if (SLReader["IdRDisabilityDocReason"].ToString() != "")
{
r.SickListInfo.DisabilityDocReason = Convert.ToByte(SLReader["IdRDisabilityDocReason"]);
}
if (SLReader["IsPatient"].ToString() != "")
{
r.SickListInfo.IsPatientTaker = Convert.ToBoolean(SLReader["IsPatient"]);
}
r.CreationDate = i.CreationDate;
r.Header = i.DocHead;
TestSickList tr = new TestSickList(r);
tr.attachment = i;
tr.doctor = TestDoctor.BuildTestDoctorFromDataBase(i.IdDoctor);
if (SLReader["IdCareGiver"].ToString() != "")
{
tr.guardian = TestGuardian.BuildTestGuardianFromDataBase(SLReader["IdCareGiver"].ToString(), patientId);
}
tsl.Add(tr);
}
}
}
}
}
}
if (tsl.Count != 0)
{
return(tsl);
}
else
{
return(null);
}
}
//public TestReferral(ReferralDto r)
//{
// referral = new Referral
// {
// ReferralInfo = new ReferralInfo
// {
// IdReferralType = Convert.ToByte(r.IdReferralType),
// IdReferralMis = r.IdReferralMis,
// IssuedDateTime = r.IssuedDateTime,
// //r.IdUrgencyType;
// MkbCode = r.MkbCode,
// Reason = r.Reason
// },
// IdSourceLpu = r.IdSourceLpu,
// IdTargetLpu = r.IdTargetLpu,
// //r.IdLPU;
// };
// attachment = new TestAttachment(new MedDocument.DocumentAttachment());
// doctor = TestDoctor.BuildTestDoctorFromDataBase(r.IdDoctorRef);
// departmentHead = TestDoctor.BuildTestDoctorFromDataBase(r.IdRefDepartmentHead);
//}
static public List <TestReferral> BuildReferralFromDataBaseData(string idStep)
{
List <TestReferral> trl = new List <TestReferral>();
if (idStep != "")
{
List <TestAttachment> lta = TestAttachment.BuildTestAttacmentFromDataBase(idStep, idReferral);
if (lta != null)
{
foreach (TestAttachment i in lta)
{
using (SqlConnection connection = Global.GetSqlConnection())
{
string findR = "SELECT * FROM Referral WHERE IdMedDocument = '" + i.idMedDocument + "'";
SqlCommand Rcommand = new SqlCommand(findR, connection);
using (SqlDataReader RReader = Rcommand.ExecuteReader())
{
while (RReader.Read())
{
Referral r = new Referral();
r.ReferralInfo = new ReferralInfo();
if (RReader["MkbCode"].ToString() != "")
{
r.ReferralInfo.MkbCode = Convert.ToString(RReader["MkbCode"]);
}
if (RReader["IdSourceLpu"].ToString() != "")
{
r.IdSourceLpu = Global.GetIdIdLpu(Convert.ToString(RReader["IdSourceLpu"]));
}
if (RReader["IdTargetLpu"].ToString() != "")
{
r.IdTargetLpu = Global.GetIdIdLpu(Convert.ToString(RReader["IdTargetLpu"]));
}
if (RReader["Reason"].ToString() != "")
{
r.ReferralInfo.Reason = Convert.ToString(RReader["Reason"]);
}
if (RReader["IdReferralMIS"].ToString() != "")
{
r.ReferralInfo.IdReferralMis = Convert.ToString(RReader["IdReferralMIS"]);
}
if (RReader["IdReferralType"].ToString() != "")
{
r.ReferralInfo.IdReferralType = Convert.ToByte(RReader["IdReferralType"]);
}
if (RReader["IssuedDateTime"].ToString() != "")
{
r.ReferralInfo.IssuedDateTime = Convert.ToDateTime(RReader["IssuedDateTime"]);
}
if (RReader["IdHospitalizationOrder"].ToString() != "")
{
r.ReferralInfo.HospitalizationOrder = Convert.ToByte(RReader["IdHospitalizationOrder"]);
}
if (RReader["ReferralId"].ToString() != "")
{
r.ReferralID = Convert.ToString(RReader["ReferralId"]);
}
if (RReader["RelatedId"].ToString() != "")
{
r.RelatedID = Convert.ToString(RReader["RelatedId"]);
}
r.CreationDate = i.CreationDate;
r.Header = i.DocHead;
//Тут нет ReferalId и referedId
TestReferral tr = new TestReferral(r);
tr.attachment = i;
if (RReader["IdRefDepartmentHead"].ToString() != "")
{
tr.departmentHead = TestDoctor.BuildTestDoctorFromDataBase((RReader["IdRefDepartmentHead"]).ToString());
}
tr.doctor = TestDoctor.BuildTestDoctorFromDataBase(i.IdDoctor);
trl.Add(tr);
}
}
}
}
}
}
if (trl.Count != 0)
{
return(trl);
}
else
{
return(null);
}
}
static public TestDispensaryOne BuildSickListFromDataBaseData(string idStep)
{
if (idStep != "")
{
List <TestAttachment> lta = TestAttachment.BuildTestAttacmentFromDataBase(idStep, idDispensaryOne);
if (lta != null)
{
foreach (TestAttachment i in lta)
{
using (SqlConnection connection = Global.GetSqlConnection())
{
string findDO = "SELECT TOP(1) * FROM DispensaryStage1, DispensaryStage1HealthGroup WHERE DispensaryStage1.idDispensaryStage1 = (SELECT MAX(idDispensaryStage1) FROM DispensaryStage1 WHERE IdMedDocument = '" + i.idMedDocument + "') AND DispensaryStage1.idDispensaryStage1 = DispensaryStage1HealthGroup.idDispensaryStage1";
SqlCommand DOcommand = new SqlCommand(findDO, connection);
using (SqlDataReader DOReader = DOcommand.ExecuteReader())
{
while (DOReader.Read())
{
DispensaryOne r = new DispensaryOne();
r.HealthGroup = new HealthGroup();
r.HealthGroup.HealthGroupInfo = new HealthGroupInfo();
if (DOReader["IsGuested"].ToString() != "")
{
r.IsGuested = Convert.ToBoolean(DOReader["IsGuested"]);
}
if (DOReader["HasExtraResearchRefferal"].ToString() != "")
{
r.HasExtraResearchRefferal = Convert.ToBoolean(DOReader["HasExtraResearchRefferal"]);
}
if (DOReader["IsUnderObservation"].ToString() != "")
{
r.IsUnderObservation = Convert.ToBoolean(DOReader["IsUnderObservation"]);
}
if (DOReader["HasExpertCareRefferal"].ToString() != "")
{
r.HasExpertCareRefferal = Convert.ToBoolean(DOReader["HasExpertCareRefferal"]);
}
if (DOReader["HasPrescribeCure"].ToString() != "")
{
r.HasPrescribeCure = Convert.ToBoolean(DOReader["HasPrescribeCure"]);
}
if (DOReader["HasHealthResortRefferal"].ToString() != "")
{
r.HasHealthResortRefferal = Convert.ToBoolean(DOReader["HasHealthResortRefferal"]);
}
if (DOReader["HasSecondStageRefferal"].ToString() != "")
{
r.HasSecondStageRefferal = Convert.ToBoolean(DOReader["HasSecondStageRefferal"]);
}
if (DOReader["IdHealthGroup"].ToString() != "")
{
r.HealthGroup.HealthGroupInfo.IdHealthGroup = Convert.ToByte(DOReader["IdHealthGroup"]);
}
if (DOReader["Date"].ToString() != "")
{
r.HealthGroup.HealthGroupInfo.Date = Convert.ToDateTime(DOReader["Date"]);
}
r.Header = i.DocHead;
r.CreationDate = i.CreationDate;
TestDispensaryOne tdo = new TestDispensaryOne(r);
if (DOReader["IdDoctor"].ToString() != "")
{
tdo.hdDoctor = TestDoctor.BuildTestDoctorFromDataBase((DOReader["IdDoctor"]).ToString());
}
if (DOReader["idDispensaryStage1"].ToString() != "")
{
tdo.recom = TestRecommendation.BuildSickListFromDataBaseData(DOReader["idDispensaryStage1"].ToString());
}
tdo.doctor = TestDoctor.BuildTestDoctorFromDataBase(i.IdDoctor);
tdo.attachment = i;
return(tdo);
}
}
}
}
}
}
return(null);
}
static public List <TestAppointedMedication> BuildAppointedMedicationFromDataBaseDate(string idStep)
{
List <TestAppointedMedication> amList = new List <TestAppointedMedication>();
if (idStep != "")
{
using (SqlConnection connection = Global.GetSqlConnection())
{
string findAM = "SELECT * FROM PrescribedMedication WHERE PrescribedMedication.IdStep = '" + idStep + "'";
SqlCommand AMcommand = new SqlCommand(findAM, connection);
using (SqlDataReader AMReader = AMcommand.ExecuteReader())
{
while (AMReader.Read())
{
AppointedMedication a = new AppointedMedication();
if (AMReader["PrescriptionNo"].ToString() != "")
{
a.Number = AMReader["PrescriptionNo"].ToString();
}
if (AMReader["PrescriptionSeries"].ToString() != "")
{
a.Seria = AMReader["PrescriptionSeries"].ToString();
}
if (AMReader["IdRMedicineIssueType"].ToString() != "")
{
a.MedicineIssueType = Convert.ToString(AMReader["IdRMedicineIssueType"]);
}
if (AMReader["MedicineIssueTypeDate"].ToString() != "")
{
a.IssuedDate = Convert.ToDateTime(AMReader["MedicineIssueTypeDate"]);
}
if (AMReader["IdRMedicineType"].ToString() != "")
{
a.MedicineType = Convert.ToUInt16(AMReader["IdRMedicineType"]);
}
if (AMReader["IdRAnatomicTherapeuticChemicalClassification"].ToString() != "")
{
using (SqlConnection connection2 = Global.GetSqlConnection())
{
string findCode = "SELECT * FROM nsi.RAnatomicTherapeuticChemicalClassification WHERE IdRAnatomicTherapeuticChemicalClassification = '" + AMReader["IdRAnatomicTherapeuticChemicalClassification"].ToString() + "'";
SqlCommand codeCommand = new SqlCommand(findCode, connection2);
using (SqlDataReader codeReader = codeCommand.ExecuteReader())
{
while (codeReader.Read())
{
if (codeReader["code"].ToString() != "")
{
a.AnatomicTherapeuticChemicalClassification = Convert.ToString(codeReader["code"]);
}
}
}
}
}
if (AMReader["IdRMedicineUseWay"].ToString() != "")
{
a.MedicineUseWay = Convert.ToByte(AMReader["IdRMedicineUseWay"]);
}
if (AMReader["TreatmentDays"].ToString() != "")
{
a.DaysCount = Convert.ToUInt16(AMReader["TreatmentDays"]);
}
if (AMReader["MedecineName"].ToString() != "")
{
a.MedicineName = AMReader["MedecineName"].ToString();
}
TestAppointedMedication ta = new TestAppointedMedication(a);
if (AMReader["CourseDose"].ToString() != "")
{
ta.courseDose = TestQuantity.BuildQuantityFromDataBaseData(AMReader["CourseDose"].ToString());
}
if (AMReader["DayDose"].ToString() != "")
{
ta.dayDose = TestQuantity.BuildQuantityFromDataBaseData(AMReader["DayDose"].ToString());
}
if (AMReader["SingleDose"].ToString() != "")
{
ta.oneTimeDose = TestQuantity.BuildQuantityFromDataBaseData(AMReader["SingleDose"].ToString());
}
if (AMReader["IdDoctor"].ToString() != "")
{
ta.doctor = TestDoctor.BuildTestDoctorFromDataBase(AMReader["IdDoctor"].ToString());
}
amList.Add(ta);
}
}
}
}
if (amList.Count == 0)
{
return(null);
}
else
{
return(amList);
}
}
