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;