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