public JsonResult AjouterCommentaire(CommentViewModel cvm)
{
var c = new DataLayer.Models.Commentaires()
{
idParent = cvm.parent_id,
datePoste = DateTime.Now,
idProduit = cvm.product_id,
texte = cvm.text,
idAuteur = _user.GetUserId()
};
_db.Commentaires.Add(c);
_db.SaveChanges();
var auteur = _user.Name;
var auteurOriginal = _db.Commentaires.Where(co => co.idComment == cvm.parent_id).Select(p => p.AspNetUsers.UserName);
int nbComm = _db.Commentaires.Where(co => co.idProduit == 2).Count();
var results = new Dictionary<string, object>();
results.Add("success", "true");
var comments = new List<Dictionary<string, object>>();
var comment = new Dictionary<string, object>();
results.Add("parent_id", cvm.parent_id);
results.Add("in_reply_to", auteurOriginal);
results.Add("element_id", "134");
results.Add("created_by", "1");
results.Add("fullname", auteur);
results.Add("picture", "../../Content/Comments/images/user_blank_picture.png");
results.Add("posted_date", c.datePoste.ToString());
results.Add("text", c.texte);
var children = new List<Dictionary<string, object>>();
results.Add("childrens", children);
var users = new Dictionary<string, string>();
users.Add("user_id", "1");
users.Add("fullname", "Administrator admin");
users.Add("picture", "../../Content/Comments/images/user_blank_picture.png");
users.Add("is_logged_in", "false");
users.Add("is_add_allowed", "true");
users.Add("is_edit_allowed", "true");
results.Add("user", users);
var r = new CommentViewModel()
{
success = true,
results = results
};
return Json(results);
}
public JsonResult GetCommJSON(int id)
{
var comm = _db.Commentaires.Where(c => c.idProduit == id).OrderBy(c => c.idParent);
var comments = new List<Dictionary<string, object>>();
var dictAllcomments = new Dictionary<int, Dictionary<string, object>>();
foreach (var item in comm)
{
var comment = new Dictionary<string, object>();
comment.Add("comment_id", item.idComment);
comment.Add("parent_id", item.idParent ?? 0);
comment.Add("in_reply_to", "null");
comment.Add("element_id", "134");
comment.Add("created_by", "1");
comment.Add("fullname", "Administrator admin");
comment.Add("picture", "../../Content/Comments/images/user_blank_picture.png");
comment.Add("posted_date", item.datePoste.ToString("yyyy-MM-ddTHH:mm:ssZ"));
comment.Add("text", item.texte);
var children = new List<Dictionary<string, object>>();
comment.Add("childrens", children);
if (item.idParent == null)
comments.Add(comment);
dictAllcomments.Add((int)comment["comment_id"],comment);
}
foreach (var item in dictAllcomments)
{
foreach (var item1 in dictAllcomments)
if (item.Key == (int)item1.Value["parent_id"])
{
((List<Dictionary<string, object>>)item.Value["childrens"])
.Add(item1.Value);
}
}
var users = new Dictionary<string, string>();
users.Add("user_id", "1");
users.Add("fullname", "Administrator admin");
users.Add("picture", "../../Content/Comments/images/user_blank_picture.png");
users.Add("is_logged_in", "false");
users.Add("is_add_allowed", "true");
users.Add("is_edit_allowed", "true");
var results = new Dictionary<string, object>();
results.Add("comments",comments);
results.Add("total_comment", comm.Count());
results.Add("user", users);
var r = new CommentViewModel(){
success = true,
results = results
};
return Json(r, JsonRequestBehavior.AllowGet);
}
public JsonResult RetirerCommentaire(CommentViewModel cvm)
{
var c = _db.Commentaires.Find(cvm.comment_id);
_db.Commentaires.Remove(c);
_db.SaveChanges();
int nbComm = _db.Commentaires.Where(co => co.idProduit == 2).Count();
var r = new CommentViewModel()
{
success = true,
total_comment = nbComm
};
return Json(r);
}
public JsonResult ModifierCommentaire(CommentViewModel cvm, int id)
{
var comment = _db.Commentaires.Find(id);
comment.texte = cvm.text;
_db.SaveChanges();
var results = new Dictionary<string, object>();
results.Add("success", "true");
results.Add("comment_id", id);
results.Add("text", cvm.text);
return Json(results);
}