public static void AddForumModerator(int forumid, int memberid)
{
ForumModeratorInfo moderator = new ForumModeratorInfo {ForumId = forumid, MemberId = memberid};
IForumModerator dal = Factory<IForumModerator>.Create("ForumModerator");
dal.Add(moderator);
}
public int Add(ForumModeratorInfo forumModerator)
{
string sqlStr = "INSERT INTO " + Config.ForumTablePrefix + "MODERATOR (FORUM_ID,MEMBER_ID,MOD_TYPE) VALUES (@ForumId,@MemberId,0)";
List<SqlParameter> parms = new List<SqlParameter>
{
new SqlParameter("@ForumId", SqlDbType.Int) {Value = forumModerator.ForumId},
new SqlParameter("@MemberId", SqlDbType.Int) {Value = forumModerator.MemberId}
};
return Convert.ToInt32(SqlHelper.ExecuteScalar(SqlHelper.ConnString, CommandType.Text, sqlStr, parms.ToArray()));
}
public void Delete(ForumModeratorInfo forumModerator)
{
string sqlStr = "";
if (forumModerator.Id > 0)
{
sqlStr = "DELETE FROM " + Config.ForumTablePrefix + "MODERATOR WHERE MOD_ID=@Id";
SqlHelper.ExecuteNonQuery(SqlHelper.ConnString, CommandType.Text, sqlStr, new SqlParameter("@Id",SqlDbType.Int){Value = forumModerator.Id});
}
else if (forumModerator.MemberId > 0 && forumModerator.ForumId > 0)
{
sqlStr = "DELETE FROM " + Config.ForumTablePrefix + "MODERATOR WHERE MEMBER_ID=@Id AND FORUM_ID=@ForumId";
List<SqlParameter> parms = new List<SqlParameter>
{
new SqlParameter("@Id", SqlDbType.Int) {Value = forumModerator.MemberId},
new SqlParameter("@ForumId", SqlDbType.Int) {Value = forumModerator.ForumId}
};
SqlHelper.ExecuteNonQuery(SqlHelper.ConnString, CommandType.Text, sqlStr, parms.ToArray());
}
}
public static void AddForumModerators(int forumid, string[] moderators, string[] remove)
{
//todo: needs testing
IForumModerator dal = Factory<IForumModerator>.Create("ForumModerator");
//get rid of any duplicates
string[] mods = moderators.Distinct().ToArray();
string[] removemods = remove.Distinct().ToArray();
foreach (string moderator in mods)
{
int modid = Convert.ToInt32(moderator);
if (!dal.IsUserForumModerator(modid, forumid))
{
ForumModeratorInfo mod = new ForumModeratorInfo
{
ForumId = forumid,
MemberId = modid
};
dal.Add(mod);
}
}
foreach (string removemod in removemods)
{
int modid = Convert.ToInt32(removemod);
if (dal.IsUserForumModerator(modid, forumid))
{
ForumModeratorInfo mod = new ForumModeratorInfo
{
ForumId = forumid,
MemberId = modid
};
dal.Delete(mod);
}
}
}
public static void RemoveForumModerator(ForumModeratorInfo moderator)
{
IForumModerator dal = Factory<IForumModerator>.Create("ForumModerator");
dal.Delete(moderator);
}
public ForumModeratorInfo GetById(int id)
{
ForumModeratorInfo moderator = null;
string sqlStr =
"SELECT FM.MOD_ID, FM.FORUM_ID,FM.MEMBER_ID,FM.MOD_TYPE,M.M_NAME FROM " +
Config.ForumTablePrefix + "MODERATOR FM LEFT OUTER JOIN " + Config.MemberTablePrefix + "MEMBERS M ON FM.MEMBER_ID = M.MEMBER_ID " +
"WHERE FM.MOD_ID=@ModId";
SqlParameter parm = new SqlParameter("@ModId", SqlDbType.VarChar) { Value = id };
using (SqlDataReader rdr = SqlHelper.ExecuteReader(SqlHelper.ConnString, CommandType.Text, sqlStr, parm))
{
while (rdr.Read())
{
moderator = new ForumModeratorInfo
{
Id= rdr.GetInt32(0),
ForumId = rdr.GetInt32(1),
MemberId = rdr.GetInt32(2),
Type = rdr.GetInt32(3),
Name = rdr.SafeGetString(4)
};
}
}
return moderator;
}
public void Update(ForumModeratorInfo forumModerator)
{
string sqlStr = "UPDATE " + Config.ForumTablePrefix + "MODERATOR SET FORUM_ID=@ForumId,MEMBER_ID=@MemberId WHERE MOD_ID=@ModId";
List<SqlParameter> parms = new List<SqlParameter>
{
new SqlParameter("@ModId", SqlDbType.Int) {Value = forumModerator.Id},
new SqlParameter("@ForumId", SqlDbType.Int) {Value = forumModerator.ForumId},
new SqlParameter("@MemberId", SqlDbType.Int) {Value = forumModerator.MemberId}
};
SqlHelper.ExecuteNonQuery(SqlHelper.ConnString, CommandType.Text, sqlStr, parms.ToArray());
}
public void SetUserAsModeratorForForums(int memberId, int[] forumList)
{
SqlHelper.ExecuteNonQuery(SqlHelper.ConnString, CommandType.Text, "DELETE FROM FORUM_MODERATOR WHERE MEMBER_ID=@MemberId", new SqlParameter("@MemberId", SqlDbType.Int) { Value = memberId });
foreach (int forum in forumList)
{
ForumModeratorInfo mod = new ForumModeratorInfo { ForumId = forum, MemberId = memberId };
Add(mod);
}
}
public void SetForumModerators(int forumId, int[] userList)
{
SqlHelper.ExecuteNonQuery(SqlHelper.ConnString, CommandType.Text, "DELETE FROM FORUM_MODERATOR WHERE FORUM_ID=@ForumId", new SqlParameter("@ForumId", SqlDbType.Int) { Value = forumId});
foreach (int user in userList)
{
ForumModeratorInfo mod = new ForumModeratorInfo {ForumId = forumId, MemberId = user};
Add(mod);
}
}
public void SetUserAsModeratorForForums(int memberId, int[] forumList)
{
SqlHelper.ExecuteNonQuery(SqlHelper.ConnString, CommandType.Text, "DELETE FROM " + Config.ForumTablePrefix + "MODERATOR WHERE MEMBER_ID=@MemberId", new OleDbParameter("@MemberId", OleDbType.Numeric) { Value = memberId });
foreach (int forum in forumList)
{
ForumModeratorInfo mod = new ForumModeratorInfo { ForumId = forum, MemberId = memberId };
Add(mod);
}
}
public void SetForumModerators(int forumId, int[] userList)
{
SqlHelper.ExecuteNonQuery(SqlHelper.ConnString, CommandType.Text, "DELETE FROM " + Config.ForumTablePrefix + "MODERATOR WHERE FORUM_ID=@ForumId", new OleDbParameter("@ForumId", OleDbType.Numeric) { Value = forumId });
foreach (int user in userList)
{
ForumModeratorInfo mod = new ForumModeratorInfo { ForumId = forumId, MemberId = user };
Add(mod);
}
}
