public void CreateComment(int postid)
{
using (var db = new DatabaseBlog())
{
var user = db.Users.Find(Convert.ToInt32(UserService.GetCurrentUserId()));
var post = db.Posts.Find(postid);
var comm = new Comment();
comm.comment = CommentText ?? "no";
comm.UserID = user.UserID;
comm.Username = user.Username;
comm.Date = DateTime.Now;
if (comm.comment == "no")
{
CommentErrorColor = "red";
CommentError = "You can't publish an empty comment.";
}
else
{
post.Comment.Add(comm);
db.SaveChanges();
post.CommentCount = CommentService.CommentCount(postid);
db.SaveChanges();
CommentText = null;
CommentErrorColor = "green";
CommentError = "";
CommentService.LoadComments(postid, Comments);
PostService.LoadPost(Posts);
}
}
}
//Method for the comments
public void DeleteComment(int postid, int CommentID)
{
using (var db = new DatabaseBlog())
{
var comment = db.Comments.Find(CommentID);
var post = db.Posts.Find(postid);
db.Comments.Remove(comment);
db.SaveChanges();
post.CommentCount = post.CommentCount = CommentService.CommentCount(postid);
db.SaveChanges();
CommentService.LoadComments(postid, Comments);
PostService.LoadPost(Posts);
}
}
public void SignUp()
{
using (var db = new DatabaseBlog())
{
var user = new User();
user.Username = Username;
user.Password = Password;
user.Email = Email;
user.Country = Country;
user.Userrole = Role;
if (UserService.CheckEmail(Email) == true)
{
ErrorMessage = "The email is alredy taken";
Email = "-";
}
else
{
if (UserService.CheckUsername(Username) == true)
{
ErrorMessage = "The Username is alredy Taken";
Username = "******";
}
else
{
db.Users.Add(user);
db.SaveChanges();
}
}
}
}
public void Delete(int id)
{
using (var db = new DatabaseBlog())
{
var post = db.Posts.Find(id);
db.Posts.Remove(post);
db.SaveChanges();
PostService.LoadMyPost(Posts);
}
}
public void DeleteUser(int id)
{
using (var db = new DatabaseBlog())
{
var user = db.Users.Find(id);
db.Users.Remove(user);
db.SaveChanges();
UserService.LoadUser(Users);
}
}
public void ChangeCategory(int id)
{
using (var db = new DatabaseBlog())
{
var post = db.Posts.Find(id);
post.Category = NewPostCategory;
db.SaveChanges();
ChangeCategoryVisible = false;
PostService.LoadPost(Posts);
}
}
public static void CreatePost(int userid, string Title, string Text)
{
using (var db = new DatabaseBlog())
{
var post = new Post();
post.UserID = userid;
post.Title = Title;
post.Text = Text;
db.Posts.Add(post);
db.SaveChanges();
}
}
public void CreatePost()
{
var userid = Convert.ToInt32(UserService.GetCurrentUserId());
using (var db = new DatabaseBlog())
{
var user = db.Users.Find(userid);
var post = new Post();
post.Title = Title;
post.Text = Text;
post.Date = DateTime.Now;
post.UserID = userid;
post.Category = NewPostCategory;
post.CreatorName = user.Username.ToString();
db.Posts.Add(post);
db.SaveChanges();
Context.RedirectToRoute("MyProfile");
}
}