/// UC 3: Adds the new contact into DB table.
public static void AddNewContactDetails()
{
AddressBookRepository repository = new AddressBookRepository();
AddressBookModel model = new AddressBookModel();
model.FirstName = "Richa";
model.LastName = "Sharma";
model.Address = "Karauli";
model.City = "Karauli";
model.State = "Rajasthan";
model.Zip = 555666;
model.PhoneNumber = 8411563241;
model.EmailId = "*****@*****.**";
model.AddressBookName = "Ritika";
model.AddressBookType = "Friend";
Console.WriteLine(repository.AddDataToTable(model) ? "Record inserted successfully\n" : "Failed");
}
static void Main(string[] args)
{
Console.WriteLine("Welcome to AddressBook System program using ADO.NET");
///Creating Instance object of AddressBookRepository class.
AddressBookRepository repository = new AddressBookRepository();
///UC1 Creating a method for checking for the validity of the connection.
repository.EnsureDataBaseConnection();
/// UC2 Getting all the stored records in the address book service table by fetching all the records
repository.GetAllContact();
/// UC 3: Adds the new contact into DB table.
//AddNewContactDetails();
/// UC 4 Ability to Edit the contactType of the existing contact.
Console.WriteLine(repository.EditContactUsingName("Richa", "Sharma", "Speaker") ? "Update done successfully\n" : "Delete operation failed");
/// UC5 Ability to Deletes the contact with given first name and last name.
Console.WriteLine(repository.DeleteContact("Richa", "Sharma") ? "Deleted Contact successfully\n" : "Update failed");
/// UC6 Retrieves the contacts from a given state or city.
repository.RetrieveContactFromCityOrStateName();
/// UC7 Gets the count of people in a state or city.
GetCountByCityOrState();
}