public DetailsModel(EgdeBookingSystemV2.Data.EgdeBookingSystemConnection context) { _context = context; }
public CreateModel(EgdeBookingSystemV2.Data.EgdeBookingSystemConnection context) { _context = context; }
public static void Initialize(EgdeBookingSystemConnection context) { //context.Database.EnsureCreated(); //if (!context.Categories.Any()) //{ // return; // DB has been seeded //} var categories = new Category[] { new Category { Name = "Tv" }, new Category { Name = "Mobil" }, new Category { Name = "PC" }, new Category { Name = "Sensorer" }, new Category { Name = "Diverse" } }; if (!context.Categories.Any()) { context.Categories.AddRange(categories); context.SaveChanges(); } var locations = new Location[] { new Location { Name = "KRS" }, new Location { Name = "GRM" } }; if (!context.Locations.Any()) { context.Locations.AddRange(locations); context.SaveChanges(); } var equipments = new Equipment[] { new Equipment { Name = "Iphone X", Info = "Hasta la vista BABY", ModelNumber = "1500 5151", CategoryID = categories.Single(i => i.ID == 1).ID, LocationID = locations.Single(i => i.ID == 2).ID }, new Equipment { Name = "Samsung S8", Info = "Hasta la mista BABY", ModelNumber = "1354648", CategoryID = categories.Single(s => s.Name == "Mobil").ID, LocationID = locations.Single(s => s.Name == "KRS").ID }, new Equipment { Name = "LG 40", Info = "Mellomstor TV", ModelNumber = "1355644648", CategoryID = categories.Single(s => s.Name == "Tv").ID, LocationID = locations.Single(s => s.Name == "GRM").ID }, new Equipment { Name = "Samsung 70", Info = "Stor TV", CategoryID = categories.Single(s => s.Name == "Tv").ID, LocationID = locations.Single(s => s.Name == "KRS").ID }, new Equipment { Name = "Iphone S", ModelNumber = "1354 6248", CategoryID = categories.Single(i => i.ID == 1).ID, LocationID = locations.Single(i => i.ID == 2).ID }, new Equipment { Name = "Samsung S7", Info = "Gammel mobil", ModelNumber = "1354648", CategoryID = categories.Single(s => s.Name == "Mobil").ID, LocationID = locations.Single(s => s.Name == "KRS").ID }, new Equipment { Name = "LG 46", Info = "Mellomstor TV", CategoryID = categories.Single(s => s.Name == "Tv").ID, LocationID = locations.Single(s => s.Name == "GRM").ID }, new Equipment { Name = "Sensor", ModelNumber = "111111", CategoryID = categories.Single(s => s.Name == "Sensorer").ID, LocationID = locations.Single(s => s.Name == "KRS").ID }, new Equipment { Name = "Sensor", ModelNumber = "22222", CategoryID = categories.Single(s => s.Name == "Sensorer").ID, LocationID = locations.Single(s => s.Name == "KRS").ID }, new Equipment { Name = "Sensor", ModelNumber = "333333", CategoryID = categories.Single(s => s.Name == "Sensorer").ID, LocationID = locations.Single(s => s.Name == "KRS").ID }, new Equipment { Name = "Sensor", ModelNumber = "4444444", CategoryID = categories.Single(s => s.Name == "Sensorer").ID, LocationID = locations.Single(s => s.Name == "KRS").ID }, new Equipment { Name = "Sensor", ModelNumber = "555555", CategoryID = categories.Single(s => s.Name == "Sensorer").ID, LocationID = locations.Single(s => s.Name == "KRS").ID }, new Equipment { Name = "Sensor", ModelNumber = "6666666", CategoryID = categories.Single(s => s.Name == "Sensorer").ID, LocationID = locations.Single(s => s.Name == "KRS").ID }, new Equipment { Name = "Sensor", ModelNumber = "777777", CategoryID = categories.Single(s => s.Name == "Sensorer").ID, LocationID = locations.Single(s => s.Name == "KRS").ID }, new Equipment { Name = "Sensor", ModelNumber = "88888", CategoryID = categories.Single(s => s.Name == "Sensorer").ID, LocationID = locations.Single(s => s.Name == "KRS").ID } }; if (!context.Equipments.Any()) { context.Equipments.AddRange(equipments); context.SaveChanges(); } var bookings = new Booking[] { new Booking { UserEmail = "*****@*****.**", StartDate = DateTime.Parse("2021-09-01 19:32"), EndDate = DateTime.Parse("2021-09-10 19:33"), EquipmentID = equipments.Single(i => i.ID == 1).ID }, new Booking { UserEmail = "*****@*****.**", StartDate = DateTime.Parse("2020-09-01 19:32"), EndDate = DateTime.Parse("2021-09-10 19:33"), EquipmentID = equipments.Single(i => i.ID == 1).ID }, new Booking { UserEmail = "*****@*****.**", StartDate = DateTime.Parse("2007-09-01 19:32"), EndDate = DateTime.Parse("2007-09-10 19:33"), EquipmentID = equipments.Single(i => i.ID == 1).ID }, new Booking { UserEmail = "*****@*****.**", StartDate = DateTime.Parse("2007-09-01 19:32"), EndDate = DateTime.Parse("2007-09-10 19:33"), EquipmentID = equipments.Single(i => i.ID == 1).ID }, new Booking { UserEmail = "*****@*****.**", StartDate = DateTime.Parse("2007-09-01 19:32"), EndDate = DateTime.Parse("2007-09-10 19:33"), EquipmentID = equipments.Single(i => i.ID == 1).ID }, new Booking { UserEmail = "*****@*****.**", StartDate = DateTime.Parse("2021-02-01 00:00:00"), EndDate = DateTime.Parse("2021-01-10 00:00:00"), EquipmentID = equipments.Single(i => i.ID == 2).ID } }; context.Bookings.AddRange(bookings); context.SaveChanges(); //var bookings = new Booking[] // { // new Booking { UserEmail = "*****@*****.**", StartDate = DateTime.parse("2021-09-01"), Endate = DateTime.parse("2021-09-01"), EquipmentID = 1 } // }; // context.Bookings.AddRange(bookings); // context.SaveChanges(); }