/// UC 3: Adds the new contact into DB table. public static void AddNewContactDetails() { AddressBookRepository repository = new AddressBookRepository(); AddressBookModel model = new AddressBookModel(); model.FirstName = "Neha"; model.LastName = "Singh"; model.Address = "MANSAROVAR"; model.City = "jaipur"; model.State = "Rajasthan"; model.Zip = 788776; model.PhoneNumber = 887788779; model.EmailId = "*****@*****.**"; model.AddressBookName = "neha"; 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("Neha", "Singh", "Friend") ? "Update done successfully\n" : "Update failed"); /// UC5 Ability to Deletes the contact with given first name and last name. Console.WriteLine(repository.DeleteContact("Neha", "Singh") ? "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(); }