public ActionResult shareingribble(string Fromdate) { SqlConnection con = null; SqlCommand cmd = null; SqlDataReader dr; List <DischargeSummary> obj = new List <DischargeSummary>(); DischargeSummary s; using (con = new SqlConnection(connstring)) { con.Open(); con.CreateCommand(); using (cmd = new SqlCommand("gribble_lab_share", con)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@FromDate", Fromdate)); dr = cmd.ExecuteReader(); while (dr.Read()) { s = new DischargeSummary(); s.BaseEntityName = DBNull.Value.Equals(dr["NAME"]) ? "" : Convert.ToString(dr["NAME"]); s.BedID = DBNull.Value.Equals(dr["countGribble"]) ? 0 : Convert.ToInt64(dr["countGribble"]); s.AdvAmt = DBNull.Value.Equals(dr["countHospitalshare"]) ? 0 : Convert.ToInt64(dr["countHospitalshare"]); obj.Add(s); } } return(Json(obj, JsonRequestBehavior.AllowGet)); } }
public ActionResult Lostdoctorstatistics(string Fromdate) { SqlConnection con = null; SqlCommand cmd = null; SqlDataReader dr; List <DischargeSummary> obj = new List <DischargeSummary>(); DischargeSummary s; // decimal lm = 0; using (con = new SqlConnection(connstring)) { con.Open(); con.CreateCommand(); using (cmd = new SqlCommand("Sp_LostDoctorStatistics", con)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@FromDate", Fromdate)); dr = cmd.ExecuteReader(); while (dr.Read()) { s = new DischargeSummary(); s.BaseEntityName = DBNull.Value.Equals(dr["Months"]) ? "" : Convert.ToString(dr["Months"]); s.BedID = DBNull.Value.Equals(dr["Doctor"]) ? 0 : Convert.ToInt64(dr["Doctor"]); obj.Add(s); } } return(Json(obj, JsonRequestBehavior.AllowGet)); } }
public ActionResult Departmenttestanalysis(string Fromdate, string Todate) { SqlConnection con = null; SqlCommand cmd = null; SqlDataReader dr; List <DischargeSummary> obj = new List <DischargeSummary>(); DischargeSummary s; // decimal lm = 0; using (con = new SqlConnection(connstring)) { con.Open(); con.CreateCommand(); using (cmd = new SqlCommand("Sp_gribbles_Dept_test", con)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@FromDate", Fromdate)); cmd.Parameters.Add(new SqlParameter("@ToDate", Todate)); dr = cmd.ExecuteReader(); while (dr.Read()) { s = new DischargeSummary(); s.BaseEntityName = DBNull.Value.Equals(dr["DepartmentName"]) ? "" : Convert.ToString(dr["DepartmentName"]); s.BedID = DBNull.Value.Equals(dr["countval"]) ? 0 : Convert.ToInt64(dr["countval"]); obj.Add(s); } } return(Json(obj, JsonRequestBehavior.AllowGet)); } }
public ActionResult PatientTypes() { SqlConnection con = null; SqlCommand cmd = null; SqlDataReader dr; List <DischargeSummary> obj = new List <DischargeSummary>(); DischargeSummary s; using (con = new SqlConnection(connstring1)) { con.Open(); con.CreateCommand(); using (cmd = new SqlCommand("Patient_type", con)) { cmd.CommandType = CommandType.StoredProcedure; //cmd.Parameters.Add(new SqlParameter("@FromDate", Fromdate)); //cmd.Parameters.Add(new SqlParameter("@ToDate", Todate)); dr = cmd.ExecuteReader(); while (dr.Read()) { s = new DischargeSummary(); s.BaseEntityName = DBNull.Value.Equals(dr["NAME"]) ? "" : Convert.ToString(dr["NAME"]); s.BedID = DBNull.Value.Equals(dr["CountVal"]) ? 0 : Convert.ToInt64(dr["CountVal"]); obj.Add(s); } } return(Json(obj, JsonRequestBehavior.AllowGet)); } }
public List <DischargeSummary> dropdownlist() { SqlConnection con = null; SqlCommand cmd = null; SqlDataReader dr = null; List <DischargeSummary> obj = new List <DischargeSummary>(); DischargeSummary s; using (con = new SqlConnection(connstring)) { con.Open(); con.CreateCommand(); using (cmd = new SqlCommand("Sp_dropdownyear", con)) { cmd.CommandType = CommandType.StoredProcedure; dr = cmd.ExecuteReader(); while (dr.Read()) { s = new DischargeSummary(); s.BaseEntityName = DBNull.Value.Equals(dr["years"]) ? "" : Convert.ToString(dr["years"]); obj.Add(s); } } } return(obj); }
public ActionResult DeleteConfirmed(int id) { DischargeSummary dischargeSummary = db.DischargeSummaries.Find(id); db.DischargeSummaries.Remove(dischargeSummary); db.SaveChanges(); return(RedirectToAction("Index")); }
public TestDischargeSummary(DischargeSummary r, string idLpu = "") { if (r != null) { dischargeSummary = r; attachment = new TestAttachment(r.Attachment); doctor = new TestDoctor(r.Author, idLpu); } }
public ActionResult Edit([Bind(Include = "ID,PRNO,A_Weight,A_Height,A_BMI,A_FatMass,A_FatMassIndex,A_FatFreeMass,A_FatFreeMassIndex,A_TotalBodyWater,A_Report,D_Weight,D_Height,D_BMI,D_FatMass,D_FatMassIndex,D_FatFreeMass,D_FatFreeMassIndex,D_TotalBodyWater,D_Report,CreatedDate")] DischargeSummary dischargeSummary) { if (ModelState.IsValid) { db.Entry(dischargeSummary).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(dischargeSummary)); }
public DischargeSummary MinDischargeSummary() { DischargeSummary dischargeSummary = new DischargeSummary { CreationDate = MedRecordData.dischargeSummary.CreationDate, Header = MedRecordData.dischargeSummary.Header, Author = MinDoctorSet(), }; return(dischargeSummary); }
// GET: Doctor/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } DischargeSummary dischargeSummary = db.DischargeSummaries.Find(id); if (dischargeSummary == null) { return(HttpNotFound()); } return(View(dischargeSummary)); }
public static 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; }
public ActionResult Create([Bind(Include = "ID,PRNO,A_Weight,A_Height,A_BMI,A_FatMass,A_FatMassIndex,A_FatFreeMass,A_FatFreeMassIndex,A_TotalBodyWater,D_Weight,D_Height,D_BMI,D_FatMass,D_FatMassIndex,D_FatFreeMass,D_FatFreeMassIndex,D_TotalBodyWater")] DischargeSummary dischargeSummary) { if (ModelState.IsValid) { Session["PRNO"] = dischargeSummary.PRNO; DischargeSummary exists = db.DischargeSummaries.Where(i => i.PRNO == dischargeSummary.PRNO).FirstOrDefault(); if (exists == null) { dischargeSummary.CreatedDate = DateTime.Now; //dischargeSummary.A_Report = ConvertToBytes(A_Report); //dischargeSummary.D_Report = ConvertToBytes(D_Report); db.DischargeSummaries.Add(dischargeSummary); db.SaveChanges(); } else { DischargeSummary ds = db.DischargeSummaries.Find(exists.ID); ds.A_BMI = dischargeSummary.A_BMI; ds.A_FatFreeMass = dischargeSummary.A_FatFreeMass; ds.A_FatFreeMassIndex = dischargeSummary.A_FatFreeMassIndex; ds.A_FatMass = dischargeSummary.A_FatMass; ds.A_FatMassIndex = dischargeSummary.A_FatMassIndex; ds.A_Height = dischargeSummary.A_Height; ds.A_Weight = dischargeSummary.A_Weight; ds.A_TotalBodyWater = dischargeSummary.A_TotalBodyWater; ds.D_BMI = dischargeSummary.D_BMI; ds.D_FatFreeMass = dischargeSummary.D_FatFreeMass; ds.D_FatFreeMassIndex = dischargeSummary.D_FatFreeMassIndex; ds.D_FatMass = dischargeSummary.D_FatMass; ds.D_FatMassIndex = dischargeSummary.D_FatMassIndex; ds.D_Height = dischargeSummary.D_Height; ds.D_Weight = dischargeSummary.D_Weight; ds.D_TotalBodyWater = dischargeSummary.D_TotalBodyWater; db.Entry(ds).State = EntityState.Modified; db.SaveChanges(); } return(RedirectToAction("Result")); } return(View(dischargeSummary)); }
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); }
public ActionResult Doctorsharepharmacy() { SqlConnection con = null; SqlCommand cmd = null; SqlDataReader dr; List <DischargeSummary> obj = new List <DischargeSummary>(); DischargeSummary s; // decimal lm = 0; using (con = new SqlConnection(connstring)) { con.Open(); con.CreateCommand(); using (cmd = new SqlCommand("sp_doctor_share", con)) { cmd.CommandType = CommandType.StoredProcedure; // cmd.Parameters.Add(new SqlParameter("@FromDate", Fromdate)); //cmd.Parameters.Add(new SqlParameter("@ToDate", Todate)); dr = cmd.ExecuteReader(); while (dr.Read()) { s = new DischargeSummary(); s.BaseEntityName = DBNull.Value.Equals(dr["NAME"]) ? "" : Convert.ToString(dr["NAME"]); s.BedID = DBNull.Value.Equals(dr["countHospital"]) ? 0 : Convert.ToInt64(dr["countHospital"]); s.AdvAmt = DBNull.Value.Equals(dr["countDoctorshare"]) ? 0 : Convert.ToInt64(dr["countDoctorshare"]); // s.Clientaddress = DBNull.Value.Equals(dr["CountVal"]) ? "" : Convert.ToString(dr["CountVal"]); // s.percentage = decimal.Parse(s.Clientaddress); //s.percentage = Int64.Parse(s.Clientaddress.ToString()); obj.Add(s); } } return(Json(obj, JsonRequestBehavior.AllowGet)); } }
public bool CheckDocumentInCase(MedRecord i, string idLpu) { TestMedRecord doc = null; Service serv = i as Service; if (serv != null) { doc = new TestService(serv); } TfomsInfo tfi = i as TfomsInfo; if (tfi != null) { doc = new TestTfomsInfo(tfi); } DeathInfo di = i as DeathInfo; if (di != null) { doc = new TestDeathInfo(di); } Diagnosis diag = i as Diagnosis; if ((diag != null) && (diag.DiagnosisInfo.IdDiagnosisType != TestDiagnosis.IdClinicMainDiagnosis)) { doc = new TestDiagnosis(diag, idLpu); } ClinicMainDiagnosis cmd = i as ClinicMainDiagnosis; if ((cmd != null) && (cmd.DiagnosisInfo.IdDiagnosisType == TestDiagnosis.IdClinicMainDiagnosis)) { doc = new TestClinicMainDiagnosis(cmd, idLpu); } AnatomopathologicalClinicMainDiagnosis acmd = i as AnatomopathologicalClinicMainDiagnosis; if ((acmd != null) && (cmd.DiagnosisInfo.IdDiagnosisType == TestDiagnosis.IdClinicMainDiagnosis)) { doc = new TestClinicMainDiagnosis(acmd, idLpu); } Referral r = i as Referral; if (r != null) { doc = new TestReferral(r, idLpu); } SickList sl = i as SickList; if (sl != null) { doc = new TestSickList(sl, idLpu); } DischargeSummary ds = i as DischargeSummary; if (ds != null) { doc = new TestDischargeSummary(ds, idLpu); } LaboratoryReport lr = i as LaboratoryReport; if (lr != null) { doc = new TestLaboratoryReport(lr, idLpu); } ConsultNote cn = i as ConsultNote; if (cn != null) { doc = new TestConsultNote(cn, idLpu); } DispensaryOne d1 = i as DispensaryOne; if ((d1 != null) && (caseBase.idCaseType == dispensaryId)) { doc = new TestDispensaryOne(d1, idLpu); } AppointedMedication ap = i as AppointedMedication; if (ap != null) { doc = new TestAppointedMedication(ap, idLpu); } Form027U form = i as Form027U; if (form != null) { doc = new TestForm027U(form, idLpu); } if (Global.IsEqual(doc, null)) { Global.errors1.Add("Документ не найден"); return(true); } foreach (TestMedRecord document in this.medRecords) { if (Global.IsEqual(doc, document)) { return(true); } } return(false); }
public TestAmbCase(string guid, CaseAmb ca) { GUID = guid.ToLower(); if (ca != null) { caseAmb = ca; caseBase = new TestCaseBase(guid, ca); if (ca.Steps != null) { ambSteps = new List <TestAmbStep>(); foreach (StepAmb i in ca.Steps) { ambSteps.Add(new TestAmbStep(i, ca.IdLpu)); } } if (ca.MedRecords != null) { records = new List <TestMedRecord>(); foreach (object i in ca.MedRecords) { Service ser = i as Service; if (ser != null) { records.Add(new TestService(ser, ca.IdLpu)); } TfomsInfo tfi = i as TfomsInfo; if (tfi != null) { records.Add(new TestTfomsInfo(tfi)); } ClinicMainDiagnosis cmd = i as ClinicMainDiagnosis; if ((cmd != null) && (cmd.DiagnosisInfo.IdDiagnosisType == TestDiagnosis.IdClinicMainDiagnosis)) { records.Add(new TestClinicMainDiagnosis(cmd, ca.IdLpu)); } if (cmd == null) { Diagnosis diag = i as Diagnosis; if ((diag != null) && (diag.DiagnosisInfo.IdDiagnosisType == TestDiagnosis.IdClinicMainDiagnosis)) { records.Add(new TestClinicMainDiagnosis(diag, ca.IdLpu)); } if ((diag != null) && (diag.DiagnosisInfo.IdDiagnosisType != TestDiagnosis.IdClinicMainDiagnosis)) { records.Add(new TestDiagnosis(diag, ca.IdLpu)); } } Referral r = i as Referral; if (r != null) { records.Add(new TestReferral(r, ca.IdLpu)); } SickList sl = i as SickList; if (sl != null) { records.Add(new TestSickList(sl, ca.IdLpu)); } DischargeSummary ds = i as DischargeSummary; if (ds != null) { records.Add(new TestDischargeSummary(ds, ca.IdLpu)); } LaboratoryReport lr = i as LaboratoryReport; if (lr != null) { records.Add(new TestLaboratoryReport(lr, ca.IdLpu)); } ConsultNote cn = i as ConsultNote; if (cn != null) { records.Add(new TestConsultNote(cn, ca.IdLpu)); } DispensaryOne d1 = i as DispensaryOne; if ((d1 != null) && (ca.IdCaseType == TestAmbCase.dispanseryId)) { records.Add(new TestDispensaryOne(d1, ca.IdLpu)); } AppointedMedication ap = i as AppointedMedication; if (ap != null) { records.Add(new TestAppointedMedication(ap, ca.IdLpu)); } } } if ((ca.IdLpu != null) && (ca.IdPatientMis != null)) { List <TestStepBase> st = TestStepBase.BuildTestStepsFromDataBase(TestCaseBase.GetCaseId(guid, ca.IdLpu, ca.IdCaseMis, TestPerson.GetPersonId(guid, ca.IdLpu, ca.IdPatientMis)), ca.IdLpu); if (st != null) { foreach (TestStepBase i in st) { if (Global.IsEqual(i.doctor, null)) { defaultStep = i; } } } } } }
public void ChangeUpdateAmbCase(string guid, CaseAmb ca) { GUID = guid.ToLower(); if (ca != null) { this.caseAmb.IsActive = ca.IsActive; if (ca.IdAmbResult != 0) { this.caseAmb.IdAmbResult = ca.IdAmbResult; } if (ca.IdCasePurpose != 0) { this.caseAmb.IdCasePurpose = ca.IdCasePurpose; } caseBase.UpdateCaseBase(guid, ca); if (ca.MedRecords != null) { List <TestMedRecord> newMedRecords = new List <TestMedRecord>(); TestTfomsInfo tfi = null; TestClinicMainDiagnosis cmd = null; TestDischargeSummary ds = null; TestConsultNote cn = null; TestDispensaryOne d1 = null; foreach (object i in ca.MedRecords) { Service ser = i as Service; if (ser != null) { newMedRecords.Add(new TestService(ser, ca.IdLpu)); } TfomsInfo tf = i as TfomsInfo; if (tf != null) { tfi = new TestTfomsInfo(tf); } Diagnosis diag = i as Diagnosis; if ((diag != null) && (diag.DiagnosisInfo.IdDiagnosisType != TestDiagnosis.IdClinicMainDiagnosis)) { newMedRecords.Add(new TestDiagnosis(diag, ca.IdLpu)); } ClinicMainDiagnosis cm = i as ClinicMainDiagnosis; if ((cm != null) && (cm.DiagnosisInfo.IdDiagnosisType == TestDiagnosis.IdClinicMainDiagnosis)) { cmd = new TestClinicMainDiagnosis(cm, ca.IdLpu); } Referral r = i as Referral; if (r != null) { newMedRecords.Add(new TestReferral(r, ca.IdLpu)); } SickList sl = i as SickList; if (sl != null) { newMedRecords.Add(new TestSickList(sl, ca.IdLpu)); } DischargeSummary pds = i as DischargeSummary; if (pds != null) { ds = new TestDischargeSummary(pds, ca.IdLpu); } LaboratoryReport lr = i as LaboratoryReport; if (lr != null) { newMedRecords.Add(new TestLaboratoryReport(lr, ca.IdLpu)); } ConsultNote pcn = i as ConsultNote; if (pcn != null) { cn = new TestConsultNote(pcn, ca.IdLpu); } DispensaryOne d = i as DispensaryOne; if (d != null) { d1 = new TestDispensaryOne(d, ca.IdLpu); } AppointedMedication ap = i as AppointedMedication; if (ap != null) { newMedRecords.Add(new TestAppointedMedication(ap, ca.IdLpu)); } } if (Global.GetLength(this.medRecords) != 0) { foreach (object i in this.medRecords) { TestService ser = i as TestService; if (!Global.IsEqual(ser, null)) { newMedRecords.Add(ser); } TestTfomsInfo tf = i as TestTfomsInfo; if (!Global.IsEqual(tfi, null) && !Global.IsEqual(tf, null)) { newMedRecords.Add(tf); } else if (!Global.IsEqual(tfi, null)) { newMedRecords.Add(tfi); } TestDiagnosis diag = i as TestDiagnosis; if (!Global.IsEqual(diag, null)) { newMedRecords.Add(diag); } TestClinicMainDiagnosis cm = i as TestClinicMainDiagnosis; if (!Global.IsEqual(cmd, null)) { newMedRecords.Add(cmd); } else if (!Global.IsEqual(cm, null)) { newMedRecords.Add(cm); } TestReferral r = i as TestReferral; if (!Global.IsEqual(r, null)) { newMedRecords.Add(r); } TestSickList sl = i as TestSickList; if (!Global.IsEqual(sl, null)) { newMedRecords.Add(sl); } TestDischargeSummary pds = i as TestDischargeSummary; if (!Global.IsEqual(ds, null)) { newMedRecords.Add(ds); } else if (!Global.IsEqual(pds, null)) { newMedRecords.Add(pds); } TestLaboratoryReport lr = i as TestLaboratoryReport; if (!Global.IsEqual(lr, null)) { newMedRecords.Add(lr); } TestConsultNote pcn = i as TestConsultNote; if (!Global.IsEqual(cn, null)) { newMedRecords.Add(cn); } else if (!Global.IsEqual(pcn, null)) { newMedRecords.Add(pcn); } TestDispensaryOne d = i as TestDispensaryOne; if (!Global.IsEqual(d1, null)) { newMedRecords.Add(d1); } else if (!Global.IsEqual(d, null)) { newMedRecords.Add(d); } TestAppointedMedication ap = i as TestAppointedMedication; if (!Global.IsEqual(ap, null)) { newMedRecords.Add(ap); } } } else { if (!Global.IsEqual(tfi, null)) { newMedRecords.Add(tfi); } if (!Global.IsEqual(cmd, null)) { newMedRecords.Add(cmd); } if (!Global.IsEqual(ds, null)) { newMedRecords.Add(ds); } if (!Global.IsEqual(cn, null)) { newMedRecords.Add(cn); } } this.records = newMedRecords; } } }
private List <EMKServise.MedRecord> ConvertMedRecords(MedRecord[] c) { if (((object)c != null) && (c.Length != 0)) { List <EMKServise.MedRecord> lmr = new List <EMKServise.MedRecord>(); foreach (object i in c) { Service ser = i as Service; if (ser != null) { EMKServise.Service eser = new EMKServise.Service(); if (ser.DateEnd != DateTime.MinValue) { eser.DateEnd = ser.DateEnd; } if (ser.DateStart != DateTime.MinValue) { eser.DateStart = ser.DateStart; } if (ser.IdServiceType != "") { eser.IdServiceType = ser.IdServiceType; } eser.PaymentInfo = ConvertPaymentInfo(ser.PaymentInfo); eser.Performer = ConvertParticipant(ser.Performer); if (ser.ServiceName != "") { eser.ServiceName = ser.ServiceName; } lmr.Add(eser); } TfomsInfo tfi = i as TfomsInfo; if (tfi != null) { EMKServise.TfomsInfo etfi = new EMKServise.TfomsInfo(); etfi.Count = tfi.Count; etfi.IdTfomsType = tfi.IdTfomsType; etfi.Tariff = tfi.Tariff; lmr.Add(etfi); } AppointedMedication ap = i as AppointedMedication; if (ap != null) { EMKServise.AppointedMedication eap = new EMKServise.AppointedMedication(); if (ap.AnatomicTherapeuticChemicalClassification != "") { eap.AnatomicTherapeuticChemicalClassification = ap.AnatomicTherapeuticChemicalClassification; } eap.CourseDose = ConvertQuantity(ap.CourseDose); eap.DayDose = ConvertQuantity(ap.DayDose); eap.DaysCount = ap.DaysCount; eap.Doctor = ConvertMedicalStaff(ap.Doctor); if (ap.IssuedDate != DateTime.MinValue) { eap.IssuedDate = ap.IssuedDate; } if (ap.MedicineIssueType != "") { eap.MedicineIssueType = ap.MedicineIssueType; } if (ap.MedicineName != "") { eap.MedicineName = ap.MedicineName; } eap.MedicineType = ap.MedicineType; eap.MedicineUseWay = ap.MedicineUseWay; if (ap.Number != "") { eap.Number = ap.Number; } eap.OneTimeDose = ConvertQuantity(ap.OneTimeDose); if (ap.Seria != "") { eap.Seria = ap.Seria; } lmr.Add(eap); } DeathInfo di = i as DeathInfo; if (di != null) { EMKServise.DeathInfo edi = new EMKServise.DeathInfo(); if (di.MkbCode != "") { edi.MkbCode = di.MkbCode; } lmr.Add(edi); } ClinicMainDiagnosis cmd = i as ClinicMainDiagnosis; if ((cmd != null) && (cmd.DiagnosisInfo.IdDiagnosisType == TestDiagnosis.IdClinicMainDiagnosis)) { EMKServise.ClinicMainDiagnosis ecmd = new EMKServise.ClinicMainDiagnosis(); ecmd.Complications = ConvertDiagnosis(cmd.Complications); ecmd.DiagnosisInfo = ConvertDiagnosisInfo(cmd.DiagnosisInfo); ecmd.Doctor = ConvertMedicalStaff(cmd.Doctor); lmr.Add(ecmd); } if (cmd == null) { Diagnosis diag = i as Diagnosis; if ((diag != null) && (diag.DiagnosisInfo.IdDiagnosisType == TestDiagnosis.IdClinicMainDiagnosis)) { EMKServise.ClinicMainDiagnosis ecmd = new EMKServise.ClinicMainDiagnosis(); ecmd.DiagnosisInfo = ConvertDiagnosisInfo(diag.DiagnosisInfo); ecmd.Doctor = ConvertMedicalStaff(diag.Doctor); lmr.Add(ecmd); } if ((diag != null) && (diag.DiagnosisInfo.IdDiagnosisType != TestDiagnosis.IdClinicMainDiagnosis)) { EMKServise.Diagnosis ecmd = new EMKServise.Diagnosis(); ecmd.DiagnosisInfo = ConvertDiagnosisInfo(diag.DiagnosisInfo); ecmd.Doctor = ConvertMedicalStaff(diag.Doctor); lmr.Add(ecmd); } } Referral r = i as Referral; if (r != null) { EMKServise.Referral er = new EMKServise.Referral(); er.Attachment = ConvertAttachment(r.Attachment); er.Author = ConvertMedicalStaff(r.Author); if (r.CreationDate != DateTime.MinValue) { er.CreationDate = r.CreationDate; } er.DepartmentHead = ConvertMedicalStaff(r.DepartmentHead); if (r.Header != "") { er.Header = r.Header; } if (r.IdSourceLpu != "") { er.IdSourceLpu = r.IdSourceLpu; } if (r.IdTargetLpu != "") { er.IdTargetLpu = r.IdTargetLpu; } if (r.ReferralID != "") { er.ReferralID = r.ReferralID; } er.ReferralInfo = ConvertReferralInfo(r.ReferralInfo); if (r.RelatedID != "") { er.RelatedID = r.RelatedID; } lmr.Add(er); } SickList sl = i as SickList; if (sl != null) { EMKServise.SickList esl = new EMKServise.SickList(); esl.Attachment = ConvertAttachment(sl.Attachment); esl.Author = ConvertMedicalStaff(sl.Author); if (sl.CreationDate != DateTime.MinValue) { esl.CreationDate = sl.CreationDate; } if (sl.Header != "") { esl.Header = sl.Header; } esl.SickListInfo = ConvertSickListInfo(sl.SickListInfo); lmr.Add(esl); } DischargeSummary ds = i as DischargeSummary; if (ds != null) { EMKServise.DischargeSummary eds = new EMKServise.DischargeSummary(); eds.Attachment = ConvertAttachment(ds.Attachment); eds.Author = ConvertMedicalStaff(ds.Author); if (ds.CreationDate != DateTime.MinValue) { eds.CreationDate = ds.CreationDate; } if (ds.Header != "") { eds.Header = ds.Header; } lmr.Add(eds); } LaboratoryReport lr = i as LaboratoryReport; if (lr != null) { EMKServise.LaboratoryReport elr = new EMKServise.LaboratoryReport(); elr.Attachment = ConvertAttachment(lr.Attachment); elr.Author = ConvertMedicalStaff(lr.Author); if (lr.CreationDate != DateTime.MinValue) { elr.CreationDate = lr.CreationDate; } if (lr.Header != "") { elr.Header = lr.Header; } lmr.Add(elr); } ConsultNote cn = i as ConsultNote; if (cn != null) { EMKServise.ConsultNote ecn = new EMKServise.ConsultNote(); ecn.Attachment = ConvertAttachment(cn.Attachment); ecn.Author = ConvertMedicalStaff(cn.Author); if (cn.CreationDate != DateTime.MinValue) { ecn.CreationDate = cn.CreationDate; } if (cn.Header != "") { ecn.Header = cn.Header; } lmr.Add(ecn); } DispensaryOne d1 = i as DispensaryOne; if (d1 != null) { EMKServise.DispensaryOne ed1 = new EMKServise.DispensaryOne(); ed1.Attachment = ConvertAttachment(d1.Attachment); ed1.Author = ConvertMedicalStaff(d1.Author); if (d1.CreationDate != DateTime.MinValue) { ed1.CreationDate = d1.CreationDate; } if (d1.Header != "") { ed1.Header = d1.Header; } ed1.HasExpertCareRefferal = d1.HasExpertCareRefferal; ed1.HasExtraResearchRefferal = d1.HasExtraResearchRefferal; ed1.HasHealthResortRefferal = d1.HasHealthResortRefferal; ed1.HasPrescribeCure = d1.HasPrescribeCure; ed1.HasSecondStageRefferal = d1.HasSecondStageRefferal; ed1.HealthGroup = ConvertHealthGroup(d1.HealthGroup); ed1.IsGuested = d1.IsGuested; ed1.IsUnderObservation = d1.IsUnderObservation; ed1.Recommendations = ConvertRecommendation(d1.Recommendations); lmr.Add(ed1); } } return(lmr); } else { return(null); } }
public void ChangeUpdateStatCase(string guid, CaseStat cs) { GUID = guid.ToLower(); if (cs != null) { if (cs.DeliveryCode != null) { this.caseStat.DeliveryCode = cs.DeliveryCode; } if (cs.IdIntoxicationType != 0) { this.caseStat.IdIntoxicationType = cs.IdIntoxicationType; } if (cs.IdPatientConditionOnAdmission != 0) { this.caseStat.IdPatientConditionOnAdmission = cs.IdPatientConditionOnAdmission; } if (cs.IdTypeFromDiseaseStart != 0) { this.caseStat.IdTypeFromDiseaseStart = cs.IdTypeFromDiseaseStart; } if (cs.IdTransportIntern != 0) { this.caseStat.IdTransportIntern = cs.IdTransportIntern; } if (cs.IdHospChannel != 0) { this.caseStat.IdHospChannel = cs.IdHospChannel; } this.caseStat.RW1Mark = cs.RW1Mark; this.caseStat.AIDSMark = cs.AIDSMark; caseBase.UpdateCaseBase(guid, cs); if (cs.MedRecords != null) { List <TestMedRecord> newMedRecords = new List <TestMedRecord>(); TestTfomsInfo tfi = null; TestClinicMainDiagnosis cmd = null; TestDischargeSummary ds = null; TestConsultNote cn = null; TestDeathInfo tdi = null; foreach (object i in cs.MedRecords) { Service ser = i as Service; if (ser != null) { newMedRecords.Add(new TestService(ser, cs.IdLpu)); } TfomsInfo tf = i as TfomsInfo; if (tf != null) { tfi = new TestTfomsInfo(tf); } Diagnosis diag = i as Diagnosis; if ((diag != null) && (diag.DiagnosisInfo.IdDiagnosisType != TestDiagnosis.IdClinicMainDiagnosis)) { newMedRecords.Add(new TestDiagnosis(diag, cs.IdLpu)); } ClinicMainDiagnosis cd = i as ClinicMainDiagnosis; if ((cd != null) && (cs.HospResult != IdDeath) && (cd.DiagnosisInfo.IdDiagnosisType == TestDiagnosis.IdClinicMainDiagnosis)) { cmd = new TestClinicMainDiagnosis(cd, cs.IdLpu); } ClinicMainDiagnosis ca = i as ClinicMainDiagnosis; if ((ca != null) && (cs.HospResult == IdDeath) && (ca.DiagnosisInfo.IdDiagnosisType == TestDiagnosis.IdClinicMainDiagnosis)) { cmd = new TestClinicMainDiagnosis(ca, cs.IdLpu); } Referral r = i as Referral; if (r != null) { newMedRecords.Add(new TestReferral(r, cs.IdLpu)); } SickList sl = i as SickList; if (sl != null) { newMedRecords.Add(new TestSickList(sl, cs.IdLpu)); } DischargeSummary pds = i as DischargeSummary; if (pds != null) { ds = new TestDischargeSummary(pds, cs.IdLpu); } LaboratoryReport lr = i as LaboratoryReport; if (lr != null) { newMedRecords.Add(new TestLaboratoryReport(lr, cs.IdLpu)); } ConsultNote pcn = i as ConsultNote; if (pcn != null) { cn = new TestConsultNote(pcn, cs.IdLpu); } AppointedMedication ap = i as AppointedMedication; if (ap != null) { newMedRecords.Add(new TestAppointedMedication(ap, cs.IdLpu)); } DeathInfo di = i as DeathInfo; if (di != null) { tdi = new TestDeathInfo(di); } Form027U form = i as Form027U; if (form != null) { newMedRecords.Add(new TestForm027U(form, cs.IdLpu)); //? } } if (Global.GetLength(this.medRecords) != 0) { foreach (object i in this.medRecords) { TestService ser = i as TestService; if (!Global.IsEqual(ser, null)) { newMedRecords.Add(ser); } TestTfomsInfo tf = i as TestTfomsInfo; if (!Global.IsEqual(tfi, null) && (!Global.IsEqual(tf, null))) { newMedRecords.Add(tf); } else if (!Global.IsEqual(tfi, null)) { newMedRecords.Add(tfi); } TestDiagnosis diag = i as TestDiagnosis; if (!Global.IsEqual(diag, null)) { newMedRecords.Add(diag); } TestClinicMainDiagnosis cm = i as TestClinicMainDiagnosis; if (!Global.IsEqual(cmd, null)) { newMedRecords.Add(cmd); } else if (!Global.IsEqual(cm, null)) { newMedRecords.Add(cm); } TestReferral r = i as TestReferral; if (!Global.IsEqual(r, null)) { newMedRecords.Add(r); } TestSickList sl = i as TestSickList; if (!Global.IsEqual(sl, null)) { newMedRecords.Add(sl); } TestDischargeSummary pds = i as TestDischargeSummary; if (!Global.IsEqual(ds, null)) { newMedRecords.Add(ds); } else if (!Global.IsEqual(pds, null)) { newMedRecords.Add(pds); } TestLaboratoryReport lr = i as TestLaboratoryReport; if (!Global.IsEqual(lr, null)) { newMedRecords.Add(lr); } TestConsultNote pcn = i as TestConsultNote; if (!Global.IsEqual(cn, null)) { newMedRecords.Add(cn); } else if (!Global.IsEqual(pcn, null)) { newMedRecords.Add(pcn); } TestAppointedMedication ap = i as TestAppointedMedication; if (!Global.IsEqual(ap, null)) { newMedRecords.Add(ap); } TestDeathInfo di = i as TestDeathInfo; if (!Global.IsEqual(tdi, null) && (!Global.IsEqual(di, null))) { newMedRecords.Add(di); } else if (!Global.IsEqual(tdi, null)) { newMedRecords.Add(tdi); } TestForm027U form = i as TestForm027U; if (!Global.IsEqual(form, null)) { newMedRecords.Add(form); } } } else { if (!Global.IsEqual(tfi, null)) { newMedRecords.Add(tfi); } if (!Global.IsEqual(cmd, null)) { newMedRecords.Add(cmd); } if (!Global.IsEqual(ds, null)) { newMedRecords.Add(ds); } if (!Global.IsEqual(cn, null)) { newMedRecords.Add(cn); } if (!Global.IsEqual(tdi, null)) { newMedRecords.Add(tdi); } } this.records = newMedRecords; } } }
public TestStatCase(string guid, CaseStat cs) { GUID = guid.ToLower(); if (cs != null) { caseStat = cs; caseBase = new TestCaseBase(guid, cs); if (cs.Steps != null) { statSteps = new List <TestStatStep>(); foreach (StepStat i in cs.Steps) { statSteps.Add(new TestStatStep(i, cs.IdLpu)); } } if (cs.MedRecords != null) { records = new List <TestMedRecord>(); foreach (object i in cs.MedRecords) { Service ser = i as Service; if (ser != null) { records.Add(new TestService(ser, cs.IdLpu)); } TfomsInfo tfi = i as TfomsInfo; if (tfi != null) { records.Add(new TestTfomsInfo(tfi)); } DeathInfo di = i as DeathInfo; if (di != null) { records.Add(new TestDeathInfo(di)); } ClinicMainDiagnosis cmd = i as ClinicMainDiagnosis; if ((cmd != null) && (cs.HospResult != IdDeath) && (cmd.DiagnosisInfo.IdDiagnosisType == TestDiagnosis.IdClinicMainDiagnosis)) { records.Add(new TestClinicMainDiagnosis(cmd, cs.IdLpu)); } AnatomopathologicalClinicMainDiagnosis acmd = i as AnatomopathologicalClinicMainDiagnosis; if ((acmd != null) && (cs.HospResult == IdDeath) && (cmd.DiagnosisInfo.IdDiagnosisType == TestDiagnosis.IdClinicMainDiagnosis)) { records.Add(new TestClinicMainDiagnosis(acmd, cs.IdLpu)); } if ((cmd == null) && (acmd == null)) { Diagnosis diag = i as Diagnosis; if ((diag != null) && (diag.DiagnosisInfo.IdDiagnosisType != TestDiagnosis.IdClinicMainDiagnosis)) { records.Add(new TestDiagnosis(diag, cs.IdLpu)); } if ((diag != null) && (diag.DiagnosisInfo.IdDiagnosisType == TestDiagnosis.IdClinicMainDiagnosis)) { records.Add(new TestClinicMainDiagnosis(diag, cs.IdLpu)); } } Referral r = i as Referral; if (r != null) { records.Add(new TestReferral(r, cs.IdLpu)); } SickList sl = i as SickList; if (sl != null) { records.Add(new TestSickList(sl, cs.IdLpu)); } DischargeSummary ds = i as DischargeSummary; if (ds != null) { records.Add(new TestDischargeSummary(ds, cs.IdLpu)); } LaboratoryReport lr = i as LaboratoryReport; if (lr != null) { records.Add(new TestLaboratoryReport(lr, cs.IdLpu)); } ConsultNote cn = i as ConsultNote; if (cn != null) { records.Add(new TestConsultNote(cn, cs.IdLpu)); } AppointedMedication ap = i as AppointedMedication; if (ap != null) { records.Add(new TestAppointedMedication(ap, cs.IdLpu)); } Form027U form = i as Form027U; if (form != null) { records.Add(new TestForm027U(form, cs.IdLpu)); } } } if ((cs.IdLpu != null) && (cs.IdPatientMis != null)) { List <TestStepBase> st = TestStepBase.BuildTestStepsFromDataBase(TestCaseBase.GetCaseId(guid, cs.IdLpu, cs.IdCaseMis, TestPerson.GetPersonId(guid, cs.IdLpu, cs.IdPatientMis)), cs.IdLpu); if (st != null) { foreach (TestStepBase i in st) { if (Global.IsEqual(i.doctor, null)) { defaultStep = i; } } } } } }
public static void AddReportSpecificTables(DataSet dataSet) { try { Common common = (Common)dataSet.Tables["RunReportRequest"].Rows[0]["CommonLibrary"]; DataTable settingsTable = dataSet.Tables["ReportSettings"]; settingsTable.Columns.Add("ReportTitle", typeof(string)); settingsTable.Rows[0]["ReportTitle"] = Resources.FieldActivity; DataTable table = new DataTable("FieldActivityDataTable"); dataSet.Tables.Add(table); RunFileReportRequest runReportRequest = (RunFileReportRequest)dataSet.Tables["RunReportRequest"].Rows[0]["RunReportRequest"]; IPublishGateway publish = runReportRequest.Publish; string locationIdentifier = (string)dataSet.Tables["LocationInput"].Rows[0]["Identifier"]; string dllName = (string)dataSet.Tables["RunReportRequest"].Rows[0]["DllName"]; Log.DebugFormat("{0} - Document GenerateScript input location = {1}", dllName, locationIdentifier); /////////////////////////////////////////////////////////////// DateTimeOffsetInterval reportPeriod = (DateTimeOffsetInterval)dataSet.Tables["ReportPeriods"].Rows[0]["NoGroupBy"]; string sortOrder = common.GetParameterString("SortOrder", "ReverseChronologicalOnMeasurementTime"); DataTable table1 = dataSet.Tables.Add("FieldActivity"); table1.Columns.Add("Date", typeof(string)); table1.Columns.Add("Time", typeof(string)); table1.Columns.Add("Timezone", typeof(string)); table1.Columns.Add("ActivityType", typeof(string)); table1.Columns.Add("Stage", typeof(string)); table1.Columns.Add("StageUnit", typeof(string)); table1.Columns.Add("Discharge", typeof(string)); table1.Columns.Add("DischargeUnit", typeof(string)); table1.Columns.Add("ControlCondition", typeof(string)); table1.Columns.Add("ActivityRemarks", typeof(string)); table1.Columns.Add("FieldVisitComments", typeof(string)); FieldVisitDataByLocationServiceRequest fdRequest = new FieldVisitDataByLocationServiceRequest(); fdRequest.LocationIdentifier = locationIdentifier; fdRequest.ApplyRounding = true; fdRequest.Activities = new List <ActivityType> { ActivityType.Reading, ActivityType.DischargeSummary, ActivityType.ControlCondition }; FieldVisitDataByLocationServiceResponse fdResponse = publish.Get(fdRequest); List <FieldVisit> fieldVisitData = fdResponse.FieldVisitData; try { if (sortOrder != "ReverseChronologicalOnMeasurementTime") { fieldVisitData.Sort((x, y) => x.StartTime.Value.CompareTo(y.StartTime.Value)); } else { fieldVisitData.Sort((x, y) => y.StartTime.Value.CompareTo(x.StartTime.Value)); } } catch { } foreach (FieldVisit fieldVisit in fieldVisitData) { if (!ReportSpecificFunctions.TimeRangeOverlaps(fieldVisit.StartTime.Value, fieldVisit.StartTime.Value, reportPeriod)) { continue; } if (fieldVisit.DischargeActivities != null) { var activities = fieldVisit.DischargeActivities; if (sortOrder != "ReverseChronologicalOnMeasurementTime") { activities.Sort((x, y) => x.DischargeSummary.MeasurementTime.CompareTo(y.DischargeSummary.MeasurementTime)); } else { activities.Sort((x, y) => y.DischargeSummary.MeasurementTime.CompareTo(x.DischargeSummary.MeasurementTime)); } foreach (DischargeActivity dischargeActivity in activities) { if (dischargeActivity.DischargeSummary == null) { continue; } DataRow row = table1.NewRow(); row["Date"] = (fieldVisit.StartTime.HasValue) ? fieldVisit.StartTime.Value.ToString("yyyy-MM-dd") : ""; row["ControlCondition"] = (fieldVisit.ControlConditionActivity != null) ? fieldVisit.ControlConditionActivity.ControlCondition.ToString() : ""; row["FieldVisitComments"] = fieldVisit.Remarks; row["ActivityType"] = Resources.DischargeSummary; DischargeSummary dischargeSummary = dischargeActivity.DischargeSummary; row["Time"] = dischargeSummary.MeasurementTime.ToString("HH:mm"); row["Timezone"] = dischargeSummary.MeasurementTime.ToString("zzz"); string discharge = (dischargeSummary.Discharge != null) ? dischargeSummary.Discharge.Display : ""; string dischargeUnit = (dischargeSummary.Discharge != null) ? dischargeSummary.Discharge.Unit : ""; if (dischargeUnit != "m^3/s") { discharge += " " + dischargeUnit; } row["Discharge"] = discharge; string stage = (dischargeSummary.MeanGageHeight != null) ? dischargeSummary.MeanGageHeight.Display : ""; string stageUnit = (dischargeSummary.MeanGageHeight != null) ? dischargeSummary.MeanGageHeight.Unit : ""; if (!string.IsNullOrEmpty(stage) && (stageUnit != "m")) { stage += " " + stageUnit; } row["Stage"] = stage; row["ActivityRemarks"] = dischargeSummary.Comments; table1.Rows.Add(row); } } if ((fieldVisit.InspectionActivity != null) && (fieldVisit.InspectionActivity.Readings != null)) { foreach (Reading reading in fieldVisit.InspectionActivity.Readings) { if (!reading.Publish || !reading.IsValid) { continue; } if ("Stage" != reading.Parameter) { continue; } DataRow row = table1.NewRow(); row["Date"] = (fieldVisit.StartTime.HasValue) ? fieldVisit.StartTime.Value.ToString("yyyy-MM-dd") : ""; row["ControlCondition"] = (fieldVisit.ControlConditionActivity != null) ? fieldVisit.ControlConditionActivity.ControlCondition.ToString() : ""; row["FieldVisitComments"] = fieldVisit.Remarks; row["ActivityType"] = Resources.Reading; row["Time"] = (reading.Time.HasValue) ? reading.Time.Value.ToString("HH:mm") : ""; row["Timezone"] = (reading.Time.HasValue) ? reading.Time.Value.ToString("zzz") : ""; string stage = reading.Value.Display; string stageUnit = reading.Unit; if (stageUnit != "m") { stage += " " + stageUnit; } row["Stage"] = stage; row["ActivityRemarks"] = reading.Comments; table1.Rows.Add(row); } } } } catch (Exception exp) { Log.Error("Error creating report specific data tables ", exp); throw exp; } }
public DischargeSummary MinDischargeSummary() { DischargeSummary dischargeSummary = new DischargeSummary { CreationDate = MedRecordData.dischargeSummary.CreationDate, Header = MedRecordData.dischargeSummary.Header, Author = MinDoctorSet(), }; return dischargeSummary; }
public static void AddReportSpecificTables(DataSet dataSet) { try { Common common = (Common)dataSet.Tables["RunReportRequest"].Rows[0]["CommonLibrary"]; DataTable settingsTable = dataSet.Tables["ReportSettings"]; settingsTable.Columns.Add("ReportTitle", typeof(string)); settingsTable.Rows[0]["ReportTitle"] = Resources.Instrumentation; DataTable table = new DataTable("InstrumentationDataTable"); dataSet.Tables.Add(table); RunFileReportRequest runReportRequest = (RunFileReportRequest)dataSet.Tables["RunReportRequest"].Rows[0]["RunReportRequest"]; IPublishGateway publish = runReportRequest.Publish; string locationIdentifier = (string)dataSet.Tables["LocationInput"].Rows[0]["Identifier"]; string dllName = (string)dataSet.Tables["RunReportRequest"].Rows[0]["DllName"]; Log.DebugFormat("{0} - Document GenerateScript input location = {1}", dllName, locationIdentifier); /////////////////////////////////////////////////////////////// DateTimeOffsetInterval reportPeriod = (DateTimeOffsetInterval)dataSet.Tables["ReportPeriods"].Rows[0]["NoGroupBy"]; string sortOrder = common.GetParameterString("SortOrder", "ReverseChronologicalOnMeasurementTime"); DataTable table1 = dataSet.Tables.Add("Instrumentation"); table1.Columns.Add("Date", typeof(string)); table1.Columns.Add("Time", typeof(string)); table1.Columns.Add("Timezone", typeof(string)); table1.Columns.Add("ActivityType", typeof(string)); table1.Columns.Add("Stage", typeof(string)); table1.Columns.Add("StageUnit", typeof(string)); table1.Columns.Add("Discharge", typeof(string)); table1.Columns.Add("DischargeUnit", typeof(string)); table1.Columns.Add("ControlCondition", typeof(string)); table1.Columns.Add("ActivityRemarks", typeof(string)); table1.Columns.Add("FieldVisitComments", typeof(string)); table1.Columns.Add("Method", typeof(string)); table1.Columns.Add("InstrumentType", typeof(string)); table1.Columns.Add("Software", typeof(string)); table1.Columns.Add("Firmware", typeof(string)); table1.Columns.Add("SerialNumber", typeof(string)); table1.Columns.Add("Manufacturer", typeof(string)); table1.Columns.Add("Model", typeof(string)); ActiveMetersAndCalibrationsServiceRequest amcRequest = new ActiveMetersAndCalibrationsServiceRequest(); ActiveMetersAndCalibrationsServiceResponse amcResponse = publish.Get(amcRequest); List <ActiveMeterDetails> activeMeterDetailsList = amcResponse.ActiveMeterDetails; FieldVisitDataByLocationServiceRequest fdRequest = new FieldVisitDataByLocationServiceRequest(); fdRequest.LocationIdentifier = locationIdentifier; fdRequest.Activities = new List <ActivityType> { ActivityType.Reading, ActivityType.DischargeSummary, ActivityType.DischargePointVelocity, ActivityType.DischargeAdcp }; fdRequest.ApplyRounding = true; fdRequest.IncludeVerticals = true; FieldVisitDataByLocationServiceResponse fdResponse = publish.Get(fdRequest); List <FieldVisit> fieldVisitData = fdResponse.FieldVisitData; try { if (sortOrder != "ReverseChronologicalOnMeasurementTime") { fieldVisitData.Sort((x, y) => x.StartTime.Value.CompareTo(y.StartTime.Value)); } else { fieldVisitData.Sort((x, y) => y.StartTime.Value.CompareTo(x.StartTime.Value)); } } catch { } foreach (FieldVisit fieldVisit in fieldVisitData) { if (!ReportSpecificFunctions.TimeRangeOverlaps(fieldVisit.StartTime.Value, fieldVisit.StartTime.Value, reportPeriod)) { continue; } string controlCondition = (fieldVisit.ControlConditionActivity != null) ? fieldVisit.ControlConditionActivity.ControlCondition.ToString() : ""; var activities = fieldVisit.DischargeActivities; if (activities != null) { if (sortOrder != "ReverseChronologicalOnMeasurementTime") { activities.Sort((x, y) => x.DischargeSummary.MeasurementTime.CompareTo(y.DischargeSummary.MeasurementTime)); } else { activities.Sort((x, y) => y.DischargeSummary.MeasurementTime.CompareTo(x.DischargeSummary.MeasurementTime)); } foreach (DischargeActivity dischargeActivity in activities) { DataRow row = table1.NewRow(); row["Date"] = (fieldVisit.StartTime.HasValue) ? fieldVisit.StartTime.Value.ToString("yyyy-MM-dd") : ""; row["ControlCondition"] = controlCondition; row["FieldVisitComments"] = fieldVisit.Remarks; row["ActivityType"] = Resources.DischargeSummary; row["Method"] = dischargeActivity.DischargeSummary.DischargeMethod; DischargeSummary dischargeSummary = dischargeActivity.DischargeSummary; row["Time"] = dischargeSummary.MeasurementTime.ToString("HH:mm"); row["Timezone"] = dischargeSummary.MeasurementTime.ToString("zzz"); string discharge = (dischargeSummary.Discharge != null) ? dischargeSummary.Discharge.Numeric.ToString() : ""; string dischargeUnit = (dischargeSummary.Discharge != null) ? dischargeSummary.Discharge.Unit : ""; if (dischargeUnit != "m^3/s") { discharge += " " + dischargeUnit; } row["Discharge"] = discharge; string stage = (dischargeSummary.MeanGageHeight != null) ? dischargeSummary.MeanGageHeight.Numeric.ToString() : ""; string stageUnit = (dischargeSummary.MeanGageHeight != null) ? dischargeSummary.MeanGageHeight.Unit : ""; if (!string.IsNullOrEmpty(stage) && (stageUnit != "m")) { stage += " " + stageUnit; } row["Stage"] = stage; row["ActivityRemarks"] = dischargeSummary.Comments; string serialNumber = ""; string model = ""; string manufacturer = ""; string instrumentType = ""; string software = ""; string firmware = ""; if ((dischargeActivity.PointVelocityDischargeActivities != null) && (dischargeActivity.PointVelocityDischargeActivities.Count > 0)) { PointVelocityDischargeActivity pointVelocityDischargeActivity = dischargeActivity.PointVelocityDischargeActivities[0]; if ((pointVelocityDischargeActivity.Verticals != null) && (pointVelocityDischargeActivity.Verticals.Count > 0)) { Vertical vertical = pointVelocityDischargeActivity.Verticals[0]; serialNumber = vertical.CurrentMeter.SerialNumber; model = vertical.CurrentMeter.Model; manufacturer = vertical.CurrentMeter.Manufacturer; foreach (ActiveMeterDetails activeMeterDetails in activeMeterDetailsList) { if ((activeMeterDetails.Manufacturer == manufacturer) && (activeMeterDetails.SerialNumber == serialNumber) && (activeMeterDetails.Model == model)) { instrumentType = (activeMeterDetails.MeterType.HasValue) ? activeMeterDetails.MeterType.Value.ToString() : ""; software = activeMeterDetails.SoftwareVersion; firmware = activeMeterDetails.FirmwareVersion; break; } } } } if ((dischargeActivity.AdcpDischargeActivities != null) && (dischargeActivity.AdcpDischargeActivities.Count > 0)) { AdcpDischargeActivity adcpDischargeActivity = dischargeActivity.AdcpDischargeActivities[0]; instrumentType = adcpDischargeActivity.AdcpDeviceType; software = adcpDischargeActivity.SoftwareVersion; firmware = adcpDischargeActivity.FirmwareVersion; manufacturer = adcpDischargeActivity.Manufacturer; serialNumber = adcpDischargeActivity.SerialNumber; model = adcpDischargeActivity.Model; Log.DebugFormat("AdcpDischargeActivity: {0}, {1}, {2}", instrumentType, software, firmware); } row["Software"] = software; row["InstrumentType"] = instrumentType; row["Firmware"] = firmware; row["Manufacturer"] = manufacturer; row["Model"] = model; row["SerialNumber"] = serialNumber; table1.Rows.Add(row); } } } } catch (Exception exp) { Log.Error("Error creating report specific data tables ", exp); throw exp; } }