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;
}