static void Main(string[] args)
{
using (var db = new PersonDBContext())
{
// Create and save a new Blog
Console.Write("Enter a name for a new person: ");
var name = Console.ReadLine();
var primAddr = new PrimaryAddress {
streetAddress = "scrubROad", countryRegion = "aarhus amt", zipCode = 8000, cityName = "aarhus"
};
db.primaryAddress.Add(primAddr);
db.SaveChanges();
var altAddr = new AlternativeAddress {
streetAddress = "kkROad", countryRegion = "randers amt", zipCode = 8600, cityName = "randers"
};
db.alternativeAddress.Add(altAddr);
db.SaveChanges();
var my_email = new Email {
email = "*****@*****.**"
};
db.emailAddress.Add(my_email);
db.SaveChanges();
var primConInf = new PrimaryContactInfo {
phoneNumber = 11223344, company = "telenor"
};
db.primaryContactInfo.Add(primConInf);
db.SaveChanges();
var person = new Person_Class {
fullName = name, type = "Hobo", StateRegisterAddress = "rrr"
};
db.persons.Add(person);
db.primaryAddress.Add(primAddr);
db.alternativeAddress.Add(altAddr);
db.emailAddress.Add(my_email);
db.primaryContactInfo.Add(primConInf);
db.SaveChanges();
// Display all Blogs from the database
var query = from b in db.persons
orderby b.fullName
select b;
Console.WriteLine("All persons in the database:");
foreach (var item in query)
{
Console.WriteLine(item.fullName);
}
}
}
static void Main(string[] args)
{
using (var db = new PersonDBContext())
{
CRUD newCRUD = new CRUD();
if (!db.persons.Any())
{
Program program = new Program();
program.StartDatabase(db);
}
}
}
static void Main(string[] args)
{
using (var db = new PersonDBContext())
{
if (!db.persons.Any())
{
Program program = new Program();
program.StartDatabase(db);
}
// Display all people from the database
Console.WriteLine("All persons in the database:");
var People = from b in db.persons select b;
int counter = 0;
foreach (var person in People)
{
Console.WriteLine($"\n {counter + 1}. person: \n");
counter++;
Console.WriteLine($"Name: {person.fullName} | Relation: { person.personType.pType } \n");
Console.WriteLine("************************");
Console.WriteLine("Addresses:");
foreach (var _address in person.Address)
{
Console.WriteLine($"City: {_address.cityAtAddress.cityName} {_address.cityAtAddress.zipCode}");
Console.WriteLine($"Address: {_address.streetAddress}");
Console.WriteLine($"Region: {_address.countryRegion}");
Console.WriteLine($"AddressType: {_address.addressType.genericType}");
}
Console.WriteLine("\n************************");
Console.WriteLine("ContactInfo:");
foreach (var number in person.ContactInfo)
{
Console.WriteLine($"PhoneType: {number.phonyType.genericType}");
Console.WriteLine($"PhoneNumber: {number.phoneNumber}");
Console.WriteLine($"Company: {number.phoneCompany.genericType}");
}
}
Console.WriteLine("\n");
}
}
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("************************");
}
}
public void StartDatabase(PersonDBContext db)
{
City århus = new City {
cityName = "Århus", zipCode = 8200
};
db.city.Add(århus);
City randers = new City {
cityName = "Randers", zipCode = 8900
};
db.city.Add(randers);
PersonType Brother = new PersonType {
pType = "Brother"
};
db.pType.Add(Brother);
PersonType Friend = new PersonType {
pType = "Friend"
};
db.pType.Add(Friend);
GenericType Home = new GenericType {
genericType = "Home"
};
db.gType.Add(Home);
GenericType TDCCompany = new GenericType {
genericType = "TDC"
};
db.gType.Add(TDCCompany);
GenericType PrivatePhone = new GenericType {
genericType = "Private"
};
db.gType.Add(PrivatePhone);
GenericType Work = new GenericType {
genericType = "Work"
};
db.gType.Add(Work);
GenericType OisterCompany = new GenericType {
genericType = "Oister"
};
db.gType.Add(OisterCompany);
GenericType WorkPhone = new GenericType {
genericType = "Work"
};
db.gType.Add(WorkPhone);
// Add Person "Jens"
Address JensAddress = new Address {
streetAddress = "Randersvej 27b", countryRegion = "Århus amt", addressType = Home, cityAtAddress = århus
};
db.address.Add(JensAddress);
ContactInfo JensPrivatePhone = new ContactInfo {
phoneNumber = 11223344, phonyType = PrivatePhone, phoneCompany = TDCCompany
};
db.contactInfo.Add(JensPrivatePhone);
Email JensEmail = new Email {
email = "*****@*****.**"
};
db.emailAddress.Add(JensEmail);
Note JensNote = new Note {
note = "Jens is my dude"
};
Person_Class Jens = new Person_Class {
fullName = "Jens Petersen", personType = Brother
};
Jens.Address.Add(JensAddress);
Jens.ContactInfo.Add(JensPrivatePhone);
Jens.EmailAddress.Add(JensEmail);
//Jens.note
db.persons.Add(Jens);
// Add Person "Karl"
Address KarlAddress = new Address {
streetAddress = "Sunset Boulevard 33", countryRegion = "Østjylland", addressType = Work, cityAtAddress = randers
};
db.address.Add(JensAddress);
ContactInfo KarlWorkPhone = new ContactInfo {
phoneNumber = 55667788, phonyType = WorkPhone, phoneCompany = OisterCompany
};
db.contactInfo.Add(KarlWorkPhone);
ContactInfo KarlPrivatePhone = new ContactInfo {
phoneNumber = 22222222, phonyType = PrivatePhone, phoneCompany = TDCCompany
};
db.contactInfo.Add(KarlPrivatePhone);
Email KarlEmail = new Email {
email = "*****@*****.**"
};
db.emailAddress.Add(KarlEmail);
Person_Class Karl = new Person_Class {
fullName = "Karl Sørensen", personType = Friend
};
Karl.Address.Add(KarlAddress);
Karl.ContactInfo.Add(KarlWorkPhone);
Karl.ContactInfo.Add(KarlPrivatePhone);
Karl.EmailAddress.Add(KarlEmail);
db.persons.Add(Karl);
db.SaveChanges();
}
