public static void EnsureSeeded(this GuildedRoseContext context)
{
var imported = new CsvDataLoader("guilded.rose.api.Domain.Data.Inventory.csv").Build();
if (!context.Categories.Any())
{
var categories = imported.Select(import => import.Category).Distinct().Select(cat => new Category {
Name = cat
});
context.AddRange(categories);
context.SaveChanges();
}
if (!context.Items.Any())
{
var items = imported.Select(import => new Item
{
Name = import.Name,
Category = context.Categories.First(cat => cat.Name == import.Category),
CategoryId = context.Categories.First(cat => cat.Name == import.Category).Id,
SellIn = import.SellIn,
Quality = import.Quality,
DateCreated = DateTime.Now
});
context.AddRange(items);
context.SaveChanges();
}
}
public CategoryRepository(GuildedRoseContext context)
{
_context = context;
}
public ItemRepository(GuildedRoseContext context)
{
_context = context;
}
