// 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);
}
}
