static void Main(string[] args)
{
CRUD myCRUD = new CRUD();
Person p = new Person()
{
PID = 1
};
Person Jens = new Person()
{
fullName = "Jens Jensen", personType = "Friend", Address = null
};
City randers = new City()
{
cityName = "Randers C", zipCode = 8900, countryRegion = "Denmark", addresses = new List <Address>()
};
Address JensAddress = new Address {
streetAddress = "Randersvej 27b", cityAtAddress = randers, peopleAtAddress = Jens
};
//Jens.Address = JensAddress;
randers.addresses = new List <Address>();
randers.addresses.Add(JensAddress);
//JensAddress.peopleAtAddress = new List<Person>();
//JensAddress.peopleAtAddress.Add(Jens);
myCRUD.AddPerson(ref Jens);
myCRUD.AddCity(ref randers);
myCRUD.AddAddress(ref JensAddress);
Jens.Address = JensAddress;
//Email JensEmail = new Email { email = "*****@*****.**" };
//ContactInfo JensPrivatePhone = new ContactInfo { phoneNumber = 11223344, phoneType = "Private", phoneCompany = "TDC" };
//Note JensNote = new Note { note = "Jens is my dude" };
}
public void StartDatabase(PersonDBContext db)
{
Console.WriteLine("Starting database");
CRUD myCRUD = new CRUD();
Person p = new Person()
{
personId = 1
};
Address blankAddress = new Address()
{
addressId = 1
};
Person Jens = new Person()
{
fullName = "Jens Jensen", personType = "Friend", Address = null, EmailAddress = new List <Email>(), ContactInfo = new List <ContactInfo>()
};
Person Otto = new Person()
{
fullName = "Otto Ottossen", personType = "Brother", Address = null
};
City randers = new City()
{
cityName = "Randers C", zipCode = 8900, countryRegion = "Denmark"
};
Address JensAddress = new Address {
streetAddress = "Randersvej 27b", cityAtAddress = randers, personId = new List <Person>()
};
Address JensAAddress = new Address {
streetAddress = "Aarhusvej 2", cityAtAddress = randers, personId = new List <Person>()
};
AlternativeAddress JensAlternativeAddress = new AlternativeAddress {
attachedAddress = JensAAddress, attachedPerson = new List <Person>(), addressType = "Work"
};
Address OttosAddress = new Address {
streetAddress = "Randersvej 10", cityAtAddress = randers, personId = new List <Person>()
};
Email JensEmail = new Email {
email = "*****@*****.**", person = Jens
};
ContactInfo JensContactInfo = new ContactInfo {
phoneNumber = 12345678, phoneCompany = "TDC", phoneType = "Private", person = Jens
};
/*********** ADD JENS TO DB ***********/
Jens.Address = JensAddress;
Jens.EmailAddress.Add(JensEmail);
JensAddress.personId.Add(Jens);
JensAAddress.personId.Add(Jens);
JensAlternativeAddress.attachedPerson.Add(Jens);
JensAlternativeAddress.attachedAddress = JensAAddress;
Jens.AlternativeAddress.Add(JensAlternativeAddress);
Jens.ContactInfo.Add(JensContactInfo);
JensAddress.cityAtAddress = randers;
JensAAddress.cityAtAddress = randers;
// CRUD OPERATIONS ON JENS
// Add operations
myCRUD.AddCity(ref randers);
myCRUD.AddAddress(ref JensAddress);
myCRUD.AddAddress(ref JensAAddress);
myCRUD.AddPerson(ref Jens);
myCRUD.AddEmail(ref JensEmail);
myCRUD.AddAlternativeAddress(ref JensAlternativeAddress);
myCRUD.AddContactInfo(ref JensContactInfo);
// Update operations
myCRUD.UpdatePerson(ref Jens);
JensAddress.streetAddress = "Randersvej 1";
myCRUD.UpdateAddress(ref JensAddress);
JensEmail.email = "*****@*****.**";
myCRUD.UpdateEmail(ref JensEmail);
JensContactInfo.phoneNumber = 55554444;
myCRUD.UpdateContactInfo(ref JensContactInfo);
JensAAddress.streetAddress = "NewAlternativeAddress 15";
myCRUD.UpdateAddress(ref JensAAddress);
JensAlternativeAddress.attachedAddress = JensAAddress;
myCRUD.UpdateAlternativeAddress(ref JensAlternativeAddress);
/*********** ADD OTTO TO DB ***********/
OttosAddress.cityAtAddress = randers;
Otto.Address = OttosAddress;
OttosAddress.cityAtAddress = randers;
myCRUD.AddAddress(ref OttosAddress);
myCRUD.AddPerson(ref Otto);
myCRUD.UpdatePerson(ref Otto);
// Read operations
var personList = myCRUD.GetPersons();
int counter = 0;
foreach (var person in personList)
{
Console.WriteLine($"\n {counter + 1}. person: \n");
counter++;
Console.WriteLine($"Name: {person.fullName} | Relation: { person.personType } \n");
Console.WriteLine("************************");
}
// Delete operations
myCRUD.DeleteAlternativeAddress(ref JensAlternativeAddress);
myCRUD.DeleteAddress(ref JensAAddress);
myCRUD.DeleteAddress(ref JensAddress);
myCRUD.DeleteAddress(ref OttosAddress);
myCRUD.DeleteEmail(ref JensEmail);
myCRUD.DeleteContactInfo(ref JensContactInfo);
myCRUD.DeletePerson(ref Jens);
myCRUD.DeletePerson(ref Otto);
var personList2 = myCRUD.GetPersons();
int counter2 = 0;
foreach (var person in personList2)
{
Console.WriteLine($"\n {counter2 + 1}. person: \n");
counter2++;
Console.WriteLine($"Name: {person.fullName} | Relation: { person.personType } \n");
Console.WriteLine("************************");
}
}
