protected void ShowSettings()
{
//get the tracking ID
if (ModuleSettings.ContainsKey("GoogleTrackingId"))
txtAnalyticsTrackingId.Text = (string)ModuleSettings["GoogleTrackingId"];
if (ModuleSettings.ContainsKey("LocalHostAddress"))
{
txtLocalHostName.Text = (string)ModuleSettings["LocalHostAddress"];
}
//populate the drop down box
RoleController rc = new DotNetNuke.Security.Roles.RoleController();
ArrayList roles = rc.GetPortalRoles(this.PortalId);
//put in a dummy role to allow no restriction on role
RoleInfo dummyRole = new RoleInfo();
dummyRole.RoleID = -1;
dummyRole.RoleName = "[Do Not Hide Tracking]";
roles.Insert(0, dummyRole);
ddlSecurityGroups.DataSource = roles;
ddlSecurityGroups.DataValueField = "RoleID";
ddlSecurityGroups.DataTextField = "RoleName";
ddlSecurityGroups.DataBind();
//get the security group
if (ModuleSettings.ContainsKey("HideTrackingFromRole"))
{
foreach(ListItem item in ddlSecurityGroups.Items)
{
string value = (string)ModuleSettings["HideTrackingFromRole"];
if (item.Text == value)
ddlSecurityGroups.SelectedValue = item.Value;
}
}
}
private static bool DeleteUserRoleInternal(int portalId, int userId, int roleId)
{
var roleController = new RoleController();
var user = UserController.GetUserById(portalId, userId);
var userRole = roleController.GetUserRole(portalId, userId, roleId);
var portalController = new PortalController();
bool delete = true;
var portal = portalController.GetPortal(portalId);
if (portal != null && userRole != null)
{
if (CanRemoveUserFromRole(portal, userId, roleId))
{
provider.RemoveUserFromRole(portalId, user, userRole);
var objEventLog = new EventLogController();
objEventLog.AddLog(userRole, PortalController.GetCurrentPortalSettings(), UserController.GetCurrentUserInfo().UserID, "", EventLogController.EventLogType.ROLE_UPDATED);
//Remove the UserInfo from the Cache, as it has been modified
DataCache.ClearUserCache(portalId, user.Username);
TestableRoleController.Instance.ClearRoleCache(portalId);
}
else
{
delete = false;
}
}
return delete;
}
public HttpResponseMessage EditRoleGroup(NewRoleGroupDTO roleGroupName)
{
try
{
DotNetNuke.Security.Roles.RoleController oDnnRoleController = new DotNetNuke.Security.Roles.RoleController();
RoleGroupInfo oRoleGroup = new RoleGroupInfo();
oRoleGroup.PortalID = this.PortalSettings.PortalId;
oRoleGroup.RoleGroupName = "DVC_" + roleGroupName.Name;
oRoleGroup.RoleGroupID = roleGroupName.RoleGroupID;
oRoleGroup.Description = "";
if (oRoleGroup.RoleGroupID == -1)
{
DotNetNuke.Security.Roles.RoleController.AddRoleGroup(oRoleGroup);
}
else
{
DotNetNuke.Security.Roles.RoleController.UpdateRoleGroup(oRoleGroup);
}
return(Request.CreateResponse(HttpStatusCode.OK));
}
catch (Exception exc)
{
Exceptions.LogException(exc);
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, exc));
}
}
public void AuthoriseClient()
{
if (_userInfo != null)
{
_userInfo.Membership.Approved = true;
UserController.UpdateUser(PortalSettings.Current.PortalId, _userInfo);
if (_userInfo.IsInRole("Unverified Users"))
{
var rc = new DotNetNuke.Security.Roles.RoleController();
var ri = rc.GetRoleByName(PortalId, "Unverified Users");
var portalSettings = PortalController.Instance.GetCurrentPortalSettings();
if (ri != null)
{
RoleController.DeleteUserRole(_userInfo, ri, portalSettings, false);
}
ri = rc.GetRoleByName(PortalId, "Registered Users");
if (ri != null)
{
RoleController.AddUserRole(_userInfo, ri, portalSettings, RoleStatus.Approved, DateTime.Now, DateTime.Now.AddYears(99), false, false);
}
ri = rc.GetRoleByName(PortalId, "Subscribers");
if (ri != null)
{
RoleController.AddUserRole(_userInfo, ri, portalSettings, RoleStatus.Approved, DateTime.Now, DateTime.Now.AddYears(99), false, false);
}
}
}
}
/// <summary>
/// BindData gets the roles from the Database and binds them to the DataGrid
/// </summary>
/// <history>
/// [cnurse] 9/10/2004 Updated to reflect design changes for Help, 508 support
/// and localisation
/// [cnurse] 01/05/2006 Updated to reflect Use of Role Groups
/// </history>
private void BindData()
{
// Get the portal's roles from the database
RoleController objRoles = new RoleController();
ArrayList arrRoles;
if( RoleGroupId < - 1 )
{
arrRoles = objRoles.GetPortalRoles( PortalId );
}
else
{
arrRoles = objRoles.GetRolesByGroup( PortalId, RoleGroupId );
}
grdRoles.DataSource = arrRoles;
if( RoleGroupId < 0 )
{
lnkEditGroup.Visible = false;
cmdDelete.Visible = false;
}
else
{
lnkEditGroup.Visible = true;
lnkEditGroup.NavigateUrl = EditUrl( "RoleGroupId", RoleGroupId.ToString(), "EditGroup" );
cmdDelete.Visible = !( arrRoles.Count > 0 );
ClientAPI.AddButtonConfirm( cmdDelete, Localization.GetString( "DeleteItem" ) );
}
Localization.LocalizeDataGrid( ref grdRoles, this.LocalResourceFile );
grdRoles.DataBind();
}
public override ArrayList GetGroups()
{
//Dim adsiConfig As Authentication.ADSI.Configuration = Authentication.ADSI.Configuration.GetConfig(_portalSettings.PortalId)
// Normally number of roles in DNN less than groups in Authentication,
// so start from DNN roles to get better performance
try
{
// Obtain search object
//Dim rootDomain As DirectoryEntry = GetRootDomain()
//Dim objSearch As New ADSI.Search(rootDomain)
ArrayList colGroup = new ArrayList();
RoleController objRoleController = new RoleController();
ArrayList lstRoles = objRoleController.GetPortalRoles( _portalSettings.PortalId );
RoleInfo objRole;
foreach( RoleInfo tempLoopVar_objRole in lstRoles )
{
objRole = tempLoopVar_objRole;
// Auto assignment roles have been added by DNN, so don't need to get them
if( ! objRole.AutoAssignment )
{
// It's possible in multiple domains network that search result return more than one group with the same name (i.e Administrators)
// We better check them all
DirectoryEntry entry;
foreach( DirectoryEntry tempLoopVar_entry in Utilities.GetGroupEntriesByName( objRole.RoleName ) )
{
entry = tempLoopVar_entry;
GroupInfo group = new GroupInfo();
group.PortalID = objRole.PortalID;
group.RoleID = objRole.RoleID;
group.GUID = entry.NativeGuid;
group.Location = Utilities.GetEntryLocation( entry );
group.RoleName = objRole.RoleName;
group.Description = objRole.Description;
group.ServiceFee = objRole.ServiceFee;
group.BillingFrequency = objRole.BillingFrequency;
group.TrialPeriod = objRole.TrialPeriod;
group.TrialFrequency = objRole.TrialFrequency;
group.BillingPeriod = objRole.BillingPeriod;
group.TrialFee = objRole.TrialFee;
group.IsPublic = objRole.IsPublic;
group.AutoAssignment = objRole.AutoAssignment;
// Populate member with distingushed name
PopulateMembership( group, entry );
colGroup.Add( group );
}
}
}
return colGroup;
}
catch( COMException exc )
{
Exceptions.LogException( exc );
return null;
}
}
public void GetStaffNames(int portalid, string term)
{
term = term.ToLower();
var result = new DotNetNuke.Security.Roles.RoleController().GetUsersByRole(portalid, "Staff")
.Where(w => w.DisplayName.ToLower().Contains(term) && w.IsDeleted==false)
.Select(s => new { label = s.DisplayName, value = s.UserID })
.OrderBy(o => o.label);
string json = JsonConvert.SerializeObject(result);
HttpContext.Current.Response.ContentType = "application/json";
HttpContext.Current.Response.Write(json);
}
private void Save_Click(object sender, EventArgs e)
{
if (GroupId > 0)
{
RoleController roleController = new RoleController();
Security.PortalSecurity ps = new Security.PortalSecurity();
txtDescription.Text = ps.InputFilter(txtDescription.Text, Security.PortalSecurity.FilterFlag.NoScripting);
txtDescription.Text = ps.InputFilter(txtDescription.Text, Security.PortalSecurity.FilterFlag.NoMarkup);
var roleInfo = roleController.GetRole(GroupId, PortalId);
if (roleInfo != null)
{
roleInfo.Description = txtDescription.Text;
roleInfo.IsPublic = rdAccessTypePublic.Checked;
if (roleInfo.Settings.ContainsKey("URL"))
{
roleInfo.Settings["URL"] = Globals.NavigateURL(TabId, "", new String[] { "groupid=" + roleInfo.RoleID.ToString() });
} else
{
roleInfo.Settings.Add("URL", Globals.NavigateURL(TabId, "", new String[] { "groupid=" + roleInfo.RoleID.ToString() }));
}
if (roleInfo.Settings.ContainsKey("ReviewMembers"))
{
roleInfo.Settings["ReviewMembers"] = chkMemberApproved.Checked.ToString();
} else
{
roleInfo.Settings.Add("ReviewMembers", chkMemberApproved.Checked.ToString());
}
TestableRoleController.Instance.UpdateRoleSettings(roleInfo, true);
roleController.UpdateRole(roleInfo);
if (inpFile.PostedFile.ContentLength > 0)
{
IFileManager _fileManager = FileManager.Instance;
IFolderManager _folderManager = FolderManager.Instance;
var rootFolderPath = PathUtils.Instance.FormatFolderPath(PortalSettings.HomeDirectory);
IFolderInfo groupFolder = _folderManager.GetFolder(PortalSettings.PortalId, "Groups/" + roleInfo.RoleID);
if (groupFolder == null)
{
groupFolder = _folderManager.AddFolder(PortalSettings.PortalId, "Groups/" + roleInfo.RoleID);
}
if (groupFolder != null)
{
var fileName = Path.GetFileName(inpFile.PostedFile.FileName);
var fileInfo = _fileManager.AddFile(groupFolder, fileName, inpFile.PostedFile.InputStream, true);
roleInfo.IconFile = "FileID=" + fileInfo.FileId;
roleController.UpdateRole(roleInfo);
}
}
}
Response.Redirect(Globals.NavigateURL(TabId, "", new String[] { "groupid=" + GroupId.ToString() }));
}
}
public void GivenThereIsAPageCalled(string pageName, Table permissions)
{
var reset = false;
var tabController = new TabController();
var tab = tabController.GetTabByName(pageName, PortalId);
if (tab == null)
{
tab = new TabInfo
{
TabName = pageName,
PortalID = 0
};
tab.TabID = tabController.AddTab(tab);
foreach (var row in permissions.Rows)
{
var roleId = -1;
var roleController = new RoleController();
if (row[0] == "All Users")
{
roleId = -1;
}
else
{
var role = roleController.GetRoleByName(PortalId, row[0]);
if (role == null)
{
if (roleController.GetRoleByName(Null.NullInteger, row[0]) == null)
{
role = new RoleInfo { RoleName = row[0], RoleGroupID = Null.NullInteger };
roleId = roleController.AddRole(role);
}
}
}
var permissionController = new PermissionController();
var permission = permissionController.GetPermissionByCodeAndKey("SYSTEM_TAB", row[1]);
var tabPermission = new TabPermissionInfo
{
PermissionID = 3,
TabID = tab.TabID,
AllowAccess = true,
RoleID = roleId
};
tab.TabPermissions.Add(tabPermission);
}
tabController.UpdateTab(tab);
reset = true;
}
Page = tab;
if (reset)
{
Config.Touch();
}
}
/// -----------------------------------------------------------------------------
/// <summary>
/// DataBind binds the data to the controls
/// </summary>
/// <history>
/// [cnurse] 03/13/2006 Created
/// </history>
/// -----------------------------------------------------------------------------
public override void DataBind()
{
if (Request.IsAuthenticated)
{
RoleController roleController = new RoleController();
grdServices.DataSource = roleController.GetUserRoles(UserInfo, false);
grdServices.DataBind();
//if no service available then hide options
ServicesRow.Visible = (grdServices.Items.Count > 0);
}
}
public void AddClientEditorRole()
{
if (_userInfo != null)
{
if (!_userInfo.IsInRole(StoreSettings.ClientEditorRole))
{
var rc = new DotNetNuke.Security.Roles.RoleController();
var ri = rc.GetRoleByName(PortalId, StoreSettings.ClientEditorRole);
if (ri != null) rc.AddUserRole(PortalId, _userInfo.UserID, ri.RoleID, Null.NullDate, Null.NullDate);
if (StoreSettings.Current.Get("sendclientroleemail") == "True") NBrightBuyUtils.SendEmail(_userInfo.Email, "addclientrole.html", _clientInfo, "", "", _userInfo.Profile.PreferredLocale);
}
}
}
static public AP_StaffBroker_Staff CreateStaffMember(int PortalId, DotNetNuke.Entities.Users.UserInfo User1in, DotNetNuke.Entities.Users.UserInfo User2in, short staffTypeIn)
{
//Create Married Staff
DotNetNuke.Security.Roles.RoleController rc = new DotNetNuke.Security.Roles.RoleController();
if (rc.GetRoleByName(PortalId, "Staff") == null)
{
DotNetNuke.Security.Roles.RoleInfo insert = new DotNetNuke.Security.Roles.RoleInfo();
insert.Description = "Staff Members";
insert.RoleName = "Staff";
insert.AutoAssignment = false;
insert.IsPublic = false;
insert.RoleGroupID = -1;
insert.PortalID = PortalId;
rc.AddRole(insert);
}
rc.AddUserRole(PortalId, User1in.UserID, rc.GetRoleByName(PortalId, "Staff").RoleID, DateTime.MaxValue);
rc.AddUserRole(PortalId, User2in.UserID, rc.GetRoleByName(PortalId, "Staff").RoleID, DateTime.MaxValue);
StaffBrokerDataContext d = new StaffBrokerDataContext();
var searchStaff = from c in d.AP_StaffBroker_Staffs where c.Active && (c.UserId1 == User1in.UserID || c.UserId2 == User1in.UserID || c.UserId1 == User2in.UserID || c.UserId2 == User2in.UserID) select c;
if (searchStaff.Count() > 0)
{
return(searchStaff.First());
}
AP_StaffBroker_Staff rtn = new AP_StaffBroker_Staff();
rtn.UserId1 = User1in.UserID;
rtn.UserId2 = User2in.UserID;
rtn.PortalId = PortalId;
rtn.Active = true;
rtn.DisplayName = User1in.FirstName + " & " + User2in.FirstName + " " + User1in.LastName;
rtn.StaffTypeId = staffTypeIn;
rtn.CostCenter = "";
d.AP_StaffBroker_Staffs.InsertOnSubmit(rtn);
d.SubmitChanges();
return(rtn);
}
/// -----------------------------------------------------------------------------
/// <summary>
/// Page_Load runs when the control is loaded
/// </summary>
/// <remarks>
/// </remarks>
/// <history>
/// [cnurse] 9/10/2004 Updated to reflect design changes for Help, 508 support
/// and localisation
/// </history>
/// -----------------------------------------------------------------------------
protected override void OnLoad(EventArgs e)
{
base.OnLoad(e);
cmdCancel.Click += cmdCancel_Click;
cmdDelete.Click += cmdDelete_Click;
cmdUpdate.Click += cmdUpdate_Click;
try
{
if ((Request.QueryString["RoleGroupID"] != null))
{
RoleGroupID = Int32.Parse(Request.QueryString["RoleGroupID"]);
}
if (Page.IsPostBack == false)
{
ClientAPI.AddButtonConfirm(cmdDelete, Localization.GetString("DeleteItem"));
var objRoles = new RoleController();
if (RoleGroupID != -1)
{
RoleGroupInfo objRoleGroupInfo = RoleController.GetRoleGroup(PortalId, RoleGroupID);
if (objRoleGroupInfo != null)
{
txtRoleGroupName.Text = objRoleGroupInfo.RoleGroupName;
txtDescription.Text = objRoleGroupInfo.Description;
//Check if Group has any roles assigned
int roleCount = objRoles.GetRolesByGroup(PortalId, RoleGroupID).Count;
if (roleCount > 0)
{
cmdDelete.Visible = false;
}
}
else //security violation attempt to access item not related to this Module
{
Response.Redirect(Globals.NavigateURL("Security Roles"));
}
}
else
{
cmdDelete.Visible = false;
}
}
}
catch (Exception exc) //Module failed to load
{
Exceptions.ProcessModuleLoadException(this, exc);
}
}
public void RemoveClientEditorRole()
{
if (_userInfo != null)
{
if (_userInfo.IsInRole(StoreSettings.ClientEditorRole))
{
var rc = new DotNetNuke.Security.Roles.RoleController();
var ri = rc.GetRoleByName(PortalId, StoreSettings.ClientEditorRole);
var portalSettings = PortalController.Instance.GetCurrentPortalSettings();
if (ri != null)
{
RoleController.DeleteUserRole(_userInfo, ri, portalSettings, false);
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
DotNetNuke.Framework.jQuery.RegisterDnnJQueryPlugins(this.Page);
imgGroup.Src = Page.ResolveUrl("~/DesktopModules/SocialGroups/Images/") + "sample-group-profile.jpg";
if (!Page.IsPostBack && GroupId > 0)
{
RoleController roleController = new RoleController();
var roleInfo = roleController.GetRole(GroupId, PortalId);
if (roleInfo != null)
{
if (!UserInfo.IsInRole(PortalSettings.AdministratorRoleName))
{
if (roleInfo.CreatedByUserID != UserInfo.UserID)
{
Response.Redirect(ModuleContext.NavigateUrl(TabId, "", false, new String[] { "groupid=" + GroupId.ToString() }));
}
}
txtGroupName.Visible = !roleInfo.IsSystemRole;
reqGroupName.Enabled = !roleInfo.IsSystemRole;
if(!roleInfo.IsSystemRole)
txtGroupName.Text = roleInfo.RoleName;
else
litGroupName.Text = roleInfo.RoleName;
txtDescription.Text = roleInfo.Description;
rdAccessTypePrivate.Checked = !roleInfo.IsPublic;
rdAccessTypePublic.Checked = roleInfo.IsPublic;
if (roleInfo.Settings.ContainsKey("ReviewMembers"))
{
chkMemberApproved.Checked = Convert.ToBoolean(roleInfo.Settings["ReviewMembers"].ToString());
}
imgGroup.Src = roleInfo.PhotoURL;
}
else
{
Response.Redirect(ModuleContext.NavigateUrl(TabId, "", false));
}
}
}
/// -----------------------------------------------------------------------------
/// <summary>
/// cmdDelete_Click runs when the delete Button is clicked
/// </summary>
/// <remarks>
/// </remarks>
/// <history>
/// [cnurse] 9/10/2004 Updated to reflect design changes for Help, 508 support
/// and localisation
/// </history>
/// -----------------------------------------------------------------------------
protected void OnDeleteClick(object sender, EventArgs e)
{
try
{
var objUser = new RoleController();
objUser.DeleteRole(_roleID, PortalSettings.PortalId);
//Clear Roles Cache
DataCache.RemoveCache("GetRoles");
Response.Redirect(Globals.NavigateURL());
}
catch (Exception exc) //Module failed to load
{
Exceptions.ProcessModuleLoadException(this, exc);
}
}
public HttpResponseMessage EditRole(NewRoleDTO roleName)
{
try
{
if ((roleName.RoleId != -1))
{
_roleID = roleName.RoleId;
}
DotNetNuke.Security.Roles.RoleController oDnnRoleController = new DotNetNuke.Security.Roles.RoleController();
RoleInfo oRole = new RoleInfo();
oRole.PortalID = PortalSettings.PortalId;
oRole.RoleName = roleName.Name;
oRole.IsPublic = false;
oRole.Status = RoleStatus.Approved;
oRole.AutoAssignment = false;
oRole.RoleGroupID = roleName.RoleGroup;
oRole.Status = (RoleStatus)roleName.Status;
oRole.Description = "";
oRole.IsSystemRole = false;
if (_roleID == -1)
{
var rolename = oRole.RoleName.ToUpper();
if (DotNetNuke.Security.Roles.RoleController.Instance.GetRole(oRole.PortalID,
r => rolename.Equals(r.RoleName, StringComparison.InvariantCultureIgnoreCase)) == null)
{
oDnnRoleController.AddRole(oRole);
}
}
else
{
oRole.RoleID = roleName.RoleId;
DotNetNuke.Security.Roles.RoleController.Instance.UpdateRole(oRole);
}
DataCache.ClearCache();
return(Request.CreateResponse(HttpStatusCode.OK));
}
catch (Exception exc)
{
Exceptions.LogException(exc);
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, exc));
}
}
internal virtual Notification AddGroupOwnerNotification(string notificationTypeName, int tabId, int moduleId, RoleInfo group, UserInfo initiatingUser)
{
var notificationType = NotificationsController.Instance.GetNotificationType(notificationTypeName);
var tokenReplace = new GroupItemTokenReplace(group);
var subject = Localization.GetString(notificationTypeName + ".Subject", Constants.SharedResourcesPath);
var body = Localization.GetString(notificationTypeName + ".Body", Constants.SharedResourcesPath);
subject = subject.Replace("[DisplayName]", initiatingUser.DisplayName);
subject = subject.Replace("[ProfileUrl]", Globals.UserProfileURL(initiatingUser.UserID));
subject = tokenReplace.ReplaceGroupItemTokens(subject);
body = body.Replace("[DisplayName]", initiatingUser.DisplayName);
body = body.Replace("[ProfileUrl]", Globals.UserProfileURL(initiatingUser.UserID));
body = tokenReplace.ReplaceGroupItemTokens(body);
var roleCreator = UserController.GetUserById(group.PortalID, group.CreatedByUserID);
var roleOwners = new List<UserInfo>();
var rc = new RoleController();
foreach (UserInfo userInfo in rc.GetUsersByRoleName(group.PortalID, group.RoleName)) {
var userRoleInfo = rc.GetUserRole(group.PortalID, userInfo.UserID, group.RoleID);
if (userRoleInfo.IsOwner && userRoleInfo.UserID != group.CreatedByUserID)
{
roleOwners.Add(UserController.GetUserById(group.PortalID, userRoleInfo.UserID));
}
}
roleOwners.Add(roleCreator);
//Need to add from sender details
var notification = new Notification
{
NotificationTypeID = notificationType.NotificationTypeId,
Subject = subject,
Body = body,
IncludeDismissAction = true,
SenderUserID = initiatingUser.UserID,
Context = String.Format("{0}:{1}:{2}:{3}", tabId, moduleId, group.RoleID, initiatingUser.UserID)
};
NotificationsController.Instance.SendNotification(notification, initiatingUser.PortalID, null, roleOwners);
return notification;
}
public void AddClientEditorRole()
{
if (_userInfo != null)
{
if (!_userInfo.IsInRole(StoreSettings.ClientEditorRole))
{
var rc = new DotNetNuke.Security.Roles.RoleController();
var ri = rc.GetRoleByName(PortalId, StoreSettings.ClientEditorRole);
if (ri != null)
{
rc.AddUserRole(PortalId, _userInfo.UserID, ri.RoleID, Null.NullDate, Null.NullDate);
}
if (StoreSettings.Current.Get("sendclientroleemail") == "True")
{
NBrightBuyUtils.SendEmail(_userInfo.Email, "addclientrole.html", _clientInfo, "", "", _userInfo.Profile.PreferredLocale);
}
}
}
}
private void BindRoles()
{
StringBuilder sb = new StringBuilder();
sb.Append("<select id=\"drpSecRoles\" class=\"amcptxtbx\" style=\"width:150px;\">");
sb.Append("<option value=\"\">[RESX:DropDownDefault]</option>");
sb.Append("<option value=\"-1\">All Users</option>");
sb.Append("<option value=\"-3\">Unauthenticated Users</option>");
DotNetNuke.Security.Roles.RoleController rc = new DotNetNuke.Security.Roles.RoleController();
foreach (DotNetNuke.Security.Roles.RoleInfo ri in rc.GetPortalRoles(PortalId))
{
sb.Append("<option value=\"" + ri.RoleID + "\">" + ri.RoleName + "</option>");
}
//drpSecRoles.DataTextField = "RoleName"
//drpSecRoles.DataValueField = "RoleId"
//drpSecRoles.DataSource = rc.GetPortalRoles(PortalId)
//drpSecRoles.DataBind()
//drpSecRoles.Items.Insert(0, New ListItem("[RESX:DropDownDefault]", ""))
//drpSecRoles.Items.Insert(1, New ListItem("All Users", "-1"))
//drpSecRoles.Items.Insert(2, New ListItem("Unauthenticated Users", "-3"))
//drpSecRoles.Items.Insert(3, New ListItem("Topic Author", "-10"))
string sGroups = string.Empty;
#if !SKU_LITE
if (System.IO.File.Exists(Server.MapPath("~/bin/active.modules.social.dll")))
{
Social social = new Social();
using (IDataReader dr = social.ActiveSocialListGroups(PortalId))
{
while (dr.Read())
{
sb.Append("<optgroup label=\"" + dr["GroupName"].ToString() + "\">");
sb.Append("<option value=\"" + dr["GroupId"].ToString() + ":0\">Group Admin</option>");
sb.Append("<option value=\"" + dr["GroupId"].ToString() + ":1\">Group Member</option>");
sb.Append("</optgroup>");
}
dr.Close();
}
}
#endif
sb.Append("</select>");
litRoles.Text = sb.ToString();
}
public File CreateGroupFolder(int roleID, int portalID, UserInfo currentUser)
{
FileController ctrl = new FileController();
File rootGroupFolder = new File();
//rootGroupFolder.ChildCount = 0;
rootGroupFolder.CreatedByUserID = currentUser.UserID;
rootGroupFolder.CreatedByUserName = currentUser.DisplayName;
rootGroupFolder.CreatedDate = System.DateTime.Now;
rootGroupFolder.IsInTrash = false;
rootGroupFolder.IsFolder = true;
rootGroupFolder.ItemType = 0;
rootGroupFolder.LastModifiedByUserID = currentUser.UserID;
rootGroupFolder.LastModifiedByUserName = currentUser.DisplayName;
rootGroupFolder.LastModifiedDate = System.DateTime.Now;
RoleController ctrlRole = new RoleController();
RoleInfo role = ctrlRole.GetRole(roleID, portalID);
rootGroupFolder.Name = role.RoleName;
rootGroupFolder.ParentID = GetRootGroupsFolder(portalID, currentUser.UserID).ID;
rootGroupFolder.PortalID = portalID;
rootGroupFolder.RoleID = roleID;
ctrl.Create(rootGroupFolder);
Permission permission = new Permission();
permission.CanAddFiles = true;
permission.CanAddFolders = true;
permission.CanDelete = false;
permission.CanModify = false;
permission.CanModifyPermission = false;
permission.CanSee = true;
permission.FileID = rootGroupFolder.ID;
permission.ModuleID = 0;
permission.PortalID = portalID;
permission.RoleID = role.RoleID;
permission.RoleName = role.RoleName;
PermissionController ctrlPerm = new PermissionController();
ctrlPerm.Create(permission);
return rootGroupFolder;
}
public void AddClientEditorRole()
{
if (_userInfo != null)
{
if (!_userInfo.IsInRole(StoreSettings.ClientEditorRole))
{
var rc = new DotNetNuke.Security.Roles.RoleController();
var ri = rc.GetRoleByName(PortalId, StoreSettings.ClientEditorRole);
if (ri != null)
{
rc.AddUserRole(PortalId, _userInfo.UserID, ri.RoleID, Null.NullDate, Null.NullDate);
}
if (StoreSettings.Current.Get("sendclientroleemail") == "True")
{
var emailBody = "";
emailBody = NBrightBuyUtils.RazorTemplRender("AddClientRole.cshtml", 0, "", _clientInfo, "/DesktopModules/NBright/NBrightBuy", StoreSettings.Current.Get("themefolder"), _userInfo.Profile.PreferredLocale, StoreSettings.Current.Settings());
NBrightBuyUtils.SendEmail(emailBody, _userInfo.Email, "ClientRole", _clientInfo, StoreSettings.Current.SettingsInfo.GetXmlProperty("genxml/textbox/storecompany"), StoreSettings.Current.ManagerEmail, _userInfo.Profile.PreferredLocale);
}
}
}
}
public HttpResponseMessage Roles_List()
{
int v_Current_Portal_ID = this.ActiveModule.PortalID;
List <Entities.Role_Info> v_Return_List = new List <Entities.Role_Info>();
DotNetNuke.Security.Roles.RoleController v_Roles_Controller = new DotNetNuke.Security.Roles.RoleController();
ArrayList v_Roles_List = v_Roles_Controller.GetPortalRoles(v_Current_Portal_ID);
foreach (DotNetNuke.Security.Roles.RoleInfo v_Roles_Info in v_Roles_List)
{
Entities.Role_Info v_Role_Info_Json = new Entities.Role_Info();
v_Role_Info_Json.RoleName = v_Roles_Info.RoleName;
v_Role_Info_Json.ID = v_Roles_Info.RoleID;
v_Return_List.Add(v_Role_Info_Json);
}
string v_json_resulted = Newtonsoft.Json.JsonConvert.SerializeObject(v_Return_List);
return(Request.CreateResponse(HttpStatusCode.OK, v_json_resulted));
}
public HttpResponseMessage ApproveGroup(NotificationDTO postData)
{
try
{
var recipient = InternalMessagingController.Instance.GetMessageRecipient(postData.NotificationId, UserInfo.UserID);
if (recipient == null) return Request.CreateErrorResponse(HttpStatusCode.InternalServerError, "Unable to locate recipient");
var notification = NotificationsController.Instance.GetNotification(postData.NotificationId);
ParseKey(notification.Context);
if (_roleInfo == null)
{
return Request.CreateErrorResponse(HttpStatusCode.InternalServerError, "Unable to locate role");
}
if (!IsMod())
{
return Request.CreateErrorResponse(HttpStatusCode.Unauthorized, "Not Authorized!");
}
var roleController = new RoleController();
_roleInfo.Status = RoleStatus.Approved;
roleController.UpdateRole(_roleInfo);
var roleCreator = UserController.GetUserById(PortalSettings.PortalId, _roleInfo.CreatedByUserID);
//Update the original creator's role
roleController.UpdateUserRole(PortalSettings.PortalId, roleCreator.UserID, _roleInfo.RoleID, RoleStatus.Approved, true, false);
GroupUtilities.CreateJournalEntry(_roleInfo, roleCreator);
var notifications = new Notifications();
var siteAdmin = UserController.GetUserById(PortalSettings.PortalId, PortalSettings.AdministratorId);
notifications.AddGroupNotification(Constants.GroupApprovedNotification, _tabId, _moduleId, _roleInfo, siteAdmin, new List<RoleInfo> { _roleInfo });
NotificationsController.Instance.DeleteAllNotificationRecipients(postData.NotificationId);
return Request.CreateResponse(HttpStatusCode.OK, new {Result = "success"});
}
catch (Exception exc)
{
Logger.Error(exc);
return Request.CreateErrorResponse(HttpStatusCode.InternalServerError, exc);
}
}
public ActionResult ApproveGroup(int notificationId)
{
try
{
var recipient = InternalMessagingController.Instance.GetMessageRecipient(notificationId, UserInfo.UserID);
if (recipient == null) return Json(new { Result = "error" });
var notification = NotificationsController.Instance.GetNotification(notificationId);
ParseKey(notification.Context);
if (roleInfo == null)
{
return Json(new { Result = "error" });
}
if (!IsMod())
{
return Json(new { Result = "access denied" });
}
var roleController = new RoleController();
roleInfo.Status = RoleStatus.Approved;
roleController.UpdateRole(roleInfo);
var roleCreator = UserController.GetUserById(PortalSettings.PortalId, roleInfo.CreatedByUserID);
//Update the original creator's role
roleController.UpdateUserRole(PortalSettings.PortalId, roleCreator.UserID, roleInfo.RoleID, RoleStatus.Approved, true, false);
GroupUtilities.CreateJournalEntry(roleInfo, roleCreator);
var notifications = new Notifications();
var siteAdmin = UserController.GetUserById(PortalSettings.PortalId, PortalSettings.AdministratorId);
notifications.AddGroupNotification(Constants.GroupApprovedNotification, TabId, ModuleId, roleInfo, siteAdmin, new List<RoleInfo> { roleInfo });
NotificationsController.Instance.DeleteAllNotificationRecipients(notificationId);
return Json(new { Result = "success" });
}
catch (Exception exc)
{
DnnLog.Error(exc);
return Json(new { Result = "error" });
}
}
/// <summary>
/// Page_Load runs when the control is loaded
/// </summary>
/// <remarks>
/// </remarks>
/// <history>
/// [cnurse] 9/10/2004 Updated to reflect design changes for Help, 508 support
/// and localisation
/// </history>
protected void Page_Load( Object sender, EventArgs e )
{
try
{
if( ! Page.IsPostBack )
{
RoleController objRoleController = new RoleController();
chkRoles.DataSource = objRoleController.GetPortalRoles( PortalId );
chkRoles.DataBind();
//Dim FileList As ArrayList = GetFileList(PortalId)
//cboAttachment.DataSource = FileList
//cboAttachment.DataBind()
//cmdUpload.NavigateUrl =Common.Globals.NavigateURL("File Manager")
txtFrom.Text = UserInfo.Email;
}
}
catch( Exception exc ) //Module failed to load
{
Exceptions.ProcessModuleLoadException( this, exc );
}
}
protected void BT_CreateUsersManquants_Click(object sender, EventArgs e)
{
DotNetNuke.Security.Roles.RoleController rc = new DotNetNuke.Security.Roles.RoleController();
TXT_Result.Text = "";
List <Member> membres = DataMapping.ListMembers(max: 10000);
foreach (Member membre in membres)
{
if (membre.userid == 0 && membre.email != "")
{
UserInfo ui = UserController.GetUserByName(Globals.GetPortalSettings().PortalId, membre.email);
if (ui == null)
{
if (DataMapping.UpdateOrCreateUser(membre.id, membre.email))
{
TXT_Result.Text += "<br/>Creation : " + membre.surname + " " + membre.name;
}
else
{
TXT_Result.Text += "<br/>Erreur création user : "******" " + membre.name;
}
}
else
{
if (DataMapping.UpdateMemberDNNUserID(membre.id, ui.UserID))
{
TXT_Result.Text += "<br/>L'utilisateur DNN existe déjà donc mise à jour : " + membre.surname + " " + membre.name;
}
else
{
TXT_Result.Text += "<br/>L'utilisateur DNN existe déjà mais n'a pas pu être mis à jour : " + membre.surname + " " + membre.name;
}
}
}
}
}
/// <summary>
/// DataBind binds the data to the controls
/// </summary>
/// <history>
/// [cnurse] 03/13/2006 Created
/// </history>
public override void DataBind()
{
if( Services == 1 )
{
RoleController objRoles = new RoleController();
grdServices.DataSource = objRoles.GetUserRoles( PortalId );
grdServices.DataBind();
if( grdServices.Items.Count != 0 )
{
lblServices.Text = string.Format( Localization.GetString( "PleaseRegister", this.LocalResourceFile ), Globals.GetPortalDomainName( PortalAlias.HTTPAlias, Request, true ) + "/" + Globals.glbDefaultPage, TabId );
}
else
{
grdServices.Visible = false;
lblServices.Text = Localization.GetString( "MembershipNotOffered", this.LocalResourceFile );
}
lblServices.Visible = true;
grdServices.Columns[0].Visible = false; // subscribe
grdServices.Columns[9].Visible = false; // expiry date
}
else
{
if( Request.IsAuthenticated )
{
RoleController objRoles = new RoleController();
grdServices.DataSource = objRoles.GetUserRoles( PortalId, UserInfo.UserID, false );
grdServices.DataBind();
// if no service available then hide options
//ServicesRow.Visible = (grdServices.Items.Count > 0)
}
}
}
private void ParseKey(string key)
{
_tabId = -1;
_moduleId = -1;
_roleId = -1;
_memberId = -1;
_roleInfo = null;
if (!String.IsNullOrEmpty(key))
{
string[] keys = key.Split(':');
_tabId = Convert.ToInt32(keys[0]);
_moduleId = Convert.ToInt32(keys[1]);
_roleId = Convert.ToInt32(keys[2]);
if (keys.Length > 3)
{
_memberId = Convert.ToInt32(keys[3]);
}
}
if (_roleId > 0)
{
var roleController = new RoleController();
_roleInfo = roleController.GetRole(_roleId, PortalSettings.PortalId);
}
}
public HttpResponseMessage ApproveMember(NotificationDTO postData)
{
try
{
var recipient = InternalMessagingController.Instance.GetMessageRecipient(postData.NotificationId, UserInfo.UserID);
if (recipient == null) return Request.CreateErrorResponse(HttpStatusCode.InternalServerError, "Unable to locate recipient");
var notification = NotificationsController.Instance.GetNotification(postData.NotificationId);
ParseKey(notification.Context);
if (_memberId <= 0)
{
return Request.CreateErrorResponse(HttpStatusCode.InternalServerError, "Unable to locate Member");
}
if (_roleInfo == null)
{
return Request.CreateErrorResponse(HttpStatusCode.InternalServerError, "Unable to locate Role");
}
var member = UserController.GetUserById(PortalSettings.PortalId, _memberId);
if (member != null)
{
var roleController = new RoleController();
var memberRoleInfo = roleController.GetUserRole(PortalSettings.PortalId, _memberId, _roleInfo.RoleID);
memberRoleInfo.Status = RoleStatus.Approved;
roleController.UpdateUserRole(PortalSettings.PortalId, _memberId, _roleInfo.RoleID, RoleStatus.Approved, false, false);
var notifications = new Notifications();
var groupOwner = UserController.GetUserById(PortalSettings.PortalId, _roleInfo.CreatedByUserID);
notifications.AddMemberNotification(Constants.MemberApprovedNotification, _tabId, _moduleId, _roleInfo, groupOwner, member);
NotificationsController.Instance.DeleteAllNotificationRecipients(postData.NotificationId);
return Request.CreateResponse(HttpStatusCode.OK, new {Result = "success"});
}
} catch (Exception exc)
{
Logger.Error(exc);
return Request.CreateErrorResponse(HttpStatusCode.InternalServerError, exc);
}
return Request.CreateErrorResponse(HttpStatusCode.InternalServerError, "Unknown Error");
}
public HttpResponseMessage LeaveGroup(RoleDTO postData)
{
var success = false;
try
{
if (UserInfo.UserID >= 0 && postData.RoleId > 0)
{
var roleController = new RoleController();
_roleInfo = roleController.GetRole(postData.RoleId, PortalSettings.PortalId);
if (_roleInfo != null)
{
if (UserInfo.IsInRole(_roleInfo.RoleName))
{
RoleController.DeleteUserRole(UserInfo, _roleInfo, PortalSettings, false);
}
success = true;
}
}
}
catch (Exception exc)
{
Logger.Error(exc);
return Request.CreateErrorResponse(HttpStatusCode.InternalServerError, exc);
}
if(success)
{
return Request.CreateResponse(HttpStatusCode.OK, new {Result = "success"});
}
return Request.CreateErrorResponse(HttpStatusCode.InternalServerError, "Unknown Error");
}
public HttpResponseMessage JoinGroup(RoleDTO postData)
{
try
{
if (UserInfo.UserID >= 0 && postData.RoleId > 0)
{
var roleController = new RoleController();
_roleInfo = roleController.GetRole(postData.RoleId, PortalSettings.PortalId);
if (_roleInfo != null)
{
var requireApproval = false;
if(_roleInfo.Settings.ContainsKey("ReviewMembers"))
requireApproval = Convert.ToBoolean(_roleInfo.Settings["ReviewMembers"]);
if ((_roleInfo.IsPublic || UserInfo.IsInRole(PortalSettings.AdministratorRoleName)) && !requireApproval)
{
roleController.AddUserRole(PortalSettings.PortalId, UserInfo.UserID, _roleInfo.RoleID, Null.NullDate);
roleController.UpdateRole(_roleInfo);
var url = Globals.NavigateURL(postData.GroupViewTabId, "", new[] { "groupid=" + _roleInfo.RoleID });
return Request.CreateResponse(HttpStatusCode.OK, new { Result = "success", URL = url });
}
if (_roleInfo.IsPublic && requireApproval)
{
roleController.AddUserRole(PortalSettings.PortalId, UserInfo.UserID, _roleInfo.RoleID, RoleStatus.Pending, false, Null.NullDate, Null.NullDate);
var notifications = new Notifications();
notifications.AddGroupOwnerNotification(Constants.MemberPendingNotification, _tabId, _moduleId, _roleInfo, UserInfo);
return Request.CreateResponse(HttpStatusCode.OK, new { Result = "success", URL = string.Empty });
}
}
}
}
catch (Exception exc)
{
Logger.Error(exc);
return Request.CreateErrorResponse(HttpStatusCode.InternalServerError, exc);
}
return Request.CreateErrorResponse(HttpStatusCode.InternalServerError, "Unknown Error");
}
private IList<UserRoleInfo> GetPagedDataSource()
{
var objRoleController = new RoleController();
var roleName = RoleId != Null.NullInteger ? Role.RoleName : Null.NullString;
var userName = UserId != Null.NullInteger ? User.Username : Null.NullString;
var userList = objRoleController.GetUserRoles(PortalId, userName, roleName);
_totalRecords = userList.Count;
_totalPages = _totalRecords%PageSize == 0 ? _totalRecords/PageSize : _totalRecords/PageSize + 1;
return userList.Skip((CurrentPage - 1 )*PageSize).Take(PageSize).ToList();
}
/// -----------------------------------------------------------------------------
/// <summary>
/// GetDates gets the expiry/effective Dates of a Users Role membership
/// </summary>
/// <remarks>
/// </remarks>
/// <param name="UserId">The Id of the User</param>
/// <param name="RoleId">The Id of the Role</param>
/// <history>
/// [cnurse] 9/10/2004 Updated to reflect design changes for Help, 508 support
/// and localisation
/// [cnurse] 01/20/2006 Added support for Effective Date
/// </history>
/// -----------------------------------------------------------------------------
private void GetDates(int UserId, int RoleId)
{
DateTime? expiryDate = null;
DateTime? effectiveDate = null;
var objRoles = new RoleController();
UserRoleInfo objUserRole = objRoles.GetUserRole(PortalId, UserId, RoleId);
if (objUserRole != null)
{
if (Null.IsNull(objUserRole.EffectiveDate) == false)
{
effectiveDate = objUserRole.EffectiveDate;
}
if (Null.IsNull(objUserRole.ExpiryDate) == false)
{
expiryDate = objUserRole.ExpiryDate;
}
}
else //new role assignment
{
RoleInfo objRole = TestableRoleController.Instance.GetRole(PortalId, r => r.RoleID == RoleId);
if (objRole.BillingPeriod > 0)
{
switch (objRole.BillingFrequency)
{
case "D":
expiryDate = DateTime.Now.AddDays(objRole.BillingPeriod);
break;
case "W":
expiryDate = DateTime.Now.AddDays(objRole.BillingPeriod*7);
break;
case "M":
expiryDate = DateTime.Now.AddMonths(objRole.BillingPeriod);
break;
case "Y":
expiryDate = DateTime.Now.AddYears(objRole.BillingPeriod);
break;
}
}
}
effectiveDatePicker.SelectedDate = effectiveDate;
expiryDatePicker.SelectedDate = expiryDate;
}
public void cmdDeleteUserRole_click(object sender, ImageClickEventArgs e)
{
if (PortalSecurity.IsInRole(PortalSettings.AdministratorRoleName) == false)
{
return;
}
try
{
var cmdDeleteUserRole = (ImageButton) sender;
int roleId = Convert.ToInt32(cmdDeleteUserRole.Attributes["roleId"]);
int userId = Convert.ToInt32(cmdDeleteUserRole.Attributes["userId"]);
var roleController = new RoleController();
RoleInfo role = TestableRoleController.Instance.GetRole(PortalId, r => r.RoleID == roleId);
if (!RoleController.DeleteUserRole(UserController.GetUserById(PortalId, userId), role, PortalSettings, chkNotify.Checked))
{
UI.Skins.Skin.AddModuleMessage(this, Localization.GetString("RoleRemoveError", LocalResourceFile), ModuleMessage.ModuleMessageType.RedError);
}
BindGrid();
}
catch (Exception exc)
{
Exceptions.LogException(exc);
UI.Skins.Skin.AddModuleMessage(this, Localization.GetString("RoleRemoveError", LocalResourceFile), ModuleMessage.ModuleMessageType.RedError);
}
}
protected override void OnLoad(EventArgs e)
{
base.OnLoad(e);
try
{
UserInfo objUserInfo = null;
int intUserID = -1;
if (Request.IsAuthenticated)
{
objUserInfo = UserController.GetCurrentUserInfo();
if (objUserInfo != null)
{
intUserID = objUserInfo.UserID;
}
}
int intRoleId = -1;
if (Request.QueryString["roleid"] != null)
{
intRoleId = int.Parse(Request.QueryString["roleid"]);
}
string strProcessorUserId = "";
var objPortalController = new PortalController();
PortalInfo objPortalInfo = objPortalController.GetPortal(PortalSettings.PortalId);
if (objPortalInfo != null)
{
strProcessorUserId = objPortalInfo.ProcessorUserId;
}
Dictionary<string, string> settings = PortalController.GetPortalSettingsDictionary(PortalSettings.PortalId);
string strPayPalURL;
if (intUserID != -1 && intRoleId != -1 && !String.IsNullOrEmpty(strProcessorUserId))
{
// Sandbox mode
if (settings.ContainsKey("paypalsandbox") && !String.IsNullOrEmpty(settings["paypalsandbox"]) && settings["paypalsandbox"] == "true")
{
strPayPalURL = "https://www.sandbox.paypal.com/cgi-bin/webscr?";
}
else
{
strPayPalURL = "https://www.paypal.com/cgi-bin/webscr?";
}
if (Request.QueryString["cancel"] != null)
{
//build the cancellation PayPal URL
strPayPalURL += "cmd=_subscr-find&alias=" + Globals.HTTPPOSTEncode(strProcessorUserId);
}
else
{
strPayPalURL += "cmd=_ext-enter";
var objRoles = new RoleController();
RoleInfo objRole = objRoles.GetRole(intRoleId, PortalSettings.PortalId);
if (objRole.RoleID != -1)
{
int intTrialPeriod = 1;
if (objRole.TrialPeriod != 0)
{
intTrialPeriod = objRole.TrialPeriod;
}
int intBillingPeriod = 1;
if (objRole.BillingPeriod != 0)
{
intBillingPeriod = objRole.BillingPeriod;
}
//explicitely format numbers using en-US so numbers are correctly built
var enFormat = new CultureInfo("en-US");
string strService = string.Format(enFormat.NumberFormat, "{0:#####0.00}", objRole.ServiceFee);
string strTrial = string.Format(enFormat.NumberFormat, "{0:#####0.00}", objRole.TrialFee);
if (objRole.BillingFrequency == "O" || objRole.TrialFrequency == "O")
{
//build the payment PayPal URL
strPayPalURL += "&redirect_cmd=_xclick&business=" + Globals.HTTPPOSTEncode(strProcessorUserId);
strPayPalURL += "&item_name=" +
Globals.HTTPPOSTEncode(PortalSettings.PortalName + " - " + objRole.RoleName + " ( " + objRole.ServiceFee.ToString("#.##") + " " +
PortalSettings.Currency + " )");
strPayPalURL += "&item_number=" + Globals.HTTPPOSTEncode(intRoleId.ToString());
strPayPalURL += "&no_shipping=1&no_note=1";
strPayPalURL += "&quantity=1";
strPayPalURL += "&amount=" + Globals.HTTPPOSTEncode(strService);
strPayPalURL += "¤cy_code=" + Globals.HTTPPOSTEncode(PortalSettings.Currency);
}
else //recurring payments
{
//build the subscription PayPal URL
strPayPalURL += "&redirect_cmd=_xclick-subscriptions&business=" + Globals.HTTPPOSTEncode(strProcessorUserId);
strPayPalURL += "&item_name=" +
Globals.HTTPPOSTEncode(PortalSettings.PortalName + " - " + objRole.RoleName + " ( " + objRole.ServiceFee.ToString("#.##") + " " +
PortalSettings.Currency + " every " + intBillingPeriod + " " + GetBillingFrequencyCode(objRole.BillingFrequency) + " )");
strPayPalURL += "&item_number=" + Globals.HTTPPOSTEncode(intRoleId.ToString());
strPayPalURL += "&no_shipping=1&no_note=1";
if (objRole.TrialFrequency != "N")
{
strPayPalURL += "&a1=" + Globals.HTTPPOSTEncode(strTrial);
strPayPalURL += "&p1=" + Globals.HTTPPOSTEncode(intTrialPeriod.ToString());
strPayPalURL += "&t1=" + Globals.HTTPPOSTEncode(objRole.TrialFrequency);
}
strPayPalURL += "&a3=" + Globals.HTTPPOSTEncode(strService);
strPayPalURL += "&p3=" + Globals.HTTPPOSTEncode(intBillingPeriod.ToString());
strPayPalURL += "&t3=" + Globals.HTTPPOSTEncode(objRole.BillingFrequency);
strPayPalURL += "&src=1";
strPayPalURL += "¤cy_code=" + Globals.HTTPPOSTEncode(PortalSettings.Currency);
}
}
var ctlList = new ListController();
strPayPalURL += "&custom=" + Globals.HTTPPOSTEncode(intUserID.ToString());
strPayPalURL += "&first_name=" + Globals.HTTPPOSTEncode(objUserInfo.Profile.FirstName);
strPayPalURL += "&last_name=" + Globals.HTTPPOSTEncode(objUserInfo.Profile.LastName);
try
{
if (objUserInfo.Profile.Country == "United States")
{
ListEntryInfo colList = ctlList.GetListEntryInfo("Region", objUserInfo.Profile.Region);
strPayPalURL += "&address1=" +
Globals.HTTPPOSTEncode(Convert.ToString(!String.IsNullOrEmpty(objUserInfo.Profile.Unit) ? objUserInfo.Profile.Unit + " " : "") +
objUserInfo.Profile.Street);
strPayPalURL += "&city=" + Globals.HTTPPOSTEncode(objUserInfo.Profile.City);
strPayPalURL += "&state=" + Globals.HTTPPOSTEncode(colList.Value);
strPayPalURL += "&zip=" + Globals.HTTPPOSTEncode(objUserInfo.Profile.PostalCode);
}
}
catch (Exception ex)
{
//issue getting user address
DnnLog.Error(ex);
}
//Return URL
if (settings.ContainsKey("paypalsubscriptionreturn") && !string.IsNullOrEmpty(settings["paypalsubscriptionreturn"]))
{
strPayPalURL += "&return=" + Globals.HTTPPOSTEncode(settings["paypalsubscriptionreturn"]);
}
else
{
strPayPalURL += "&return=" + Globals.HTTPPOSTEncode(Globals.AddHTTP(Globals.GetDomainName(Request)));
}
//Cancellation URL
if (settings.ContainsKey("paypalsubscriptioncancelreturn") && !string.IsNullOrEmpty(settings["paypalsubscriptioncancelreturn"]))
{
strPayPalURL += "&cancel_return=" + Globals.HTTPPOSTEncode(settings["paypalsubscriptioncancelreturn"]);
}
else
{
strPayPalURL += "&cancel_return=" + Globals.HTTPPOSTEncode(Globals.AddHTTP(Globals.GetDomainName(Request)));
}
//Instant Payment Notification URL
if (settings.ContainsKey("paypalsubscriptionnotifyurl") && !string.IsNullOrEmpty(settings["paypalsubscriptionnotifyurl"]))
{
strPayPalURL += "¬ify_url=" + Globals.HTTPPOSTEncode(settings["paypalsubscriptionnotifyurl"]);
}
else
{
strPayPalURL += "¬ify_url=" + Globals.HTTPPOSTEncode(Globals.AddHTTP(Globals.GetDomainName(Request)) + "/admin/Sales/PayPalIPN.aspx");
}
strPayPalURL += "&sra=1"; //reattempt on failure
}
//redirect to PayPal
Response.Redirect(strPayPalURL, true);
}
else
{
if ((settings.ContainsKey("paypalsubscriptioncancelreturn") && !string.IsNullOrEmpty(settings["paypalsubscriptioncancelreturn"])))
{
strPayPalURL = settings["paypalsubscriptioncancelreturn"];
}
else
{
strPayPalURL = Globals.AddHTTP(Globals.GetDomainName(Request));
}
//redirect to PayPal
Response.Redirect(strPayPalURL, true);
}
}
catch (Exception exc) //Page failed to load
{
Exceptions.ProcessPageLoadException(exc);
}
}
private void GetControl(string view, string options)
{
try
{
if (!Page.IsPostBack)
{
plhLoader.Controls.Clear();
}
ForumBase ctl = null;
if (view.ToUpperInvariant() == "FORUMVIEW")
{
ctl = (ForumBase)(new DotNetNuke.Modules.ActiveForums.Controls.ForumView());
}
else if (view.ToUpperInvariant() == "ADVANCED")
{
ctl = (ForumBase)(LoadControl("~/desktopmodules/activeforums/advanced.ascx"));
}
else if ((view.ToUpperInvariant() == Views.Topics.ToUpperInvariant()) || (view.ToUpperInvariant() == "topics".ToUpperInvariant()))
{
ctl = (ForumBase)(new DotNetNuke.Modules.ActiveForums.Controls.TopicsView());
}
else if ((view.ToUpperInvariant() == Views.Topic.ToUpperInvariant()) || (view.ToUpperInvariant() == "topic".ToUpperInvariant()))
{
ctl = (ForumBase)(new DotNetNuke.Modules.ActiveForums.Controls.TopicView());
}
else if (view.ToUpperInvariant() == "USERSETTINGS".ToUpperInvariant())
{
string ctlPath = string.Empty;
ctlPath = "~/DesktopModules/ActiveForums/controls/af_profile.ascx";
if (!(System.IO.File.Exists(Server.MapPath(ctlPath))))
{
ctl = (ForumBase)(new DotNetNuke.Modules.ActiveForums.Controls.ForumView());
}
else
{
ctl = (ForumBase)(LoadControl(ctlPath));
}
}
else
{
string ctlPath = string.Empty;
ctlPath = "~/DesktopModules/ActiveForums/controls/af_" + view + ".ascx";
if (!(System.IO.File.Exists(Server.MapPath(ctlPath))))
{
ctl = (ForumBase)(new DotNetNuke.Modules.ActiveForums.Controls.ForumView());
}
else
{
ctl = (ForumBase)(LoadControl(ctlPath));
}
}
if (ForumId > 0 & ForumInfo != null)
{
ctl.ForumInfo = ForumInfo;
}
ctl.ID = view;
ctl.ForumId = ForumId;
ctl.ForumModuleId = ForumModuleId;
if (ForumTabId == -1)
{
ForumTabId = TabId;
}
ctl.ForumTabId = ForumTabId;
ctl.ForumGroupId = ForumGroupId;
ctl.DefaultForumViewTemplateId = DefaultForumViewTemplateId;
ctl.DefaultTopicsViewTemplateId = DefaultTopicsViewTemplateId;
ctl.DefaultTopicViewTemplateId = DefaultTopicViewTemplateId;
ctl.UseTemplatePath = UseTemplatePath;
ctl.TemplatePath = TemplatePath;
ctl.ParentForumId = ParentForumId;
if (string.IsNullOrEmpty(ForumIds))
{
ForumIds = UserForumsList;
}
if (SocialGroupId > 0)
{
ForumController fc = new ForumController();
ForumIds = fc.GetForumIdsBySocialGroup(PortalId, SocialGroupId);
if (string.IsNullOrEmpty(ForumIds))
{
RoleController rc = new RoleController();
RoleInfo role = rc.GetRole(SocialGroupId, PortalId);
//Create new forum
bool isPrivate = false;
if (!role.IsPublic)
{
isPrivate = true;
}
Entities.Modules.ModuleController objModules = new Entities.Modules.ModuleController();
Hashtable htSettings = objModules.GetTabModuleSettings(TabModuleId);
fc.CreateGroupForum(PortalId, ModuleId, SocialGroupId, Convert.ToInt32(htSettings["ForumGroupTemplate"].ToString()), role.RoleName + " Discussions", role.Description, isPrivate, htSettings["ForumConfig"].ToString());
ForumIds = fc.GetForumIdsBySocialGroup(PortalId, SocialGroupId);
}
}
ctl.ForumIds = ForumIds;
ctl.SocialGroupId = SocialGroupId;
//ctl.PostID = PostID
ctl.ModuleConfiguration = this.ModuleConfiguration;
if (!(options == string.Empty))
{
ctl.Params = options;
}
ControlsConfig cc = new ControlsConfig();
cc.AppPath = Page.ResolveUrl("~/DesktopModules/ActiveForums/");
cc.ThemePath = Page.ResolveUrl("~/DesktopModules/ActiveForums/themes/" + MainSettings.Theme + "/");
cc.TemplatePath = cc.ThemePath + "templates/";
cc.SiteId = PortalId;
cc.PageId = TabId;
cc.InstanceId = ModuleId;
cc.User = ForumUser;
cc.DefaultViewRoles = Permissions.GetRoleIds(this.ModuleConfiguration.AuthorizedViewRoles.Split(';'), PortalId);
cc.AdminRoles = Permissions.GetRoleIds(this.ModuleConfiguration.AuthorizedEditRoles.Split(';'), PortalId);
cc.ProfileLink = ""; //GetProfileLink()
cc.MembersLink = ""; // GetMembersLink()
this.ControlConfig = cc;
ctl.ControlConfig = cc;
LinkControls(ctl.Controls);
if (!(plhLoader.Controls.Contains(ctl)))
{
plhLoader.Controls.Add(ctl);
}
string sOut = null;
sOut = System.Environment.NewLine + "<!-- © 2004 - 2013 DNN Corp., All Rights Reserved -->" + System.Environment.NewLine;
sOut += "<!-- Active Forums 5.0 -->" + System.Environment.NewLine;
Literal lit = new Literal();
lit.Text = sOut;
plhLoader.Controls.Add(lit);
}
catch (Exception ex)
{
DotNetNuke.Services.Exceptions.Exceptions.ProcessModuleLoadException(this, ex);
}
}
/// <summary>
/// Handles the Load event of the Page control.
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="EventArgs"/> instance containing the event data.</param>
protected void Page_Load(object sender, EventArgs e)
{
this.SortAscending.CssClass = this.SortFilesDescending ? "ButtonNormal" : "ButtonSelected";
this.SortDescending.CssClass = !this.SortFilesDescending ? "ButtonNormal" : "ButtonSelected";
this.extensionWhiteList = HostController.Instance.GetString("FileExtensions").ToLower();
if (!string.IsNullOrEmpty(this.request.QueryString["mode"]))
{
this.currentSettings.SettingMode =
(SettingsMode)Enum.Parse(typeof(SettingsMode), this.request.QueryString["mode"]);
}
ProviderConfiguration providerConfiguration = ProviderConfiguration.GetProviderConfiguration("htmlEditor");
Provider objProvider = (Provider)providerConfiguration.Providers[providerConfiguration.DefaultProvider];
var settingsDictionary = Utility.GetEditorHostSettings();
var portalRoles = new RoleController().GetPortalRoles(this._portalSettings.PortalId);
switch (this.currentSettings.SettingMode)
{
case SettingsMode.Default:
// Load Default Settings
this.currentSettings = SettingsUtil.GetDefaultSettings(
this._portalSettings,
this._portalSettings.HomeDirectoryMapPath,
objProvider.Attributes["ck_configFolder"],
portalRoles);
break;
case SettingsMode.Portal:
this.currentSettings = SettingsUtil.LoadPortalOrPageSettings(
this._portalSettings,
this.currentSettings,
settingsDictionary,
string.Format("DNNCKP#{0}#", this.request.QueryString["PortalID"]),
portalRoles);
break;
case SettingsMode.Page:
this.currentSettings = SettingsUtil.LoadPortalOrPageSettings(
this._portalSettings,
this.currentSettings,
settingsDictionary,
string.Format("DNNCKT#{0}#", this.request.QueryString["tabid"]),
portalRoles);
break;
case SettingsMode.ModuleInstance:
this.currentSettings = SettingsUtil.LoadModuleSettings(
this._portalSettings,
this.currentSettings,
string.Format(
"DNNCKMI#{0}#INS#{1}#", this.request.QueryString["mid"], this.request.QueryString["ckId"]),
int.Parse(this.request.QueryString["mid"]),
portalRoles);
break;
}
if (this.currentSettings.BrowserMode.Equals(Constants.Browser.StandardBrowser)
&& HttpContext.Current.Request.IsAuthenticated)
{
string command = null;
try
{
if (this.request.QueryString["Command"] != null)
{
command = this.request.QueryString["Command"];
}
}
catch (Exception)
{
command = null;
}
try
{
if (this.request.QueryString["Type"] != null)
{
this.browserModus = this.request.QueryString["Type"];
this.lblModus.Text = string.Format("Browser-Modus: {0}", this.browserModus);
if (!this.IsPostBack)
{
this.OverrideFile.Checked = this.currentSettings.OverrideFileOnUpload;
this.title.InnerText = string.Format("{0} - WatchersNET.FileBrowser", this.lblModus.Text);
this.AnchorList.Visible = this.currentSettings.UseAnchorSelector;
this.LabelAnchor.Visible = this.currentSettings.UseAnchorSelector;
this.ListViewState.Value = this.currentSettings.FileListViewMode.ToString();
// Set default link mode
switch (this.currentSettings.DefaultLinkMode)
{
case LinkMode.RelativeURL:
this.rblLinkType.SelectedValue = "relLink";
break;
case LinkMode.AbsoluteURL:
this.rblLinkType.SelectedValue = "absLnk";
break;
case LinkMode.RelativeSecuredURL:
this.rblLinkType.SelectedValue = "lnkClick";
break;
case LinkMode.AbsoluteSecuredURL:
this.rblLinkType.SelectedValue = "lnkAbsClick";
break;
}
switch (this.browserModus)
{
case "Link":
this.BrowserMode.Visible = true;
if (this.currentSettings.ShowPageLinksTabFirst)
{
this.BrowserMode.SelectedValue = "page";
this.panLinkMode.Visible = false;
this.panPageMode.Visible = true;
this.TrackClicks.Visible = false;
this.lblModus.Text = string.Format(
"Browser-Modus: {0}", string.Format("Page {0}", this.browserModus));
this.title.InnerText = string.Format(
"{0} - WatchersNET.FileBrowser", this.lblModus.Text);
this.RenderTabs();
}
else
{
this.BrowserMode.SelectedValue = "file";
this.panPageMode.Visible = false;
}
break;
case "Image":
this.BrowserMode.Visible = false;
this.panPageMode.Visible = false;
break;
case "Flash":
this.BrowserMode.Visible = false;
this.panPageMode.Visible = false;
break;
default:
this.BrowserMode.Visible = false;
this.panPageMode.Visible = false;
break;
}
}
}
}
catch (Exception)
{
this.browserModus = null;
}
if (command != null)
{
if (!command.Equals("FileUpload") && !command.Equals("FlashUpload")
&& !command.Equals("ImageUpload"))
{
return;
}
var uploadedFile =
HttpContext.Current.Request.Files[HttpContext.Current.Request.Files.AllKeys[0]];
if (uploadedFile != null)
{
this.UploadFile(uploadedFile, command);
}
}
else
{
if (!this.IsPostBack)
{
this.SetLanguage();
this.GetLanguageList();
var startFolder = this.StartingDir();
if (!Utility.IsInRoles(this._portalSettings.AdministratorRoleName, this._portalSettings))
{
// Hide physical file Path
this.lblCurrentDir.Visible = false;
this.lblCurrent.Visible = false;
}
this.FillFolderTree(startFolder);
bool folderSelected = false;
if (!string.IsNullOrEmpty(ckFileUrl))
{
try
{
folderSelected = this.SelectFolderFile(ckFileUrl);
ckFileUrl = null;
}
catch (Exception)
{
folderSelected = false;
ckFileUrl = null;
}
}
if (!folderSelected)
{
this.lblCurrentDir.Text = startFolder.PhysicalPath;
this.ShowFilesIn(startFolder);
}
}
this.FillQualityPrecentages();
}
}
else
{
var errorScript = string.Format(
"javascript:alert('{0}');self.close();",
Localization.GetString("Error1.Text", this.ResXFile, this.LanguageCode));
this.Response.Write("<script type=\"text/javascript\">");
this.Response.Write(errorScript);
this.Response.Write("</script>");
this.Response.End();
}
}
/// <summary>
/// Load All Editor Settings
/// </summary>
/// <param name="currentMode">The current mode.</param>
/// <param name="changeMode">if set to <c>true</c> [change mode].</param>
private void LoadSettings(int currentMode, bool changeMode = true)
{
this.CurrentSettingsMode = (SettingsMode)Enum.Parse(typeof(SettingsMode), currentMode.ToString());
this.lnkRemoveAll.Visible = !currentMode.Equals(0);
this.lnkRemoveChild.Visible = !currentMode.Equals(0);
this.CopyToAllChild.Visible = !currentMode.Equals(0);
this.lnkRemove.Text = string.Format(
Localization.GetString("Remove.Text", this.ResXFile, this.LangCode),
this.rBlSetMode.Items[currentMode].Text);
this.lnkRemoveAll.Text =
string.Format(
Localization.GetString("RemoveAll.Text", this.ResXFile, this.LangCode),
this.rBlSetMode.Items[currentMode].Text);
this.lnkRemove.ToolTip = string.Format(
Localization.GetString("Remove.Help", this.ResXFile, this.LangCode),
this.rBlSetMode.Items[currentMode].Text);
this.lnkRemoveAll.ToolTip =
string.Format(
Localization.GetString("RemoveAll.Help", this.ResXFile, this.LangCode),
this.rBlSetMode.Items[currentMode].Text);
this.LoadDefaultSettings();
var settingsDictionary = Utility.GetEditorHostSettings();
var portalRoles = new RoleController().GetPortalRoles(this._portalSettings.PortalId);
var portalKey = string.Format("DNNCKP#{0}#", this._portalSettings.PortalId);
var pageKey = string.Format("DNNCKT#{0}#", this.CurrentOrSelectedTabId);
var moduleKey = string.Format("DNNCKMI#{0}#INS#{1}#", this.ModuleId, this.moduleInstanceName);
var providerConfiguration = ProviderConfiguration.GetProviderConfiguration("htmlEditor");
var objProvider = (Provider)providerConfiguration.Providers[providerConfiguration.DefaultProvider];
var currentSettings = SettingsUtil.GetDefaultSettings(
this._portalSettings,
this._portalSettings.HomeDirectoryMapPath,
objProvider.Attributes["ck_configFolder"],
portalRoles);
switch (this.CurrentSettingsMode)
{
case SettingsMode.Portal:
{
// Load Portal Settings ?!
if (SettingsUtil.CheckExistsPortalOrPageSettings(settingsDictionary, portalKey))
{
currentSettings = new EditorProviderSettings();
currentSettings = SettingsUtil.LoadPortalOrPageSettings(
this._portalSettings, currentSettings, settingsDictionary, portalKey, portalRoles);
// Set Current Mode to Portal
currentSettings.SettingMode = SettingsMode.Portal;
this.lnkRemove.Enabled = true;
}
else
{
this.lnkRemove.Enabled = false;
}
}
break;
case SettingsMode.Page:
{
// Load Page Settings ?!
if (SettingsUtil.CheckExistsPortalOrPageSettings(settingsDictionary, pageKey))
{
currentSettings = new EditorProviderSettings();
currentSettings = SettingsUtil.LoadPortalOrPageSettings(
this._portalSettings, currentSettings, settingsDictionary, pageKey, portalRoles);
// Set Current Mode to Page
currentSettings.SettingMode = SettingsMode.Page;
this.lnkRemove.Enabled = true;
}
else
{
this.lnkRemove.Enabled = false;
}
var currentTab = new TabController().GetTab(
this.CurrentOrSelectedTabId, this._portalSettings.PortalId, false);
this.lnkRemoveChild.Enabled = currentTab.HasChildren;
this.lnkRemoveChild.Text = Localization.GetString(
"RemovePageChild.Text", this.ResXFile, this.LangCode);
this.lnkRemoveChild.ToolTip = Localization.GetString(
"RemovePageChild.Help", this.ResXFile, this.LangCode);
this.CopyToAllChild.Enabled = currentTab.HasChildren;
this.CopyToAllChild.Text = Localization.GetString(
"CopyPageChild.Text", this.ResXFile, this.LangCode);
this.CopyToAllChild.ToolTip = Localization.GetString(
"CopyPageChild.Help", this.ResXFile, this.LangCode);
}
break;
case SettingsMode.ModuleInstance:
{
// Load Module Settings ?!
if (SettingsUtil.CheckExistsModuleInstanceSettings(moduleKey, this.ModuleId))
{
currentSettings = new EditorProviderSettings();
currentSettings = SettingsUtil.LoadModuleSettings(
this._portalSettings, currentSettings, moduleKey, this.ModuleId, portalRoles);
currentSettings.SettingMode = SettingsMode.ModuleInstance;
this.lnkRemove.Enabled = true;
}
else
{
this.lnkRemove.Enabled = false;
}
this.lnkRemoveChild.Enabled = true;
this.lnkRemoveChild.Text = Localization.GetString(
"RemoveModuleChild.Text", this.ResXFile, this.LangCode);
this.lnkRemoveChild.ToolTip = Localization.GetString(
"RemoveModuleChild.Help", this.ResXFile, this.LangCode);
}
break;
}
if (currentSettings != null)
{
this.FillSettings(currentSettings, changeMode);
}
}
protected void BT_Refresh_AAR_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection(Config.GetConnectionString());
try
{
conn.Open();
int annee = Functions.GetRotaryYear();
DotNetNuke.Security.Roles.RoleController rc = new DotNetNuke.Security.Roles.RoleController();
RoleInfo uri = rc.GetRoleByName(Globals.GetPortalSettings().PortalId, Const.ROLE_ADMIN_CLUB);
ArrayList users = rc.GetUsersByRoleName(PortalId, Const.ROLE_ADMIN_CLUB);
foreach (UserInfo user in users)
{
rc.DeleteUserRole(Globals.GetPortalSettings().PortalId, user.UserID, uri.RoleID);
}
SqlCommand sql = new SqlCommand("SELECT nim,name FROM " + Const.TABLE_PREFIX + "rya WHERE rotary_year IN (" + annee + "," + (annee + 1) + ")", conn);
SqlDataAdapter da = new SqlDataAdapter(sql);
DataSet ds = new DataSet();
da.Fill(ds);
foreach (DataRow row in ds.Tables[0].Rows)
{
cestbon:
Member membre = DataMapping.GetMemberByNim((int)row["nim"]);
if (membre != null)
{
if (membre.userid == 0)
{
TXT_Result.Text += "<br/>Le membre : " + row["name"] + " n'a pas de user DNN";
if (DataMapping.UpdateOrCreateUser(membre.id, membre.email))
{
TXT_Result.Text += "<br/>et a été créé";
goto cestbon;
}
else
{
TXT_Result.Text += "<br/>et n'a pas été créé";
}
}
else
{
UserInfo ui = UserController.GetUserByName(Globals.GetPortalSettings().PortalId, membre.email);
if (ui != null)
{
rc.AddUserRole(Globals.GetPortalSettings().PortalId, ui.UserID, uri.RoleID, Null.NullDate, Null.NullDate);
TXT_Result.Text += "<br/>Ajout role admin club : " + row["name"];
}
}
}
}
}
catch (Exception ee)
{
TXT_Result.Text += ee.ToString();
}
finally
{
conn.Close();
}
}
/// -----------------------------------------------------------------------------
/// <summary>
/// BindData gets the roles from the Database and binds them to the DataGrid
/// </summary>
/// <remarks>
/// </remarks>
/// <history>
/// [cnurse] 9/10/2004 Updated to reflect design changes for Help, 508 support
/// and localisation
/// [cnurse] 01/05/2006 Updated to reflect Use of Role Groups
/// </history>
/// -----------------------------------------------------------------------------
private void BindData()
{
//Get the portal's roles from the database
var objRoles = new RoleController();
var arrRoles = _roleGroupId < -1 ? objRoles.GetPortalRoles(PortalId) : objRoles.GetRolesByGroup(PortalId, _roleGroupId);
grdRoles.DataSource = arrRoles;
if (_roleGroupId < 0)
{
lnkEditGroup.Visible = false;
cmdDelete.Visible = false;
}
else
{
lnkEditGroup.Visible = true;
lnkEditGroup.NavigateUrl = EditUrl("RoleGroupId", _roleGroupId.ToString(), "EditGroup");
cmdDelete.Visible = arrRoles.Count == 0;
}
Localization.LocalizeDataGrid(ref grdRoles, LocalResourceFile);
grdRoles.DataBind();
}
/// <summary>
/// Gets the edit rights for user roles and binds them to the respective list control
/// </summary>
private void BindRights()
{
// declare variables
ArrayList arrAvailableAuthViewRoles = new ArrayList();
ArrayList arrAvailableNotifyRoles = new ArrayList();
ArrayList arrAssignedAuthViewRoles = new ArrayList();
ArrayList arrAssignedNotifyRoles = new ArrayList();
Array arrAuthViewRoles = null;
Array arrAuthNotifyRoles = null;
// add an entry of All Users for the View roles
arrAvailableAuthViewRoles.Add(new ListItem("All Users", DotNetNuke.Common.Globals.glbRoleAllUsersName));
// add an entry of Unauthenticated Users for the View roles
arrAvailableAuthViewRoles.Add(new ListItem("Unauthenticated Users", DotNetNuke.Common.Globals.glbRoleUnauthUserName));
// process portal roles
DotNetNuke.Security.Roles.RoleController objRoles = new DotNetNuke.Security.Roles.RoleController();
var arrRoles = objRoles.GetPortalRoles(PortalId).OfType <RoleInfo>();
foreach (var objRole in arrRoles)
{
arrAvailableAuthViewRoles.Add(new ListItem(objRole.RoleName, objRole.RoleName));
arrAvailableNotifyRoles.Add(new ListItem(objRole.RoleName, objRole.RoleName));
}
// populate view roles
if (this.mSettingsModel.ContentEditorRoles.Equals(StrUseDNNSettings))
{
arrAuthViewRoles = this.mSettingsModel.ContentEditorRoles.Split(new string[] { StrUseDNNSettings }, StringSplitOptions.RemoveEmptyEntries);
}
else
{
arrAuthViewRoles = this.mSettingsModel.ContentEditorRoles.Split(
new char[] { '|' }, StringSplitOptions.RemoveEmptyEntries)[0]
.Split(new char[] { ';' }, StringSplitOptions.RemoveEmptyEntries);
}
// populate the notify roles
if (!string.IsNullOrWhiteSpace(this.mSettingsModel.CommentNotifyRoles))
{
if (this.mSettingsModel.CommentNotifyRoles.StartsWith("UseDNNSettings;"))
{
this.mSettingsModel.CommentNotifyRoles = this.mSettingsModel.CommentNotifyRoles.Replace("UseDNNSettings;", string.Empty);
arrAuthNotifyRoles = this.mSettingsModel.CommentNotifyRoles.Split(new char[] { ';' }, StringSplitOptions.RemoveEmptyEntries);
foreach (string curRole in arrAuthNotifyRoles)
{
if (curRole.Equals("View"))
{
this.NotifyMethodViewRoles.Checked = true;
}
else if (curRole.Equals("Edit"))
{
this.NotifyMethodEditRoles.Checked = true;
}
}
}
else
{
arrAuthNotifyRoles = this.mSettingsModel.CommentNotifyRoles.Split(new char[] { '|' })[0].Split(new char[] { ';' });
}
}
if (arrAuthViewRoles != null)
{
foreach (string strRole in arrAuthViewRoles)
{
if (!string.IsNullOrEmpty(strRole))
{
foreach (ListItem objListItem in arrAvailableAuthViewRoles)
{
if (objListItem.Value == strRole)
{
arrAssignedAuthViewRoles.Add(objListItem);
arrAvailableAuthViewRoles.Remove(objListItem);
break;
}
}
}
}
}
if (arrAuthNotifyRoles != null)
{
foreach (string strRole in arrAuthNotifyRoles)
{
if (!string.IsNullOrEmpty(strRole))
{
foreach (ListItem objListItem in arrAvailableNotifyRoles)
{
if (objListItem.Value == strRole)
{
arrAssignedNotifyRoles.Add(objListItem);
arrAvailableNotifyRoles.Remove(objListItem);
break;
}
}
}
}
}
int x = arrAvailableAuthViewRoles.Count; // TODO Do we need this?
int y = arrAssignedAuthViewRoles.Count; // TODO Do we need this?
this.ContentEditors.Available = arrAvailableAuthViewRoles;
this.ContentEditors.Assigned = arrAssignedAuthViewRoles;
this.NotifyRoles.Assigned = arrAssignedNotifyRoles;
this.NotifyRoles.Available = arrAvailableNotifyRoles;
}
protected void BT_Maj_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection(Config.GetConnectionString());
try
{
conn.Open();
TXT_Result.Text = "<br/>";
/****** Script de la commande SelectTopNRows à partir de SSMS ******/
SqlCommand sql = new SqlCommand("SELECT * FROM [admin_club] where open_passwd !='' and fonction like 'new_%' and cric !='' and cric is not null", conn);
SqlDataAdapter da = new SqlDataAdapter(sql);
DataSet ds = new DataSet();
da.Fill(ds);
foreach (DataRow row in ds.Tables[0].Rows)
{
sql = new SqlCommand("SELECT id FROM " + Const.TABLE_PREFIX + "members WHERE nim=@nim", conn);
sql.Parameters.AddWithValue("nim", row["nim"]);
string id = "" + sql.ExecuteScalar();
int idn = 0;
int.TryParse(id, out idn);
if (idn != 0)
{
Member member = DataMapping.GetMember(idn);
if (member.userid == 0)
{
UserInfo ui = UserController.GetUserByName(Globals.GetPortalSettings().PortalId, member.email);
if (ui == null && member != null)
{
TXT_Result.Text += "Creation : " + member.surname + " " + member.name + "<br/>";
ui = new UserInfo();
ui.Username = member.email;
ui.FirstName = member.name;
ui.LastName = member.surname;
ui.DisplayName = member.name + " " + member.surname;
ui.Email = member.email;
ui.IsSuperUser = false;
ui.PortalID = Globals.GetPortalSettings().PortalId;
UserMembership mb = new UserMembership(ui);
mb.Approved = true;
mb.CreatedDate = System.DateTime.Now;
mb.IsOnLine = false;
string password = "" + DateTime.Now.Ticks;
password = "" + row["open_passwd"];
//password = "******";
mb.Password = password;
ui.Membership = mb;
if (UserCreateStatus.Success == UserController.CreateUser(ref ui))
{
DotNetNuke.Security.Roles.RoleController rc = new DotNetNuke.Security.Roles.RoleController();
RoleInfo uri = rc.GetRoleByName(Globals.GetPortalSettings().PortalId, Const.ROLE_MEMBERS);
rc.AddUserRole(Globals.GetPortalSettings().PortalId, ui.UserID, uri.RoleID, Null.NullDate, Null.NullDate);
TXT_Result.Text += DataMapping.UpdateMemberDNNUserID(member.id, ui.UserID) + "<br/>";
}
}
}
}
else
{
TXT_Result.Text += "NIM inconnu : " + row["nim"] + " " + row["surname"] + " " + row["name"] + "<br/>";
}
}
}
catch (Exception ee)
{
TXT_Result.Text += ee.ToString();
}
finally
{
conn.Close();
}
}
/// <summary>
/// 绑定数据项
/// </summary>
private void BindDataItem()
{
Playngo_ClientZone_Event Event = EventItem;
TemplateFormat xf = new TemplateFormat(this);
//验证文章是否存在
if (EventID > 0 && (Event == null || EventID != Event.ID))
{
//需要给出提示,载入文章错误
mTips.LoadMessage("LoadingEventError", EnumTips.Error, this, new String[] { "" });
Response.Redirect(xUrl("Events"), false);
}
if (Event == null)
{
Event = new Playngo_ClientZone_Event();
}
//这里需要验证一下权限,当作者进入到别人的文章时，需要跳到列表页面
if (Event != null && Event.ID > 0 && (!IsAdministrator && !IsAdmin) && Event.CreateUser != UserId)
{
//需要给出提示,你无权编辑其他作者的文章
mTips.LoadMessage("NoPermissionEventAlert", EnumTips.Warning, this, new String[] { Event.Title });
Response.Redirect(xUrl("Events"), false);
}
if (Event != null && Event.ID > 0)
{
liLastUpdated.Text = Event.LastTime.ToString("MM/dd/yyyy hh:mm tt", System.Globalization.DateTimeFormatInfo.InvariantInfo);
}
//导出CSV链接
hlExportCSV.NavigateUrl = xf.GoDownloadCSVToEventUrl(Event);
txtTitle.Text = Common.RestoreEscape(Event.Title);
txtContentText.Text = HttpUtility.HtmlDecode(Event.ContentText);
txtAddress.Text = Event.Address;
txtLocationX.Text = Event.LocationX;
txtLocationY.Text = Event.LocationY;
cbIncludeNotification.Checked = Event.NotifyInclude == 1;
WebHelper.SelectedListByValue(ddlNotificationStatus, Event.NotifyStatus);
cbNotifySubscribers.Checked = Event.NotifySubscribers == 1;
txtStartDate.Text = Event.StartTime.ToString("MM/dd/yyyy", System.Globalization.DateTimeFormatInfo.InvariantInfo);
txtStartTime.Text = Event.StartTime.ToString("HH:mm:ss", System.Globalization.DateTimeFormatInfo.InvariantInfo);
txtReleaseDate.Text = Event.ReleaseDate.ToString("MM/dd/yyyy", System.Globalization.DateTimeFormatInfo.InvariantInfo);
txtReleaseTime.Text = Event.ReleaseDate.ToString("HH:mm:ss", System.Globalization.DateTimeFormatInfo.InvariantInfo);
txtDisableDate.Text = Event.EndTime.ToString("MM/dd/yyyy", System.Globalization.DateTimeFormatInfo.InvariantInfo);
txtDisableTime.Text = Event.EndTime.ToString("HH:mm:ss", System.Globalization.DateTimeFormatInfo.InvariantInfo);
//增加权限用户
DotNetNuke.Security.Roles.RoleController rc = new DotNetNuke.Security.Roles.RoleController();
WebHelper.BindList(cblPermissionsRoles, rc.GetPortalRoles(PortalId), "RoleName", "RoleName");
WebHelper.SelectedListMultiByValue(cblPermissionsRoles, Event.Per_Roles);
cbPermissionsAllUsers.Checked = Event.Per_AllUsers == 0;
//区域
cbAllJurisdictions.Checked = Event.Per_AllJurisdictions == 0;
WebHelper.BindList(cblJurisdictions, Playngo_ClientZone_Jurisdiction.GetAllCheckList(ModuleId), "Name", "ID");
WebHelper.SelectedListMultiByValue(cblJurisdictions, Event.Per_Jurisdictions);
Event.CreateUser = Event.CreateUser == 0 ? UserId : Event.CreateUser;
UserInfo CreateUserInfo = UserController.GetUserById(PortalId, Event.CreateUser);
hfEventAuthor.Value = Event.CreateUser.ToString();
lbEventAuthor.Text = CreateUserInfo != null && CreateUserInfo.UserID > 0 ? CreateUserInfo.DisplayName : "None";
imgEventAuthor.ImageUrl = ViewUserPic(CreateUserInfo);
WebHelper.SelectedListByValue(ddlEventStatus, Event.Status); //管理员看到的文章状态
}