public ActionResult MyFriends() { ValidationLogin(); MyFriends model = new MyFriends(); using (var ct = new SunMoon.Blog.DataAccess.EntityFramework.blogEntities()) { var lists = ct.Friends.Where(f => f.Self.ToLower().Equals(Passport.AccountID.ToLower())).ToList(); var results = new List<FriendInfo>(); foreach (var ff in lists) { FriendInfo friend = new FriendInfo(); friend.Friend.UserID = ff.FriendID; friend.Friend.FirstName = ff.User.FirstName; friend.Friend.LastName = ff.User.LastName; results.Add(friend); } model.Friends = results; } return View(model); }
public ActionResult Create(string topicID, string commentID, string description) { try { // TODO: Add insert logic here using (blogEntities ct = new blogEntities()) { Comment c = new Comment(); c.Author = base.Passport.AccountID; c.CreateTime = DateTime.Now; c.Description = description; c.ID = Guid.NewGuid(); c.IP = Request.UserHostAddress; if (!string.IsNullOrWhiteSpace(commentID)) c.ParentId = Guid.Parse(commentID); c.TopicID = Guid.Parse(topicID); ct.Comments.Add(c); ct.SaveChanges(); } return RedirectToAction("Index", "Home"); } catch { return View(); } }
public ActionResult AddFriend(AddFriend model) { model.Friend = model.Friend.Trim(); using (var ct = new SunMoon.Blog.DataAccess.EntityFramework.blogEntities()) { var user = ct.Users.Single(u => u.UserID.Equals(Passport.AccountID)); var friend = ct.Users.Single(u => u.UserID.Equals(model.Friend)); SunMoon.Blog.DataAccess.EntityFramework.Friend f = new DataAccess.EntityFramework.Friend(); f.Self = user.UserID; f.FriendID = model.Friend; f.CreateTime = DateTime.Now; ct.Friends.Add(f); Friend ff = new Friend(); ff.Self = model.Friend; ff.FriendID = user.UserID; ff.CreateTime = DateTime.Now; ct.Friends.Add(ff); ct.SaveChanges(); } return View(); }
public ActionResult GetTopicsView(int? id) { if (!IsLogin) { return View(); } TopicsPartial model = new TopicsPartial(); if (id != null) model.BeginIndex = id; using (blogEntities ct = new blogEntities()) { var users = ct.Friends.Where(f => f.Self.Equals(Passport.AccountID)).Select(f => f.FriendID).ToList(); var lists = from t in ct.Topics.Include("Comments") where t.Author.Equals(Passport.AccountID) || users.Contains(t.Author) orderby t.CreateTime descending select t; model.Topics = lists.Skip(model.BeginIndex.Value).Take(model.Count).ToList(); model.BeginIndex += model.Count; if (lists.Count() > model.BeginIndex) model.HaveNextRecord = true; else model.HaveNextRecord = false; } return View(model); }
public ActionResult QueryPerson(QueryPerson model) { if (!IsLogin) { return View(); } using (blogEntities en = new blogEntities()) { var result = from user in en.Users where !Passport.AccountID.Equals(user.UserID) && user.UserID.Contains(model.Keyword) || user.FirstName.Contains(model.Keyword) || user.LastName.Equals(model.Keyword) || user.FirstNamePy.Equals(model.Keyword) || user.LastNamePy.Equals(model.Keyword) select new PersonInfo() { Age = 20, DisplayName = user.FirstName + user.LastName, Name = user.UserID, Sex = user.Sex }; model.Persons = result.ToList(); } return View(model); }
public ActionResult AddFriend(AddFriend model) { //if (!IsLogin) { // return View(); //} using (blogEntities ct = new blogEntities()) { //SunMoon.Blog.DataAccess.EntityFramework.Friend f = new DataAccess.EntityFramework.Friend(); //f.CreateTime = DateTime.Now; //f.FriendID = model.Friend; //f.Self = base.Passport.AccountID; //ct.Friends.Add(f); SunMoon.Blog.DataAccess.EntityFramework.Message msg = new Message(); msg.ID = Guid.NewGuid(); msg.Author = Passport.AccountID; msg.CreateTime = DateTime.Now; msg.Description = "{'type':'addfriend'}"; msg.Owner = model.Friend; ct.Messages.Add(msg); ct.SaveChanges(); return RedirectToAction("queryperson"); } }
public ActionResult MyFriends() { ValidationLogin(); MyFriends model = new MyFriends(); using (var ct = new SunMoon.Blog.DataAccess.EntityFramework.blogEntities()) { var lists = ct.Friends.Where(f => f.Self.ToLower().Equals(Passport.AccountID.ToLower())).ToList(); var results = new List <FriendInfo>(); foreach (var ff in lists) { FriendInfo friend = new FriendInfo(); friend.Friend.UserID = ff.FriendID; friend.Friend.FirstName = ff.User.FirstName; friend.Friend.LastName = ff.User.LastName; results.Add(friend); } model.Friends = results; } return(View(model)); }
public ActionResult AddFriend(AddFriend model) { model.Friend = model.Friend.Trim(); using (var ct = new SunMoon.Blog.DataAccess.EntityFramework.blogEntities()) { var user = ct.Users.Single(u => u.UserID.Equals(Passport.AccountID)); var friend = ct.Users.Single(u => u.UserID.Equals(model.Friend)); SunMoon.Blog.DataAccess.EntityFramework.Friend f = new DataAccess.EntityFramework.Friend(); f.Self = user.UserID; f.FriendID = model.Friend; f.CreateTime = DateTime.Now; ct.Friends.Add(f); Friend ff = new Friend(); ff.Self = model.Friend; ff.FriendID = user.UserID; ff.CreateTime = DateTime.Now; ct.Friends.Add(ff); ct.SaveChanges(); } return(View()); }
public ActionResult GetMessages() { using (blogEntities ct = new blogEntities()) { var lists = ct.Messages.Where(m => m.Owner.Equals(Passport.AccountID)).ToList(); Models.Messages model = new Models.Messages(); model.Store = lists; return View(model); } }
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); }
public ActionResult AddTopic(string title, string desc) { using (blogEntities en = new blogEntities()) { Topic t = new Topic(); t.Title = title; t.Description = desc; t.CreateTime = t.UpdateTime = DateTime.Now; t.Author = base.Passport.AccountID; t.ID = Guid.NewGuid(); en.Topics.Add(t); en.SaveChanges(); return View(t); } }
public ActionResult AddComment(string description, Guid topicId) { using (blogEntities ct = new blogEntities()) { Comment comment = new Comment(); comment.ID = Guid.NewGuid(); comment.CreateTime = DateTime.Now; comment.Author = base.Passport.AccountID; comment.IP = Request.UserHostAddress; comment.Description = description; comment.TopicID = topicId; ct.Comments.Add(comment); ct.SaveChanges(); return View(comment); } //return RedirectToAction("index", "home"); }
public ActionResult QueryPerson() { base.ValidationLogin(); QueryPerson model = new QueryPerson(); using (blogEntities en = new blogEntities()) { var result = from user in en.Users select new PersonInfo() { Age = 20, DisplayName = user.FirstName + user.LastName, Name = user.UserID, Sex = user.Sex }; model.LoginUser = base.Passport; model.Persons = result.ToList(); } return View(model); }
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); }
public ActionResult LogOn(LogOnModel model, string returnUrl) { try { using (blogEntities ct = new blogEntities()) { var result = ct.Users.Find(model.UserName); if (result != null && result.Passwrod.Equals(model.Password)) { //登录成功。 Passport pp = new Passport(); pp.AccountID = model.UserName; pp.LoginTime = System.DateTime.Now; pp.IP = Request.UserHostAddress; Session.Add("passport", pp); return RedirectToAction("Index", "Home"); } else { //用户名或者密码错误。 ModelState.AddModelError("", "提供的用户名或密码不正确。"); } } // 如果我们进行到这一步时某个地方出错,则重新显示表单 return RedirectToAction("LogOn"); } catch (Exception ex) { string path = AppDomain.CurrentDomain.BaseDirectory + "log.txt"; StreamWriter sw = null; if (!System.IO.File.Exists(path)) sw = System.IO.File.CreateText(path); else sw = System.IO.File.AppendText(path); sw.WriteLine(ex.Message); sw.Close(); } return View(); }
public ActionResult Register(RegisterModel model) { using (blogEntities en = new blogEntities()) { User user = new User(); user.UserID = model.UserName; user.Passwrod = model.Password; user.Mail = model.Email; en.Users.Add(user); en.SaveChanges(); } return RedirectToAction("Index", "Home"); }