private void populateGeneral(MNameValuePair profile) { txtNVP_SEQ_ID.Text = profile.Id.ToString(); txtSchemaName.Text = profile.SchemaName; litSchemaName.Text = profile.SchemaName; txtSTATIC_NAME.Text = profile.StaticName; litStaticName.Text = profile.StaticName; txtDisplay.Text = profile.Display; txtDescription.Text = profile.Description; if (!String.IsNullOrEmpty(profile.SchemaName)) { lblTableName.InnerHtml = profile.SchemaName + "." + profile.StaticName; } if (profile.Id > -1) { txtSchemaName.Style.Add("display", "none"); RequiredFieldValidator1.Enabled = false; Alphanumeric.Enabled = false; txtSTATIC_NAME.Style.Add("display", "none"); RequiredFieldValidator2.Enabled = false; Alphanumeric2.Enabled = false; litSchemaName.Visible = true; litStaticName.Visible = true; } else { txtSchemaName.Style.Add("display", ""); txtSTATIC_NAME.Style.Add("display", ""); litSchemaName.Visible = false; litStaticName.Visible = false; } }
/// <summary> /// Saves the specified profile. /// </summary> /// <param name="nameValuePairProfile">The profile.</param> /// <returns>System.Int32.</returns> public int Save(MNameValuePair nameValuePairProfile) { int mRetVal = -1; m_DNameValuePair.NameValuePairProfile = nameValuePairProfile; if (DatabaseIsOnline()) { mRetVal = m_DNameValuePair.Save(); } return(mRetVal); }
/// <summary> /// Inserts or updates a name value pair given a NameValuePair profile /// </summary> /// <param name="profile">Details of the profile to added or updated</param> /// <returns>The Primary sequence ID</returns> /// <remarks></remarks> public static int Save(MNameValuePair profile) { if (profile == null) { throw new ArgumentNullException("profile", "profile cannot be a null reference (Nothing in Visual Basic)!"); } int mRetVal = -1; MSecurityEntityProfile mSecurityProfile = SecurityEntityUtility.CurrentProfile(); BNameValuePairs myNameValuePair = new BNameValuePairs(mSecurityProfile); CacheController.RemoveFromCache(CachedNameValuePairTableName); CacheController.RemoveFromCache(CachedNameValuePairDetailsTableName); mRetVal = myNameValuePair.Save(profile); return(mRetVal); }
protected void Page_Load(object sender, EventArgs e) { if (!String.IsNullOrEmpty(HttpContext.Current.Request.QueryString["NVP_SEQ_ID"])) { int mNameValuePairSeqID = int.Parse((HttpContext.Current.Request.QueryString["NVP_SEQ_ID"]).ToString()); if (mNameValuePairSeqID != -1) { m_NVPToUpdate = NameValuePairUtility.GetNameValuePair(mNameValuePairSeqID); } else { m_NVPToUpdate = new MNameValuePair(); } HttpContext.Current.Session.Add("EditId", m_NVPToUpdate.Id); } else { tdStatus.Style.Add("display", "none"); dropStatus.Style.Add("display", "none"); } populatePage(m_NVPToUpdate); }
private void populateRolesAndGroups(MNameValuePair profile) { int mSecurityEntityId = int.Parse(ClientChoicesState[MClientChoices.SecurityEntityId].ToString()); DataView mDVRoles = RoleUtility.GetAllRolesBySecurityEntity(mSecurityEntityId).DefaultView; DataView mDVGroups = GroupUtility.GetAllGroupsBySecurityEntity(mSecurityEntityId).DefaultView; try { ctlGroups.SelectedItems = NameValuePairUtility.GetSelectedGroups(m_NVPToUpdate.Id); ctlRoles.SelectedItems = NameValuePairUtility.GetSelectedRoles(m_NVPToUpdate.Id); } catch (Exception ex) { Logger mLog = Logger.Instance(); mLog.Debug(ex); } ctlGroups.DataSource = mDVGroups; ctlGroups.DataField = "Name"; ctlGroups.DataBind(); ctlRoles.DataSource = mDVRoles; ctlRoles.DataField = "Name"; ctlRoles.DataBind(); }
public IHttpActionResult SaveNameValuePair(UINVPProfile uiProfile) { string mRetVal = false.ToString(); MNameValuePair mProfile = new MNameValuePair(); String mAction = GWWebHelper.GetQueryValue(HttpContext.Current.Request, "Action"); int mEditId = int.Parse(HttpContext.Current.Items["EditId"].ToString()); Logger mLog = Logger.Instance(); if (mEditId != uiProfile.NVP_SEQ_ID) { Exception mError = new Exception("Identifier you have last looked at does not match the one passed in nothing has been saved!!!!"); mLog.Error(mError); return(this.InternalServerError(mError)); } MAccountProfile mUpdatingAccount = AccountUtility.CurrentProfile(); MSecurityEntityProfile mSecurityEntityProfile = SecurityEntityUtility.CurrentProfile(); MSecurityInfo mSecurityInfo = new MSecurityInfo(FunctionUtility.GetProfile(mAction), mUpdatingAccount); String mGroups = String.Join(",", uiProfile.Groups); String mRoles = String.Join(",", uiProfile.Roles); String mCommaSepRoles = mUpdatingAccount.GetCommaSeparatedAssignedRoles; if (uiProfile.NVP_SEQ_ID != -1) { if (!mSecurityInfo.MayAdd) { Exception mError = new Exception("The account (" + mUpdatingAccount.Account + ") being used does not have the correct permissions to add"); mLog.Error(mError); return(this.InternalServerError(mError)); } } else { if (!mSecurityInfo.MayAdd) { Exception mError = new Exception("The account (" + mUpdatingAccount.Account + ") being used does not have the correct permissions to edit"); mLog.Error(mError); return(this.InternalServerError(mError)); } } if (uiProfile.NVP_SEQ_ID != -1) { mProfile = NameValuePairUtility.GetNameValuePair(uiProfile.NVP_SEQ_ID); } else { mProfile.AddedBy = mUpdatingAccount.Id; mProfile.AddedDate = DateTime.Today; } mProfile.UpdatedBy = mUpdatingAccount.Id; mProfile.UpdatedDate = DateTime.Today; mProfile.StaticName = uiProfile.STATIC_NAME; mProfile.SchemaName = uiProfile.SchemaName; mProfile.Display = uiProfile.Display; mProfile.Description = uiProfile.Description; mProfile.Status = uiProfile.Status; int mID = NameValuePairUtility.Save(mProfile); int mSecurityId = mSecurityEntityProfile.Id; NameValuePairUtility.UpdateRoles(mID, mSecurityId, mRoles, mProfile); NameValuePairUtility.UpdateGroups(mID, mSecurityId, mGroups, mProfile); return(this.Ok(mRetVal)); }
private void populatePage(MNameValuePair profile) { populateGeneral(profile); populateRolesAndGroups(profile); }
void IDNameValuePair.UpdateGroups(int NVP_ID, int SecurityEntityID, string CommaSeparatedGroups, MNameValuePair nvpProfile) { string myStoreProcedure = "ZGWSecurity.Set_Name_Value_Pair_Groups"; SqlParameter[] mParameters = { new SqlParameter("@P_NVP_SeqID", NVP_ID), new SqlParameter("@P_Security_Entity_SeqID", SecurityEntityID), new SqlParameter("@P_Groups", CommaSeparatedGroups), new SqlParameter("@P_Permissions_NVP_Detail_SeqID", m_PermissionSeqId), new SqlParameter("@P_Added_Updated_By", GetAddedUpdatedBy(nvpProfile)) }; base.ExecuteNonQuery(myStoreProcedure, mParameters); }
/// <summary> /// Updates the roles. /// </summary> /// <param name="nameValuePairId">The NV p_ ID.</param> /// <param name="securityEntityId">The security entity ID.</param> /// <param name="commaSeparatedRoles">The comma separated roles.</param> /// <param name="nameValuePairProfile">MNameValuePair.</param> public static void UpdateRoles(int nameValuePairId, int securityEntityId, string commaSeparatedRoles, MNameValuePair nameValuePairProfile) { if (nameValuePairProfile == null) { throw new ArgumentNullException("nameValuePairProfile", "nameValuePairProfile cannot be a null reference (Nothing in Visual Basic)!"); } MSecurityEntityProfile mSecurityProfile = SecurityEntityUtility.CurrentProfile(); BNameValuePairs myNameValuePair = new BNameValuePairs(mSecurityProfile); myNameValuePair.UpdateRoles(nameValuePairId, securityEntityId, commaSeparatedRoles, nameValuePairProfile); }
/// <summary> /// Updates the roles. /// </summary> /// <param name="nameValuePairId">The NV p_ ID.</param> /// <param name="securityEntityId">The security entity ID.</param> /// <param name="commaSeparatedRoles">The comma separated roles.</param> /// <param name="nameValuePairProfile">MNameValuePair.</param> public void UpdateRoles(int nameValuePairId, int securityEntityId, string commaSeparatedRoles, MNameValuePair nameValuePairProfile) { if (DatabaseIsOnline()) { m_DNameValuePair.UpdateRoles(nameValuePairId, securityEntityId, commaSeparatedRoles, nameValuePairProfile); } }