public static async Task <int> AddCategoryAsync(this BlogWebDbContext _dbContext, CategoryCreateModel model)
{
Category category = new Category
{
Name = model.Name
};
_dbContext.Categories.Add(category);
return(await _dbContext.SaveChangesAsync());
}
public static async Task <int> RemoveCategoryAsync(this BlogWebDbContext _dbContext, int id)
{
Category category = await _dbContext.Categories.FindAsync(id);
if (category != null)
{
_dbContext.Categories.Remove(category);
}
return(await _dbContext.SaveChangesAsync());
}
public static async Task <int> RemoveContactMessageAsync(this BlogWebDbContext _dbContext, int id)
{
ContactMessage c = await _dbContext.ContactMessages.FindAsync(id);
if (c != null)
{
_dbContext.ContactMessages.Remove(c);
}
return(await _dbContext.SaveChangesAsync());
}
public static async Task <int> RemovePostAsync(this BlogWebDbContext _dbContext, int id)
{
Post p = await _dbContext.Posts.FindAsync(id);
if (p != null)
{
_dbContext.Posts.Remove(p);
}
return(await _dbContext.SaveChangesAsync());
}
public static async Task <int> SendMessageAsync(this BlogWebDbContext _dbContext, ContactMessageViewModel model)
{
ContactMessage message = new ContactMessage
{
Email = model.Email,
SubmmittedDate = DateTime.Now,
Message = model.Message,
Name = model.Name,
Subject = model.Subject
};
_dbContext.ContactMessages.Add(message);
return(await _dbContext.SaveChangesAsync());
}
public static async Task <int> AddCommentAsync(this BlogWebDbContext _dbContext, CommentPostModel model)
{
Comment comment = new Comment
{
Email = model.Email,
SubmmittedDate = DateTime.Now,
Message = model.Message,
PostId = model.PostId,
Username = model.Username,
Website = model.Website,
UserId = 1
};
_dbContext.Comments.Add(comment);
return(await _dbContext.SaveChangesAsync());
}
public static async Task <int> SavePostAsync(this BlogWebDbContext _dbContext, PostEditModel model)
{
var category = await _dbContext.Categories.Where(x => x.Name == model.CategoryName).FirstOrDefaultAsync();
var existingPost = await _dbContext.Posts.FindAsync(model.Id);
Post post = new Post
{
AuthorId = model.AuthorId,
CategoryId = model.CategoryId,
ImageData = model.ImageData ?? existingPost.ImageData,
ImageMimeType = model.ImageMimeType ?? existingPost.ImageMimeType,
ShortDescription = model.ShortDescription,
Text = model.Text,
PublishDate = model.WrittenDate,
WrittenDate = model.WrittenDate,
Title = model.Title,
Category = category,
ArchiveId = 1
};
if (existingPost == null)
{
_dbContext.Posts.Add(post);
}
else
{
Post dbEntry = await _dbContext.Posts.FindAsync(model.Id);
if (dbEntry != null)
{
dbEntry.Title = post.Title ?? existingPost.Title;
dbEntry.CategoryId = category.Id;
dbEntry.ImageData = post.ImageData ?? existingPost.ImageData;
dbEntry.ImageMimeType = post.ImageMimeType ?? existingPost.ImageMimeType;
dbEntry.ShortDescription = post.ShortDescription ?? existingPost.ShortDescription;
dbEntry.Text = post.Text ?? existingPost.Text;
dbEntry.PublishDate = post.WrittenDate;
dbEntry.WrittenDate = post.WrittenDate;
}
}
return(await _dbContext.SaveChangesAsync());
}
