public void theApp() { PersonkartotekDBUtil utilObject = new PersonkartotekDBUtil(); List <Person> personList; Town newTown = new Town("8210", "Aarhus"); utilObject.addTownDB(ref newTown); Adresse nyAdresse = new Adresse("kærvænget", "9", newTown.townID); utilObject.addAdresseDB(ref nyAdresse); Person nyPerson = new Person(nyAdresse.adresseID, "Anton", "Rørbæk", "Sihm", "skole", "mand"); //utilObject.addPersonTilDB(ref nyPerson); //utilObject.getAllePersonDB(); //utilObject.updatePersonDB(); //Person nyPerson2 = new Person(nyAdresse.adresseID, "Anton", "Rørbæk", "test", "skole", "mand"); //utilObject.addPersonTilDB(ref nyPerson2); //Person HjælpeObjPerson = new Person(, ¨dsbsdbds, aarus); //utilObject.deletePersonDB("Anton", "sihm", aarus); //utilObject.deletePersonDB(ref HjælpeObjPerson); //Telefonnummer nytTelefonnummer = new Telefonnummer(50696065, 2, 100, "arbejde"); //utilObject.addTelefonnummerDB(ref nytTelefonnummer); //Note note1 = new Note(20, 1002, "This is a note"); //utilObject.addNoteDB(ref note1); }
public TownView() { InitializeComponent(); personkartotek_ = new PersonkartotekDBUtil(); }
public void ProgramApp() { PersonkartotekDBUtil personUtil = new PersonkartotekDBUtil(); City city = new City() // city { CityID = 1, CityName = "Aarhus", Country = "DK", PostNumber = "8000" }; personUtil.CreateCityDB(ref city); Address primaryAddr = new Address() // primary address { AddressID = 1, StreetName = "Finlandsgade", HouseNumber = "99", Town = city, // CityID = city.CityID, AlternativePerson = new List <AlternativeAddress>(), PersonsPrimary = new List <Person>() }; Email email = new Email() // email { EmailID = 5, EmailAddress = "*****@*****.**", PersonID = 11 }; Notes notes = new Notes() // notes { NotesID = 7, NotesText = "All the notes about this person comes soon...", PersonID = 11 }; Provider provider = new Provider() // telefon provider { ProviderID = 2, ProviderName = "Telia" }; Telefon tlf = new Telefon() // Telefon { TelefonID = 26, Number = 22663355, TelefonType = "Private", ProviderID = 2, PersonID = 11, TelefonProvider = provider }; // Create section personUtil.CreateAddressDB(ref primaryAddr); personUtil.CreateEmailDB(ref email); personUtil.CreateNotesDB(ref notes); personUtil.CreateTelefonDB(ref tlf); Person Father = new Person() { PersonID = 0, FirstName = "Martin", MiddleName = "", LastName = "Moore", AddressID = 1, PrimaryAddress = primaryAddr, Emails = email, Notes = notes }; personUtil.CreatePersonDB(ref Father); Person Son = new Person() { PersonID = 2, FirstName = "Michael", MiddleName = "", LastName = "Rasmussen", AddressID = 2, TelefonNumbers = null, Notes = null, Emails = null, }; AlternativeAddress altAdr = new AlternativeAddress() // alternavtive address /address 2 reference to alternative AAType { AAID = 0, AAType = "Bolig", AddressID = 1, PersonID = 0, Persons = Son, Address = primaryAddr }; primaryAddr.PersonsPrimary.Add(Son); // reference from address to Person Son.PrimaryAddress = primaryAddr; // reference from person to primary addresss Son.AlternativeAddresses.Add(altAdr); // reference from person to ALT address Son.PrimaryAddress = primaryAddr; personUtil.CreateAlternativeAddressDB(ref altAdr); // Update section personUtil.UpdateAddressDB(ref primaryAddr); personUtil.UpdateEmailDB(ref email); personUtil.UpdateNotesDB(ref notes); personUtil.UpdateTelefonDB(ref tlf); personUtil.UpdatePersonDB(ref Father); primaryAddr.PersonsPrimary.Add(Father); // reference from Alt address to Person // Delete section personUtil.DeletePersonDB(ref Father); personUtil.DeleteTelefonDB(ref tlf); personUtil.DeleteNotesDB(ref notes); personUtil.DeleteEmailDB(ref email); personUtil.DeleteAddressDB(ref primaryAddr); return; }