protected void Save(bool shouldReturn) { AUDIT_SCHEDULER scheduler = null; decimal auditScheduleId = 0; string result = "<h3>EHS Audit Scheduler " + ((IsEditContext) ? "Updated" : "Created") + ":</h3>"; if (shouldReturn == true) { divForm.Visible = false; pnlAddEdit.Visible = false; btnSaveReturn.Visible = false; RadCodeBlock rcbWarnNavigate = (RadCodeBlock)this.Parent.Parent.FindControl("rcbWarnNavigate"); if (rcbWarnNavigate != null) { rcbWarnNavigate.Visible = false; } lblResults.Visible = true; } if (!IsEditContext) { auditTypeId = SelectedTypeId; auditType = rddlAuditType.SelectedText; } else { auditTypeId = EditAuditTypeId; auditType = EHSAuditMgr.SelectAuditTypeByAuditScheduleId(EditAuditScheduleId); } if (!IsEditContext) { // Add context scheduler = CreateNewAuditScheduler(); auditScheduleId = scheduler.AUDIT_SCHEDULER_ID; } else { // Edit context auditScheduleId = EditAuditScheduleId; if (auditScheduleId > 0) { scheduler = UpdateAuditScheduler(auditScheduleId); } } if (shouldReturn) { SessionManager.ReturnStatus = false; SessionManager.ReturnObject = "DisplayAuditSchedules"; Response.Redirect("/EHS/EHS_Audit_Scheduler.aspx"); // mt - temporary } }
protected AUDIT_SCHEDULER UpdateAuditScheduler(decimal auditScheduleId) { AUDIT_SCHEDULER scheduler = (from i in entities.AUDIT_SCHEDULER where i.AUDIT_SCHEDULER_ID == auditScheduleId select i).FirstOrDefault(); PLANT auditPlant = SQMModelMgr.LookupPlant(Convert.ToDecimal(hdnAuditLocation.Value.ToString())); if (scheduler != null) { scheduler.PLANT_ID = auditPlant.PLANT_ID; scheduler.AUDIT_TYPE_ID = Convert.ToDecimal(rddlAuditType.SelectedValue.ToString()); scheduler.DAY_OF_WEEK = Convert.ToInt32(rddlDayOfWeek.SelectedValue.ToString()); scheduler.JOBCODE_CD = rddlAuditJobcodes.SelectedValue.ToString(); scheduler.INACTIVE = cbInactive.Checked; scheduler.UPDATE_DT = DateTime.Now; scheduler.UPDATE_PERSON = SessionManager.UserContext.Person.PERSON_ID; entities.SaveChanges(); } return(scheduler); }
protected AUDIT_SCHEDULER CreateNewAuditScheduler() { decimal auditScheduleId = 0; PLANT auditPlant = SQMModelMgr.LookupPlant(Convert.ToDecimal(hdnAuditLocation.Value.ToString())); var newAuditScheduler = new AUDIT_SCHEDULER() { DAY_OF_WEEK = Convert.ToInt32(rddlDayOfWeek.SelectedValue.ToString()), INACTIVE = false, JOBCODE_CD = rddlAuditJobcodes.SelectedValue.ToString(), PLANT_ID = auditPlant.PLANT_ID, CREATE_DT = DateTime.Now, CREATE_PERSON = SessionManager.UserContext.Person.PERSON_ID, AUDIT_TYPE_ID = auditTypeId }; entities.AddToAUDIT_SCHEDULER(newAuditScheduler); entities.SaveChanges(); auditScheduleId = newAuditScheduler.AUDIT_SCHEDULER_ID; return(newAuditScheduler); }
protected void LoadInformation() { // set up for adding the header info List <PRIVGROUP> pl = SQMModelMgr.SelectPrivGroupList(new SysPriv[1] { SysPriv.originate }, SysScope.audit, ""); // SQMModelMgr.SelectPrivGroupJobcodeList(SysPriv.originate, SysScope.audit); DropDownListItem item = new DropDownListItem(); UpdateAuditTypes(); if (rddlAuditJobcodes.Items.Count == 0) { rddlAuditJobcodes.DataSource = pl; rddlAuditJobcodes.DataTextField = "DESCRIPTION"; rddlAuditJobcodes.DataValueField = "PRIV_GROUP"; rddlAuditJobcodes.DataBind(); item = new DropDownListItem("[Select a Group]", ""); rddlAuditJobcodes.Items.Insert(0, item); } if (rddlDayOfWeek.Items.Count == 0) { rddlDayOfWeek.Items.Clear(); rddlDayOfWeek.DataSource = EHS_Audit_Scheduler.GetAll <DayOfWeek>(); rddlDayOfWeek.DataTextField = "Value"; rddlDayOfWeek.DataValueField = "Key"; rddlDayOfWeek.DataBind(); item = new DropDownListItem("[Select a Day]", ""); rddlDayOfWeek.Items.Insert(0, item); } if (IsEditContext || CurrentStep > 0) { // in edit mode, load the header field values and make all fields display only AUDIT_SCHEDULER scheduler = EHSAuditMgr.SelectAuditSchedulerById(entities, EditAuditScheduleId); BusinessLocation location = new BusinessLocation().Initialize((decimal)scheduler.PLANT_ID); rddlAuditType.SelectedValue = scheduler.AUDIT_TYPE_ID.ToString(); rddlAuditType.Enabled = false; rddlAuditType.Visible = false; lblScheduleAuditType.Visible = true; lblScheduleAuditType.Text = rddlAuditType.SelectedText.ToString(); hdnAuditLocation.Value = location.Plant.PLANT_ID.ToString(); lblAuditLocation.Text = location.Plant.PLANT_NAME + " " + location.BusinessOrg.ORG_NAME; lblAuditLocation.Visible = true; ddlAuditLocation.Visible = false; mnuAuditLocation.Visible = false; rddlDayOfWeek.SelectedValue = scheduler.DAY_OF_WEEK.ToString(); cbInactive.Checked = scheduler.INACTIVE; // build the audit jobcode list PRIVGROUP pv = pl.Where(i => i.PRIV_GROUP.ToString() == scheduler.JOBCODE_CD).FirstOrDefault(); lblAuditJobcode.Text = pv.DESCRIPTION; lblAuditJobcode.Visible = true; rddlAuditJobcodes.SelectedValue = scheduler.JOBCODE_CD.ToString(); rddlAuditJobcodes.Visible = false; } else { if (UserContext.GetMaxScopePrivilege(SysScope.audit) <= SysPriv.config) { 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) { if (mnuAuditLocation.Items.Count == 0) { mnuAuditLocation.Items.Clear(); ddlAuditLocation.Visible = false; mnuAuditLocation.Visible = true; mnuAuditLocation.Enabled = true; SQMBasePage.SetLocationList(mnuAuditLocation, locationList, 0, "Select a Location", "", true); } } else { if (ddlAuditLocation.Items.Count == 0) { ddlAuditLocation.Items.Clear(); ddlAuditLocation.Visible = true; ddlAuditLocation.Enabled = true; mnuAuditLocation.Visible = false; SQMBasePage.SetLocationList(ddlAuditLocation, locationList, 0, true); ddlAuditLocation.Items[0].ImageUrl = "~/images/defaulticon/16x16/user-alt-2.png"; } } } // set defaults for add mode rddlAuditType.Enabled = true; rddlAuditType.Visible = true; lblAuditLocation.Visible = false; rddlAuditJobcodes.Enabled = true; rddlAuditJobcodes.Visible = true; lblAuditJobcode.Visible = false; lblScheduleAuditType.Visible = false; } }