private static void Main(string[] args) { try { DatabaseUtil.initializeDatabase(); /* TODO: create person objects and put them in the PhoneBook and database * John Smith, (248) 123-4567, 1234 Sand Hill Dr, Royal Oak, MI * Cynthia Smith, (824) 128-8758, 875 Main St, Ann Arbor, MI */ // TODO: print the phone book out to System.out Console.Write("\n\n************All Records in the PhoneBook Table!************\n"); phonebook.GetAll(); // TODO: insert the new person objects into the database Console.Write("************\n\nNew Person Added in the PhoneBook Table !\n"); phonebook.AddPerson(); // TODO: find Cynthia Smith and print out just her entry Console.Write("************\n\n Find the Person in PhoneBook Table !\n"); phonebook.FindPerson("Cynthia", "Smith"); Console.Write("End !"); Console.ReadLine(); } finally { DatabaseUtil.CleanUp(); } }
private static void Main(string[] args) { try{ Console.WriteLine("Creating new DB. Wait..."); var book = new PhoneBook(); book.Initialize(); Console.WriteLine("Done initializing. Adding 2 default persons."); var p = new Person { Name = "John Smith", PhoneNumber = "(248) 123-4567", Address = "1234 Sand Hill Dr, Royal Oak, MI" }; var c = new Person { Name = "Cynthia Smith", PhoneNumber = "(824) 128-8758", Address = "875 Main St, Ann Arbor, MI" }; book.AddPerson(p); book.AddPerson(c); Person[] pers = book.FindAll(); foreach (Person s in pers) { Console.WriteLine(s.Name + ", " + s.Address + ", " + s.PhoneNumber); } Console.WriteLine("Total count: " + pers.Length); Console.WriteLine("Searching for a given person."); Person n = book.FindPerson("Cynthia Smith"); Console.WriteLine("Found: " + n.Name + " " + n.Address + " " + n.PhoneNumber); Console.WriteLine("Adding new person: "); Console.WriteLine("Enter the name, phone, address, separated by comma : "); string entry = Console.ReadLine(); if (entry != null) { string[] entries = entry.Split(','); book.AddPerson(new Person { Name = entries[0], PhoneNumber = entries[1], Address = entries[2] }); } Console.WriteLine("New entry added!"); Console.WriteLine(); pers = book.FindAll(); foreach (Person s in pers) { Console.WriteLine(s.Name + ", " + s.Address + ", " + s.PhoneNumber); } Console.WriteLine("New count: " + pers.Length); Console.ReadLine(); } catch (Exception e) { Console.WriteLine(e.Message); } }
private static void FindAndPrintPerson() { // TODO: find Cynthia Smith and print out just her entry var personFound = _phonebook.FindPerson("Cynthia", "Smith"); Console.WriteLine("\n======TODO: find Cynthia Smith and print out just her entry======"); PrintPerson(personFound); }
public void findPerson() { //Arrange var pBook = new PhoneBook(); //Act var p = pBook.FindPerson("John Smith"); Assert.IsNull(p); }
static void Main(string[] args) { PhoneBook phonebook = new PhoneBook(); try { /* TODO: create person objects and put them in the PhoneBook and database * John Smith, (248) 123-4567, 1234 Sand Hill Dr, Royal Oak, MI * Cynthia Smith, (824) 128-8758, 875 Main St, Ann Arbor, MI */ // The database does not exist so create it DatabaseUtil.initializeDatabase(); // Create person objects Person johnSmith = new Person() { name = "John Smith", address = "1234 Sand Hill Dr, Royaml Oak, MI", phoneNumber = "(248) 123-4567" }; Person cynthiaSmith = new Person() { name = "Cynthia Smith", address = "875 Main St, Ann Arbor, MI", phoneNumber = "(824) 128-8758" }; // Insert the new person objects into the database phonebook.AddPerson(johnSmith); phonebook.AddPerson(cynthiaSmith); // Print the phone book out to System.out foreach (var person in phonebook.GetPeople()) { // Write out list of people to console Console.WriteLine("Name: {0}, Number: {1}, Address: {2}\n", person.name, person.phoneNumber, person.address); } // Find Cynthia Smith and print out just her entry Person cynthia = phonebook.FindPerson("Cynthia", "Smith"); // Print out Cynthias' details to console Console.WriteLine("Name: {0}, Number: {1}, Address: {2}\n", cynthia.name, cynthia.phoneNumber, cynthia.address); } finally { DatabaseUtil.CleanUp(); } }
static void Main(string[] args) { try { Person[] persons = { new Person("John Smith", "(248) 123-4567", "1234 Sand Hill Dr, Royal Oak, MI"), new Person("Cynthia Smith", "(824) 128-8758", "875 Main St, Ann Arbor, MI") }; DatabaseUtil.InitializeDatabase(null); PhoneBook phoneBook = new PhoneBook(); phoneBook.AddPerson(persons[0]); phoneBook.AddPerson(persons[1]); for (int i = 0; i < phoneBook.Length; ++i) { Console.WriteLine(phoneBook[i].GetInfo); } Person p = phoneBook.FindPerson("Cynthia Smith"); Console.WriteLine(p?.GetInfo); Console.ReadLine(); #region Test //Console.ReadLine(); ///* TODO: create person objects and put them in the PhoneBook and database //* John Smith, (248) 123-4567, 1234 Sand Hill Dr, Royal Oak, MI //* Cynthia Smith, (824) 128-8758, 875 Main St, Ann Arbor, MI //*/ //// TODO: print the phone book out to System.out //// TODO: find Cynthia Smith and print out just her entry //// TODO: insert the new person objects into the database #endregion } finally { DatabaseUtil.CleanUp(); } }
static void Main(string[] args) { try { var dbConnection = new SQLiteConnection("Data Source= MyDatabase.sqlite;Version=3;"); dbConnection.Open(); SQLiteCommand command = new SQLiteCommand( "drop table PHONEBOOK", dbConnection); command.ExecuteNonQuery(); DatabaseUtil.InitializeDatabase(); //Add phonebooks to In-memory Phonebook Collection var phoneBook = new PhoneBook(new PersonRepository()); phoneBook.AddPerson(new Person() { Name = "John Smith", Address = "1234 Sand Hill Dr, Royal Oak, MI", PhoneNumber = "(248) 123-4567" }); phoneBook.AddPerson(new Person() { Name = "Cynthia Smith", Address = "875 Main St, Ann Arbor, MI", PhoneNumber = "(824) 128-8758" }); //Print phonebook Console.WriteLine("---------PRINT Phonebook"); Console.WriteLine(phoneBook.ToString()); //get and print cynthia Console.WriteLine("---------PRINT Cynthia"); var person = phoneBook.FindPerson("Cynthia Smith"); Console.WriteLine(person.ToString()); //persist in-memory phonebook collection to DB phoneBook.Persist(); Console.WriteLine("Press Enter to exit"); Console.ReadLine(); } finally { DatabaseUtil.CleanUp(); } }
/// <summary> /// Find Record With Given Name /// </summary> /// <param name="firstName">First Name Of Person</param> /// <param name="lastName">Last Name Of Person</param> private void FindRecordWithGivenName(string firstName, string lastName) { Person person = phonebook.FindPerson(firstName.Trim(), lastName.Trim()); Console.WriteLine(Environment.NewLine); if (person != null && person.address != null) { Console.WriteLine("Found below Record"); Console.WriteLine("Name = {0}, PhoneNumber = {1}, Address = {2}", person.name, person.phoneNumber, person.address); } else { Console.WriteLine("No Matching Record Found"); } }
static void Main(string[] args) { /* TODO: create person objects and put them in the PhoneBook and database * John Smith, (248) 123-4567, 1234 Sand Hill Dr, Royal Oak, MI * Cynthia Smith, (824) 128-8758, 875 Main St, Ann Arbor, MI */ phonebook.AddPerson(new Person("John Smith", "(248) 123-4567", "1234 Sand Hill Dr, Royal Oak, MI")); phonebook.AddPerson(new Person("Cynthia Smith", "(824) 128-8758", "875 Main St, Ann Arbor, MI")); // TODO: print the phone book out to System.out Console.WriteLine("All phonebook entries \n"); foreach (var person in phonebook) { Console.WriteLine(person); } Console.WriteLine("\n"); // TODO: find Cynthia Smith and print out just her entry Console.WriteLine("Cythia's phonebook entry \n"); var cynthia = phonebook.FindPerson("Cynthia", "Smith"); Console.WriteLine(cynthia); try { DatabaseUtil.initializeDatabase(); // TODO: insert the new person objects into the database DatabaseUtil.InsertPeople(phonebook); } finally { DatabaseUtil.CleanUp(); } Console.ReadLine(); }