Ejemplo n.º 1
0
        static void Main(string[] args)
        {
            // Have EF skip DB state check.
            Database.SetInitializer(new NullDatabaseInitializer <CustomPoolAndSpaDbContext>());

            using (var context = new CustomPoolAndSpaDbContext())
            {
                context.Database.Log = Console.WriteLine;


                var mat1 = context.MaterialSet.Find(1);
                var mat2 = context.MaterialSet.Find(2);
                var mat3 = context.MaterialSet.Find(3);
                var mat4 = context.MaterialSet.Find(4);

                var serviceAddress1 = context.ServiceAddressSet.Find(1);
                var serviceAddress2 = context.ServiceAddressSet.Find(2);
                var serviceAddress3 = context.ServiceAddressSet.Find(3);

                //var serviceCall7 = context.ServiceCallset.Find(7);
                //var serviceCall8 = context.ServiceCallset.Find(8);

                var poolConditionReport1 = new PoolCondition();

                poolConditionReport1.ChlorineResidual  = 2;
                poolConditionReport1.CyanuricAcidLevel = 35;
                poolConditionReport1.FreeChlorine      = 1;
                poolConditionReport1.PHLevel           = 7.4F;
                poolConditionReport1.Temperature       = 87.3F;
                poolConditionReport1.TotalAlkalinity   = 160;
                poolConditionReport1.Turbidity         = 1;


                //var serviceCall = context.ServiceCallset.Add(
                //    new ServiceReport
                //    {
                //        ServiceAddress = serviceAddress1,
                //        ServiceDate = DateTime.Now,
                //        ServiceTime = new TimeSpan(1, 2, 3),
                //        PoolCondition = poolConditionReport1
                //    });

                var serviceCall = new ServiceCall
                {
                    ServiceAddress = serviceAddress1,
                    ServiceDate    = DateTime.Now,
                    ServiceTime    = new TimeSpan(1, 2, 3),
                    PoolCondition  = poolConditionReport1
                };

                serviceCall.ServiceType.ChemicalCheck = true;

                // This alone doesn't seem to work as no MaterialUsed rows are created.

                // Doesn't matter if add ServiceReport first

                //context.ServiceCallset.Add(serviceCall);

                //serviceCall.MaterialsUsed.Add(
                //    new MaterialUsed
                //    {
                //        Material = mat1,
                //        Quantity = 3,
                //        ServiceReport = serviceCall
                //    });

                //serviceCall.MaterialsUsed.Add(
                //    new MaterialUsed
                //    {
                //        Material = mat2,
                //        Quantity = 4.9F,
                //        ServiceReport = serviceCall
                //    });

                var mu1 = new MaterialUsed
                {
                    //Id = 3,
                    Material      = mat3,
                    Quantity      = 3,
                    ServiceReport = serviceCall
                };

                var mu2 = new MaterialUsed
                {
                    //Id = 4,
                    Material      = mat4,
                    Quantity      = 4.9F,
                    ServiceReport = serviceCall
                };

                // This doesn't get rows added.

                serviceCall.MaterialsUsed.Add(mu1);
                serviceCall.MaterialsUsed.Add(mu2);

                // But if we tell the context about them directly it works
                // The EF6 course suggests otherwise.

                context.MaterialUsedSet.Add(mu1);
                context.MaterialUsedSet.Add(mu2);

                // Or here

                context.ServiceCallSet.Add(serviceCall);

                context.SaveChanges();
            }
        }
Ejemplo n.º 2
0
        protected override void Seed(CustomPoolAndSpaDbContext context)
        {
            Console.WriteLine("Seed()");
            //  This method will be called after migrating to the latest version.

            //  You can use the DbSet<T>.AddOrUpdate() helper extension method
            //  to avoid creating duplicate seed data.

            // This Seeds Address, Customer, and Material

            SeedAddressCustomerMaterialTables(context);

            // Customers

            var vikki       = context.CustomerSet.Find(1);
            var natalie     = context.CustomerSet.Find(2);
            var christopher = context.CustomerSet.Find(3);

            // Addresses

            var hillrise      = context.AddressSet.Find(1);
            var woodyhills    = context.AddressSet.Find(2);
            var pheasanttrail = context.AddressSet.Find(3);

            // Vikki has one pool

            var serviceAddress1 = CreateServiceAddress(context, 1, vikki, hillrise);

            if (serviceAddress1.Id != 1)
            {
                throw new Exception("WTF Id not equal to 1");
            }

            // Christopher has two pools

            var serviceAddress2 = CreateServiceAddress(context, 2, christopher, hillrise);

            if (serviceAddress2.Id != 2)
            {
                throw new Exception("WTF Id not equal to 2");
            }

            var serviceAddress3 = CreateServiceAddress(context, 3, christopher, woodyhills);

            if (serviceAddress3.Id != 3)
            {
                throw new Exception("WTF Id not equal to 3");
            }

            // Added this from Program.cs

            var mat1 = context.MaterialSet.Find(1);
            var mat2 = context.MaterialSet.Find(2);
            var mat3 = context.MaterialSet.Find(3);
            var mat4 = context.MaterialSet.Find(4);

            var poolConditionReport1 = new PoolCondition();

            poolConditionReport1.ChlorineResidual  = 2;
            poolConditionReport1.CyanuricAcidLevel = 35;
            poolConditionReport1.FreeChlorine      = 1;
            poolConditionReport1.PHLevel           = 7.4F;
            poolConditionReport1.Temperature       = 87.3F;
            poolConditionReport1.TotalAlkalinity   = 160;
            poolConditionReport1.Turbidity         = 1;

            var serviceCall = new ServiceCall
            {
                ServiceAddress = serviceAddress1,
                ServiceDate    = DateTime.Now,
                ServiceTime    = new TimeSpan(1, 2, 3),
                PoolCondition  = poolConditionReport1
            };

            var mu1 = new MaterialUsed
            {
                //Id = 3,
                Material      = mat3,
                Quantity      = 3,
                ServiceReport = serviceCall
            };

            var mu2 = new MaterialUsed
            {
                //Id = 4,
                Material      = mat4,
                Quantity      = 4.9F,
                ServiceReport = serviceCall
            };

            // This doesn't get rows added.

            serviceCall.MaterialsUsed.Add(mu1);
            serviceCall.MaterialsUsed.Add(mu2);

            // But if we tell the context about them directly it works
            // The EF6 course suggests otherwise.

            context.MaterialUsedSet.Add(mu1);
            context.MaterialUsedSet.Add(mu2);

            // Or here

            context.ServiceCallSet.Add(serviceCall);

            serviceCall.ServiceType.ChemicalCheck = true;

            context.SaveChanges();

            base.Seed(context);
        }