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 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;
}
}
