// Merge Command
        public static void MergeCommand(ContactBookLogic contactbooklogic, SQLConnection sql)
        {
            Console.WriteLine("Please enter the index of the contact which merges his location into a second contact.");

            sql.ReadContactsTable();

            bool z = int.TryParse(Console.ReadLine(), out int temp1);

            if (z)
            {
                Console.WriteLine($"Please enter the index of the contact that you want to merge locations bla bla of the contact with index : {temp1} with.\n");

                bool y = int.TryParse(Console.ReadLine(), out int temp2);
                if (y)
                {
                    contactbooklogic.MergeContacts(temp1, temp2, sql);
                }
                else
                {
                    Console.WriteLine("WARNING: Invalid Input!");
                }
            }
            else
            {
                Console.WriteLine("WARNING: Invalid Index!");
            }
        }
        //Add or Get Location Command
        public static Location AddOrGetLocationCommand(ContactBookLogic contactbooklogic, SQLConnection sql, long countLocations)
        {
            bool addressIsCorrectInput  = false;
            bool cityNameIsCorrectInput = false;
            var  address  = "";
            var  cityName = "";

            while (!addressIsCorrectInput)
            {
                Console.WriteLine("\nPlease enter the address of the new contact.");
                address = Console.ReadLine();
                addressIsCorrectInput = InputChecker.NoEmptyInputCheck(address);
            }

            while (!cityNameIsCorrectInput)
            {
                Console.WriteLine("\nPlease enter the cityname of the new contact.");
                cityName = Console.ReadLine();
                cityNameIsCorrectInput = InputChecker.NoEmptyInputCheck(cityName);
            }

            Location location = contactbooklogic.AddOrGetLocation(contactbooklogic, sql, countLocations, address, cityName);

            return(location);
        }
        //only locations
        public void ShowLocations(ContactBookLogic contactbooklogic, SQLConnection sql)
        {
            Console.WriteLine("\nWhat List of locations do you want to display?\n1. All locations\n2. All locations of a specific city\n3. All cities\nType 1, 2 or 3\n");
            var check = Console.ReadLine();

            Console.WriteLine("");

            if (check == "1")
            {
                Console.WriteLine("\nListing all locations:\n");
                List <Location> locationsList = sql.ReadLocationsTable();

                foreach (var loc in locationsList)
                {
                    Console.WriteLine($"{loc.LocationID} {loc.Address} {loc.CityName}, has contact: {loc.HasContact} ");
                }


                Console.WriteLine("");
            }
            else if (check == "2")
            {
                Console.WriteLine("\nWhich city do you want to display the locations from?\nPossible cities are:\n");
                List <string> tempLocationCityList = sql.ShowCitiesOfLocations();
                foreach (string s in tempLocationCityList)
                {
                    Console.WriteLine(s);
                }
                Console.WriteLine("");
                var chosenCity = Console.ReadLine();

                var  CommandText = $"SELECT * FROM Locations l WHERE l.CityName = '{chosenCity}';";
                long count       = sql.ExecuteScalar(CommandText);

                if (count > 0)
                {
                    Console.WriteLine($"\nListing all locations from city: {chosenCity}\n");
                    sql.ShowChosenCityOfLocation(chosenCity);
                    Console.WriteLine("");
                }
                else
                {
                    Console.WriteLine($"\nWARNING: {chosenCity} does not exist in the database\n");
                }
            }
            else if (check == "3")
            {
                Console.WriteLine("\nCities with locations:\n");
                List <string> tempLocationCityList = sql.ShowCitiesOfLocations();
                foreach (string s in tempLocationCityList)
                {
                    Console.WriteLine(s);
                }
            }
            else
            {
                Console.WriteLine("Invalid Input!");
            }
        }
        // Edit Location Command
        public static void EditLocationCommand(ContactBookLogic contactbooklogic, SQLConnection sql, long countLocations)
        {
            Console.WriteLine($"Please enter the index of the location you wish to edit.");
            List <Location> locationsList = sql.ReadLocationsTable();

            foreach (var loc in locationsList)
            {
                Console.WriteLine($"{loc.LocationID} {loc.Address} {loc.CityName}, has contact: {loc.HasContact} ");
            }

            bool z = int.TryParse(Console.ReadLine(), out int inputindex);

            if (z && inputindex <= countLocations && inputindex > 0)
            {
                Console.WriteLine("Please enter the number of what you want to edit.\n1. Address\n2. City\n");
                var c = Console.ReadLine();
                if (c == "1" || c == "2")
                {
                    bool CorrectInput = false;
                    var  newvalue     = "";

                    if (c == "1")
                    {
                        Console.WriteLine($"Please enter the new value for the address.");
                    }
                    else if (c == "2")
                    {
                        Console.WriteLine($"Please enter the new value for the cityname.");
                    }

                    while (!CorrectInput)
                    {
                        newvalue     = Console.ReadLine();
                        CorrectInput = InputChecker.NoEmptyInputCheck(newvalue);
                        //if (CorrectInput)
                        //    break; //TODO: check ob das nötig ist oder ob es ohne break auch geht
                    }
                    contactbooklogic.EditLocation(inputindex, c, sql, newvalue);
                }

                else
                {
                    Console.WriteLine("WARNING: Invalid Input.");
                }
            }
            else
            {
                Console.WriteLine("WARNING: Invalid Index.");
            }
        }
        // Add Contact Command
        public static void AddContactCommand(ContactBookLogic contactbooklogic, SQLConnection sql, long countLocations)
        {
            bool nameIsCorrectInput        = false;
            bool inputIsNumber             = false;
            bool mailAddressIsCorrectInput = false;
            bool genderIsCorrectInput      = false;
            var  name        = "";
            var  mailAddress = "";
            long phoneNumber = 0;
            var  gender      = "";


            while (!nameIsCorrectInput)
            {
                Console.WriteLine("\nPlease enter the Name of the new Contact.");
                name = Console.ReadLine();
                nameIsCorrectInput = InputChecker.NoEmptyInputCheck(name);
            }

            Location location = AddOrGetLocationCommand(contactbooklogic, sql, countLocations);

            while (!inputIsNumber)
            {
                Console.WriteLine("\nPlease enter the phone number for the new Contact");
                inputIsNumber = long.TryParse(Console.ReadLine(), out phoneNumber);
            }

            while (!mailAddressIsCorrectInput)
            {
                Console.WriteLine("\nPlease enter a mailaddress for the new Contact");
                mailAddress = Console.ReadLine();
                mailAddressIsCorrectInput = InputChecker.MailFormatCheck(mailAddress);
            }

            while (!genderIsCorrectInput)
            {
                Console.WriteLine("\nPlease enter the gender for the new Contact ('Male' or 'Female')");
                gender = Console.ReadLine();
                genderIsCorrectInput = InputChecker.GenderCheck(gender);
            }

            bool conWasDupe = contactbooklogic.AddContact(contactbooklogic, sql, countLocations, name, location, phoneNumber, mailAddress, gender);

            if (conWasDupe)
            {
                Console.WriteLine("INFO: Contact was a duplicate and has not been added to the database.");
            }
        }
        //TODOH: hier liste bekommen und ausgabe hier - damit es von SQL connection getrennt ist - überall (vlt mit List<object>?)
        public void ListWanted(ContactBookLogic contactbooklogic, SQLConnection sql, long countContacts, long countLocations)
        {
            Console.WriteLine("\nDo you want a list of 1. only contacts, 2. only locations or 3. both?\nType 1, 2 or 3\n");
            var v = Console.ReadLine();

            if (v == "1")
            {
                if (countContacts > 0)
                {
                    ShowContacts(contactbooklogic, sql);
                }

                else
                {
                    Console.WriteLine("\nWARNING: There are no contacts which could be displayed.\n");
                }
            }
            else if (v == "2")
            {
                if (countLocations > 0)
                {
                    ShowLocations(contactbooklogic, sql);
                }

                else
                {
                    Console.WriteLine("\nWARNING: There are no locations which could be displayed.\n");
                }
            }
            else if (v == "3")
            {
                if (countContacts > 0 || countLocations > 0)
                {
                    ShowBoth(contactbooklogic, sql);
                }

                else
                {
                    Console.WriteLine("\nWARNING: There are neither contacts nor locations which could be displayed.");
                }
            }
            else
            {
                Console.WriteLine("Invalid Input.");
            }
        }
        // Edit Contact Command
        public static void EditContactCommand(ContactBookLogic contactbooklogic, SQLConnection sql, long countContacts)
        {
            Console.WriteLine("\nPlease enter the index of the contact you wish to edit.");
            sql.ReadContactsTable();

            bool correctIndex = int.TryParse(Console.ReadLine(), out int inputindex);

            if (correctIndex && inputindex <= countContacts && inputindex > 0)
            {
                var  newValue = "";
                bool newValueIsCorrectInput = false;
                var  CommandText            = "";
                bool inputIsNumber          = false;
                long phoneNumber            = 0;

                Console.WriteLine("\nPlease enter the number of what you want to edit.\n1. Name\n2. PhoneNumber\n3. MailAddress");
                var c = Console.ReadLine();
                if (c == "1")
                {
                    while (!newValueIsCorrectInput)
                    {
                        Console.WriteLine($"Please enter the new value for the name.");
                        var name = Console.ReadLine();
                        newValueIsCorrectInput = InputChecker.NoEmptyInputCheck(newValue);
                    }

                    CommandText = $"UPDATE contacts SET Name = '{newValue}' WHERE ContactID = {inputindex};";
                    sql.ExecuteNonQuery(CommandText);
                }
                else if (c == "2")
                {
                    while (!inputIsNumber)
                    {
                        Console.WriteLine("\nPlease enter the phone number for the new Contact");
                        inputIsNumber = long.TryParse(Console.ReadLine(), out phoneNumber);
                    }

                    CommandText = $"UPDATE contacts SET phoneNumber = '{phoneNumber}' WHERE ContactID = {inputindex};";
                    sql.ExecuteNonQuery(CommandText);
                }
                else if (c == "3")
                {
                    while (!newValueIsCorrectInput)
                    {
                        Console.WriteLine($"Please enter the new value for the Mailaddress.");
                        var mailAddress = Console.ReadLine();
                        newValueIsCorrectInput = InputChecker.MailFormatCheck(mailAddress);
                    }

                    CommandText = $"UPDATE contacts SET MailAddress = '{newValue}' WHERE ContactID = {inputindex};";
                    sql.ExecuteNonQuery(CommandText);
                }
                else
                {
                    Console.WriteLine("WARNING: Invalid Input.");
                }
            }
            else
            {
                Console.WriteLine("WARNING: Invalid Index.");
            }
        }
        //only contacts
        public void ShowContacts(ContactBookLogic contactbooklogic, SQLConnection sql)
        {
            List <string> tempList = new List <string>();

            Console.WriteLine("\nWhat List of contacts do you want to display?\n1. All contacts\n2. All contacts of a specific city\n3. All cities\n4. All male contacts\n5. All female contacts\nType 1, 2 or 3\n");
            var check = Console.ReadLine();

            if (check == "1")
            {
                Console.WriteLine("\nListing all contacts:\n");
                sql.ReadContactsTable();
                Console.WriteLine("");
            }
            else if (check == "2")
            {
                Console.WriteLine("");
                Console.WriteLine("\nWhich city do you want to display the contacts from?\nPossible cities are:\n");
                tempList = sql.ShowCitiesOfContacts();
                foreach (string s in tempList)
                {
                    Console.WriteLine(s);
                }

                Console.WriteLine("");
                var  chosenCity  = Console.ReadLine();
                var  CommandText = $"SELECT * FROM locations l INNER JOIN contacts c ON c.LocationID = l.LocationID WHERE l.CityName = '{chosenCity}';";
                long count       = sql.ExecuteScalar(CommandText);

                if (count > 0)
                {
                    Console.WriteLine($"\nListing all contacts from city: {chosenCity}\n");
                    sql.ShowChosenCityOfContacts(chosenCity);
                    Console.WriteLine("");
                }
                else
                {
                    Console.WriteLine($"\nWARNING: {chosenCity} does not exist in the database\n");
                }
            }
            else if (check == "3")
            {
                Console.WriteLine("\nCities with contacts:\n");
                tempList = sql.ShowCitiesOfContacts();

                foreach (string s in tempList)
                {
                    Console.WriteLine(s);
                }
            }
            else if (check == "4")
            {
                Console.WriteLine("\nMale contacts:\n");
                var gender = "Male";
                sql.ShowGenderSpecificList(gender);
            }
            else if (check == "5")
            {
                Console.WriteLine("\nFemale contacts:\n");
                var gender = "Female";
                sql.ShowGenderSpecificList(gender);
            }
            else
            {
                Console.WriteLine("\nInvalid input!\n");
            }
        }
        //contacts and locations
        public void ShowBoth(ContactBookLogic contactbooklogic, SQLConnection sql)
        {
            List <Contact> tempList = new List <Contact>();

            Console.WriteLine("\nWhat List do you want to display?\n1. All Contacts and Locations\n2. All contacts and locations of a specific city\n3. All cities\nType 1, 2 or 3\n");
            var check = Console.ReadLine();

            if (check == "1")
            {
                Console.WriteLine("\nListing all contacts and locations...\n");

                Console.WriteLine("Contacts:");
                sql.ReadContactsTable();
                Console.WriteLine("");

                Console.WriteLine("\nLocations:");
                List <Location> locationsList = sql.ReadLocationsTable();

                foreach (var loc in locationsList)
                {
                    if (loc.HasContact == true)
                    {
                        Console.WriteLine($"{loc.LocationID} {loc.Address} {loc.CityName} assigned to a contact ");
                    }
                    else if (loc.HasContact == false)
                    {
                        Console.WriteLine($"{loc.LocationID} {loc.Address} {loc.CityName}");
                    }
                }
                Console.WriteLine("");
            }
            else if (check == "2")
            {
                Console.WriteLine("\nWhich city do you want to display the contacts and locations from?\nPossible cities are:\n");
                List <string> tempLocationCityList = sql.ShowCitiesOfLocations();
                foreach (string s in tempLocationCityList)
                {
                    Console.WriteLine(s);
                }
                Console.WriteLine("");

                var chosenCity = Console.ReadLine();

                var  CommandText = $"SELECT * FROM Locations l WHERE l.CityName = '{chosenCity}';";
                long count       = sql.ExecuteScalar(CommandText);

                if (count > 0)
                {
                    Console.WriteLine($"Showing Contacts and Locations of the city: {chosenCity}");

                    Console.WriteLine("\nContacts:");
                    sql.ShowChosenCityOfContacts(chosenCity);

                    Console.WriteLine("\nLocations:");
                    sql.ShowChosenCityOfLocation(chosenCity);
                }
                else
                {
                    Console.WriteLine($"\nWARNING: {chosenCity} does not exist in the database\n");
                }
            }
            else if (check == "3")
            {
                Console.WriteLine("\nCities with contacts:\n");
                List <string> tempContactCityList = sql.ShowCitiesOfContacts();
                foreach (string s in tempContactCityList)
                {
                    Console.WriteLine(s);
                }

                Console.WriteLine("\nCities with locations:\n");
                List <string> tempLocationCityList = sql.ShowCitiesOfLocations();
                foreach (string s in tempLocationCityList)
                {
                    Console.WriteLine(s);
                }
                Console.WriteLine("");
            }
            else
            {
                Console.WriteLine("Invalid Input.");
            }
        }
示例#10
0
        static void Main()
        {
            //TODOL: Refactoring komplett
            //TODO: Trennung von Input und Logik für WPF
            //TODOL: csv path anpassen + generic?
            //TODO: List 2.2 2.3 3.2 3.3 - Import - Edit - general check again

            ShowConsoleOutput showList         = new ShowConsoleOutput();
            ContactBookLogic  contactbooklogic = new ContactBookLogic();
            CsvReader         reader           = new CsvReader();
            SQLConnection     sql = new SQLConnection();

            while (true)
            {
                Console.WriteLine("\nType 'Add', 'Edit', 'Remove', 'List', 'Quit', 'Help', 'Clear' or 'Import'");

                long countContacts  = sql.GetTableRowCount("contacts");
                long countLocations = sql.GetTableRowCount("locations");

                Console.WriteLine($"There are currently {countContacts} contacts and {countLocations} locations in the database.\n");

                string input = Console.ReadLine();

                // ADD METHOD
                if (input == "Add")
                {
                    Console.WriteLine("\nWhat do you want to add?\n1. Contact\n2. Location\n");
                    input = Console.ReadLine();

                    if (input == "1")
                    {
                        ContactbookConsoleInputControl.AddContactCommand(contactbooklogic, sql, countLocations);
                    }
                    else if (input == "2")
                    {
                        ContactbookConsoleInputControl.AddOrGetLocationCommand(contactbooklogic, sql, countLocations);
                    }
                    else
                    {
                        Console.WriteLine("WARNING: Invalid Input.\n");
                    }
                }
                // EDIT AND MERGE METHODS
                else if (input == "Edit")
                {
                    if (countContacts > 0 || countLocations > 0)
                    {
                        Console.WriteLine("\nWhat do you want to do?\n1. Edit a contact or location\n2. Merge a contact\n");
                        var i = Console.ReadLine();

                        //EDIT
                        //TODO: hier edit refactoren
                        if (i == "1")
                        {
                            Console.WriteLine("\nWhat do you want to edit?\n1. Contact\n2. Location\n");
                            var a = Console.ReadLine();
                            if (a == "1")
                            {
                                if (countContacts > 0)
                                {
                                    ContactbookConsoleInputControl.EditContactCommand(contactbooklogic, sql, countContacts);
                                }
                                else
                                {
                                    Console.WriteLine("\nWARNING: There is no contact that can be edited.\n");
                                }
                            }
                            else if (a == "2")
                            {
                                if (countLocations > 0)
                                {
                                    ContactbookConsoleInputControl.EditLocationCommand(contactbooklogic, sql, countLocations);
                                }
                                else
                                {
                                    Console.WriteLine("\nWARNING: There is no location that can be edited.\n");
                                }
                            }
                            else
                            {
                                Console.WriteLine("WARNING: Invalid Input");
                            }
                        }
                        //MERGE

                        else if (i == "2" && countContacts > 1)
                        {
                            ContactbookConsoleInputControl.MergeCommand(contactbooklogic, sql);
                        }
                        else
                        {
                            Console.WriteLine("\nWARNING: Invalid Input or not enough contacts.");
                        }
                    }
                    else
                    {
                        Console.WriteLine("\nWARNING: You need atleast a contact or a location to edit or merge something.");
                    }
                }

                // REMOVE METHOD
                else if (input == "Remove")
                {
                    if (countContacts > 0 || countLocations > 0)
                    {
                        Console.WriteLine("\nWhat do you want to remove?\n1. Contact\n2. Location\n3. Everything\n");
                        var b = Console.ReadLine();

                        if (b == "1")
                        {
                            if (countContacts > 0)
                            {
                                Console.WriteLine("Please enter the index of the contact you want to remove.");
                                sql.ReadContactsTable();
                                Console.WriteLine("");

                                bool numberCheck = int.TryParse(Console.ReadLine(), out var value);
                                if (numberCheck)
                                {
                                    contactbooklogic.RemoveContact(contactbooklogic, countContacts, sql, value);
                                }
                                else
                                {
                                    Console.WriteLine("\nWARNING: There is no contact that can be removed.\n");
                                }
                            }
                        }
                        else if (b == "2")
                        {
                            if (countLocations > 0)
                            {
                                Console.WriteLine("\nPlease enter the index of the location you want to remove.\n");
                                List <Location> locationsList = sql.ReadLocationsTable();
                                foreach (var loc in locationsList)
                                {
                                    Console.WriteLine($"{loc.LocationID} {loc.Address} {loc.CityName}, has contact: {loc.HasContact} ");
                                }

                                Console.WriteLine("");
                                bool numberCheck = int.TryParse(Console.ReadLine(), out var value);
                                if (numberCheck)
                                {
                                    contactbooklogic.RemoveLocation(contactbooklogic, countLocations, sql, value);
                                }
                                else
                                {
                                    Console.WriteLine("WARNING: Invalid Input");
                                }
                            }
                            else
                            {
                                Console.WriteLine("\nWARNING: There is no location that can be removed.\n");
                            }
                        }
                        else if (b == "3")
                        {
                            if (countContacts > 0 || countLocations > 0)
                            {
                                Console.WriteLine("\nIf you really want to empty the entire database enter 'y' now.\n");
                                var confirmation = Console.ReadLine();
                                if (confirmation == "y")
                                {
                                    contactbooklogic.RemoveEverything(sql);
                                }
                            }
                            else
                            {
                                Console.WriteLine("\nWARNING: There is nothing that can be deleted from the table.\n");
                            }
                        }
                        else
                        {
                            Console.WriteLine("WARNING: Invalid Input.\n");
                        }
                    }
                    else
                    {
                        Console.WriteLine("\nWARNING: There is nothing that can be removed.\n");
                    }
                }
                // LIST METHOD
                else if (input == "List")
                {
                    if (countContacts > 0 || countLocations > 0)
                    {
                        showList.ListWanted(contactbooklogic, sql, countContacts, countLocations);
                    }
                    else
                    {
                        Console.WriteLine("\nWARNING: There is nothing that can be listed.\n");
                    }
                }

                // QUIT METHOD
                else if (input == "Quit")
                {
                    break;
                }

                else if (input == "Clear")
                {
                    Console.Clear();
                }

                // HELP METHOD
                else if (input == "Help")
                {
                    ContactbookConsoleInputControl.HelpCommand();
                }

                //IMPORT METHOD
                else if (input == "Import")
                {
                    Console.WriteLine("Do you want to import 1. testfile.csv or 2. errortestfile.csv?\nType 1 or 2\n");
                    string csvFileName   = "";
                    string fileNameInput = Console.ReadLine();
                    Console.WriteLine("");
                    if (fileNameInput == "1")
                    {
                        csvFileName = "testfile";
                        reader.ImportEntriesFromCsvIntoList(contactbooklogic, csvFileName, sql);
                    }
                    else if (fileNameInput == "2")
                    {
                        csvFileName = "errortestfile";
                        reader.ImportEntriesFromCsvIntoList(contactbooklogic, csvFileName, sql);
                    }
                    else
                    {
                        Console.WriteLine("WARNING: Wrong input.");
                    }
                }
                else
                {
                    Console.WriteLine($"\nWARNING: {input} is not a valid input. \n");
                }
            }
        }