static void Main(string[] args)
{
Console.WriteLine("Welcome to address book problem ADO.net");
/// Creating an object of AddressBookRepo class
AddressBookRepo addressBookRepo = new AddressBookRepo();
/// Calling the GetAllEntries method from AddressBookRepo class
addressBookRepo.GetAllEntries();
AddressBookModel model = new AddressBookModel
{
FirstName = "Shashank",
LastName = "Singh",
Address = "Techman City",
City = "Mathura",
State = "Uttar Pradesh",
Zip = 281006,
PhoneNo = 8265800789,
Email = "*****@*****.**",
AddressBookName = "Kartikeya",
ContactType = "Friends"
};
Console.WriteLine(addressBookRepo.AddContact(model) ? "Record inserted successfully " : "Failed");
/// Calling the update contact method
addressBookRepo.UpdateContact();
/// Calling the DeleteContact method
addressBookRepo.DeleteContact();
/// Calling the GetPersonByCityOrState method
addressBookRepo.GetPersonByCityOrState();
///Calling the GetSizeByCity method
addressBookRepo.GetSizeByCity();
///Calling the GetSizeByState method
addressBookRepo.GetSizeByState();
}
static void Main(string[] args)
{
Console.WriteLine("Welcome to address book problem ADO.net");
/// Creating an object of AddressBookRepo class
AddressBookRepo addressBookRepo = new AddressBookRepo();
//UC1
addressBookRepo.EnsureDataBaseConnection();
//UC2
addressBookRepo.GetAllEntries();
//UC3
AddressBookModel model = new AddressBookModel();
model.FirstName = "rahul";
model.LastName = "vats";
model.Address = "fatwua";
model.City = "chapra";
model.State = "bihar";
model.Zip = 281051;
model.PhoneNo = 5485200789;
model.Email = "*****@*****.**";
model.AddressBookName = "nikhil";
model.ContactType = "Friends";
Console.WriteLine(addressBookRepo.AddContact(model) ? "Record inserted successfully " : "Failed");
//UC4
addressBookRepo.UpdateContact("nikhil");
//UC5
addressBookRepo.DeleteContact("neha");
//UC6
addressBookRepo.GetPersonByCityOrState();
//UC7
///Calling the GetSizeByCity method
addressBookRepo.GetSizeByCity("kolkata");
//UC7-Calling the GetSizeByState method
addressBookRepo.GetSizeByState("westBengal");
}