public ActionResult SignUp(AuthUserModel signupUser)
{
User user;
using (var cx = new ViralContext())
{
if (cx.Users.Any(u => u.Username == signupUser.Username))
{
return(View("PartialSignup", signupUser));
}
user = cx.Users.Add(new User
{
Username = signupUser.Username,
Password = signupUser.Password,
Email = signupUser.Email,
AvatarPath = signupUser.AvatarPath,
RegisteredTime = DateTime.UtcNow
});
cx.SaveChanges();
}
FormsAuthentication.SetAuthCookie(user.Id.ToString(), true);
return(RedirectToAction("Index", "Home", user));
}
public static void Get(int id)
{
using (var cx = new ViralContext())
{
cx.Users.Find(id);
}
}
static void Main(string[] args)
{
using (var cx = new ViralContext())
{
var user = new User
{
Email = "*****@*****.**",
Username = "******",
Password = "******",
RegisteredTime = DateTime.UtcNow
};
var post = new Post
{
Title = "Funny title",
Text = "Funny text",
PostedTime = DateTime.UtcNow,
ContentPath = "url"
};
cx.Users.Add(user);
user.PostedPosts = new List <Post> {
post
};
cx.Posts.Add(post);
cx.SaveChanges();
/*var user1 = cx.Users.Find(1);
* var user2 = cx.Users.Find(2);
* var posts = cx.Posts.Where(p => p.Author.Id == 2).ToList();*/
}
Console.WriteLine("Finished");
Console.ReadKey();
}
public static void Add(User user)
{
using (var cx = new ViralContext())
{
cx.Users.Add(user);
cx.SaveChanges();
}
}
private bool Authenticate(AuthUserModel authUser, out User user)
{
using (var cx = new ViralContext())
{
user = cx.Users.SingleOrDefault(u => authUser.Username.Equals(u.Username, StringComparison.OrdinalIgnoreCase) && u.Password == authUser.Password);
return(user != null);
}
}
private ActionResult Rate(int?id, RatingType type)
{
using (var cx = new ViralContext())
{
var existingRating = cx.Ratings.SingleOrDefault(r => r.User.Id == CurrentUserId && r.Comment.Id == id);
if (existingRating != null)
{
existingRating.RatedTime = DateTime.UtcNow;
existingRating.Type = type;
cx.Entry(existingRating).State = EntityState.Modified;
}
else
{
var comment = cx.Comments
.Where(p => p.Id == id)
.Include(p => p.Ratings)
.SingleOrDefault();
if (comment == null)
{
return(RedirectToAction("Index", "Home"));
}
var user = cx.Users
.Where(u => u.Id == CurrentUserId)
.Include(u => u.Ratings)
.Single();
var rating = new Rating
{
RatedTime = DateTime.UtcNow,
Type = type
};
if (user.Ratings == null)
{
user.Ratings = new List <Rating>();
}
user.Ratings.Add(rating);
if (comment.Ratings == null)
{
comment.Ratings = new List <Rating>();
}
comment.Ratings.Add(rating);
cx.Entry(user).State = EntityState.Modified;
cx.Entry(comment).State = EntityState.Modified;
}
cx.SaveChanges();
return(RedirectToAction("Index", "Home"));
}
}
public ActionResult UserProfile(int id)
{
User model;
using (var cx = new ViralContext())
{
model = cx.Users.Find(id);
}
return(View("Index", model));
}
public ActionResult Edit(int id)
{
Post post;
using (var cx = new ViralContext())
{
post = cx.Posts.Find(id);
cx.SaveChanges();
}
return(View(post));
}
public ActionResult Index(int id)
{
Post post;
using (var cx = new ViralContext())
{
post = cx.Posts
.Where(p => p.Id == id)
.Where(p => !p.IsDeleted)
.Include(p => p.Ratings)
.Include(p => p.Comments)
.Include(p => p.Author)
.SingleOrDefault();
}
return(View(new PostModel(post)));
}
public ActionResult GetByPost(int postId)
{
var posts = new List <PostModel>();
using (var cx = new ViralContext())
{
foreach (var post in cx.Posts
.Where(p => !p.IsDeleted)
.Include(p => p.Ratings)
.Include(p => p.Comments)
.Include(p => p.Author))
{
posts.Add(new PostModel(post));
}
}
return(Json(posts.ToJson()));
}
public ActionResult GetTop(int pageIndex, int pageSize)
{
var posts = new List <PostModel>();
using (var cx = new ViralContext())
{
foreach (var post in cx.Posts
.Where(p => !p.IsDeleted)
.Include(p => p.Ratings)
.Include(p => p.Comments)
.Include(p => p.Author))
{
posts.Add(new PostModel(post));
}
}
return(Json(posts, JsonRequestBehavior.AllowGet));
}
public ActionResult Delete(int?id)
{
var currentUser = CurrentUser;
using (var cx = new ViralContext())
{
var savedComment = cx.Comments.SingleOrDefault(c => c.Id == id && c.Author.Id == currentUser.Id);
if (savedComment == null)
{
return(RedirectToAction("Index", "Home"));
}
savedComment.IsDeleted = true;
cx.Entry(savedComment).State = EntityState.Modified;
cx.SaveChanges();
return(RedirectToAction("Index", "Home"));
}
}
public ActionResult Edit(Comment comment)
{
var currentUser = CurrentUser;
using (var cx = new ViralContext())
{
var savedComment = cx.Comments.SingleOrDefault(c => c.Id == comment.Id && c.Author.Id == currentUser.Id);
if (savedComment == null)
{
return(RedirectToAction("Index", "Home"));
}
comment.PostedTime = savedComment.PostedTime;
cx.Comments.AddOrUpdate(comment);
cx.SaveChanges();
return(RedirectToAction("Index", "Home"));
}
}
public ActionResult Edit(Post post)
{
var currentUser = CurrentUser;
using (var cx = new ViralContext())
{
var savedPost = cx.Posts.SingleOrDefault(p => p.Id == post.Id && p.Author.Id == currentUser.Id);
if (savedPost == null)
{
return(RedirectToAction("Index", "Home"));
}
post.LastEditTime = savedPost.LastEditTime;
cx.Posts.AddOrUpdate(post);
cx.SaveChanges();
return(Index(post.Id));
}
}
public ActionResult Create(Comment comment)
{
var currentUser = CurrentUser;
using (var cx = new ViralContext())
{
comment.PostedTime = DateTime.UtcNow;
if (currentUser.PostedComments == null)
{
currentUser.PostedComments = new List <Comment>();
}
currentUser.PostedComments.Add(comment);
cx.Entry(currentUser).State = EntityState.Modified;
cx.Entry(comment).State = EntityState.Added;
cx.SaveChanges();
}
return(RedirectToAction("Index", "Home"));
}
public ActionResult Create(Post post)
{
var currentUser = CurrentUser;
using (var cx = new ViralContext())
{
post.PostedTime = DateTime.UtcNow;
post.LastEditTime = post.PostedTime;
if (currentUser.PostedPosts == null)
{
currentUser.PostedPosts = new List <Post>();
}
currentUser.PostedPosts.Add(post);
cx.Entry(currentUser).State = EntityState.Modified;
cx.Entry(post).State = EntityState.Added;
cx.SaveChanges();
}
return(View("Create"));
}
