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"); } }