// Method to active or inactive the user... private void MakeActiveorInactive(int userDeleteId) { SqlParameter[] parameters = new SqlParameter[15]; parameters[0] = new SqlParameter("@FirstName", ""); parameters[1] = new SqlParameter("@LastName", ""); parameters[2] = new SqlParameter("@UserName", ""); parameters[3] = new SqlParameter("@Password", ""); parameters[4] = new SqlParameter("@EmailId", ""); parameters[5] = new SqlParameter("@Status", 'D'); parameters[6] = new SqlParameter("@UpdatedBy", Session["UserID"]); parameters[7] = new SqlParameter("@UpdatedDate", DateTime.Now); parameters[8] = new SqlParameter("@CreatedBy", Session["UserID"]); parameters[9] = new SqlParameter("@Createddate", DateTime.Now); parameters[10] = new SqlParameter("@middleName", ""); parameters[11] = new SqlParameter("@userID", userDeleteId); parameters[12] = new SqlParameter("@IsActive", 1); parameters[13] = new SqlParameter("@UserRoleID", 1); parameters[14] = new SqlParameter("@EmployeeCode", ""); parameters[5].Direction = ParameterDirection.InputOutput; BaseDAL.ExecuteSPNonQuery("[UserOperations]", parameters); DisplayUserDetailsList(); // Method to Display User Details List... lbMessage.Text = PMOscar.Core.Constants.AddRole.STATUS; }
// Method to add the user details private string InsertUser(string FirstName, string LastName, string UserName, string Password, string EmailId, string MiddleName, int roleID, string EmpCode) { int radioButtonStatus = 0; if (RdActive.Checked == true) { radioButtonStatus = 1; } else { radioButtonStatus = 0; } string status = "I"; try { FirstName = FirstName.Replace("<script", "[script").Replace("</script>", "[/script]"); LastName = LastName.Replace("<script", "[script").Replace("</script>", "[/script]"); UserName = UserName.Replace("<script", "[script").Replace("</script>", "[/script]"); Password = PMOscar.BaseDAL.EncryptText(Password); EmailId = EmailId.Replace("<script", "[script").Replace("</script>", "[/script]"); MiddleName = MiddleName.Replace("<script", "[script").Replace("</script>", "[/script]"); SqlParameter[] parameters = new SqlParameter[15]; parameters[0] = new SqlParameter("@FirstName", FirstName); parameters[1] = new SqlParameter("@LastName", LastName); parameters[2] = new SqlParameter("@UserName", UserName); parameters[3] = new SqlParameter("@Password", Password); parameters[4] = new SqlParameter("@EmailId", EmailId); parameters[5] = new SqlParameter("@Status", status); parameters[6] = new SqlParameter("@UpdatedBy", Session["UserID"]); parameters[7] = new SqlParameter("@UpdatedDate", DateTime.Now); parameters[8] = new SqlParameter("@CreatedBy", Session["UserID"]); parameters[9] = new SqlParameter("@Createddate", DateTime.Now); parameters[10] = new SqlParameter("@middleName", MiddleName); parameters[11] = new SqlParameter("@userID", 1); parameters[12] = new SqlParameter("@IsActive", radioButtonStatus); parameters[13] = new SqlParameter("@UserRoleID", roleID); parameters[14] = new SqlParameter("@EmployeeCode", EmpCode); parameters[5].Direction = ParameterDirection.InputOutput; BaseDAL.ExecuteSPNonQuery("[UserOperations]", parameters); status = parameters[5].Value.ToString(); return(status); } catch (Exception ex) { return(status); throw ex; } }
// Method to update the user details private string UpdateUser(string FirstName, string LastName, string UserName, string EmailId, string pwd, string middlename, string employeecode) { userEditId = Convert.ToInt32(Request.QueryString["UserEditId"]); int radioButtonStatus = 0; if (rdActive.Checked == true) { radioButtonStatus = 1; } else { radioButtonStatus = 0; } string status = "U"; try { FirstName = FirstName.Replace("<script", "[script").Replace("</script>", "[/script]"); LastName = LastName.Replace("<script", "[script").Replace("</script>", "[/script]"); UserName = UserName.Replace("<script", "[script").Replace("</script>", "[/script]"); pwd = PMOscar.BaseDAL.EncryptText(pwd); EmailId = EmailId.Replace("<script", "[script").Replace("</script>", "[/script]"); middlename = middlename.Replace("<script", "[script").Replace("</script>", "[/script]"); employeecode = employeecode.Replace("<script", "[script").Replace("</script>", "[/script]"); SqlParameter[] parameters = new SqlParameter[15]; parameters[0] = new SqlParameter("@FirstName", FirstName); parameters[1] = new SqlParameter("@LastName", LastName); parameters[2] = new SqlParameter("@UserName", UserName); parameters[3] = new SqlParameter("@Password", pwd); parameters[4] = new SqlParameter("@EmailId", EmailId); parameters[5] = new SqlParameter("@Status", status); parameters[6] = new SqlParameter("@CreatedBy", Session["UserID"]); parameters[7] = new SqlParameter("@Createddate", DateTime.Now); parameters[8] = new SqlParameter("@UpdatedBy", Session["UserID"]); parameters[9] = new SqlParameter("@UpdatedDate", DateTime.Now); parameters[10] = new SqlParameter("@middleName", middlename); parameters[11] = new SqlParameter("@userID", userEditId); parameters[12] = new SqlParameter("@IsActive", radioButtonStatus); parameters[13] = new SqlParameter("@UserRoleID", Convert.ToInt32(ddlRole.SelectedValue.ToString())); if (employeecode != null) { parameters[14] = new SqlParameter("@EmployeeCode", employeecode); } else { parameters[14] = new SqlParameter("@EmployeeCode", ""); } parameters[5].Direction = ParameterDirection.InputOutput; BaseDAL.ExecuteSPNonQuery("[UserOperations]", parameters); status = parameters[5].Value.ToString(); return(status); } catch (Exception ex) { //Log.Write("Error in user Creation:" + Environment.NewLine + ex.StackTrace + ex.InnerException, ex); return(status); } }