public IActionResult DeleteBlogPost(int id)
{
var blogPostToDelete = (from m in dataContext.BlogPosts where m.BlogPostId == id select m).FirstOrDefault();
var comments = (from m in dataContext.Comments where m.BlogPostId == id select m);
var photos = (from m in dataContext.Photos where m.BlogPostId == id select m);
if (comments != null)
{
blogPostToDelete.Comments = (from m in dataContext.Comments where m.BlogPostId == id select m).Include(p => p.User).ToList();
}
if (photos != null)
{
blogPostToDelete.Photos = (from m in dataContext.Photos where m.BlogPostId == id select m).ToList();
}
dataContext.Remove(blogPostToDelete);
foreach (var photo in blogPostToDelete.Photos)
{
dataContext.Remove(photo);
}
foreach (var comment in blogPostToDelete.Comments)
{
dataContext.Remove(comment);
}
dataContext.SaveChanges();
return(RedirectToAction("Index"));
}
public IActionResult DeleteBlog(int id)
{
var getSpecificBlog = (from b in _assignment1DataContext.BlogPosts
where b.BlogPostId == id
select b
).FirstOrDefault();
//get all the rows that blogpostid contains
var getSpecificComment = (from b in _assignment1DataContext.Comments
where b.BlogPostId == id
select b
).ToList();
var getSpecificPhotos = (from b in _assignment1DataContext.Photos
where b.BlogPostId == id
select b
).ToList();
for (int i = 0; i < getSpecificComment.Count(); i++)
{
_assignment1DataContext.Comments.Remove(getSpecificComment[i]);
_assignment1DataContext.SaveChanges();
}
for (int i = 0; i < getSpecificPhotos.Count(); i++)
{
_assignment1DataContext.Photos.Remove(getSpecificPhotos[i]);
_assignment1DataContext.SaveChanges();
}
_assignment1DataContext.Remove(getSpecificBlog);
_assignment1DataContext.SaveChanges();
return(RedirectToAction("Index"));
}
public IActionResult DeleteBlogPost(int id)
{
/*
* var photosToDelete = (from p in _assignment2DataContext.Photos where p.BlogPostId == id select p).ToList();
*
* if(photosToDelete != null)
* {
* foreach (var photo in photosToDelete)
* {
* _assignment2DataContext.Remove(photo);
* }
* }
*
* var commentsToDelete = (from c in _assignment2DataContext.Comments where c.BlogPostId == id select c).ToList();
*
* if (commentsToDelete != null)
* {
* foreach (var comment in commentsToDelete)
* {
* _assignment2DataContext.Remove(comment);
* }
* }
*/
var blogPostToDelete = (from b in _assignment2DataContext.BlogPosts where b.BlogPostId == id select b).FirstOrDefault();
_assignment2DataContext.Remove(blogPostToDelete);
_assignment2DataContext.SaveChanges();
return(RedirectToAction("Index"));
}
public IActionResult DeleteBlog(BlogPost blog)
{
var deleteId = (from c in _blogContext.BlogPosts where c.BlogPostId == c.BlogPostId select c).FirstOrDefault(); //TODO DELETE THE RIGHT ONE NOT THE FIRST ONE EVERY TIME
_blogContext.Remove(deleteId); //delete the id object
_blogContext.SaveChanges(); //save the changes
return(RedirectToAction("Index"));
}
public IActionResult DeletePhoto(int id)
{
var deleteId = (from c in _context.Photos where c.PhotoId == id select c).FirstOrDefault();
_context.Remove(deleteId);
var blogId = Convert.ToInt32(Request.Form["BlogPostId"]);
_context.SaveChanges();
return(RedirectToAction("EditBlogPost" + blogId));
}
