private void SearchIncidents() { string selectedValue = ""; DateTime fromDate = Convert.ToDateTime(dmFromDate.SelectedDate); DateTime toDate = Convert.ToDateTime(dmToDate.SelectedDate); if (toDate < fromDate) { return; } toDate = new DateTime(toDate.Year, toDate.Month, toDate.Day, 23, 59, 59); List <decimal> plantIDS = SQMBasePage.GetComboBoxCheckedItems(ddlPlantSelect).Select(i => Convert.ToDecimal(i.Value)).ToList(); var typeList = new List <decimal>(); List <string> statusList = new List <string>(); if (Mode == IncidentMode.Incident) { if (HSCalcs() == null) { foreach (RadComboBoxItem item in rcbIncidentType.Items) { item.Checked = true; } } typeList = rcbIncidentType.Items.Where(c => c.Checked).Select(c => Convert.ToDecimal(c.Value)).ToList(); selectedValue = rcbStatusSelect.SelectedValue; } else if (Mode == IncidentMode.Prevent) { typeList = EHSIncidentMgr.SelectPreventativeTypeList(SessionManager.PrimaryCompany().COMPANY_ID).Select(l => l.INCIDENT_TYPE_ID).ToList(); statusList = SQMBasePage.GetComboBoxCheckedItems(rcbFindingsSelect).Select(l => l.Value).ToList(); } SetHSCalcs(new SQMMetricMgr().CreateNew(SessionManager.PrimaryCompany(), "0", fromDate, toDate, new decimal[0])); HSCalcs().ehsCtl = new EHSCalcsCtl().CreateNew(1, DateSpanOption.SelectRange); HSCalcs().ObjAny = cbShowImage.Checked; if (selectedValue == "T") { HSCalcs().ehsCtl.SelectIncidentList(plantIDS, typeList, fromDate, toDate, "A", false); List <EHSIncidentData> actionList = new List <EHSIncidentData>(); foreach (EHSIncidentData data in HSCalcs().ehsCtl.IncidentHst) { if (data.EntryList.Where(l => l.INCIDENT_QUESTION_ID == (decimal)EHSQuestionId.Create8D && l.ANSWER_VALUE != "Yes").Count() > 0) { // if (data.Incident.INCIDENT_ANSWER.Where(l => l.INCIDENT_QUESTION_ID == (decimal)EHSQuestionId.Create8D && l.ANSWER_VALUE != "Yes").Count() > 0) actionList.Add(data); } } HSCalcs().ehsCtl.IncidentHst = actionList; if (!UserContext.CheckUserPrivilege(SysPriv.admin, SysScope.incident)) { actionList = HSCalcs().ehsCtl.IncidentHst = (from i in HSCalcs().ehsCtl.IncidentHst where i.Incident.ISSUE_TYPE_ID != 10 select i).ToList(); } if (actionList != null) { uclIncidentList.BindIncidentActionList(actionList, "EHS"); } } else { if (Mode == IncidentMode.Incident) { HSCalcs().ehsCtl.SelectIncidentList(plantIDS, typeList, fromDate, toDate, selectedValue, cbShowImage.Checked); } else if (Mode == IncidentMode.Prevent) { List <string> inspectionCatetoryList = new List <string>(); inspectionCatetoryList.AddRange(rcbInspectCatetory.Items.Where(c => c.Checked).Select(c => c.Value).ToList()); List <string> recommendationTypeList = new List <string>(); recommendationTypeList.AddRange(rcbRecommendationType.Items.Where(c => c.Checked).Select(c => c.Value).ToList()); HSCalcs().ehsCtl.SelectPreventativeList(plantIDS, typeList, inspectionCatetoryList, recommendationTypeList, fromDate, toDate, statusList, cbShowImage.Checked); } if (!UserContext.CheckUserPrivilege(SysPriv.admin, SysScope.incident)) { HSCalcs().ehsCtl.IncidentHst = (from i in HSCalcs().ehsCtl.IncidentHst where i.Incident.ISSUE_TYPE_ID != 10 select i).ToList(); } if (HSCalcs().ehsCtl.IncidentHst != null) { //HSCalcs().ehsCtl.IncidentHst.OrderByDescending(x => x.Incident.INCIDENT_DT); if (Mode == IncidentMode.Incident) { uclIncidentList.BindIncidentListRepeater(HSCalcs().ehsCtl.IncidentHst.OrderByDescending(x => x.Incident.INCIDENT_ID).ToList(), "EHS", cbShowImage.Checked, false); } else if (Mode == IncidentMode.Prevent) { uclIncidentList.BindPreventativeListRepeater(HSCalcs().ehsCtl.IncidentHst.OrderByDescending(x => x.Incident.INCIDENT_ID).ToList(), "EHS", cbShowImage.Checked); } } } if (HSCalcs().ehsCtl.IncidentHst != null && HSCalcs().ehsCtl.IncidentHst.Count > 0) { lblChartType.Visible = ddlChartType.Visible = true; } pnlIncidentDetails.Visible = lnkIncidentDetailsClose.Visible = false; if (ddlChartType.SelectedValue != "") { ddlChartTypeChange(null, null); } }
private void SearchIncidents() { string selectedValue = ""; // work-around for rad persistence manager being cleared upon re-build ?? if (ddlPlantSelect.CheckedItems.Count == 0) { foreach (RadComboBoxItem item in ddlPlantSelect.Items) { item.Checked = true; } } if (rcbInspectionType.CheckedItems.Count == 0) { foreach (RadComboBoxItem item in rcbInspectionType.Items) { item.Checked = true; } } if (rcbStatusSelect.SelectedItem == null) { rcbStatusSelect.SelectedIndex = 0; } DateTime fromDate = Convert.ToDateTime(dmFromDate.SelectedDate); DateTime toDate = Convert.ToDateTime(dmToDate.SelectedDate); if (toDate < fromDate) { return; } toDate = new DateTime(toDate.Year, toDate.Month, toDate.Day, 23, 59, 59); List <decimal> plantIDS = SQMBasePage.GetComboBoxCheckedItems(ddlPlantSelect).Select(i => Convert.ToDecimal(i.Value)).ToList(); if (HSCalcs() == null) { foreach (RadComboBoxItem item in rcbInspectionType.Items) { item.Checked = true; } } SetHSCalcs(new SQMMetricMgr().CreateNew(SessionManager.PrimaryCompany(), "0", fromDate, toDate, new decimal[0])); HSCalcs().ehsCtl = new EHSCalcsCtl().CreateNew(1, DateSpanOption.SelectRange, "0"); HSCalcs().ObjAny = cbShowImage.Checked; var typeList = new List <decimal>(); typeList = EHSIncidentMgr.SelectPreventativeTypeList(SessionManager.PrimaryCompany().COMPANY_ID).Select(l => l.INCIDENT_TYPE_ID).ToList(); var rec_id = RTXT_RecID.Text; List <string> inspectionCatetoryList = new List <string>(); inspectionCatetoryList.AddRange(rcbInspectionType.Items.Where(c => c.Checked).Select(c => c.Value).ToList()); List <string> recommendationTypeList = new List <string>(); recommendationTypeList.AddRange(rcbRecommendType.Items.Where(c => c.Checked).Select(c => c.Value).ToList()); List <string> statusList = SQMBasePage.GetComboBoxCheckedItems(rcbStatusSelect).Select(l => l.Value).ToList(); HSCalcs().ehsCtl.SelectPreventativeList(plantIDS, typeList, inspectionCatetoryList, recommendationTypeList, fromDate, toDate, statusList, cbShowImage.Checked, cbCreatedByMe.Checked ? SessionManager.UserContext.Person.PERSON_ID : 0, Convert.ToDecimal(rec_id == "" ? "0" : rec_id)); if (HSCalcs().ehsCtl.IncidentHst != null) { uclIncidentList.BindPreventativeListRepeater(HSCalcs().ehsCtl.IncidentHst.OrderByDescending(x => x.Incident.INCIDENT_DT).ToList(), "EHS", cbShowImage.Checked); } if (HSCalcs().ehsCtl.IncidentHst != null && HSCalcs().ehsCtl.IncidentHst.Count > 0) { lblChartType.Visible = ddlChartType.Visible = true; } pnlIncidentDetails.Visible = lnkIncidentDetailsClose.Visible = false; if (ddlChartType.SelectedValue != "") { lnkCloseChart(null, null); } }