public JsonResult GetComments(int ID_ticket)
{
SUPPORT_SYSTEMEntities DB = new SUPPORT_SYSTEMEntities();
var comment = DB.comments.Where(x => x.ID_ticket == ID_ticket).Select(s => new { s.ID_ticket, s.username, s.ID_parent, s.ID_comments, s.comment1, s.posted_on }).ToList();
return(Json(comment, JsonRequestBehavior.AllowGet));
}
public JsonResult AllReplay(int ID_ticket)
{
try
{
SUPPORT_SYSTEMEntities DB = new SUPPORT_SYSTEMEntities();
var replay = DB.comments.Where(x => x.ID_ticket == ID_ticket && x.ID_parent != null).Select(s => new { s.comment1, s.posted_on, s.ID_user, s.ID_comments, s.ID_parent, s.username }).ToArray();
return(Json(replay, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(ex, JsonRequestBehavior.AllowGet));
}
}
public MainLogic()
{
DB = new SUPPORT_SYSTEMEntities();
}
