コード例 #1
0
        public void Query6()
        {
            var v5 = context.Villains;

            foreach (var item in v5)
            {
                Console.WriteLine(item.Id + " " + item.Name);
            }
            int temp = int.Parse(Console.ReadLine());

            MinionsVillains minionsVillains = context.MinionsVillains
                                              .Where(o => o.VillainId == temp)
                                              .FirstOrDefault();

            context.MinionsVillains.Remove(minionsVillains);
            context.SaveChanges();

            var v6 = context.MinionsVillains;

            foreach (var i in v6)
            {
                Console.WriteLine(i.MinionId + " " + i.VillainId);
            }

            Villain villain = context.Villains
                              .Where(o => o.Id == temp)
                              .FirstOrDefault();

            context.Villains.Remove(villain);
            context.SaveChanges();
        }
コード例 #2
0
        public void Initialize()
        {
            using (MinionsContext db = new MinionsContext())
            {
                //creating Minions


                Country country1 = new Country {
                    Name = "USA", Id = 1
                };
                Country country2 = new Country {
                    Name = "Ukraine", Id = 2
                };
                Country country3 = new Country {
                    Name = "Germany", Id = 3
                };
                Country country4 = new Country {
                    Name = "Italy", Id = 4
                };
                Country country5 = new Country {
                    Name = "France", Id = 5
                };

                Town town1 = new Town {
                    Name = "Kyiv", CountryId = 2, Id = 1
                };
                Town town2 = new Town {
                    Name = "Vancouver", CountryId = 1, Id = 2
                };
                Town town3 = new Town {
                    Name = "Washington", CountryId = 1, Id = 3
                };
                Town town4 = new Town {
                    Name = "New York", CountryId = 1, Id = 4
                };
                Town town5 = new Town {
                    Name = "Parise", CountryId = 5, Id = 5
                };
                Town town6 = new Town {
                    Name = "Munchen", CountryId = 3, Id = 6
                };
                Town town7 = new Town {
                    Name = "Frankfurt", CountryId = 3, Id = 7
                };
                Town town8 = new Town {
                    Name = "Rome", CountryId = 4, Id = 8
                };
                Town town9 = new Town {
                    Name = "Venezia", CountryId = 4, Id = 9
                };
                Town town10 = new Town {
                    Name = "Odessa", CountryId = 2, Id = 10
                };

                EvilnessFactor evilnessFactor1 = new EvilnessFactor {
                    Name = "Bad", Id = 3
                };
                EvilnessFactor evilnessFactor2 = new EvilnessFactor {
                    Name = "Good", Id = 2
                };
                EvilnessFactor evilnessFactor3 = new EvilnessFactor {
                    Name = "Pretty", Id = 1
                };
                EvilnessFactor evilnessFactor4 = new EvilnessFactor {
                    Name = "Evil", Id = 4
                };

                Villain villain1 = new Villain {
                    Name = "Tominikano", Id = 1, EvilnessFactorId = 3
                };
                Villain villain2 = new Villain {
                    Name = "Zelenino", Id = 2, EvilnessFactorId = 4
                };
                Villain villain3 = new Villain {
                    Name = "Porohino", Id = 3, EvilnessFactorId = 2
                };
                Villain villain4 = new Villain {
                    Name = "Trumpino", Id = 4, EvilnessFactorId = 1
                };

                MinionsVillains minionsVillains1 = new MinionsVillains {
                    Id = 1, MinionId = 1, VillainId = 1
                };
                MinionsVillains minionsVillains2 = new MinionsVillains {
                    Id = 2, MinionId = 2, VillainId = 1
                };
                MinionsVillains minionsVillains3 = new MinionsVillains {
                    Id = 3, MinionId = 3, VillainId = 1
                };
                MinionsVillains minionsVillains4 = new MinionsVillains {
                    Id = 4, MinionId = 4, VillainId = 2
                };
                MinionsVillains minionsVillains5 = new MinionsVillains {
                    Id = 5, MinionId = 5, VillainId = 3
                };
                MinionsVillains minionsVillains6 = new MinionsVillains {
                    Id = 6, MinionId = 6, VillainId = 4
                };
                MinionsVillains minionsVillains7 = new MinionsVillains {
                    Id = 7, MinionId = 5, VillainId = 4
                };
                MinionsVillains minionsVillains8 = new MinionsVillains {
                    Id = 8, MinionId = 4, VillainId = 4
                };


                Minion minion1 = new Minion {
                    Name = "Tony", Age = 19, Id = 1, TownId = 1
                };
                Minion minion2 = new Minion {
                    Name = "Gabriel", Age = 18, Id = 2, TownId = 1
                };
                Minion minion3 = new Minion {
                    Name = "Luiza", Age = 18, Id = 3, TownId = 2
                };
                Minion minion4 = new Minion {
                    Name = "Jack", Age = 14, Id = 4, TownId = 3
                };
                Minion minion5 = new Minion {
                    Name = "Tom", Age = 13, Id = 5, TownId = 3
                };
                Minion minion6 = new Minion {
                    Name = "Mitty", Age = 19, Id = 6, TownId = 4
                };


                #region adding to DB
                Console.WriteLine("Processing...");
                db.Countries.Add(country1);
                db.Countries.Add(country2);
                db.Countries.Add(country3);
                db.Countries.Add(country4);
                db.Countries.Add(country5);

                db.Towns.Add(town1);
                db.Towns.Add(town2);
                db.Towns.Add(town3);
                db.Towns.Add(town4);
                db.Towns.Add(town5);
                db.Towns.Add(town6);
                db.Towns.Add(town7);
                db.Towns.Add(town8);
                db.Towns.Add(town9);
                db.Towns.Add(town10);

                db.EvilnessFactors.Add(evilnessFactor1);
                db.EvilnessFactors.Add(evilnessFactor2);
                db.EvilnessFactors.Add(evilnessFactor3);
                db.EvilnessFactors.Add(evilnessFactor4);

                db.Villains.Add(villain1);
                db.Villains.Add(villain2);
                db.Villains.Add(villain3);
                db.Villains.Add(villain4);

                db.MinionsVillains.Add(minionsVillains1);
                db.MinionsVillains.Add(minionsVillains2);
                db.MinionsVillains.Add(minionsVillains3);
                db.MinionsVillains.Add(minionsVillains4);
                db.MinionsVillains.Add(minionsVillains5);
                db.MinionsVillains.Add(minionsVillains6);
                db.MinionsVillains.Add(minionsVillains7);
                db.MinionsVillains.Add(minionsVillains8);

                db.Minions.Add(minion1);
                db.Minions.Add(minion2);
                db.Minions.Add(minion3);
                db.Minions.Add(minion4);
                db.Minions.Add(minion5);
                db.Minions.Add(minion6);

                db.SaveChanges();
                Console.WriteLine("Data Added!");
                Console.ReadLine();
                #endregion
            }
        }
コード例 #3
0
        public void Query4()
        {
            string name;
            int    age;

            string townName;
            string villainName;

            String s;

            Console.WriteLine("Add Minion : ");

            Console.WriteLine("Input name of minion: ");
            Console.WriteLine("Input age of minion: ");
            Console.WriteLine("Input town of minion: ");

            s = Console.ReadLine();
            String[] words = s.Split(new char[] { ' ' }, StringSplitOptions.RemoveEmptyEntries);
            name     = words[0].ToString();
            age      = Convert.ToInt32(words[1]);
            townName = words[2];

            Minion minions = new Minion();

            Console.WriteLine("Input name of Villain : ");
            villainName = Console.ReadLine();

            Town towns  = new Town();
            var  Ttowns = context.Towns.ToList();

            bool flag  = false;
            bool flag1 = false;
            int  idd   = 0;

            foreach (var t in Ttowns)
            {
                if (t.Name == words[2])
                {
                    idd  = t.Id;
                    flag = true;
                    break;
                }
                else if (t.Name != words[2])
                {
                    flag = false;
                }
            }

            if (flag == true)
            {
                minions.TownId = idd;
                minions.Name   = name;
                minions.Age    = age;
                context.Minions.Add(minions);
                context.SaveChanges();
                Console.WriteLine("You have this town ");
            }
            else
            {
                towns.Name = words[2];
                context.Towns.Add(towns);
                context.SaveChanges();

                var newtowns = context.Towns.ToList();
                minions.Name = name;
                minions.Age  = age;
                foreach (var t in newtowns)
                {
                    if (t.Name == townName)
                    {
                        minions.TownId = t.Id;
                    }
                }

                context.Minions.Add(minions);
                context.SaveChanges();
                Console.WriteLine("This town were added to DB");
            }



            Villain         villains        = new Villain();
            var             villainss       = context.Villains.ToList();
            int             idvillain       = 0;
            int             idminion        = 0;
            var             minionss        = context.Minions.ToList();
            MinionsVillains minionsVillains = new MinionsVillains();

            foreach (var v in villainss)
            {
                if (villainName == v.Name)
                {
                    idvillain = v.Id;
                    flag1     = true;
                    break;
                }
                else if (villainName != v.Name)
                {
                    flag1 = false;
                }
            }

            if (flag1 == true)
            {
                idminion = minionss.Last().Id;
                minionsVillains.MinionId  = idminion;
                minionsVillains.VillainId = idvillain;
                context.MinionsVillains.Add(minionsVillains);
                context.SaveChanges();
                Console.WriteLine("You have this villain ");
            }
            else
            {
                villains.Name             = villainName;
                villains.EvilnessFactorId = 5;
                context.Villains.Add(villains);
                context.SaveChanges();

                var newvillains = context.Villains.ToList();////////////

                idminion = minionss.Last().Id;
                minionsVillains.MinionId  = idminion;
                minionsVillains.VillainId = newvillains.Last().Id;

                context.MinionsVillains.Add(minionsVillains);
                context.SaveChanges();

                Console.WriteLine("This villain were added to DB");
            }
        }