Ejemplo n.º 1
0
 private static void Removeposts(Garage_2Context db)
 {
     db.ParkedVehicle.RemoveRange(db.ParkedVehicle);
     db.Member.RemoveRange(db.Member);
     db.VehicleType.RemoveRange(db.VehicleType);
     db.ParkingSpace.RemoveRange(db.ParkingSpace);
 }
Ejemplo n.º 2
0
        public static void Initialize(IServiceProvider services)
        {
            var options = services.GetRequiredService <DbContextOptions <Garage_2Context> >();

            using (var db = new Garage_2Context(options))
            {
                if (db.ParkedVehicle.Any())
                {
                    Removeposts(db);
                    //return;
                }

                var fake = new Faker("sv");

                // ********************** Seeding members ************************************************
                List <Member> members = new List <Member>();

                for (int i = 0; i < 25; i++)
                {
                    var fName = fake.Name.FirstName();
                    var lName = fake.Name.LastName();

                    Member member = new Member()
                    {
                        FirstName            = fName,
                        LastName             = lName,
                        Phone                = fake.Phone.PhoneNumber(),
                        SocialSecurityNumber = string.Join("", fake.Random.Digits(10, 1, 9)),
                        Email                = fake.Internet.Email(fName, lName),
                        Street               = $"{fake.Address.StreetName()} {fake.Random.Int(1, 400)}",
                        ZIP    = string.Join("", fake.Random.Digits(5, 0, 9)),
                        Avatar = fake.Internet.Avatar()
                    };

                    members.Add(member);
                }

                db.AddRange(members);

                //*********** Seeding VehicleType *********************************************************
                var vehicleTypes = new List <VehicleType>();

                List <string> vehicleList = new List <string>()
                {
                    "Car",
                    "Boat",
                    "Bus",
                    "Airplane",
                    "Motorcycle"
                };

                foreach (string vt in vehicleList)
                {
                    VehicleType vehicleType = new VehicleType();
                    vehicleType.VehicType = vt;
                    vehicleTypes.Add(vehicleType);
                }

                db.AddRange(vehicleTypes);

                //*************************** Seeding ParkedVehicle *************************************
                List <ParkedVehicle> parkedVehicles = new List <ParkedVehicle>();

                string regNum;

                for (int i = 0; i < 20; i++)
                {
                    regNum  = string.Join("", fake.Random.Chars('A', 'Z', 3));
                    regNum += fake.Random.Int(001, 999).ToString();

                    ParkedVehicle parkedVehicle = new ParkedVehicle()
                    {
                        RegisterNumber = regNum,
                        Color          = fake.Commerce.Color(),
                        Model          = fake.Vehicle.Model(),
                        Brand          = fake.Vehicle.Manufacturer(),
                        WheelsNumber   = fake.Random.Int(0, 20),
                        ParkedDateTime = fake.Date.Recent(),

                        // Foreign keys
                        Member      = fake.Random.ListItem <Member>(members),
                        VehicleType = fake.Random.ListItem <VehicleType>(vehicleTypes)
                    };

                    parkedVehicles.Add(parkedVehicle);
                }

                db.AddRange(parkedVehicles);


                // ********************** Seeding ParkingSpaces *************************************************
                List <ParkingSpace> parkingSpaces = new List <ParkingSpace>();
                int nrOfParkingSpaces             = 20;

                for (int i = 0; i < nrOfParkingSpaces; i++)
                {
                    ParkingSpace parkingSpace = new ParkingSpace()
                    {
                        // Foreign key
                        ParkedVehicleId = i,

                        // Foreign keys
                        //ParkedVehicle = fake.Random.ListItem<ParkedVehicle>(parkedVehicles),
                        ParkedVehicle = parkedVehicles[i]
                    };

                    parkingSpaces.Add(parkingSpace);
                }

                db.AddRange(parkingSpaces);

                db.SaveChanges();
            }
        }