public ParkingSpace ChangeSpace(int id)
        {
            var parkingspace = _db.ParkingSpaces.FirstOrDefault(x => x.ID == id);
            var currentState = parkingspace.Status;

            if (currentState == "open")
            {
                parkingspace.Status = "out";
                _db.ParkingSpaces.Update(parkingspace);
                _db.SaveChanges();
            }

            if (currentState == "out")
            {
                parkingspace.Status = "open";
                _db.ParkingSpaces.Update(parkingspace);
                _db.SaveChanges();
            }

            return(parkingspace);
        }
        public async Task Seed()
        {
            _db.Database.EnsureCreated();

            var user = await _userManager.FindByEmailAsync("*****@*****.**");

            var user2 = await _userManager.FindByEmailAsync("*****@*****.**");


            //if (user == null)
            //{
            //seeding simple user data into database

            /*        user = new Manager {
             *      UserName = "******",
             *      Email = "*****@*****.**",
             *      Name = "Brett",
             *      SSN = 123456789,
             *      HireDate = DateTime.Now
             *  };
             *
             *
             *  user2 = new Manager {
             *      UserName = "******",
             *      Email = "*****@*****.**",
             *      Name = "Jake",
             *      SSN = 123456289,
             *      HireDate = DateTime.Now
             *  };
             *
             *
             *  //var result = await _userManager.CreateAsync(user, "P@ssword1!");
             *  //var result2 = await _userManager.CreateAsync(user2, "P@ssword1!");
             *  //if(result != IdentityResult.Success) {
             *    //  throw new InvalidOperationException("Failed to create default user");
             *  //}
             *
             *
             *  var garage = new ParkingGarage() {
             *  ID = 1,
             *  Manager = user,
             *  Floors = 5,
             *  Address = "123 Apple Street"
             *  };
             *
             */var garage3 = new ParkingGarage()
            {
                ID      = 4,
                Manager = user2,
                Floors  = 5,
                Address = "258 Buckeye Drive"
            };

            /*
             * var space1 = new ParkingSpace() {
             * Garage = garage,
             * Manager = user,
             * ID = 1,
             * Floor = 1,
             * Status = "open"
             * };
             *
             * var garage2 = new ParkingGarage() {
             * ID = 2,
             * Manager = user,
             * Floors = 3,
             * Address = "321 Pear Street"
             * };
             *
             *
             * var space2 = new ParkingSpace() {
             * Garage = garage2,
             * Manager = user,
             * ID = 2,
             * Floor = 3,
             * Status = "open"
             * };
             *
             * var space3 = new ParkingSpace() {
             * Garage = garage,
             * Manager = user,
             * ID = 3,
             * Floor = 1,
             * Status = "out"
             * };
             *
             * var space4 = new ParkingSpace() {
             * Garage = garage,
             * Manager = user,
             * ID = 4,
             * Floor = 1,
             * Status = "out"
             * };
             *
             * var space5 = new ParkingSpace() {
             * Garage = garage,
             * Manager = user,
             * ID = 5,
             * Floor = 3,
             * Status = "out"
             * };
             *
             * var space6 = new ParkingSpace() {
             * Garage = garage,
             * Manager = user,
             * ID = 6,
             * Floor = 3,
             * Status = "inuse"
             * };
             *
             * var space7 = new ParkingSpace() {
             * Garage = garage,
             * Manager = user,
             * ID = 7,
             * Floor = 3,
             * Status = "open"
             * };
             *
             * var space8 = new ParkingSpace() {
             * Garage = garage,
             * Manager = user,
             * ID = 8,
             * Floor = 1,
             * Status = "out"
             * };
             *
             * var space9 = new ParkingSpace() {
             * Garage = garage,
             * Manager = user,
             * ID = 9,
             * Floor = 1,
             * Status = "out"
             * };
             *
             * var space10 = new ParkingSpace() {
             * Garage = garage,
             * Manager = user,
             * ID = 10,
             * Floor = 1,
             * Status = "out"
             * };
             *
             * var space11 = new ParkingSpace() {
             * Garage = garage,
             * Manager = user,
             * ID = 11,
             * Floor = 1,
             * Status = "open"
             * };
             *
             * var space12 = new ParkingSpace() {
             * Garage = garage,
             * Manager = user,
             * ID = 12,
             * Floor = 1,
             * Status = "open"
             * };
             *
             * var space13 = new ParkingSpace() {
             * Garage = garage,
             * Manager = user,
             * ID = 13,
             * Floor = 4,
             * Status = "open"
             * };
             *
             * var space14 = new ParkingSpace() {
             * Garage = garage,
             * Manager = user,
             * ID = 14,
             * Floor = 3,
             * Status = "inuse"
             * };
             *
             * var space15 = new ParkingSpace() {
             * Garage = garage,
             * Manager = user,
             * ID = 15,
             * Floor = 5,
             * Status = "open"
             * };
             *
             * var space16 = new ParkingSpace() {
             * Garage = garage,
             * Manager = user,
             * ID = 16,
             * Floor = 4,
             * Status = "inuse"
             * };
             *
             * var space17 = new ParkingSpace() {
             * Garage = garage,
             * Manager = user,
             * ID = 17,
             * Floor = 1,
             * Status = "open"
             * };
             *
             * var space18 = new ParkingSpace() {
             * Garage = garage,
             * Manager = user,
             * ID = 18,
             * Floor = 1,
             * Status = "open"
             * };
             *
             * var space19 = new ParkingSpace() {
             * Garage = garage,
             * Manager = user,
             * ID = 19,
             * Floor = 4,
             * Status = "inuse"
             * };
             *
             * var space20 = new ParkingSpace() {
             * Garage = garage2,
             * Manager = user,
             * ID = 20,
             * Floor = 1,
             * Status = "open"
             * };
             *
             * var space21 = new ParkingSpace() {
             * Garage = garage2,
             * Manager = user,
             * ID = 21,
             * Floor = 3,
             * Status = "open"
             * };
             *
             * var space22 = new ParkingSpace() {
             * Garage = garage2,
             * Manager = user,
             * ID = 22,
             * Floor = 1,
             * Status = "open"
             * };
             *
             * var space23 = new ParkingSpace() {
             * Garage = garage2,
             * Manager = user,
             * ID = 23,
             * Floor = 1,
             * Status = "open"
             * };
             *
             * var space24 = new ParkingSpace() {
             * Garage = garage2,
             * Manager = user,
             * ID = 24,
             * Floor = 1,
             * Status = "open"
             * };
             *
             * var space25 = new ParkingSpace() {
             * Garage = garage2,
             * Manager = user,
             * ID = 25,
             * Floor = 1,
             * Status = "open"
             * };
             *
             * var space26 = new ParkingSpace() {
             * Garage = garage2,
             * Manager = user,
             * ID = 26,
             * Floor = 1,
             * Status = "open"
             * };
             *
             * var space27 = new ParkingSpace() {
             * Garage = garage2,
             * Manager = user,
             * ID = 27,
             * Floor = 1,
             * Status = "inuse"
             * };
             *
             * var space28 = new ParkingSpace() {
             * Garage = garage2,
             * Manager = user,
             * ID = 28,
             * Floor = 2,
             * Status = "open"
             * };
             *
             * var space29 = new ParkingSpace() {
             * Garage = garage2,
             * Manager = user,
             * ID = 29,
             * Floor = 2,
             * Status = "out"
             * };
             *
             * var space30 = new ParkingSpace() {
             * Garage = garage2,
             * Manager = user,
             * ID = 30,
             * Floor = 2,
             * Status = "open"
             * };
             *
             * var space31 = new ParkingSpace() {
             * Garage = garage2,
             * Manager = user,
             * ID = 31,
             * Floor = 2,
             * Status = "out"
             * };
             *
             * var space32 = new ParkingSpace() {
             * Garage = garage2,
             * Manager = user,
             * ID = 32,
             * Floor = 2,
             * Status = "open"
             * };
             *
             * var space33 = new ParkingSpace() {
             * Garage = garage2,
             * Manager = user,
             * ID = 33,
             * Floor = 3,
             * Status = "inuse"
             * };
             *
             * var space34 = new ParkingSpace() {
             * Garage = garage2,
             * Manager = user,
             * ID = 34,
             * Floor = 3,
             * Status = "open"
             * };
             *
             * var space35 = new ParkingSpace() {
             * Garage = garage2,
             * Manager = user,
             * ID = 35,
             * Floor = 1,
             * Status = "open"
             * };
             *
             * var space36 = new ParkingSpace() {
             * Garage = garage2,
             * Manager = user,
             * ID = 36,
             * Floor = 1,
             * Status = "open"
             * };
             *
             * var space37 = new ParkingSpace() {
             * Garage = garage2,
             * Manager = user,
             * ID = 37,
             * Floor = 1,
             * Status = "inuse"
             * };
             *
             * var space38 = new ParkingSpace() {
             * Garage = garage2,
             * Manager = user,
             * ID = 38,
             * Floor = 2,
             * Status = "inuse"
             * };
             *
             * var space39 = new ParkingSpace() {
             * Garage = garage2,
             * Manager = user,
             * ID = 39,
             * Floor = 3,
             * Status = "inuse"
             * };
             *
             * var space40 = new ParkingSpace() {
             * Garage = garage2,
             * Manager = user,
             * ID = 40,
             * Floor = 2,
             * Status = "out"
             * };
             *
             * var space41 = new ParkingSpace() {
             * Garage = garage3,
             * Manager = user2,
             * ID = 41,
             * Floor = 3,
             * Status = "open"
             * };
             *
             * var space42 = new ParkingSpace() {
             * Garage = garage3,
             * Manager = user2,
             * ID = 42,
             * Floor = 1,
             * Status = "open"
             * };
             *
             * var space43 = new ParkingSpace() {
             * Garage = garage3,
             * Manager = user2,
             * ID = 43,
             * Floor = 2,
             * Status = "out"
             * };
             *
             * var space44 = new ParkingSpace() {
             * Garage = garage3,
             * Manager = user2,
             * ID = 44,
             * Floor = 1,
             * Status = "inuse"
             * };
             *
             * var space45 = new ParkingSpace() {
             * Garage = garage3,
             * Manager = user2,
             * ID = 45,
             * Floor = 2,
             * Status = "inuse"
             * };
             *
             * var space46 = new ParkingSpace() {
             * Garage = garage3,
             * Manager = user2,
             * ID = 46,
             * Floor = 3,
             * Status = "inuse"
             * };
             *
             * var space47 = new ParkingSpace() {
             * Garage = garage3,
             * Manager = user2,
             * ID = 47,
             * Floor = 2,
             * Status = "out"
             * };
             */

            var space48 = new ParkingSpace()
            {
                Garage  = garage3,
                Manager = user2,
                ID      = 48,
                Floor   = 3,
                Status  = "inuse"
            };

            var space49 = new ParkingSpace()
            {
                Garage  = garage3,
                Manager = user2,
                ID      = 49,
                Floor   = 1,
                Status  = "open"
            };

            var space50 = new ParkingSpace()
            {
                Garage  = garage3,
                Manager = user2,
                ID      = 50,
                Floor   = 2,
                Status  = "inuse"
            };

            var space51 = new ParkingSpace()
            {
                Garage  = garage3,
                Manager = user2,
                ID      = 51,
                Floor   = 3,
                Status  = "out"
            };



            /* _db.Garages.Add(garage);
             * _db.Garages.Add(garage2);
             * _db.Garages.Add(garage3);
             *
             * _db.ParkingSpaces.Add(space1);
             * _db.ParkingSpaces.Add(space2);
             * _db.ParkingSpaces.Add(space3);
             * _db.ParkingSpaces.Add(space4);
             * _db.ParkingSpaces.Add(space5);
             * _db.ParkingSpaces.Add(space6);
             * _db.ParkingSpaces.Add(space7);
             * _db.ParkingSpaces.Add(space8);
             * _db.ParkingSpaces.Add(space9);
             * _db.ParkingSpaces.Add(space10);
             * _db.ParkingSpaces.Add(space11);
             * _db.ParkingSpaces.Add(space12);
             * _db.ParkingSpaces.Add(space13);
             * _db.ParkingSpaces.Add(space14);
             * _db.ParkingSpaces.Add(space15);
             * _db.ParkingSpaces.Add(space16);
             * _db.ParkingSpaces.Add(space17);
             * _db.ParkingSpaces.Add(space18);
             * _db.ParkingSpaces.Add(space19);
             * _db.ParkingSpaces.Add(space20);
             * _db.ParkingSpaces.Add(space21);
             * _db.ParkingSpaces.Add(space22);
             * _db.ParkingSpaces.Add(space23);
             * _db.ParkingSpaces.Add(space24);
             * _db.ParkingSpaces.Add(space25);
             * _db.ParkingSpaces.Add(space26);
             * _db.ParkingSpaces.Add(space27);
             * _db.ParkingSpaces.Add(space28);
             * _db.ParkingSpaces.Add(space29);
             * _db.ParkingSpaces.Add(space30);
             * _db.ParkingSpaces.Add(space31);
             * _db.ParkingSpaces.Add(space32);
             * _db.ParkingSpaces.Add(space33);
             * _db.ParkingSpaces.Add(space34);
             * _db.ParkingSpaces.Add(space35);
             * _db.ParkingSpaces.Add(space36);
             * _db.ParkingSpaces.Add(space37);
             * _db.ParkingSpaces.Add(space38);
             * _db.ParkingSpaces.Add(space39);
             * _db.ParkingSpaces.Add(space40);
             * _db.ParkingSpaces.Add(space41);
             * _db.ParkingSpaces.Add(space42);
             * _db.ParkingSpaces.Add(space43);
             * _db.ParkingSpaces.Add(space44);
             * _db.ParkingSpaces.Add(space45);
             * _db.ParkingSpaces.Add(space46);
             * _db.ParkingSpaces.Add(space47);
             */

            _db.ParkingSpaces.Add(space48);
            _db.ParkingSpaces.Add(space49);
            _db.ParkingSpaces.Add(space50);
            _db.ParkingSpaces.Add(space51);

            _db.SaveChanges();
            //}
        }