private static void CreatePersonAddedDatabase()
{
/* 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
*/
var person = new Person
{
Name = "John Smith",
PhoneNumber = "(248) 123-4567",
Address = "1234 Sand Hill Dr, Royal Oak, MI"
};
_phonebook.AddPerson(person);
person.Name = "Cynthia Smith";
person.PhoneNumber = "(824) 128-8758";
person.Address = "875 Main St, Ann Arbor, MI";
_phonebook.AddPerson(person);
// TODO: print the phone book out to System.out
var all = _phonebook.GetAll();
Console.WriteLine("======TODO: print the phone book out to System.out======");
foreach (var p in all)
{
PrintPerson(p);
}
}
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);
}
}
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();
}
}
/// <summary>
/// Adds New person details in the database
/// </summary>
public void AddNewPerson()
{
Person p = new Person();
Console.WriteLine("Enter the person name");
p.name = Console.ReadLine();
Console.WriteLine("Enter the person phoneNumber");
p.phoneNumber = Console.ReadLine();
Console.WriteLine("Enter the person address");
p.address = Console.ReadLine();
phonebook.AddPerson(p);
GetAllPersons();
}
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();
}
}
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();
}
}
/// <summary>
/// Add new persons to database
/// </summary>
private void AddNewPersons()
{
/* 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 {
name = "Chris Johnson", phoneNumber = "(321) 231-7876", address = "452 Freeman Drive, Algonac, MI"
});
phonebook.AddPerson(new Person {
name = "Dave Williams", phoneNumber = "(231) 502-1236", address = "285 Huron St, Port Austin, MI"
});
phonebook.AddPerson(new Person {
name = "John Smith", phoneNumber = "(248) 123-4567", address = "1234 Sand Hill Dr, Royal Oak, MI"
});
phonebook.AddPerson(new Person {
name = "Cynthia Smith", phoneNumber = "(824) 128-8758", address = "875 Main St, Ann Arbor, MI"
});
}
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();
}
public void addPerson()
{
//Arrange
var pBook = new PhoneBook();
var person = new Person()
{
Name = "test person"
};
//Act
pBook.AddPerson(person);
Assert.Pass();
}
static void Main(string[] args)
{
var context = new PhoneBookContext();
try
{
DatabaseUtil.initializeDatabase(context);
/* 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
*/
var John = new Person("John", "Smith", "(248) 123 - 4567", "1234 Sand Hill Dr", "Royal Oak", "MI");
var Cynthia = new Person("Cynthia", "Smith", "(824) 128 - 8758", "875 Main St", "Ann Arbor", "MI");
var phoneBook = new PhoneBook(context);
phoneBook.AddPerson(John);
phoneBook.AddPerson(Cynthia);
// TODO: print the phone book out to System.out
new PhoneBookPrinter().Print(phoneBook);
// TODO: find Cynthia Smith and print out just her entry
var cynthiaRecord = phoneBook.Find(m => m.FirstName == "Cynthia" && m.LastName == "Smith")
.FirstOrDefault();
Console.WriteLine();
Console.WriteLine(cynthiaRecord?.ToString());
// TODO: insert the new person objects into the database
Console.ReadLine();
DatabaseUtil.CleanUp(context);
}
finally
{
DatabaseUtil.CleanUp(context);
}
}
static void Main(string[] args)
{
try
{
Console.WriteLine("\nHello, Welcome to Phone Book App! \n");
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
*/
Person objPerson = new Person()
{
name = "John Smith",
phoneNumber = "(248) 123-4567",
address = "1234 Sand Hill Dr, Royal Oak, MI"
};
phonebook.AddPerson(objPerson);
objPerson = new Person()
{
name = "Cynthia Smith",
phoneNumber = "(824) 128-8758",
address = "875 Main St, Ann Arbor, MI"
};
phonebook.AddPerson(objPerson);
// TODO: print the phone book out to System.out
var phoneBookData = phonebook.GetPhoneBook();
if (phoneBookData != null)
{
Console.WriteLine("List of Contacts from Phone Book:");
for (var i = 0; i < phoneBookData.Rows.Count; i++)
{
var contactNum = i + 1;
Console.WriteLine("\n Contact " + contactNum + " : \n Name: " + phoneBookData.Rows[i][0] + "\n Phone: " + phoneBookData.Rows[i][1] + "\n Address: " + phoneBookData.Rows[i][2]);
}
}
// TODO: find Cynthia Smith and print out just her entry
var person = phonebook.findPerson("Cynthia", "Smith");
if (person.name != null)
{
Console.WriteLine("\n Cynthia Smith is available in Phone book and below are the details.");
Console.WriteLine(" Name: " + person.name + "\n Phone: " + person.phoneNumber + "\n Address: " + person.address);
}
else
{
Console.WriteLine("\n Oops!, Cynthia Smith is not available in Phone book.");
}
// TODO: insert the new person objects into the database
Console.WriteLine("\nEnter 1 to add new contact Or any other key to Proceed.");
var input = Console.ReadKey();
if (input.KeyChar.ToString() == "1")
{
AddNewContact();
}
Console.WriteLine("\n ***Thank you, Have a nice day.***");
Console.Read();
}
catch (Exception ex)
{
Console.WriteLine("Encountered as exception while running the process with below message.\n" + ex.Message);
}
finally
{
DatabaseUtil.CleanUp();
}
}
