protected void Application_Start(object sender, EventArgs e)
{
try
{
string IsInstalled = Config.GetSetting("IsInstalled").ToString();
string InstallationDate = Config.GetSetting("InstallationDate").ToString();
if ((IsInstalled != "" && IsInstalled != "false") && InstallationDate != "")
{
SageFrameConfig pagebase = new SageFrameConfig();
RolesManagementDataContext db = new RolesManagementDataContext(SystemSetting.SageFrameConnectionString);
sp_GetRoleIDByRoleNameResult res = (sp_GetRoleIDByRoleNameResult)db.sp_GetRoleIDByRoleName(SystemSetting.AnonymousUsername).SingleOrDefault();
if (res != null)
{
SystemSetting.ANONYMOUS_ROLEID = res.RoleId.ToString();
}
bool IsUseFriendlyUrls = pagebase.GetSettingBollByKey(SageFrameSettingKeys.UseFriendlyUrls);
if (IsUseFriendlyUrls)
{
RegisterRoutes(RouteTable.Routes);
}
}
}
catch
{
}
}
protected void Application_Start(object sender, EventArgs e)
{
try
{
string IsInstalled = Config.GetSetting("IsInstalled").ToString();
string InstallationDate = Config.GetSetting("InstallationDate").ToString();
if ((IsInstalled != "" && IsInstalled != "false") && InstallationDate != "")
{
SageFrameConfig pagebase = new SageFrameConfig();
RolesManagementDataContext db = new RolesManagementDataContext(SystemSetting.SageFrameConnectionString);
sp_GetRoleIDByRoleNameResult res = (sp_GetRoleIDByRoleNameResult)db.sp_GetRoleIDByRoleName(SystemSetting.AnonymousUsername).SingleOrDefault();
if (res != null)
{
SystemSetting.ANONYMOUS_ROLEID = res.RoleId.ToString();
}
bool IsUseFriendlyUrls = pagebase.GetSettingBollByKey(SageFrameSettingKeys.UseFriendlyUrls);
if (IsUseFriendlyUrls)
{
RegisterRoutes(RouteTable.Routes);
}
}
}
catch
{
}
}
private DataTable GetAllRoles()
{
DataTable dtRole = new DataTable();
dtRole.Columns.Add("RoleID");
dtRole.Columns.Add("RoleName");
dtRole.AcceptChanges();
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))
{
DataRow dr = dtRole.NewRow();
dr["RoleID"] = role.RoleID;
dr["RoleName"] = roleName;
dtRole.Rows.Add(dr);
}
else
{
string rolePrefix = GetPortalSEOName + "_";
roleName = roleName.Replace(rolePrefix, "");
DataRow dr = dtRole.NewRow();
dr["RoleID"] = role.RoleID;
dr["RoleName"] = roleName;
dtRole.Rows.Add(dr);
}
}
return(dtRole);
}
protected void Login1_LoggedIn(object sender, EventArgs e)
{
try
{
RolesManagementDataContext dbRole = new RolesManagementDataContext(SystemSetting.SageFrameConnectionString);
var userRoles = dbRole.sp_RoleGetByUsername(Login1.UserName,GetPortalID).ToList();
foreach (var userRole in userRoles)
{
strRoles += userRole.RoleId + ",";
}
if (strRoles.Length > 1)
{
strRoles = strRoles.Substring(0, strRoles.Length - 1);
}
if (strRoles.Length > 0)
{
SetUserRoles(strRoles);
if (Request.QueryString["ReturnUrl"] == null)
{
if (IsUseFriendlyUrls)
{
if (string.IsNullOrEmpty(PortalSEOName))
{
Response.Redirect("~/" + pagebase.GetSettingsByKey(SageFrameSettingKeys.PortalDefaultPage) + ".aspx");
}
else
{
Response.Redirect("~/portal/" + PortalSEOName + "/" + pagebase.GetSettingsByKey(SageFrameSettingKeys.PortalDefaultPage) + ".aspx");
}
}
else
{
Response.Redirect(ResolveUrl("~/Default.aspx?ptlid=" + GetPortalID + "&ptSEO=" + GetPortalSEOName + "&pgnm=" + pagebase.GetSettingsByKey(SageFrameSettingKeys.PortalDefaultPage)));
}
}
}
else
{
FormsAuthentication.SignOut();
Login1.FailureText = "failure text";
}
}
catch (Exception ex)
{
ProcessException(ex);
}
}
protected void Login1_LoggedIn(object sender, EventArgs e)
{
try
{
RolesManagementDataContext dbRole = new RolesManagementDataContext(SystemSetting.SageFrameConnectionString);
var userRoles = dbRole.sp_RoleGetByUsername(Login1.UserName, GetPortalID).ToList();
foreach (var userRole in userRoles)
{
strRoles += userRole.RoleId + ",";
}
if (strRoles.Length > 1)
{
strRoles = strRoles.Substring(0, strRoles.Length - 1);
}
if (strRoles.Length > 0)
{
SetUserRoles(strRoles);
if (Request.QueryString["ReturnUrl"] == null)
{
if (IsUseFriendlyUrls)
{
if (string.IsNullOrEmpty(PortalSEOName))
{
Response.Redirect("~/" + pagebase.GetSettingsByKey(SageFrameSettingKeys.PortalDefaultPage) + ".aspx");
}
else
{
Response.Redirect("~/portal/" + PortalSEOName + "/" + pagebase.GetSettingsByKey(SageFrameSettingKeys.PortalDefaultPage) + ".aspx");
}
}
else
{
Response.Redirect(ResolveUrl("~/Default.aspx?ptlid=" + GetPortalID + "&ptSEO=" + GetPortalSEOName + "&pgnm=" + pagebase.GetSettingsByKey(SageFrameSettingKeys.PortalDefaultPage)));
}
}
}
else
{
FormsAuthentication.SignOut();
Login1.FailureText = "failure text";
}
}
catch (Exception ex)
{
ProcessException(ex);
}
}
private DataTable GetAllRoles()
{
DataTable dtRole = new DataTable();
dtRole.Columns.Add("RoleID");
dtRole.Columns.Add("RoleName");
dtRole.AcceptChanges();
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))
{
DataRow dr = dtRole.NewRow();
dr["RoleID"] = role.RoleID;
dr["RoleName"] = roleName;
dtRole.Rows.Add(dr);
}
else
{
string rolePrefix = GetPortalSEOName + "_";
roleName = roleName.Replace(rolePrefix, "");
DataRow dr = dtRole.NewRow();
dr["RoleID"] = role.RoleID;
dr["RoleName"] = roleName;
dtRole.Rows.Add(dr);
}
}
return dtRole;
}
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);
}
}
private DataTable GetAllSuperRoles()
{
DataTable dtRole = new DataTable();
if (HttpContext.Current.Cache["AllSuperRoles"] != null)
{
return (DataTable)HttpContext.Current.Cache["AllSuperRoles"];
}
else
{
dtRole.Columns.Add("RoleID");
dtRole.Columns.Add("RoleName");
dtRole.AcceptChanges();
RolesManagementDataContext dbRoles = new RolesManagementDataContext(SystemSetting.SageFrameConnectionString);
var roles = dbRoles.sp_PortalRoleList(GetPortalID, true, GetUsername);
foreach (var role in roles)
{
string roleName = role.RoleName;
if (SystemSetting.SUPER_ROLE.Contains(roleName, StringComparer.OrdinalIgnoreCase))
{
DataRow dr = dtRole.NewRow();
dr["RoleID"] = role.RoleID;
dr["RoleName"] = roleName;
dtRole.Rows.Add(dr);
}
}
}
return dtRole;
}
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);
}
}
