Exemplo n.º 1
0
    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();
    }
Exemplo n.º 2
0
        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();
        }
Exemplo n.º 3
0
        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();
        }
Exemplo n.º 4
0
        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();
        }
Exemplo n.º 5
0
        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();
        }
Exemplo n.º 6
0
        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();
        }
Exemplo n.º 7
0
        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();
        }
Exemplo n.º 8
0
        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();
        }