public async Task <IActionResult> AddComment(
[FromBody] CommentPost newComment)
{
var curUser = await _userService.GetCurUser(HttpContext);
var createdComment = new ArtefactComment
{
ArtefactId = newComment.ArtefactId,
AuthorId = curUser.Id,
Author = curUser,
Body = newComment.Body,
CreatedAt = System.DateTime.UtcNow,
};
try
{
await _context.AddAsync(createdComment);
await _context.SaveChangesAsync();
}
catch (DbUpdateException e)
{
var sqlError = Helpers.GetSqlError((SqlException)e.GetBaseException());
switch (sqlError.Number)
{
case 547: // fk violation
return(NotFound($"Artefact '{newComment.ArtefactId}' does not exist."));
default:
throw;
}
}
return(new JsonResult(_converter.ToJson(createdComment)));
}
public PartialViewResult ChildrenPostComment(CommentPost childCom)
{
ApplicationUser user = null;
string id = GetUserId();
if (id != string.Empty && id != null)
{
user = context.Users.Where(a => a.Id == id).First();
}
CurrentCommentPostViewModel vm = new CurrentCommentPostViewModel
{
LoggedUser = user,
Com = childCom
};
if (vm.Com.Children != null && vm.Com.Children.Count > 1)
{
vm.Com.Children = vm.Com.Children.OrderBy(a => a.DateOfInsert).ToList();
}
return(PartialView("_ChildrenComments", vm));
}
public PartialViewResult AddChildCommentPost(int idOfParentId, string content)
{
if (SpamDetector.IsContentSpam(content))
{
return(null);
}
var parentComment = context.CommentPosts.Find(idOfParentId);
Post post = context.Posts.Where(a => a.PostId == parentComment.PostId).First();
ApplicationUser user = null;
string id = User.Identity.GetUserId();
if (id != string.Empty && id != null)
{
user = context.Users.Where(a => a.Id == id).First();
}
CommentPost commentPost = new CommentPost()
{
Body = content,
DateOfInsert = DateTime.Now,
PostId = post.PostId,
UserId = User.Identity.GetUserId(),
User = user,
ParentCommentPostId = parentComment.CommentPostId,
Parent = parentComment
};
var sentimentalInt = new SentimentalInterpreter();
var isContentHappy = sentimentalInt.IsHappy(commentPost.Body);
if (isContentHappy)
{
commentPost.IsHappy = true;
}
parentComment.Children.Add(commentPost);
context.CommentPosts.Add(commentPost);
context.SaveChanges();
CurrentCommentPostViewModel vm = new CurrentCommentPostViewModel
{
LoggedUser = user,
Com = parentComment
};
if (vm.Com.Children != null && vm.Com.Children.Count > 1)
{
vm.Com.Children = vm.Com.Children.OrderBy(a => a.DateOfInsert).ToList();
}
return(PartialView("~/Views/Post/_ChildrenComments.cshtml", vm));
}
public ActionResult <ResponseMessage> Post([FromBody] CommentPost value)
{
using (AnimalProjectDbContext _context = new AnimalProjectDbContext())
{
ResponseMessage response = new ResponseMessage();
try
{
int result = 0;
if (value.description.Length < 2)
{
response.message = "Descripton lenght is not less than 2";
}
else
{
value.createdAt = DateTime.Now;
try
{
int maxid = 0;
if (_context.CommentPosts.Count() > 0)
{
maxid = _context.CommentPosts.OrderByDescending(a => a.id).FirstOrDefault().id;
}
value.id = maxid + 1;
}
catch (Exception e)
{
response.message = e.Message;
}
_context.CommentPosts.Add(value);
try
{
result = _context.SaveChanges();
}
catch (Exception e)
{
response.message += e.InnerException.Message;
}
if (result == 1)
{
response.message = "Success";
}
else
{
response.message = "Fail";
}
}
}
catch (Exception e)
{
response.message = "Fail" + Environment.NewLine + e.Message;
}
return(response);
}
}
public IActionResult PostComment(CommentPost model)
{
if (ModelState.IsValid)
{
string query = $@"INSERT INTO comments (comment, users_id, messages_id) VALUES (
'{model.commentPost}', {(int)HttpContext.Session.GetInt32("loggedUserID")}, '{model.messageID}')";
DbConnector.Execute(query);
return(RedirectToAction("TheWall"));
}
return(RedirectToAction("TheWall"));
}
public async Task <IActionResult> Create([Bind("Id,Content,Enabled,ApplicationUserId,Created_date,PostId")] CommentPost commentPost)
{
if (ModelState.IsValid)
{
commentPost.ApplicationUser = _context.Users.Find(commentPost.ApplicationUserId);
_context.Add(commentPost);
await _context.SaveChangesAsync();
return(RedirectToAction("Details", "Posts", new { id = commentPost.PostId }));
}
//ViewData["ApplicationUserId"] = new SelectList(_context.Users, "Id", "Id", commentPost.ApplicationUserId);
//ViewData["PostId"] = new SelectList(_context.Posts, "Id", "Id", commentPost.PostId);
return(View(commentPost));
}
public bool CommentPost(CommentPost model)
{
using (var ctx = new ApplicationDbContext())
{
var entity =
ctx
.Comment
.Single(e => e.PostId == model.PostId && e.OwnerID == _userId);
entity.Title = model.Title;
entity.Content = model.Content;
entity.ModifiedUtc = DateTimeOffset.UtcNow;
return(ctx.SaveChanges() == 1);
}
}
public async Task <IActionResult> Create([Bind("CategoryPostId,CommentBody")] CommentPost commentPost, string slug)
{
if (ModelState.IsValid)
{
commentPost.Created = DateTime.Now;
//How do i tell my program that the Id of the Author of this comment is the Id of the User
commentPost.BlogUserId = _userManager.GetUserId(User);
_context.Add(commentPost);
await _context.SaveChangesAsync();
return(RedirectToAction("Details", "CategoryPosts", new { slug }));
}
return(RedirectToAction("Details", "CategoryPosts", new { slug }));
}
public IActionResult PostComment(CommentPost parameters)
{
var userID = JWTUtility.GetUserID(HttpContext);
var comment = new Comments
{
Comment = parameters.Comment,
Userid = userID,
Postid = parameters.PostID,
Createdon = DateTime.Now
};
_context.Comments.Add(comment);
_context.SaveChanges();
return(Ok());
}
public IActionResult PostComments([FromBody] CommentPost comment)
{
if (!ModelState.IsValid)
{
return(BadRequest());
}
else
{
if (comment.Fid < 0)
{
return(StatusCode(417));
}
else if (comment.Uid < 0)
{
return(StatusCode(417));
}
else if (comment.Comments.Length < 1 || comment.Comments.Length > 1400)
{
return(StatusCode(417));
}
else
{
string temp = repo.PostComment(comment);
if (temp.Equals("Invalid User ID"))
{
return(StatusCode(417));
}
else if (temp.Equals("Invalid Question"))
{
return(StatusCode(417));
}
else if (temp.Equals("Invalid User"))
{
return(Unauthorized());
}
else
{
temp = "Success";
Reply obj = new Reply {
Message = temp
};
return(Ok(obj));
}
}
}
}
public ActionResult Index(CommentPost newComment, int?id)
{
ViewBag.ActivePost = db.Posts.Find(id);
User activeUser = (User)Session["UserLogged"];
Post activePost = db.Posts.Find(id);
ViewBag.Comments = db.CommentPosts.Where(db => db.Post_Id == activePost.Id).OrderByDescending(db => db.Dates).ToList();
if (newComment.Content != null)
{
newComment.Users_Id = activeUser.Id;
newComment.Post_Id = activePost.Id;
newComment.Dates = DateTime.Now;
db.CommentPosts.Add(newComment);
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
ViewBag.Error = "Comment cannot be empty !";
}
ViewBag.Comments = db.CommentPosts.Where(db => db.Post_Id == activePost.Id).OrderByDescending(db => db.Dates).ToList();
ViewBag.Author = db.Administrators.First();
ViewBag.BlogSingleMasking = db.Blog_Single_Masking.First();
ViewBag.Category = db.Categories.Where(db => db.Status == 0).ToList();
ViewBag.Post = db.Posts.Where(db => db.Status == 0).OrderByDescending(db => db.Date).Take(3).ToList();
ViewBag.Tag = db.Tags.Where(db => db.Status == 0).ToList();
List <Category> ctg = db.Categories.Where(db => db.Status == 0).ToList();
List <int> newsCount = new List <int>();
foreach (var item in ctg)
{
var sum = db.News_To_Category.Where(db => db.Category_Id == item.Id).Count();
newsCount.Add(sum);
}
ViewBag.NewsCount = newsCount;
ViewBag.CommentCount = db.CommentPosts.Where(db => db.Post_Id == activePost.Id).Count();
if (activePost != null)
{
return(View(activePost));
}
else
{
return(Content("There is no News with this Id"));
}
}
public ActionResult <List <CommentPost> > Post([FromBody] User user)
{
using (AnimalProjectDbContext _context = new AnimalProjectDbContext())
{
try
{
return(_context.CommentPosts.Where(a => a.creatorUsername == user.username).ToList());
}
catch (Exception e)
{
List <CommentPost> errorList = new List <CommentPost>();
CommentPost d = new CommentPost();
d.description = e.InnerException.Message;
errorList.Add(d);
return(errorList);
}
}
}
public void GetComments(int id)
{
string strCon = System.Web
.Configuration
.WebConfigurationManager
.ConnectionStrings["WingtipToys"].ConnectionString;
SqlConnection conn = new SqlConnection(strCon);
conn.Open();
SqlCommand cmd = new SqlCommand("SELECT * FROM[Comments]WHERE CommentPostId = " + id, conn);
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds);
CommentPost.DataSource = ds;
CommentPost.DataBind();
}
public PartialViewResult AddComment(int postId, string content)
{
if (SpamDetector.IsContentSpam(content))
{
return(null);
}
Post post = context.Posts.Where(a => a.PostId == postId).First();
ApplicationUser user = null;
string id = User.Identity.GetUserId();
if (id != string.Empty && id != null)
{
user = context.Users.Where(a => a.Id == id).First();
}
CommentPost commentPost = new CommentPost()
{
Body = content, DateOfInsert = DateTime.Now, PostId = post.PostId, UserId = User.Identity.GetUserId(), User = user
};
var sentimentalInt = new SentimentalInterpreter();
var isContentHappy = sentimentalInt.IsHappy(commentPost.Body);
if (isContentHappy)
{
commentPost.IsHappy = true;
}
context.CommentPosts.Add(commentPost);
context.SaveChanges();
post.Comments.Add(commentPost);
CurrentPostUserViewModel vm = new CurrentPostUserViewModel
{
LoggedUser = user,
Post = post
};
vm.Post.Comments = vm.Post.Comments.OrderBy(a => a.DateOfInsert).ToList();
return(PartialView("_ListOfComments", vm));
}
public string AddPostComment(CommentPost commpost)
{
var contentpos = Request.Form["CommendPostcopne"];
var posid = Convert.ToInt32(Request["post_idcomm"]);
var userid = Convert.ToInt32(Session["User_id"]);
if (!String.IsNullOrEmpty(contentpos))
{
commpost.Post_id = posid;
commpost.User_id = userid;
commpost.Content = contentpos;
PostManage.AddCommentPost(commpost);
return("success");
}
else
{
return("fail");
}
}
public ActionResult CommentPoster(CommentPostModel NewComment)
{
int usermodelidintcontainer = int.Parse(NewComment.UserIdContainer);
var sentCommentpost = new CommentPost
{
BlogPostId = NewComment.Items.ID,
Comment = NewComment.Items2.Comment,
UserModelId = usermodelidintcontainer
};
db.CommentTable.Add(sentCommentpost);
db.SaveChanges();
return(View());
}
public ActionResult <ResponseMessage> Put([FromBody] CommentPost value)
{
ResponseMessage response = new ResponseMessage();
using (AnimalProjectDbContext _context = new AnimalProjectDbContext())
{
int result = 0;
if (_context.CommentPosts.Any(a => a.id == value.id))
{
response.message = "CommentPost is found";
_context.CommentPosts.Remove(_context.CommentPosts.Where(a => a.id == value.id).FirstOrDefault());
_context.CommentPosts.Add(value);
try
{
result = _context.SaveChanges();
if (result == 1)
{
response.message = "Success";
}
else
{
response.message = "Fail";
}
}
catch (Exception e)
{
response.message = "Error" + Environment.NewLine + e.InnerException.Message;
}
}
else
{
response.message = "CommentPost not found";
}
}
return(response);
}
public async Task <IActionResult> AddQuestion(
[FromBody] CommentPost newQuestion)
{
var curUser = await _userService.GetCurUser(HttpContext);
// veryify answer
var art = await _context
.Artefacts
.SingleOrDefaultAsync(a => a.Id == newQuestion.ArtefactId);
if (art == null)
{
return(NotFound($"'ArtefactId' '{newQuestion.ArtefactId}' does not exist."));
}
if (art.OwnerId != curUser.Id)
{
return(Unauthorized("Only the artefact owner can post a question."));
}
var createdQuestion = new ArtefactQuestion
{
ArtefactId = newQuestion.ArtefactId,
AuthorId = curUser.Id,
Author = curUser,
Body = newQuestion.Body,
CreatedAt = System.DateTime.UtcNow,
IsAnswered = false,
AnswerCommentId = null,
};
// no need to catch the fk error - already checked for 404
await _context.AddAsync(createdQuestion);
await _context.SaveChangesAsync();
return(new JsonResult(_converter.ToJson(createdQuestion)));
}
public void UpdateCommend(CommentPost commpost)
{
db.Entry <CommentPost>(commpost).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
//评论回复
public static void AddCommentPost(CommentPost commPost)
{
pos.AddCommentPost(commPost);
}
public static void UpdateCommend(CommentPost commpost)
{
pos.UpdateCommend(commpost);
}
private void btnLuu_Click(object sender, EventArgs e)
{
// cập nhật thông tin bài viết
tblPost p = new tblPost();
p.IDPost = idpost;
p.TimePost = DateTime.Parse(timepost);
p.CountComment = tongsocomment;
p.CountLike = int.Parse(tongsoluonglike);
if (danhgia == "Tích cực")
{
p.Status = "Tích cực";
}
else
{
p.Status = "Tiêu cực";
}
Post.Sua(p);
// kết thúc cập nhật thông tin bài viết
//thêm tài khoản người dùng
for (int i = 0; i < lsIDTichCuc.Count; i++)
{
tblUserFB newu = new tblUserFB();
tblLikePost newlp = new tblLikePost();
newu.IDUser = lsIDTichCuc[i].ToString();
newu.Name = lsNameTichCuc[i].ToString();
UserFB.Them(newu);
newlp.IDPost = idpost;
newlp.IDUserFB = lsIDTichCuc[i].ToString();
newlp.Status = 1;
LikePost.Them(newlp);
}
for (int i = 0; i < lsIDTieuCuc.Count; i++)
{
tblUserFB newu = new tblUserFB();
tblLikePost newlp = new tblLikePost();
newu.IDUser = lsIDTieuCuc[i].ToString();
newu.Name = lsNameTieuCuc[i].ToString();
UserFB.Them(newu);
newlp.IDPost = idpost;
newlp.IDUserFB = lsIDTieuCuc[i].ToString();
newlp.Status = -1;
LikePost.Them(newlp);
}
//thêm từ những người bình luận
for (int i = 0; i < LsNguoiDungBL.Items.Count; i++)
{
tblUserFB newu = new tblUserFB();
newu.IDUser = lsIDUserBinhLuan[i];
newu.Name = LsNguoiDungBL.Items[i].Text;
UserFB.Them(newu);
//lưu người dùng bình luận vào sql
tblCommentPost newcommentpost = new tblCommentPost();
newcommentpost.IDPost = idpost;
newcommentpost.IDComment = lsIDBinhLuan[i].ToString();
newcommentpost.IDUser = lsIDUserBinhLuan[i];
newcommentpost.Description = lsNoiDungBL[i];
newcommentpost.Status = 0;
CommentPost.Them(newcommentpost);
//kết thúc lưu người dùng bình luận
}
//kết thúc thêm tài khoản
MessageBox.Show("Đã lưu tất cả thông tin!");
}
private void btnNguoiBinhLuan_Click(object sender, EventArgs e)
{
LsNguoiDungBL.Items.Clear();
lsIDBinhLuan.Clear();
lsNoiDungBL.Clear();
lbTrangThaiBL.Visible = true;
ProgressQuetBL.Visible = true;
ProgressQuetBL.Value = 0;
WebBrowser web1 = new WebBrowser();
web1.Navigate("mobile.facebook.com/" + idpost);
while (web1.ReadyState != WebBrowserReadyState.Complete)
{
Application.DoEvents();
}
htmlcontent = web1.DocumentText;
htmlcontent = htmlcontent.Replace("amp;", "");
for (; ;)
{
int kt = htmlcontent.IndexOf("<H3><A class=\"");
int kt2 = htmlcontent.IndexOf("<h3><a class=\"d");
//nếu như còn bình luận
if (kt != -1 || kt2 != -1)
{
if (kt == -1)
{
htmlcontent = htmlcontent.Substring(kt2 + 5);
}
else
{
htmlcontent = htmlcontent.Substring(kt + 5);
}
htmlcontent = htmlcontent.Substring(htmlcontent.IndexOf("href") + 4);
htmlcontent = htmlcontent.Substring(htmlcontent.IndexOf("\"") + 1);
//string idUserComment = htmlcontent.Remove(htmlcontent.IndexOf("refid"));
//idUserComment = idUserComment.Replace("?", "");
//idUserComment = idUserComment.Replace("rc=p", "");
string idUserComment = htmlcontent.Remove(htmlcontent.IndexOf("&"));
string NameBL = htmlcontent.Substring(htmlcontent.IndexOf(">") + 1);
NameBL = NameBL.Remove(NameBL.IndexOf("<"));
htmlcontent = htmlcontent.Substring(htmlcontent.IndexOf("class=") + 5);
htmlcontent = htmlcontent.Substring(htmlcontent.IndexOf(">") + 1);
string NoiDung = htmlcontent.Remove(htmlcontent.IndexOf("/DIV") - 1);
string idcomment = htmlcontent.Substring(htmlcontent.IndexOf("like_comment_id=") + 16);
idcomment = idcomment.Remove(idcomment.IndexOf("&"));
string TimeBL = htmlcontent.Substring(htmlcontent.IndexOf("ABBR") + 5);
TimeBL = TimeBL.Remove(TimeBL.IndexOf("<"));
if (TimeBL.IndexOf("Tháng") == -1)
{
TimeBL = TimeBL + DateTime.Now.ToShortDateString();
}
if (CommentPost.KiemTraIDComment(idcomment) == false)
{
lsIDUserBinhLuan.Add(idUserComment);
lsIDBinhLuan.Add(idcomment);
lsNoiDungBL.Add(NoiDung);
lsTimeBinhLuan.Add(TimeBL);
LsNguoiDungBL.Items.Add(NameBL);
}
}
//nếu như hết bình luận cố tìm xem thêm bình luận
else
{
int ktseenext = htmlcontent.IndexOf("see_next");
if (ktseenext != -1)
{
htmlcontent = htmlcontent.Substring(htmlcontent.IndexOf("see_next") + 5);
htmlcontent = htmlcontent.Substring(htmlcontent.IndexOf("href") + 4);
htmlcontent = htmlcontent.Substring(htmlcontent.IndexOf("\"") + 1);
string urltiep = htmlcontent.Remove(htmlcontent.IndexOf("\""));
urltiep = urltiep.Replace("amp;", "");
web1.Navigate("mobile.facebook.com" + urltiep);
while (web1.ReadyState != WebBrowserReadyState.Complete)
{
Application.DoEvents();
}
htmlcontent = web1.DocumentText;
}
else
{
ProgressQuetBL.Value = 100;
lbTrangThaiBL.Text = "Đã quét xong!";
MessageBox.Show("Đã tìm kiếm được " + LsNguoiDungBL.Items.Count + " bình luận mới");
tongsocomment = LsNguoiDungBL.Items.Count;
break;
}
}
}
}
