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