public async Task <bool> Create(CommentModel comment, int articleId)
{
comment.ArticleId = articleId;
await _theraphosidaeContext.Comments.AddAsync(comment);
return(await _theraphosidaeContext.SaveChangesAsync() > 0);
}
public async Task <bool> Create(SpiderModel spider, int animalTaxonomyId)
{
spider.AnimalTaxonomyId = animalTaxonomyId;
await _theraphosidaeContext.Spiders.AddAsync(spider);
return(await _theraphosidaeContext.SaveChangesAsync() > 0);
}
public async Task <bool> Delete(int articleId)
{
var taxonomiesToRemove = await _context.Taxonomies.Where(t => t.ArticleId == articleId).ToListAsync();
foreach (var taxonomy in taxonomiesToRemove)
{
_context.Taxonomies.Remove(taxonomy);
}
return(await _context.SaveChangesAsync() > 0);
}
private async Task <MediaModel> SaveToDatabase(ImageUploadResult uploadResult, string fileNameLong, ArticleModel article)
{
var fileName = Path.GetFileNameWithoutExtension(fileNameLong);
var medium = new MediaModel
{
Id = uploadResult.PublicId,
Url = uploadResult.SecureUrl.AbsoluteUri,
Name = fileName,
Description = fileName,
Type = uploadResult.Format,
Article = article,
Length = ConvertBytesToMegabytes(uploadResult.Length)
};
await _context.Medias.AddAsync(medium);
await _context.SaveChangesAsync();
return(medium);
}
public async Task <bool> Create(AnimalTaxonomyModel AnimalTaxonomy)
{
await _context.AnimalTaxonomies.AddAsync(AnimalTaxonomy);
return(await _context.SaveChangesAsync() > 0);
}
public async Task <bool> Create(ReportModel report)
{
await _theraphosidaeContext.Reports.AddAsync(report);
return(await _theraphosidaeContext.SaveChangesAsync() > 0);
}
public async Task <bool> Update(MediaModel media)
{
_context.Medias.Update(media);
return(await _context.SaveChangesAsync() > 0);
}
public async Task <bool> Create(ImageModel spiderImage)
{
await _theraphosidaeContext.Images.AddAsync(spiderImage);
return(await _theraphosidaeContext.SaveChangesAsync() > 0);
}
public async Task <bool> Create(CategoryModel category)
{
await _context.Categories.AddAsync(category);
return(await _context.SaveChangesAsync() > 0);
}
public async Task <bool> Create(TagModel tag)
{
await _context.Tags.AddAsync(tag);
return(await _context.SaveChangesAsync() > 0);
}
public async Task <bool> Create(ArticleModel article)
{
await _context.Articles.AddAsync(article);
return(await _context.SaveChangesAsync() > 0);
}
