public static bool CreatePortalUser(UserInfo obj, out UserCreationStatus status, UserCreationMode mode)
{
string sp = "[dbo].[usp_sf_CreateUser]";
try
{
List<KeyValuePair<string, object>> ParamCollInput = new List<KeyValuePair<string, object>>();
ParamCollInput.Add(new KeyValuePair<string, object>("@ApplicationName", obj.ApplicationName));
ParamCollInput.Add(new KeyValuePair<string, object>("@UserName", obj.UserName));
ParamCollInput.Add(new KeyValuePair<string, object>("@FirstName", obj.FirstName));
ParamCollInput.Add(new KeyValuePair<string, object>("@LastName", obj.LastName));
ParamCollInput.Add(new KeyValuePair<string, object>("@Password", obj.Password));
ParamCollInput.Add(new KeyValuePair<string, object>("@PasswordSalt", obj.PasswordSalt));
ParamCollInput.Add(new KeyValuePair<string, object>("@Email", obj.Email));
ParamCollInput.Add(new KeyValuePair<string, object>("@PasswordQuestion", obj.SecurityQuestion));
ParamCollInput.Add(new KeyValuePair<string, object>("@PasswordAnswer", obj.SecurityAnswer));
ParamCollInput.Add(new KeyValuePair<string, object>("@IsApproved", obj.IsApproved));
ParamCollInput.Add(new KeyValuePair<string, object>("@CurrentTimeUtc", obj.CurrentTimeUtc));
ParamCollInput.Add(new KeyValuePair<string, object>("@CreateDate", obj.CreatedDate));
ParamCollInput.Add(new KeyValuePair<string, object>("@UniqueEmail", obj.UniqueEmail));
ParamCollInput.Add(new KeyValuePair<string, object>("@PasswordFormat", obj.PasswordFormat));
ParamCollInput.Add(new KeyValuePair<string, object>("@PortalID", obj.PortalID));
ParamCollInput.Add(new KeyValuePair<string, object>("@AddedOn", obj.AddedOn));
ParamCollInput.Add(new KeyValuePair<string, object>("@AddedBy", obj.AddedBy));
ParamCollInput.Add(new KeyValuePair<string, object>("@RoleNames", obj.RoleNames));
ParamCollInput.Add(new KeyValuePair<string, object>("@StoreID", obj.StoreID));
List<KeyValuePair<string, object>> ParamCollOutput = new List<KeyValuePair<string, object>>();
ParamCollOutput.Add(new KeyValuePair<string, object>("@UserId", obj.UserID));
ParamCollOutput.Add(new KeyValuePair<string, object>("@ErrorCode", 0));
ParamCollOutput.Add(new KeyValuePair<string, object>("@CustomerID", obj.CustomerID));
SageFrameSQLHelper sagesql = new SageFrameSQLHelper();
List<KeyValuePair<int, string>> OutputValColl = new List<KeyValuePair<int, string>>();
OutputValColl = sagesql.ExecuteNonQueryWithMultipleOutput(sp, ParamCollInput, ParamCollOutput);
int CustomerID = int.Parse(OutputValColl[2].Value);
int ErrorCode = int.Parse(OutputValColl[1].Value);
Guid UserID = new Guid(OutputValColl[0].Value.ToString());
switch (ErrorCode)
{
case 3:
status = UserCreationStatus.DUPLICATE_EMAIL;
break;
case 6:
status = UserCreationStatus.DUPLICATE_USER;
break;
default:
status = UserCreationStatus.SUCCESS;
break;
}
return true;
}
catch (Exception)
{
throw;
}
}
public bool ChangePassword(AspxCommonInfo aspxCommonObj, string newPassword, string retypePassword)
{
MembershipController m = new MembershipController();
try
{
if (newPassword != "" && retypePassword != "" && newPassword == retypePassword && aspxCommonObj.UserName != "")
{
UserInfo sageUser = m.GetUserDetails(aspxCommonObj.PortalID, aspxCommonObj.UserName);
// Guid userID = (Guid)member.ProviderUserKey;
string password, passwordSalt;
PasswordHelper.EnforcePasswordSecurity(m.PasswordFormat, newPassword, out password, out passwordSalt);
UserInfo user = new UserInfo(sageUser.UserID, password, passwordSalt, m.PasswordFormat);
m.ChangePassword(user);
return true;
}
else
{
return false;
}
}
catch (Exception ex)
{
throw ex;
}
}
public abstract bool ChangePassword(UserInfo user);
protected void imbCreateUser_Click(object sender, ImageClickEventArgs e)
{
try
{
if (txtUserName.Text != "" && txtSecurityQuestion.Text != "" && txtSecurityAnswer.Text != "" && txtFirstName.Text != "" && txtLastName.Text != "" && txtEmail.Text != "")
{
if (lstAvailableRoles.SelectedIndex > -1)
{
UserInfo objUser = new UserInfo();
objUser.ApplicationName = Membership.ApplicationName;
objUser.FirstName = txtFirstName.Text;
objUser.UserName = txtUserName.Text;
objUser.LastName = txtLastName.Text;
string Password, PasswordSalt;
PasswordHelper.EnforcePasswordSecurity(m.PasswordFormat, txtPassword.Text, out Password, out PasswordSalt);
objUser.Password = Password;
objUser.PasswordSalt = PasswordSalt;
objUser.Email = txtEmail.Text;
objUser.SecurityQuestion = txtSecurityQuestion.Text;
objUser.SecurityAnswer = txtSecurityAnswer.Text;
objUser.IsApproved = true;
objUser.CurrentTimeUtc = DateTime.Now;
objUser.CreatedDate = DateTime.Now;
objUser.UniqueEmail = 0;
objUser.PasswordFormat = m.PasswordFormat;
objUser.PortalID = GetPortalID;
objUser.AddedOn = DateTime.Now;
objUser.AddedBy = GetUsername;
objUser.UserID = Guid.NewGuid();
objUser.RoleNames = GetSelectedRoleNameString();
objUser.StoreID = GetStoreID;
objUser.CustomerID = 0;
UserCreationStatus status = new UserCreationStatus();
try
{
MembershipDataProvider.CreatePortalUser(objUser, out status, UserCreationMode.CREATE);
if (status == UserCreationStatus.DUPLICATE_USER)
{
ShowMessage(SageMessageTitle.Notification.ToString(), GetSageMessage("UserManagement", "NameAlreadyExists"), "", SageMessageType.Alert);
}
else if (status == UserCreationStatus.DUPLICATE_EMAIL)
{
ShowMessage(SageMessageTitle.Notification.ToString(), GetSageMessage("UserManagement", "EmailAddressAlreadyIsInUse"), "", SageMessageType.Alert);
}
else if (status == UserCreationStatus.SUCCESS)
{
PanelVisibility(false, true, false);
BindUsers(string.Empty);
ShowMessage(SageMessageTitle.Notification.ToString(), GetSageMessage("UserManagement", "UserCreatedSuccessfully"), "", SageMessageType.Success);
}
}
catch (Exception)
{
throw;
}
}
else
{
ShowMessage(SageMessageTitle.Notification.ToString(), GetSageMessage("UserManagement", "PleaseSelectRole"), "", SageMessageType.Alert);
}
}
else
{
ShowMessage(SageMessageTitle.Notification.ToString(), GetSageMessage("UserManagement", "PleaseEnterAllRequiredFields"), "", SageMessageType.Alert);
}
}
catch (Exception ex)
{
ProcessException(ex);
}
}
protected void imgManageRoleSave_Click(object sender, EventArgs e)
{
try
{
string unselectedRoles = GetListBoxText(lstUnselectedRoles);
string selectedRoles = GetListBoxText(lstSelectedRoles);
if (hdnEditUsername.Value != "")
{
string userRoles = role.GetRoleNames(hdnEditUsername.Value, GetPortalID);
string[] arrRoles = userRoles.Split(',');
UserInfo user = new UserInfo(Membership.ApplicationName, new Guid(hdnEditUserID.Value), userRoles, GetPortalID);
if (arrRoles.Length > 0 && selectedRoles.Length > 0)
{
role.ChangeUserInRoles(Membership.ApplicationName, new Guid(hdnEditUserID.Value), userRoles, selectedRoles, GetPortalID);
ShowMessage(SageMessageTitle.Information.ToString(), GetSageMessage("UserManagement", "UserRolesUpdatedSuccessfully"), "", SageMessageType.Success);
}
}
}
catch (Exception ex)
{
ProcessException(ex);
ShowMessage(SageMessageTitle.Information.ToString(), GetSageMessage("UserManagement", "UnknownErrorOccur"), "", SageMessageType.Error);
}
}
protected void imgUserInfoSave_Click(object sender, EventArgs e)
{
try
{
if (hdnEditUsername.Value != "")
{
if (txtManageFirstName.Text != "" && txtManageLastName.Text != "" && txtManageEmail.Text != "")
{
MembershipUser member = Membership.GetUser(hdnEditUsername.Value);
member.Email = txtManageEmail.Text;
if (!EmailAddressExists(txtManageEmail.Text,m.RequireUniqueEmail))
{
UserInfo user = new UserInfo(Membership.ApplicationName, hdnEditUsername.Value,new Guid(hdnEditUserID.Value), txtManageFirstName.Text,txtManageLastName.Text, txtManageEmail.Text, GetPortalID,chkIsActive.Checked, GetUsername, GetStoreID);
UserUpdateStatus status=new UserUpdateStatus();
m.UpdateUser(user, out status);
if (status == UserUpdateStatus.DUPLICATE_EMAIL_NOT_ALLOWED)
{
ShowMessage(SageMessageTitle.Notification.ToString(), GetSageMessage("UserManagement", "EmailAddressAlreadyIsInUse"), "", SageMessageType.Alert);
}
else if (status == UserUpdateStatus.USER_UPDATE_SUCCESSFUL)
{
BindUsers(string.Empty);
if(user.IsActive)
{
SendActivateMail(user);
}
ShowMessage(SageMessageTitle.Notification.ToString(),GetSageMessage("UserManagement", "UserInformationSaveSuccessfully"), "",SageMessageType.Success);
}
}
else
{
ShowMessage(SageMessageTitle.Notification.ToString(), GetSageMessage("UserManagement", "EmailAddressAlreadyIsInUse"), "", SageMessageType.Alert);
}
}
else
{
ShowMessage(SageMessageTitle.Notification.ToString(), GetSageMessage("UserManagement", "PleaseEnterTheRequiredFields"), "", SageMessageType.Alert);
}
}
}
catch (Exception ex)
{
ProcessException(ex);
}
}
public static bool ChangePassword(UserInfo obj)
{
string sp = "[dbo].[usp_sf_ResetPassword]";
SageFrameSQLHelper sagesql = new SageFrameSQLHelper();
try
{
List<KeyValuePair<string, object>> ParamCollInput = new List<KeyValuePair<string, object>>();
ParamCollInput.Add(new KeyValuePair<string, object>("@UserID", obj.UserID));
ParamCollInput.Add(new KeyValuePair<string, object>("@NewPassword", obj.Password));
ParamCollInput.Add(new KeyValuePair<string, object>("@PasswordSalt", obj.PasswordSalt));
ParamCollInput.Add(new KeyValuePair<string, object>("@PasswordFormat", obj.PasswordFormat));
sagesql.ExecuteNonQuery(sp, ParamCollInput);
return true;
}
catch (Exception)
{
throw;
}
}
public static bool AddUserInRoles(UserInfo obj)
{
string sp = "[dbo].[usp_sf_UserInRolesAdd]";
SageFrameSQLHelper sagesql = new SageFrameSQLHelper();
try
{
List<KeyValuePair<string, object>> ParamCollInput = new List<KeyValuePair<string, object>>();
ParamCollInput.Add(new KeyValuePair<string, object>("@ApplicationName", obj.ApplicationName));
ParamCollInput.Add(new KeyValuePair<string, object>("@UserID", obj.UserID));
ParamCollInput.Add(new KeyValuePair<string, object>("@RoleNames", obj.RoleNames));
ParamCollInput.Add(new KeyValuePair<string, object>("@PortalID", obj.PortalID));
sagesql.ExecuteNonQuery(sp, ParamCollInput);
return true;
}
catch (Exception)
{
throw;
}
}
public static bool DeleteUser(UserInfo user)
{
string sp = "[dbo].[usp_UsersDelete]";
SQLHandler sagesql = new SQLHandler();
try
{
List<KeyValuePair<string, object>> ParamCollInput = new List<KeyValuePair<string, object>>();
ParamCollInput.Add(new KeyValuePair<string, object>("@ApplicationName", user.ApplicationName));
ParamCollInput.Add(new KeyValuePair<string, object>("@Username", user.UserName));
ParamCollInput.Add(new KeyValuePair<string, object>("@PortalID", user.PortalID));
ParamCollInput.Add(new KeyValuePair<string, object>("@StoreID", user.StoreID));
ParamCollInput.Add(new KeyValuePair<string, object>("@DeletedBy", user.AddedBy));
sagesql.ExecuteNonQuery(sp, ParamCollInput);
return true;
}
catch (Exception)
{
throw;
}
}
protected void wzdPasswordRecover_NextButtonClick(object sender, WizardNavigationEventArgs e)
{
try
{
MessageTemplateDataContext dbMessageTemplate = new MessageTemplateDataContext(SystemSetting.SageFrameConnectionString);
if (txtPassword.Text != null && txtRetypePassword.Text != "" && txtRetypePassword.Text == txtPassword.Text)
{
if (txtPassword.Text.Length < 4)
{
ShowMessage(SageMessageTitle.Notification.ToString(), GetSageMessage("PasswordRecovery", "PasswordLength"), "", SageMessageType.Alert);
e.Cancel = true;
}
else
{
if (hdnRecoveryCode.Value != "")
{
UserManagementDataContext dbUser = new UserManagementDataContext(SystemSetting.SageFrameConnectionString);
var sageframeuser = dbUser.sp_GetUsernameByActivationOrRecoveryCode(hdnRecoveryCode.Value, GetPortalID).SingleOrDefault();
if (sageframeuser != null)
{
MembershipController m = new MembershipController();
UserInfo sageUser = m.GetUserDetails(GetPortalID, sageframeuser.CodeForUsername);
//MembershipUser user = Membership.GetUser(sageframeuser.CodeForUsername);
string Password, PasswordSalt;
PasswordHelper.EnforcePasswordSecurity(m.PasswordFormat, txtPassword.Text, out Password, out PasswordSalt);
UserInfo user1 = new UserInfo(sageUser.UserID, Password, PasswordSalt, m.PasswordFormat);
m.ChangePassword(user1);
//string oldPassword = user.ResetPassword();
//user.ChangePassword(oldPassword, txtPassword.Text);
var template = dbMessageTemplate.sp_MessageTemplateByMessageTemplateTypeID(SystemSetting.PASSWORD_RECOVERED_SUCESSFUL_INFORMATION, GetPortalID).SingleOrDefault();
if (template != null)
{
((Literal)WizardStep2.FindControl("litPasswordChangedSuccessful")).Text = template.Body;
}
var messageTemplates = dbMessageTemplate.sp_MessageTemplateByMessageTemplateTypeID(SystemSetting.PASSWORD_RECOVERED_SUCCESSFUL_EMAIL, GetPortalID);
foreach (var messageTemplate in messageTemplates)
{
MessageTokenDataContext messageTokenDB = new MessageTokenDataContext(SystemSetting.SageFrameConnectionString);
var messageTokenValues = messageTokenDB.sp_GetPasswordRecoverySuccessfulTokenValue(sageUser.UserName, GetPortalID);
CommonFunction comm = new CommonFunction();
DataTable dtTokenValues = comm.LINQToDataTable(messageTokenValues);
string replacedMessageSubject = MessageToken.ReplaceAllMessageToken(messageTemplate.Subject, dtTokenValues);
string replacedMessageTemplate = MessageToken.ReplaceAllMessageToken(messageTemplate.Body, dtTokenValues);
MailHelper.SendMailNoAttachment(messageTemplate.MailFrom, sageUser.Email, replacedMessageSubject, replacedMessageTemplate, string.Empty, string.Empty);
}
}
else
{
var template = dbMessageTemplate.sp_MessageTemplateByMessageTemplateTypeID(SystemSetting.PASSWORD_RECOVERED_SUCESSFUL_INFORMATION, GetPortalID).SingleOrDefault();
if (template != null)
{
((Literal)WizardStep2.FindControl("litPasswordChangedSuccessful")).Text = template.Body;
}
e.Cancel = true;
ShowMessage(SageMessageTitle.Notification.ToString(), GetSageMessage("PasswordRecovery", "UnknownErrorPleaseTryAgaing"), "", SageMessageType.Alert);
}
}
else
{
var template = dbMessageTemplate.sp_MessageTemplateByMessageTemplateTypeID(SystemSetting.PASSWORD_RECOVERED_SUCESSFUL_INFORMATION, GetPortalID).SingleOrDefault();
if (template != null)
{
((Literal)WizardStep2.FindControl("litPasswordChangedSuccessful")).Text = template.Body;
}
e.Cancel = true;
ShowMessage(SageMessageTitle.Notification.ToString(), GetSageMessage("PasswordRecovery", "UnknownError"), "", SageMessageType.Alert);
}
}
}
else
{
ShowMessage(SageMessageTitle.Notification.ToString(), GetSageMessage("PasswordRecovery", "PleaseEnterAllRequiredFields"), "", SageMessageType.Alert);
e.Cancel = true;
}
}
catch (Exception ex)
{
ProcessException(ex);
}
}
private void CheckRegistrationType(int UserRegistrationType, ref UserInfo user)
{
switch (UserRegistrationType)
{
case 0:
break;
case 1:
user.IsApproved = false;
break;
case 2:
user.IsApproved = true;
break;
case 3:
user.IsApproved = false;
break;
}
}
private void RegisterUser()
{
try
{
if (string.IsNullOrEmpty(UserName.Text) || string.IsNullOrEmpty(FirstName.Text) || string.IsNullOrEmpty(LastName.Text) || string.IsNullOrEmpty(Email.Text) || string.IsNullOrEmpty(Password.Text) || string.IsNullOrEmpty(ConfirmPassword.Text) || string.IsNullOrEmpty(CaptchaValue.Text))
{
ShowMessage("", GetSageMessage("UserRegistration", "PleaseEnterAllRequiredFields"), "", SageMessageType.Alert);
}
else if (UserName.Text.Length > 50)
{
ShowMessage("", "Username should not be greater than 50 characters", "", SageMessageType.Alert);
}
else
{
int UserRegistrationType = pagebase.GetSettingIntValueByIndividualKey(SageFrameSettingKeys.PortalUserRegistration);
bool isUserActive = UserRegistrationType == 2 ? true : false;
UserInfo objUser = new UserInfo();
objUser.ApplicationName = Membership.ApplicationName;
objUser.FirstName = Server.HtmlEncode(FirstName.Text);
objUser.UserName = Server.HtmlEncode(UserName.Text);
objUser.LastName = Server.HtmlEncode(LastName.Text);
string Pwd, PasswordSalt;
PasswordHelper.EnforcePasswordSecurity(_member.PasswordFormat, Password.Text, out Pwd, out PasswordSalt);
objUser.Password = Pwd;
objUser.PasswordSalt = PasswordSalt;
objUser.Email = Email.Text;
objUser.SecurityQuestion = " ";
objUser.SecurityAnswer = " ";
objUser.IsApproved = true;
objUser.CurrentTimeUtc = DateTime.Now;
objUser.CreatedDate = DateTime.Now;
objUser.UniqueEmail = 0;
objUser.PasswordFormat = _member.PasswordFormat;
objUser.PortalID = GetPortalID;
objUser.AddedOn = DateTime.Now;
objUser.AddedBy = GetUsername;
objUser.UserID = Guid.NewGuid();
objUser.RoleNames = SystemSetting.REGISTER_USER_ROLENAME;
objUser.StoreID = GetStoreID;
objUser.CustomerID = 0;
UserCreationStatus status = new UserCreationStatus();
CheckRegistrationType(UserRegistrationType, ref objUser);
MembershipDataProvider.CreatePortalUser(objUser, out status, UserCreationMode.REGISTER);
if (status == UserCreationStatus.DUPLICATE_USER)
{
ShowMessage("", GetSageMessage("UserManagement", "NameAlreadyExists"), "", SageMessageType.Alert);
GenerateCaptchaImage();
}
else if (status == UserCreationStatus.DUPLICATE_EMAIL)
{
ShowMessage("", GetSageMessage("UserManagement", "EmailAddressAlreadyIsInUse"), "", SageMessageType.Alert);
GenerateCaptchaImage();
}
else if (status == UserCreationStatus.SUCCESS)
{
try
{
IsModuleInstalled(1);
MembershipUser userInfo = Membership.GetUser(UserName.Text.Trim());
if (chkIsSubscribeNewsLetter.Checked)
{
int? newID = 0;
ManageNewsLetterSubscription(Email.Text, ref newID);
IsModuleInstalled(2);
}
HandlePostRegistration(UserRegistrationType);
}
catch (Exception)
{
ShowMessage("", GetSageMessage("UserManagement", "SecureConnection"), "", SageMessageType.Alert);
}
}
}
}
catch (Exception ex)
{
ProcessException(ex);
}
}
public abstract bool DeleteUserInRoles(UserInfo user);
public abstract void RemoveUserFromRole(int PortalID, UserInfo user, UserRoleInfo userRole);
public abstract bool AddUserToRoles(UserInfo user);
public abstract bool AddUserToRole(int PortalID, UserInfo user, UserRoleInfo UserRole);
public static SageFrameUserCollection SearchUsers(string RoleID, string SearchText, int PortalID, string UserName)
{
string sp = "[dbo].[usp_SageFrameUserListSearch]";
SageFrameSQLHelper sagesql = new SageFrameSQLHelper();
SageFrameUserCollection userColl = new SageFrameUserCollection();
List<UserInfo> lstUsers = new List<UserInfo>();
List<KeyValuePair<string, object>> ParamCollInput = new List<KeyValuePair<string, object>>();
ParamCollInput.Add(new KeyValuePair<string, object>("@RoleID", RoleID));
ParamCollInput.Add(new KeyValuePair<string, object>("@SearchText", SearchText));
ParamCollInput.Add(new KeyValuePair<string, object>("@PortalID", PortalID));
ParamCollInput.Add(new KeyValuePair<string, object>("@Username", UserName));
try
{
SqlDataReader reader;
reader = sagesql.ExecuteAsDataReader(sp, ParamCollInput);
while (reader.Read())
{
UserInfo obj = new UserInfo();
obj.UserID = new Guid(reader["userid"].ToString());
obj.UserName = reader["username"].ToString();
obj.FirstName = reader["firstname"].ToString();
obj.LastName = reader["lastname"].ToString();
obj.Email = reader["email"].ToString();
obj.IsActive = bool.Parse(reader["IsActive"].ToString());
lstUsers.Add(obj);
}
reader.Close();
userColl.UserList = lstUsers;
return userColl;
}
catch (Exception ex)
{
throw (ex);
}
}
/// <summary>
/// Assigne role to user.
/// </summary>
/// <param name="PortalID">PortalID</param>
/// <param name="user">Object of UserInfo class.</param>
/// <param name="UserRole">Object of UserRoleInfo class.</param>
/// <returns>True for assigne role to user successfully.</returns>
public override bool AddUserToRole(int PortalID, UserInfo user, UserRoleInfo UserRole)
{
throw new NotImplementedException();
}
public static UserInfo GetUserDetails(string UserName, int PortalID)
{
string sp = "[dbo].[usp_GetUserDetails]";
SQLHandler sagesql = new SQLHandler();
List<KeyValuePair<string, object>> ParamCollInput = new List<KeyValuePair<string, object>>();
ParamCollInput.Add(new KeyValuePair<string, object>("@UserName", UserName));
ParamCollInput.Add(new KeyValuePair<string, object>("@PortalID", PortalID));
List<UserInfo> lstUser = new List<UserInfo>();
try
{
SqlDataReader reader;
reader = sagesql.ExecuteAsDataReader(sp, ParamCollInput);
while (reader.Read())
{
UserInfo obj = new UserInfo();
obj.UserID = new Guid(reader["userid"].ToString());
obj.UserName = reader["Username"].ToString();
obj.Password = reader["Password"].ToString();
obj.PasswordSalt = reader["PasswordSalt"].ToString();
obj.PasswordFormat = int.Parse(reader["PasswordFormat"].ToString());
obj.FirstName = reader["FirstName"].ToString();
obj.LastName = reader["LastName"].ToString();
obj.Email = reader["Email"].ToString();
obj.LastPasswordChangeDate = DateTime.Parse(reader["LastPasswordChangedDate"].ToString());
obj.LastActivityDate = DateTime.Parse(reader["LastActivityDate"].ToString());
obj.LastLoginDate = DateTime.Parse(reader["LastLoginDate"].ToString());
obj.IsApproved = bool.Parse(reader["IsApproved"].ToString());
obj.UserExists = true;
lstUser.Add(obj);
}
reader.Close();
UserInfo userObj = lstUser.Count > 0 ? lstUser[0] : new UserInfo(false);
return userObj;
}
catch (Exception ex)
{
throw (ex);
}
}
/// <summary>
/// Remove user from application role.
/// </summary>
/// <param name="PortalID">PortalID</param>
/// <param name="user">User name.</param>
/// <param name="userRole">User role.</param>
public override void RemoveUserFromRole(int PortalID, UserInfo user, UserRoleInfo userRole)
{
throw new NotImplementedException();
}
public static bool DeleteUserInRoles(UserInfo obj)
{
string sp = "[dbo].[usp_sf_UserInRolesDelete]";
SageFrameSQLHelper sagesql = new SageFrameSQLHelper();
try
{
List<KeyValuePair<string, object>> ParamCollInput = new List<KeyValuePair<string, object>>();
ParamCollInput.Add(new KeyValuePair<string, object>("@ApplicationName", obj.ApplicationName));
ParamCollInput.Add(new KeyValuePair<string, object>("@UserID", obj.UserID));
ParamCollInput.Add(new KeyValuePair<string, object>("@RoleNames", obj.RoleNames));
ParamCollInput.Add(new KeyValuePair<string, object>("@PortalID", obj.PortalID));
List<KeyValuePair<string, object>> ParamCollOutput = new List<KeyValuePair<string, object>>();
ParamCollOutput.Add(new KeyValuePair<string, object>("@ErrorCode", 0));
List<KeyValuePair<int, string>> OutPutColl = new List<KeyValuePair<int, string>>();
OutPutColl = sagesql.ExecuteNonQueryWithMultipleOutput(sp, ParamCollInput, ParamCollOutput);
return true;
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// Delete user from roles.
/// </summary>
/// <param name="user">Object of UserInfo class.</param>
/// <returns>True for deleted successfully.</returns>
public override bool DeleteUserInRoles(UserInfo user)
{
return (MembershipDataProvider.DeleteUserInRoles(user));
}
protected void gdvUser_RowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
int rownum = Convert.ToInt32(e.CommandArgument);
string username = gdvUser.DataKeys[rownum]["Username"].ToString();
string userId = gdvUser.DataKeys[rownum]["UserId"].ToString();
hdnEditUsername.Value = username;
hdnEditUserID.Value = userId;
switch (e.CommandName)
{
case "EditUser":
string[] userRoles = Roles.GetRolesForUser(username);
UserInfo sageUser = m.GetUserDetails(GetPortalID, hdnEditUsername.Value);
hdnCurrentEmail.Value = sageUser.Email;
txtManageEmail.Text = sageUser.Email;
txtManageFirstName.Text = sageUser.FirstName;
txtManageLastName.Text = sageUser.LastName;
txtManageUsername.Text = sageUser.UserName;
chkIsActive.Checked = sageUser.IsApproved == true ? true : false;
if (SystemSetting.SYSTEM_USERS.Contains(hdnEditUsername.Value) || hdnEditUsername.Value == GetUsername)
{
chkIsActive.Enabled = false;
chkIsActive.Attributes.Add("class", "disabledClass");
}
txtCreatedDate.Text = sageUser.AddedOn.ToString();
txtLastActivity.Text = sageUser.LastActivityDate.ToShortDateString();
txtLastLoginDate.Text = sageUser.LastLoginDate.ToShortDateString();
txtLastPasswordChanged.Text = sageUser.LastPasswordChangeDate.ToShortDateString();
lstSelectedRoles.Items.Clear();
lstUnselectedRoles.Items.Clear();
RolesManagementDataContext dbRoles = new RolesManagementDataContext(SystemSetting.SageFrameConnectionString);
var roles = dbRoles.sp_PortalRoleList(GetPortalID, false, GetUsername);
foreach (var role in roles)
{
string roleName = role.RoleName;
if (SystemSetting.SYSTEM_ROLES.Contains(roleName, StringComparer.OrdinalIgnoreCase))
{
if (userRoles.Contains(roleName, StringComparer.OrdinalIgnoreCase))
{
lstSelectedRoles.Items.Add(new ListItem(roleName, roleName));
}
else
{
lstUnselectedRoles.Items.Add(new ListItem(roleName, roleName));
}
}
else
{
if (userRoles.Contains(roleName, StringComparer.OrdinalIgnoreCase))
{
string rolePrefix = GetPortalSEOName + "_";
roleName = roleName.Replace(rolePrefix, "");
lstSelectedRoles.Items.Add(new ListItem(roleName, roleName));
}
else
{
string rolePrefix = GetPortalSEOName + "_";
roleName = roleName.Replace(rolePrefix, "");
lstUnselectedRoles.Items.Add(new ListItem(roleName, roleName));
}
}
}
PanelVisibility(false, false, true);
userProfile1.EditUserName = hdnEditUsername.Value;
break;
case "DeleteUser":
if (hdnEditUsername.Value != "")
{
UserInfo user = new UserInfo(hdnEditUsername.Value, GetPortalID, Membership.ApplicationName, GetUsername, GetStoreID);
m.DeleteUser(user);
ShowMessage(SageMessageTitle.Information.ToString(), GetSageMessage("UserManagement", "UserDeletedSuccessfully"), "", SageMessageType.Success);
BindUsers(string.Empty);
}
else
{
ShowMessage(SageMessageTitle.Notification.ToString(), GetSageMessage("UserManagement", "SelectDeleteButtonOnceAgain"), "", SageMessageType.Alert);
}
break;
}
}
catch (Exception ex)
{
ProcessException(ex);
}
}
/// <summary>
/// Add user in role.
/// </summary>
/// <param name="user">Object of UserInfo class.</param>
/// <returns>True for add user in role successfully.</returns>
public override bool AddUserToRoles(UserInfo user)
{
return (MembershipDataProvider.AddUserInRoles(user));
}
private void SendActivateMail(UserInfo user)
{
var dbMessageTemplate = new MessageTemplateDataContext(SystemSetting.SageFrameConnectionString);
MessageTokenDataContext messageTokenDB = new MessageTokenDataContext(SystemSetting.SageFrameConnectionString);
var messageTemplates = dbMessageTemplate.sp_MessageTemplateByMessageTemplateTypeID(SystemSetting.ACTIVATION_SUCCESSFUL_EMAIL, GetPortalID);
foreach (var messageTemplate in messageTemplates)
{
var linqActivationTokenValues = messageTokenDB.sp_GetActivationSuccessfulTokenValue(user.UserName, GetPortalID);
CommonFunction comm = new CommonFunction();
DataTable dtActivationSuccessfulTokenValues = comm.LINQToDataTable(linqActivationTokenValues);
string replaceMessageSubject = MessageToken.ReplaceAllMessageToken(messageTemplate.Subject, dtActivationSuccessfulTokenValues);
string replacedMessageTemplate = MessageToken.ReplaceAllMessageToken(messageTemplate.Body, dtActivationSuccessfulTokenValues);
try
{
MailHelper.SendMailNoAttachment(messageTemplate.MailFrom, user.Email, replaceMessageSubject, replacedMessageTemplate, string.Empty, string.Empty);
}
catch (Exception)
{
ShowMessage("", GetSageMessage("UserRegistration", "SecureConnectionUAEmailError"), "", SageMessageType.Alert);
return;
}
}
}
public static bool UpdateUser(UserInfo obj, out UserUpdateStatus status)
{
string sp = "[dbo].[usp_sf_UsersUpdate]";
try
{
List<KeyValuePair<string, object>> ParamCollInput = new List<KeyValuePair<string, object>>();
ParamCollInput.Add(new KeyValuePair<string, object>("@ApplicationName", obj.ApplicationName));
ParamCollInput.Add(new KeyValuePair<string, object>("@UserName", obj.UserName));
ParamCollInput.Add(new KeyValuePair<string, object>("@UserID", obj.UserID));
ParamCollInput.Add(new KeyValuePair<string, object>("@FirstName", obj.FirstName));
ParamCollInput.Add(new KeyValuePair<string, object>("@LastName", obj.LastName));
ParamCollInput.Add(new KeyValuePair<string, object>("@Email", obj.Email));
ParamCollInput.Add(new KeyValuePair<string, object>("@PortalID", obj.PortalID));
ParamCollInput.Add(new KeyValuePair<string, object>("@IsApproved", obj.IsApproved));
ParamCollInput.Add(new KeyValuePair<string, object>("@UpdatedBy", obj.UpdatedBy));
ParamCollInput.Add(new KeyValuePair<string, object>("@StoreID", obj.StoreID));
List<KeyValuePair<string, object>> ParamCollOutput = new List<KeyValuePair<string, object>>();
ParamCollOutput.Add(new KeyValuePair<string, object>("@ErrorCode", 0));
SageFrameSQLHelper sagesql = new SageFrameSQLHelper();
List<KeyValuePair<int, string>> OutputValColl = new List<KeyValuePair<int, string>>();
OutputValColl = sagesql.ExecuteNonQueryWithMultipleOutput(sp, ParamCollInput, ParamCollOutput);
int ErrorCode = int.Parse(OutputValColl[0].Value);
switch (ErrorCode)
{
case 1:
status = UserUpdateStatus.DUPLICATE_EMAIL_NOT_ALLOWED;
break;
default:
status = UserUpdateStatus.USER_UPDATE_SUCCESSFUL;
break;
}
return true;
}
catch (Exception)
{
throw;
}
}
protected void btnManagePasswordSave_Click(object sender, EventArgs e)
{
try
{
if (txtNewPassword.Text != "" && txtRetypeNewPassword.Text != "" && txtNewPassword.Text == txtRetypeNewPassword.Text && hdnEditUsername.Value != "")
{
MembershipUser member = Membership.GetUser(hdnEditUsername.Value);
string Password, PasswordSalt;
PasswordHelper.EnforcePasswordSecurity(m.PasswordFormat, txtNewPassword.Text, out Password, out PasswordSalt);
UserInfo user = new UserInfo(new Guid(hdnEditUserID.Value), Password, PasswordSalt,m.PasswordFormat);
m.ChangePassword(user);
ShowMessage(SageMessageTitle.Information.ToString(), GetSageMessage("UserManagement", "UserPasswordChangedSuccessfully"), "", SageMessageType.Success);
}
else
{
ShowMessage(SageMessageTitle.Notification.ToString(), GetSageMessage("UserManagement", "PleaseEnterTheRequiredField"), "", SageMessageType.Alert);
}
}
catch (Exception ex)
{
ProcessException(ex);
}
}
public static List<UserInfo> GetPortalUsers(int PortalID)
{
string sp = "[dbo].[usp_PortalUserListGet]";
SQLHandler sagesql = new SQLHandler();
List<KeyValuePair<string, object>> ParamCollInput = new List<KeyValuePair<string, object>>();
ParamCollInput.Add(new KeyValuePair<string, object>("@PortalID", PortalID));
List<UserInfo> lstUsers = new List<UserInfo>();
try
{
SqlDataReader reader;
reader = sagesql.ExecuteAsDataReader(sp, ParamCollInput);
while (reader.Read())
{
UserInfo obj = new UserInfo();
obj.UserID = new Guid(reader["UserID"].ToString());
obj.UserName = reader["UserName"].ToString();
obj.IsApproved = bool.Parse(reader["IsActive"].ToString());
lstUsers.Add(obj);
}
reader.Close();
return lstUsers;
}
catch (Exception ex)
{
throw (ex);
}
}
private void LogInPublicModeRegistration(UserInfo user)
{
string strRoles = string.Empty;
RoleController role = new RoleController();
SageFrameConfig sfConfig = new SageFrameConfig();
string userRoles = role.GetRoleNames(user.UserName, GetPortalID);
strRoles += userRoles;
if (strRoles.Length > 0)
{
SetUserRoles(strRoles);
SessionTracker sessionTracker = (SessionTracker)Session[SessionKeys.Tracker];
sessionTracker.PortalID = GetPortalID.ToString();
sessionTracker.Username = user.UserName;
Session[SessionKeys.Tracker] = sessionTracker;
SageFrame.Web.SessionLog SLog = new SageFrame.Web.SessionLog();
SLog.SessionTrackerUpdateUsername(sessionTracker, sessionTracker.Username, GetPortalID.ToString());
{
FormsAuthenticationTicket ticket = new FormsAuthenticationTicket(1,
user.UserName,
DateTime.Now,
DateTime.Now.AddMinutes(30),
true,
GetPortalID.ToString(),
FormsAuthentication.FormsCookiePath);
// Encrypt the ticket.
string encTicket = FormsAuthentication.Encrypt(ticket);
// Create the cookie.
Response.Cookies.Add(new HttpCookie(FormsAuthentication.FormsCookieName + "_" + GetApplicationName + "_" + GetPortalID, encTicket));
bool IsUseFriendlyUrls = sfConfig.GetSettingBollByKey(SageFrameSettingKeys.UseFriendlyUrls);
if (IsUseFriendlyUrls)
{
if (GetPortalID > 1)
{
Response.Redirect(ResolveUrl("~/portal/" + GetPortalSEOName + "/" + sfConfig.GetSettingsByKey(SageFrameSettingKeys.PortalDefaultPage) + SageFrameSettingKeys.PageExtension), false);
}
else
{
Response.Redirect(ResolveUrl("~/" + sfConfig.GetSettingsByKey(SageFrameSettingKeys.PortalDefaultPage) + SageFrameSettingKeys.PageExtension), false);
}
}
else
{
Response.Redirect(ResolveUrl("~/Default.aspx?ptlid=" + GetPortalID + "&ptSEO=" + GetPortalSEOName + "&pgnm=" + sfConfig.GetSettingsByKey(SageFrameSettingKeys.PortalDefaultPage)), false);
}
}
}
}
public static SageFrameUserCollection GetAllUsers()
{
string sp = "[dbo].[usp_UsersGetAll]";
SQLHandler sagesql = new SQLHandler();
SageFrameUserCollection userColl = new SageFrameUserCollection();
List<UserInfo> lstUsers = new List<UserInfo>();
try
{
SqlDataReader reader;
reader = sagesql.ExecuteAsDataReader(sp);
while (reader.Read())
{
UserInfo obj = new UserInfo();
obj.UserID = new Guid(reader["userid"].ToString());
obj.UserName = reader["username"].ToString();
obj.FirstName = reader["firstname"].ToString();
obj.LastName = reader["lastname"].ToString();
obj.Email = reader["email"].ToString();
lstUsers.Add(obj);
}
reader.Close();
userColl.UserList = lstUsers;
return userColl;
}
catch (Exception ex)
{
throw (ex);
}
}
