private void Button26_Click(object sender, EventArgs e) { Land landToQuery = SelectObjectForm.selectObject("Wähle Land", Data.Laender.ToList()) as Land; if (landToQuery == null) { return; } Console.WriteLine("List People living in country " + landToQuery.Name); var personen = ( from stadt in landToQuery.Staedte from einw in stadt.Einwohner orderby einw.Familienname select einw ) .Distinct(); foreach (Person person in personen) { Console.WriteLine(person.getFullname()); } }
private void Button23_Click(object sender, EventArgs e) { Fluss flussToDelete = SelectObjectForm.selectObject("Lösche Fluss", Data.Fluesse) as Fluss; if (flussToDelete == null) { return; } Data.Fluesse.Remove(flussToDelete); Data.SaveChanges(); }
private void Button15_Click(object sender, EventArgs e) { Stadt stadtToDelete = SelectObjectForm.selectObject("Lösche Stadt", Data.Staedte) as Stadt; if (stadtToDelete == null) { return; } Data.Staedte.Remove(stadtToDelete); Data.SaveChanges(); }
private void Button19_Click(object sender, EventArgs e) { Land landToDelete = SelectObjectForm.selectObject("Lösche Land", Data.Laender) as Land; if (landToDelete == null) { return; } Data.Laender.Remove(landToDelete); Data.SaveChanges(); }
private void Button11_Click(object sender, EventArgs e) { Person personToDelete = SelectObjectForm.selectObject("Lösche Person", Data.People) as Person; if (personToDelete == null) { return; } Data.People.Remove(personToDelete); Data.SaveChanges(); }
public static IEnumerable <object> selectObjects (string caption, IEnumerable <object> elementList) { SelectObjectForm form = new SelectObjectForm(); form.Text = caption; form.Elements = elementList; form.MultiSelect = true; DialogResult res = form.ShowDialog(); if (res != DialogResult.OK) { return(null); } return(form.Elements); }
public static object selectObject (string caption, IEnumerable <object> elementList) { SelectObjectForm form = new SelectObjectForm(); form.Text = caption; form.Elements = elementList; form.MultiSelect = false; DialogResult res = form.ShowDialog(); if (res != DialogResult.OK) { return(null); } return(form.Elements.FirstOrDefault()); }
private void Button22_Click(object sender, EventArgs e) { try { Fluss flussToUpdate = SelectObjectForm.selectObject("Ändere Fluß", Data.Laender) as Fluss; if (flussToUpdate == null) { return; } FlussForm.updateFluss(Data, flussToUpdate); Data.SaveChanges(); } catch (Exception ex) { Console.WriteLine(ex.ToString()); } }
private void Button18_Click(object sender, EventArgs e) { try { Land landToUpdate = SelectObjectForm.selectObject("Ändere Land", Data.Laender) as Land; if (landToUpdate == null) { return; } LandForm.updateLand(Data, landToUpdate); Data.SaveChanges(); } catch (Exception ex) { Console.WriteLine(ex.ToString()); } }
private void Button14_Click(object sender, EventArgs e) { try { Stadt stadtToUpdate = SelectObjectForm.selectObject("Ändere Person", Data.Staedte) as Stadt; if (stadtToUpdate == null) { return; } StadtForm.updateStadt(Data, stadtToUpdate); Data.SaveChanges(); } catch (Exception ex) { Console.WriteLine(ex.ToString()); } }
private void Button10_Click(object sender, EventArgs e) { try { Person personToUpdate = SelectObjectForm.selectObject("Ändere Person", Data.People) as Person; if (personToUpdate == null) { return; } PersonForm.updatePerson(Data, personToUpdate); Data.SaveChanges(); } catch (Exception ex) { Console.WriteLine(ex.ToString()); } }
private void Button28_Click(object sender, EventArgs e) { Land landToQuery = SelectObjectForm.selectObject("Land wählen ...", Data.Laender.ToList()) as Land; if (landToQuery == null) { return; } var staedteToExclude = SelectObjectForm.selectObjects("Städte wählen", landToQuery.Staedte.ToList() ).Select(o => o as Stadt).Where(p => p != null).ToList(); Console.WriteLine("Auszuschließende Städte"); staedteToExclude.ToList().ForEach(Console.WriteLine); var otherStaedte = (from stadt in landToQuery.Staedte where !staedteToExclude.Any(s => s == stadt) select stadt ).ToArray(); Console.WriteLine("Restliche Städte"); otherStaedte.ToList().ForEach(Console.WriteLine); var persons = ( from stadt in otherStaedte from einw in stadt.Einwohner orderby einw.Familienname select einw) .Distinct(); Console.WriteLine("Bewohner der restlichen Städte"); persons.ToList().ForEach(Console.WriteLine); }
private void Button27_Click(object sender, EventArgs e) { Fluss flussToQuery = SelectObjectForm.selectObject("Wähle Fluß", Data.Fluesse) as Fluss; if (flussToQuery == null) { return; } var staedte = from stadt in flussToQuery.Durchfließt select stadt; foreach (var stadt in staedte) { Console.WriteLine(stadt.getDescription()); } Console.WriteLine("List People living next to first river"); var personen = ( from person in Data.People where person.WohntIn.Any( wi => wi.LiegtAn.Any( la => la == Data.Fluesse.FirstOrDefault())) orderby person.Familienname ascending select person ) .Distinct(); foreach (var person in personen) { Console.WriteLine(person.getFullname()); } }