Esempio n. 1
0
        public void ToDashboardNoteTest()
        {
            var note = new TestValueNote
            {
                Error = new Error {
                    Value = "Fehler Bla bla", ErrorCode = "666"
                },
                Message = "eifach kaputt gange"
            };
            var target = new LaborDashboardHelper(new NLogLoggerFactory());
            var actual =
                target.ToDashboardNote(new List <TestValue>
            {
                new TestValue {
                    TestValueNote = new List <TestValueNote> {
                        note, note
                    }
                },
                new TestValue {
                    TestValueNote = new List <TestValueNote> {
                        note
                    }
                }
            });

            actual.Count.Should()
            .Be(3);
            actual.ToList()[0].Code.Should()
            .Be("666");
            actual.ToList()[0].ErrorMessage.Should()
            .Be(note.Error.Value);
            actual.ToList()[0].Message.Should()
            .Be(note.Message);
        }
Esempio n. 2
0
        protected override void Seed(LaborContext context)
        {
            var error1 = new Error
            {
                ErrorCode = "080",
                Value     = "Fixtape fehlt"
            };
            var error2 = new Error
            {
                ErrorCode = "411",
                Value     = "Saugkissen hinten zu kurz"
            };
            var error3 = new Error
            {
                ErrorCode = "023",
                Value     = "Zu wenig Inhalt"
            };
            var error4 = new Error
            {
                ErrorCode = "802",
                Value     = "Linke Seite reisst auf"
            };

            context.Errors.AddOrUpdate(e => e.ErrorId, error1, error2, error3, error4);

            var machine1 = new Machine
            {
                MachineNr = "M10"
            };
            var machine2 = new Machine
            {
                MachineNr = "M11"
            };
            var machine3 = new Machine
            {
                MachineNr = "M49"
            };

            context.Machines.AddOrUpdate(m => m.MachineId, machine1, machine2, machine3);

            var article1 = new Article
            {
                ArticleNr                = "10401",
                Name                     = "Babydream Maxi-Plus",
                ArticleType              = ArticleType.BabyDiaper,
                Rewet140Max              = 0.4,
                Rewet210Max              = 0.5,
                MinRetention             = 350,
                MaxRetention             = 380,
                MaxPenetrationAfter4Time = 250
            };
            var article2 = new Article
            {
                ArticleNr   = "10412",
                Name        = "Inko Extra",
                ArticleType = ArticleType.IncontinencePad,
                SizeName    = "Inko  Extra"
            };

            context.Articles.AddOrUpdate(a => a.ArticleId, article1);
            context.Articles.AddOrUpdate(a => a.ArticleId, article2);

            var productionOrderComponent1 = new ProductionOrderComponent
            {
                SAP = 32.7,
                PillowRetentWithoutSAP = 31.2,
                PillowWeightWithoutSAP = 26.0,
                CelluloseRetention     = 1.2,
                ComponentType          = "EKX",
                ComponentNr            = "EN67"
            };

            var productionOrder1 = new ProductionOrder
            {
                FaNr          = "FA123456",
                StartDateTime = new DateTime(2016, 1, 1),
                EndDateTime   = new DateTime(2018, 1, 1),
                Machine       = machine2,
                Component     = productionOrderComponent1,
                Article       = article1
            };

            productionOrderComponent1.ProductionOrder = productionOrder1;

            context.ProductionOrderComponent.AddOrUpdate(p => p.ProductionOrderComponentId, productionOrderComponent1);
            context.ProductionOrders.AddOrUpdate(p => p.FaId, productionOrder1);

            ////////////////////////////////////////////////////

            var inkoArticle1 = new Article
            {
                ArticleNr                   = "10501",
                Name                        = "Cresta Extra Inko Extra",
                ArticleType                 = ArticleType.IncontinencePad,
                MaxInkoRewet                = 0.5,
                MinInkoRetention            = 180,
                MaxHyTec1                   = 20,
                MaxHyTec2                   = 60,
                MaxHyTec3                   = 85,
                MaxInkoRewetAfterAquisition = 2
            };
            var productionOrder2 = new ProductionOrder
            {
                FaNr          = "FA654321",
                StartDateTime = new DateTime(2016, 1, 1),
                EndDateTime   = new DateTime(2018, 1, 1),
                Machine       = machine3,
                Article       = inkoArticle1
            };

            context.Articles.AddOrUpdate(a => a.ArticleId, inkoArticle1);
            context.ProductionOrders.AddOrUpdate(p => p.FaId, productionOrder2);

            ////////////////////////////////////////////////////
            var shift1 = new ShiftSchedule
            {
                Name      = "Mo Nacht",
                ShiftType = ShiftType.Night,
                StartDay  = DayOfWeek.Sunday,
                EndDay    = DayOfWeek.Monday,
                StartTime = new TimeSpan(22, 00, 00),
                EndTime   = new TimeSpan(04, 59, 59)
            };
            var shift2 = new ShiftSchedule
            {
                Name      = "Mo Morgen",
                ShiftType = ShiftType.Morning,
                StartDay  = DayOfWeek.Monday,
                EndDay    = DayOfWeek.Monday,
                StartTime = new TimeSpan(05, 00, 00),
                EndTime   = new TimeSpan(13, 59, 59)
            };
            var shift3 = new ShiftSchedule
            {
                Name      = "Mo Spät",
                ShiftType = ShiftType.Late,
                StartDay  = DayOfWeek.Monday,
                EndDay    = DayOfWeek.Monday,
                StartTime = new TimeSpan(14, 00, 00),
                EndTime   = new TimeSpan(22, 59, 59)
            };
            var shift4 = new ShiftSchedule
            {
                Name      = "Di Nacht",
                ShiftType = ShiftType.Night,
                StartDay  = DayOfWeek.Monday,
                EndDay    = DayOfWeek.Tuesday,
                StartTime = new TimeSpan(22, 00, 00),
                EndTime   = new TimeSpan(04, 59, 59)
            };
            var shift5 = new ShiftSchedule
            {
                Name      = "Di Morgen",
                ShiftType = ShiftType.Morning,
                StartDay  = DayOfWeek.Tuesday,
                EndDay    = DayOfWeek.Tuesday,
                StartTime = new TimeSpan(05, 00, 00),
                EndTime   = new TimeSpan(13, 59, 59)
            };
            var shift6 = new ShiftSchedule
            {
                Name      = "Di Spät",
                ShiftType = ShiftType.Late,
                StartDay  = DayOfWeek.Tuesday,
                EndDay    = DayOfWeek.Tuesday,
                StartTime = new TimeSpan(14, 00, 00),
                EndTime   = new TimeSpan(22, 59, 59)
            };
            var shift7 = new ShiftSchedule
            {
                Name      = "Mi Nacht",
                ShiftType = ShiftType.Night,
                StartDay  = DayOfWeek.Tuesday,
                EndDay    = DayOfWeek.Wednesday,
                StartTime = new TimeSpan(22, 00, 00),
                EndTime   = new TimeSpan(04, 59, 59)
            };
            var shift8 = new ShiftSchedule
            {
                Name      = "Mi Morgen",
                ShiftType = ShiftType.Morning,
                StartDay  = DayOfWeek.Wednesday,
                EndDay    = DayOfWeek.Wednesday,
                StartTime = new TimeSpan(05, 00, 00),
                EndTime   = new TimeSpan(13, 59, 59)
            };
            var shift9 = new ShiftSchedule
            {
                Name      = "Mi Spät",
                ShiftType = ShiftType.Late,
                StartDay  = DayOfWeek.Wednesday,
                EndDay    = DayOfWeek.Wednesday,
                StartTime = new TimeSpan(14, 00, 00),
                EndTime   = new TimeSpan(22, 59, 59)
            };
            var shift10 = new ShiftSchedule
            {
                Name      = "Do Nacht",
                ShiftType = ShiftType.Night,
                StartDay  = DayOfWeek.Wednesday,
                EndDay    = DayOfWeek.Thursday,
                StartTime = new TimeSpan(22, 00, 00),
                EndTime   = new TimeSpan(04, 59, 59)
            };
            var shift11 = new ShiftSchedule
            {
                Name      = "Do Morgen",
                ShiftType = ShiftType.Morning,
                StartDay  = DayOfWeek.Thursday,
                EndDay    = DayOfWeek.Thursday,
                StartTime = new TimeSpan(05, 00, 00),
                EndTime   = new TimeSpan(13, 59, 59)
            };
            var shift12 = new ShiftSchedule
            {
                Name      = "Do Spät",
                ShiftType = ShiftType.Late,
                StartDay  = DayOfWeek.Thursday,
                EndDay    = DayOfWeek.Thursday,
                StartTime = new TimeSpan(14, 00, 00),
                EndTime   = new TimeSpan(22, 59, 59)
            };
            var shift13 = new ShiftSchedule
            {
                Name      = "Fr Nacht",
                ShiftType = ShiftType.Night,
                StartDay  = DayOfWeek.Thursday,
                EndDay    = DayOfWeek.Friday,
                StartTime = new TimeSpan(22, 00, 00),
                EndTime   = new TimeSpan(04, 59, 59)
            };
            var shift14 = new ShiftSchedule
            {
                Name      = "Fr Morgen",
                ShiftType = ShiftType.Morning,
                StartDay  = DayOfWeek.Friday,
                EndDay    = DayOfWeek.Friday,
                StartTime = new TimeSpan(05, 00, 00),
                EndTime   = new TimeSpan(13, 59, 59)
            };
            var shift15 = new ShiftSchedule
            {
                Name      = "Fr Spät",
                ShiftType = ShiftType.Late,
                StartDay  = DayOfWeek.Friday,
                EndDay    = DayOfWeek.Friday,
                StartTime = new TimeSpan(14, 00, 00),
                EndTime   = new TimeSpan(22, 59, 59)
            };
            var shift16 = new ShiftSchedule
            {
                Name      = "Sa Nacht",
                ShiftType = ShiftType.Night,
                StartDay  = DayOfWeek.Friday,
                EndDay    = DayOfWeek.Saturday,
                StartTime = new TimeSpan(22, 00, 00),
                EndTime   = new TimeSpan(04, 59, 59)
            };

            context.ShiftSchedules.AddOrUpdate(s => s.Name, shift1);
            context.ShiftSchedules.AddOrUpdate(s => s.Name, shift2);
            context.ShiftSchedules.AddOrUpdate(s => s.Name, shift3);
            context.ShiftSchedules.AddOrUpdate(s => s.Name, shift4);
            context.ShiftSchedules.AddOrUpdate(s => s.Name, shift5);
            context.ShiftSchedules.AddOrUpdate(s => s.Name, shift6);
            context.ShiftSchedules.AddOrUpdate(s => s.Name, shift7);
            context.ShiftSchedules.AddOrUpdate(s => s.Name, shift8);
            context.ShiftSchedules.AddOrUpdate(s => s.Name, shift9);
            context.ShiftSchedules.AddOrUpdate(s => s.Name, shift10);
            context.ShiftSchedules.AddOrUpdate(s => s.Name, shift11);
            context.ShiftSchedules.AddOrUpdate(s => s.Name, shift12);
            context.ShiftSchedules.AddOrUpdate(s => s.Name, shift13);
            context.ShiftSchedules.AddOrUpdate(s => s.Name, shift14);
            context.ShiftSchedules.AddOrUpdate(s => s.Name, shift15);
            context.ShiftSchedules.AddOrUpdate(s => s.Name, shift16);
            ////////////////////////////////////////////////////

            var testSheet = new TestSheet
            {
                TestSheetId     = 1,
                FaNr            = "FA123456",
                CreatedDateTime = new DateTime(2016, 11, 2, 1, 50, 0),
                ShiftType       = ShiftType.Night,
                MachineNr       = "M11",
                SAPType         = "EKX",
                SAPNr           = "EN67",
                ProductName     = "Babydream",
                SizeName        = "Maxi-Plus",
                ArticleType     = ArticleType.BabyDiaper
            };

            var babyDiapersRewetTestValue1 = new TestValue
            {
                TestValueId                = 1,
                CreatedDateTime            = new DateTime(2016, 11, 2, 1, 50, 0),
                LastEditedDateTime         = new DateTime(2016, 11, 2, 1, 50, 0),
                DayInYearOfArticleCreation = 307,
                CreatedPerson              = "Hans",
                LastEditedPerson           = "Hans",
                ArticleTestType            = ArticleType.BabyDiaper,
                TestValueType              = TestValueType.Single,
                TestSheetId                = 1
            };
            var babyDiapersRetentionTestValueAverage = new TestValue
            {
                TestValueId        = 2,
                CreatedDateTime    = new DateTime(2016, 11, 2, 1, 50, 0),
                LastEditedDateTime = new DateTime(2016, 11, 2, 1, 50, 0),
                CreatedPerson      = "Hans",
                LastEditedPerson   = "Hans",
                ArticleTestType    = ArticleType.BabyDiaper,
                TestValueType      = TestValueType.Average,
                TestSheetId        = 1
            };
            var babyDiapersRetentionTestValueStandardDeviation = new TestValue
            {
                TestValueId        = 3,
                CreatedDateTime    = new DateTime(2016, 11, 2, 1, 50, 0),
                LastEditedDateTime = new DateTime(2016, 11, 2, 1, 50, 0),
                CreatedPerson      = "Hans",
                LastEditedPerson   = "Hans",
                ArticleTestType    = ArticleType.BabyDiaper,
                TestValueType      = TestValueType.StandardDeviation,
                TestSheetId        = 1
            };
            var babyDiapersRewetTestValueAverage = new TestValue
            {
                TestValueId        = 4,
                CreatedDateTime    = new DateTime(2016, 11, 2, 1, 50, 0),
                LastEditedDateTime = new DateTime(2016, 11, 2, 1, 50, 0),
                CreatedPerson      = "Hans",
                LastEditedPerson   = "Hans",
                ArticleTestType    = ArticleType.BabyDiaper,
                TestValueType      = TestValueType.Average,
                TestSheetId        = 1
            };
            var babyDiapersRewetTestValueStandardDeviation = new TestValue
            {
                TestValueId        = 5,
                CreatedDateTime    = new DateTime(2016, 11, 2, 1, 50, 0),
                LastEditedDateTime = new DateTime(2016, 11, 2, 1, 50, 0),
                CreatedPerson      = "Hans",
                LastEditedPerson   = "Hans",
                ArticleTestType    = ArticleType.BabyDiaper,
                TestValueType      = TestValueType.StandardDeviation,
                TestSheetId        = 1
            };
            var babyDiapersPenetrationTimeTestValueAverage = new TestValue
            {
                TestValueId        = 6,
                CreatedDateTime    = new DateTime(2016, 11, 2, 1, 50, 0),
                LastEditedDateTime = new DateTime(2016, 11, 2, 1, 50, 0),
                CreatedPerson      = "Hans",
                LastEditedPerson   = "Hans",
                ArticleTestType    = ArticleType.BabyDiaper,
                TestValueType      = TestValueType.Average,
                TestSheetId        = 1
            };
            var babyDiapersPenetrationTimeTestValueStandardDeviation = new TestValue
            {
                TestValueId        = 7,
                CreatedDateTime    = new DateTime(2016, 11, 2, 1, 50, 0),
                LastEditedDateTime = new DateTime(2016, 11, 2, 1, 50, 0),
                CreatedPerson      = "Hans",
                LastEditedPerson   = "Hans",
                ArticleTestType    = ArticleType.BabyDiaper,
                TestValueType      = TestValueType.StandardDeviation,
                TestSheetId        = 1
            };

            var babyDiapersRewetTest1 = new BabyDiaperTestValue
            {
                BabyDiaperTestValueId         = 1,
                DiaperCreatedTime             = new TimeSpan(1, 38, 0),
                WeightDiaperDry               = 32.9,
                Rewet140Value                 = 0.1,
                Rewet210Value                 = 0.18,
                StrikeTroughValue             = 0.28,
                DistributionOfTheStrikeTrough = 240,
                Rewet140Rw = RwType.Ok,
                Rewet210Rw = RwType.Ok,
                TestType   = TestTypeBabyDiaper.Rewet
            };
            var babyDiapersRewetTestAverage = new BabyDiaperTestValue
            {
                BabyDiaperTestValueId         = 2,
                DiaperCreatedTime             = new TimeSpan(1, 38, 0),
                WeightDiaperDry               = 32.9,
                Rewet140Value                 = 0.1,
                Rewet210Value                 = 0.18,
                StrikeTroughValue             = 0.28,
                DistributionOfTheStrikeTrough = 240,
                Rewet140Rw = RwType.Ok,
                Rewet210Rw = RwType.Ok,
                TestType   = TestTypeBabyDiaper.Rewet
            };
            var babyDiapersRewetTestStandardDeviation = new BabyDiaperTestValue
            {
                BabyDiaperTestValueId         = 3,
                DiaperCreatedTime             = new TimeSpan(1, 38, 0),
                WeightDiaperDry               = 32.9,
                Rewet140Value                 = 0.1,
                Rewet210Value                 = 0.18,
                StrikeTroughValue             = 0.28,
                DistributionOfTheStrikeTrough = 240,
                Rewet140Rw = RwType.Ok,
                Rewet210Rw = RwType.Ok,
                TestType   = TestTypeBabyDiaper.Rewet
            };

            babyDiapersRewetTestValue1.BabyDiaperTestValue = babyDiapersRewetTest1;

            var testNote = new TestValueNote
            {
                Error   = error2,
                Message = "Testnotiz"
            };
            var babyDiapersRetentionTestValue1 = new TestValue
            {
                TestValueId                = 2,
                CreatedDateTime            = new DateTime(2016, 11, 2, 1, 51, 0),
                LastEditedDateTime         = new DateTime(2016, 11, 2, 1, 51, 0),
                DayInYearOfArticleCreation = 307,
                CreatedPerson              = "Hans",
                LastEditedPerson           = "Hans",
                ArticleTestType            = ArticleType.BabyDiaper,
                TestValueType              = TestValueType.Single,
                TestSheetId                = 1,
                TestValueNote              = new List <TestValueNote> {
                    testNote
                }
            };

            testNote.TestValue = babyDiapersRetentionTestValue1;
            var babyDiapersRetentionTest1 = new BabyDiaperTestValue
            {
                BabyDiaperTestValueId           = 2,
                DiaperCreatedTime               = new TimeSpan(1, 38, 0),
                WeightDiaperDry                 = 33.0,
                RetentionWetWeight              = 414.0,
                RetentionAfterZentrifugeValue   = 381.0,
                RetentionAfterZentrifugePercent = 1155,
                RetentionRw    = RwType.Better,
                SapType        = "EKX",
                SapNr          = "EN67",
                SapGHoewiValue = 10.70,
                TestType       = TestTypeBabyDiaper.Retention
            };

            babyDiapersRetentionTestValue1.BabyDiaperTestValue = babyDiapersRetentionTest1;

            var babyDiapersRetentionTestAverage = new BabyDiaperTestValue
            {
                BabyDiaperTestValueId           = 4,
                DiaperCreatedTime               = new TimeSpan(0, 0, 0),
                WeightDiaperDry                 = 0,
                RetentionRw                     = RwType.Ok,
                RetentionAfterZentrifugeValue   = 0,
                RetentionWetWeight              = 0,
                RetentionAfterZentrifugePercent = 0,
                TestType = TestTypeBabyDiaper.Retention
            };
            var babyDiapersRetentionTestStandardDeviation = new BabyDiaperTestValue
            {
                BabyDiaperTestValueId           = 5,
                DiaperCreatedTime               = new TimeSpan(0, 0, 0),
                WeightDiaperDry                 = 0,
                RetentionRw                     = RwType.Ok,
                RetentionAfterZentrifugeValue   = 0,
                RetentionWetWeight              = 0,
                RetentionAfterZentrifugePercent = 0,
                TestType = TestTypeBabyDiaper.Retention
            };
            var babyDiapersPenetrationTimeTestAverage = new BabyDiaperTestValue
            {
                BabyDiaperTestValueId           = 6,
                DiaperCreatedTime               = new TimeSpan(0, 0, 0),
                WeightDiaperDry                 = 0,
                PenetrationTimeAdditionThird    = 0,
                PenetrationTimeAdditionSecond   = 0,
                PenetrationTimeAdditionFourth   = 0,
                PenetrationTimeAdditionFirst    = 0,
                RetentionAfterZentrifugePercent = 0,
                PenetrationRwType               = RwType.Ok,
                TestType = TestTypeBabyDiaper.RewetAndPenetrationTime
            };
            var babyDiapersPenetrationTimeTestStandardDeviation = new BabyDiaperTestValue
            {
                BabyDiaperTestValueId           = 7,
                DiaperCreatedTime               = new TimeSpan(0, 0, 0),
                PenetrationTimeAdditionThird    = 0,
                PenetrationTimeAdditionSecond   = 0,
                PenetrationTimeAdditionFourth   = 0,
                PenetrationTimeAdditionFirst    = 0,
                RetentionAfterZentrifugePercent = 0,
                WeightDiaperDry   = 0,
                PenetrationRwType = RwType.Ok,
                TestType          = TestTypeBabyDiaper.RewetAndPenetrationTime
            };

            babyDiapersRewetTestValue1.BabyDiaperTestValue = babyDiapersRewetTest1;

            babyDiapersRewetTestValueAverage.BabyDiaperTestValue           = babyDiapersRewetTestAverage;
            babyDiapersRewetTestValueStandardDeviation.BabyDiaperTestValue = babyDiapersRewetTestStandardDeviation;

            babyDiapersRetentionTestValueAverage.BabyDiaperTestValue           = babyDiapersRetentionTestAverage;
            babyDiapersRetentionTestValueStandardDeviation.BabyDiaperTestValue = babyDiapersRetentionTestStandardDeviation;

            babyDiapersPenetrationTimeTestValueAverage.BabyDiaperTestValue           = babyDiapersPenetrationTimeTestAverage;
            babyDiapersPenetrationTimeTestValueStandardDeviation.BabyDiaperTestValue = babyDiapersPenetrationTimeTestStandardDeviation;

            testSheet.TestValues = new List <TestValue>
            {
                babyDiapersRewetTestValue1,
                babyDiapersRetentionTestValue1,
                babyDiapersRetentionTestValueAverage,
                babyDiapersRetentionTestValueStandardDeviation,
                babyDiapersRewetTestValueAverage,
                babyDiapersRewetTestValueStandardDeviation,
                babyDiapersPenetrationTimeTestValueAverage,
                babyDiapersPenetrationTimeTestValueStandardDeviation
            };
            context.TestSheets.AddOrUpdate(m => m.FaNr, testSheet);
            context.TestValues.AddOrUpdate(m => m.TestValueId, babyDiapersRewetTestValue1);
            context.TestValues.AddOrUpdate(m => m.TestValueId, babyDiapersRewetTestValueAverage);
            context.TestValues.AddOrUpdate(m => m.TestValueId, babyDiapersRewetTestValueStandardDeviation);

            context.TestValues.AddOrUpdate(m => m.TestValueId, babyDiapersRetentionTestValueAverage);
            context.TestValues.AddOrUpdate(m => m.TestValueId, babyDiapersRetentionTestValueStandardDeviation);

            context.TestValues.AddOrUpdate(m => m.TestValueId, babyDiapersPenetrationTimeTestValueAverage);
            context.TestValues.AddOrUpdate(m => m.TestValueId, babyDiapersPenetrationTimeTestValueStandardDeviation);

            context.BabyDiaperTestValues.AddOrUpdate(m => m.BabyDiaperTestValueId, babyDiapersRewetTest1);
            context.BabyDiaperTestValues.AddOrUpdate(m => m.BabyDiaperTestValueId, babyDiapersRewetTestStandardDeviation);
            context.BabyDiaperTestValues.AddOrUpdate(m => m.BabyDiaperTestValueId, babyDiapersRewetTestAverage);
            context.BabyDiaperTestValues.AddOrUpdate(m => m.BabyDiaperTestValueId, babyDiapersRetentionTestStandardDeviation);
            context.BabyDiaperTestValues.AddOrUpdate(m => m.BabyDiaperTestValueId, babyDiapersRetentionTestAverage);
            context.BabyDiaperTestValues.AddOrUpdate(m => m.BabyDiaperTestValueId, babyDiapersPenetrationTimeTestStandardDeviation);
            context.BabyDiaperTestValues.AddOrUpdate(m => m.BabyDiaperTestValueId, babyDiapersPenetrationTimeTestAverage);

            babyDiapersPenetrationTimeTestValueAverage.BabyDiaperTestValue = babyDiapersPenetrationTimeTestAverage;
        }