public PartialViewResult UserHavntReadNewsTopList() { //IEnumerable<UserNews> userNews = dbUserNews.GetAll().Where(n => n.read == false&&n.UserId==User.Identity.GetUserName()).ToList(); List <UserNews> userNewss = dbUserNews.GetAll().Where(n => n.read == false && n.UserId == User.Identity.GetUserName()).OrderByDescending(n => n.time).Take(5).ToList(); List <UserNewsViewModel> unvms = new List <UserNewsViewModel>(); foreach (UserNews uns in userNewss) { UserNewsViewModel unvm = new UserNewsViewModel { UserNews = uns, UserNewsUrlss = db.UserNewsUrls.Where(n => n.UserNewsSn == uns.sn).ToList(), FromUserName = db.AspNetUsers.Where(n => n.UserName == uns.fromUser).Select(n => n.Name).FirstOrDefault() }; unvms.Add(unvm); } return(PartialView(unvms)); }
public ActionResult UserMessage() { List <UserNews> userNewss = dbUserNews.GetAll().Where(n => n.UserId == User.Identity.GetUserName()).OrderByDescending(n => n.time).ToList(); List <UserNewsViewModel> unvms = new List <UserNewsViewModel>(); foreach (UserNews uns in userNewss) { UserNewsViewModel unvm = new UserNewsViewModel { UserNews = uns, UserNewsUrlss = db.UserNewsUrls.Where(n => n.UserNewsSn == uns.sn).ToList(), FromUserName = db.AspNetUsers.Where(n => n.UserName == uns.fromUser).Select(n => n.Name).FirstOrDefault() }; unvms.Add(unvm); } //return View(userNewss); return(View(unvms)); }
public JsonResult GetUserHavntReadNews() { //IEnumerable<UserNews> userNews = dbUserNews.GetAll().Where(n => n.read == false&&n.UserId==User.Identity.GetUserName()).ToList(); List <UserNews> userNewss = dbUserNews.GetAll().Where(n => n.read == false && n.UserId == User.Identity.GetUserName()).ToList(); List <UserNewsViewModel> unvms = new List <UserNewsViewModel>(); foreach (UserNews uns in userNewss) { UserNewsViewModel unvm = new UserNewsViewModel { UserNews = uns, UserNewsUrlss = db.UserNewsUrls.Where(n => n.UserNewsSn == uns.sn).ToList(), FromUserName = db.AspNetUsers.Where(n => n.UserName == uns.fromUser).Select(n => n.Name).FirstOrDefault() }; unvms.Add(unvm); } return(Json(unvms, JsonRequestBehavior.AllowGet)); }