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; } }