public DeleteModel(GadgetHub.Data.GadgetHubContext context) { _context = context; }
public IndexModel(GadgetHub.Data.GadgetHubContext context) { _context = context; }
public DetailsModel(GadgetHub.Data.GadgetHubContext context) { _context = context; }
public CreateModel(GadgetHub.Data.GadgetHubContext context) { _context = context; }
public EditModel(GadgetHub.Data.GadgetHubContext context) { _context = context; }
public static void Initialize(GadgetHubContext context) { context.Database.EnsureCreated(); // Look for any customer. if (context.Customer.Any()) { return; // DB has been seeded } var customers = new Customer[] { new Customer { CustomerFirstname = "Aryan", CustomerLastname = "Shah", CustomerAddress = "45 Great North Road", CustomerContactNumber = "02182374932" }, new Customer { CustomerFirstname = "Brooklyn", CustomerLastname = "Eti", CustomerAddress = "27 Brook Street", CustomerContactNumber = "02342058462" }, new Customer { CustomerFirstname = "Zara", CustomerLastname = "Colaco", CustomerAddress = "35 Delta Avenue", CustomerContactNumber = "02324839583" }, new Customer { CustomerFirstname = "Kian", CustomerLastname = "Chico", CustomerAddress = "7 Titirangi Road", CustomerContactNumber = "02103284396" }, new Customer { CustomerFirstname = "Faith", CustomerLastname = "Dahunan", CustomerAddress = "85 Glen Eden Road", CustomerContactNumber = "02103859485" }, new Customer { CustomerFirstname = "Jarred", CustomerLastname = "Malijan", CustomerAddress = "19 New North Road", CustomerContactNumber = "02105866934" }, }; context.Customer.AddRange(customers); context.SaveChanges(); var employees = new Employees[] { new Employees { EmployerFirstname = "Cyruss", EmployerLastname = "Sese", EmployerAddress = "60 Holly Street", EmployerContactNumber = "02108044689" }, new Employees { EmployerFirstname = "Ivan", EmployerLastname = "Lee", EmployerAddress = " 10 Kelwyn Road", EmployerContactNumber = "02134940294" }, }; context.Employees.AddRange(employees); context.SaveChanges(); var products = new Products[] { new Products { ProductName = "Iphone 11", ProductBrand = "Apple", Supplier = "Apple Inc." }, new Products { ProductName = "Iphone 11 Pro", ProductBrand = "Apple", Supplier = "Apple Inc." }, new Products { ProductName = "Iphone 12 ", ProductBrand = "Apple", Supplier = "Apple Inc." }, new Products { ProductName = "Iphone 12 Pro", ProductBrand = "Apple", Supplier = "Apple Inc." }, new Products { ProductName = "Iphone 12 Pro Max", ProductBrand = "Apple", Supplier = "Apple Inc." }, new Products { ProductName = "Samsung Galaxy S21 5G", ProductBrand = "Samsung", Supplier = "Samsung Inc." }, new Products { ProductName = "Samsung Galaxy S21 Ultra 5G", ProductBrand = "Samsung", Supplier = "Samsung Inc." }, new Products { ProductName = "Huawei Nova 5T", ProductBrand = "Huawei", Supplier = "Huawei Inc." }, new Products { ProductName = "Huawei Mate 40 Pro", ProductBrand = "Huawei", Supplier = "Huawei Inc." }, new Products { ProductName = "Asus Zenfone 5", ProductBrand = "Asus", Supplier = "Asus Inc." }, new Products { ProductName = "Rog Phone 5", ProductBrand = "Asus", Supplier = "Asus Inc." }, new Products { ProductName = "Rog Phone 5 Ultimate", ProductBrand = "Asus", Supplier = "Asus Inc." }, }; context.Products.AddRange(products); context.SaveChanges(); var sales = new Sales[] { new Sales { ProductsID = products.Single(s => s.ProductName == "Huawei Nova 5t").ProductsID, CustomerID = customers.Single(s => s.CustomerFirstname == "Aryan").CustomerID, EmployeesID = employees.Single(s => s.EmployerFirstname == "Cyruss").EmployeesID } }; context.Sales.AddRange(sales); context.SaveChanges(); }