public void Seed(DbContext dbContext) { var modelFactory = new ModelFactory(); var responsibleSubject1 = ResponsibleSubjectModelFactory.CreateEmployee("Oliver", "Kahn"); dbContext.Set<Employee>() .Add(responsibleSubject1); //var pointlessInvestmentPlan = modelFactory.CreateInvestPlan("Trainingszentrum Säbener Straße", "Neues Trainingszentrum für FC Bayern Nachwuchsspieler", responsibleSubject1, // new DateTime(2014, 1, 1), (float) 0.1, (float) 0.1, (float) 0.5, null, 25, 1000000, 900000, 500000, 1000, (float) 0.1, 1000, 20000); //pointlessInvestmentPlan.Comparisons = new List<Comparison> // { // modelFactory.CreateComparison("Trainingszentrum in Braunschweig", 5, 50000000, 1200, 42, 31415.92f, (float) 0.1, 2000, 0) // }; //dbContext.Set<InvestmentPlan>() // .Add(pointlessInvestmentPlan); var excelInvestmentPlan = modelFactory.CreateInvestPlan("Excel Investmentplan", "Der Investmentplan aus dem Dokument", responsibleSubject1, new DateTime(2010, 01, 01), 0.1f, 0, 0, null, 15, 5000, 0, 0, 1500, 0, 0, 0); excelInvestmentPlan.Comparisons = new List<Comparison> { modelFactory.CreateComparison("Vergleich", 15, 8000, 0, 0, 750, 0, 0, 0) }; dbContext.Set<InvestmentPlan>() .Add(excelInvestmentPlan); dbContext.SaveChanges(); }
public void Seed(DbContext dbContext) { var assembly = Assembly.GetExecutingAssembly(); var initMap1 = MapModelFactory.CreateMap("Ebene 1", assembly.GetManifestResourceStream("OpenResKit.Meter.Resources.dummy_1.jpg")); var mp1 = MapModelFactory.CreateMapPosition(initMap1, 100, 100); var mp2 = MapModelFactory.CreateMapPosition(initMap1, 200, 200); var mp3 = MapModelFactory.CreateMapPosition(initMap1, 300, 300); var meter1 = ModelFactory.CreateMeter("Stromzähler", "AB1", "kWh", mp1); var meter2 = ModelFactory.CreateMeter("Generatorzähler", "AB2", "kWh", mp2); var meter3 = ModelFactory.CreateMeter("Wasserzähler", "AB3", "m³", mp3); dbContext.Set <Meter>() .Add(meter1); dbContext.Set <Meter>() .Add(meter2); dbContext.Set <Meter>() .Add(meter3); var emp1 = ResponsibleSubjectModelFactory.CreateEmployee("Peter", "Lustig"); var date = DateTime.Now.AddYears(-1); var s1 = SeriesModelFactory.CreateSeries("Stromrundgang", date, date.AddMinutes(30), date.AddDays(91), true, false, false, 1, 1, 13, new DayOfWeek[0]); var s2 = SeriesModelFactory.CreateSeries("Wasserbegehung", date, date.AddMinutes(30), date.AddDays(91), true, false, true, 2, 1, 6, new DayOfWeek[0]); CreateReadingSeeds(dbContext, s1, emp1, meter1, 8); CreateReadingSeeds(dbContext, s2, emp1, meter3, -1); CreateReadingSeeds(dbContext, s1, emp1, meter2, -1); dbContext.SaveChanges(); }
public void Seed(DbContext dbContext) { var employee = ResponsibleSubjectModelFactory.CreateEmployee("Dieter", "Schwarz"); dbContext.Set <Employee>() .Add(employee); for (var i = 1; i < 3; i++) { var name = "CarbonFootprint " + i; var description = "Description of CarbonFootprint " + i; var cf = CarbonFootprintFactory.CreateCarbonFootprint(name, description); cf.Positions = new Collection <CarbonFootprintPosition>(); foreach (var carbonFootprintPositionFactory in m_PositionFactories) { cf.Positions.Add(carbonFootprintPositionFactory.CreatePredefinedPosition(employee)); } dbContext.Set <CarbonFootprint>() .Add(cf); } dbContext.SaveChanges(); }
public void Seed(DbContext dbContext) { //var grabber = new NovaGrabber(); //foreach (Machine machine in grabber.getData()) //{ // dbContext.Set<Machine>().AddOrUpdate(machine); //} var responsibleSubject1 = ResponsibleSubjectModelFactory.CreateEmployee("Hans", "Müller"); var responsibleSubject2 = ResponsibleSubjectModelFactory.CreateEmployee("Gabi", "Becker"); var responsibleGroup = ResponsibleSubjectModelFactory.CreateGroup("Praktikanten"); dbContext.Set <EmployeeGroup>() .Add(responsibleGroup); dbContext.Set <Employee>() .Add(responsibleSubject1); dbContext.Set <Employee>() .Add(responsibleSubject2); var assembly = Assembly.GetExecutingAssembly(); var creationDate = DateTime.Now; var measureCollection1 = new List <EnergyMeasure>(); var measureCollection2 = new List <EnergyMeasure>(); for (var i = 0; i < 10; i++) { var word = DocumentModelFactory.CreateDocument("doc1.docx", assembly.GetManifestResourceStream("OpenResKit.Energy.Resources.dummyword.docx")); var pdf = DocumentModelFactory.CreateDocument("pdf1.pdf", assembly.GetManifestResourceStream("OpenResKit.Energy.Resources.dummypdf.pdf")); var measureName = "Container leeren"; var description = "Der Container ist voll"; var evaluationText = "Das Leeren hat funktioniert"; var entryDate = DateTime.Now.AddDays(-i * 7 - 1); var dueDate = DateTime.Now.AddDays(-i * 7); var status = 2; var rating = 0.8; var priority = 0; var imageSource = ModelFactory.CreateImage(assembly.GetManifestResourceStream("OpenResKit.Energy.Resources.dummyImage1.jpg")); var measure = ModelFactory.CreateMeasure(measureName, description, evaluationText, entryDate, dueDate, responsibleSubject1, status, priority, creationDate, rating, imageSource, new Collection <Document> { word, pdf }); measureCollection1.Add(measure); } for (var i = 5; i < 10; i++) { var word = DocumentModelFactory.CreateDocument("doc1.docx", assembly.GetManifestResourceStream("OpenResKit.Energy.Resources.dummyword.docx")); var pdf = DocumentModelFactory.CreateDocument("pdf1.pdf", assembly.GetManifestResourceStream("OpenResKit.Energy.Resources.dummypdf.pdf")); var measureName = "Container leeren"; var description = "Der Container ist voll"; var dueDate = DateTime.Now.AddDays(-i * 7); var evaluationText = string.Empty; DateTime?entryDate = null; var status = 0; var ratig = 0.0; var priority = 1; var imageSource = ModelFactory.CreateImage(assembly.GetManifestResourceStream("OpenResKit.Energy.Resources.dummyImage2.jpg")); var measure = ModelFactory.CreateMeasure(measureName, description, evaluationText, entryDate, dueDate, responsibleSubject1, status, priority, creationDate, ratig, imageSource, new Collection <Document> { word, pdf }); measureCollection1.Add(measure); } for (var i = 0; i < 5; i++) { var measureName = "Stromzähler ablesen"; var description = "Stromzähler befindet sich im Keller"; var evaluationText = string.Empty; DateTime?entryDate = null; var dueDate = DateTime.Now.AddDays(-i * 3); var status = 0; var rating = 0.2; var priority = 2; var imageSource = Measure.ModelFactory.CreateImage(assembly.GetManifestResourceStream("OpenResKit.Energy.Resources.dummyImage3.jpg")); var measure = ModelFactory.CreateMeasure(measureName, description, evaluationText, entryDate, dueDate, responsibleSubject1, status, priority, creationDate, rating, imageSource, null); measureCollection2.Add(measure); } for (var i = 5; i < 10; i++) { var measureName = "Stromzähler ablesen"; var description = "Stromzähler befindet sich im Keller"; var evaluationText = "Das Ablesen war wegen dem ganzen Schmutz kaum möglich"; var entryDate = DateTime.Now.AddDays(-i * 30); var dueDate = DateTime.Now.AddDays(-i * 30); var status = 2; var rating = 0.4; var priority = 2; var measure = ModelFactory.CreateMeasure(measureName, description, evaluationText, entryDate, dueDate, responsibleSubject1, status, priority, creationDate, rating, null, null); measureCollection2.Add(measure); } var subMeasure = new SubMeasure { IsCompleted = false, Name = "Test Untermaßnahme", ReleatedMeasure = measureCollection1[0], ResponsibleSubject = responsibleSubject1 }; dbContext.Set <SubMeasure>() .Add(subMeasure); var sgm = new ConsumerType { TypeName = "SGM" }; var auto = new ConsumerType { TypeName = "Automaten" }; var pc = new ConsumerType { TypeName = "PCs" }; var server = new ConsumerType { TypeName = "Server" }; dbContext.Set <ConsumerType>() .Add(sgm); dbContext.Set <ConsumerType>() .Add(auto); dbContext.Set <ConsumerType>() .Add(pc); dbContext.Set <ConsumerType>() .Add(server); var consumerGroupEdv = ModelFactory.CreateConsumerGroup("01 EDV"); consumerGroupEdv.ConsumerTypes.Add(pc); consumerGroupEdv.ConsumerTypes.Add(server); var consumerGroupAnlagen = ModelFactory.CreateConsumerGroup("02 Anlagen"); consumerGroupAnlagen.ConsumerTypes.Add(auto); consumerGroupAnlagen.ConsumerTypes.Add(sgm); dbContext.Set <ConsumerGroup>() .Add(consumerGroupEdv); dbContext.Set <ConsumerGroup>() .Add(consumerGroupAnlagen); dbContext.SaveChanges(); var distributorvi = ModelFactory.CreateDistributor("Verteiler Villa"); var distributorA = ModelFactory.CreateDistributor("Verteiler Gebäude A"); var distributorSchiene = ModelFactory.CreateDistributor("Stromschine 1"); dbContext.Set <Distributor>() .Add(distributorvi); dbContext.Set <Distributor>() .Add(distributorA); dbContext.Set <Distributor>() .Add(distributorSchiene); var auto1 = ModelFactory.CreateConsumer("Automat 1", distributorA, consumerGroupAnlagen, auto); var auto2 = ModelFactory.CreateConsumer("Automat 2", distributorA, consumerGroupAnlagen, auto); var sgm1 = ModelFactory.CreateConsumer("Spritzgußmaschine 1", distributorA, consumerGroupAnlagen, sgm); var sgm2 = ModelFactory.CreateConsumer("Spritzgußmaschine 2", distributorSchiene, consumerGroupAnlagen, sgm); var sgm3 = ModelFactory.CreateConsumer("Spritzgußmaschine 3", distributorSchiene, consumerGroupAnlagen, sgm); var sgm4 = ModelFactory.CreateConsumer("Spritzgußmaschine 4", distributorSchiene, consumerGroupAnlagen, sgm); dbContext.Set <Consumer>() .Add(auto1); dbContext.Set <Consumer>() .Add(auto2); dbContext.Set <Consumer>() .Add(sgm1); dbContext.Set <Consumer>() .Add(sgm2); dbContext.Set <Consumer>() .Add(sgm3); dbContext.Set <Consumer>() .Add(sgm4); dbContext.SaveChanges(); }
public void Seed(DbContext dbContext) { var responsibleSubject1 = ResponsibleSubjectModelFactory.CreateEmployee("Hans", "Müller"); var responsibleSubject2 = ResponsibleSubjectModelFactory.CreateEmployee("Gabi", "Becker"); var responsibleGroup = ResponsibleSubjectModelFactory.CreateGroup("Praktikanten"); dbContext.Set <EmployeeGroup>() .Add(responsibleGroup); dbContext.Set <Employee>() .Add(responsibleSubject1); dbContext.Set <Employee>() .Add(responsibleSubject2); var assembly = Assembly.GetExecutingAssembly(); var creationDate = DateTime.Now; var measureCollection1 = new Collection <Measure>(); var measureCollection2 = new Collection <Measure>(); for (var i = 0; i < 10; i++) { var word = DocumentModelFactory.CreateDocument("doc1.docx", assembly.GetManifestResourceStream("OpenResKit.Measure.Resources.dummyword.docx")); var pdf = DocumentModelFactory.CreateDocument("pdf1.pdf", assembly.GetManifestResourceStream("OpenResKit.Measure.Resources.dummypdf.pdf")); var measureName = "Container leeren"; var description = "Der Container ist voll"; var evaluationText = "Das Leeren hat funktioniert"; var entryDate = DateTime.Now.AddDays(-i * 7 - 1); var dueDate = DateTime.Now.AddDays(-i * 7); var status = 2; var rating = 0.8; var priority = 0; var imageSource = ModelFactory.CreateImage(assembly.GetManifestResourceStream("OpenResKit.Measure.Resources.dummyImage1.jpg")); var measure = ModelFactory.CreateMeasure(measureName, description, evaluationText, entryDate, dueDate, responsibleSubject1, status, priority, creationDate, rating, imageSource, new Collection <Document> { word, pdf }); measureCollection1.Add(measure); } for (var i = 5; i < 10; i++) { var word = DocumentModelFactory.CreateDocument("doc1.docx", assembly.GetManifestResourceStream("OpenResKit.Measure.Resources.dummyword.docx")); var pdf = DocumentModelFactory.CreateDocument("pdf1.pdf", assembly.GetManifestResourceStream("OpenResKit.Measure.Resources.dummypdf.pdf")); var measureName = "Container leeren"; var description = "Der Container ist voll"; var dueDate = DateTime.Now.AddDays(-i * 7); var evaluationText = string.Empty; DateTime?entryDate = null; var status = 0; var ratig = 0.0; var priority = 1; var imageSource = ModelFactory.CreateImage(assembly.GetManifestResourceStream("OpenResKit.Measure.Resources.dummyImage2.jpg")); var measure = ModelFactory.CreateMeasure(measureName, description, evaluationText, entryDate, dueDate, responsibleSubject1, status, priority, creationDate, ratig, imageSource, new Collection <Document> { word, pdf }); measureCollection1.Add(measure); } for (var i = 0; i < 5; i++) { var measureName = "Stromzähler ablesen"; var description = "Stromzähler befindet sich im Keller"; var evaluationText = string.Empty; DateTime?entryDate = null; var dueDate = DateTime.Now.AddDays(-i * 3); var status = 0; var rating = 0.2; var priority = 2; var imageSource = ModelFactory.CreateImage(assembly.GetManifestResourceStream("OpenResKit.Measure.Resources.dummyImage3.jpg")); var measure = ModelFactory.CreateMeasure(measureName, description, evaluationText, entryDate, dueDate, responsibleSubject1, status, priority, creationDate, rating, imageSource, null); measureCollection2.Add(measure); } for (var i = 5; i < 10; i++) { var measureName = "Stromzähler ablesen"; var description = "Stromzähler befindet sich im Keller"; var evaluationText = "Das Ablesen war wegen dem ganzen Schmutz kaum möglich"; var entryDate = DateTime.Now.AddDays(-i * 30); var dueDate = DateTime.Now.AddDays(-i * 30); var status = 2; var rating = 0.4; var priority = 2; var measure = ModelFactory.CreateMeasure(measureName, description, evaluationText, entryDate, dueDate, responsibleSubject1, status, priority, creationDate, rating, null, null); measureCollection2.Add(measure); } var catalog1 = ModelFactory.CreateCatalog("Katalog 1", "Das ist Katalog 1", measureCollection1); var catalog2 = ModelFactory.CreateCatalog("Katalog 2", "Das ist Katalog 2", measureCollection2); dbContext.Set <Catalog>() .Add(catalog1); dbContext.Set <Catalog>() .Add(catalog2); dbContext.SaveChanges(); }
public void Seed(DbContext dbContext) { var responsibleSubject1 = ResponsibleSubjectModelFactory.CreateEmployee("Shawn", "Steinfeger", "1"); var responsibleSubject2 = ResponsibleSubjectModelFactory.CreateGroup("Test"); var measure1 = ModelFactory.CreateMeasure("Das und Das müssen gemacht werden", 0, responsibleSubject1, null, 1, DateTime.Now, DateTime.Now.AddDays(10), "Maßnahme1"); var measure2 = ModelFactory.CreateMeasure("Das und Das müssen gemacht werden2", 1, responsibleSubject2, null, 2, DateTime.Now, DateTime.Now.AddDays(25), "Maßnahme2"); var measures1 = new Collection <Approval_Measure>(); measures1.Add(measure1); var measures2 = new Collection <Approval_Measure>(); measures2.Add(measure2); dbContext.Set <Approval_Measure>().Add(measure1); dbContext.Set <Approval_Measure>().Add(measure2); var conditionInspection1 = ModelFactory.CreateConditionInspection(true, "Alles Ok", measures1, DateTime.Now /*, inspection2, auxillaryCondition1*/); var conditionInspection2 = ModelFactory.CreateConditionInspection(false, "Nicht alles ok", measures2, DateTime.Now /*, inspection1, auxillaryCondition2*/); var conditionInspection3 = ModelFactory.CreateConditionInspection(true, "AllesO Ok2", null, DateTime.Now /*, inspection1, auxillaryCondition2*/); dbContext.Set <ConditionInspection>().Add(conditionInspection1); dbContext.Set <ConditionInspection>().Add(conditionInspection2); dbContext.Set <ConditionInspection>().Add(conditionInspection3); var conditionInspections1 = new Collection <ConditionInspection>(); conditionInspections1.Add(conditionInspection1); var conditionInspections2 = new Collection <ConditionInspection>(); conditionInspections2.Add(conditionInspection2); conditionInspections2.Add(conditionInspection3); var conditionInspections3 = new Collection <ConditionInspection>(); conditionInspections3.Add(conditionInspection1); conditionInspections3.Add(conditionInspection3); var auxillaryCondition1 = ModelFactory.CreateAuxillaryCondition("Wert muss unter 20 mg bleiben", "WHG §5", false, conditionInspections1); var auxillaryCondition2 = ModelFactory.CreateAuxillaryCondition("Wert muss unter 50 mg bleiben", "WHG §6", true, conditionInspections2); var auxillaryConditions = new Collection <AuxillaryCondition>(); auxillaryConditions.Add(auxillaryCondition1); auxillaryConditions.Add(auxillaryCondition2); var date = DateTime.Now.AddYears(-1); var series = SeriesModelFactory.CreateSeries("Kontrolle", date, date.AddMinutes(30), date.AddDays(91), true, false, false, 1, 1, 13, new DayOfWeek[0]); var inspection1 = ModelFactory.CreateInspection(conditionInspections1, DateTime.Now, DateTime.Now.AddHours(1), responsibleSubject2, series, 0); var series2 = SeriesModelFactory.CreateSeries("Kontrolle2", date, date.AddMinutes(30), date.AddDays(91), true, true, false, 1, 1, 13, new DayOfWeek[1]); var inspection2 = ModelFactory.CreateInspection(conditionInspections2, DateTime.Now, DateTime.Now.AddHours(1), responsibleSubject1, series2, 2); //dbContext.Set<ConditionInspection>().Add(conditionInspection2); //dbContext.Set<ConditionInspection>().Add(conditionInspection3); dbContext.Set <Approval_Inspection>().Add(inspection1); dbContext.Set <Approval_Inspection>().Add(inspection2); dbContext.Set <AuxillaryCondition>().Add(auxillaryCondition1); dbContext.Set <AuxillaryCondition>().Add(auxillaryCondition2); //dbContext.Set<Approval_Inspection>().Add(inspection2); var permission1 = ModelFactory.CreatePermission("Genehmigung 1", "Das ist eine Genehmigung.", true, 1, "AH-101", DateTime.Now, DateTime.Now, DateTime.Now, auxillaryConditions); var permission2 = ModelFactory.CreatePermission("Genehmigung 2", "Das ist eine Genehmigung.", true, 0, "AH-102", DateTime.Now, DateTime.Now, DateTime.Now, null); var permission3 = ModelFactory.CreatePermission("Genehmigung 3", "Das ist eine Genehmigung.", false, 2, "AH-103", DateTime.Now, DateTime.Now, DateTime.Now, null); dbContext.Set <Permission>().Add(permission1); dbContext.Set <Permission>().Add(permission2); dbContext.Set <Permission>().Add(permission3); var permissionCollection1 = new Collection <Permission>(); permissionCollection1.Add(permission1); permissionCollection1.Add(permission2); var permissionCollection2 = new Collection <Permission>(); permissionCollection2.Add(permission2); permissionCollection2.Add(permission3); var substance1 = ModelFactory.CreateSubstance("Wasser", "H2O", 1, 0, "0,1,2", "Abdichten", 2); var substance2 = ModelFactory.CreateSubstance("Kohlenstoffdioxid", "CO2", 0, 1, "3", "Gasmaske und abdichten", 1); var substanceList1 = new Collection <Substance>(); substanceList1.Add(substance1); substanceList1.Add(substance2); var plant1 = ModelFactory.CreatePlant("Anlage 1", "Das ist eine Anlage", "Anlage 1", permissionCollection1, substanceList1); var plant2 = ModelFactory.CreatePlant("Anlage 2", "Das ist auch eine Anlage", "Anlage 2", permissionCollection2, null); dbContext.Set <Plant>().Add(plant1); dbContext.Set <Plant>().Add(plant2); dbContext.Set <Employee>().Add(responsibleSubject1); dbContext.Set <EmployeeGroup>().Add(responsibleSubject2); dbContext.SaveChanges(); }
public void Seed(DbContext dbContext) { var assembly = Assembly.GetExecutingAssembly(); var initMap2 = MapModelFactory.CreateMap("Ebene 2", assembly.GetManifestResourceStream("OpenResKit.Waste.Resources.dummy_2.jpg")); var mp1 = MapModelFactory.CreateMapPosition(initMap2, 100, 100); var mp2 = MapModelFactory.CreateMapPosition(initMap2, 200, 200); var mp3 = MapModelFactory.CreateMapPosition(initMap2, 300, 300); var wc1 = ModelFactory.CreateWasteContainer("Restmülltonne", "AB1", 2, mp1); var wc2 = ModelFactory.CreateWasteContainer("Plastikmülltonne", "AB2", 2, mp2); var wc3 = ModelFactory.CreateWasteContainer("Schrottcontainer", "AB3", 6, mp3); dbContext.Set <WasteContainer>() .Add(wc1); dbContext.Set <WasteContainer>() .Add(wc2); dbContext.Set <WasteContainer>() .Add(wc3); var r1 = ResponsibleSubjectModelFactory.CreateEmployee("Shawn", "Steinfeger", "1234dqwe"); //series 1 - two containers, weekly, 13 times, 30 minutes each var containers1 = new[] { wc1, wc2 }; var s1 = SeriesModelFactory.CreateSeries("Abfalltonnen", DateTime.Now, DateTime.Now.AddMinutes(30), DateTime.Now.AddDays(91), true, false, false, 1, 1, 13, new[] { DateTime.Now.DayOfWeek }); foreach (var container in containers1) { for (var i = 0; i < s1.NumberOfRecurrences; i++) { if (i < 5) { var flr = ModelFactory.CreateFillLevelReading(s1.Begin.AddDays(i * 7), s1.Begin.AddDays(i * 7) .AddMinutes(30), s1.Begin.AddDays((i + 1) * 7), s1.Begin.AddDays((i + 1) * 7) .AddMinutes(30), 0.0f, r1, r1, container, s1); flr.EntryDate.Begin = s1.Begin.AddDays((i * 7) + 1); flr.FillLevel = (float)(i * 0.25); dbContext.Set <FillLevelReading>() .Add(flr); } else { var flr = ModelFactory.CreateFillLevelReading(s1.Begin.AddDays(i * 7), s1.Begin.AddDays(i * 7) .AddMinutes(30), r1, container, s1); dbContext.Set <FillLevelReading>() .Add(flr); } } } //series 2 - one container, monthly, 3 times, all day var s2 = SeriesModelFactory.CreateSeries("Schrottrundgang", DateTime.Now, DateTime.Now.AddMinutes(30), DateTime.Now.AddDays(91), true, false, true, 2, 1, 3, new DayOfWeek[0]); for (var i = 0; i < s2.NumberOfRecurrences; i++) { if (i < 2) { var flr = ModelFactory.CreateFillLevelReading(s2.Begin.AddMonths(i), s2.Begin.AddMonths(i) .AddMinutes(30), s2.Begin.AddMonths(i), s2.Begin.AddMonths(i) .AddMinutes(30), 1, r1, r1, wc2, s2); flr.EntryDate.Begin = s2.Begin.AddMonths(i) .AddDays(2); flr.FillLevel = (0.5f * (i + 1)); dbContext.Set <FillLevelReading>() .Add(flr); } else { var flr = ModelFactory.CreateFillLevelReading(s2.Begin.AddMonths(i), s2.Begin.AddMonths(i) .AddMinutes(30), r1, wc2, s2); dbContext.Set <FillLevelReading>() .Add(flr); } } var disposerModelFactory = new DisposerModelFactory(); var disposer1 = disposerModelFactory.CreateDisposer("ALBA", "A1", "alba@müll.de", "An der Waterkant 1", "12345", "Berlin", null, new Collection <WasteContainer>() { wc1, wc2 }, "Nur Sondermüll"); dbContext.Set <Disposer>() .Add(disposer1); var disposer2 = disposerModelFactory.CreateDisposer("Dino Container", "DinoX", "*****@*****.**", "Holzstraße 2", "12345", "Berlin", null, new Collection <WasteContainer>() { wc3 }, "Bauschutt"); dbContext.Set <Disposer>() .Add(disposer2); var collection1 = ModelFactory.CreateCollection(disposer1, wc1, 20, 18, 500, 485, DateTime.Now.AddDays(2)); dbContext.Set <WasteCollection>() .Add(collection1); var collection2 = ModelFactory.CreateCollection(disposer2, wc2, 10, 10, 449, 499, DateTime.Now.AddDays(10)); dbContext.Set <WasteCollection>() .Add(collection2); dbContext.SaveChanges(); }
public void Seed(DbContext dbContext) { var modelFactory = new ModelFactory(); var responsibleSubject1 = ResponsibleSubjectModelFactory.CreateEmployee("Heinz", "Petersen"); dbContext.Set <Employee>() .Add(responsibleSubject1); var inspectionAttribute1 = modelFactory.CreateInspectionAttribute("Teilequalität prüfen: nicht ausgespritzt", "1"); var inspectionAttribute2 = modelFactory.CreateInspectionAttribute("Teilequalität prüfen: starke Gratbildung", "2"); var inspectionAttribute3 = modelFactory.CreateInspectionAttribute("Teilequalität prüfen: Einlegeteile nicht vorhanden", "3"); var inspectionAttribute4 = modelFactory.CreateInspectionAttribute("Laschen verbogen", "1"); var inspectionAttribute5 = modelFactory.CreateInspectionAttribute("Kontakte fehlerhaft", "2"); var inspectionAttribute6 = modelFactory.CreateInspectionAttribute("Kontakte fehlerhaft 2", "1"); var inspectionAttribute7 = modelFactory.CreateInspectionAttribute("Laschen verbogen", "2"); var inspectionAttribute8 = modelFactory.CreateInspectionAttribute("Bedienelemen definitiv Ausschuß", "1"); var inspectionAttribute9 = modelFactory.CreateInspectionAttribute("Abdeckung definitiv Ausschuß", "2"); var inspectionAttribute10 = modelFactory.CreateInspectionAttribute("Zahnrad definitiv Ausschuß", "3"); var inspectionAttribute11 = modelFactory.CreateInspectionAttribute("Farbe falsch", "1"); var inspectionAttribute12 = modelFactory.CreateInspectionAttribute("Formfehler", "2"); var inspectionAttribute13 = modelFactory.CreateInspectionAttribute("Sonstiger Fehler", "3"); dbContext.Set <InspectionAttribute>() .Add(inspectionAttribute1); dbContext.Set <InspectionAttribute>() .Add(inspectionAttribute2); dbContext.Set <InspectionAttribute>() .Add(inspectionAttribute3); dbContext.Set <InspectionAttribute>() .Add(inspectionAttribute4); dbContext.Set <InspectionAttribute>() .Add(inspectionAttribute5); dbContext.Set <InspectionAttribute>() .Add(inspectionAttribute6); dbContext.Set <InspectionAttribute>() .Add(inspectionAttribute7); dbContext.Set <InspectionAttribute>() .Add(inspectionAttribute8); dbContext.Set <InspectionAttribute>() .Add(inspectionAttribute9); dbContext.Set <InspectionAttribute>() .Add(inspectionAttribute10); dbContext.Set <InspectionAttribute>() .Add(inspectionAttribute11); dbContext.Set <InspectionAttribute>() .Add(inspectionAttribute12); dbContext.Set <InspectionAttribute>() .Add(inspectionAttribute13); var inspectionAttributeList1 = new Collection <InspectionAttribute>(); var inspectionAttributeList3 = new Collection <InspectionAttribute>(); var inspectionAttributeList2 = new Collection <InspectionAttribute>(); var inspectionAttributeList4 = new Collection <InspectionAttribute>(); var inspectionAttributeList5 = new Collection <InspectionAttribute>(); inspectionAttributeList1.Add(inspectionAttribute1); inspectionAttributeList1.Add(inspectionAttribute2); inspectionAttributeList1.Add(inspectionAttribute3); inspectionAttributeList2.Add(inspectionAttribute4); inspectionAttributeList2.Add(inspectionAttribute5); inspectionAttributeList3.Add(inspectionAttribute6); inspectionAttributeList3.Add(inspectionAttribute7); inspectionAttributeList4.Add(inspectionAttribute8); inspectionAttributeList4.Add(inspectionAttribute9); inspectionAttributeList4.Add(inspectionAttribute10); inspectionAttributeList5.Add(inspectionAttribute11); inspectionAttributeList5.Add(inspectionAttribute12); inspectionAttributeList5.Add(inspectionAttribute13); var customer1 = modelFactory.CreateCustomer("HTW GmbH"); var customer2 = modelFactory.CreateCustomer("Beispielunernehmen AG"); var productionItem1 = modelFactory.CreateProductionItem("308231", "Bedienelement Spritz Groß", "Das ist die Beschreibung für ein großes Bedienelement", "Werkzeug Form 1", "AD/16", "Miramid VE30CW 802", customer1, "1337", "987654321", 1, inspectionAttributeList1); var productionItem2 = modelFactory.CreateProductionItem("AB20123", "Montagegruppe", "Das ist die Beschreibung für die Montagegruppe", "Werkzeug Hammer", "AB/23", "Baugruppenteil", customer2, " 42", "1234556789", 1, inspectionAttributeList2); var productionItem3 = modelFactory.CreateProductionItem("AB20124", "Löschbares Teil", "Ich bin löschbar", "Werkzeug Schweißgerät", "AB/24", "Baugruppenteil", customer2, " 42", "1234556789", 1, inspectionAttributeList3); var productionItem4 = modelFactory.CreateProductionItem("30829042", "Montagegruppe 42", "Beschreibung Montagegruppe", null, "AB/23", "Baugruppenteil", customer2, " 4212", "1234556789", 0, inspectionAttributeList4); var productionItem5 = modelFactory.CreateProductionItem("1900", "Kaffeetasse FCB", "Schwarze Kaffeetasse für Mitarbeiter", "Tassenform 1337", "Änd.Ind1", "Keramik", customer2, "123123", "123123", 1, inspectionAttributeList5); dbContext.Set <ProductionItem>() .Add(productionItem1); dbContext.Set <ProductionItem>() .Add(productionItem2); dbContext.Set <ProductionItem>() .Add(productionItem3); dbContext.Set <ProductionItem>() .Add(productionItem4); dbContext.Set <ProductionItem>() .Add(productionItem5); var discardItem1 = modelFactory.CreateDiscardItem(inspectionAttribute1, "Teil nicht ausgespritzt", 20, null); var discardItem2 = modelFactory.CreateDiscardItem(inspectionAttribute2, "Teil stark vergratet", 10, null); var discardItem4 = modelFactory.CreateDiscardItem(inspectionAttribute4, "Lasche nach rechts verbogen", 10, null); var discardItem3 = modelFactory.CreateDiscardItem(inspectionAttribute5, "Kontakt leitet nicht", 20, null); var discardItem8 = modelFactory.CreateDiscardItem(inspectionAttribute8, "Bedienelement ist Ausschuß", 200, null); var discardItem9 = modelFactory.CreateDiscardItem(inspectionAttribute9, "Abdeckung fehlt", 2000, null); var discardItem10 = modelFactory.CreateDiscardItem(inspectionAttribute10, "Zahnrad hat keine Zähne", 5, null); var discardItem11 = modelFactory.CreateDiscardItem(inspectionAttribute11, "Farbe ist Blau", 10, null); var discardItem12 = modelFactory.CreateDiscardItem(inspectionAttribute11, "Farbe fehlt ganz", 15, null); var discardItem13 = modelFactory.CreateDiscardItem(inspectionAttribute12, "Henkel fehlt", 20, null); var discardItem14 = modelFactory.CreateDiscardItem(inspectionAttribute12, "Tasse hat keinen Boden", 5, null); var discardItem15 = modelFactory.CreateDiscardItem(inspectionAttribute13, "Schrift fehlt", 10, null); var discardItem16 = modelFactory.CreateDiscardItem(inspectionAttribute11, "Farbe ist Blau", 2, null); var discardItem17 = modelFactory.CreateDiscardItem(inspectionAttribute11, "Farbe fehlt ganz", 3, null); var discardItem18 = modelFactory.CreateDiscardItem(inspectionAttribute12, "Henkel fehlt", 4, null); var discardItem19 = modelFactory.CreateDiscardItem(inspectionAttribute12, "Tasse hat keinen Boden", 1, null); var discardItem20 = modelFactory.CreateDiscardItem(inspectionAttribute13, "Schrift fehlt", 4, null); var discardItemList1 = new Collection <DiscardItem>(); discardItemList1.Add(discardItem1); discardItemList1.Add(discardItem2); var discardItemList2 = new Collection <DiscardItem>(); discardItemList2.Add(discardItem3); discardItemList2.Add(discardItem4); var discardItemList3 = new Collection <DiscardItem>(); discardItemList3.Add(discardItem8); discardItemList3.Add(discardItem9); discardItemList3.Add(discardItem10); var discardItemList4 = new Collection <DiscardItem>(); discardItemList4.Add(discardItem11); discardItemList4.Add(discardItem12); discardItemList4.Add(discardItem13); discardItemList4.Add(discardItem14); discardItemList4.Add(discardItem15); var discardItemList5 = new Collection <DiscardItem>(); discardItemList5.Add(discardItem16); discardItemList5.Add(discardItem17); discardItemList5.Add(discardItem18); discardItemList5.Add(discardItem19); discardItemList5.Add(discardItem20); dbContext.Set <DiscardItem>() .Add(discardItem1); dbContext.Set <DiscardItem>() .Add(discardItem2); dbContext.Set <DiscardItem>() .Add(discardItem3); dbContext.Set <DiscardItem>() .Add(discardItem4); dbContext.Set <DiscardItem>() .Add(discardItem8); dbContext.Set <DiscardItem>() .Add(discardItem9); dbContext.Set <DiscardItem>() .Add(discardItem10); dbContext.Set <DiscardItem>() .Add(discardItem11); dbContext.Set <DiscardItem>() .Add(discardItem12); dbContext.Set <DiscardItem>() .Add(discardItem13); dbContext.Set <DiscardItem>() .Add(discardItem14); dbContext.Set <DiscardItem>() .Add(discardItem15); dbContext.Set <DiscardItem>() .Add(discardItem16); dbContext.Set <DiscardItem>() .Add(discardItem17); dbContext.Set <DiscardItem>() .Add(discardItem18); dbContext.Set <DiscardItem>() .Add(discardItem19); dbContext.Set <DiscardItem>() .Add(discardItem20); var inspection1 = modelFactory.CreateInspection("Sichtprüfung Spritz", DateTime.Today, DateTime.Today, 0, 0, 0, 200, "Teile", 1000, "Reguläre Prüfung der Bedienelemente Spritz", responsibleSubject1, productionItem1, discardItemList1, false); var inspection2 = modelFactory.CreateInspection("Längenprüfung", DateTime.Today, DateTime.Today, 1, 1, 1, 200, "Meter", 1000, "Wieviel Meter wurden korrekt behämmert?", responsibleSubject1, productionItem2, discardItemList2, false); var inspection3 = modelFactory.CreateInspection("Ausschußprüfung", new DateTime(2013, 12, 24), new DateTime(2013, 12, 31), 2, 1, 0, 10, "Stück", 123, "Wieviel Teile sind pro Schicht Ausschuß", responsibleSubject1, productionItem4, discardItemList3, true); var inspection4 = modelFactory.CreateInspection("Erste Tassenprüfung", new DateTime(2014, 1, 15), new DateTime(2014, 1, 20), 1, 2, 0, 200, "Stück", 1000, "Die erste Charge FCB-Tassen für ORK-Mitarbeiter wird geprüft", responsibleSubject1, productionItem5, discardItemList4, true); var inspection5 = modelFactory.CreateInspection("zweite Tassenprüfung", new DateTime(2014, 1, 16), new DateTime(2014, 1, 21), 1, 2, 0, 150, "Stück", 1000, "Die zweite Charge FCB-Tassen für ORK-Mitarbeiter wird geprüft", responsibleSubject1, productionItem5, discardItemList5, true); dbContext.Set <Inspection>() .Add(inspection1); dbContext.Set <Inspection>() .Add(inspection2); dbContext.Set <Inspection>() .Add(inspection3); dbContext.Set <Inspection>() .Add(inspection4); dbContext.Set <Inspection>() .Add(inspection5); dbContext.SaveChanges(); }