public static int AddRole(DNNContext context, int portalId, int roleGroupID, string roleName)
{
int RoleID = -1;
var cmd = context.GetCommand("{databaseOwner}{objectQualifier}AddRole")
.AddParameter("PortalID", portalId)
.AddParameter("RoleGroupId", roleGroupID == -1 ? (object)DBNull.Value : roleGroupID)
.AddParameter("RoleName", roleName)
.AddParameter("Description", "")
.AddParameter("ServiceFee", 0)
.AddParameter("BillingPeriod", -1)
.AddParameter("BillingFrequency", "N")
.AddParameter("TrialFee", 0)
.AddParameter("TrialPeriod", -1)
.AddParameter("TrialFrequency", "N")
.AddParameter("IsPublic", false)
.AddParameter("AutoAssignment", false)
.AddParameter("RSVPCode", DBNull.Value)
.AddParameter("IconFile", DBNull.Value)
.AddParameter("CreatedByUserID", -1)
.AddParameter("Status", 1)
.AddParameter("SecurityMode", 0)
.AddParameter("IsSystemRole", false);
cmd.CommandType = CommandType.StoredProcedure;
RoleID = Convert.ToInt32(cmd.ExecuteScalar());
return(RoleID);
}
public static void AddUserToRole(DNNContext context, int portalId, int userId, string roleName)
{
var cmd = context.GetCommand(Sql.SqlScripts.GetScript("AddUserToRole", context.DNNVersion))
.AddParameter("PortalID", portalId)
.AddParameter("UserID", userId)
.AddParameter("Rolename", roleName);
cmd.ExecuteNonQuery();
}
public static int GetOrCreateRoleGroupIdByName(DNNContext context, int portalId, string roleGroupName)
{
int RoleGroupID = -1;
if (!string.IsNullOrEmpty(roleGroupName))
{
var cmd = context.GetCommand(Sql.SqlScripts.GetScript("SetRoleGroup", context.DNNVersion))
.AddParameter("PortalID", portalId)
.AddParameter("RoleGroupName", roleGroupName);
RoleGroupID = Convert.ToInt32(cmd.ExecuteScalar());
cmd.Dispose();
}
return(RoleGroupID);
}
public static int GetRoleIdByName(DNNContext context, int portalId, string roleName)
{
int RoleID = -1;
var cmd = context.GetCommand("SELECT RoleID FROM {databaseOwner}{objectQualifier}Roles WHERE PortalId=@PortalID AND Rolename=@Rolename")
.AddParameter("PortalID", portalId)
.AddParameter("RoleName", roleName);
object res = cmd.ExecuteScalar();
if (res != null)
{
RoleID = Convert.ToInt32(res);
}
cmd.Dispose();
return(RoleID);
}
public static int AddUser(DNNContext context, int portalId, string userName, string password, string email, string firstName, string lastName, string displayName)
{
var cmd = context.GetCommand("{databaseOwner}[aspnet_Membership_CreateUser]")
.AddParameter("ApplicationName", "DotNetNuke")
.AddParameter("UserName", userName)
.AddParameter("Password", password)
.AddParameter("PasswordSalt", Globals.EncodeBase64((new Guid()).ToString()))
.AddParameter("Email", email)
.AddParameter("PasswordQuestion", DBNull.Value)
.AddParameter("PasswordAnswer", DBNull.Value)
.AddParameter("IsApproved", true)
.AddParameter("CurrentTimeUtc", DateTime.Now.ToUniversalTime())
.AddParameter("CreateDate", DateTime.Now.ToUniversalTime())
.AddParameter("UniqueEmail", false)
.AddParameter("PasswordFormat", 0)
.AddOutputParameter("UserId", SqlDbType.UniqueIdentifier);
cmd.CommandType = CommandType.StoredProcedure;
cmd.ExecuteNonQuery();
cmd.Dispose();
int UserId = -1;
cmd = context.GetCommand("{databaseOwner}{objectQualifier}AddUser")
.AddParameter("PortalID", portalId)
.AddParameter("Username", userName)
.AddParameter("Firstname", firstName)
.AddParameter("Lastname", lastName)
.AddParameter("AffiliateId", DBNull.Value)
.AddParameter("IsSuperUser", false)
.AddParameter("Email", email)
.AddParameter("DisplayName", displayName)
.AddParameter("UpdatePassword", false)
.AddParameter("Authorised", true);
cmd.CommandType = CommandType.StoredProcedure;
if (context.DNNVersion >= new Version("05.00.00"))
{
cmd.AddParameter("CreatedByUserID", 0);
}
UserId = Convert.ToInt32(cmd.ExecuteScalar());
cmd = context.GetCommand("INSERT INTO {databaseOwner}[{objectQualifier}UserRoles] ([UserID],[RoleID],[ExpiryDate],[IsTrialUsed],[EffectiveDate]) SELECT @UserID, r.RoleId, NULL, NULL, NULL FROM {databaseOwner}[{objectQualifier}Roles] r WHERE r.AutoAssignment=1 AND r.PortalID=@PortalID")
.AddParameter("PortalID", portalId)
.AddParameter("UserID", UserId);
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();
return(UserId);
}
/// <summary>
/// Initializes AngularJSTemplateEngine
/// </summary>
/// <param name="DNNContext"></param>
public AngularJSTemplateEngine(DNNContext DNNContext)
{
this.DNNContext = DNNContext;
}
/// <summary>
/// Initializes the DNNTokenEngine
/// </summary>
/// <param name="DNNContext"></param>
public DNNTokenEngine(DNNContext DNNContext)
{
this.DNNContext = DNNContext;
}
