public void AddCategory_AddsCategory()
{
// Arrange
using (var context = new ApplicationDbContext(_options))
{
context.Database.EnsureDeleted();
IResourceCategoryDataAccess categoryDataAccess = new ResourceCategoryDataAccess(context);
// Act
int result = categoryDataAccess.AddCategory("TestCategory");
// Assert
Assert.Equal("TestCategory", context.ResourceCategories.First().Name);
}
}
public void GetCategory_GetsCategories()
{
// Arrange
using (var context = new ApplicationDbContext(_options))
{
context.Database.EnsureDeleted();
IResourceCategoryDataAccess categoryDataAccess = new ResourceCategoryDataAccess(context);
categoryDataAccess.AddCategory("TestCategory");
categoryDataAccess.AddCategory("TestCategory2");
// Act
var result = categoryDataAccess.GetAllCategories();
// Assert
Assert.Equal(2, result.Count());
Assert.Equal("TestCategory", result.First().Name);
Assert.Equal("TestCategory2", result.Skip(1).First().Name);
}
}
private static int[] GetCategories(ResourceCategoryDataAccess resourceCategoryDataAccess)
{
int[] categories = new int[3];
var resourceCategories = resourceCategoryDataAccess.GetAllCategories();
if (resourceCategories.Any())
{
categories[0] = resourceCategories.First().Id;
categories[1] = resourceCategories.Skip(1).First().Id;
categories[2] = resourceCategories.Skip(2).First().Id;
}
else
{
categories[0] = resourceCategoryDataAccess.AddCategory("Software Development");
categories[1] = resourceCategoryDataAccess.AddCategory("Travel");
categories[2] = resourceCategoryDataAccess.AddCategory("Gambling");
}
return(categories);
}
static void Main(string[] args)
{
Console.WriteLine("This tool will clear and then repopulate the data in the database.");
Console.WriteLine("Press Y to continue, or any other key to cancel.");
ConsoleKeyInfo key = Console.ReadKey();
if (key.Key != ConsoleKey.Y)
{
return;
}
var builder = new ConfigurationBuilder()
.SetBasePath(Directory.GetCurrentDirectory())
.AddJsonFile("appsettings.json", optional: true, reloadOnChange: true);
IConfigurationRoot configuration = builder.Build();
Console.WriteLine(configuration.GetConnectionString("DefaultConnection"));
var options =
new DbContextOptionsBuilder <ApplicationDbContext>()
.UseSqlServer(configuration.GetConnectionString("DefaultConnection"))
.EnableSensitiveDataLogging()
.Options;
ApplicationDbContext applicationDbContext = new ApplicationDbContext(options);
var dataAccess = new ResourceDataAccess(applicationDbContext);
ResourceCategoryDataAccess resourceCategoryDataAccess = new ResourceCategoryDataAccess(applicationDbContext);
int[] categories = GetCategories(resourceCategoryDataAccess);
for (int i = 1; i <= 100; i++)
{
int category = _random.Next(categories.Length);
string webSiteAddress = $"www.{CreateWebAddress()}.{GetExtension()}";
dataAccess.CreateWebSite(categories[category], $"Test web site {i}", webSiteAddress);
}
}
