PdfPTable HeaderSection(AlertData pageData)
{
PdfPTable tableHeader = new PdfPTable(new float[] { 220f, 160f, 160f });
tableHeader.TotalWidth = 540f;
tableHeader.LockedWidth = true;
PdfPCell cell;
INCIDENT_ANSWER answer = null;
cell = new PdfPCell()
{
Padding = 2f, PaddingBottom = 5f, Border = 0
};
cell.BorderWidthTop = cell.BorderWidthLeft = .25f;
cell.AddElement(new Paragraph(String.Format(SQMBasePage.GetXLAT(reportXLAT, "HS_5PHASE", "PLANT").DESCRIPTION_SHORT + ": {0}", pageData.incidentLocation), detailTxtFont));
tableHeader.AddCell(cell);
cell = new PdfPCell()
{
Padding = 2f, PaddingBottom = 5f, Border = 0
};
cell.Colspan = 2;
cell.BorderWidthTop = cell.BorderWidthLeft = cell.BorderWidthRight = .25f;
cell.AddElement(new Paragraph(String.Format(SQMBasePage.GetXLAT(reportXLAT, "HS_5PHASE", "LOCATION").DESCRIPTION_SHORT + ": {0}", pageData.incidentDept), detailTxtFont));
tableHeader.AddCell(cell);
cell = new PdfPCell()
{
Padding = 2f, PaddingBottom = 5f, Border = 0
};
cell.BorderWidthTop = cell.BorderWidthLeft = .25f;
cell.AddElement(new Paragraph(String.Format("Date" + ": {0}", pageData.incidentDate), detailTxtFont));
tableHeader.AddCell(cell);
cell = new PdfPCell()
{
Padding = 2f, PaddingBottom = 5f, Border = 0
};
cell.BorderWidthTop = cell.BorderWidthLeft = .25f;
cell.AddElement(new Paragraph(String.Format("Time" + ": {0}", pageData.incidentTime), detailTxtFont));
tableHeader.AddCell(cell);
cell = FormatHeaderCell(pageData, (decimal)EHSQuestionId.Shift);
cell.BorderWidthTop = cell.BorderWidthLeft = cell.BorderWidthRight = .25f;
tableHeader.AddCell(cell);
cell = new PdfPCell()
{
Padding = 2f, PaddingBottom = 5f, Border = 0
};
cell.BorderWidthTop = cell.BorderWidthLeft = cell.BorderWidthBottom = .25f;
cell.AddElement(new Paragraph(String.Format(SQMBasePage.GetXLAT(reportXLAT, "HS_5PHASE", "SUPERVISOR").DESCRIPTION_SHORT + ": {0}", pageData.supervisorPerson == null ? "" : SQMModelMgr.FormatPersonListItem(pageData.supervisorPerson)), detailTxtFont));
tableHeader.AddCell(cell);
cell = new PdfPCell()
{
Padding = 2f, PaddingBottom = 5f, Border = 0
};
cell.Colspan = 2;
cell.BorderWidthTop = cell.BorderWidthLeft = cell.BorderWidthRight = cell.BorderWidthBottom = .25f;
cell.AddElement(new Paragraph(String.Format(SQMBasePage.GetXLAT(reportXLAT, "HS_5PHASE", "CONTACT_NO").DESCRIPTION_SHORT + ": {0}", pageData.supervisorPerson == null ? "" : pageData.supervisorPerson.PHONE), detailTxtFont));
tableHeader.AddCell(cell);
return(tableHeader);
}
PdfPCell FormatHeaderCell(AlertData pageData, decimal questionID)
{
PdfPCell cell = new PdfPCell()
{
Padding = 2f, PaddingBottom = 5f, Border = 0
};
if (questionID == 0)
{
cell.AddElement(new Paragraph(" ", detailTxtFont));
}
else
{
INCIDENT_ANSWER answer = pageData.answerList.Where(a => a.INCIDENT_QUESTION_ID == questionID).FirstOrDefault();
if (answer != null)
{
cell.AddElement(new Paragraph(String.Format(answer.ORIGINAL_QUESTION_TEXT + ": {0}", answer.ANSWER_VALUE), detailTxtFont));
}
else
{
cell.AddElement(new Paragraph(" ", detailTxtFont));
}
}
return(cell);
}
PdfPTable HeaderSection(AuditData pageData)
{
PdfPTable tableHeader = new PdfPTable(new float[] { 540f });
tableHeader.TotalWidth = 540f;
tableHeader.LockedWidth = true;
PdfPCell cell;
INCIDENT_ANSWER answer = null;
cell = new PdfPCell()
{
Padding = 2f, PaddingBottom = 2f, Border = 0
};
//cell.BorderWidthTop = cell.BorderWidthLeft = .25f;
cell.AddElement(new Paragraph(String.Format(SQMBasePage.GetXLAT(reportXLAT, "AUDIT_PRINT", "PLANT").DESCRIPTION_SHORT + ": {0}", pageData.auditLocation), detailTxtFont));
tableHeader.AddCell(cell);
cell = new PdfPCell()
{
Padding = 2f, PaddingBottom = 2f, Border = 0
};
//cell.BorderWidthTop = cell.BorderWidthLeft = cell.BorderWidthRight =.25f;
cell.AddElement(new Paragraph(String.Format(SQMBasePage.GetXLAT(reportXLAT, "AUDIT_PRINT", "DEPARTMENT").DESCRIPTION_SHORT + ": {0}", pageData.auditDepartment), detailTxtFont));
tableHeader.AddCell(cell);
cell = new PdfPCell()
{
Padding = 2f, PaddingBottom = 2f, Border = 0
};
//cell.BorderWidthTop = cell.BorderWidthLeft = cell.BorderWidthRight =.25f;
cell.AddElement(new Paragraph(String.Format(SQMBasePage.GetXLAT(reportXLAT, "AUDIT_PRINT", "DESCRIPTION").DESCRIPTION_SHORT + ": {0}", pageData.auditDescription), detailTxtFont));
tableHeader.AddCell(cell);
cell = new PdfPCell()
{
Padding = 2f, PaddingBottom = 2f, Border = 0
};
//cell.BorderWidthTop = cell.BorderWidthLeft = cell.BorderWidthRight =.25f;
cell.AddElement(new Paragraph(String.Format(SQMBasePage.GetXLAT(reportXLAT, "AUDIT_PRINT", "DATE").DESCRIPTION_SHORT + ": {0}", pageData.auditDate), detailTxtFont));
tableHeader.AddCell(cell);
cell = new PdfPCell()
{
Padding = 2f, PaddingBottom = 2f, Border = 0
};
//cell.BorderWidthTop = cell.BorderWidthLeft = cell.BorderWidthRight =.25f;
cell.AddElement(new Paragraph(String.Format(SQMBasePage.GetXLAT(reportXLAT, "AUDIT_PRINT", "CLOSE_DATE").DESCRIPTION_SHORT + ": {0}", pageData.auditCloseDate), detailTxtFont));
tableHeader.AddCell(cell);
cell = new PdfPCell()
{
Padding = 2f, PaddingBottom = 2f, Border = 0
};
//cell.BorderWidthTop = cell.BorderWidthLeft = cell.BorderWidthRight =.25f;
cell.AddElement(new Paragraph(String.Format(SQMBasePage.GetXLAT(reportXLAT, "AUDIT_PRINT", "AUDIT_PERSON").DESCRIPTION_SHORT + ": {0}", pageData.auditPerson == null ? "" : SQMModelMgr.FormatPersonListItem(pageData.auditPerson)), detailTxtFont));
tableHeader.AddCell(cell);
return(tableHeader);
}
protected void rgIncidentActionList_ItemDataBound(object sender, GridItemEventArgs e)
{
if (e.Item is GridDataItem)
{
GridDataItem item = (GridDataItem)e.Item;
HiddenField hf;
Label lbl;
EHSIncidentData data = (EHSIncidentData)e.Item.DataItem;
try
{
lbl = (Label)e.Item.FindControl("lblIncidentId");
lbl.Text = WebSiteCommon.FormatID(data.Incident.INCIDENT_ID, 6);
if (data.Incident.DESCRIPTION.Length > 200)
{
lbl = (Label)e.Item.FindControl("lblDescription");
lbl.Text = data.Incident.DESCRIPTION.Substring(0, 200) + "...";
}
lbl = (Label)e.Item.FindControl("lblDueDT");
INCIDENT_ANSWER entry = data.Incident.INCIDENT_ANSWER.Where(l => l.INCIDENT_QUESTION_ID == 65).FirstOrDefault(); // due date
if (entry != null && !string.IsNullOrEmpty(entry.ANSWER_VALUE))
{
lbl.Text = SQMBasePage.FormatDate(Convert.ToDateTime(entry.ANSWER_VALUE), "d", false);
entry = data.Incident.INCIDENT_ANSWER.Where(l => l.INCIDENT_QUESTION_ID == 64).FirstOrDefault(); // responsible person
if (entry != null && !string.IsNullOrEmpty(entry.ANSWER_VALUE))
{
lbl = (Label)e.Item.FindControl("lblResponsible");
lbl.Text = entry.ANSWER_VALUE;
}
}
RadGrid gv = (RadGrid)e.Item.FindControl("rgIncidentActions");
List <INCIDENT_ANSWER> incidentActionList = new List <INCIDENT_ANSWER>();
incidentActionList.AddRange(data.Incident.INCIDENT_ANSWER.Where(l => l.INCIDENT_QUESTION_ID == 24 || l.INCIDENT_QUESTION_ID == 27).ToList());
if (incidentActionList.Count > 0)
{
baseRowIndex = e.Item.RowIndex;
gv.DataSource = incidentActionList;
gv.DataBind();
gv.Visible = true;
}
LinkButton lb8d = (LinkButton)e.Item.FindControl("lb8d");
if (lb8d != null && UserContext.RoleAccess() <= AccessMode.Partner)
{
lb8d.Visible = false;
}
}
catch
{
}
}
}
AlertData PopulateByIncidentId(decimal iid)
{
AlertData d = new AlertData();
var entities = new PSsqmEntities();
d.incident = EHSIncidentMgr.SelectIncidentById(entities, iid);
if (d.incident != null)
{
try
{
string plantName = EHSIncidentMgr.SelectPlantNameById((decimal)d.incident.DETECT_PLANT_ID);
d.incidentLocation = plantName;
d.incidentNumber = WebSiteCommon.FormatID(iid, 6);
string incidentType = EHSIncidentMgr.SelectIncidentTypeByIncidentId(iid);
decimal incidentTypeId = EHSIncidentMgr.SelectIncidentTypeIdByIncidentId(iid);
decimal companyId = d.incident.DETECT_COMPANY_ID;
var questions = EHSIncidentMgr.SelectIncidentQuestionList(incidentTypeId, companyId, 0);
questions.AddRange(EHSIncidentMgr.SelectIncidentQuestionList(incidentTypeId, companyId, 1));
d.answerList = EHSIncidentMgr.GetIncidentAnswerList(d.incident.INCIDENT_ID);
INCIDENT_ANSWER answer = null;
// Date/Time
d.incidentDate = d.incident.INCIDENT_DT.ToShortDateString();
if ((answer = d.answerList.Where(a => a.INCIDENT_QUESTION_ID == (decimal)EHSQuestionId.TimeOfDay).SingleOrDefault()) != null)
{
if (!string.IsNullOrEmpty(answer.ANSWER_VALUE))
{
d.incidentTime = Convert.ToDateTime(answer.ANSWER_VALUE).ToShortTimeString();
}
}
if ((answer = d.answerList.Where(a => a.INCIDENT_QUESTION_ID == (decimal)EHSQuestionId.Shift).SingleOrDefault()) != null)
{
if (!string.IsNullOrEmpty(SQMBasePage.GetXLAT(reportXLAT, "SHIFT", answer.ANSWER_VALUE).DESCRIPTION))
{
answer.ANSWER_VALUE = SQMBasePage.GetXLAT(reportXLAT, "SHIFT", answer.ANSWER_VALUE).DESCRIPTION;
}
}
if ((answer = d.answerList.Where(a => a.INCIDENT_QUESTION_ID == (decimal)EHSQuestionId.Department).SingleOrDefault()) != null)
{
d.incidentDept = answer.ANSWER_VALUE;
decimal deptID = 0;
if (decimal.TryParse(answer.ANSWER_VALUE, out deptID))
{
DEPARTMENT dept = SQMModelMgr.LookupDepartment(entities, deptID);
if (dept != null)
{
d.incidentDept = dept.DEPT_NAME;
}
}
}
// Incident Type
d.incidentType = incidentType;
// Description
d.incidentDescription = d.incident.DESCRIPTION;
d.detectPerson = SQMModelMgr.LookupPerson(entities, (decimal)d.incident.CREATE_PERSON, "", false);
if (d.detectPerson != null)
{
d.supervisorPerson = SQMModelMgr.LookupPersonByEmpID(entities, d.detectPerson.SUPV_EMP_ID);
}
if (d.incident.ISSUE_TYPE_ID == (decimal)EHSIncidentTypeId.InjuryIllness)
{
if (d.incident.INCFORM_INJURYILLNESS.INVOLVED_PERSON_ID.HasValue)
{
d.involvedPerson = SQMModelMgr.LookupPerson(entities, (decimal)d.incident.INCFORM_INJURYILLNESS.INVOLVED_PERSON_ID, "", false);
if (d.involvedPerson != null)
{
if (d.incident.INCFORM_INJURYILLNESS.SUPERVISOR_PERSON_ID.HasValue) // supervisor was known
{
d.supervisorPerson = SQMModelMgr.LookupPerson(entities, (decimal)d.incident.INCFORM_INJURYILLNESS.SUPERVISOR_PERSON_ID, "", false);
}
else
{
// get current supervisor
d.supervisorPerson = SQMModelMgr.LookupPersonByEmpID(entities, d.involvedPerson.SUPV_EMP_ID);
}
}
}
else
{
d.involvedPerson = new PERSON();
d.involvedPerson.FIRST_NAME = d.incident.INCFORM_INJURYILLNESS.INVOLVED_PERSON_NAME;
}
if (d.incident.INCFORM_INJURYILLNESS.DEPT_ID.HasValue)
{
DEPARTMENT dept = SQMModelMgr.LookupDepartment(entities, (decimal)d.incident.INCFORM_INJURYILLNESS.DEPT_ID);
if (dept != null)
{
d.incidentDept = dept.DEPT_NAME;
}
}
else
{
d.incidentDept = d.incident.INCFORM_INJURYILLNESS.DEPARTMENT;
}
}
// Containment
foreach (INCFORM_CONTAIN cc in EHSIncidentMgr.GetContainmentList(iid, null, false))
{
if (cc.ASSIGNED_PERSON_ID.HasValue)
{
cc.ASSIGNED_PERSON = SQMModelMgr.FormatPersonListItem(SQMModelMgr.LookupPerson((decimal)cc.ASSIGNED_PERSON_ID, ""));
}
d.containList.Add(cc);
}
// Root Cause(s)
d.root5YList = EHSIncidentMgr.GetRootCauseList(iid).Where(l => !string.IsNullOrEmpty(l.ITEM_DESCRIPTION)).ToList();
if (d.root5YList != null && d.root5YList.Count > 0)
{
d.incident.INCFORM_CAUSATION.Load();
if (d.incident.INCFORM_CAUSATION != null && d.incident.INCFORM_CAUSATION.Count > 0)
{
d.causation = d.incident.INCFORM_CAUSATION.ElementAt(0);
}
}
// Corrective Actions
foreach (TASK_STATUS ac in EHSIncidentMgr.GetCorrectiveActionList(iid, null, false))
{
if (ac.RESPONSIBLE_ID.HasValue)
{
ac.COMMENTS = SQMModelMgr.FormatPersonListItem(SQMModelMgr.LookupPerson((decimal)ac.RESPONSIBLE_ID, ""));
}
d.actionList.Add(ac);
}
var files = (from a in entities.ATTACHMENT
where
(a.RECORD_ID == iid && a.RECORD_TYPE == 40 && a.DISPLAY_TYPE > 0) &&
(a.FILE_NAME.ToLower().Contains(".jpg") || a.FILE_NAME.ToLower().Contains(".jpeg") ||
a.FILE_NAME.ToLower().Contains(".gif") || a.FILE_NAME.ToLower().Contains(".png") ||
a.FILE_NAME.ToLower().Contains(".bmp"))
orderby a.RECORD_TYPE, a.FILE_NAME
select new
{
Data = (from f in entities.ATTACHMENT_FILE where f.ATTACHMENT_ID == a.ATTACHMENT_ID select f.ATTACHMENT_DATA).FirstOrDefault(),
Description = (string.IsNullOrEmpty(a.FILE_DESC)) ? "" : a.FILE_DESC,
}).ToList();
d.approvalList = EHSIncidentMgr.GetApprovalList(entities, (decimal)d.incident.ISSUE_TYPE_ID, 10.0m, iid, null, 0);
if (files.Count > 0)
{
d.photoData = new List <byte[]>();
d.photoCaptions = new List <string>();
foreach (var f in files)
{
d.photoData.Add(f.Data);
d.photoCaptions.Add(f.Description);
}
}
}
catch
{
}
}
return(d);
}
PdfPTable HeaderSection(AlertData pageData)
{
PdfPTable tableHeader = new PdfPTable(new float[] { 270f, 270f });
tableHeader.TotalWidth = 540f;
tableHeader.LockedWidth = true;
PdfPCell cell;
INCIDENT_ANSWER answer = null;
cell = new PdfPCell()
{
Padding = 2f, PaddingBottom = 5f, Border = 0
};
cell.BorderWidthTop = cell.BorderWidthLeft = .25f;
cell.AddElement(new Paragraph(String.Format(SQMBasePage.GetXLAT(reportXLAT, "HS_ALERT", "PLANT").DESCRIPTION_SHORT + ": {0}", pageData.incidentLocation), detailLblFont));
tableHeader.AddCell(cell);
cell = new PdfPCell()
{
Padding = 2f, PaddingBottom = 5f, Border = 0
};
cell.BorderWidthTop = cell.BorderWidthLeft = cell.BorderWidthRight = .25f;
cell.AddElement(new Paragraph(String.Format(SQMBasePage.GetXLAT(reportXLAT, "HS_ALERT", "LOCATION").DESCRIPTION_SHORT + ": {0}", pageData.incidentDept), detailLblFont));
tableHeader.AddCell(cell);
if (exportOption == "xls")
{
exportList.Add(new ReportCell()
{
Row = ++exportRow, Col = 1, Text = ""
});
exportList.Add(new ReportCell()
{
Row = ++exportRow, Col = 1, Text = SQMBasePage.GetXLAT(reportXLAT, "HS_ALERT", "PLANT").DESCRIPTION_SHORT
});
exportList.Add(new ReportCell()
{
Row = exportRow, Col = 2, Text = pageData.incidentLocation
});
exportList.Add(new ReportCell()
{
Row = ++exportRow, Col = 1, Text = SQMBasePage.GetXLAT(reportXLAT, "HS_ALERT", "LOCATION").DESCRIPTION_SHORT
});
exportList.Add(new ReportCell()
{
Row = exportRow, Col = 2, Text = pageData.incidentDept
});
}
cell = new PdfPCell()
{
Padding = 2f, PaddingBottom = 5f, Border = 0
};
cell.BorderWidthTop = cell.BorderWidthLeft = cell.BorderWidthBottom = cell.BorderWidthRight = .25f;
cell.AddElement(new Paragraph(String.Format("{0}" + ": {1}", SQMBasePage.GetXLAT(reportXLAT, "HS_ALERT", "DATE").DESCRIPTION_SHORT, pageData.incidentDate), detailLblFont));
tableHeader.AddCell(cell);
cell = new PdfPCell()
{
Padding = 2f, PaddingBottom = 5f, Border = 0
};
cell.BorderWidthTop = cell.BorderWidthBottom = cell.BorderWidthRight = .25f;
cell.AddElement(new Paragraph(String.Format("{0}" + ": {1}", SQMBasePage.GetXLAT(reportXLAT, "HS_ALERT", "TIME").DESCRIPTION_SHORT, pageData.incidentTime), detailLblFont));
tableHeader.AddCell(cell);
if (exportOption == "xls")
{
exportList.Add(new ReportCell()
{
Row = ++exportRow, Col = 1, Text = SQMBasePage.GetXLAT(reportXLAT, "HS_ALERT", "DATE").DESCRIPTION_SHORT
});
exportList.Add(new ReportCell()
{
Row = exportRow, Col = 2, Text = pageData.incidentDate
});
exportList.Add(new ReportCell()
{
Row = ++exportRow, Col = 1, Text = SQMBasePage.GetXLAT(reportXLAT, "HS_ALERT", "TIME").DESCRIPTION_SHORT
});
exportList.Add(new ReportCell()
{
Row = exportRow, Col = 2, Text = pageData.incidentTime
});
}
return(tableHeader);
}
protected void btnConversion_Click(object sender, EventArgs e)
{
int status = 0;
INCIDENT_ANSWER answer = null;
List <XLAT> xlatList = SQMBasePage.SelectXLATList(new string[6] {
"SHIFT", "INJURY_CAUSE", "INJURY_TYPE", "INJURY_PART", "INJURY_TENURE", "IQ_10"
});
foreach (EHSIncidentData eda in HSCalcs().ehsCtl.IncidentHst.Where(i => i.Incident.INCFORM_LAST_STEP_COMPLETED < 1 && i.Incident.INCIDENT_ID > 0))
{
INCIDENT incident = (from i in entities.INCIDENT where i.INCIDENT_ID == eda.Incident.INCIDENT_ID select i).SingleOrDefault();
incident.INCIDENT_ANSWER.Load();
// clear any prior conversion reecords
string delCmd = " = " + incident.INCIDENT_ID.ToString();
status = entities.ExecuteStoreCommand("DELETE FROM TASK_STATUS WHERE RECORD_TYPE = 40 AND RECORD_ID" + delCmd);
status = entities.ExecuteStoreCommand("DELETE FROM INCFORM_LOSTTIME_HIST WHERE INCIDENT_ID" + delCmd);
status = entities.ExecuteStoreCommand("DELETE FROM INCFORM_CONTAIN WHERE INCIDENT_ID" + delCmd);
status = entities.ExecuteStoreCommand("DELETE FROM INCFORM_ACTION WHERE INCIDENT_ID" + delCmd);
status = entities.ExecuteStoreCommand("DELETE FROM INCFORM_ROOT5Y WHERE INCIDENT_ID" + delCmd);
status = entities.ExecuteStoreCommand("DELETE FROM INCFORM_CAUSATION WHERE INCIDENT_ID" + delCmd);
status = entities.ExecuteStoreCommand("DELETE FROM INCFORM_APPROVAL WHERE INCIDENT_ID" + delCmd);
status = entities.ExecuteStoreCommand("DELETE FROM INCFORM_WITNESS WHERE INCIDENT_ID" + delCmd);
status = entities.ExecuteStoreCommand("DELETE FROM INCFORM_INJURYILLNESS WHERE INCIDENT_ID" + delCmd);
EHSIncidentTypeId issueType = (EHSIncidentTypeId)incident.ISSUE_TYPE_ID;
try
{
switch (issueType)
{
case EHSIncidentTypeId.PropertyDamage:
case EHSIncidentTypeId.PowerOutage:
case EHSIncidentTypeId.Fire:
case EHSIncidentTypeId.Explosion:
case EHSIncidentTypeId.ImsAudit:
case EHSIncidentTypeId.RegulatoryContact:
case EHSIncidentTypeId.FireSystemImpairment:
case EHSIncidentTypeId.SpillRelease:
case EHSIncidentTypeId.EhsWalk:
case EHSIncidentTypeId.NearMiss:
case EHSIncidentTypeId.InjuryIllness:
incident.INCFORM_LAST_STEP_COMPLETED = 100; // assume new status
answer = incident.INCIDENT_ANSWER.Where(a => a.INCIDENT_QUESTION_ID == 69).FirstOrDefault(); // containment
if (answer != null && !string.IsNullOrEmpty(answer.ANSWER_VALUE))
{
incident.INCFORM_LAST_STEP_COMPLETED = 110; // containment
INCFORM_CONTAIN contain = new INCFORM_CONTAIN();
contain.INCIDENT_ID = incident.INCIDENT_ID;
contain.ITEM_SEQ = 1;
contain.ITEM_DESCRIPTION = answer.ANSWER_VALUE;
contain.ASSIGNED_PERSON_ID = incident.CREATE_PERSON;
contain.START_DATE = contain.COMPLETION_DATE = incident.CREATE_DT;
contain.IsCompleted = true;
contain.LAST_UPD_BY = SessionManager.UserContext.UserName();
contain.LAST_UPD_DT = DateTime.UtcNow;
entities.AddToINCFORM_CONTAIN(contain);
}
answer = incident.INCIDENT_ANSWER.Where(a => a.INCIDENT_QUESTION_ID == 24).FirstOrDefault(); // root cause
if (answer != null && !string.IsNullOrEmpty(answer.ANSWER_VALUE))
{
incident.INCFORM_LAST_STEP_COMPLETED = 120; // root cause
INCFORM_ROOT5Y rootc = new INCFORM_ROOT5Y();
rootc.INCIDENT_ID = incident.INCIDENT_ID;
rootc.ITEM_SEQ = 1;
rootc.ITEM_DESCRIPTION = answer.ANSWER_VALUE;
rootc.LAST_UPD_BY = SessionManager.UserContext.UserName();
rootc.LAST_UPD_DT = DateTime.UtcNow;
entities.AddToINCFORM_ROOT5Y(rootc);
}
answer = incident.INCIDENT_ANSWER.Where(a => a.INCIDENT_QUESTION_ID == 78).FirstOrDefault(); // causation
if (answer != null && !string.IsNullOrEmpty(answer.ANSWER_VALUE))
{
incident.INCFORM_LAST_STEP_COMPLETED = 125; // causation
INCFORM_CAUSATION cause = new INCFORM_CAUSATION();
cause.INCIDENT_ID = incident.INCIDENT_ID;
cause.CAUSEATION_CD = xlatList.Where(l => l.XLAT_GROUP == "INJURY_CAUSE" && l.DESCRIPTION == answer.ANSWER_VALUE).FirstOrDefault() == null ? "1000" : xlatList.Where(l => l.XLAT_GROUP == "INJURY_CAUSE" && l.DESCRIPTION == answer.ANSWER_VALUE).FirstOrDefault().XLAT_CODE;
cause.LAST_UPD_BY = SessionManager.UserContext.UserName();
cause.LAST_UPD_DT = DateTime.UtcNow;
entities.AddToINCFORM_CAUSATION(cause);
}
answer = incident.INCIDENT_ANSWER.Where(a => a.INCIDENT_QUESTION_ID == 27).FirstOrDefault(); // corrective action
if (answer != null && !string.IsNullOrEmpty(answer.ANSWER_VALUE))
{
incident.INCFORM_LAST_STEP_COMPLETED = 130; // corrective action
TASK_STATUS action = new TASK_STATUS();
action.RECORD_TYPE = (int)TaskRecordType.HealthSafetyIncident;
action.RECORD_ID = incident.INCIDENT_ID;
action.TASK_STEP = ((int)SysPriv.action).ToString();
action.TASK_SEQ = 0;
action.RECORD_SUBID = 0;
action.TASK_TYPE = "T";
action.TASK_SEQ = 0;
action.DESCRIPTION = answer.ANSWER_VALUE;
action.DETAIL = incident.DESCRIPTION;
action.STATUS = "1";
action.CREATE_ID = action.RESPONSIBLE_ID = action.COMPLETE_ID = incident.CREATE_PERSON; // default action values
action.CREATE_DT = action.DUE_DT = action.COMPLETE_DT = incident.CREATE_DT;
answer = incident.INCIDENT_ANSWER.Where(a => a.INCIDENT_QUESTION_ID == 79).FirstOrDefault(); // responsible
if (answer != null && !string.IsNullOrEmpty(answer.ANSWER_VALUE))
{
action.RESPONSIBLE_ID = action.COMPLETE_ID = decimal.Parse(answer.ANSWER_VALUE);
}
answer = incident.INCIDENT_ANSWER.Where(a => a.INCIDENT_QUESTION_ID == 65).FirstOrDefault(); // action due date
if (answer != null && !string.IsNullOrEmpty(answer.ANSWER_VALUE))
{
action.DUE_DT = DateTime.ParseExact(answer.ANSWER_VALUE, "M/d/yyyy hh:mm:ss tt", null);
}
answer = incident.INCIDENT_ANSWER.Where(a => a.INCIDENT_QUESTION_ID == 66).FirstOrDefault(); // action complete date
if (answer != null && !string.IsNullOrEmpty(answer.ANSWER_VALUE))
{
action.COMPLETE_DT = DateTime.ParseExact(answer.ANSWER_VALUE, "M/d/yyyy hh:mm:ss tt", null);
}
answer = incident.INCIDENT_ANSWER.Where(a => a.INCIDENT_QUESTION_ID == 70).FirstOrDefault(); // verification ?
if (answer != null && !string.IsNullOrEmpty(answer.ANSWER_VALUE))
{
action.COMMENTS = answer.ANSWER_VALUE;
}
entities.AddToTASK_STATUS(action);
}
if (incident.CLOSE_DATE_DATA_COMPLETE.HasValue || incident.CLOSE_DATE.HasValue)
{
incident.INCFORM_LAST_STEP_COMPLETED = 151; // signoff
INCFORM_APPROVAL approval = new INCFORM_APPROVAL();
approval.INCIDENT_ID = incident.INCIDENT_ID;
approval.ITEM_SEQ = (int)SysPriv.approve1;
approval.APPROVAL_DATE = incident.CLOSE_DATE.HasValue ? incident.CLOSE_DATE : incident.CLOSE_DATE_DATA_COMPLETE;
approval.IsAccepted = true;
approval.APPROVER_PERSON_ID = incident.CLOSE_PERSON.HasValue ? incident.CLOSE_PERSON : incident.CREATE_PERSON;
PERSON person = (from p in entities.PERSON where p.PERSON_ID == approval.APPROVER_PERSON_ID select p).FirstOrDefault();
approval.APPROVAL_MESSAGE = approval.APPROVER_PERSON = (person.FIRST_NAME + " " + person.LAST_NAME);
answer = incident.INCIDENT_ANSWER.Where(a => a.INCIDENT_QUESTION_ID == 67).FirstOrDefault(); // completed by
if (answer != null && !string.IsNullOrEmpty(answer.ANSWER_VALUE))
{
approval.APPROVAL_MESSAGE = approval.APPROVER_PERSON = answer.ANSWER_VALUE;
string[] names = answer.ANSWER_VALUE.ToLower().Split(' ');
if (names.Length > 1)
{
string firstName = names[0];
string lastnamne = names[1];
person = (from p in entities.PERSON where p.FIRST_NAME.ToLower() == firstName && p.LAST_NAME.ToLower() == lastnamne select p).FirstOrDefault();
}
}
if (person != null)
{
approval.APPROVER_PERSON_ID = person.PERSON_ID;
approval.APPROVER_TITLE = person.JOB_TITLE;
}
entities.AddToINCFORM_APPROVAL(approval);
}
if (issueType == EHSIncidentTypeId.InjuryIllness)
{
INCFORM_INJURYILLNESS inRec = new INCFORM_INJURYILLNESS();
INCFORM_WITNESS witness = new INCFORM_WITNESS();
INCFORM_LOSTTIME_HIST hist = new INCFORM_LOSTTIME_HIST();
inRec.INCIDENT_ID = incident.INCIDENT_ID;
answer = incident.INCIDENT_ANSWER.Where(a => a.INCIDENT_QUESTION_ID == 6).FirstOrDefault(); // shift
inRec.SHIFT = GetXLATCode(xlatList, "SHIFT", answer.ANSWER_VALUE);
answer = incident.INCIDENT_ANSWER.Where(a => a.INCIDENT_QUESTION_ID == 7).FirstOrDefault(); // department
if (answer != null && !string.IsNullOrEmpty(answer.ANSWER_VALUE))
{
inRec.DEPARTMENT = answer.ANSWER_VALUE;
DEPARTMENT dept = (from d in entities.DEPARTMENT where d.DEPT_NAME.ToLower() == answer.ANSWER_VALUE.ToLower() select d).SingleOrDefault();
if (dept != null)
{
inRec.DEPT_ID = dept.DEPT_ID;
}
}
answer = incident.INCIDENT_ANSWER.Where(a => a.INCIDENT_QUESTION_ID == 8).FirstOrDefault(); // involved person
if (answer != null && !string.IsNullOrEmpty(answer.ANSWER_VALUE))
{
inRec.INVOLVED_PERSON_NAME = answer.ANSWER_VALUE;
}
answer = incident.INCIDENT_ANSWER.Where(a => a.INCIDENT_QUESTION_ID == 4).FirstOrDefault(); // supervisor inform date
if (answer != null && !string.IsNullOrEmpty(answer.ANSWER_VALUE))
{
inRec.SUPERVISOR_INFORMED_DT = DateTime.ParseExact(answer.ANSWER_VALUE, "M/d/yyyy hh:mm:ss tt", null);
}
answer = incident.INCIDENT_ANSWER.Where(a => a.INCIDENT_QUESTION_ID == 5).FirstOrDefault(); // time of incident
if (answer != null && !string.IsNullOrEmpty(answer.ANSWER_VALUE))
{
inRec.INCIDENT_TIME = TimeSpan.Parse(answer.ANSWER_VALUE);
}
answer = incident.INCIDENT_ANSWER.Where(a => a.INCIDENT_QUESTION_ID == 9).FirstOrDefault(); // witness
if (answer != null && !string.IsNullOrEmpty(answer.ANSWER_VALUE) && answer.ANSWER_VALUE.Split(' ').Length > 1)
{
witness.INCIDENT_ID = incident.INCIDENT_ID;
witness.WITNESS_NO = 1;
witness.WITNESS_NAME = answer.ANSWER_VALUE;
witness.LAST_UPD_BY = SessionManager.UserContext.UserName();
witness.LAST_UPD_DT = DateTime.UtcNow;
entities.AddToINCFORM_WITNESS(witness);
}
answer = incident.INCIDENT_ANSWER.Where(a => a.INCIDENT_QUESTION_ID == 10).FirstOrDefault(); // inside/outside
if (answer != null && !string.IsNullOrEmpty(answer.ANSWER_VALUE))
{
inRec.INSIDE_OUTSIDE_BLDNG = GetXLATCode(xlatList, "IQ_10", answer.ANSWER_VALUE);
}
answer = incident.INCIDENT_ANSWER.Where(a => a.INCIDENT_QUESTION_ID == 11).FirstOrDefault(); // weather
if (answer != null && !string.IsNullOrEmpty(answer.ANSWER_VALUE))
{
; // NO FIELD
}
answer = incident.INCIDENT_ANSWER.Where(a => a.INCIDENT_QUESTION_ID == 12).FirstOrDefault(); // injury type
if (answer != null && !string.IsNullOrEmpty(answer.ANSWER_VALUE))
{
inRec.INJURY_TYPE = GetXLATCode(xlatList, "INJURY_TYPE", answer.ANSWER_VALUE);
}
answer = incident.INCIDENT_ANSWER.Where(a => a.INCIDENT_QUESTION_ID == 13).FirstOrDefault(); // body part
if (answer != null && !string.IsNullOrEmpty(answer.ANSWER_VALUE))
{
inRec.INJURY_BODY_PART = GetXLATCode(xlatList, "INJURY_PART", answer.ANSWER_VALUE);
}
answer = incident.INCIDENT_ANSWER.Where(a => a.INCIDENT_QUESTION_ID == 15).FirstOrDefault(); // reocurrance
if (answer != null && !string.IsNullOrEmpty(answer.ANSWER_VALUE))
{
inRec.REOCCUR = answer.ANSWER_VALUE.ToLower() == "yes" ? true : false;
}
answer = incident.INCIDENT_ANSWER.Where(a => a.INCIDENT_QUESTION_ID == 16).FirstOrDefault(); // first aid case
if (answer != null && !string.IsNullOrEmpty(answer.ANSWER_VALUE))
{
inRec.FIRST_AID = answer.ANSWER_VALUE.ToLower() == "yes" ? true : false;
}
answer = incident.INCIDENT_ANSWER.Where(a => a.INCIDENT_QUESTION_ID == 37).FirstOrDefault(); // employee
if (answer != null && !string.IsNullOrEmpty(answer.ANSWER_VALUE))
{
inRec.COMPANY_SUPERVISED = answer.ANSWER_VALUE.ToLower() == "yes" ? true : false;
}
answer = incident.INCIDENT_ANSWER.Where(a => a.INCIDENT_QUESTION_ID == 58).FirstOrDefault(); // specific description
if (answer != null && !string.IsNullOrEmpty(answer.ANSWER_VALUE))
{
inRec.DESCRIPTION_LOCAL = answer.ANSWER_VALUE;
}
answer = incident.INCIDENT_ANSWER.Where(a => a.INCIDENT_QUESTION_ID == 62).FirstOrDefault(); // recordable
if (answer != null && !string.IsNullOrEmpty(answer.ANSWER_VALUE))
{
inRec.RECORDABLE = answer.ANSWER_VALUE.ToLower() == "yes" ? true : false;
}
answer = incident.INCIDENT_ANSWER.Where(a => a.INCIDENT_QUESTION_ID == 63).FirstOrDefault(); // lost time case
if (answer != null && !string.IsNullOrEmpty(answer.ANSWER_VALUE))
{
inRec.LOST_TIME = answer.ANSWER_VALUE.ToLower() == "yes" ? true : false;
if (inRec.LOST_TIME)
{
hist.INCIDENT_ID = incident.INCIDENT_ID;
hist.WORK_STATUS = "03";
hist.ITEM_DESCRIPTION = "Lost Time";
hist.BEGIN_DT = incident.INCIDENT_DT;
answer = incident.INCIDENT_ANSWER.Where(a => a.INCIDENT_QUESTION_ID == 3).FirstOrDefault(); // expected return date
if (answer != null && !string.IsNullOrEmpty(answer.ANSWER_VALUE))
{
hist.RETURN_EXPECTED_DT = DateTime.ParseExact(answer.ANSWER_VALUE, "M/d/yyyy hh:mm:ss tt", null);
}
answer = incident.INCIDENT_ANSWER.Where(a => a.INCIDENT_QUESTION_ID == 55).FirstOrDefault(); // actual return date
if (answer != null && !string.IsNullOrEmpty(answer.ANSWER_VALUE))
{
hist.RETURN_TOWORK_DT = DateTime.ParseExact(answer.ANSWER_VALUE, "M/d/yyyy hh:mm:ss tt", null);
}
hist.LAST_UPD_BY = SessionManager.UserContext.UserName();
hist.LAST_UPD_DT = DateTime.UtcNow;
entities.AddToINCFORM_LOSTTIME_HIST(hist);
}
}
answer = incident.INCIDENT_ANSWER.Where(a => a.INCIDENT_QUESTION_ID == 74).FirstOrDefault(); // occupational event ?
if (answer != null && !string.IsNullOrEmpty(answer.ANSWER_VALUE))
{
inRec.STD_PROCS_FOLLOWED = answer.ANSWER_VALUE.ToLower() == "yes" ? true : false; // map to std procedures ?
}
entities.AddToINCFORM_INJURYILLNESS(inRec);
}
status = entities.SaveChanges();
break;
case EHSIncidentTypeId.PreventativeAction:
break;
default:
break;
}
}
catch
{
decimal id;
id = incident.INCIDENT_ID;
}
}
}
protected void rgIncidentList_ItemDataBound(object sender, GridItemEventArgs e)
{
if (e.Item is GridDataItem)
{
GridDataItem item = (GridDataItem)e.Item;
HiddenField hf;
Label lbl;
EHSIncidentData data = (EHSIncidentData)e.Item.DataItem;
lbl = (Label)e.Item.FindControl("lblIncidentId");
lbl.Text = WebSiteCommon.FormatID(data.Incident.INCIDENT_ID, 6);
if (data.Incident.DESCRIPTION.Length > 120)
{
lbl = (Label)e.Item.FindControl("lblDescription");
lbl.Text = data.Incident.DESCRIPTION.Substring(0, 117) + "...";
}
lbl = (Label)e.Item.FindControl("lblDescription");
lbl.Text = HttpUtility.HtmlEncode(lbl.Text);
if (data.Person != null)
{
lbl = (Label)e.Item.FindControl("lblReportedBy");
lbl.Text = SQMModelMgr.FormatPersonListItem(data.Person);
}
lbl = (Label)e.Item.FindControl("lblIncStatus");
if (data.Status == "C")
{
lbl.Text = WebSiteCommon.GetXlatValue("incidentStatus", "C") + " " + SQMBasePage.FormatDate((DateTime)data.Incident.CLOSE_DATE, "d", false) + "<br/>(" + data.DaysToClose.ToString() + ")";
}
else if (data.Status == "C8")
{
lbl.Text = WebSiteCommon.GetXlatValue("incidentStatus", "C8") + " " + SQMBasePage.FormatDate((DateTime)data.Incident.CLOSE_DATE_8D, "d", false) + "<br/>(" + data.DaysToClose.ToString() + ")";
}
else if (data.Status == "N")
{
lbl.Text = "<strong>" + WebSiteCommon.GetXlatValue("incidentStatus", "N") + "</strong>";
}
else
{
lbl.Text = WebSiteCommon.GetXlatValue("incidentStatus", "A") + "<br/>(" + data.DaysOpen + ")";
}
LinkButton lb8d = (LinkButton)e.Item.FindControl("lb8d");
LinkButton lbEditReport = (LinkButton)e.Item.FindControl("lbEditReport");
HyperLink hlReport = (HyperLink)e.Item.FindControl("hlReport");
hlReport.Visible = true;
INCIDENT_ANSWER entry = data.Incident.INCIDENT_ANSWER.Where(l => l.INCIDENT_QUESTION_ID == (decimal)EHSQuestionId.Create8D).FirstOrDefault();
if (entry != null && entry.ANSWER_VALUE == "Yes")
{
if (UserContext.RoleAccess() > AccessMode.View)
{
lb8d.Visible = true;
}
else
{
lb8d.Visible = false;
}
lbEditReport.Visible = false;
var problemCaseId = EHSIncidentMgr.SelectProblemCaseIdByIncidentId(data.Incident.INCIDENT_ID);
if (problemCaseId > 0)
{
hlReport.NavigateUrl = "/EHS/EHS_Alert_PDF.aspx?pcid=" + EncryptionManager.Encrypt(problemCaseId.ToString());
LinkButton lbReport = (LinkButton)e.Item.FindControl("lbReport");
lbReport.Visible = true;
lbReport.CommandArgument = problemCaseId.ToString();
lbReport.Attributes.Add("CaseType", data.Incident.INCIDENT_TYPE);
}
}
else
{
lb8d.Visible = false;
lbEditReport.Visible = true;
hlReport.NavigateUrl = "/EHS/EHS_Alert_PDF.aspx?iid=" + EncryptionManager.Encrypt(data.Incident.INCIDENT_ID.ToString());
}
if (data.Incident.ISSUE_TYPE_ID == 10) // Prevention Verification
{
lbEditReport.Visible = false;
//HtmlImage imgEditReport = (HtmlImage)e.Item.FindControl("imgEditReport");
//imgEditReport.Visible = false;
}
if (rgIncidentList.MasterTableView.GetColumn("Attach").Visible&& data.AttachList != null)
{
lbl = (Label)e.Item.FindControl("lblAttach");
Ucl_Attach attch = (Ucl_Attach)Page.LoadControl("/Include/Ucl_Attach.ascx");
lbl.Parent.Controls.AddAt(lbl.Parent.Controls.IndexOf(lbl), attch);
attch.BindListAttachment(data.AttachList, "", 1);
}
}
}
