public static string DeleteMember(int memberId)
{
int _currentMember = HttpContext.Current.User.Identity.IsAuthenticated ? (int)Membership.GetUser().ProviderUserKey : 0;
//Check if member is an admin (in group 'admin')
if (Utils.IsHq(_currentMember))
{
//Lets check the memberID of the member we are blocking passed into /base is a valid member..
//Yep - it's valid, lets get that member
var member = Utils.GetMember(memberId);
Membership.DeleteUser(member.LoginName, true);
using (var sqlHelper = Application.SqlHelper)
{
sqlHelper.ExecuteNonQuery("UPDATE forumForums SET latestAuthor = 0 WHERE latestAuthor = @memberId",
sqlHelper.CreateParameter("@memberId", memberId));
}
//It's all good...
return("true");
}
//Member not authorised or memberID passed in is not valid
return("false");
}
public static string GetBlockedMembers()
{
var currentMember = HttpContext.Current.User.Identity.IsAuthenticated ? (int)Membership.GetUser().ProviderUserKey : 0;
//Check if member is an admin (in group 'admin')
//Member not authorised or memberID passed in is not valid
if (Utils.IsHq(currentMember) == false)
{
return(string.Empty);
}
var returnValue = string.Empty;
const string blockedMembersQuery = "SELECT contentNodeId FROM cmsPropertyData WHERE propertytypeid = (SELECT id FROM cmsPropertyType WHERE alias = 'blocked') AND dataInt = 1";
using (var reader = Application.SqlHelper.ExecuteReader(blockedMembersQuery))
{
while (reader.Read())
{
var memberId = reader.GetInt("contentNodeId");
returnValue = returnValue + "<a href=\"/member/" + memberId + "\">" + memberId + "</a><br />";
}
}
//It's all good...
return(returnValue);
}
