public bool AddModerator(string subforum, string moderatorName)
{
try
{
ModeratorEntity me = new ModeratorEntity();
me.Username = moderatorName;
me.Subforum = subforum;
ForumContext.ModeratorEntities.AddObject(me);
ForumContext.SaveChanges();
return true;
}
catch (Exception)
{
throw;
}
//try
//{
// // Update in moderators table
// IEnumerable<ModeratorEntity> getModeratorQuery = from m in ForumContext.ModeratorEntities
// where m.Subforum == subforum && m.Username == moderatorName
// select m;
// // Update in users table
// IEnumerable<ModeratorEntity> userIsStillModeratorQuery = from m in ForumContext.ModeratorEntities
// where m.Username == moderatorName
// select m;
// UserEntity ue = null;
// if (userIsStillModeratorQuery.Count() == 1) // If user was just moderator of subforum then change his status in yblUsers
// {
// IEnumerable<UserEntity> usersQuery = from u in ForumContext.UserEntities
// where u.UserName == moderatorName
// select u;
// ue = usersQuery.First();
// ue.Authentication = AuthorizationLevel.MEMBER.ToString();
// }
// ForumContext.ModeratorEntities.DeleteObject(getModeratorQuery.First());
// ForumContext.SaveChanges();
// return true;
//}
//catch (Exception)
//{
// //TODO
// throw;
//}
}
public bool SetModerators(string subforum, List<string> moderatorsList)
{
try
{
foreach (string modName in moderatorsList)
{
ModeratorEntity me = new ModeratorEntity();
me.Username = modName;
me.Subforum = subforum;
ForumContext.ModeratorEntities.AddObject(me);
IEnumerable<UserEntity> usersQuery = from u in ForumContext.UserEntities
where u.UserName == modName
select u;
usersQuery.First().Authentication = AuthorizationLevel.MODERATOR.ToString();
}
ForumContext.SaveChanges();
return true;
}
catch (Exception)
{
//TODO
throw;
}
}
/// <summary>
/// Create a new ModeratorEntity object.
/// </summary>
/// <param name="username">Initial value of the Username property.</param>
/// <param name="subforum">Initial value of the Subforum property.</param>
public static ModeratorEntity CreateModeratorEntity(global::System.String username, global::System.String subforum)
{
ModeratorEntity moderatorEntity = new ModeratorEntity();
moderatorEntity.Username = username;
moderatorEntity.Subforum = subforum;
return moderatorEntity;
}
/// <summary>
/// Deprecated Method for adding a new object to the ModeratorEntities EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddToModeratorEntities(ModeratorEntity moderatorEntity)
{
base.AddObject("ModeratorEntities", moderatorEntity);
}