static void Main(string[] args)
{
Console.WriteLine("Welcome to Address book Service");
AddressBookRepo addressBookRepo = new AddressBookRepo();
List <AddressBookModel> listContacts = new List <AddressBookModel>();
listContacts.Add(new AddressBookModel(FirstName: "Rashmi", LastName: "Sollapure", Address: "Hukkeri", City: "Belgaum", State: "Karnataka", Zip: 562974, PhoneNumber: "7223691472", Email: "*****@*****.**", AddedDate: Convert.ToDateTime("2019-05-31 12:00:00 AM")));
listContacts.Add(new AddressBookModel(FirstName: "Sabil", LastName: "Mujawar", Address: "Maula Ali", City: "Vizag", State: "Andhra Pradesh", Zip: 562874, PhoneNumber: "8523691472", Email: "*****@*****.**", AddedDate: Convert.ToDateTime("05 - 02 - 2019 12:00:00 AM")));
listContacts.Add(new AddressBookModel(FirstName: "Zaid", LastName: "Soudagar", Address: "Chikodi", City: "Belgaum", State: "Karnataka", Zip: 479874, PhoneNumber: "8523647472", Email: "*****@*****.**", AddedDate: Convert.ToDateTime("19 - 10 - 2020 12:00:00 AM")));
listContacts.Add(new AddressBookModel(FirstName: "Anusha", LastName: "Adapa", Address: "Athani", City: "Belgaum", State: "Karnataka", Zip: 569823, PhoneNumber: "6523791472", Email: "*****@*****.**", AddedDate: Convert.ToDateTime("15 - 01 - 2018 12:00:00 AM")));
listContacts.Add(new AddressBookModel(FirstName: "Aishwarya", LastName: "Pise", Address: "Hinjewadi", City: "Pune", State: "Maharastra", Zip: 536981, PhoneNumber: "8253691472", Email: "*****@*****.**", AddedDate: Convert.ToDateTime("25 - 07 - 2017 12:00:00 AM")));
listContacts.Add(new AddressBookModel(FirstName: "Sushil", LastName: "Ashtekar", Address: "Kakti", City: "Belgaum", State: "Karnataka", Zip: 569874, PhoneNumber: "7623691472", Email: "*****@*****.**", AddedDate: Convert.ToDateTime("18 - 02 - 2020 12:00:00 AM")));
listContacts.Add(new AddressBookModel(FirstName: "Adnan", LastName: "Darga", Address: "Chinchwad", City: "Pune", State: "Maharastra", Zip: 590016, PhoneNumber: "7583691474", Email: "*****@*****.**", AddedDate: Convert.ToDateTime("10 - 11 - 2018 12:00:00 AM")));
listContacts.Add(new AddressBookModel(FirstName: "Pratik", LastName: "Dharnaik", Address: "Hukkeri", City: "Belgaum", State: "Karnataka", Zip: 590006, PhoneNumber: "7223691442", Email: "*****@*****.**", AddedDate: Convert.ToDateTime("31 - 12 - 2019 12:00:00 AM")));
addressBookRepo.AddContactToDbUsingThreads(listContacts);
}
static void Main(string[] args)
{
AddressBookRepo addressBookRepo = new AddressBookRepo();
AddressBookModel addressBookModel = new AddressBookModel();
//addressBookRepo.GetAllContactTable("Contact");
addressBookRepo.GetAllDataOfContactBookName("Contact_BookName");
addressBookRepo.GetAllDataOfContactType("Contact_Type");
addressBookRepo.UpdateContactTable("PersonId =3");
addressBookRepo.RetriveContactInGivenDateRange();
addressBookRepo.RetriveContactInGivenCity();
addressBookRepo.RetriveContactInGivenState();
addressBookModel.firstName = "kalyan";
addressBookModel.lastName = "Goud";
addressBookModel.Address = "sriramnager";
addressBookModel.City = "Nlg";
addressBookModel.State = "TS";
addressBookModel.zip = "508001";
addressBookModel.PhoneNumber = "7732063720";
addressBookModel.ContactTypeId = 3;
addressBookRepo.AddContact(addressBookModel);
}