public static async Task AddDefaultBlogCategories(IServiceProvider services)
{
var context = services.GetRequiredService <AppDbContext>();
// first add the BlogCategoryName to be the parent of all BlogCategory in any languages
string[] BlogCategoryNames = { "Food", "Travel", "Music", "Lifestyle", "Fitness", "Sports" };
int[] BlogCategoryNamesId = { 1, 2, 3, 4, 5, 6 };
for (int i = 0; i < BlogCategoryNames.Length; i++)
{
var name = new BlogSourceCategoryName
{
Id = BlogCategoryNamesId[i],
Name = BlogCategoryNames[i]
};
await context.BlogSourceCategoryName.AddAsync(name);
}
await context.SaveChangesAsync();
string[] BlogCategoryNamesDe = { "Essen", "Reise", "Musik", "Lebensstil", "Fitness", "Sport" };
string[] BlogCategoryNamesAr = { "طعام", "السفر", "موسيقى", "أسلوب الحياة", "اللياقه البدنيه", "رياضة" };
for (int i = 0; i < BlogCategoryNames.Length; i++)
{
// De
var lDe = new BlogCategory
{
Name = BlogCategoryNamesDe[i],
SourceCategoryId = BlogCategoryNamesId[i],
LanguageId = LanguageCodeId[2]
};
await context.BlogCategory.AddAsync(lDe);
// Ar
var lAr = new BlogCategory
{
Name = BlogCategoryNamesAr[i],
SourceCategoryId = BlogCategoryNamesId[i],
LanguageId = LanguageCodeId[1]
};
await context.BlogCategory.AddAsync(lAr);
}
await context.SaveChangesAsync();
}
public async Task <ActionResult <string> > PutSourceCategoryName([FromForm] BlogSourceCategoryDto sourcCate)
{
// check if this Source Name existing before
var sourceName = await _context.BlogSourceCategoryName.FirstOrDefaultAsync(n => n.Name == sourcCate.Name);
if (sourceName != null)
{
return(BadRequest(new ApiResponse(400, $"This {sourcCate.Name} category existing before!")));
}
// check if this name not exist
var name = await _context.BlogSourceCategoryName.FirstOrDefaultAsync(n => n.Id == sourcCate.Id);
if (name != null)
{
name.Name = sourcCate.Name;
_context.Entry(name).State = EntityState.Modified;
await _context.SaveChangesAsync();
return(Ok(new ApiResponse(201, $"Update {sourcCate.Name} Source BlogCategory Successfully")));
}
else if (name == null && sourcCate.Id != null)
{ // if user add id not exist
return(BadRequest(new ApiResponse(400, $"This Id {sourcCate.Id} not existing, If you want add new Source Blog's Category Set Id is empty or null!")));
}
else
{
var newSC = new BlogSourceCategoryName
{
Name = sourcCate.Name
};
await _context.BlogSourceCategoryName.AddAsync(newSC);
await _context.SaveChangesAsync();
return(Ok(new ApiResponse(201, $"Add {sourcCate.Name} Source BlogCategory successfully")));
}
}
public async Task <BlogSourceCategoryName> GetSourceBlogCategoryName([FromForm] int id)
{
BlogSourceCategoryName categoriesName = await _context.BlogSourceCategoryName.Where(c => c.Id == id).FirstOrDefaultAsync();
return(categoriesName);
}