Ejemplo n.º 1
0
        /// <summary>
        /// Defines the entry point of the application.
        /// </summary>
        /// <param name="args">The arguments.</param>
        static void Main(string[] args)
        {
            Console.WriteLine("Welcome to Address Book using LINQ.");
            AddressBookRepo addressBookRepo = new AddressBookRepo();

            addressBookRepo.ContactList();
            TextFileStream textFile = new TextFileStream();
            int            loop     = 1;

            while (loop == 1)
            {
                Console.WriteLine("Enter your Choice. \n1. Display Address book \n2. Insert Contact \n3. Edit Contact " +
                                  "\n4. Delete Contact \n5. Retrieve contacts by city " +
                                  "\n6. Retrieve Contacts by state \n7. Retrieve count of contacts by city and state " +
                                  "\n8. Display contacts sorted alphabetically for a city. \n9. Display contacts sorted alphabetically" +
                                  " for a state. \n10. Display contacts by sorted zipcode. \n11. Write txt file. \n12. Read txt file. " +
                                  "\n13. Write CSV File. \n14. Read CSV file. \n15. Write Json File. \n16. Read Json File. " +
                                  "\n17. Retrive all contacts from Database. \n18. Exit");
                int choice = Convert.ToInt32(Console.ReadLine());
                switch (choice)
                {
                case 1:
                    addressBookRepo.DisplayAddressBook();
                    break;

                case 2:
                    Contact contact = new Contact();
                    Console.WriteLine("Enter the person details to be added in the address book");
                    Console.WriteLine("First Name");
                    contact.FirstName = Console.ReadLine();
                    Console.WriteLine("Last Name");
                    contact.LastName = Console.ReadLine();
                    Console.WriteLine("Address");
                    contact.Address = Console.ReadLine();
                    Console.WriteLine("City");
                    contact.City = Console.ReadLine();
                    Console.WriteLine("State");
                    contact.State = Console.ReadLine();
                    Console.WriteLine("Zip code");
                    contact.ZipCode = Console.ReadLine();
                    Console.WriteLine("Phone Number");
                    contact.PhoneNumber = Console.ReadLine();
                    Console.WriteLine("Email");
                    contact.Email = Console.ReadLine();
                    addressBookRepo.InsertContacts(contact);
                    break;

                case 3:
                    Contact contacts = new Contact();
                    Console.WriteLine("Enter the person details to be updated in the address book");
                    Console.WriteLine("First Name");
                    string FirstName = Console.ReadLine();
                    Console.WriteLine("Last Name");
                    string LastName = Console.ReadLine();
                    Console.WriteLine("Address");
                    string Address = Console.ReadLine();
                    Console.WriteLine("City");
                    string City = Console.ReadLine();
                    Console.WriteLine("State");
                    string State = Console.ReadLine();
                    Console.WriteLine("Zip code");
                    string ZipCode = Console.ReadLine();
                    Console.WriteLine("Phone Number");
                    string PhoneNumber = Console.ReadLine();
                    Console.WriteLine("Email");
                    string Email = Console.ReadLine();
                    addressBookRepo.EditContact(contacts, FirstName);
                    break;

                case 4:
                    Console.WriteLine("Enter FirstName of contact to be deleted");
                    string name = Console.ReadLine();
                    addressBookRepo.DeleteContact(name);
                    break;

                case 5:
                    Console.WriteLine("Enter City");
                    string city = Console.ReadLine();
                    addressBookRepo.RetrieveContactsByCity(city);
                    break;

                case 6:
                    Console.WriteLine("Enter State");
                    string state = Console.ReadLine();
                    addressBookRepo.RetrieveContactsByState(state);
                    break;

                case 7:
                    addressBookRepo.CountByCityAndState();
                    break;

                case 8:
                    Console.WriteLine("Enter City");
                    string cityName = Console.ReadLine();
                    addressBookRepo.SortContactsAlphabeticalyForACity(cityName);
                    break;

                case 9:
                    Console.WriteLine("Enter State");
                    string stateName = Console.ReadLine();
                    addressBookRepo.SortContactsAlphabeticallyForState(stateName);
                    break;

                case 10:
                    Console.WriteLine("Enter ZipCode");
                    string zipCode = Console.ReadLine();
                    addressBookRepo.SortContactsByZipcode(zipCode);
                    break;

                case 11:
                    textFile.WriteFile(list);
                    break;

                case 12:
                    textFile.ReadFile();
                    break;

                case 13:
                    textFile.WriteCSVFile(list);
                    break;

                case 14:
                    textFile.ReadCSVFile();
                    break;

                case 15:
                    textFile.WriteJSONFile(list);
                    break;

                case 16:
                    textFile.ReadJSONFile();
                    break;

                case 17:
                    addressBookRepo.RetrieveAllContacts();
                    break;

                case 18:
                    loop = 0;
                    break;
                }
            }
        }
Ejemplo n.º 2
0
        /// <summary>
        /// Defines the entry point of the application.
        /// </summary>
        /// <param name="args">The arguments.</param>
        static void Main(string[] args)
        {
            Console.WriteLine("Welocme To AddressBook Using Linq");
            AddressBookRepo addressBookRepo = new AddressBookRepo();
            Contact         contact         = new Contact();

            addressBookRepo.CreateBookTable();
            bool check = true;

            while (check == true)
            {
                Console.WriteLine("Enter Your Choice");
                Console.WriteLine("1 Display");
                Console.WriteLine("2 Add Contact");
                Console.WriteLine("3 Edit Existing Contact");
                Console.WriteLine("4 Delete Contact");
                Console.WriteLine("5 Get Person Belongings By Giving State");
                Console.WriteLine("6 Get Person Belongings By Giving City");
                Console.WriteLine("7 Get Person Count By Giving State");
                Console.WriteLine("8 Get Person Count By Giving City");
                Console.WriteLine("9 Get Person sorted in Alphabetically Order By Giving City");
                Console.WriteLine("10 Get Count by Book Type");
                Console.WriteLine("11 Get Person sorted in Alphabetically Order");
                Console.WriteLine("12 Get Sort Entries in Alphabetically Order By Giving City");
                Console.WriteLine("13 Get Sort Entries in Alphabetically Order By Giving State");
                Console.WriteLine("14 Get Sort Entries in Alphabetically Order By Giving ZipCode");
                Console.WriteLine("15 Exit");
                int choice = Convert.ToInt32(Console.ReadLine());
                switch (choice)
                {
                case 1:
                    addressBookRepo.GetAllRecordsInTable();
                    break;

                case 2:
                    Console.WriteLine("Enter First Name:");
                    contact.FirstName = Console.ReadLine();
                    Console.WriteLine("Enter Last Name:");
                    contact.LastName = Console.ReadLine();
                    Console.WriteLine("Enter Address:");
                    contact.Address = Console.ReadLine();
                    Console.WriteLine("Enter City:");
                    contact.City = Console.ReadLine();
                    Console.WriteLine("Enter State:");
                    contact.State = Console.ReadLine();
                    Console.WriteLine("Enter Zip code:");
                    contact.ZipCode = Console.ReadLine();
                    Console.WriteLine("Enter Phone Number:");
                    contact.PhoneNumber = Console.ReadLine();
                    Console.WriteLine("Enter Email:");
                    contact.Email = Console.ReadLine();
                    addressBookRepo.AddContact(contact);
                    break;

                case 3:
                    Console.WriteLine("Enter First Name: ");
                    contact.FirstName = Console.ReadLine();
                    Console.WriteLine("Enter Last Name: ");
                    contact.LastName = Console.ReadLine();
                    Console.WriteLine("Enter Address: ");
                    contact.Address = Console.ReadLine();
                    Console.WriteLine("Enter City: ");
                    contact.City = Console.ReadLine();
                    Console.WriteLine("Enter State: ");
                    contact.State = Console.ReadLine();
                    Console.WriteLine("Enter Zip code: ");
                    contact.ZipCode = Console.ReadLine();
                    Console.WriteLine("Enter Phone Number: ");
                    contact.PhoneNumber = Console.ReadLine();
                    Console.WriteLine("Enter Email ID: ");
                    contact.Email = Console.ReadLine();
                    addressBookRepo.EditContact(contact);
                    break;

                case 4:
                    Console.WriteLine("Enter First Name: ");
                    contact.FirstName = Console.ReadLine();
                    Console.WriteLine("Enter Last Name: ");
                    contact.LastName = Console.ReadLine();
                    addressBookRepo.DeleteContact(contact);
                    break;

                case 5:
                    Console.WriteLine("Enter State: ");
                    contact.State = Console.ReadLine();
                    addressBookRepo.RetrievePersonDataByUsingState(contact);
                    break;

                case 6:
                    Console.WriteLine("Enter City: ");
                    contact.City = Console.ReadLine();
                    addressBookRepo.RetrievePersonDataByUsingCity(contact);
                    break;

                case 7:
                    addressBookRepo.RetrieveCountByState();
                    break;

                case 8:
                    addressBookRepo.RetrieveCountByCity();
                    break;

                case 9:
                    Console.WriteLine("Enter City: ");
                    contact.City = Console.ReadLine();
                    addressBookRepo.SortPersonNameAlphabetically(contact);
                    break;

                case 10:
                    addressBookRepo.GetCountByABookType();
                    break;

                case 11:
                    addressBookRepo.SortPersonNameAlphabeticallOrder();
                    break;

                case 12:
                    Console.WriteLine("Enter City: ");
                    contact.City = Console.ReadLine();
                    addressBookRepo.SortPersonNameAlphabeticallyByGivingCity(contact);
                    break;

                case 13:
                    Console.WriteLine("Enter State: ");
                    contact.City = Console.ReadLine();
                    addressBookRepo.SortPersonNameAlphabeticallyByGivingState(contact);
                    break;

                case 14:
                    Console.WriteLine("Enter ZiCode: ");
                    contact.City = Console.ReadLine();
                    addressBookRepo.SortPersonNameAlphabeticallyByGivingiZip(contact);
                    break;

                case 15:
                    return;

                default:
                    Console.WriteLine("Enter valid choice between 1 to 15");
                    break;
                }
            }
        }