public static void Initialize(QualityBooksContext context)
{
context.Database.EnsureCreated();
// Look for any students.
if (context.Categories.Any())
{
return; // DB has been seeded
}
var categories = new Category[]
{
new Category {
CategroyName = "Arts & Music"
},
new Category {
CategroyName = "Business"
},
new Category {
CategroyName = "Sports"
},
new Category {
CategroyName = "Maori Culture"
},
};
foreach (Category c in categories)
{
context.Categories.Add(c);
}
context.SaveChanges();
var suppliers = new Supplier[]
{
new Supplier {
FirstName = "John", LastName = "Liew", HomePhoneNo = "210856677", MobileNo = "210856677", Email = "*****@*****.**"
},
new Supplier {
FirstName = "Zane", LastName = "Chau", HomePhoneNo = "210856577", MobileNo = "210856577", Email = "*****@*****.**"
},
new Supplier {
FirstName = "Peter", LastName = "Tan", HomePhoneNo = "210856477", MobileNo = "210856477", Email = "*****@*****.**"
},
};
foreach (Supplier s in suppliers)
{
context.Suppliers.Add(s);
}
context.SaveChanges();
string path = Environment.CurrentDirectory + @"/wwwroot/images/Temp/defaultBook.jpg";
byte[] image = System.IO.File.ReadAllBytes(path);
var Product = new Product[]
{
new Product {
CategoryId = 1, Description = "This is super book", ProductImage = image, ProductName = "Clean Code", ProductPrice = 45, SupplierId = 1,
}
};
foreach (Product b in Product)
{
context.Products.Add(b);
}
context.SaveChanges();
}
public static void Initialize(QualityBooksContext context)
{
context.Database.EnsureCreated();
// Look for any students.
if (context.Categories.Any())
{
return; // DB has been seeded
}
var categories = new Category[]
{
new Category {
CategroyName = "Arts & Music"
},
new Category {
CategroyName = "Business"
},
new Category {
CategroyName = "Sports"
},
new Category {
CategroyName = "Maori Culture"
},
};
foreach (Category c in categories)
{
context.Categories.Add(c);
}
context.SaveChanges();
var suppliers = new Supplier[]
{
new Supplier {
FirstName = "Richard", LastName = "Conway", HomePhoneNo = "21553555", MobileNo = "21333377", Email = "*****@*****.**"
},
new Supplier {
FirstName = "Mike", LastName = "Ballard", HomePhoneNo = "210000000", MobileNo = "25555577", Email = "*****@*****.**"
},
new Supplier {
FirstName = "Peter", LastName = "Russell", HomePhoneNo = "23333377", MobileNo = "25677777", Email = "*****@*****.**"
},
};
foreach (Supplier s in suppliers)
{
context.Suppliers.Add(s);
}
context.SaveChanges();
string path = Environment.CurrentDirectory + @"/wwwroot/images/Temp/defaultBook.jpg";
byte[] image = System.IO.File.ReadAllBytes(path);
var Product = new Product[]
{
new Product {
CategoryId = 1, Description = "This is Book about Maori History", ProductImage = image, ProductName = "Maori History ", ProductPrice = 45, SupplierId = 1
}
};
foreach (Product b in Product)
{
context.Products.Add(b);
}
context.SaveChanges();
}