public void UpdateUser(FrameworkTables.User user)
{
SovaContext db = new SovaContext();
db.Update(user);
db.SaveChanges();
}
//update comment
public void UpdateComment(Comment comment)
{
SovaContext db = new SovaContext();
db.Comments.Update(comment);
db.SaveChanges();
}
//update post
public void UpdatePost(Post post)
{
SovaContext db = new SovaContext();
db.Posts.Update(post);
db.SaveChanges();
}
public List <FrameworkTables.User> GetUsers(PagingAttributes pagingAttributes)
{
SovaContext db = new SovaContext();
return(db.FrameworkUsers
.Skip(pagingAttributes.Page * pagingAttributes.PageSize)
.Take(pagingAttributes.PageSize).ToList());
}
///////////////////////
//
// Posts
//
///////////////////////
// Gets All Posts
public IList <Post> GetPosts(PagingAttributes pagingAttributes)
{
SovaContext db = new SovaContext();
return(db.Posts.Skip(pagingAttributes.Page * pagingAttributes.PageSize)
.Take(pagingAttributes.PageSize)
.ToList());
}
///////////////////////
//
// Users
//
///////////////////////
// Gets All GetUsers
public IList <User> QAGetUsers(PagingAttributes pagingAttributes)
{
SovaContext db = new SovaContext();
return(db.Users.Skip(pagingAttributes.Page * pagingAttributes.PageSize)
.Take(pagingAttributes.PageSize)
.ToList());
}
//create new post
public void CreatePost(Post post)
{
SovaContext db = new SovaContext();
post.Id = db.Posts.Max(x => x.Id) + 1;
post.CreationDate = DateTime.Now;
db.Add(post);
db.SaveChanges();
}
//create new comment
public void CreateComment(Comment comment)
{
SovaContext db = new SovaContext();
comment.Id = db.Comments.Max(x => x.Id) + 1;
comment.CreateDate = DateTime.Now;
db.Add(comment);
db.SaveChanges();
}
//delete comment
public bool DeleteComment(int commentId)
{
SovaContext db = new SovaContext();
var comment = db.Comments.Find(commentId);
if (comment == null)
{
return(false);
}
db.Remove(comment);
db.SaveChanges();
return(true);
}
public bool DeleteUser(int userId)
{
SovaContext db = new SovaContext();
var user = db.FrameworkUsers.Find(userId);
if (user == null)
{
return(false);
}
db.Remove(user);
db.SaveChanges();
return(true);
}
//delete post
public bool DeletePost(int postId)
{
SovaContext db = new SovaContext();
var post = db.Posts.Find(postId);
if (post == null)
{
return(false);
}
db.Remove(post);
db.SaveChanges();
return(true);
}
public void CreateUser(FrameworkTables.User user)
{
SovaContext db = new SovaContext();
var tmpList = db.Users.ToList();
if (tmpList.Count() == 0)
{
user.Id = 1;
}
else
{
user.Id = db.FrameworkUsers.Max(x => x.Id) + 1;
}
db.Add(user);
db.SaveChanges();
}
// get comment by id
public Comment GetComment(int commentId)
{
SovaContext db = new SovaContext();
return(db.Comments.Find(commentId));
}
public LinkPost GetLinkPostId(int linkId)
{
SovaContext db = new SovaContext();
return(db.LinkPosts.Find(linkId));
}
public int NumberGetLinkPost()
{
var db = new SovaContext();
return(db.LinkPosts.Count());
}
public int NumberOfUsers()
{
var db = new SovaContext();
return(db.Users.Count());
}
// Gets Number Of Posts
public int NumberOfPosts()
{
var db = new SovaContext();
return(db.Posts.Count());
}
public FrameworkTables.User GetUser(int userId)
{
SovaContext db = new SovaContext();
return(db.FrameworkUsers.Find(userId));
}
//Get a post by Id
public User QAGetUser(int userId)
{
SovaContext db = new SovaContext();
return(db.Users.Find(userId));
}
///////////////////////
//
// Linkpost
//
///////////////////////
// Gets All LinkPosts
// Gets Number Of Comments
public int NumberOfComments()
{
var db = new SovaContext();
return(db.Comments.Count());
}
//Get a post by Id
public Post GetPost(int postId)
{
SovaContext db = new SovaContext();
return(db.Posts.Find(postId));
}
public int numOfPages()
{
SovaContext db = new SovaContext();
return(db.FrameworkUsers.Count());
}