Esempio n. 1
0
 void RefreshList()
 {
     using (PeopleCarsContext ctx = new PeopleCarsContext())
     {
         lvPeople.ItemsSource = ctx.People.ToList();
     }
 }
Esempio n. 2
0
        private void miDelete_Click(object sender, RoutedEventArgs e)
        {
            Person currPerson = lvPeople.SelectedItem as Person;

            if (currPerson == null)
            {
                return;
            }
            //
            MessageBoxResult result = MessageBox.Show(this, "Are you sure you want to delete:\n" +
                                                      currPerson, "Confirm delete", MessageBoxButton.OKCancel, MessageBoxImage.Warning);

            //
            using (PeopleCarsContext ctx = new PeopleCarsContext())
            {
                if (result == MessageBoxResult.OK)
                {
                    var people = (from p in ctx.People where p.Id == currPerson.Id select p).ToList();
                    if (people.Count == 0)
                    {
                        Console.WriteLine("Record not found");
                    }
                    else
                    {
                        Person p = people[0];
                        ctx.People.Remove(p);
                        ctx.SaveChanges();
                        RefreshList();
                    }
                }
            }
        }
Esempio n. 3
0
        private void btnSavePerson_Click(object sender, RoutedEventArgs e)
        {
            using (PeopleCarsContext ctx = new PeopleCarsContext())
            {
                string name      = tbName.Text;
                int    age       = int.Parse(tbAge.Text);
                string genderStr = cbGender.Text;

                Person.GenderEnum gender;
                if (!Enum.TryParse <Person.GenderEnum>(genderStr, out gender))
                {
                    throw new InvalidCastException("Enum value invalid: " + genderStr);
                }

                if (currPerson == null)
                {
                    Person p = new Person {
                        Name = name, Age = age, Gender = gender
                    };
                    ctx.People.Add(p);
                    ctx.SaveChanges();
                }
                else
                {
                    var people = (from p in ctx.People where p.Id == currPerson.Id select p).ToList();
                    if (people.Count == 0)
                    {
                        Console.WriteLine("Record not found");
                    }
                    else
                    {
                        Person p = people[0];

                        p.Name   = name;
                        p.Age    = age;
                        p.Gender = gender;
                        ctx.SaveChanges();
                    }
                }
                this.DialogResult = true;
            }
        }