protected void Page_Init(object sender, EventArgs e)
{
var configValue = UnitOfWork.Repository <Config>().Queryable().Single(c => c.ConfigType == ConfigType.AssessmentScale).ConfigValue;
_configValue = (CausalityConfigType)Enum.Parse(typeof(CausalityConfigType), configValue.Replace(" ", ""));
switch (_configValue)
{
case CausalityConfigType.WHOScale:
dt_basic.HideColumn(6);
break;
case CausalityConfigType.NaranjoScale:
dt_basic.HideColumn(7);
break;
}
txtSearchFrom.Value = DateTime.Today.AddDays(-7).ToString("yyyy-MM-dd");
txtSearchTo.Value = DateTime.Today.ToString("yyyy-MM-dd");
ListItem item;
var facilityList = (from f in UnitOfWork.Repository <Facility>().Queryable() orderby f.FacilityName ascending select f).ToList();
foreach (Facility fac in facilityList)
{
item = new ListItem();
item.Text = fac.FacilityName;
item.Value = fac.Id.ToString();
ddlFacility.Items.Add(item);
}
}
public ChangeReportMedicationCausalityCommand(Guid workFlowGuid, int reportInstanceId, int reportInstanceMedicationId, CausalityConfigType causalityConfigType, string causality) : this()
{
WorkFlowGuid = workFlowGuid;
ReportInstanceId = reportInstanceId;
ReportInstanceMedicationId = reportInstanceMedicationId;
CausalityConfigType = causalityConfigType;
Causality = causality;
}
public ICollection <CausalityNotSetList> GetCausalityNotSetItems(DateTime searchFrom, DateTime searchTo, CausalityConfigType causalityConfig, int facilityId, CausalityCriteria causalityCriteria)
{
string where = facilityId > 0 ? " AND pf.Facility_Id = " + facilityId.ToString() : "";
switch (causalityConfig)
{
case CausalityConfigType.BothScales:
where += (causalityCriteria == CausalityCriteria.CausalitySet) ? " AND rim.NaranjoCausality IS NOT NULL AND rim.WhoCausality IS NOT NULL " : " AND (rim.NaranjoCausality IS NULL OR rim.WhoCausality IS NULL) ";
break;
case CausalityConfigType.WHOScale:
where += (causalityCriteria == CausalityCriteria.CausalitySet) ? " AND rim.WhoCausality IS NOT NULL " : " AND rim.WhoCausality IS NULL ";
break;
case CausalityConfigType.NaranjoScale:
where += (causalityCriteria == CausalityCriteria.CausalitySet) ? " AND rim.NaranjoCausality IS NOT NULL " : " AND rim.NaranjoCausality IS NULL ";
break;
}
string sql = string.Format(@"
SELECT p.Id AS Patient_Id, p.FirstName, p.Surname, pce.SourceTerminologyMedDra AS AdverseEvent, pce.OnsetDate, rim.NaranjoCausality, rim.WhoCausality, rim.MedicationIdentifier, pce.[Istheadverseeventserious?] AS Serious
FROM ReportInstance ri
INNER JOIN MetaPatientClinicalEvent pce ON ri.ContextGuid = pce.PatientClinicalEventGuid
INNER JOIN Patient p on pce.Patient_Id = p.Id
INNER JOIN PatientFacility pf ON pf.Id = (select top 1 Id from PatientFacility ipf where ipf.Patient_Id = p.Id and ipf.EnrolledDate <= GETDATE() order by ipf.EnrolledDate desc, ipf.Id desc)
INNER JOIN ReportInstanceMedication rim ON ri.Id = rim.ReportInstance_Id
WHERE pce.OnsetDate BETWEEN '{0}' AND '{1}'
AND p.Archived = 0 {2}
ORDER BY pce.OnsetDate asc ", searchFrom.ToString("yyyy-MM-dd"), searchTo.ToString("yyyy-MM-dd"), where);
SqlParameter[] parameters = new SqlParameter[0];
return(_unitOfWork.Repository <CausalityNotSetList>().ExecuteSql(sql, parameters));
}
