public static void Seed(this productsContext dbContext)
{
dbContext.product.AddRange(
new ProductDto()
{
Name = "galaxy bar", Price = 12.99, Stock = 42
},
new ProductDto()
{
Name = "20kg galaxy bar", Price = 12.99, Stock = 42
},
new ProductDto()
{
Name = "20kg galaxy bar", Price = 12.99, Stock = 42
},
new ProductDto()
{
Name = "20kg galaxy bar", Price = 12.99, Stock = 42
}
);
dbContext.productHistory.AddRange(
new ProductHistoryDto()
{
ProductId = 0, DateChange = DateTime.Now, Price = 12.99
},
new ProductHistoryDto()
{
ProductId = 1, DateChange = DateTime.Now, Price = 12.99
},
new ProductHistoryDto()
{
ProductId = 2, DateChange = DateTime.Now, Price = 12.99
},
new ProductHistoryDto()
{
ProductId = 3, DateChange = DateTime.Now, Price = 12.99
}
);
dbContext.review.AddRange(
new ReviewDto()
{
CustomerID = 0, ProductID = 32, Rating = 3, Comments = "fab", Visible = true
},
new ReviewDto()
{
CustomerID = 1, ProductID = 2, Rating = 5, Comments = "perfect", Visible = true
},
new ReviewDto()
{
CustomerID = 2, ProductID = 34, Rating = 1, Comments = "not to good", Visible = false
}
);
dbContext.SaveChanges();
}
public List <data> GetData()
{
using (var context = new productsContext())
{
context.Product.ToList().ForEach(i => {
data data = new data();
data.name = i.PName;
data.value = i.Count;
datalist.Add(data);
});
return(datalist);
}
}
public static productsContext getProductMockDb(string dbName)
{
// Create options for DbContext instance
var options = new DbContextOptionsBuilder <productsContext>()
.UseInMemoryDatabase(databaseName: dbName)
.Options;
// Create instance of DbContext
var dbContext = new productsContext(options);
// Add entities in memory
dbContext.Seed();
return(dbContext);
}
// public catalogbo()
// {
// }
public catalogbo(productsContext context)
{
_db = context;
}
private readonly productsContext _context; public dataController(productsContext context)
{
_context = context;
}
public TodoController(productsContext context) => _context = context;
public productsController(productsContext context)
{
_context = context;
}
public purchasesController(productsContext context) => _context = context;
