public int UpdateCausation(decimal incidentID)
{
int status = 0;
using (PSsqmEntities ctx = new PSsqmEntities())
{
status = ctx.ExecuteStoreCommand("DELETE FROM INCFORM_CAUSATION WHERE INCIDENT_ID = " + incidentID.ToString());
if (!string.IsNullOrEmpty(ddlCausation.SelectedValue))
{
INCFORM_CAUSATION causation = new INCFORM_CAUSATION();
causation.INCIDENT_ID = incidentID;
causation.CAUSEATION_CD = ddlCausation.SelectedValue;
causation.TEAM_LIST = tbTeam.Text.Trim();
causation.LAST_UPD_BY = SessionManager.UserContext.UserName();
causation.LAST_UPD_DT = WebSiteCommon.LocalTime(DateTime.UtcNow, IncidentLocationTZ);
ctx.AddToINCFORM_CAUSATION(causation);
status = ctx.SaveChanges();
EHSIncidentMgr.UpdateIncidentStatus(incidentID, IncidentStepStatus.rootcauseComplete, WebSiteCommon.LocalTime(DateTime.UtcNow, IncidentLocationTZ));
}
else
{
}
}
return(status);
}
void InitializeForm()
{
//call function for get the attachment files for Final Corrective Action.
GetAttachments(IncidentId);
IncidentId = (IsEditContext) ? IncidentId : NewIncidentId;
lblStatusMsg.Visible = false;
LocalIncident = EHSIncidentMgr.SelectIncidentById(new PSsqmEntities(), IncidentId);
if (LocalIncident == null)
{
return;
}
pnlAction.Visible = true;
if (PageMode == PageUseMode.ViewOnly)
{
divTitle.Visible = true;
lblFormTitle.Text = Resources.LocalizedText.CorrectiveAction;
}
rptAction.DataSource = EHSIncidentMgr.GetCorrectiveActionList(IncidentId, WebSiteCommon.LocalTime(DateTime.UtcNow, IncidentLocationTZ), PageMode == PageUseMode.ViewOnly ? false : true);
rptAction.DataBind();
pnlAction.Enabled = PageMode == PageUseMode.ViewOnly ? false : EHSIncidentMgr.CanUpdateIncident(LocalIncident, IsEditContext, SysPriv.action, LocalIncident.INCFORM_LAST_STEP_COMPLETED);
if (PageMode == PageUseMode.ViewOnly && rptAction.Items.Count == 0)
{
rptAction.Visible = false;
}
}
private decimal GetTaskLocation(TASK_STATUS task)
{
decimal plantID = SessionManager.UserContext.HRLocation.Plant.PLANT_ID;
switch ((TaskRecordType)task.RECORD_TYPE)
{
case TaskRecordType.HealthSafetyIncident:
case TaskRecordType.PreventativeAction:
INCIDENT incident = EHSIncidentMgr.SelectIncidentById(new PSsqmEntities(), task.RECORD_ID);
if (incident != null && incident.DETECT_PLANT_ID.HasValue)
{
plantID = (decimal)incident.DETECT_PLANT_ID;
}
break;
case TaskRecordType.Audit:
AUDIT audit = EHSAuditMgr.SelectAuditById(new PSsqmEntities(), task.RECORD_ID);
if (audit != null && audit.DETECT_PLANT_ID.HasValue)
{
plantID = (decimal)audit.DETECT_PLANT_ID;
}
break;
}
return(plantID);
}
public void PopulateInitialForm()
{
PSsqmEntities entities = new PSsqmEntities();
decimal typeId = (IsEditContext) ? EditIncidentTypeId : SelectedTypeId;
if (IncidentId > 0)
{
try
{
LocalIncident = (from i in entities.INCIDENT where i.INCIDENT_ID == IncidentId select i).SingleOrDefault();
PLANT plant = SQMModelMgr.LookupPlant(entities, (decimal)LocalIncident.DETECT_PLANT_ID, "");
if (plant != null)
{
IncidentLocationTZ = plant.LOCAL_TIMEZONE;
}
if (PageMode == PageUseMode.ViewOnly)
{
divTitle.Visible = true;
lblFormTitle.Text = Resources.LocalizedText.RootCause;
}
pnlRoot5Y.Enabled = PageMode == PageUseMode.ViewOnly ? false : EHSIncidentMgr.CanUpdateIncident(LocalIncident, IsEditContext, SysPriv.originate, LocalIncident.INCFORM_LAST_STEP_COMPLETED);
}
catch { }
}
InitializeForm();
}
protected string GetPlantName(decimal incidentId)
{
string content = "";
content = EHSIncidentMgr.SelectIncidentLocationNameByIncidentId(incidentId);
return(content);
}
void InitializeForm()
{
lblStatusMsg.Visible = false;
pnlContain.Visible = true;
LocalIncident = EHSIncidentMgr.SelectIncidentById(new PSsqmEntities(), IncidentId);
if (LocalIncident == null)
{
return;
}
PLANT plant = SQMModelMgr.LookupPlant(entities, (decimal)LocalIncident.DETECT_PLANT_ID, "");
if (plant != null)
{
IncidentLocationTZ = plant.LOCAL_TIMEZONE;
}
pnlContain.Visible = true;
if (PageMode == PageUseMode.ViewOnly)
{
divTitle.Visible = true;
lblFormTitle.Text = Resources.LocalizedText.InitialAction;
}
rptContain.DataSource = EHSIncidentMgr.GetContainmentList(IncidentId, WebSiteCommon.LocalTime(DateTime.UtcNow, IncidentLocationTZ), PageMode == PageUseMode.ViewOnly ? false : true);
rptContain.DataBind();
pnlContain.Enabled = PageMode == PageUseMode.ViewOnly ? false : EHSIncidentMgr.CanUpdateIncident(LocalIncident, IsEditContext, SysPriv.originate, LocalIncident.INCFORM_LAST_STEP_COMPLETED);
}
private void GetAttachments(decimal incidentId)
{
uploaderFinalCorrectiveAction.SetAttachmentRecordStep("1");
uploaderFinalCorrectiveAction.SetReportOption(false);
uploaderFinalCorrectiveAction.SetDescription(false);
// Specifying postback triggers allows uploader to persist on other postbacks (e.g. 8D checkbox toggle)
//uploader.RAUpload.PostbackTriggers = new string[] { "btnSubnavSave", "btnSaveReturn", "btnSaveContinue", "btnDelete", "btnDeleteInc", "btnSubnavIncident", "btnSubnavContainment", "btnSubnavRootCause", "btnSubnavAction", "btnSubnavApproval" };
//uploader.RAUpload.PostbackTriggers = new string[] { "btnSubnavSave", "btnSaveReturn", "btnSaveContinue", "btnDelete", "btnDeleteInc", "btnSubnavIncident", "btnSubnavContainment", "btnSubnavRootCause", "btnSubnavAction", "btnSubnavApproval" };
int attCnt = EHSIncidentMgr.AttachmentCounts(incidentId, 1);//Apply 1 for getting the attachment for Final Corrective Action section.
int px = 128;
if (attCnt > 0)
{
px = px + (attCnt * 30) + 35;
uploaderFinalCorrectiveAction.GetUploadedFilesIncidentSection(40, incidentId, "", (int)Incident_Section.FinalCorrectiveAttachment);
}
else
{
uploaderFinalCorrectiveAction.GetBlinkATTACHMENT();
}
/*
*
*/
// Set the html Div height based on number of attachments to be displayed in the grid:
//dvAttachLbl.Style.Add("height", px.ToString() + "px !important");
//dvAttach.Style.Add("height", px.ToString() + "px !important");
}
public int AddUpdateINCFORM_ALERT(decimal incidentId)
{
lblStatusMsg.Visible = false;
int status = 0;
bool allFieldsComplete = true;
localCtx = new PSsqmEntities();
INCFORM_ALERT incidentAlert = EHSIncidentMgr.LookupIncidentAlert(localCtx, IncidentId);
if (incidentAlert == null) // new alert
{
incidentAlert = new INCFORM_ALERT();
incidentAlert.INCIDENT_ID = LocalIncident.INCIDENT_ID;
incidentAlert.ALERT_TYPE = ((int)TaskRecordType.HealthSafetyIncident).ToString();
incidentAlert.CREATE_DT = DateTime.UtcNow;
incidentAlert.CREATE_BY = SessionManager.UserContext.UserName();
localCtx.AddToINCFORM_ALERT(incidentAlert);
lblAlertStatus.Text = XLATList.Where(l => l.XLAT_GROUP == "TASK_STATUS" && l.XLAT_CODE == "0").FirstOrDefault().DESCRIPTION;
}
SaveAttachments(incidentId);
incidentAlert.LOCATION_LIST = "";
foreach (RadComboBoxItem item in ddlLocations.Items.Where(i => i.Checked == true && i.Value.Contains("BU") == false).ToList())
{
incidentAlert.LOCATION_LIST += string.IsNullOrEmpty(incidentAlert.LOCATION_LIST) ? item.Value : (item.Value + ",");
}
incidentAlert.ALERT_GROUP = "";
foreach (RadComboBoxItem item in ddlNotifyGroup.Items.Where(i => i.Checked == true).ToList())
{
incidentAlert.ALERT_GROUP += string.IsNullOrEmpty(incidentAlert.ALERT_GROUP) ? item.Value : (item.Value + ",");
}
incidentAlert.RESPONSIBLE_GROUP = ddlResponsibleGroup.SelectedValue;
// incidentAlert.ALERT_DESC = tbAlertDesc.Text;
incidentAlert.COMMENTS = tbComments.Text;
incidentAlert.DUE_DT = rdpDueDate.SelectedDate;
// Update CEO-Comments value.
incidentAlert.CEO_COMMENTS = tbCeoComments.Text.Trim();
// send general notifications
if (incidentAlert.INCIDENT_ALERT_ID < 1)
{
EHSNotificationMgr.NotifyIncidentAlert(LocalIncident, ((int)SysPriv.notify).ToString(), "380",
ddlLocations.Items.Where(i => i.Checked == true && i.Value.Contains("BU") == false).Select(i => Convert.ToDecimal(i.Value)).ToList());
}
List <TASK_STATUS> alertTaskList = UpdateAlertTaskList(EHSIncidentMgr.GetAlertTaskList(localCtx, LocalIncident.INCIDENT_ID));
status = localCtx.SaveChanges();
// send specific task assignments
EHSNotificationMgr.NotifyIncidentAlertTaskAssignment(LocalIncident, alertTaskList.Where(l => l.RESPONSIBLE_ID.HasValue).ToList());
return(status);
}
void InitializeForm()
{
IncidentId = (IsEditContext) ? EditIncidentId : NewIncidentId;
pnlContain.Visible = true;
rptContain.DataSource = EHSIncidentMgr.GetContainmentList(IncidentId);
rptContain.DataBind();
}
void InitializeForm()
{
IncidentId = (IsEditContext) ? EditIncidentId : NewIncidentId;
pnlAction.Visible = true;
rptAction.DataSource = EHSIncidentMgr.GetFinalActionList(IncidentId);
rptAction.DataBind();
}
void InitializeForm()
{
IncidentId = (IsEditContext) ? EditIncidentId : NewIncidentId;
pnlRoot5Y.Visible = true;
rptRootCause.DataSource = EHSIncidentMgr.GetRootCauseList(IncidentId);
rptRootCause.DataBind();
}
protected void UpdateDisplayState(DisplayState state, decimal incidentID)
{
try
{
switch (state)
{
case DisplayState.IncidentList:
SearchIncidents();
SessionManager.ClearReturns();
break;
case DisplayState.IncidentNotificationNew:
SessionManager.ClearReturns();
if (rddlNewActionType.SelectedItem != null)
{
INCIDENT newIncident = new INCIDENT();
newIncident.DETECT_PLANT_ID = Convert.ToDecimal(ddlActionLocation.SelectedValue);
newIncident.ISSUE_TYPE_ID = (decimal)EHSIncidentTypeId.PreventativeAction;
newIncident.ISSUE_TYPE = rddlNewActionType.SelectedValue;
if (newIncident.DETECT_PLANT_ID < 1 || newIncident.ISSUE_TYPE_ID < 1)
{
ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Error creating new PrevAction');", true);
}
else
{
SessionManager.ReturnObject = newIncident;
SessionManager.ReturnStatus = true;
Response.Redirect("/EHS/EHS_PrevActionForm.aspx");
}
}
break;
case DisplayState.IncidentNotificationEdit:
SessionManager.ClearReturns();
INCIDENT theIncident = EHSIncidentMgr.SelectIncidentById(entities, incidentID);
if (theIncident != null)
{
SessionManager.ReturnObject = theIncident;
SessionManager.ReturnStatus = true;
string stepCmd = "";
if (!string.IsNullOrEmpty(Request.QueryString["s"])) // from inbox/calendar assume this is a task assignment. direct to corrective actions page
{
stepCmd = ("?s=" + Request.QueryString["s"]);
}
Response.Redirect("/EHS/EHS_PrevActionForm.aspx" + stepCmd);
}
break;
default:
SessionManager.ClearReturns();
break;
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Error updating PrevAction display state:'" + ex.Message + ");", true);
}
}
public static void NotifyOnCreate(decimal incidentId, decimal plantId)
{
var entities = new PSsqmEntities();
decimal companyId = SessionManager.UserContext.HRLocation.Company.COMPANY_ID;
decimal busOrgId = SessionManager.UserContext.HRLocation.BusinessOrg.BUS_ORG_ID;
var emailIds = new HashSet <decimal>();
INCIDENT incident = EHSIncidentMgr.SelectIncidentById(entities, incidentId);
string incidentLocation = EHSIncidentMgr.SelectIncidentLocationNameByIncidentId(incidentId);
string incidentType = EHSIncidentMgr.SelectIncidentTypeByIncidentId(incidentId);
List <ATTACHMENT> attachList = SQM.Website.Classes.SQMDocumentMgr.SelectAttachmentListByRecord(40, incidentId, "", "");
List <NOTIFY> notifications = SQMModelMgr.SelectNotifyHierarchy(companyId, busOrgId, plantId, 0, TaskRecordType.HealthSafetyIncident);
foreach (NOTIFY n in notifications)
{
if (n.NOTIFY_PERSON1 != null)
{
emailIds.Add((decimal)n.NOTIFY_PERSON1);
}
if (n.NOTIFY_PERSON2 != null)
{
emailIds.Add((decimal)n.NOTIFY_PERSON2);
}
}
if (emailIds.Count > 0)
{
string appUrl = SQMSettings.SelectSettingByCode(entities, "MAIL", "TASK", "MailURL").VALUE;
if (string.IsNullOrEmpty(appUrl))
{
appUrl = "the website";
}
string emailSubject = "Incident Created: " + incidentType + " (" + incidentLocation + ")";
string emailBody = "A new incident has been created:<br/>" +
"<br/>" +
incidentLocation + "<br/>" +
incidentType + "<br/>" +
"<br/>" +
incident.DESCRIPTION + "<br/>" +
"<br/>" +
"Please log in to " + appUrl + " to view the incident.";
foreach (decimal eid in emailIds)
{
string emailAddress = (from p in entities.PERSON where p.PERSON_ID == eid select p.EMAIL).FirstOrDefault();
Thread thread = new Thread(() => WebSiteCommon.SendEmail(emailAddress, emailSubject, emailBody, "", "web", attachList));
thread.IsBackground = true;
thread.Start();
//WebSiteCommon.SendEmail(emailAddress, emailSubject, emailBody, "");
}
}
}
protected void gvPreventLocationsList_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
decimal plantId = (decimal)gvPreventLocationsList.DataKeys[e.Row.RowIndex].Value;
RadGrid rg = (RadGrid)e.Row.FindControl("rgPlantContacts");
var personList = EHSIncidentMgr.SelectEhsPeopleAtPlant(plantId);
if (personList.Count > 0)
{
rg.DataSource = personList;
rg.DataBind();
if (IsEditContext == true)
{
// Find and select people previously selected
PSsqmEntities entities = new PSsqmEntities();
foreach (GridDataItem dataItem in rg.Items)
{
decimal personId = (decimal)dataItem.GetDataKeyValue("PERSON_ID");
if (personId != null)
{
var verificationLine = (from iv in entities.INCIDENT_VERIFICATION
where iv.INCIDENT_ID == IncidentId &&
iv.PLANT_ID == plantId &&
iv.PERSON_ID == personId
select iv).FirstOrDefault();
if (verificationLine != null)
{
dataItem.Selected = true;
if (verificationLine.HAS_RESPONDED == true)
{
Label confirmedLabel = (Label)dataItem.FindControl("lblConfirmed");
confirmedLabel.Visible = true;
}
}
}
}
}
}
else
{
e.Row.Visible = false;
}
var comments = EHSIncidentMgr.SelectIncidentComments(IncidentId, plantId);
Panel pc = (Panel)e.Row.FindControl("pnlComments");
RadGrid rgc = (RadGrid)e.Row.FindControl("rgPlantComments");
if (comments.Count > 0)
{
pc.Visible = true;
rgc.DataSource = comments;
rgc.DataBind();
}
}
}
void InitializeForm()
{
List <INCFORM_ROOT5Y> rootCauseList = EHSIncidentMgr.GetRootCauseList(IncidentId, false);
rootCauseList = EHSIncidentMgr.FormatRootCauseList(LocalIncident, rootCauseList);
rptRootCause.DataSource = rootCauseList.OrderBy(l => l.PROBLEM_SERIES).ThenBy(l => l.ITEM_SEQ).ToList();
rptRootCause.DataBind();
}
public void PopulateInitialForm()
{
PSsqmEntities entities = new PSsqmEntities();
decimal typeId = (IsEditContext) ? EditIncidentTypeId : SelectedTypeId;
formSteps = EHSIncidentMgr.GetStepsForincidentTypeId(typeId);
totalFormSteps = formSteps.Count();
InitializeForm();
}
void InitializeForm()
{
IncidentId = (IsEditContext) ? EditIncidentId : NewIncidentId;
//SetUserAccess("INCFORM_LOSTTIME_HIST");
pnlLostTime.Visible = true;
rptLostTime.DataSource = EHSIncidentMgr.GetLostTimeList(IncidentId);
rptLostTime.DataBind();
}
void InitializeForm()
{
IncidentId = (IsEditContext) ? EditIncidentId : NewIncidentId;
SetUserAccess("INCFORM_APPROVAL");
pnlApproval.Visible = true;
rptApprovals.DataSource = EHSIncidentMgr.GetApprovalList(IncidentId);
rptApprovals.DataBind();
}
protected void rptAction_ItemCommand(object source, RepeaterCommandEventArgs e)
{
List <TASK_STATUS> actionList = GetActionListFromGrid();
if (e.CommandArgument.ToString() == "ActionType")
{
Panel pnl = (Panel)e.Item.FindControl("pnlActionType");
if (pnl.Visible)
{
pnl.Visible = false;
pnl = (Panel)e.Item.FindControl("pnlActionTypeSelect");
pnl.Visible = true;
HiddenField hf = (HiddenField)e.Item.FindControl("hfActionType");
XLAT xlat = XLATList.Where(l => l.XLAT_GROUP == "ACTION_CATEGORY" && l.XLAT_CODE == hf.Value).FirstOrDefault();
if (xlat != null)
{
Label lb = (Label)e.Item.FindControl("lblActionType");
lb.Text = xlat.DESCRIPTION;
}
}
else
{
pnl.Visible = true;
pnl = (Panel)e.Item.FindControl("pnlActionTypeSelect");
pnl.Visible = false;
}
}
if (e.CommandArgument.ToString() == "Delete")
{
int delId = e.Item.ItemIndex;
TASK_STATUS action = actionList.ElementAt(delId);
if (action != null)
{
if (action.TASK_ID > 0) // only delete existing actions
{
using (PSsqmEntities entities = new PSsqmEntities())
{
entities.ExecuteStoreCommand("DELETE FROM TASK_STATUS WHERE TASK_ID = " + action.TASK_ID.ToString());
}
}
actionList.Remove(action);
if (actionList.Count == 0)
{
actionList.Add(EHSIncidentMgr.CreateEmptyTask(ActionIncident.INCIDENT_ID, ((int)SysPriv.action).ToString(), 1, WebSiteCommon.LocalTime(DateTime.UtcNow, IncidentLocationTZ)));
}
}
rptAction.DataSource = actionList;
rptAction.DataBind();
decimal incidentId = (IsEditContext) ? IncidentId : NewIncidentId;
}
}
protected void AddDelete_Click(object sender, EventArgs e)
{
Button btn = (Button)sender;
if (btn.CommandArgument == "AddAnother")
{
List <TASK_STATUS> actionList = GetActionListFromGrid();
int newSeq = actionList.Max(l => l.TASK_SEQ).Value + 1;
actionList.Add(EHSIncidentMgr.CreateEmptyTask(ActionIncident.INCIDENT_ID, ((int)SysPriv.action).ToString(), newSeq, WebSiteCommon.LocalTime(DateTime.UtcNow, IncidentLocationTZ)));
rptAction.DataSource = actionList;
rptAction.DataBind();
}
}
protected List <TASK_STATUS> UpdateAlertTaskList(List <TASK_STATUS> alertTaskList)
{
// create task for each location and/or update existing task
TASK_STATUS task = null;
int taskSeq = 0;
bool isNew = false;
RadComboBox ddl = null;
HiddenField hf = null;
foreach (GridDataItem item in rgAlertTaskList.Items)
{
hf = (HiddenField)item.FindControl("hfTaskID");
ddl = (RadComboBox)item.FindControl("ddlResponsible");
if (string.IsNullOrEmpty(hf.Value)) // create new
{
isNew = true;
task = new TASK_STATUS();
hf = (HiddenField)item.FindControl("hfLocationTZ");
task = EHSIncidentMgr.CreateEmptyTask(LocalIncident.INCIDENT_ID, ((int)SysPriv.notify).ToString(), ++taskSeq, WebSiteCommon.LocalTime(DateTime.UtcNow, hf.Value));
task.RECORD_TYPE = (int)TaskRecordType.HealthSafetyIncident;
hf = (HiddenField)item.FindControl("hfLocation");
task.RECORD_SUBID = Convert.ToDecimal(hf.Value);
task.RECORD_ID = LocalIncident.INCIDENT_ID;
alertTaskList.Add(task);
localCtx.AddToTASK_STATUS(task);
}
else
{
isNew = false;
task = alertTaskList.Where(l => l.TASK_ID.ToString() == hf.Value).FirstOrDefault(); // existing
}
// task.DESCRIPTION = tbAlertDesc.Text;
task.DETAIL = tbComments.Text;
task.DUE_DT = rdpDueDate.SelectedDate;
if (!string.IsNullOrEmpty(ddl.SelectedValue))
{
task.RESPONSIBLE_ID = Convert.ToDecimal(ddl.SelectedValue);
}
else
{
alertTaskList.Remove(task);
localCtx.DeleteObject(task);
}
}
return(alertTaskList);
}
private int SaveLostTime(decimal incidentId, List <INCFORM_LOSTTIME_HIST> itemList)
{
int status = 0;
PSsqmEntities entities = new PSsqmEntities();
using (var ctx = new PSsqmEntities())
{
ctx.ExecuteStoreCommand("DELETE FROM INCFORM_LOSTTIME_HIST WHERE INCIDENT_ID = {0}", incidentId);
}
int seq = 0;
foreach (INCFORM_LOSTTIME_HIST item in itemList)
{
var newItem = new INCFORM_LOSTTIME_HIST();
if (!String.IsNullOrEmpty(item.WORK_STATUS) && item.WORK_STATUS != "")
{
newItem.INCIDENT_ID = incidentId;
newItem.ITEM_DESCRIPTION = item.ITEM_DESCRIPTION;
newItem.WORK_STATUS = item.WORK_STATUS;
newItem.BEGIN_DT = item.BEGIN_DT;
newItem.RETURN_TOWORK_DT = item.RETURN_TOWORK_DT;
newItem.NEXT_MEDAPPT_DT = item.NEXT_MEDAPPT_DT;
newItem.RETURN_EXPECTED_DT = item.RETURN_EXPECTED_DT;
newItem.LAST_UPD_BY = SessionManager.UserContext.Person.FIRST_NAME + " " + SessionManager.UserContext.Person.LAST_NAME;
newItem.LAST_UPD_DT = WebSiteCommon.LocalTime(DateTime.UtcNow, IncidentLocationTZ);
entities.AddToINCFORM_LOSTTIME_HIST(newItem);
status = entities.SaveChanges();
}
}
if (seq > 0)
{
EHSIncidentMgr.UpdateIncidentStatus(incidentId, IncidentStepStatus.workstatus, WebSiteCommon.LocalTime(DateTime.UtcNow, IncidentLocationTZ));
}
/*
* if (status > -1)
* {
* EHSNotificationMgr.NotifyIncidentStatus(WorkStatusIncident, ((int)SysPriv.update).ToString(), "Work status updated");
* }
*/
return(status);
}
public static List <PERSON> InvolvedPersonList(INCIDENT incident)
{
List <PERSON> involvedList = new List <PERSON>();
if (incident.ISSUE_TYPE_ID == (int)EHSIncidentTypeId.InjuryIllness)
{
PSsqmEntities ctx = new PSsqmEntities();
INCFORM_INJURYILLNESS iiDetail = EHSIncidentMgr.SelectInjuryIllnessDetailsById(ctx, incident.INCIDENT_ID);
if (iiDetail != null && iiDetail.INVOLVED_PERSON_ID.HasValue)
{
involvedList = SQMModelMgr.GetSupvHierarchy(ctx, SQMModelMgr.LookupPerson(ctx, (decimal)iiDetail.INVOLVED_PERSON_ID, "", false), 2, true);
}
}
return(involvedList);
}
protected void rbNew_Click(object sender, EventArgs e)
{
List <BusinessLocation> locationList = SessionManager.PlantList;
locationList = UserContext.FilterPlantAccessList(locationList);
SQMBasePage.SetLocationList(ddlIncidentLocation, locationList, 0, true);
var incidentTypeList = EHSIncidentMgr.SelectIncidentTypeList(companyId, SessionManager.UserContext.Language.NLS_LANGUAGE);
rddlNewIncidentType.DataSource = incidentTypeList;
rddlNewIncidentType.DataTextField = "TITLE";
rddlNewIncidentType.DataValueField = "INCIDENT_TYPE_ID";
rddlNewIncidentType.DataBind();
string script = "function f(){OpenNewIncidentWindow(); Sys.Application.remove_load(f);}Sys.Application.add_load(f);";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "key", script, true);
}
void InitializeForm()
{
IncidentId = (IsEditContext) ? IncidentId : NewIncidentId;
//SetUserAccess("INCFORM_LOSTTIME_HIST");
if (IncidentId >= 0)
{
pnlLostTime.Visible = true;
if (PageMode == PageUseMode.ViewOnly)
{
divTitle.Visible = true;
lblFormTitle.Text = Resources.LocalizedText.LostTimeHistory;
}
rptLostTime.DataSource = EHSIncidentMgr.GetLostTimeList(IncidentId);
rptLostTime.DataBind();
//EHSIncidentMgr.CalculateWorkStatusSummary(EHSIncidentMgr.CalculateWorkStatusAccounting(new PSsqmEntities(), IncidentId, null, null));
}
}
protected int SaveRootCauses(decimal incidentId, List <INCFORM_ROOT5Y> itemList)
{
PSsqmEntities entities = new PSsqmEntities();
int status = 0;
using (var ctx = new PSsqmEntities())
{
ctx.ExecuteStoreCommand("DELETE FROM INCFORM_ROOT5Y WHERE INCIDENT_ID = {0}", incidentId);
}
int seq = 0;
foreach (INCFORM_ROOT5Y item in itemList)
{
var newItem = new INCFORM_ROOT5Y();
if (!string.IsNullOrEmpty(item.ITEM_DESCRIPTION))
{
seq = seq + 1;
newItem.INCIDENT_ID = incidentId;
newItem.ITEM_SEQ = seq;
newItem.ITEM_TYPE = item.ITEM_TYPE;
newItem.PROBLEM_SERIES = item.PROBLEM_SERIES;
newItem.ITEM_DESCRIPTION = item.ITEM_DESCRIPTION;
newItem.IS_ROOTCAUSE = item.IS_ROOTCAUSE;
newItem.LAST_UPD_BY = SessionManager.UserContext.Person.FIRST_NAME + " " + SessionManager.UserContext.Person.LAST_NAME;
newItem.LAST_UPD_DT = WebSiteCommon.LocalTime(DateTime.UtcNow, IncidentLocationTZ);
entities.AddToINCFORM_ROOT5Y(newItem);
status = entities.SaveChanges();
}
}
if (seq > 0)
{
EHSIncidentMgr.UpdateIncidentStatus(incidentId, IncidentStepStatus.rootcause, WebSiteCommon.LocalTime(DateTime.UtcNow, IncidentLocationTZ));
}
return(status);
}
private int SaveContainment(decimal incidentId, List <INCFORM_CONTAIN> itemList)
{
PSsqmEntities entities = new PSsqmEntities();
int status = 0;
using (var ctx = new PSsqmEntities())
{
ctx.ExecuteStoreCommand("DELETE FROM INCFORM_CONTAIN WHERE INCIDENT_ID = {0}", incidentId);
}
int seq = 0;
foreach (INCFORM_CONTAIN item in itemList)
{
var newItem = new INCFORM_CONTAIN();
if (!string.IsNullOrEmpty(item.ITEM_DESCRIPTION))
{
seq = seq + 1;
newItem.INCIDENT_ID = incidentId;
newItem.ITEM_SEQ = seq;
newItem.ITEM_DESCRIPTION = item.ITEM_DESCRIPTION;
newItem.ASSIGNED_PERSON_ID = item.ASSIGNED_PERSON_ID;
newItem.START_DATE = item.START_DATE;
newItem.COMMENTS = item.COMMENTS;
newItem.LAST_UPD_BY = SessionManager.UserContext.Person.FIRST_NAME + " " + SessionManager.UserContext.Person.LAST_NAME;
newItem.LAST_UPD_DT = WebSiteCommon.LocalTime(DateTime.UtcNow, IncidentLocationTZ);
entities.AddToINCFORM_CONTAIN(newItem);
status = entities.SaveChanges();
}
}
if (seq > 0)
{
EHSIncidentMgr.UpdateIncidentStatus(incidentId, IncidentStepStatus.containment, WebSiteCommon.LocalTime(DateTime.UtcNow, IncidentLocationTZ));
}
return(status);
}
private int SaveActions(decimal incidentId, List <TASK_STATUS> actionList)
{
PSsqmEntities entities = new PSsqmEntities();
int status = 0;
foreach (TASK_STATUS action in actionList)
{
if (!string.IsNullOrEmpty(action.DESCRIPTION) && action.DUE_DT.HasValue && action.RESPONSIBLE_ID.HasValue)
{
EHSIncidentMgr.CreateOrUpdateTask(ActionIncident, action, WebSiteCommon.LocalTime(DateTime.UtcNow, IncidentLocationTZ));
}
}
if (status > -1)
{
EHSNotificationMgr.NotifyIncidentStatus(ActionIncident, ((int)SysPriv.update).ToString(), "Corrective action specified");
}
EHSIncidentMgr.UpdateIncidentStatus(incidentId, IncidentStepStatus.correctiveaction, WebSiteCommon.LocalTime(DateTime.UtcNow, IncidentLocationTZ));
return(status);
}
public int PopulateInitialForm(PSsqmEntities ctx)
{
int status = 0;
INCIDENT incident = EHSIncidentMgr.SelectIncidentById(ctx, IncidentId, true);
//if incident is not null populate the form
if (incident != null)
{
PLANT plant = SQMModelMgr.LookupPlant(ctx, (decimal)incident.DETECT_PLANT_ID, "");
if (plant != null)
{
IncidentLocationTZ = plant.LOCAL_TIMEZONE;
}
BindCausation(incident);
pnlCausation.Enabled = PageMode == PageUseMode.ViewOnly ? false : EHSIncidentMgr.CanUpdateIncident(incident, IsEditContext, SysPriv.originate, incident.INCFORM_LAST_STEP_COMPLETED);
}
return(status);
}
private int SaveActions(decimal incidentId, List <INCFORM_ACTION> itemList)
{
PSsqmEntities entities = new PSsqmEntities();
int status = 0;
using (var ctx = new PSsqmEntities())
{
ctx.ExecuteStoreCommand("DELETE FROM INCFORM_ACTION WHERE INCIDENT_ID = {0}", incidentId);
}
int seq = 0;
foreach (INCFORM_ACTION item in itemList)
{
var newItem = new INCFORM_ACTION();
if (!string.IsNullOrEmpty(item.ITEM_DESCRIPTION))
{
seq = seq + 1;
newItem.INCIDENT_ID = incidentId;
newItem.ITEM_SEQ = seq;
newItem.ITEM_DESCRIPTION = item.ITEM_DESCRIPTION;
newItem.ASSIGNED_PERSON_ID = item.ASSIGNED_PERSON_ID;
newItem.START_DATE = item.START_DATE;
newItem.COMPLETION_DATE = item.COMPLETION_DATE;
newItem.IsCompleted = item.IsCompleted;
newItem.LAST_UPD_BY = SessionManager.UserContext.Person.FIRST_NAME + " " + SessionManager.UserContext.Person.LAST_NAME;
newItem.LAST_UPD_DT = DateTime.Now;
entities.AddToINCFORM_ACTION(newItem);
status = entities.SaveChanges();
DateTime dueDate = newItem.START_DATE.HasValue ? (DateTime)newItem.START_DATE : DateTime.Now.AddDays(2);
EHSIncidentMgr.CreateOrUpdateTask(incidentId, (decimal)item.ASSIGNED_PERSON_ID, 40, dueDate, item.ITEM_DESCRIPTION);
}
}
return(status);
}
