static void Main(string[] args)
{
AddressBookRepository repository = new AddressBookRepository();
//UC 16
repository.RetrieveAllContactDetails();
//UC 17
Console.WriteLine(repository.UpdateExistingContactUsingName("Rahul", "Kumar", "Email", "*****@*****.**") ? "Update done" : "Update Failed");
//UC 18
repository.GetContactsAddedInPeriod("2018-01-01", "2020-01-01");
//UC 19
repository.GetNumberOfContactsByCityOrState();
//UC 20
AddressBookModel contactDetails = new AddressBookModel();
contactDetails.FirstName = "Virat";
contactDetails.LastName = "Kohli";
contactDetails.Address = "Chinnaswamy";
contactDetails.City = "Bangalore";
contactDetails.State = "Karnataka";
contactDetails.Zip = 432565;
contactDetails.PhoneNumber = 6787665678;
contactDetails.Email = "*****@*****.**";
contactDetails.DateAdded = Convert.ToDateTime("2019-06-10");
contactDetails.AddressBookName = "BCCI";
contactDetails.ContactType = "CRICKETER";
contactDetails.TypeCode = "CRI";
Console.WriteLine(repository.AddContactDetailsIntoDataBase(contactDetails) ? "Contact added successfully" : "Contact was not added");
//UC 21
AddressBookModel contactDetails1 = new AddressBookModel();
contactDetails1.FirstName = "Rohit";
contactDetails1.LastName = "Sharma";
contactDetails1.Address = "Wankhede";
contactDetails1.City = "Mumbai";
contactDetails1.State = "Maharashtra";
contactDetails1.Zip = 654567;
contactDetails1.PhoneNumber = 3456453345;
contactDetails1.Email = "*****@*****.**";
contactDetails1.DateAdded = Convert.ToDateTime("2019-01-10");
contactDetails1.AddressBookName = "B";
contactDetails1.ContactType = "B";
contactDetails1.TypeCode = "B";
AddressBookModel contactDetails2 = new AddressBookModel();
contactDetails2.FirstName = "MS";
contactDetails2.LastName = "Dhoni";
contactDetails2.Address = "Chidambaram";
contactDetails2.City = "Chennai";
contactDetails2.State = "Tamil Nadu";
contactDetails2.Zip = 546765;
contactDetails2.PhoneNumber = 2345432345;
contactDetails2.Email = "*****@*****.**";
contactDetails2.DateAdded = Convert.ToDateTime("2018-06-10");
contactDetails2.AddressBookName = "A";
contactDetails2.ContactType = "A";
contactDetails2.TypeCode = "A";
List <AddressBookModel> contactList = new List <AddressBookModel>();
contactList.Add(contactDetails1);
contactList.Add(contactDetails2);
repository.AddMultipleContactsUsingThread(contactList);
}