Exemplo n.º 1
0
        public async Task <IActionResult> AddStaff(StaffVM vm)
        {
            var addedStaffInt = await _adminRepo.AddStaff(vm);

            var     staffTypeId   = vm.StaffTypeID;
            var     staffTypeName = (await _adminRepo.GetStaffTypeById(vm.StaffTypeID)).Type;
            dynamic obj           = null;
            string  nextViewName  = "Add" + staffTypeName;

            switch (staffTypeName)
            {
            case nameof(Pilot):
                obj = new Pilot
                {
                    StaffID = addedStaffInt
                };
                break;

            case nameof(Steward):
                obj = new Steward
                {
                    StaffID = addedStaffInt
                };
                break;

            default:
                break;
            }

            return(View(nextViewName, obj));
        }
Exemplo n.º 2
0
            public async Task <StewardLookupDto> Handle(CreateStewardCommand request, CancellationToken cancellationToken)
            {
                var session = await _context.GameSessions.FindAsync(request.GameSessionId);

                if (session != null)
                {
                    var steward = new Steward();
                    session.Stewards.Add(steward);
                    await _context.SaveChangesAsync(cancellationToken);

                    return(_mapper.Map <StewardLookupDto>(steward));
                }

                return(null);
            }
Exemplo n.º 3
0
        public static List <Steward> Get_Data(string id)
        {
            List <Steward> list_det = new List <Steward>();


            DataTable dt = getdata(Convert.ToInt32(id));

            for (Int32 i = 0; i < dt.Rows.Count; i++)
            {
                Steward u = new Steward();

                u.User_Name = dt.Rows[i]["User_Name"].ToString();
                u.User_Id   = Convert.ToInt32(dt.Rows[i]["User_Id"]);
                u.Email     = dt.Rows[i]["Email"].ToString();
                u.Age       = dt.Rows[i]["Age"].ToString();
                u.Password  = dt.Rows[i]["Password"].ToString();
                u.gender    = dt.Rows[i]["gender"].ToString();

                list_det.Add(u);
            }
            return(list_det);
        }
Exemplo n.º 4
0
        public async Task <int> AddSteward(Steward input)
        {
            using (IDbConnection conn = Connection)
            {
                try
                {
                    string sQuery = "INSERT INTO " + Steward.tableName + " (StaffID, StewardLicence) VALUES(@StaffID, @StewardLicence)";
                    //"SELECT CAST(SCOPE_IDENTITY() as int)";
                    conn.Open();
                    var addedInt = await conn.ExecuteAsync(sQuery, new { StaffID = input.StaffID, StewardLicence = input.StewardLicence });

                    return(addedInt);
                }
                catch (Exception)
                {
                    throw;
                }
                finally
                {
                    conn.Close();
                }
            }
        }
Exemplo n.º 5
0
        public async Task <IActionResult> AddSteward(Steward staff)
        {
            await _adminRepo.AddSteward(staff);

            return(RedirectToAction("Index", "Home"));
        }
Exemplo n.º 6
0
        // здесь на лекции демонстрировали некоторые фишки C#
        private void FlightsForm_Load(object sender, EventArgs e)
        {
            // удобная инициализация
            var flight = new Flight {
                Code = "Y43N", DepartureCity = "Donetsk", DepartureTime = DateTime.Now
            };

            // демонстрация полиморфизма
            Employee steward = new Steward();
            var      salary  = steward.CalculateSalary();

            // демонстрация динамических кастов
            Pilot p = steward as Pilot;

            if (p != null)
            {
                // в данном случае сюда не попадем, т.к. p - не Pilot
            }

            if (steward is Steward)
            {
                // сюда попадем
            }

            // пример Nullable
            int?number = null;

            //number = 35;

            if (number.HasValue)        // если не null
            {
                // сюда попадем
            }

            // синтаксический сахар для:
            // Nullable<int> number = null;


            // демонстрация упаковки-распаковки (boxing-unboxing)
            object o = new object();
            int    x = 40;

            o = x;          //boxing

            int y = (int)o; // unboxing

            // value-type           struct, int, double,
            // reference-type

            // демо перехвата исключения
            try
            {
                var name = "".Cleanse();
                MessageBox.Show(name);
            }
            catch (ArgumentException aex)
            {
                // ... close and clean resources
                //throw;
            }
            finally
            {
                // ...
            }

            //
            // конструкция using
            //

            //using (FileStream fs = new FileStream("a.txt", FileMode.Open))
            //{
            //}

            // => аналогично:

            //FileStream fs;
            //try
            //{
            //    fs = new FileStream();
            //    // ...
            //}
            //finally
            //{
            //    if (fs != null)
            //        fs.Close();
            //}

            // пример кортежа (Tuple)
            var tuple = new Tuple <int, string>(1, "OK");

            // например, если хотим вернуть из функции два результата
            // (аналог кортежа в Python)

            var info = tuple.Item1 + tuple.Item2;
        }
        public void GetAll_Users(int iDisplayLength, int iDisplayStart, int iSortCol_0, string sSortDir_0, string sSearch)
        {
            int    displayLength = iDisplayLength;
            int    displayStart  = iDisplayStart;
            int    sortCol       = iSortCol_0;
            string sortDir       = sSortDir_0;
            string search        = sSearch;

            string cs = ConfigurationManager.ConnectionStrings["DBMS"].ConnectionString;

            List <Steward> listEmployees = new List <Steward>();
            int            filteredCount = 0;

            using (SqlConnection con = new SqlConnection(cs))
            {
                SqlCommand cmd = new SqlCommand("sp_GetUser", con);
                cmd.CommandType = CommandType.StoredProcedure;

                SqlParameter paramDisplayLength = new SqlParameter()
                {
                    ParameterName = "@DisplayLength",
                    Value         = displayLength
                };
                cmd.Parameters.Add(paramDisplayLength);

                SqlParameter paramDisplayStart = new SqlParameter()
                {
                    ParameterName = "@DisplayStart",
                    Value         = displayStart
                };
                cmd.Parameters.Add(paramDisplayStart);

                SqlParameter paramSortCol = new SqlParameter()
                {
                    ParameterName = "@SortCol",
                    Value         = sortCol
                };
                cmd.Parameters.Add(paramSortCol);

                SqlParameter paramSortDir = new SqlParameter()
                {
                    ParameterName = "@SortDir",
                    Value         = sortDir
                };
                cmd.Parameters.Add(paramSortDir);

                SqlParameter paramSearchString = new SqlParameter()
                {
                    ParameterName = "@Search",
                    Value         = string.IsNullOrEmpty(search) ? null : search
                };
                cmd.Parameters.Add(paramSearchString);

                con.Open();
                SqlDataReader rdr = cmd.ExecuteReader();
                while (rdr.Read())
                {
                    Steward users = new Steward();
                    users.User_Id   = Convert.ToInt32(rdr["User_Id"]);
                    filteredCount   = Convert.ToInt32(rdr["TotalCount"]);
                    users.User_Name = rdr["User_Name"].ToString();
                    users.Age       = rdr["Age"].ToString();
                    users.Password  = rdr["Password"].ToString();
                    users.Email     = rdr["Email"].ToString();
                    users.Img       = Convert.ToString(rdr["Img"]);
                    users.gender    = rdr["gender"].ToString();

                    listEmployees.Add(users);
                }
            }

            var result = new
            {
                iTotalRecords        = GetEmployeeTotalCount(),
                iTotalDisplayRecords = filteredCount,
                aaData = listEmployees
            };

            JavaScriptSerializer js = new JavaScriptSerializer();

            Context.Response.Write(js.Serialize(result));
        }
Exemplo n.º 8
0
        public async Task InitializeData()
        {
            _dbContext.Database.EnsureDeleted();
            if (_dbContext.Database.EnsureCreated())
            {
                #region init users
                // Stewards
                Steward steward = new Steward {
                    Email = "*****@*****.**", FirstName = "Sebastien", LastName = "Wojtyla"
                };

                await CreateSteward(steward.Email, "Azertyuiop@1");

                _dbContext.Stewards.Add(steward);

                // Passengers
                Passenger passenger1 = new Passenger {
                    Email = "*****@*****.**", FirstName = "Marie", LastName = "Louise", SeatNumber = 1
                };

                await CreatePassenger(passenger1.Email, "Azertyuiop@1");

                Passenger passenger2 = new Passenger {
                    Email = "*****@*****.**", FirstName = "George", LastName = "Floyd", SeatNumber = 2
                };

                await CreatePassenger(passenger2.Email, "Azertyuiop@1");

                Passenger passenger3 = new Passenger {
                    Email = "*****@*****.**", FirstName = "Sandra", LastName = "Wilson", SeatNumber = 3
                };

                await CreatePassenger(passenger3.Email, "Azertyuiop@1");

                Passenger passenger4 = new Passenger {
                    Email = "*****@*****.**", FirstName = "Hilaire", LastName = "Simard", SeatNumber = 4
                };

                await CreatePassenger(passenger4.Email, "Azertyuiop@1");

                Passenger passenger5 = new Passenger {
                    Email = "*****@*****.**", FirstName = "Roger", LastName = "Dupont", SeatNumber = 5
                };

                await CreatePassenger(passenger5.Email, "Azertyuiop@1");

                Passenger passenger6 = new Passenger {
                    Email = "*****@*****.**", FirstName = "Nando", LastName = "Diemel", SeatNumber = 6
                };

                await CreatePassenger(passenger6.Email, "Azertyuiop@1");

                Passenger passenger7 = new Passenger {
                    Email = "*****@*****.**", FirstName = "Maarten", LastName = "Deur", SeatNumber = 7
                };

                await CreatePassenger(passenger7.Email, "Azertyuiop@1");

                Passenger passenger8 = new Passenger {
                    Email = "*****@*****.**", FirstName = "Nancy", LastName = "Bel", SeatNumber = 8
                };

                await CreatePassenger(passenger8.Email, "Azertyuiop@1");

                Passenger passenger9 = new Passenger {
                    Email = "*****@*****.**", FirstName = "Emile", LastName = "Desmet", SeatNumber = 9
                };

                await CreatePassenger(passenger9.Email, "Azertyuiop@1");

                Passenger passenger10 = new Passenger {
                    Email = "*****@*****.**", FirstName = "Aaron", LastName = "Meskens", SeatNumber = 10
                };

                await CreatePassenger(passenger10.Email, "Azertyuiop@1");

                _dbContext.Passengers.AddRange(passenger1, passenger2, passenger3, passenger4, passenger5, passenger6, passenger7, passenger8, passenger9, passenger10);
                #endregion

                #region set contacts
                // Passenger 1 kent 3 & 4
                PassengerContact passengerContact1 = new PassengerContact {
                    Passenger = passenger1, PassengerId = passenger1.PersonId, Contact = passenger3, ContactId = passenger3.PersonId
                };
                PassengerContact passengerContact2 = new PassengerContact {
                    Passenger = passenger1, PassengerId = passenger1.PersonId, Contact = passenger4, ContactId = passenger4.PersonId
                };
                List <PassengerContact> passengerContacts1 = new List <PassengerContact>
                {
                    passengerContact1,
                    passengerContact2
                };
                passenger1.Contacts = passengerContacts1;

                // Passenger 2 kent 5
                PassengerContact passengerContact3 = new PassengerContact {
                    Passenger = passenger2, PassengerId = passenger2.PersonId, Contact = passenger5, ContactId = passenger5.PersonId
                };
                List <PassengerContact> passengerContacts2 = new List <PassengerContact>
                {
                    passengerContact3
                };
                passenger2.Contacts = passengerContacts2;

                // Passenger 3 kent 1 & 4
                PassengerContact passengerContact4 = new PassengerContact {
                    Passenger = passenger3, PassengerId = passenger3.PersonId, Contact = passenger1, ContactId = passenger1.PersonId
                };
                PassengerContact passengerContact5 = new PassengerContact {
                    Passenger = passenger3, PassengerId = passenger3.PersonId, Contact = passenger4, ContactId = passenger4.PersonId
                };
                List <PassengerContact> passengerContacts3 = new List <PassengerContact>
                {
                    passengerContact4,
                    passengerContact5
                };
                passenger3.Contacts = passengerContacts3;

                // Passenger 4 kent 1 & 3
                PassengerContact passengerContact6 = new PassengerContact {
                    Passenger = passenger4, PassengerId = passenger4.PersonId, Contact = passenger1, ContactId = passenger1.PersonId
                };
                PassengerContact passengerContact7 = new PassengerContact {
                    Passenger = passenger4, PassengerId = passenger4.PersonId, Contact = passenger3, ContactId = passenger3.PersonId
                };
                List <PassengerContact> passengerContacts4 = new List <PassengerContact>
                {
                    passengerContact6,
                    passengerContact7
                };
                passenger4.Contacts = passengerContacts4;

                // Passenger 5 kent 2
                PassengerContact passengerContact8 = new PassengerContact {
                    Passenger = passenger5, PassengerId = passenger5.PersonId, Contact = passenger2, ContactId = passenger2.PersonId
                };
                List <PassengerContact> passengerContacts5 = new List <PassengerContact>
                {
                    passengerContact8
                };
                passenger5.Contacts = passengerContacts5;

                // Passenger 6 kent 9 & 10
                PassengerContact passengerContact9 = new PassengerContact {
                    Passenger = passenger6, PassengerId = passenger6.PersonId, Contact = passenger9, ContactId = passenger9.PersonId
                };
                PassengerContact passengerContact10 = new PassengerContact {
                    Passenger = passenger6, PassengerId = passenger6.PersonId, Contact = passenger10, ContactId = passenger10.PersonId
                };
                List <PassengerContact> passengerContacts6 = new List <PassengerContact>
                {
                    passengerContact9,
                    passengerContact10
                };
                passenger6.Contacts = passengerContacts6;

                // Passenger 7 kent 8
                PassengerContact passengerContact11 = new PassengerContact {
                    Passenger = passenger7, PassengerId = passenger7.PersonId, Contact = passenger8, ContactId = passenger8.PersonId
                };
                List <PassengerContact> passengerContacts7 = new List <PassengerContact>
                {
                    passengerContact11
                };
                passenger7.Contacts = passengerContacts7;

                // Passenger 8 kent 7
                PassengerContact passengerContact12 = new PassengerContact {
                    Passenger = passenger8, PassengerId = passenger8.PersonId, Contact = passenger7, ContactId = passenger7.PersonId
                };
                List <PassengerContact> passengerContacts8 = new List <PassengerContact>
                {
                    passengerContact12
                };
                passenger8.Contacts = passengerContacts8;

                // Passenger 9 kent 6 & 10
                PassengerContact passengerContact13 = new PassengerContact {
                    Passenger = passenger9, PassengerId = passenger9.PersonId, Contact = passenger6, ContactId = passenger6.PersonId
                };
                PassengerContact passengerContact14 = new PassengerContact {
                    Passenger = passenger9, PassengerId = passenger9.PersonId, Contact = passenger10, ContactId = passenger10.PersonId
                };
                List <PassengerContact> passengerContacts9 = new List <PassengerContact>
                {
                    passengerContact13,
                    passengerContact14
                };
                passenger9.Contacts = passengerContacts9;

                // Passenger 10 kent 6 & 9
                PassengerContact passengerContact15 = new PassengerContact {
                    Passenger = passenger10, PassengerId = passenger10.PersonId, Contact = passenger6, ContactId = passenger6.PersonId
                };
                PassengerContact passengerContact16 = new PassengerContact {
                    Passenger = passenger10, PassengerId = passenger10.PersonId, Contact = passenger9, ContactId = passenger9.PersonId
                };
                List <PassengerContact> passengerContacts10 = new List <PassengerContact>
                {
                    passengerContact15,
                    passengerContact16
                };
                passenger10.Contacts = passengerContacts10;

                _dbContext.SaveChanges();
                #endregion

                #region init products
                Product water = new Product {
                    Name = "water", ImagePath = "/Assets/water.png", BasePrice = 0.80
                };
                water.SetPrice();
                Product cola = new Product {
                    Name = "cola", ImagePath = "/Assets/cola.jpg", BasePrice = 1.00
                };
                cola.SetPrice();
                Product tea = new Product {
                    Name = "ice tea", ImagePath = "/Assets/ice_tea.png", BasePrice = 1.00
                };
                tea.SetPrice();
                Product coffee = new Product {
                    Name = "coffee", ImagePath = "/Assets/coffee.jpg", BasePrice = 1.50
                };
                coffee.SetPrice();
                Product orangina = new Product {
                    Name = "orangina", ImagePath = "/Assets/orangina.png", BasePrice = 1.00
                };
                orangina.SetPrice();

                Product hotdog = new Product {
                    Name = "hotdog", ImagePath = "/Assets/hotdog.jpg", BasePrice = 2.50
                };
                hotdog.SetPrice();
                Product hamburger = new Product {
                    Name = "hamburger", ImagePath = "/Assets/hamburger.jpg", BasePrice = 3.00
                };
                hamburger.SetPrice();
                Product panini = new Product {
                    Name = "panini", ImagePath = "/Assets/panini.jpg", BasePrice = 2.50
                };
                panini.SetPrice();
                Product donut = new Product {
                    Name = "donut", ImagePath = "/Assets/donut.jpg", BasePrice = 1.50
                };
                donut.SetPrice();
                Product chips = new Product {
                    Name = "chips", ImagePath = "/Assets/chips.jpg", BasePrice = 2.00
                };
                chips.SetPrice();

                _dbContext.Products.AddRange(water, cola, tea, coffee, orangina, hotdog, hamburger, panini, donut, chips);
                #endregion

                #region init categories
                List <Product> drinklist = new List <Product>()
                {
                    water, cola, tea, coffee, orangina
                };
                Category drinks = new Category {
                    Name = "drinks", Products = drinklist
                };

                List <Product> foodlist = new List <Product>()
                {
                    hotdog, hamburger, panini, donut, chips
                };
                Category food = new Category {
                    Name = "food", Products = foodlist
                };

                _dbContext.Categories.AddRange(drinks, food);
                _dbContext.SaveChanges();
                #endregion

                #region init orders
                // Orderlines - drinks
                Orderline orderlineWater1    = new Orderline(water);
                Orderline orderlineWater2    = new Orderline(water);
                Orderline orderlineWater3    = new Orderline(water);
                Orderline orderlineCola1     = new Orderline(cola);
                Orderline orderlineTea1      = new Orderline(tea);
                Orderline orderlineCoffee1   = new Orderline(coffee);
                Orderline orderlineCoffee2   = new Orderline(coffee);
                Orderline orderlineOrangina1 = new Orderline(orangina);
                Orderline orderlineOrangina2 = new Orderline(orangina);
                // Orderlines - food
                Orderline orderlineHotdog1    = new Orderline(hotdog);
                Orderline orderlineHotdog2    = new Orderline(hotdog);
                Orderline orderlineHamburger1 = new Orderline(hamburger);
                Orderline orderlineHamburger2 = new Orderline(hamburger);
                Orderline orderlinePanini1    = new Orderline(panini);
                Orderline orderlineDonut1     = new Orderline(donut);
                Orderline orderlineDonut2     = new Orderline(donut);
                Orderline orderlineChips1     = new Orderline(chips);

                // Orders
                Order order1 = new Order(1);
                order1.Orderlines.Add(orderlineWater1);
                order1.Orderlines.Add(orderlineHotdog1);
                order1.SetOrderCost();

                Order order2 = new Order(1);
                order2.Orderlines.Add(orderlineTea1);
                order2.Orderlines.Add(orderlineDonut1);
                order2.SetOrderCost();

                Order order3 = new Order(2);
                order3.Orderlines.Add(orderlineOrangina1);
                order3.Orderlines.Add(orderlineHotdog2);
                order3.SetOrderCost();

                Order order4 = new Order(5);
                order4.Orderlines.Add(orderlineCoffee1);
                order4.Orderlines.Add(orderlineDonut2);
                order4.Orderlines.Add(orderlineWater2);
                order4.SetOrderCost();

                Order order5 = new Order(6);
                order5.Orderlines.Add(orderlineCola1);
                order5.Orderlines.Add(orderlineHamburger1);
                order5.Orderlines.Add(orderlinePanini1);
                order5.SetOrderCost();

                Order order6 = new Order(7);
                order6.Orderlines.Add(orderlineCoffee2);
                order6.Orderlines.Add(orderlineHamburger2);
                order6.SetOrderCost();

                Order order7 = new Order(8);
                order7.Orderlines.Add(orderlineWater3);
                order7.SetOrderCost();

                Order order8 = new Order(9);
                order8.Orderlines.Add(orderlineOrangina2);
                order8.Orderlines.Add(orderlineChips1);
                order8.SetOrderCost();

                _dbContext.Orders.AddRange(order1, order2, order3, order4, order5, order6, order7, order8);
                #endregion

                #region init flightInfo
                Location brussel = new Location {
                    Country = "Belgium", City = "Zaventem", Latitude = 50.8855, Longitude = 4.4710
                };
                Location loiu = new Location {
                    Country = "Spain", City = "Loiu", Latitude = 43.3161, Longitude = -2.92444
                };

                Airport brusselsAirport = new Airport {
                    Name = "Brussels Airport", Location = brussel
                };
                Airport bilbaoAirport = new Airport {
                    Name = "Bilbao Airport", Location = loiu
                };

                Aircraft boeing747 = new Aircraft {
                    Name = "Boeing 747", ConstructionYear = 1984, ImageString = "/Assets/aircraft.jpg"
                };

                Airline soloFlightAirlines = new Airline {
                    Name = "Solo Flight Airlines", Description = "This airline company was found in 2020 during covid-19.", ImageString = "/Assets/airline.png"
                };

                FlightDetail detail = new FlightDetail {
                    DepartingAirport = brusselsAirport, DepartingTime = new DateTime(2020, 8, 15, 12, 0, 0), ArrivalAirport = bilbaoAirport, ArrivalTime = new DateTime(2020, 8, 15, 15, 0, 0)
                };

                Flight flight = new Flight {
                    Airline = soloFlightAirlines, Aircraft = boeing747, FlightDetail = detail
                };
                _dbContext.Flights.Add(flight);
                #endregion

                #region init movies
                List <Movie> movies = new List <Movie> {
                    new Movie("Star Wars: The Rise of Skywalker", DateTime.Parse("2019/12/19"), 141, "The surviving Resistance faces the First Order once more in the final chapter of the Skywalker saga.", "J.J. Abrams", "https://m.media-amazon.com/images/M/MV5BMDljNTQ5ODItZmQwMy00M2ExLTljOTQtZTVjNGE2NTg0NGIxXkEyXkFqcGdeQXVyODkzNTgxMDg@._V1_UX182_CR0,0,182,268_AL_.jpg", "https://www.youtube.com/embed/8Qn_spdM5Zg"),
                    new Movie("The Shawshank Redemption", DateTime.Parse("1995/2/17"), 142, "Two imprisoned men bond over a number of years, finding solace and eventual redemption through acts of common decency. ", "F. Darabont", "https://m.media-amazon.com/images/M/MV5BMDFkYTc0MGEtZmNhMC00ZDIzLWFmNTEtODM1ZmRlYWMwMWFmXkEyXkFqcGdeQXVyMTMxODk2OTU@._V1_UX182_CR0,0,182,268_AL_.jpg", "https://www.youtube.com/embed/6hB3S9bIaco"),
                    new Movie("The Godfather", DateTime.Parse("1972/8/24"), 175, "The aging patriarch of an organized crime dynasty transfers control of his clandestine empire to his reluctant son. ", "F. F. Coppola", "https://m.media-amazon.com/images/M/MV5BM2MyNjYxNmUtYTAwNi00MTYxLWJmNWYtYzZlODY3ZTk3OTFlXkEyXkFqcGdeQXVyNzkwMjQ5NzM@._V1_UY268_CR3,0,182,268_AL_.jpg", "https://www.youtube.com/embed/CWoQlDlyQj4"),
                    new Movie("The Godfather: Part II", DateTime.Parse("1975/5/15"), 202, "Early life and career of Vito Corleone in 1920s New York City is portrayed, while his son, Michael, expands and tightens his grip on the family crime syndicate. ", "F. F. Coppola", "https://m.media-amazon.com/images/M/MV5BMWMwMGQzZTItY2JlNC00OWZiLWIyMDctNDk2ZDQ2YjRjMWQ0XkEyXkFqcGdeQXVyNzkwMjQ5NzM@._V1_UY268_CR3,0,182,268_AL_.jpg", "https://www.youtube.com/embed/9O1Iy9od7-A"),
                    new Movie("Schindler's List", DateTime.Parse("1994/2/18"), 195, "In German-occupied Poland during World War II, industrialist Oskar Schindler gradually becomes concerned for his Jewish workforce after witnessing their persecution by the Nazis.", "S. Spielberg", "https://m.media-amazon.com/images/M/MV5BNDE4OTMxMTctNmRhYy00NWE2LTg3YzItYTk3M2UwOTU5Njg4XkEyXkFqcGdeQXVyNjU0OTQ0OTY@._V1_UX182_CR0,0,182,268_AL_.jpg", "https://www.youtube.com/embed/gG22XNhtnoY"),
                    new Movie("The Lord of the Rings: The Fellowship of the Ring", DateTime.Parse("2001/12/19"), 178, "A meek Hobbit from the Shire and eight companions set out on a journey to destroy the powerful One Ring and save Middle-earth from the Dark Lord Sauron. ", "P. Jackson", "https://m.media-amazon.com/images/M/MV5BN2EyZjM3NzUtNWUzMi00MTgxLWI0NTctMzY4M2VlOTdjZWRiXkEyXkFqcGdeQXVyNDUzOTQ5MjY@._V1_UX182_CR0,0,182,268_AL_.jpg", "https://www.youtube.com/embed/V75dMMIW2B4"),
                    new Movie("The Lord of the Rings: The Two Towers", DateTime.Parse("2002/12/18"), 179, "While Frodo and Sam edge closer to Mordor with the help of the shifty Gollum, the divided fellowship makes a stand against Sauron's new ally, Saruman, and his hordes of Isengard.", "P. Jackson", "https://m.media-amazon.com/images/M/MV5BNGE5MzIyNTAtNWFlMC00NDA2LWJiMjItMjc4Yjg1OWM5NzhhXkEyXkFqcGdeQXVyNzkwMjQ5NzM@._V1_UY268_CR0,0,182,268_AL_.jpg", "https://www.youtube.com/embed/hYcw5ksV8YQ"),
                    new Movie("The Lord of the Rings: The Return of the King", DateTime.Parse("2003/12/17"), 201, "TGandalf and Aragorn lead the World of Men against Sauron's army to draw his gaze from Frodo and Sam as they approach Mount Doom with the One Ring.", "P. Jackson", "https://m.media-amazon.com/images/M/MV5BNzA5ZDNlZWMtM2NhNS00NDJjLTk4NDItYTRmY2EwMWZlMTY3XkEyXkFqcGdeQXVyNzkwMjQ5NzM@._V1_UX182_CR0,0,182,268_AL_.jpg", "https://www.youtube.com/embed/r5X-hFf6Bwo"),
                    new Movie("Pulp Fiction", DateTime.Parse("1994/10/24"), 154, "The lives of two mob hitmen, a boxer, a gangster and his wife, and a pair of diner bandits intertwine in four tales of violence and redemption. ", "Q. Tarantino", "https://m.media-amazon.com/images/M/MV5BNGNhMDIzZTUtNTBlZi00MTRlLWFjM2ItYzViMjE3YzI5MjljXkEyXkFqcGdeQXVyNzkwMjQ5NzM@._V1_UY268_CR1,0,182,268_AL_.jpg", "https://www.youtube.com/embed/s7EdQ4FqbhY")
                };
                movies.ForEach(m => _dbContext.Movies.Add(m));
                #endregion

                #region init music
                List <Music> music = new List <Music> {
                    new Music("God's Plan", "Drake", "https://charts-static.billboard.com/img/2018/01/drake-hq6-87x87.jpg"),
                    new Music("Perfect", "Ed Sheeran", "https://charts-static.billboard.com/img/2017/03/ed-sheeran-buv-87x87.jpg"),
                    new Music("Meant To Be", "Bebe Rexha", "https://charts-static.billboard.com/img/2017/10/bebe-rexha-8wm-87x87.jpg"),
                    new Music("Havana", "Camila Cabello", "https://charts-static.billboard.com/img/2017/08/camila-cabello-4tx-87x87.jpg"),
                    new Music("Rockstar", "Post Malone", "https://charts-static.billboard.com/img/2017/10/post-malone-1vw-87x87.jpg"),
                    new Music("Psycho", "Post Malone", "https://charts-static.billboard.com/img/2018/03/post-malone-tp6-87x87.jpg"),
                    new Music("I Like It", "Cardi B", "https://charts-static.billboard.com/img/2018/04/cardi-b-n38-i-like-it-ppy-87x87.jpg"),
                    new Music("The Middle", "Zedd", "https://charts-static.billboard.com/img/2018/02/zedd-edd-87x87.jpg"),
                    new Music("In My Feelings", "Drake", "https://charts-static.billboard.com/img/2018/07/drake-zwl-in-my-feelings-591-87x87.jpg"),
                    new Music("Girls Like You", "Maroon 5", "https://charts-static.billboard.com/img/2018/06/maroon-5-9st-girls-like-you-32b-87x87.jpg")
                };
                music.ForEach(m => _dbContext.Music.Add(m));
                #endregion

                _dbContext.SaveChanges();
            }
        }
Exemplo n.º 9
0
 // Use this for initialization
 void Start()
 {
     steward = GameObject.Find("Steward").GetComponent <Steward> ();
     bkOver.SetActive(false);
 }