public ActionResult InsertComment(tbl_Comments tComment) { try { tComment.Title = "نظر"; tComment.Confirm = false; tComment.Date = DateTime.Now.Date; tComment.Family = "f"; tComment.DisLike = 0; tComment.Like = 0; tComment.ParentID = 0; tComment.Read = false; tComment.IP = Request.UserHostAddress; db.tbl_Comments.Add(tComment); if (Convert.ToBoolean(db.SaveChanges())) { ViewBag.Style = "color:green"; ViewBag.Message = "نظر ثبت شد"; } else { ViewBag.Style = "color:red"; ViewBag.Message = "نظر ثبت نشد"; } return(View("Subject", RepSubject.GetDeatilsSubject(tComment.SubjectID))); } catch { return(Content("Error")); } }
public ActionResult CommentReplay(int ParentID, int SubjectID) { tbl_Comments tComment = new tbl_Comments(); tComment.SubjectID = SubjectID; tComment.ParentID = ParentID; return(PartialView("P_ReplayComment", tComment)); }
public string AcceptOrRejectArticleByR(int artId, string articleName, string articleDescription, DateTime dateOfPublish, int userId, int mediaManagerId, int articleStatusId, int articleStateId, string commentContent, int articleCommentId) { string uArticle = ""; System.Net.ServicePointManager.DefaultConnectionLimit = 200; db.Configuration.ProxyCreationEnabled = false; tbl_Article updatedArticle = db.tbl_Article.SingleOrDefault(x => x.Article_Id == artId); updatedArticle.Article_Name = articleName; updatedArticle.Article_Description = articleDescription; updatedArticle.Article_PublishDate = dateOfPublish; updatedArticle.User_Id = userId; updatedArticle.MedaManager_Id = mediaManagerId; updatedArticle.ArticleStatus_Id = articleStatusId; if (articleStatusId == 2) //Accepted by Reviewer { //updatedArticle.Article_State_Id = 2; tbl_Workflows currentPosOfWorkflow = db.tbl_Workflows.SingleOrDefault(x => x.User_Id == userId && x.State_Id == updatedArticle.Article_State_Id); tbl_Workflows nextPosOfWorkFlow = db.tbl_Workflows.SingleOrDefault(x => x.Workflow_Id == currentPosOfWorkflow.Workflow_Id + 1 && x.User_Id == userId); updatedArticle.Article_State_Id = nextPosOfWorkFlow.State_Id; } else if (articleStatusId == 3) //Rejected by Reviewer { updatedArticle.Article_State_Id = 4; } tbl_Comments newComment = new tbl_Comments(); //if (newComment.ArticleComment_Content == "") //if (updatedArticle.ArticleComment_Id == null) if(commentContent == null) { updatedArticle.ArticleComment_Id = null; } else { newComment.ArticleComment_Content = commentContent; newComment.Article_Id = artId; newComment.User_Id = userId; db.Entry(newComment).State = EntityState.Added; db.SaveChanges(); updatedArticle.ArticleComment_Id = newComment.ArticleComment_Id; } db.Entry(updatedArticle).State = EntityState.Modified; db.SaveChanges(); if (uArticle != "") { return uArticle; } else { return null; } }
public string AcceptOrRejectArticleByMm(int artId, string articleName, string articleDescription, DateTime dateOfPublish, int userId, int mediaManagerId, int articleStatusId, int articleStateId, string commentContent, int articleCommentId) { string uArticle = ""; System.Net.ServicePointManager.DefaultConnectionLimit = 200; db.Configuration.ProxyCreationEnabled = false; tbl_Article updatedArticle = db.tbl_Article.SingleOrDefault(x => x.Article_Id == artId); updatedArticle.Article_Id = artId; updatedArticle.Article_Name = articleName; updatedArticle.Article_Description = articleDescription; updatedArticle.Article_PublishDate = dateOfPublish; updatedArticle.User_Id = userId; updatedArticle.MedaManager_Id = mediaManagerId; updatedArticle.ArticleStatus_Id = articleStatusId; if (articleStatusId == 4) //Accepted by Media Manager { //updatedArticle.Article_State_Id = 2; tbl_Workflows currentPosOfWorkflow = db.tbl_Workflows.SingleOrDefault(x => x.User_Id == userId && x.State_Id == updatedArticle.Article_State_Id); tbl_Workflows nextPosOfWorkFlow = db.tbl_Workflows.SingleOrDefault(x => x.Workflow_Id == currentPosOfWorkflow.Workflow_Id + 1 && x.User_Id == userId); updatedArticle.Article_State_Id = nextPosOfWorkFlow.State_Id; } else if (articleStatusId == 5) //Rejected by Media Manager { updatedArticle.Article_State_Id = 4; } tbl_Comments newComment = new tbl_Comments(); if (commentContent == null) //If article do not have a comment by a reviewer and { //media manager left the article without a comment too updatedArticle.ArticleComment_Id = null; } else { if (updatedArticle.ArticleComment_Id == null) //If media manager added the first comment to the article { newComment.ArticleComment_Content = commentContent; newComment.Article_Id = artId; newComment.User_Id = userId; db.Entry(newComment).State = EntityState.Added; db.SaveChanges(); updatedArticle.ArticleComment_Id = newComment.ArticleComment_Id; } else if (updatedArticle.ArticleComment_Id != null) //If media manager replaced the comment of the reviewer { newComment.ArticleComment_Id = Convert.ToInt32(updatedArticle.ArticleComment_Id); newComment.ArticleComment_Content = commentContent; newComment.Article_Id = artId; newComment.User_Id = userId; db.Entry(newComment).State = EntityState.Modified; db.SaveChanges(); updatedArticle.ArticleComment_Id = newComment.ArticleComment_Id; } } db.Entry(updatedArticle).State = EntityState.Modified; db.SaveChanges(); if (uArticle != "") { return uArticle; } else { return null; } }