private void UpdateAnswerStatus(decimal auditID, decimal questionID)
{
EHSAuditQuestion auditQuestion = EHSAuditMgr.SelectAuditQuestion(auditID, questionID);
if (auditQuestion != null)
{
if (TaskXLATList == null || TaskXLATList.Count == 0)
{
TaskXLATList = SQMBasePage.SelectXLATList(new string[1] {
"AUDIT_EXCEPTION_STATUS"
});
}
ddlAnswerStatus.DataTextField = "DESCRIPTION";
ddlAnswerStatus.DataValueField = "XLAT_CODE";
ddlAnswerStatus.DataSource = TaskXLATList;
ddlAnswerStatus.DataBind();
if (auditQuestion.Status == null || auditQuestion.Status == "")
{
ddlAnswerStatus.SelectedIndex = 0;
}
else
{
ddlAnswerStatus.SelectedValue = auditQuestion.Status;
}
btnStatusSave.CommandArgument = auditID + "~" + questionID;
string script = "function f(){OpenUpdateAnswerStatusWindow(); Sys.Application.remove_load(f);}Sys.Application.add_load(f);";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "key", script, true);
}
}
public void PopulateInitialForm()
{
PSsqmEntities entities = new PSsqmEntities();
IncidentId = (IsEditContext) ? IncidentId : NewIncidentId;
if (IncidentId > 0)
{
try
{
ActionIncident = (from i in entities.INCIDENT where i.INCIDENT_ID == IncidentId select i).Single();
PLANT plant = SQMModelMgr.LookupPlant(entities, (decimal)ActionIncident.DETECT_PLANT_ID, "");
if (plant != null)
{
IncidentLocationTZ = plant.LOCAL_TIMEZONE;
}
}
catch { }
XLATList = SQMBasePage.SelectXLATList(new string[1] {
"ACTION_CATEGORY"
}, SessionManager.UserContext.Person.PREFERRED_LANG_ID.HasValue ? (int)SessionManager.UserContext.Person.PREFERRED_LANG_ID : 1);
decimal typeId = (IsEditContext) ? EditIncidentTypeId : SelectedTypeId;
// what the f**k does this do ?
//formSteps = EHSIncidentMgr.GetStepsForincidentTypeId(typeId);
//totalFormSteps = formSteps.Count();
InitializeForm();
}
}
public void BindTaskList(List <TASK_STATUS> taskList, string context)
{
if (TaskXLATList == null || TaskXLATList.Count == 0)
{
TaskXLATList = SQMBasePage.SelectXLATList(new string[4] {
"TASK_STATUS", "RECORD_TYPE", "INCIDENT_STATUS", "NOTIFY_SCOPE_TASK"
});
}
pnlTaskSchedule.Visible = pnlTaskStrip.Visible = false;
pnlTaskList.Visible = true;
rgTaskList.DataSource = taskList;
rgTaskList.DataBind();
if (taskList.Count > 0)
{
rgTaskList.Visible = true;
lblTaskListEmpty.Visible = false;
}
else
{
rgTaskList.Visible = false;
lblTaskListEmpty.Visible = true;
}
}
public void PopulateInitialForm(PSsqmEntities ctx)
{
XLATList = SQMBasePage.SelectXLATList(new string[20] {
"TASK_STATUS", "BusinessType", "BT_01", "BT_02", "BT_03", "BT_04", "MPT_S_01", "MPT_S_16", "MPT_S_18", "MPT_S_19", "MPT_B_09", "MPT_B_10", "MPT_B_23", "MPT_P_05", "MPT_P_06", "MPT_P_10", "MPT_P_11", "MPT_P_13", "MPT_AEL_1", "MPT_AEL_2"
}, SessionManager.UserContext.Person.PREFERRED_LANG_ID.HasValue ? (int)SessionManager.UserContext.Person.PREFERRED_LANG_ID : 1);
InitializeForm(ctx);
}
void PopulateBodyPartDropDown()
{
bool categorize = SessionManager.GetUserSetting("EHS", "INJURYPART_CATEGORIZE") != null && SessionManager.GetUserSetting("EHS", "INJURYPART_CATEGORIZE").VALUE == "Y" ? true : false;
List <XLAT> xlatList = SQMBasePage.SelectXLATList(new string[1] {
"INJURY_PART"
}, SessionManager.UserContext.Person.PREFERRED_LANG_ID.HasValue ? (int)SessionManager.UserContext.Person.PREFERRED_LANG_ID : 1);
SQMBasePage.SetCategorizedDropDownItems(rdlBodyPart, xlatList.Where(l => l.XLAT_GROUP == "INJURY_PART").ToList(), categorize);
}
void PopulateBodyPartDropDown()
{
//bool categorize = EHSSettings.Where(s => s.SETTING_CD == "INJURYPART_CATEGORIZE").FirstOrDefault() != null && EHSSettings.Where(s => s.SETTING_CD == "INJURYPART_CATEGORIZE").FirstOrDefault().VALUE.ToUpper() == "Y" ? true : false;
bool categorize = false;
List <XLAT> xlatList = SQMBasePage.SelectXLATList(new string[1] {
"INJURY_PART"
}, SessionManager.UserContext.Person.PREFERRED_LANG_ID.HasValue ? (int)SessionManager.UserContext.Person.PREFERRED_LANG_ID : 1);
SQMBasePage.SetCategorizedDropDownItems(rdlBodyPart, xlatList.Where(l => l.XLAT_GROUP == "INJURY_PART").ToList(), categorize);
}
protected void rgAuditAnswers_ItemDataBound(object sender, GridItemEventArgs e)
{
if (e.Item is GridDataItem)
{
GridDataItem item = (GridDataItem)e.Item;
HiddenField hf;
LinkButton lnk;
Label lbl;
EHSAuditQuestion data = (EHSAuditQuestion)e.Item.DataItem;
lnk = (LinkButton)e.Item.FindControl("lnkAddTask");
lnk.CommandArgument = data.AuditId.ToString() + "," + data.QuestionId.ToString();
string buttonText = Resources.LocalizedText.AssignTask + "(" + data.TasksAssigned.ToString() + ")";
lnk.Text = buttonText;
lnk = (LinkButton)e.Item.FindControl("lnkAddAttach");
lnk.CommandArgument = data.AuditId.ToString() + "," + data.QuestionId.ToString();
buttonText = Resources.LocalizedText.Attachments + "(" + data.FilesAttached.ToString() + ")";
lnk.Text = buttonText;
lnk = (LinkButton)e.Item.FindControl("lnkUpdateStatus");
lnk.CommandArgument = data.AuditId.ToString() + "," + data.QuestionId.ToString();
if (!hdnAuditPerson.Value.ToString().Equals(SessionManager.UserContext.Person.PERSON_ID.ToString()))
{
lnk.Visible = false;
}
if (TaskXLATList == null || TaskXLATList.Count == 0)
{
TaskXLATList = SQMBasePage.SelectXLATList(new string[1] {
"AUDIT_EXCEPTION_STATUS"
});
}
lbl = (Label)e.Item.FindControl("lblAnswerStatus");
if (data.Status == null)
{
lbl.Text = TaskXLATList.Where(l => l.XLAT_GROUP == "AUDIT_EXCEPTION_STATUS" && l.XLAT_CODE == "01").FirstOrDefault().DESCRIPTION;
}
else
{
lbl.Text = TaskXLATList.Where(l => l.XLAT_GROUP == "AUDIT_EXCEPTION_STATUS" && l.XLAT_CODE == data.Status.ToString()).FirstOrDefault().DESCRIPTION;
}
lbl = (Label)e.Item.FindControl("lblResolutionDate");
if (data.CompleteDate == null || data.CompleteDate.Year == 1)
{
lbl.Text = "";
}
else
{
lbl.Text = data.CompleteDate.ToString("MM/dd/yyyy");
}
}
}
//protected void btnReceiptsSearchClick(object sender, EventArgs e)
//{
// if (OnSearchReceiptsClick != null)
// {
// Button btn = (Button)sender;
// OnSearchReceiptsClick(btn.CommandArgument);
// }
//}
#endregion
#region mediavideo
public void BindVideoListRepeater(object theList, string appContext)
{
pnlVideoListRepeater.Visible = true;
staticAppContext = appContext;
listXLAT = SQMBasePage.SelectXLATList(new string[1] {
"MEDIA_VIDEO_STATUS"
}, 1);
rgVideoList.DataSource = theList;
rgVideoList.DataBind();
}
public void BindPrivGroups(List <PRIVGROUP> privGroupList, BusinessLocation businessLocation, string context)
{
hfPrivGroupContext.Value = context;
if (ddlPrivGroupStatus.Items.Count == 0)
{
XLATList = SQMBasePage.SelectXLATList(new string[3] {
"ACTIVE_STATUS", "PRIV_PRIV", "PRIV_SCOPE"
});
ddlPrivGroupStatus.DataSource = XLATList.Where(x => x.XLAT_GROUP == "ACTIVE_STATUS").ToList();
ddlPrivGroupStatus.DataValueField = "XLAT_CODE";
ddlPrivGroupStatus.DataTextField = "DESCRIPTION";
ddlPrivGroupStatus.DataBind();
}
if (ddlScope.Items.Count == 0)
{
ddlScope.DataSource = XLATList.Where(x => x.XLAT_GROUP == "PRIV_SCOPE").ToList();
ddlScope.DataValueField = "XLAT_CODE";
ddlScope.DataTextField = "DESCRIPTION";
ddlScope.DataBind();
}
if (ddlPriviledge.Items.Count == 0)
{
ddlPriviledge.DataSource = XLATList.Where(x => x.XLAT_GROUP == "PRIV_PRIV").ToList();
ddlPriviledge.DataValueField = "XLAT_CODE";
ddlPriviledge.DataTextField = "DESCRIPTION";
ddlPriviledge.DataBind();
RadComboBoxItem item = new RadComboBoxItem("", "select a priviledge level");
ddlPriviledge.Items.Insert(0, item);
try
{
item = ddlPriviledge.FindItemByValue("100");
item.Enabled = false;
}
catch { }
}
defaultPrivs = SQMSettings.SelectSettingsGroup("DEFAULT_PRIVS", "");
pnlPrivGroups.Visible = true;
rgPrivGroup.DataSource = privGroupList;
rgPrivGroup.DataBind();
}
public void BindNotfyPlan(List <NOTIFYACTION> notifyItemList, BusinessLocation businessLocation, string context)
{
XLATList = SQMBasePage.SelectXLATList(new string[4] {
"NOTIFY_SCOPE", "NOTIFY_SCOPE_TASK", "NOTIFY_TASK_STATUS", "NOTIFY_TIMING"
});
hfNotifyActionContext.Value = context;
hfNotifyActionBusLoc.Value = context == "plant" ? businessLocation.Plant.PLANT_ID.ToString() : businessLocation.BusinessOrg.BUS_ORG_ID.ToString();
ddlNotifyScope.DataSource = XLATList.Where(x => x.XLAT_GROUP == "NOTIFY_SCOPE").ToList();
ddlNotifyScope.DataValueField = "XLAT_CODE";
ddlNotifyScope.DataTextField = "DESCRIPTION";
ddlNotifyScope.DataBind();
ddlScopeTask.DataSource = XLATList.Where(x => x.XLAT_GROUP == "NOTIFY_SCOPE_TASK").ToList();
ddlScopeTask.DataValueField = "XLAT_CODE";
ddlScopeTask.DataTextField = "DESCRIPTION";
ddlScopeTask.DataBind();
ddlScopeStatus.DataSource = XLATList.Where(x => x.XLAT_GROUP == "NOTIFY_TASK_STATUS").ToList();
ddlScopeStatus.DataValueField = "XLAT_CODE";
ddlScopeStatus.DataTextField = "DESCRIPTION";
ddlScopeStatus.DataBind();
ddlScopeTiming.DataSource = XLATList.Where(x => x.XLAT_GROUP == "NOTIFY_TIMING").ToList();
ddlScopeTiming.DataValueField = "XLAT_CODE";
ddlScopeTiming.DataTextField = "DESCRIPTION";
ddlScopeTiming.DataBind();
foreach (PRIVGROUP pg in SQMModelMgr.SelectPrivGroupList(new SysPriv[2] {
SysPriv.admin, SysPriv.notify
}, SysScope.incident, "A").ToList())
{
ddlNotifyPrivGroup.Items.Add(new RadComboBoxItem(SQMModelMgr.FormatPrivGroup(pg), pg.PRIV_GROUP));
}
pnlNotifyAction.Visible = true;
hfNotifyActionContext.Value = context;
rgNotifyAction.DataSource = notifyItemList;
rgNotifyAction.DataBind();
}
public static int NotifyIncidentTaskAssigment(INCIDENT incident, TASK_STATUS theTask, string scopeAction)
{
int status = 0;
PLANT plant = SQMModelMgr.LookupPlant((decimal)incident.DETECT_PLANT_ID);
PERSON person = SQMModelMgr.LookupPerson((decimal)theTask.RESPONSIBLE_ID, "");
if (person != null && !string.IsNullOrEmpty(person.EMAIL))
{
List <XLAT> XLATList = SQMBasePage.SelectXLATList(new string[3] {
"NOTIFY_SCOPE", "NOTIFY_SCOPE_TASK", "NOTIFY_TASK_STATUS"
});
string appUrl = SQMSettings.SelectSettingByCode(new PSsqmEntities(), "MAIL", "TASK", "MailURL").VALUE;
if (string.IsNullOrEmpty(appUrl))
{
appUrl = "the website";
}
string emailTo = person.EMAIL;
string actionText = XLATList.Where(x => x.XLAT_GROUP == "NOTIFY_SCOPE_TASK" && x.XLAT_CODE == scopeAction).FirstOrDefault().DESCRIPTION;
string emailSubject = "Health/Safety Incident " + actionText + ": " + incident.ISSUE_TYPE + " (" + plant.PLANT_NAME + ")";
string emailBody = "You have been assigned to one or more tasks regarding the following Incident: <br/>" +
"<br/>" +
"Incident ID: " + WebSiteCommon.FormatID(incident.INCIDENT_ID, 6) + "<br/>" +
plant.PLANT_NAME + "<br/>" +
incident.ISSUE_TYPE + "<br/>" +
"<br/>" +
incident.DESCRIPTION + "<br/>" +
"<br/>" +
theTask.DESCRIPTION + "<br/>" +
"<br/>" +
"Due : " + theTask.DUE_DT.ToString() + "<br/>" +
"<br/>" +
"Please log in to " + (appUrl + incidentPath) + " to view this incident.";
Thread thread = new Thread(() => WebSiteCommon.SendEmail(emailTo, emailSubject, emailBody, "", "web", null));
thread.IsBackground = true;
thread.Start();
}
return(status);
}
protected void lblDueDate_OnClick(object sender, EventArgs e)
{
lblErrorMessage.Text = "";
LinkButton btn = (LinkButton)sender;
if (btn == null || string.IsNullOrEmpty(btn.CommandArgument))
{
return;
}
PSsqmEntities ctx = new PSsqmEntities();
int recordType;
TaskStatusMgr taskMgr = new TaskStatusMgr().CreateNew(0, 0);
TASK_STATUS task = new TASK_STATUS();
AUDIT audit = new AUDIT();
try
{
decimal recordID = Convert.ToDecimal(btn.CommandArgument.ToString());
if (TaskXLATList == null || TaskXLATList.Count == 0)
{
TaskXLATList = SQMBasePage.SelectXLATList(new string[5] {
"TASK_STATUS", "RECORD_TYPE", "INCIDENT_STATUS", "NOTIFY_SCOPE_TASK", "ACTION_CATEGORY"
});
}
task = taskMgr.SelectTask(recordID);
BindTaskUpdate(task, "");
}
catch (Exception ex)
{
lblErrorMessage.Text = ex.Message.ToString();
}
pnlAddTask.Visible = false;
pnlUpdateTask.Visible = true;
string script = "function f(){OpenUpdateTaskWindow(); Sys.Application.remove_load(f);}Sys.Application.add_load(f);";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "key", script, true);
}
protected void rgAuditList_ItemDataBound(object sender, GridItemEventArgs e)
{
if (e.Item is GridDataItem)
{
GridDataItem item = (GridDataItem)e.Item;
HiddenField hf;
Label lbl;
EHSAuditData data = (EHSAuditData)e.Item.DataItem;
lbl = (Label)e.Item.FindControl("lblAuditId");
lbl.Text = WebSiteCommon.FormatID(data.Audit.AUDIT_ID, 6);
if (data.Audit.DESCRIPTION.Length > 120)
{
lbl = (Label)e.Item.FindControl("lblDescription");
lbl.Text = data.Audit.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("lblAuditBy");
lbl.Text = SQMModelMgr.FormatPersonListItem(data.Person);
hdnAuditPerson.Value = data.Person.PERSON_ID.ToString();
}
lbl = (Label)e.Item.FindControl("lblAuditStatus");
List <XLAT> TaskXLATList = SQMBasePage.SelectXLATList(new string[1] {
"AUDIT_STATUS"
});
if (data.Audit.CURRENT_STATUS == "C")
{
DateTime clsDate = (DateTime)data.Audit.CLOSE_DATE_DATA_COMPLETE;
lbl.Text = TaskXLATList.Where(l => l.XLAT_GROUP == "AUDIT_STATUS" && l.XLAT_CODE == "C").FirstOrDefault().DESCRIPTION + " " + SQMBasePage.FormatDate(clsDate, "d", false);
}
else
{
if (data.DaysToClose == 0)
{
DateTime tmp = ((DateTime)data.Audit.AUDIT_DT).AddDays(data.AuditType.DAYS_TO_COMPLETE);
lbl.Text = TaskXLATList.Where(l => l.XLAT_GROUP == "AUDIT_STATUS" && l.XLAT_CODE == "X").FirstOrDefault().DESCRIPTION + "<br/>(" + SQMBasePage.FormatDate(tmp, "d", false) + ")";
}
else if (data.Audit.PERCENT_COMPLETE > 0)
{
lbl.Text = TaskXLATList.Where(l => l.XLAT_GROUP == "AUDIT_STATUS" && l.XLAT_CODE == "I").FirstOrDefault().DESCRIPTION + "<br/>(" + data.DaysToClose + ")";
}
else
{
lbl.Text = TaskXLATList.Where(l => l.XLAT_GROUP == "AUDIT_STATUS" && l.XLAT_CODE == "A").FirstOrDefault().DESCRIPTION + "<br/>(" + data.DaysToClose + ")";
}
}
//LinkButton lnk = (LinkButton)e.Item.FindControl("lbAuditId");
//if (SessionManager.UserContext.Person.PERSON_ID == data.Person.PERSON_ID)
// lnk.CommandArgument = data.Audit.AUDIT_ID.ToString() + "~" + data.Status;
//else if (!data.Status.Equals("C"))
// lnk.CommandArgument = data.Audit.AUDIT_ID.ToString() + "~D";
//else
// lnk.CommandArgument = data.Audit.AUDIT_ID.ToString() + "~C";
}
}
public void LoadVideoInformation()
{
// populate all the fields
List <XLAT> listXLAT = SQMBasePage.SelectXLATList(new string[5] {
"INJURY_PART", "INJURY_TYPE", "MEDIA_VIDEO_SOURCE", "MEDIA_VIDEO_STATUS", "MEDIA_VIDEO_TYPE"
}, 1);
List <MediaVideoData> videos = MediaVideoMgr.SelectVideoDataById(entities, EditVideoId);
if (videos != null)
{
MediaVideoData videoData = videos[0];
BusinessLocation location = new BusinessLocation().Initialize((decimal)videoData.Video.PLANT_ID);
lblVideoSourceType.Text = ((TaskRecordType)videoData.Video.SOURCE_TYPE).ToString();
if ((TaskRecordType)videoData.Video.SOURCE_TYPE != TaskRecordType.Media)
{
lblVideoSourceType.Text += " " + videoData.Video.SOURCE_ID;
}
lblVideoLocation.Text = location.Plant.PLANT_NAME + " " + location.BusinessOrg.ORG_NAME;
lblVideoPersonName.Text = videoData.Person.LAST_NAME + ", " + videoData.Person.FIRST_NAME;
DateTime dt = (DateTime)videoData.Video.VIDEO_DT;
lblVideoDate.Text = dt.ToString("MM/dd/yyyy");
dt = (DateTime)videoData.Video.INCIDENT_DT;
lblVideoIncidentDate.Text = dt.ToString("MM/dd/yyyy");
lblVideoInjuryType.Text = SQMBasePage.GetXLAT(listXLAT, "INJURY_TYPE", videoData.Video.INJURY_TYPES).DESCRIPTION; // for now we assume only one
lblVideoBodyPart.Text = SQMBasePage.GetXLAT(listXLAT, "INJURY_PART", videoData.Video.BODY_PARTS).DESCRIPTION; // for now we assume only one
tbTitle.Text = videoData.Video.TITLE;
tbDescription.Text = videoData.Video.DESCRIPTION;
if (ddlVideoType.Items.Count == 0)
{
PopulateVideoTypeDropDown();
}
if (videoData.Video.VIDEO_TYPE == null)
{
ddlVideoType.SelectedValue = "";
}
else
{
ddlVideoType.SelectedValue = videoData.Video.VIDEO_TYPE;
}
if (videoData.Video.VIDEO_AVAILABILITY == null)
{
ddlAvailability.SelectedIndex = 0;
}
else
{
ddlAvailability.SelectedValue = videoData.Video.VIDEO_AVAILABILITY;
}
litVideoDownloadLink.Text = "<a href='/Shared/FileHandler.ashx?DOC=v&DOC_ID=" + EditVideoId + "&FILE_NAME=" + videoData.Video.FILE_NAME + "' target='_blank'>" + Resources.LocalizedText.VideoDownload + "</a>";
litVideoViewLink.Text = "<a href='/Shared/VideoHandler.aspx?DOC=v&DOC_ID=" + EditVideoId + "' target='_blank'>" + Resources.LocalizedText.VideoView + "</a>";
rcbStatusSelect = SQMBasePage.SetComboBoxItemsFromXLAT(rcbStatusSelect, listXLAT.Where(l => l.XLAT_GROUP == "MEDIA_VIDEO_STATUS" && l.STATUS == "A").OrderBy(h => h.SORT_ORDER).ToList(), "SHORT");
rcbStatusSelect.Items.Insert(0, new RadComboBoxItem("Select a status", ""));
rcbStatusSelect.SelectedValue = videoData.Video.VIDEO_STATUS;
cbVideoText.Checked = videoData.Video.SPEAKER_AUDIO;
// populate release form list
if (videoData.Video.RELEASE_REQUIRED)
{
cbReleaseForms.Checked = true;
//dvAttach.Visible = true;
dvAttach.Style.Add("display", "block");
// get the new async working
GetAttachments(EditVideoId, (int)MediaAttachmentType.ReleaseForm, videoData.ReleaseFormList.Count);
}
else
{
cbReleaseForms.Checked = false;
//dvAttach.Visible = false;
dvAttach.Style.Add("display", "none");
}
uploadReleases.SetViewMode(true);
// populate text list
GetAttachments(EditVideoId, (int)MediaAttachmentType.Text, videoData.VideoTextList.Count);
if (videoData.Video.TEXT_ADDED || videoData.VideoTextList.Count > 0)
{
cbVideoText.Checked = true;
//dvText.Visible = true;
dvText.Style.Add("display", "block");
}
else
{
cbVideoText.Checked = false;
//dvText.Visible = false;
dvText.Style.Add("display", "none");
}
pnlAddEdit.Visible = true;
pnlVideoHeader.Visible = true;
divVideoForm.Visible = true;
if (videoData.Video.SOURCE_TYPE == (int)TaskRecordType.Audit || videoData.Video.SOURCE_TYPE == (int)TaskRecordType.HealthSafetyIncident)
{
btnDelete.Visible = false;
}
else
{
btnDelete.Visible = true;
}
// if not edit mode, all fields are display only
if (!IsEditContext)
{
tbTitle.Enabled = false;
tbDescription.Enabled = false;
ddlAvailability.Enabled = false;
ddlVideoType.Enabled = false;
cbReleaseForms.Enabled = false;
cbVideoText.Enabled = false;
cbSpeakerAudio.Enabled = false;
}
}
}
protected void Page_PreRender(object sender, EventArgs e)
{
try
{
if (!Page.IsPostBack)
{
if (menuXLATList == null || menuXLATList.Count == 0)
{
menuXLATList = SQMBasePage.SelectXLATList(new string[8] {
"MENU_HOME", "MENU_ORG", "MENU_ENV", "MENU_HS", "MENU_AUDIT", "MENU_DATA", "MENU_RM", "MENU_MEDIA"
});
}
SessionManager.CurrentAdminPage = "";
string customerLogo = "";
customerLogo = System.Configuration.ConfigurationManager.AppSettings["CustomerLogo"];
if (string.IsNullOrEmpty(customerLogo) || customerLogo.Contains("Metricsoft"))
{
imgLogo.ImageUrl = "~/images/company/MetricsoftLogoSmall.png";
}
else
{
int pos = customerLogo.IndexOf('.');
customerLogo = customerLogo.Substring(0, pos) + "Small." + customerLogo.Substring(pos + 1, customerLogo.Length - pos - 1);
imgLogo.ImageUrl = "~/images/company/" + customerLogo;
}
string title = System.Configuration.ConfigurationManager.AppSettings["MainTitle"];
if (!string.IsNullOrEmpty(title))
{
lblMainTitle.Text = title;
}
SetupPage();
bool addConsole = false;
RadMenu1.Skin = "Metro";
RadMenu1.ExpandDelay = 225;
RadMenu1.CollapseDelay = 500;
RadMenu1.ExpandAnimation.Duration = 40;
RadMenu1.CollapseAnimation.Duration = 20;
RadMenu1.DefaultGroupSettings.Flow = Telerik.Web.UI.ItemFlow.Horizontal;
RadMenuItem HomeMenu = new RadMenuItem(GetMenu("MENU_HOME", "0").DESCRIPTION);
RadMenu1.Items.Add(HomeMenu);
if (UserContext.GetScopePrivileges(SysScope.dashboard).Count() > 0)
{
HomeMenu.Items.Add(new Telerik.Web.UI.RadMenuItem(GetMenu("MENU_HOME", "11").DESCRIPTION, GetMenu("MENU_HOME", "11").DESCRIPTION_SHORT));
}
if (UserContext.GetScopePrivileges(SysScope.inbox).Count() > 0)
{
HomeMenu.Items.Add(new Telerik.Web.UI.RadMenuItem(GetMenu("MENU_HOME", "12").DESCRIPTION, GetMenu("MENU_HOME", "12").DESCRIPTION_SHORT));
}
if (UserContext.GetMaxScopePrivilege(SysScope.busorg) <= SysPriv.admin)
{
RadMenuItem OrgMenu = new RadMenuItem(GetMenu("MENU_ORG", "0").DESCRIPTION);
RadMenu1.Items.Add(OrgMenu);
OrgMenu.Items.Add(new Telerik.Web.UI.RadMenuItem(GetMenu("MENU_ORG", "11").DESCRIPTION, GetMenu("MENU_ORG", "11").DESCRIPTION_SHORT));
OrgMenu.Items.Add(new Telerik.Web.UI.RadMenuItem(GetMenu("MENU_ORG", "12").DESCRIPTION, GetMenu("MENU_ORG", "12").DESCRIPTION_SHORT));
if (UserContext.CheckUserPrivilege(SysPriv.admin, SysScope.system) && SessionManager.UserContext.Person.PERSON_ID == 1)
{
OrgMenu.Items.Add(new Telerik.Web.UI.RadMenuItem(GetMenu("MENU_ORG", "13").DESCRIPTION, GetMenu("MENU_ORG", "13").DESCRIPTION_SHORT));
OrgMenu.Items.Add(new Telerik.Web.UI.RadMenuItem(GetMenu("MENU_ORG", "14").DESCRIPTION, GetMenu("MENU_ORG", "14").DESCRIPTION_SHORT));
}
}
if (UserContext.GetScopePrivileges(SysScope.envdata).Count() > 0)
{
RadMenuItem EHSMenu1 = new RadMenuItem(GetMenu("MENU_ENV", "0").DESCRIPTION);
RadMenu1.Items.Add(EHSMenu1);
if (UserContext.CheckUserPrivilege(SysPriv.config, SysScope.envdata))
{
EHSMenu1.Items.Add(new Telerik.Web.UI.RadMenuItem(GetMenu("MENU_ENV", "11").DESCRIPTION, GetMenu("MENU_ENV", "11").DESCRIPTION_SHORT));
EHSMenu1.Items.Add(new Telerik.Web.UI.RadMenuItem(GetMenu("MENU_ENV", "12").DESCRIPTION, GetMenu("MENU_ENV", "12").DESCRIPTION_SHORT));
}
EHSMenu1.Items.Add(new Telerik.Web.UI.RadMenuItem(GetMenu("MENU_ENV", "13").DESCRIPTION, GetMenu("MENU_ENV", "13").DESCRIPTION_SHORT));
EHSMenu1.Items.Add(new Telerik.Web.UI.RadMenuItem(GetMenu("MENU_ENV", "14").DESCRIPTION, GetMenu("MENU_ENV", "14").DESCRIPTION_SHORT));
if (addConsole == false && UserContext.GetScopePrivileges(SysScope.console).Count() > 0)
{
EHSMenu1.Items.Add(new Telerik.Web.UI.RadMenuItem(GetMenu("MENU_ENV", "15").DESCRIPTION, GetMenu("MENU_ENV", "15").DESCRIPTION_SHORT));
addConsole = true;
}
}
if (UserContext.GetScopePrivileges(SysScope.incident).Count() > 0)
{
RadMenuItem EHSMenu2 = new RadMenuItem(GetMenu("MENU_HS", "0").DESCRIPTION);
RadMenu1.Items.Add(EHSMenu2);
if (UserContext.GetScopePrivileges(SysScope.incident).Count() > 0)
{
EHSMenu2.Items.Add(new Telerik.Web.UI.RadMenuItem(GetMenu("MENU_HS", "11").DESCRIPTION, GetMenu("MENU_HS", "11").DESCRIPTION_SHORT));
}
if (UserContext.GetScopePrivileges(SysScope.console).Count() > 0)
{
EHSMenu2.Items.Add(new Telerik.Web.UI.RadMenuItem(GetMenu("MENU_HS", "12").DESCRIPTION, GetMenu("MENU_HS", "12").DESCRIPTION_SHORT));
}
}
if (UserContext.GetScopePrivileges(SysScope.audit).Count() > 0)
{
RadMenuItem EHSMenu2 = new RadMenuItem(GetMenu("MENU_AUDIT", "0").DESCRIPTION);
RadMenu1.Items.Add(EHSMenu2);
if (UserContext.GetMaxScopePrivilege(SysScope.audit) <= SysPriv.config && GetMenu("MENU_AUDIT", "11").STATUS.ToUpper() == "A")
{
EHSMenu2.Items.Add(new Telerik.Web.UI.RadMenuItem(GetMenu("MENU_AUDIT", "11").DESCRIPTION, GetMenu("MENU_AUDIT", "11").DESCRIPTION_SHORT));
}
if (UserContext.GetMaxScopePrivilege(SysScope.audit) <= SysPriv.originate)
{
if (GetMenu("MENU_AUDIT", "12").STATUS.ToUpper() == "A")
{
EHSMenu2.Items.Add(new Telerik.Web.UI.RadMenuItem(GetMenu("MENU_AUDIT", "12").DESCRIPTION, GetMenu("MENU_AUDIT", "12").DESCRIPTION_SHORT));
}
if (GetMenu("MENU_AUDIT", "15").STATUS.ToUpper() == "A")
{
EHSMenu2.Items.Add(new Telerik.Web.UI.RadMenuItem(GetMenu("MENU_AUDIT", "15").DESCRIPTION, GetMenu("MENU_AUDIT", "15").DESCRIPTION_SHORT));
}
}
if (UserContext.GetMaxScopePrivilege(SysScope.audit) <= SysPriv.originate && GetMenu("MENU_AUDIT", "13").STATUS.ToUpper() == "A")
{
EHSMenu2.Items.Add(new Telerik.Web.UI.RadMenuItem(GetMenu("MENU_AUDIT", "13").DESCRIPTION, GetMenu("MENU_AUDIT", "13").DESCRIPTION_SHORT));
}
}
if (SessionManager.GetUserSetting("MODULE", "PREVACTION") != null && SessionManager.GetUserSetting("MODULE", "PREVACTION").VALUE.ToUpper() == "A")
{
if (UserContext.GetScopePrivileges(SysScope.prevent).Count() > 0 && IsMenuActive("MENU_RM"))
{
RadMenuItem EHSMenu2 = new RadMenuItem(GetMenu("MENU_RM", "0").DESCRIPTION);
RadMenu1.Items.Add(EHSMenu2);
EHSMenu2.Items.Add(new Telerik.Web.UI.RadMenuItem(GetMenu("MENU_RM", "11").DESCRIPTION, GetMenu("MENU_RM", "11").DESCRIPTION_SHORT));
}
}
if (SessionManager.GetUserSetting("MODULE", "EHSDATA") != null && SessionManager.GetUserSetting("MODULE", "EHSDATA").VALUE.ToUpper() == "A")
{
if (UserContext.GetMaxScopePrivilege(SysScope.ehsdata) <= SysPriv.originate && IsMenuActive("MENU_DATA"))
{
RadMenuItem EHSMenu2 = new RadMenuItem(GetMenu("MENU_DATA", "0").DESCRIPTION);
RadMenu1.Items.Add(EHSMenu2);
EHSMenu2.Items.Add(new Telerik.Web.UI.RadMenuItem(GetMenu("MENU_DATA", "11").DESCRIPTION, GetMenu("MENU_DATA", "11").DESCRIPTION_SHORT));
EHSMenu2.Items.Add(new Telerik.Web.UI.RadMenuItem(GetMenu("MENU_DATA", "12").DESCRIPTION, GetMenu("MENU_DATA", "12").DESCRIPTION_SHORT));
EHSMenu2.Items.Add(new Telerik.Web.UI.RadMenuItem(GetMenu("MENU_DATA", "13").DESCRIPTION, GetMenu("MENU_DATA", "13").DESCRIPTION_SHORT));
if (UserContext.GetMaxScopePrivilege(SysScope.ehsdata) <= SysPriv.config)
{
EHSMenu2.Items.Add(new RadMenuItem(GetMenu("MENU_DATA", "21").DESCRIPTION, GetMenu("MENU_DATA", "21").DESCRIPTION_SHORT));
EHSMenu2.Items.Add(new RadMenuItem(GetMenu("MENU_DATA", "22").DESCRIPTION, GetMenu("MENU_DATA", "22").DESCRIPTION_SHORT));
}
if (UserContext.CheckUserPrivilege(SysPriv.approve, SysScope.ehsdata) || UserContext.CheckUserPrivilege(SysPriv.approve1, SysScope.ehsdata))
{
EHSMenu2.Items.Add(new RadMenuItem(GetMenu("MENU_DATA", "25").DESCRIPTION, GetMenu("MENU_DATA", "25").DESCRIPTION_SHORT));
}
}
}
if (SessionManager.GetUserSetting("MODULE", "MEDIA") != null && SessionManager.GetUserSetting("MODULE", "MEDIA").VALUE.ToUpper() == "A")
{
if (UserContext.GetMaxScopePrivilege(SysScope.media) <= SysPriv.originate)
{
RadMenuItem EHSMenu2 = new RadMenuItem(GetMenu("MENU_MEDIA", "0").DESCRIPTION);
RadMenu1.Items.Add(EHSMenu2);
EHSMenu2.Items.Add(new Telerik.Web.UI.RadMenuItem(GetMenu("MENU_MEDIA", "11").DESCRIPTION, GetMenu("MENU_MEDIA", "11").DESCRIPTION_SHORT));
}
}
}
}
catch (Exception ex)
{
// SQMLogger.LogException(ex);
}
}
private void SetupPage()
{
if (ddlPlantSelect.Items.Count < 1)
{
List <BusinessLocation> locationList = SQMModelMgr.SelectBusinessLocationList(SessionManager.UserContext.HRLocation.Company.COMPANY_ID, 0, true);
SQMBasePage.SetLocationList(ddlPlantSelect, UserContext.FilterPlantAccessList(locationList), 0);
List <XLAT> xlatList = SQMBasePage.SelectXLATList(new string[5] {
"INJURY_PART", "INJURY_TYPE", "MEDIA_VIDEO_SOURCE", "MEDIA_VIDEO_STATUS", "MEDIA_VIDEO_TYPE"
}, 1);
rcbVideoSource = SQMBasePage.SetComboBoxItemsFromXLAT(rcbVideoSource, xlatList.Where(l => l.XLAT_GROUP == "MEDIA_VIDEO_SOURCE" && l.STATUS == "A").OrderBy(h => h.SORT_ORDER).ToList(), "SHORT");
rcbVideoSource.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem("All", ""));
rcbVideoSource.SelectedIndex = 0;
rcbVideoStatusSelect = SQMBasePage.SetComboBoxItemsFromXLAT(rcbVideoStatusSelect, xlatList.Where(l => l.XLAT_GROUP == "MEDIA_VIDEO_STATUS" && l.STATUS == "A").OrderBy(h => h.SORT_ORDER).ToList(), "SHORT");
rcbVideoStatusSelect.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem("All", ""));
rcbVideoStatusSelect.SelectedIndex = 0;
rcbVideoType = SQMBasePage.SetComboBoxItemsFromXLAT(rcbVideoType, xlatList.Where(l => l.XLAT_GROUP == "MEDIA_VIDEO_TYPE" && l.STATUS == "A").OrderBy(h => h.SORT_ORDER).ToList(), "SHORT");
//rcbVideoStatusSelect.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem("All", ""));
//rcbVideoStatusSelect.SelectedIndex = 0;
rcbInjuryType = SQMBasePage.SetComboBoxItemsFromXLAT(rcbInjuryType, xlatList.Where(l => l.XLAT_GROUP == "INJURY_TYPE" && l.STATUS == "A").OrderBy(h => h.SORT_ORDER).ToList(), "SHORT");
rcbInjuryType.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem("All", ""));
rcbInjuryType.SelectedIndex = 0;
rcbBodyPart = SQMBasePage.SetComboBoxItemsFromXLAT(rcbBodyPart, xlatList.Where(l => l.XLAT_GROUP == "INJURY_PART" && l.STATUS == "A").OrderBy(h => h.SORT_ORDER).ToList(), "SHORT");
rcbBodyPart.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem("All", ""));
rcbBodyPart.SelectedIndex = 0;
}
divVideoList.Visible = true;
rbNew.Visible = true;
dmFromDate.ShowPopupOnFocus = dmToDate.ShowPopupOnFocus = true;
// ABW 1/5/16 - use user's default plant local time for search default
DateTime localTime = SessionManager.UserContext.LocalTime;
dmFromDate.SelectedDate = localTime.AddMonths(-1);
dmToDate.SelectedDate = localTime.AddMonths(1);
//lblStatus.Text = "Assessment Status:";
lblVideoDate.Visible = true;
phVideo.Visible = true;
//SETTINGS sets = SQMSettings.GetSetting("EHS", "AUDITSEARCHFROM");
//if (sets != null)
//{
// try
// {
// string[] args = sets.VALUE.Split('-');
// if (args.Length > 1)
// {
// dmFromDate.SelectedDate = new DateTime(Convert.ToInt32(args[0]), Convert.ToInt32(args[1]), Convert.ToInt32(args[2]));
// }
// else
// {
// dmFromDate.SelectedDate = SessionManager.UserContext.LocalTime.AddMonths(Convert.ToInt32(args[0]) * -1);
// }
// }
// catch { }
//}
}
private void SetupPage()
{
if (ddlPlantSelect.Items.Count < 1)
{
List <XLAT> xlatList = SQMBasePage.SelectXLATList(new string[2] {
"STATUS_SELECT", "INCIDENT_SEVERITY"
}, 1);
List <BusinessLocation> locationList = SQMModelMgr.SelectBusinessLocationList(SessionManager.UserContext.HRLocation.Company.COMPANY_ID, 0, true);
SQMBasePage.SetLocationList(ddlPlantSelect, UserContext.FilterPlantAccessList(locationList), 0);
rcbStatusSelect = SQMBasePage.SetComboBoxItemsFromXLAT(rcbStatusSelect, xlatList.Where(l => l.XLAT_GROUP == "STATUS_SELECT" && new string[3] {
"", "A", "C"
}.Contains(l.XLAT_CODE)).ToList(), "SHORT");
rcbStatusSelect.SelectedValue = "A";
rcbSeverity = SQMBasePage.SetComboBoxItemsFromXLAT(rcbSeverity, xlatList.Where(l => l.XLAT_GROUP == "INCIDENT_SEVERITY").OrderBy(l => l.SORT_ORDER).ToList(), "SHORT");
}
divIncidentList.Visible = true;
pnlChartSection.Style.Add("display", "none");
lblChartType.Visible = ddlChartType.Visible = false;
//Bind data with severity level dropdown.
var severityList = EHSIncidentMgr.PopulateSeverityLevel();
rcbSeverityLevel = SQMBasePage.SetComboBoxItemsFromXLAT(rcbSeverityLevel, severityList, "SHORT");
SQMBasePage.SetRadDateCulture(dmFromDate, "");
SQMBasePage.SetRadDateCulture(dmToDate, "");
dmFromDate.ShowPopupOnFocus = dmToDate.ShowPopupOnFocus = true;
dmFromDate.SelectedDate = SessionManager.UserContext.LocalTime.AddMonths(-11);
dmToDate.SelectedDate = SessionManager.UserContext.LocalTime;
lblViewEHSRezTitle.Text = GetLocalResourceObject("lblViewEHSRezTitleResource1.Text").ToString();
lblPageInstructions.Text = GetLocalResourceObject("lblPageInstructionsResource1.Text").ToString();
//lblStatus.Text = "Incident Status:";
rbNew.Text = GetLocalResourceObject("rbNewResource1.Text").ToString();
lblIncidentDate.Visible = true;
lblInspectionDate.Visible = false;
phIncident.Visible = true;
SETTINGS sets = SQMSettings.GetSetting("EHS", "INCIDENTSEARCHFROM");
if (sets != null)
{
try
{
string[] args = sets.VALUE.Split('-');
if (args.Length > 1)
{
dmFromDate.SelectedDate = new DateTime(Convert.ToInt32(args[0]), Convert.ToInt32(args[1]), Convert.ToInt32(args[2]));
}
else
{
dmFromDate.SelectedDate = SessionManager.UserContext.LocalTime.AddMonths(Convert.ToInt32(args[0]) * -1);
}
}
catch { }
}
foreach (INCIDENT_TYPE ip in EHSIncidentMgr.SelectIncidentTypeList(SessionManager.PrimaryCompany().COMPANY_ID, SessionManager.UserContext.Language.NLS_LANGUAGE))
{
RadComboBoxItem item = new RadComboBoxItem(ip.TITLE, ip.INCIDENT_TYPE_ID.ToString());
item.Checked = true;
rcbIncidentType.Items.Add(item);
}
// lookup charts defined for this module & app context
PERSPECTIVE_VIEW view = ViewModel.LookupView(entities, "HSIR", "HSIR", 0, SessionManager.UserContext.Language.NLS_LANGUAGE);
if (view != null)
{
ddlChartType.Items.Clear();
ddlChartType.Items.Add(new RadComboBoxItem("", ""));
foreach (PERSPECTIVE_VIEW_ITEM vi in view.PERSPECTIVE_VIEW_ITEM.Where(l => l.STATUS != "I").OrderBy(l => l.ITEM_SEQ).ToList())
{
RadComboBoxItem item = new RadComboBoxItem();
item.Text = vi.TITLE;
item.Value = vi.ITEM_SEQ.ToString();
item.ImageUrl = ViewModel.GetViewItemImageURL(vi);
ddlChartType.Items.Add(item);
}
}
if (UserContext.GetMaxScopePrivilege(SysScope.incident) <= SysPriv.action)
{
uclExport.Visible = true;
}
else
{
uclExport.Visible = false;
}
}
public void BindTaskUpdate(TASK_STATUS task, string context)
{
PSsqmEntities ctx = new PSsqmEntities();
if (TaskXLATList == null || TaskXLATList.Count == 0)
{
TaskXLATList = SQMBasePage.SelectXLATList(new string[5] {
"TASK_STATUS", "RECORD_TYPE", "INCIDENT_STATUS", "NOTIFY_SCOPE_TASK", "ACTION_CATEGORY"
});
}
CurrentTask = task;
pnlUpdateTask.Visible = true;
btnTaskUpdate.CommandArgument = btnTaskComplete.CommandArgument = btnTaskAssign.CommandArgument = task.TASK_ID.ToString();
if (task.STATUS == ((int)TaskStatus.Complete).ToString())
{
btnTaskComplete.Visible = btnTaskUpdate.Visible = btnTaskAssign.Visible = false;
//tbTaskDescription.Enabled = rdpTaskDueDT.Enabled = tbTaskComments.Enabled = false;
rdpTaskDueDT.Enabled = tbTaskComments.Enabled = false;
}
else
{
btnTaskComplete.Visible = btnTaskUpdate.Visible = btnTaskAssign.Visible = true;
//tbTaskDescription.Enabled = rdpTaskDueDT.Enabled = tbTaskComments.Enabled = true;
rdpTaskDueDT.Enabled = tbTaskComments.Enabled = true;
}
switch ((TaskRecordType)task.RECORD_TYPE)
{
case TaskRecordType.HealthSafetyIncident:
lblTaskTypeValue.Text = TaskXLATList.Where(l => l.XLAT_GROUP == "RECORD_TYPE" && l.XLAT_CODE == task.RECORD_TYPE.ToString()).FirstOrDefault().DESCRIPTION;
if (task.TASK_STEP == "350")
{ // corrective action task
lblTaskTypeValue.Text += (" - " + TaskXLATList.Where(l => l.XLAT_GROUP == "NOTIFY_SCOPE_TASK" && l.XLAT_CODE == task.TASK_STEP).FirstOrDefault().DESCRIPTION);
}
else
{
lblTaskTypeValue.Text += (" - " + TaskXLATList.Where(l => l.XLAT_GROUP == "NOTIFY_SCOPE_TASK" && l.XLAT_CODE == task.TASK_STEP).FirstOrDefault().DESCRIPTION);
}
break;
case TaskRecordType.PreventativeAction:
lblTaskTypeValue.Text = TaskXLATList.Where(l => l.XLAT_GROUP == "RECORD_TYPE" && l.XLAT_CODE == task.RECORD_TYPE.ToString()).FirstOrDefault().DESCRIPTION;
if (task.TASK_STEP == "350")
{ // corrective action task
lblTaskTypeValue.Text += (" - " + TaskXLATList.Where(l => l.XLAT_GROUP == "NOTIFY_SCOPE_TASK" && l.XLAT_CODE == task.TASK_STEP).FirstOrDefault().DESCRIPTION);
}
else
{
lblTaskTypeValue.Text += (" - " + TaskXLATList.Where(l => l.XLAT_GROUP == "NOTIFY_SCOPE_TASK" && l.XLAT_CODE == task.TASK_STEP).FirstOrDefault().DESCRIPTION);
}
btnTaskLink.CommandArgument = task.RECORD_ID.ToString();
btnTaskLink.Visible = true;
btnTaskAssign.Visible = btnTaskComplete.Visible = false;
break;
case TaskRecordType.Audit:
//AUDIT audit = EHSAuditMgr.SelectAuditById(ctx, task.RECORD_ID);
lblTaskTypeValue.Text = TaskXLATList.Where(l => l.XLAT_GROUP == "RECORD_TYPE" && l.XLAT_CODE == task.RECORD_TYPE.ToString()).FirstOrDefault().DESCRIPTION;
if ((task.RECORD_SUBID.HasValue && task.RECORD_SUBID > 0) || task.TASK_STEP == "350")
{ // action required if subid references a specific audit question
lblTaskTypeValue.Text += (" - " + TaskXLATList.Where(l => l.XLAT_GROUP == "NOTIFY_SCOPE_TASK" && l.XLAT_CODE == task.TASK_STEP).FirstOrDefault().DESCRIPTION);
}
else
{
lblTaskTypeValue.Text += (" - " + TaskXLATList.Where(l => l.XLAT_GROUP == "NOTIFY_SCOPE_TASK" && l.XLAT_CODE == "300").FirstOrDefault().DESCRIPTION);
}
break;
default:
return;
break;
}
//tbTaskDescription.Text = task.DESCRIPTION; // command of what to do
lbTaskDescription.Text = task.DESCRIPTION; // command of what to do
lblTaskDetailValue.Text = task.DETAIL; // incident description or audit question
PERSON createBy = null; // mt - predeclare create by person to better handle NULL CREATE_ID
// get the Create By person name and display
if (task.CREATE_ID.HasValue)
{
createBy = SQMModelMgr.LookupPerson(ctx, (decimal)task.CREATE_ID, "", false);
}
if (createBy == null)
{
lblCreatedByValue.Text = Resources.LocalizedText.AutomatedScheduler;
}
else
{
lblCreatedByValue.Text = SQMModelMgr.FormatPersonListItem(createBy, false, "LF");
}
PERSON assignTo = SQMModelMgr.LookupPerson(ctx, (decimal)task.RESPONSIBLE_ID, "", false);
if (assignTo == null)
{
lblAssignPersonValue.Text = Resources.LocalizedText.AutomatedScheduler;
}
else
{
lblAssignPersonValue.Text = SQMModelMgr.FormatPersonListItem(assignTo, false, "LF");
}
rdpTaskDueDT.SelectedDate = (DateTime)task.DUE_DT;
lblTaskStatusValue.Text = TaskXLATList.Where(l => l.XLAT_GROUP == "TASK_STATUS" && l.XLAT_CODE == ((int)TaskMgr.CalculateTaskStatus(task)).ToString()).FirstOrDefault().DESCRIPTION;
tbTaskComments.Text = task.COMMENTS;
int attachCount = SQM.Website.Classes.SQMDocumentMgr.GetAttachmentCountByRecord(CurrentTask.RECORD_TYPE, CurrentTask.RECORD_ID, CurrentTask.TASK_STEP, "");
lnkAttachments.Text = attachCount == 0 ? Resources.LocalizedText.Attachments : (Resources.LocalizedText.Attachments + " (" + attachCount.ToString() + ")");
lnkAttachments.Visible = true;
}
public void BindTaskAdd(int recordType, decimal recordID, decimal recordSubID, string taskStep, string taskType, string originalDetail, decimal plantID, string context)
{
PSsqmEntities ctx = new PSsqmEntities();
if (TaskXLATList == null || TaskXLATList.Count == 0)
{
TaskXLATList = SQMBasePage.SelectXLATList(new string[5] {
"TASK_STATUS", "RECORD_TYPE", "INCIDENT_STATUS", "NOTIFY_SCOPE_TASK", "ACTION_CATEGORY"
});
}
pnlUpdateTask.Visible = false;
pnlAddTask.Visible = true;
btnTaskAdd.CommandArgument = recordType.ToString() + "~" + recordID.ToString() + "~" + recordSubID.ToString() + "~" + taskStep + "~" + taskType + "~" + plantID.ToString();
lblTaskTypeValueAdd.Text = TaskXLATList.Where(l => l.XLAT_GROUP == "RECORD_TYPE" && l.XLAT_CODE == recordType.ToString()).FirstOrDefault().DESCRIPTION;
switch ((TaskRecordType)recordType)
{
case TaskRecordType.Audit:
if ((recordSubID > 0) || taskStep == "350")
{ // action required if subid references a specific audit question
lblTaskTypeValueAdd.Text += (" - " + TaskXLATList.Where(l => l.XLAT_GROUP == "NOTIFY_SCOPE_TASK" && l.XLAT_CODE == taskStep).FirstOrDefault().DESCRIPTION);
}
else
{
lblTaskTypeValueAdd.Text += (" - " + TaskXLATList.Where(l => l.XLAT_GROUP == "NOTIFY_SCOPE_TASK" && l.XLAT_CODE == "300").FirstOrDefault().DESCRIPTION);
}
break;
default:
return;
break;
}
lblTaskDetailValueAdd.Text = originalDetail; // cause of the requirement
rdpTaskDueDTAdd.SelectedDate = SessionManager.UserContext.LocalTime; // default to today?
lblTaskStatusValueAdd.Text = TaskXLATList.Where(l => l.XLAT_GROUP == "TASK_STATUS" && l.XLAT_CODE == (0).ToString()).FirstOrDefault().DESCRIPTION; // default to the "Open" status
ddlScheduleScopeAdd.Items.Clear();
mnuScheduleScopeAdd.Items.Clear();
BusinessLocation location = new BusinessLocation().Initialize(plantID);
SysPriv maxPriv = UserContext.GetMaxScopePrivilege(SysScope.busloc);
List <BusinessLocation> locationList = SessionManager.PlantList;
locationList = UserContext.FilterPlantAccessList(locationList);
if (maxPriv <= SysPriv.config) // is a plant admin or greater ?
{
// AW20170105 - move this up so it can be used by both admin and non admin
//List<BusinessLocation> locationList = SessionManager.PlantList;
//locationList = UserContext.FilterPlantAccessList(locationList);
if (locationList.Select(l => l.Plant.BUS_ORG_ID).Distinct().Count() > 1 && SessionManager.IsUserAgentType("ipad,iphone") == false)
{
ddlScheduleScopeAdd.Visible = false;
mnuScheduleScopeAdd.Visible = true;
SQMBasePage.SetLocationList(mnuScheduleScopeAdd, locationList, plantID, location.Plant.PLANT_NAME, "TOP", true);
//RadMenuItem mi = new RadMenuItem();
//mi.Text = (location.Plant.PLANT_NAME);
//mi.Value = plantID.ToString();
////mi.ImageUrl = "~/images/defaulticon/16x16/user-alt-2.png";
//mnuScheduleScopeAdd.Items[0].Items.Insert(0, mi);
//mnuScheduleScopeAdd.Attributes.Add("z-index", "9");
}
else
{
ddlScheduleScopeAdd.Visible = true;
mnuScheduleScopeAdd.Visible = false;
SQMBasePage.SetLocationList(ddlScheduleScopeAdd, locationList, plantID, true);
}
}
else
{
ddlScheduleScopeAdd.Visible = true;
mnuScheduleScopeAdd.Visible = false;
//ddlScheduleScopeAdd.Items.Insert(0, new RadComboBoxItem((SessionManager.UserContext.Person.FIRST_NAME + " " + SessionManager.UserContext.Person.LAST_NAME), "0"));
//ddlScheduleScopeAdd.Items[0].ImageUrl = "~/images/defaulticon/16x16/user-alt-2.png";
SQMBasePage.SetLocationList(ddlScheduleScopeAdd, locationList, plantID, true);
}
List <PERSON> personList = SQMModelMgr.SelectPlantPersonList(1, plantID).Where(l => !string.IsNullOrEmpty(l.EMAIL)).OrderBy(l => l.LAST_NAME).ToList();
SQMBasePage.SetPersonList(ddlAssignPersonAdd, personList, "", 0, false, "LF");
List <TaskItem> tasklist = TaskMgr.ExceptionTaskListByRecord(recordType, recordID, recordSubID);
rptTaskList.DataSource = tasklist;
rptTaskList.DataBind();
if (tasklist.Count > 0)
{
pnlListTasks.Visible = true;
}
else
{
pnlListTasks.Visible = false;
}
btnTaskAdd.Visible = true;
btnTaskUpdate.Visible = false;
}
public static int NotifyIncidentStatus(INCIDENT incident, string scopeAction)
{
int status = 0;
string notifyScope;
if ((EHSIncidentTypeId)incident.ISSUE_TYPE_ID == EHSIncidentTypeId.InjuryIllness)
{
notifyScope = "IN-" + incident.ISSUE_TYPE_ID.ToString();
}
else
{
notifyScope = "IN-" + ((int)EHSIncidentTypeId.Any).ToString();
}
PLANT plant = SQMModelMgr.LookupPlant((decimal)incident.DETECT_PLANT_ID);
List <PERSON> notifyPersonList = InvolvedPersonList(incident);
notifyPersonList.AddRange(GetNotifyPersonList(plant, notifyScope, scopeAction));
if (notifyPersonList.Count > 0)
{
List <XLAT> XLATList = SQMBasePage.SelectXLATList(new string[3] {
"NOTIFY_SCOPE", "NOTIFY_SCOPE_TASK", "NOTIFY_TASK_STATUS"
});
string appUrl = SQMSettings.SelectSettingByCode(new PSsqmEntities(), "MAIL", "TASK", "MailURL").VALUE;
if (string.IsNullOrEmpty(appUrl))
{
appUrl = "the website";
}
string actionText = XLATList.Where(x => x.XLAT_GROUP == "NOTIFY_SCOPE_TASK" && x.XLAT_CODE == scopeAction).FirstOrDefault().DESCRIPTION;
string emailSubject = "Health/Safety Incident " + actionText + ": " + incident.ISSUE_TYPE + " (" + plant.PLANT_NAME + ")";
string emailBody = "A new Health/Safety incident has been " + actionText + " :<br/>" +
"<br/>" +
"Incident ID: " + WebSiteCommon.FormatID(incident.INCIDENT_ID, 6) + "<br/>" +
plant.PLANT_NAME + "<br/>" +
incident.ISSUE_TYPE + "<br/>" +
"<br/>" +
incident.DESCRIPTION + "<br/>" +
"<br/>" +
"On : " + DateTime.Now.ToString() +
"<br/>" +
"By : " + incident.LAST_UPD_BY +
"<br/>" +
"Please log in to " + (appUrl + incidentPath) + " to view this incident.";
string emailTo = "";
foreach (PERSON person in notifyPersonList.Where(l => !string.IsNullOrEmpty(l.EMAIL)).ToList())
{
emailTo += string.IsNullOrEmpty(emailTo) ? person.EMAIL : ("," + person.EMAIL);
}
Thread thread = new Thread(() => WebSiteCommon.SendEmail(emailTo, emailSubject, emailBody, "", "web", null));
thread.IsBackground = true;
thread.Start();
}
//WebSiteCommon.SendEmail(emailTo, emailSubject, emailBody, "", "web", null);
return(status);
}
public void BindIncidentSummary(decimal incidentID)
{
PSsqmEntities ctx = new PSsqmEntities();
XLATList = SQMBasePage.SelectXLATList(new string[2] {
"INCIDENT_STATUS", "TASK_STATUS"
});
string none = "None entered"; // TODO: get this from XLAT table
string more = " ...";
pnlIncidentSummary.Visible = true;
INCIDENT incident = EHSIncidentMgr.SelectIncidentById(ctx, incidentID, true);
if (incident == null)
{
; // error
return;
}
lblDetail.Text = incident.DESCRIPTION;
if (incident.INCFORM_CONTAIN != null && incident.INCFORM_CONTAIN.Count > 0)
{
lblContainment.Text = incident.INCFORM_CONTAIN.Count > 1 ? incident.INCFORM_CONTAIN.ElementAt(0).ITEM_DESCRIPTION + more : incident.INCFORM_CONTAIN.ElementAt(0).ITEM_DESCRIPTION;
}
else
{
lblContainment.Text = none;
}
if (incident.INCFORM_ROOT5Y != null && incident.INCFORM_ROOT5Y.Count > 0)
{
lblContainment.Text = incident.INCFORM_ROOT5Y.Count > 1 ? incident.INCFORM_ROOT5Y.ElementAt(0).ITEM_DESCRIPTION + more : incident.INCFORM_ROOT5Y.ElementAt(0).ITEM_DESCRIPTION;
}
else
{
lblContainment.Text = none;
}
if (incident.INCFORM_ACTION != null && incident.INCFORM_ACTION.Count > 0)
{
lblContainment.Text = incident.INCFORM_ACTION.Count > 1 ? incident.INCFORM_ACTION.ElementAt(0).ITEM_DESCRIPTION + more : incident.INCFORM_ACTION.ElementAt(0).ITEM_DESCRIPTION;
}
else
{
lblContainment.Text = none;
}
if (incident.INCFORM_APPROVAL != null && incident.INCFORM_APPROVAL.Count > 0)
{
lblSignoff.Text = incident.INCFORM_APPROVAL.ElementAt(0).APPROVER_PERSON + SQMBasePage.FormatDate((DateTime)incident.INCFORM_APPROVAL.ElementAt(0).APPROVAL_DATE, "d", false);
if (incident.INCFORM_APPROVAL.Count > 1)
{
lblSignoff.Text = incident.INCFORM_APPROVAL.ElementAt(1).APPROVER_PERSON + SQMBasePage.FormatDate((DateTime)incident.INCFORM_APPROVAL.ElementAt(1).APPROVAL_DATE, "d", false);
}
}
else
{
lblContainment.Text = XLATList.Where(l => l.XLAT_GROUP == "TASK_STATUS" && l.XLAT_CODE == "1").FirstOrDefault().DESCRIPTION_SHORT; // pending
}
}
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 rgAuditList_ItemDataBound(object sender, GridItemEventArgs e)
{
if (e.Item is GridDataItem)
{
GridDataItem item = (GridDataItem)e.Item;
HiddenField hf;
Label lbl;
EHSAuditData data = (EHSAuditData)e.Item.DataItem;
LinkButton lnk = (LinkButton)e.Item.FindControl("lbAuditId");
lnk.Text = WebSiteCommon.FormatID(data.Audit.AUDIT_ID, 6);
/*
* if (data.Audit.DESCRIPTION.Length > 120)
* {
* lbl = (Label)e.Item.FindControl("lblDescription");
* lbl.Text = data.Audit.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("lblAuditBy");
lbl.Text = SQMModelMgr.FormatPersonListItem(data.Person);
}
lbl = (Label)e.Item.FindControl("lblAuditStatus");
List <XLAT> TaskXLATList = SQMBasePage.SelectXLATList(new string[1] {
"AUDIT_STATUS"
});
if (data.Audit.CURRENT_STATUS == "C")
{
// TODO: This throws a null reference error when the database field is NULL (which is valid)
DateTime clsDate = (DateTime)data.Audit.CLOSE_DATE_DATA_COMPLETE;
lbl.Text = TaskXLATList.Where(l => l.XLAT_GROUP == "AUDIT_STATUS" && l.XLAT_CODE == "C").FirstOrDefault().DESCRIPTION + " " + SQMBasePage.FormatDate(clsDate, "d", false);
// TODO: Possible fix
//DateTime? clsDate = data.Audit.CLOSE_DATE;
//if (data.Audit.CLOSE_DATE_DATA_COMPLETE.HasValue)
//{
// clsDate = data.Audit.CLOSE_DATE_DATA_COMPLETE;
//}
//if (clsDate.HasValue)
//{
// lbl.Text = TaskXLATList.Where(l => l.XLAT_GROUP == "AUDIT_STATUS" && l.XLAT_CODE == "C").FirstOrDefault().DESCRIPTION + " " + SQMBasePage.FormatDate(clsDate.Value, "d", false);
//}
}
else
{
if (data.DaysToClose == 0)
{
DateTime tmp = ((DateTime)data.Audit.AUDIT_DT).AddDays(data.AuditType.DAYS_TO_COMPLETE);
lbl.Text = TaskXLATList.Where(l => l.XLAT_GROUP == "AUDIT_STATUS" && l.XLAT_CODE == "X").FirstOrDefault().DESCRIPTION + "<br/>(" + SQMBasePage.FormatDate(tmp, "d", false) + ")";
}
else if (data.Audit.PERCENT_COMPLETE > 0)
{
lbl.Text = TaskXLATList.Where(l => l.XLAT_GROUP == "AUDIT_STATUS" && l.XLAT_CODE == "I").FirstOrDefault().DESCRIPTION + "<br/>(" + data.DaysToClose + ")";
}
else
{
lbl.Text = TaskXLATList.Where(l => l.XLAT_GROUP == "AUDIT_STATUS" && l.XLAT_CODE == "A").FirstOrDefault().DESCRIPTION + "<br/>(" + data.DaysToClose + ")";
}
}
lnk = (LinkButton)e.Item.FindControl("lbAuditId");
LinkButton lnkReAudit = (LinkButton)e.Item.FindControl("lbReAudit");
Label lblAuditingId = (Label)e.Item.FindControl("lblAuditingId");
HiddenField hdnId = (HiddenField)e.Item.FindControl("hdnAuditingId");
if (allowReAudits.ToUpper().Equals("Y"))
{
if (SessionManager.CheckUserPrivilege(SysPriv.admin, SysScope.audit))
{
if (hdnId.Value.ToString().Trim().Equals("0") || hdnId.Value.ToString().Trim().Equals(""))
{
lblAuditingId.Visible = false;
}
else
{
lnkReAudit.Visible = false;
lblAuditingId.Text = Resources.LocalizedText.ReAuditing + " " + hdnId.Value.ToString();
}
}
else
{
lnkReAudit.Visible = false;
lblAuditingId.Visible = false;
}
}
else
{
lnkReAudit.Visible = false;
lblAuditingId.Visible = false;
}
if (SessionManager.UserContext.Person.PERSON_ID == data.Person.PERSON_ID)
{
lnk.CommandArgument = data.Audit.AUDIT_ID.ToString() + "~" + data.Status;
lnkReAudit.Visible = false;
//lblAuditingId.Visible = false;
}
else if (!data.Status.Equals("C"))
{
lnk.CommandArgument = data.Audit.AUDIT_ID.ToString() + "~D";
}
else
{
lnk.CommandArgument = data.Audit.AUDIT_ID.ToString() + "~C";
}
}
}
protected bool SaveUser(bool updateUser)
{
bool bErrors = false;
bool success;
Label lblErrorMessage = null;
PERSON person = LocalPerson();
string currentSSOID = LocalPerson().SSO_ID;
PERSON currentPerson = new PERSON();
if (isNew)
{
person.SSO_ID = string.IsNullOrEmpty(tbUserSSOID.Text) ? "" : tbUserSSOID.Text.Trim(); // trim traling blanks when creating new user
}
else
{
person = SQMModelMgr.LookupPerson(entities, person.PERSON_ID, "", false);
person.SSO_ID = string.IsNullOrEmpty(tbUserSSOID.Text) ? "" : tbUserSSOID.Text;
currentPerson.ROLE = person.ROLE;
}
person.FIRST_NAME = string.IsNullOrEmpty(tbUserFirstName.Text) ? "" : tbUserFirstName.Text;
person.LAST_NAME = string.IsNullOrEmpty(tbUserLastName.Text) ? "" : tbUserLastName.Text;
person.MIDDLE_NAME = string.IsNullOrEmpty(tbUserMiddleName.Text) ? "" : tbUserMiddleName.Text;
person.JOBCODE_CD = ddlJobCode.SelectedValue;
if (string.IsNullOrEmpty(ddlPrivGroup.SelectedValue))
{
person.PRIV_GROUP = null;
}
else
{
person.PRIV_GROUP = ddlPrivGroup.SelectedValue;
}
person.PHONE = tbUserPhone.Text;
person.EMAIL = tbUserEmail.Text;
person.EMP_ID = tbEmpID.Text;
person.SUPV_EMP_ID = tbSupvEmpID.Text;
if (!string.IsNullOrEmpty(ddlUserLanguage.SelectedValue))
{
person.PREFERRED_LANG_ID = Convert.ToInt32(ddlUserLanguage.SelectedValue);
}
if (!string.IsNullOrEmpty(ddlUserTimezone.SelectedValue))
{
person.PREFERRED_TIMEZONE = ddlUserTimezone.SelectedValue;
}
person.COMPANY_ID = SessionManager.EffLocation.Company.COMPANY_ID;
if (!string.IsNullOrEmpty(ddlHRLocation.SelectedValue))
{
PLANT plant = SQMModelMgr.LookupPlant(Convert.ToDecimal(ddlHRLocation.SelectedValue));
if (plant != null)
{
person.PLANT_ID = plant.PLANT_ID;
person.BUS_ORG_ID = (decimal)plant.BUS_ORG_ID;
}
}
person.NEW_LOCATION_CD = "";
foreach (RadComboBoxItem item in SQMBasePage.GetComboBoxCheckedItems(ddlPlantSelect))
{
if (string.IsNullOrEmpty(person.NEW_LOCATION_CD))
{
person.NEW_LOCATION_CD = ",";
}
person.NEW_LOCATION_CD += (item.Value + ",");
}
person.OLD_LOCATION_CD = "";
/* quality module reference
* foreach (RadComboBoxItem item in SQMBasePage.GetComboBoxCheckedItems(ddlCustPlantSelect))
* {
* person.OLD_LOCATION_CD += (item.Value + ",");
* }
* person.OLD_LOCATION_CD = person.OLD_LOCATION_CD.TrimEnd(',');
*/
person.STATUS = ddlUserStatus.SelectedValue;
// roles were originally a list - let's keep the logic below just in case we need to restore a multi-role strategy
//person.PERSON_ROLE.Clear();
person.ROLE = 100; /////
person.RCV_ESCALATION = true;
person.LOCKS = "";
if (cbUserEmailLock.Checked)
{
person.LOCKS += (LockField.email.ToString() + ",");
}
if (cbPrivGroupLock.Checked)
{
person.LOCKS += (LockField.priv.ToString() + ",");
}
if (cbHRLocationLock.Checked)
{
person.LOCKS += (LockField.plant.ToString() + ",");
}
if (cbUserLanguageLock.Checked)
{
person.LOCKS += (LockField.lang.ToString() + ",");
}
person.LOCKS = person.LOCKS.TrimEnd(',');
SetLocalPerson(person);
if (string.IsNullOrEmpty(tbUserSSOID.Text) || string.IsNullOrEmpty(tbUserFirstName.Text) || string.IsNullOrEmpty(tbUserLastName.Text) ||
ddlJobCode.SelectedIndex < 0 || string.IsNullOrEmpty(ddlHRLocation.SelectedValue) ||
string.IsNullOrEmpty(ddlHRLocation.SelectedValue))
{
lblErrorMessage = lblErrRequiredInputs;
}
if (lblErrorMessage == null)
{
// AW20131106 - need to verify that the SSO_ID and email address are unique in the system
lblDuplicateSSOId.Visible = false;
lblDuplicateEmail.Visible = false;
string strSSOId = tbUserSSOID.Text;
string strEmail = tbUserEmail.Text;
if (isNew) // || !strSSOId.Equals(person.SSO_ID))
{
// verify unique sso_id
strSSOId = tbUserSSOID.Text.Trim();
SQM.Website.PSsqmEntities ctxAccess = new PSsqmEntities();
SQM_ACCESS access = SQMModelMgr.LookupCredentials(ctxAccess, strSSOId, "", false);
if (access != null && access.SSO_ID.ToLower().Equals(strSSOId.ToLower()))
{
lblErrorMessage = lblDuplicateSSOId;
}
}
if (lblErrorMessage == null && (isNew || !strEmail.Equals(person.EMAIL)))
{
// verify unique email
SQM.Website.PSsqmEntities ctxAccess = new PSsqmEntities();
//SQM_ACCESS access = SQMModelMgr.LookupCredentialsByEmail(ctxAccess, strEmail, false);
// ABW 20140117 - we want to look up email on person record...
PERSON personEmail = SQMModelMgr.LookupPersonByEmail(ctxAccess, strEmail);
if (personEmail != null && personEmail.EMAIL.Trim().ToLower().Equals(strEmail.Trim().ToLower()))
{
lblErrorMessage = lblDuplicateEmail;
}
}
}
if (lblErrorMessage != null)
{
DisplayUser();
DisplayErrorMessage(lblErrorMessage);
return(false);
}
if (updateUser)
{
string defaultPwd = "";
string environment = System.Configuration.ConfigurationManager.AppSettings["environment"].ToString();
string altEmail = !string.IsNullOrEmpty(environment) && environment.ToLower() == "dev" ? System.Configuration.ConfigurationManager.AppSettings["altEmail"].ToString() : "";
if (isNew)
{
SETTINGS pwdInitial = SQMSettings.SelectSettingByCode(entities, "COMPANY", "TASK", "PasswordDefault");
if (pwdInitial != null)
{
switch (pwdInitial.VALUE.ToUpper())
{
case "LASTNAME":
defaultPwd = person.LAST_NAME;
break;
case "EMPID":
defaultPwd = person.EMP_ID;
break;
default:
break;
}
}
}
SetLocalPerson(SQMModelMgr.UpdatePerson(entities, person, SessionManager.UserContext.UserName(), false, currentSSOID, defaultPwd));
//selectedUser = SQMModelMgr.UpdatePerson(entities, person, SessionManager.UserContext.UserName(), Convert.ToBoolean(GetFindControlValue("cbIsBuyer", hfBase, out success)), GetFindControlValue("tbBuyerCode", hfBase, out success));
// AW20131106 - send an email for new users with random password generation
List <SETTINGS> MailSettings = SQMSettings.SelectSettingsGroup("MAIL", ""); // ABW 20140805
SETTINGS setting = new SETTINGS(); // ABW 20140805
setting = MailSettings.Find(x => x.SETTING_CD == "MailFromSystem"); // ABW 20140805
string strEmailCompanyName = ""; // ABW 20140805
if (setting != null) // ABW 20140805
{
strEmailCompanyName = setting.VALUE;
}
bool sendEmail = false;
setting = MailSettings.Find(x => x.SETTING_CD == "SendNewUserEmail");
if (setting != null && setting.VALUE.ToLower().Equals("true")) // ABW 20140805
{
sendEmail = true;
}
List <XLAT> XLATList = SQMBasePage.SelectXLATList(new string[1] {
"USER_EMAIL"
}, 0);
string strEmailSubject = "";
string strEmailBody = "";
LOCAL_LANGUAGE lang = SQMModelMgr.LookupLanguage(new PSsqmEntities(), "", (int)person.PREFERRED_LANG_ID, false);
string strTemp = "";
if (isNew && (string.IsNullOrEmpty(defaultPwd) || sendEmail)) // send email notice only when a default password was not set
{
// send a confirmation email
// string strength = WebConfigurationManager.AppSettings["PasswordComplexity"]; // ABW 20140805
SETTINGS complexity = SQMSettings.SelectSettingByCode(entities, "COMPANY", "TASK", "PasswordComplexity"); // ABW 20140805
string strength = ""; // ABW 20140805
if (complexity == null)
{
strength = "4";
}
else
{
strength = complexity.VALUE;
}
SQM.Website.PSsqmEntities ctxAccess = new PSsqmEntities();
SQM_ACCESS access = SQMModelMgr.LookupCredentials(ctxAccess, LocalPerson().SSO_ID, "", false);
string key = SQMModelMgr.GetPasswordKey();
string strPassword = WebSiteCommon.Decrypt(access.PASSWORD, key);
// ABW 20140805 - Build the email based on fields in the SETTINGS table
//string strEmailSubject = "";
//setting = MailSettings.Find(x => x.SETTING_CD == "NewUserSubject");
//if (setting == null)
// strEmailSubject = strEmailCompanyName + " " + lblPasswordEmailSubject.Text.ToString();
//else
// strEmailSubject = setting.VALUE.Trim();
//setting = MailSettings.Find(x => x.SETTING_CD == "NewUserWelcome");
//string strEmailBody = "";
//if (setting == null)
// strEmailBody = lblPasswordEmailBody1a.Text.ToString();
//else
// strEmailBody = setting.VALUE.Trim();
//strEmailBody += lblPasswordEmailBody1b.Text.ToString() + " " + LocalPerson().SSO_ID + lblPasswordEmailBody2.Text.ToString() + " " + strPassword;
//setting = MailSettings.Find(x => x.SETTING_CD == "MailURL");
//if (setting != null)
// strEmailBody += lblPasswordEmailBody2b.Text.ToString() + "<a href='" + setting.VALUE + "'>" + setting.VALUE + "</a>";
//complexity = SQMSettings.SelectSettingByCode(entities, "PASSWORDCOMPLEXITY", "TASK", strength); // ABW 20140805
//if (complexity != null)
// strEmailBody += "<br><br>" + complexity.VALUE + "<br><br>";
//setting = MailSettings.Find(x => x.SETTING_CD == "NewUserSignature");
//if (setting == null)
// strEmailBody += "<br><br>" + lblPasswordEmailBody3.Text.ToString();
//else
// strEmailBody += "<br><br>" + setting.VALUE.Trim();
// ABW 20160115 - Build the email based on fields in the XLAT table
strTemp = SQMBasePage.GetXLAT(XLATList, "USER_EMAIL", "NewUserSubject", lang.NLS_LANGUAGE).DESCRIPTION;
if (strTemp == null || strTemp == "")
{
strEmailSubject = strEmailCompanyName + " " + lblPasswordEmailSubject.Text.ToString();
}
else
{
strEmailSubject = strTemp.Trim();
}
strTemp = SQMBasePage.GetXLAT(XLATList, "USER_EMAIL", "NewUserWelcome", lang.NLS_LANGUAGE).DESCRIPTION;
strEmailBody = "";
if (strTemp == null || strTemp == "")
{
strEmailBody = lblPasswordEmailBody1a.Text.ToString();
}
else
{
strEmailBody = strTemp.Trim();
}
strTemp = SQMBasePage.GetXLAT(XLATList, "USER_EMAIL", "NewUserBodyUsername", lang.NLS_LANGUAGE).DESCRIPTION;
if (strTemp == null || strTemp == "")
{
strEmailBody += lblPasswordEmailBody1b.Text.ToString();
}
else
{
strEmailBody += strTemp.Trim();
}
strEmailBody += " " + LocalPerson().SSO_ID;
strTemp = SQMBasePage.GetXLAT(XLATList, "USER_EMAIL", "NewUserBodyPassword", lang.NLS_LANGUAGE).DESCRIPTION;
if (strTemp == null || strTemp == "")
{
strEmailBody += lblPasswordEmailBody2.Text.ToString();
}
else
{
strEmailBody += strTemp.Trim();
}
strEmailBody += " " + strPassword;
strTemp = SQMBasePage.GetXLAT(XLATList, "USER_EMAIL", "NewUserBodyUrl", lang.NLS_LANGUAGE).DESCRIPTION;
string strUrlLabel = "";
if (strTemp == null || strTemp == "")
{
strUrlLabel = lblPasswordEmailBody2b.Text.ToString();
}
else
{
strUrlLabel = strTemp.Trim();
}
setting = MailSettings.Find(x => x.SETTING_CD == "MailURL");
if (setting != null)
{
strEmailBody += strUrlLabel + " <a href='" + setting.VALUE + "'>" + setting.VALUE + "</a>";
}
complexity = SQMSettings.SelectSettingByCode(entities, "PASSWORDCOMPLEXITY", "TASK", strength); // ABW 20140805
if (complexity != null)
{
strEmailBody += "<br><br>" + complexity.VALUE + "<br><br>";
}
strTemp = SQMBasePage.GetXLAT(XLATList, "USER_EMAIL", "NewUserSignature", lang.NLS_LANGUAGE).DESCRIPTION;
if (strTemp == null || strTemp == "")
{
strEmailBody += "<br><br>" + lblPasswordEmailBody3.Text.ToString();
}
else
{
strEmailBody += "<br><br>" + strTemp.Trim();
}
// ABW 20140117 - we are now using the email on the Person record
/*
* Thread thread = new Thread(() => WebSiteCommon.SendEmail(person.EMAIL, strEmailSubject, strEmailBody.Trim(), ""));
* thread.IsBackground = true;
* thread.Start();
*/
string mailStatus = WebSiteCommon.SendEmail(person.EMAIL, strEmailSubject, strEmailBody.Trim(), "");
EHSNotificationMgr.WriteEmailLog(entities, person.EMAIL, "", strEmailSubject, strEmailBody, 0, LocalPerson().PERSON_ID, ("user password notification - is new = " + isNew.ToString()), mailStatus, altEmail);
}
else
{
bool roleChanged = person.ROLE != currentPerson.ROLE ? true : false;
// ABW 20160115 - send an email based on a parameter
setting = MailSettings.Find(x => x.SETTING_CD == "SendChangeUserEmail");
if (setting != null && setting.VALUE.ToLower().Equals("true"))
{
sendEmail = true;
}
else
{
sendEmail = false;
}
if (roleChanged && sendEmail)
{
//ABW 20140805 - Build the email based on fields in the SETTINGS table
//strEmailSubject = "";
//setting = MailSettings.Find(x => x.SETTING_CD == "AdminRoleChangeSubject");
//if (setting == null)
// strEmailSubject = lblUserRoleEmailSubjecta.Text + strEmailCompanyName + lblUserRoleEmailSubjectb.Text;
//else
// strEmailSubject = setting.VALUE.Trim();
//setting = MailSettings.Find(x => x.SETTING_CD == "AdminRoleChangeWelcome");
//string strEmailBody = "";
//if (setting == null)
// strEmailBody = lblUserRoleEmailBodya.Text + strEmailCompanyName + lblUserRoleEmailBodyb.Text;
//else
// strEmailBody = setting.VALUE.Trim();
//setting = MailSettings.Find(x => x.SETTING_CD == "AdminRoleChangeSignature");
//if (setting == null)
// strEmailBody += "<br><br>" + lblUserRoleEmailBodyc.Text;
//else
// strEmailBody += "<br><br>" + setting.VALUE.Trim();
//ABW 20160115 - Build the email based on fields in the XLAT table
strEmailSubject = "";
strTemp = SQMBasePage.GetXLAT(XLATList, "USER_EMAIL", "AdminRoleChangeSubject", lang.NLS_LANGUAGE).DESCRIPTION;
if (strTemp == null || strTemp == "")
{
strEmailSubject = lblUserRoleEmailSubjecta.Text + strEmailCompanyName + lblUserRoleEmailSubjectb.Text;
}
else
{
strEmailSubject = strTemp.Trim();
}
strEmailBody = "";
strTemp = SQMBasePage.GetXLAT(XLATList, "USER_EMAIL", "AdminRoleChangeWelcome", lang.NLS_LANGUAGE).DESCRIPTION;
if (strTemp == null || strTemp == "")
{
strEmailBody = lblUserRoleEmailBodya.Text + strEmailCompanyName + lblUserRoleEmailBodyb.Text;
}
else
{
strEmailBody = strTemp.Trim();
}
setting = MailSettings.Find(x => x.SETTING_CD == "AdminRoleChangeSignature");
strTemp = SQMBasePage.GetXLAT(XLATList, "USER_EMAIL", "AdminRoleChangeSignature", lang.NLS_LANGUAGE).DESCRIPTION;
if (strTemp == null || strTemp == "")
{
strEmailBody += "<br><br>" + lblUserRoleEmailBodyc.Text;
}
else
{
strEmailBody += strTemp.Trim();
}
/*
* Thread thread = new Thread(() => WebSiteCommon.SendEmail(person.EMAIL, strEmailSubject, strEmailBody, ""));
* thread.IsBackground = true;
* thread.Start();
*/
string mailStatus = WebSiteCommon.SendEmail(person.EMAIL, strEmailSubject, strEmailBody, "");
EHSNotificationMgr.WriteEmailLog(entities, person.EMAIL, "", strEmailSubject, strEmailBody, 0, LocalPerson().PERSON_ID, "user role changed", mailStatus, altEmail);
}
if (cbResetPassword.Checked) // always send an email when the password changes
{
// build the email body in 3 segments
SETTINGS complexity = SQMSettings.SelectSettingByCode(entities, "COMPANY", "TASK", "PasswordComplexity");
string strength = "";
if (complexity == null)
{
strength = "4";
}
else
{
strength = complexity.VALUE;
}
// ABW 20140805 - Build the email based on fields in the SETTINGS table
//string strEmailSubject = "";
//setting = MailSettings.Find(x => x.SETTING_CD == "AdminPasswordResetSubject");
//if (setting == null)
// strEmailSubject = strEmailCompanyName + " " + lblResetEmailSubject.Text.ToString();
//else
// strEmailSubject = setting.VALUE.Trim();
//setting = MailSettings.Find(x => x.SETTING_CD == "AdminPasswordResetWelcome");
//string strEmailBodya = "";
//string strEmailBodyb = "";
//string strEmailBodyc = "";
//if (setting == null)
// strEmailBodya = lblPasswordEmailBody1a.Text.ToString();
//else
// strEmailBodya = setting.VALUE.Trim();
//strEmailBodya += lblPasswordEmailBody1b.Text.ToString();
//strEmailBodyb = lblPasswordEmailBody2.Text.ToString();
//setting = MailSettings.Find(x => x.SETTING_CD == "MailURL");
//if (setting != null)
// strEmailBodyc += lblPasswordEmailBody2b.Text.ToString() + "<a href='" + setting.VALUE + "'>" + setting.VALUE + "</a>";
//complexity = SQMSettings.SelectSettingByCode(entities, "PASSWORDCOMPLEXITY", "TASK", strength);
//if (complexity != null)
// strEmailBodyc += "<br><br>" + complexity.VALUE + "<br><br>";
//setting = MailSettings.Find(x => x.SETTING_CD == "AdminPasswordResetSignature");
//if (setting == null)
// strEmailBodyc += "<br><br>" + lblPasswordEmailBody3.Text.ToString();
//else
// strEmailBodyc += "<br><br>" + setting.VALUE.Trim();
// ABW 20160115 - Build the email based on fields in the XLAT table
strTemp = SQMBasePage.GetXLAT(XLATList, "USER_EMAIL", "AdminPasswordResetSubject", lang.NLS_LANGUAGE).DESCRIPTION;
if (strTemp == null || strTemp == "")
{
strEmailSubject = strEmailCompanyName + " " + lblPasswordEmailSubject.Text.ToString();
}
else
{
strEmailSubject = strTemp.Trim();
}
string strEmailBodya = "";
string strEmailBodyb = "";
string strEmailBodyc = "";
strTemp = SQMBasePage.GetXLAT(XLATList, "USER_EMAIL", "AdminPasswordResetWelcome", lang.NLS_LANGUAGE).DESCRIPTION;
if (strTemp == null || strTemp == "")
{
strEmailBodya = lblResetEmailBody1a.Text.ToString();
}
else
{
strEmailBodya = strTemp.Trim();
}
strTemp = SQMBasePage.GetXLAT(XLATList, "USER_EMAIL", "NewUserBodyUsername", lang.NLS_LANGUAGE).DESCRIPTION;
if (strTemp == null || strTemp == "")
{
strEmailBodya += lblPasswordEmailBody1b.Text.ToString();
}
else
{
strEmailBodya += strTemp.Trim();
}
strTemp = SQMBasePage.GetXLAT(XLATList, "USER_EMAIL", "NewUserBodyPassword", lang.NLS_LANGUAGE).DESCRIPTION;
if (strTemp == null || strTemp == "")
{
strEmailBodyb = lblPasswordEmailBody2.Text.ToString();
}
else
{
strEmailBodyb = strTemp.Trim();
}
strTemp = SQMBasePage.GetXLAT(XLATList, "USER_EMAIL", "NewUserBodyUrl", lang.NLS_LANGUAGE).DESCRIPTION;
string strUrlLabel = "";
if (strTemp == null || strTemp == "")
{
strUrlLabel = lblPasswordEmailBody2b.Text.ToString();
}
else
{
strUrlLabel = strTemp.Trim();
}
setting = MailSettings.Find(x => x.SETTING_CD == "MailURL");
if (setting != null)
{
strEmailBodyc += strUrlLabel.Trim() + "<a href='" + setting.VALUE + "'>" + setting.VALUE + "</a>";
}
complexity = SQMSettings.SelectSettingByCode(entities, "PASSWORDCOMPLEXITY", "TASK", strength);
if (complexity != null)
{
strEmailBodyc += "<br><br>" + complexity.VALUE + "<br><br>";
}
strTemp = SQMBasePage.GetXLAT(XLATList, "USER_EMAIL", "NewUserSignature", lang.NLS_LANGUAGE).DESCRIPTION;
if (strTemp == null || strTemp == "")
{
strEmailBodyc += "<br><br>" + lblPasswordEmailBody3.Text.ToString();
}
else
{
strEmailBodyc += "<br><br>" + strTemp.Trim();
}
int msg = WebSiteCommon.RecoverPassword(person.EMAIL, person.SSO_ID, strEmailSubject, strEmailBodya, strEmailBodyb, strEmailBodyc);
EHSNotificationMgr.WriteEmailLog(entities, person.EMAIL, "", strEmailSubject, strEmailBodya, 0, LocalPerson().PERSON_ID, "recover password", msg.ToString(), altEmail);
}
}
isNew = false;
if (SQMModelMgr.updateStatus < 0) // report error
{
AlertUpdateResult(SQMModelMgr.updateStatus);
}
}
else
{
SetLocalPerson(person);
}
return(true);
}
public void PopulateInitialForm(INCFORM_TYPE_CONTROL stepRecord)
{
PSsqmEntities entities = new PSsqmEntities();
ApprovalStep = stepRecord;
XLATList = SQMBasePage.SelectXLATList(new string[1] {
"INCIDENT_APPROVALS"
}, SessionManager.UserContext.Person.PREFERRED_LANG_ID.HasValue ? (int)SessionManager.UserContext.Person.PREFERRED_LANG_ID : 1);
string incident = "";
if (IncidentId > 0)
{
try
{
LocalIncident = (from i in entities.INCIDENT where i.INCIDENT_ID == IncidentId select i).FirstOrDefault();
PLANT plant = SQMModelMgr.LookupPlant(entities, (decimal)LocalIncident.DETECT_PLANT_ID, "");
if (plant != null)
{
IncidentLocationTZ = plant.LOCAL_TIMEZONE;
}
//Get Issue type.
if (LocalIncident != null)
{
incident = LocalIncident.ISSUE_TYPE;
}
if (incident == null)
{
incident = "";
}
//To Display severity-level section only for Injury/Illness type incidents.
if (incident == "Injury/Illness")
{
if (status == 0)
{
pnlSeverityDescription.Visible = false;
pnlSeverity.Visible = false;
}
else if (status == 1) //Display severity level and checkBox on Flash Report SignOff only.
{
pnlSeverity.Visible = true;
pnlSeverityDescription.Visible = false;
}
else if (status == 2)//Display severity level with description on Investigation Report Signoff only.
{
pnlSeverity.Visible = false;
pnlSeverityDescription.Visible = true;
}
}
//Get SEVERITY-LEVEL information from database, check related checkbox and display servity-level description.
string res = (from i in entities.INCFORM_APPROVAL where i.INCIDENT_ID == IncidentId select i.SEVERITY_LEVEL).FirstOrDefault();
if (res == null)
{
res = "";
}
else
{
chkSeverityLevel00.Enabled = false;
chkSeverityLevel01.Enabled = false;
chkSeverityLevel02.Enabled = false;
chkSeverityLevel03.Enabled = false;
chkSeverityLevel04.Enabled = false;
}
if (res == SysPriv.first_add.ToString())
{
chkSeverityLevel00.Checked = true;
lblSeverityLevelDescription.Text = chkSeverityLevel00.Text;
}
else if (res == SysPriv.l1.ToString())
{
chkSeverityLevel01.Checked = true;
lblSeverityLevelDescription.Text = chkSeverityLevel01.Text;
}
else if (res == SysPriv.l2.ToString())
{
chkSeverityLevel02.Checked = true;
lblSeverityLevelDescription.Text = chkSeverityLevel02.Text;
}
else if (res == SysPriv.l3.ToString())
{
chkSeverityLevel03.Checked = true;
lblSeverityLevelDescription.Text = chkSeverityLevel03.Text;
}
else if (res == SysPriv.l4.ToString())
{
chkSeverityLevel04.Checked = true;
lblSeverityLevelDescription.Text = chkSeverityLevel04.Text;
}
}
catch (Exception ex) { string s = ex.Message; }
}
InitializeForm(entities);
}
public void BindNotfyPlan(List <NOTIFYACTION> notifyItemList, BusinessLocation businessLocation, string context)
{
hfNotifyActionContext.Value = context;
if (context != "company")
{
hfNotifyActionBusLoc.Value = context == "plant" ? businessLocation.Plant.PLANT_ID.ToString() : businessLocation.BusinessOrg.BUS_ORG_ID.ToString();
}
if (ddlNotifyScope.Items.Count == 0)
{
XLATList = SQMBasePage.SelectXLATList(new string[4] {
"NOTIFY_SCOPE", "NOTIFY_SCOPE_TASK", "NOTIFY_TASK_STATUS", "NOTIFY_TIMING"
});
// filter out non-installed or authorized modules from the notify-scope list
List <SETTINGS> settingList = SQMSettings.SelectSettingsGroup("MODULE", "");
if (settingList.Where(l => l.SETTING_CD == "PREVACTION" && l.VALUE == "A").Count() < 1)
{
XLATList = XLATList.Where(x => !x.XLAT_CODE.Contains("RM-")).ToList();
}
ddlNotifyScope.DataSource = XLATList.Where(x => x.XLAT_GROUP == "NOTIFY_SCOPE").ToList();
ddlNotifyScope.DataValueField = "XLAT_CODE";
ddlNotifyScope.DataTextField = "DESCRIPTION";
ddlNotifyScope.DataBind();
ddlScopeTask.DataSource = XLATList.Where(x => x.XLAT_GROUP == "NOTIFY_SCOPE_TASK").ToList();
ddlScopeTask.DataValueField = "XLAT_CODE";
ddlScopeTask.DataTextField = "DESCRIPTION";
ddlScopeTask.DataBind();
ddlScopeStatus.DataSource = XLATList.Where(x => x.XLAT_GROUP == "NOTIFY_TASK_STATUS").ToList();
ddlScopeStatus.DataValueField = "XLAT_CODE";
ddlScopeStatus.DataTextField = "DESCRIPTION";
ddlScopeStatus.DataBind();
ddlScopeTiming.DataSource = XLATList.Where(x => x.XLAT_GROUP == "NOTIFY_TIMING").ToList();
ddlScopeTiming.DataValueField = "XLAT_CODE";
ddlScopeTiming.DataTextField = "DESCRIPTION";
ddlScopeTiming.DataBind();
/*
* foreach (PRIVGROUP pg in SQMModelMgr.SelectPrivGroupList(new SysPriv[2] { SysPriv.admin, SysPriv.notify }, SysScope.incident, "A").ToList())
* {
* ddlNotifyPrivGroup.Items.Add(new RadComboBoxItem(SQMModelMgr.FormatPrivGroup(pg), pg.PRIV_GROUP));
* }
*/
foreach (PRIVGROUP pg in SQMModelMgr.SelectPrivGroupList("A", false).ToList())
{
if (pg.PRIV_GROUP.ToUpper() != "COMMON")
{
ddlNotifyPrivGroup.Items.Add(new RadComboBoxItem(SQMModelMgr.FormatPrivGroup(pg), pg.PRIV_GROUP));
}
}
}
pnlNotifyAction.Visible = true;
rgNotifyAction.DataSource = notifyItemList;
rgNotifyAction.DataBind();
}
private void SetupPage()
{
if (ddlPlantSelect.Items.Count < 1)
{
List <BusinessLocation> locationList = SQMModelMgr.SelectBusinessLocationList(SessionManager.UserContext.HRLocation.Company.COMPANY_ID, 0, true);
SQMBasePage.SetLocationList(ddlPlantSelect, UserContext.FilterPlantAccessList(locationList), 0);
List <XLAT> xlatList = SQMBasePage.SelectXLATList(new string[4] {
"IQ_81", "IQ_82", "IQ_83", "STATUS_SELECT"
}, 1);
rcbInspectionType = SQMBasePage.SetComboBoxItemsFromXLAT(rcbInspectionType, xlatList.Where(l => l.XLAT_GROUP == "IQ_81" && l.STATUS == "A").ToList(), "SHORT");
rcbRecommendType = SQMBasePage.SetComboBoxItemsFromXLAT(rcbRecommendType, xlatList.Where(l => l.XLAT_GROUP == "IQ_83").ToList(), "SHORT");
rcbStatusSelect = SQMBasePage.SetComboBoxItemsFromXLAT(rcbStatusSelect, xlatList.Where(l => l.XLAT_GROUP == "STATUS_SELECT").Where(l => new string[] { "A", "C", "P", "U" }.Contains(l.XLAT_CODE)).ToList(), "SHORT");
rcbStatusSelect.SelectedValue = "A";
// work-around for problem w/ radwindow combobox not retaining items created/set from a basepage method ?
SQMBasePage.SetLocationList(ddlActionLocation, locationList, 0, true);
rddlNewActionType.DataSource = xlatList.Where(l => l.XLAT_GROUP == "IQ_81" && l.STATUS == "A").ToList();
rddlNewActionType.DataTextField = "DESCRIPTION_SHORT";
rddlNewActionType.DataValueField = "XLAT_CODE";
rddlNewActionType.DataBind();
}
divIncidentList.Visible = true;
pnlChartSection.Style.Add("display", "none");
lblChartType.Visible = ddlChartType.Visible = false;
SQMBasePage.SetRadDateCulture(dmFromDate, "");
SQMBasePage.SetRadDateCulture(dmToDate, "");
dmFromDate.ShowPopupOnFocus = dmToDate.ShowPopupOnFocus = true;
dmFromDate.SelectedDate = SessionManager.UserContext.LocalTime.AddMonths(-11);
dmToDate.SelectedDate = SessionManager.UserContext.LocalTime;
//lblViewEHSRezTitle.Text = GetLocalResourceObject("lblViewEHSRezTitleResource1.Text").ToString();
//lblPageInstructions.Text = GetLocalResourceObject("lblPageInstructionsResource1.Text").ToString();
//lblStatus.Text = "Incident Status:";
//rbNew.Text = GetLocalResourceObject("rbNewResource1.Text").ToString();
lblIncidentDate.Visible = true;
lblInspectionDate.Visible = false;
SETTINGS sets = SQMSettings.GetSetting("EHS", "INCIDENTSEARCHFROM");
if (sets != null)
{
try
{
string[] args = sets.VALUE.Split('-');
if (args.Length > 1)
{
dmFromDate.SelectedDate = new DateTime(Convert.ToInt32(args[0]), Convert.ToInt32(args[1]), Convert.ToInt32(args[2]));
}
else
{
dmFromDate.SelectedDate = SessionManager.UserContext.LocalTime.AddMonths(Convert.ToInt32(args[0]) * -1);
}
}
catch { }
}
// lookup charts defined for this module & app context
PERSPECTIVE_VIEW view = ViewModel.LookupView(entities, "HSCA", "HSCA", 0, SessionManager.UserContext.Language.NLS_LANGUAGE);
if (view != null)
{
ddlChartType.Items.Clear();
ddlChartType.Items.Add(new RadComboBoxItem("", ""));
foreach (PERSPECTIVE_VIEW_ITEM vi in view.PERSPECTIVE_VIEW_ITEM.Where(l => l.STATUS != "I").OrderBy(l => l.ITEM_SEQ).ToList())
{
RadComboBoxItem item = new RadComboBoxItem();
item.Text = vi.TITLE;
item.Value = vi.ITEM_SEQ.ToString();
item.ImageUrl = ViewModel.GetViewItemImageURL(vi);
ddlChartType.Items.Add(item);
}
}
if (UserContext.GetMaxScopePrivilege(SysScope.prevent) <= SysPriv.action)
{
uclExport.Visible = true;
}
else
{
uclExport.Visible = false;
}
}
