public void GetPosts(int DemId) { using (Entities db = new Entities()) { var ret = (from post in db.Comments.Where(d => d.DemotivatorId == DemId).ToList() orderby post.Date select new { Message = post.Text, PostedBy = post.UserId, PostedByName = post.AspNetUsers.UserName, PostedByAvatar = post.AspNetUsers.AvatarUrl, PostedDate = TimeAgo(post.Date), //PostId = post.Id, }).ToArray(); Clients.All.loadPosts(ret, DemId); } }
public void AddPost(Comments post, string UserId, int DemId1) { post.UserId = UserId; post.Date = DateTime.Now; post.DemotivatorId = DemId1; using (Entities db = new Entities()) { db.Comments.Add(post); db.SaveChanges(); var usr = db.AspNetUsers.FirstOrDefault(x => x.Id == post.UserId); var ret = new { Message = post.Text, PostedBy = post.UserId, PostedByName = usr.UserName, PostedByAvatar = post.AspNetUsers.AvatarUrl, PostedDate = TimeAgo(post.Date), //PostId = post.Id }; Clients.Caller.addPost(ret); Clients.Others.newPost(ret, DemId1); } }
public ActionResult Index() { DemoTagsViewModel model = new DemoTagsViewModel(); using (var context = new Entities()) { model.demoList = context.Demotivators.ToList(); model.tagsList = context.Tags.ToList(); } return View(model); }