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"); }