public ActionResult Index() { //get all the comments and return to view List <Comment> comments = new List <Comment>(); using (MailCRMEntities entities = new MailCRMEntities()) { comments = entities.Comments.OrderByDescending(i => i.PostDate).ToList(); } return(View(comments)); }
public void Post(Comment comment) { using (MailCRMEntities entities = new MailCRMEntities()) { comment.PostDate = DateTime.Now; entities.Comments.Add(comment); entities.SaveChanges(); //notify the client through the hub var hubContext = GlobalHost.ConnectionManager.GetHubContext <CommentsHub>(); hubContext.Clients.All.commentReceived(comment); } }
public IEnumerable <Comment> Get(string email) { List <Comment> comments = new List <Comment>(); using (MailCRMEntities entities = new MailCRMEntities()) { email = email.ToLower(); comments = entities.Comments.Where(i => i.ContactEmail == email) .OrderByDescending(i => i.PostDate) .ToList(); } return(comments); }