Ejemplo n.º 1
0
        private void AddNumbers()
        {
            Numbers num = new Numbers {
                CityName = TextBox1.Text, Number = TextBox2.Text, Coment = TextBox3.Text
            };

            using (CityContext context = new CityContext())
            {
                context.Number.Add(num);
                context.SaveChanges();
            }
            MessageBox.Show("Номер добавлен в базу");
        }
Ejemplo n.º 2
0
        private void AddCity()
        {
            using (CityContext context = new CityContext())
            {
                Cityes city1 = new Cityes {
                    Name = "Алматы", Code = "727"
                };
                Cityes city2 = new Cityes {
                    Name = "Актау", Code = "7292"
                };
                Cityes city3 = new Cityes {
                    Name = "Атырау", Code = "7122"
                };
                Cityes city4 = new Cityes {
                    Name = "Актобе", Code = "7132"
                };
                Cityes city5 = new Cityes {
                    Name = "Кокшетау", Code = "7162"
                };
                Cityes city6 = new Cityes {
                    Name = "Караганда", Code = "7212"
                };
                Cityes city7 = new Cityes {
                    Name = "Костанай", Code = "7142"
                };
                Cityes city8 = new Cityes {
                    Name = "Кызылорда", Code = "72422"
                };
                Cityes city9 = new Cityes {
                    Name = "Нурсултан", Code = "7172"
                };
                Cityes city10 = new Cityes {
                    Name = "Павлодар", Code = "7182"
                };
                Cityes city11 = new Cityes {
                    Name = "Петропавловск", Code = "7152"
                };
                Cityes city12 = new Cityes {
                    Name = "Тараз", Code = "7262"
                };
                Cityes city13 = new Cityes {
                    Name = "Талдыкорган", Code = "7282"
                };
                Cityes city14 = new Cityes {
                    Name = "Усть-Каменогорск", Code = "7232"
                };
                Cityes city15 = new Cityes {
                    Name = "Уральск", Code = "7112"
                };
                Cityes city16 = new Cityes {
                    Name = "Шымкент", Code = "7252"
                };

                context.City.Add(city1);
                context.City.Add(city2);
                context.City.Add(city3);
                context.City.Add(city4);
                context.City.Add(city5);
                context.City.Add(city6);
                context.City.Add(city7);
                context.City.Add(city8);
                context.City.Add(city9);
                context.City.Add(city10);
                context.City.Add(city11);
                context.City.Add(city12);
                context.City.Add(city13);
                context.City.Add(city14);
                context.City.Add(city15);
                context.City.Add(city16);
                context.SaveChanges();

                var           city   = context.City;
                List <Cityes> cityes = new List <Cityes>();

                foreach (var i in context.City)
                {
                    cityes.Add(i);
                }

                ListBox1.ItemsSource = cityes;
            }
        }