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