Example #1
0
        public ActionResult Index()
        {
            using (blogEntities ct = new blogEntities()) {
                History h = new History();

                h.CreateTime = DateTime.Now;
                h.Guest = "guest";
                h.Url = "/";
                h.IP = Request.UserHostAddress;

                ct.Histories.Add(h);
                ct.SaveChanges();
            }

            IndexModel model = new IndexModel();

            if (IsLogin) {
                model.Passport = base.Passport;
                using (blogEntities en = new blogEntities()) {
                    var users = en.Friends.Where(f => f.Self.Equals(Passport.AccountID)).Select(f => f.FriendID).ToList();

                    model.Topics =
                        (from t in en.Topics.Include("Comments")
                         where t.Author.Equals(Passport.AccountID)
                         || users.Contains(t.Author)
                         orderby t.CreateTime descending
                         select t
                             ).ToList();

                    //en.Topics
                    //.Where(
                    //    t =>
                    //        t.Author.Equals(Passport.AccountID)
                    //        || users.Contains(t.Author)
                    //)
                    //.OrderByDescending(t => t.CreateTime)

                    //.ToList();

                    if (en.Users.Count(u => u.UserID.Equals(Passport.AccountID)) > 0) {
                        model.Author = en.Users.Where(u => u.UserID.Equals(Passport.AccountID)).First();
                    }
                }
            }
            else {
                return Redirect("~/Account/LogOn");
            }

            return View(model);

            //return Json(model, JsonRequestBehavior.AllowGet);
        }
Example #2
0
        public ActionResult Index1(string userid)
        {
            ViewBag.Message = "欢迎使用 ASP.NET MVC!";

            IndexModel model = new IndexModel();

            model.Passport = base.Passport;
            using (blogEntities en = new blogEntities()) {
                model.Topics = en.Topics.Where(t => t.Author.Equals(userid))
                    .OrderByDescending(t => t.CreateTime).ToList();
                if (en.Users.Count(u => u.UserID.Equals(userid)) > 0) {
                    model.Author = en.Users.Where(u => u.UserID.Equals(userid)).First();
                    //model.Firends = model.Author.Friends.Select<Friend,User>()
                }
            }

            return View(model);
        }