public JsonResult EditSubForumComment(long ForumCommID, long UID)
{
ResultInfo <ForumDetails> ResultInfo = new ResultInfo <ForumDetails>()
{
Status = false,
Description = "Failed|Login"
};
ForumDetails temp = new ForumDetails();
SchoolStudent obj = new SchoolStudent();
try
{
if (ForumCommID > 0 && UID > 0)
{
temp.singleComment = obj.EditSubForumComment(ForumCommID, UID);
ResultInfo.Info = temp;
}
if (ResultInfo.Info != null)
{
ResultInfo.Description = "Success| Get Details Of SocialStudent";
ResultInfo.Status = true;
}
}
catch (Exception ex)
{
}
return(Json(ResultInfo, JsonRequestBehavior.AllowGet));
}
public JsonResult ForumTopicComments(long TopicID)
{
ResultInfo <ForumDetails> CommentList = new ResultInfo <ForumDetails>()
{
Status = false,
Description = "Failed|Login"
};
List <SubjectForumTopicComment> AllCommentList = new List <SubjectForumTopicComment>();
ForumDetails DetailsInfo = new ForumDetails();
// List<ForumTopicComment> CommentDetails = new List<ForumTopicComment>();
List <SubjectForumTopics> TopicDetails = new List <SubjectForumTopics>();
SchoolStudent PageObj = new SchoolStudent();
AllCommentList = PageObj.AllCommentsOfTopic(TopicID);
DetailsInfo.comments = AllCommentList;
// DetailsInfo.ComID=AllCommentLi
// DetailsInfo.singleComment=
TopicDetails = PageObj.getDetailsOfComment(TopicID);
if (TopicDetails != null && TopicDetails.Count > 0)
{
DetailsInfo.Topic = TopicDetails.FirstOrDefault().TopicName;
DetailsInfo.TopicCreatedByName = TopicDetails.FirstOrDefault().CreatedByName;
DetailsInfo.TopicCreatedDate = TopicDetails.FirstOrDefault().TopicCreatedDate;
//DetailsInfo.Topic_CreatedDate = TopicDetails.FirstOrDefault().Topic_CreatedDate;
DetailsInfo.TopicID = TopicDetails.FirstOrDefault().TopicID;
DetailsInfo.IsStudent = TopicDetails.FirstOrDefault().IsStudent;
DetailsInfo.IsTeacher = TopicDetails.FirstOrDefault().IsTeacher;
}
CommentList.Info = DetailsInfo;
CommentList.Description = "Success| Get all comment by TopicId";
CommentList.Status = true;
return(Json(CommentList, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// Updates an existing forum
/// </summary>
public static bool UpdateForum(int id, string title, bool moderated, int importance, string description, string imageUrl)
{
ForumDetails record = new ForumDetails(id, DateTime.Now, "", title, moderated, importance, description, imageUrl);
bool ret = SiteProvider.Forums.UpdateForum(record);
BizObject.PurgeCacheItems("forums_forum");
return(ret);
}
/// <summary>
/// Creates a new forum
/// </summary>
public static int InsertForum(string title, bool moderated, int importance, string description, string imageUrl)
{
ForumDetails record = new ForumDetails(0, DateTime.Now,
BizObject.CurrentUserName, title, moderated, importance, description, imageUrl);
int ret = SiteProvider.Forums.InsertForum(record);
BizObject.PurgeCacheItems("forums_forum");
return(ret);
}
/// <summary>
/// Returns a Forum object filled with the data taken from the input ForumDetails
/// </summary>
private static Forum GetForumFromForumDetails(ForumDetails record)
{
if (record == null)
{
return(null);
}
else
{
return(new Forum(record.ID, record.AddedDate, record.AddedBy,
record.Title, record.Moderated, record.Importance, record.Description, record.ImageUrl));
}
}
/// <summary>
/// Updates a forum
/// </summary>
public override bool UpdateForum(ForumDetails forum)
{
using (SqlConnection cn = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("tbh_Forums_UpdateForum", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@ForumID", SqlDbType.Int).Value = forum.ID;
cmd.Parameters.Add("@Title", SqlDbType.NVarChar).Value = forum.Title;
cmd.Parameters.Add("@Moderated", SqlDbType.Bit).Value = forum.Moderated;
cmd.Parameters.Add("@Importance", SqlDbType.Int).Value = forum.Importance;
cmd.Parameters.Add("@ImageUrl", SqlDbType.NVarChar).Value = forum.ImageUrl;
cmd.Parameters.Add("@Description", SqlDbType.NVarChar).Value = forum.Description;
cn.Open();
int ret = ExecuteNonQuery(cmd);
return(ret == 1);
}
}
/// <summary>
/// Creates a new forum
/// </summary>
public override int InsertForum(ForumDetails forum)
{
using (SqlConnection cn = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("tbh_Forums_InsertForum", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@AddedDate", SqlDbType.DateTime).Value = forum.AddedDate;
cmd.Parameters.Add("@AddedBy", SqlDbType.NVarChar).Value = forum.AddedBy;
cmd.Parameters.Add("@Title", SqlDbType.NVarChar).Value = forum.Title;
cmd.Parameters.Add("@Moderated", SqlDbType.Bit).Value = forum.Moderated;
cmd.Parameters.Add("@Importance", SqlDbType.Int).Value = forum.Importance;
cmd.Parameters.Add("@ImageUrl", SqlDbType.NVarChar).Value = forum.ImageUrl;
cmd.Parameters.Add("@Description", SqlDbType.NVarChar).Value = forum.Description;
cmd.Parameters.Add("@ForumID", SqlDbType.Int).Direction = ParameterDirection.Output;
cn.Open();
int ret = ExecuteNonQuery(cmd);
return((int)cmd.Parameters["@ForumID"].Value);
}
}
public JsonResult TopicsListByForumID(long ForumID, long SchoolID, long ClassID)
{
ResultInfo <ForumDetails> TopicList = new ResultInfo <ForumDetails>()
{
Status = false,
Description = "Failed|Login"
};
List <SubjectForumTopics> AllTopicList = new List <SubjectForumTopics>();
ForumDetails DetailsInfo = new ForumDetails();
SchoolStudent PageObj = new SchoolStudent();
AllTopicList = PageObj.TopicListByForumID(ForumID, SchoolID, ClassID); // topics list
if (AllTopicList != null && AllTopicList.Count > 0)
{
DetailsInfo.topicList = AllTopicList;
DetailsInfo.Forum = AllTopicList.FirstOrDefault().ForumName;
TopicList.Info = DetailsInfo;
TopicList.Description = "Success| Get all topic by communityID";
TopicList.Status = true;
}
return(Json(TopicList, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// Refresh the details of the forum, including title and description.
/// </summary>
/// <param name="forumName">The forum name</param>
public void RefreshForum(string forumName)
{
Thread t = new Thread(() =>
{
DirForum forum = null;
try
{
string encodedForumName = FolderCollection.EncodeForumName(forumName);
LogFile.WriteLine("Updating directory for {0}", forumName);
HttpWebRequest wrGeturl = APIRequest.Get("forums/" + encodedForumName + "/details", APIRequest.APIFormat.XML);
Stream objStream = APIRequest.ReadResponse(wrGeturl);
if (objStream != null)
{
using (XmlReader reader = XmlReader.Create(objStream))
{
XmlSerializer serializer = new XmlSerializer(typeof(ForumDetails));
ForumDetails forumDetails = (ForumDetails)serializer.Deserialize(reader);
bool isNewForum = false;
forum = ForumByName(forumDetails.Name);
if (forum == null)
{
forum = new DirForum();
isNewForum = true;
}
forum.Name = forumDetails.Name;
forum.Title = forumDetails.Title;
forum.Desc = forumDetails.Description;
forum.Cat = forumDetails.Category;
forum.Sub = forumDetails.SubCategory;
forum.Recent = forumDetails.Recent;
forum.Type = forumDetails.Type;
lock (CIX.DBLock)
{
if (isNewForum)
{
CIX.DB.Insert(forum);
_allForums[forum.ID] = forum;
}
else
{
CIX.DB.Update(forum);
}
}
LogFile.WriteLine("Directory for {0} updated", forum.Name);
}
}
}
catch (Exception e)
{
CIX.ReportServerExceptions("DirectoryCollection.RefreshForum", e);
}
NotifyForumUpdated(forum);
});
t.Start();
}
/// <summary>
/// Updates a forum
/// </summary>
public override bool UpdateForum(ForumDetails forum)
{
using (SqlConnection cn = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("tbh_Forums_UpdateForum", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@ForumID", SqlDbType.Int).Value = forum.ID;
cmd.Parameters.Add("@Title", SqlDbType.NVarChar).Value = forum.Title;
cmd.Parameters.Add("@Moderated", SqlDbType.Bit).Value = forum.Moderated;
cmd.Parameters.Add("@Importance", SqlDbType.Int).Value = forum.Importance;
cmd.Parameters.Add("@ImageUrl", SqlDbType.NVarChar).Value = forum.ImageUrl;
cmd.Parameters.Add("@Description", SqlDbType.NVarChar).Value = forum.Description;
cn.Open();
int ret = ExecuteNonQuery(cmd);
return (ret == 1);
}
}
/// <summary>
/// Creates a new forum
/// </summary>
public override int InsertForum(ForumDetails forum)
{
using (SqlConnection cn = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("tbh_Forums_InsertForum", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@AddedDate", SqlDbType.DateTime).Value = forum.AddedDate;
cmd.Parameters.Add("@AddedBy", SqlDbType.NVarChar).Value = forum.AddedBy;
cmd.Parameters.Add("@Title", SqlDbType.NVarChar).Value = forum.Title;
cmd.Parameters.Add("@Moderated", SqlDbType.Bit).Value = forum.Moderated;
cmd.Parameters.Add("@Importance", SqlDbType.Int).Value = forum.Importance;
cmd.Parameters.Add("@ImageUrl", SqlDbType.NVarChar).Value = forum.ImageUrl;
cmd.Parameters.Add("@Description", SqlDbType.NVarChar).Value = forum.Description;
cmd.Parameters.Add("@ForumID", SqlDbType.Int).Direction = ParameterDirection.Output;
cn.Open();
int ret = ExecuteNonQuery(cmd);
return (int)cmd.Parameters["@ForumID"].Value;
}
}
