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