static void Main(string[] args) { SqlConnection connect = null; try { // Sql command and connectString Authentication, connection string command = "SELECT COUNT(*) FROM PHONE"; string conString = "Data Source=revature-cuny-jace-server.database.windows.net;Initial Catalog=Week2DB;Persist Security Info=True;User ID=jacewill963;Password=Khunta96#"; connect = new SqlConnection(conString); //1. Open connection connect.Open(); //2. SQL Command SqlCommand sqlCommand = new SqlCommand(command, connect); //3. Execute query SqlDataReader data = sqlCommand.ExecuteReader(); int phoneCheck = 0; Phone myPhone = new Phone(); while (data.Read()) { phoneCheck = (int)data[0]; } connect.Close(); //Check if phone data exists if (phoneCheck == 0) { //if data doesn't exist ask use for phone information Console.WriteLine(":::::New Phone Creation:::::"); Console.WriteLine(); Console.WriteLine("First Name*:"); myPhone.Fname = Console.ReadLine(); myPhone.PhoneName = myPhone.Fname + "'s Phone"; Console.WriteLine("Last Name (Optional):"); myPhone.Lname = Console.ReadLine(); Console.WriteLine("Email (Optional):"); myPhone.Email = Console.ReadLine(); Console.WriteLine("Phone Number*:"); myPhone.PhoneNumber = Convert.ToInt64(Console.ReadLine()); //insert into database using ExecuteNonQuery(). ConnectToDB(connect, command, sqlCommand, myPhone, null, null, "INSERT_PHONE"); } else { ConnectToDB(connect, command, sqlCommand, myPhone, null, null, "READ_PHONE"); } //Declare lists to store Addresses and Countries List <Address> AddList = new List <Address>(); List <Country> CtryList = new List <Country>(); //Load Contacts ConnectToDB(connect, command, sqlCommand, myPhone, AddList, CtryList, "READ_CONTACTS"); //Displa Main menu bool display = true; string currDisplay = "main"; string mainMenu = ":::::Main Menu:::::" + System.Environment.NewLine + "(1) Manage Contacts" + System.Environment.NewLine + "(2) Phone Logs" + System.Environment.NewLine + "(3) Factory Reset" + System.Environment.NewLine + "(4) Turn Off" + System.Environment.NewLine + ":::::Main Menu:::::"; string currMenu = mainMenu; string menuSel; bool redisplay = false; int result; while (display == true && currDisplay != null) { Console.Clear(); Console.WriteLine(currMenu); //Console.WriteLine(currDisplay); menuSel = Console.ReadLine(); if (redisplay) { switch (menuSel) { case "1": currMenu = mainMenu; currDisplay = "main"; break; case "2": display = false; break; default: break; } redisplay = false; continue; } switch (currDisplay) { case "main": { switch (menuSel) { case "1": currMenu = ":::::Manage Contacts:::::" + System.Environment.NewLine + "(1) View Contacts" + System.Environment.NewLine + "(2) Add Contacts" + System.Environment.NewLine + "(3) Update Contact" + System.Environment.NewLine + "(4) Delete Contact" + System.Environment.NewLine + "(5) Cancel" + System.Environment.NewLine + ":::::Manage Contacts:::::"; currDisplay = "contacts"; continue; case "2": currMenu = ":::::Phone Logs:::::" + System.Environment.NewLine + "(1) View Phone Logs" + System.Environment.NewLine + "(2) Delete Phone Log Entry" + System.Environment.NewLine + "(3) Clear Phone Logs" + System.Environment.NewLine + "(4) Cancel" + System.Environment.NewLine + ":::::Phone Logs:::::"; currDisplay = "phonelogs"; continue; case "3": currMenu = ":::::Factory Reset:::::" + System.Environment.NewLine + "(1) Reset Phone to Factory Settings" + System.Environment.NewLine + "(2) Cancel" + System.Environment.NewLine + ":::::Factory Reset:::::"; currDisplay = "reset"; continue; case "4": currMenu = ":::::Shut Down:::::" + System.Environment.NewLine + "(1) Are you sure you want to shut down?" + System.Environment.NewLine + "(2) Cancel" + System.Environment.NewLine + ":::::Shut Down:::::"; continue; default: currMenu += "\n \nSelection entered wasn't valid, please select options 1-4."; continue; } } case "contacts": { /* *":::::Manage Contacts:::::" + System.Environment.NewLine + * "(1) View Contacts" + System.Environment.NewLine + * "(2) Add Contacts" + System.Environment.NewLine + * "(3) Update Contact" + System.Environment.NewLine + * "(4) Delete Contact" + System.Environment.NewLine + * "(5) Cancel" + System.Environment.NewLine + * ":::::Manage Contacts:::::"; */ bool reDisplayList; switch (menuSel) { case "1": // Update Contact currMenu = ":::::View Contact::::: \n(1) View All Contacts \n(2) Search Contacts \n(3) Cancel \n:::::View Contact:::::"; currDisplay = "view-contacts"; continue; case "2": //Add Contact Console.Clear(); Console.WriteLine(":::::Add Contact:::::"); Console.WriteLine(); string fname, lname, gender, state, city, countryName, addressSt; int age, zip, countryCode, addressID = 0, countryID = 0; long phoneNum; Console.WriteLine("First Name:"); fname = Console.ReadLine(); Console.WriteLine("Last Name:"); lname = Console.ReadLine(); Console.WriteLine("Gender (Male , Female):"); gender = Console.ReadLine(); Console.WriteLine("Phone Number:"); phoneNum = Convert.ToInt64(Console.ReadLine()); Console.WriteLine("Address:"); addressSt = Console.ReadLine(); Console.WriteLine("State:"); state = Console.ReadLine(); Console.WriteLine("City:"); city = Console.ReadLine(); Console.WriteLine("Age:"); age = Convert.ToInt32(Console.ReadLine()); Console.WriteLine("Zip Code:"); zip = Convert.ToInt32(Console.ReadLine()); Console.WriteLine("Country:"); countryName = Console.ReadLine(); Console.WriteLine("Country Code:"); countryCode = Convert.ToInt32(Console.ReadLine()); Console.WriteLine("Save Contact?: (1) Save, (2) Cancel"); result = Convert.ToInt16(Console.ReadLine()); if (result == 1) { //connect.Open(); Country c = null; bool storeData = true; foreach (var item in CtryList) { if (Convert.ToString(item.CountryName).ToLower() == countryName.ToLower()) { c = item; storeData = false; } } if (storeData) { c = new Country(); c.CountryName = countryName; c.CountryCode = countryCode; //=============================================== //DATA ACCESS METHOD CountryDA.insert(c); //=============================================== CtryList.Add(c); } connect.Open(); Address a = new Address(addressSt, city, state, zip, c.CountryID, c); command = $"INSERT INTO Address (ADDRESS, CITY, STATE, ZIP_CODE, COUNTRY_ID) " + $"VALUES (@address, @city, @state, @zip, @countryID)"; using (SqlDataAdapter dataAdapter = new SqlDataAdapter()) { using (sqlCommand = new SqlCommand(command, connect)) { sqlCommand.Parameters.AddWithValue("@address", a.AddressST); sqlCommand.Parameters.AddWithValue("@city", a.City); sqlCommand.Parameters.AddWithValue("@state", a.State); sqlCommand.Parameters.AddWithValue("@zip", a.ZipCode); sqlCommand.Parameters.AddWithValue("@countryID", a.CountryID); sqlCommand.ExecuteNonQuery(); } }; command = "SELECT ADDRESS_ID FROM ADDRESS " + $"WHERE ADDRESS = '{a.AddressST}' AND CITY = '{a.City}'"; using (SqlCommand cmd = new SqlCommand(command, connect)) { using (data = cmd.ExecuteReader()) { while (data.Read()) { a.AddressID = (int)data[0]; } } } AddList.Add(a); Contact con = new Contact(fname, lname, age, gender, a.AddressID, phoneNum, a); ContactDA.insert(con); /*insert into database using ExecuteNonQuery(). * command = $"INSERT INTO dbo.Contacts (FIRST_NAME, LAST_NAME, AGE, GENDER, ADDRESS_ID, PHONE_NUMBER) " + * $"VALUES (@firstName, @lastName, @age, @gender, @addressID, @phoneNumber)"; * using (SqlDataAdapter dataAdapter = new SqlDataAdapter()) * { * using (sqlCommand = new SqlCommand(command, connect)) * { * sqlCommand.Parameters.AddWithValue("@firstName", con.FName); * sqlCommand.Parameters.AddWithValue("@lastName", con.LName); * sqlCommand.Parameters.AddWithValue("@age", con.Age); * sqlCommand.Parameters.AddWithValue("@gender", con.Gender); * sqlCommand.Parameters.AddWithValue("@addressID", con.AddressID); * sqlCommand.Parameters.AddWithValue("@phoneNumber", con.PhoneNumber); * sqlCommand.ExecuteNonQuery(); * } * }; * command = $"SELECT Contact_ID FROM Contacts WHERE PHONE_NUMBER = {con.PhoneNumber};"; * using (SqlCommand cmd = new SqlCommand(command, connect)) * { * using (data = cmd.ExecuteReader()) * { * while (data.Read()) * { * con.ContactId = (int)data[0]; * } * } * } * connect.Close(); */ myPhone.contactList.Add(con); currMenu = mainMenu + "\n \n Contact Added!"; currDisplay = "main"; redisplay = true; } else { currMenu = mainMenu; currDisplay = "main"; } continue; case "3": //Update Contacts int contactID = 0; if (myPhone.contactList.Count == 0) { currMenu = mainMenu + "There are no Contacts to Update.\n"; currDisplay = "main"; continue; } Console.Clear(); currMenu = ":::::Update Contact::::: \n Search for a contact to edit by First name or Last name"; reDisplayList = true; while (reDisplayList) { Console.Clear(); Console.WriteLine(currMenu); string search = Console.ReadLine(); var searchQuery = from elements in myPhone.contactList where search.Equals(elements.FName, StringComparison.InvariantCultureIgnoreCase) || search.Equals(elements.LName, StringComparison.InvariantCultureIgnoreCase) select elements; if (searchQuery.Count() == 0) { currMenu += "\n \nThe Search returned no results please try again"; continue; } foreach (var contact in searchQuery) { currMenu += System.Environment.NewLine + contact.displayContact(AddList, CtryList); } reDisplayList = false; } Console.Clear(); reDisplayList = true; while (reDisplayList) { currMenu += "Please enter the Contact ID of the contact to update."; Console.WriteLine(currMenu); if (int.TryParse(Console.ReadLine(), out contactID)) { Console.WriteLine(contactID); reDisplayList = false; break; } else { currMenu += "\nPlease enter only numeric values for Contact ID.\n"; continue; } } currMenu += "\n \nWhat would you like to update? Press (12) to Cancel \n(1) First Name \n(2) Last Name \n(3) Gender \n(4) Address \n(5) State \n(6) City \n(7) Country \n(8) Age \n(9) Zip Code \n(10) Country Code \n(11) Phone Number"; var updateCol = ""; var updateElement = new Contact(); foreach (var item in myPhone.contactList) { if (item.ContactId == contactID) { updateElement = item; break; } } reDisplayList = true; while (reDisplayList) { Console.Clear(); Console.WriteLine(currMenu); string sel = Console.ReadLine(); string updateResult = ""; switch (sel) { case "1": Console.Write("First Name: "); updateCol = "FIRST_NAME"; break; case "2": Console.Write("Last Name: "); updateCol = "LAST_NAME"; break; case "3": Console.Write("Gender: "); updateCol = "GENDER"; break; case "4": Console.Write("Addres: "); updateCol = "ADDRESS"; break; case "5": Console.Write("State: "); updateCol = "STATE"; break; case "6": Console.Write("City: "); updateCol = "CITY"; break; case "7": Console.Write("Country: "); updateCol = "COUNTRY_NAME"; break; case "8": Console.Write("Age: "); updateCol = "AGE"; break; case "9": Console.Write("Zip Code: "); updateCol = "ZIP_CODE"; break; case "10": Console.Write("Country Code: "); updateCol = "COUNTRY_CODE"; break; case "11": Console.Write("Phone Number: "); updateCol = "PHONE_NUMBER"; break; case "12": currMenu = mainMenu; currDisplay = "main"; reDisplayList = false; continue; default: currMenu += "\n \nSelection entered wasn't valid, please select options 1-11 or 12 to Cancel"; continue; } updateResult = Console.ReadLine(); if (updateCol == "COUNTRY_NAME" || updateCol == "COUNTRY_CODE") { command = $"UPDATE dbo.Country " + $"SET {updateCol} = @{updateCol} " + $"WHERE COUNTRY_ID = {updateElement.Address.Country.CountryID}"; } else if (updateCol == "ADDRESS" || updateCol == "CITY" || updateCol == "STATE" || updateCol == "ZIP_CODE") { command = $"UPDATE dbo.Address " + $"SET {updateCol} = @{updateCol} " + $"WHERE ADDRESS_ID = {updateElement.Address.AddressID}"; } else { command = $"UPDATE dbo.Contacts " + $"SET {updateCol} = @{updateCol} " + $"WHERE CONTACT_ID = {updateElement.ContactId}"; } using (SqlDataAdapter dataAdapter = new SqlDataAdapter()) { connect.Open(); using (sqlCommand = new SqlCommand(command, connect)) { if (updateCol.Equals("AGE") || updateCol == "ZIP_CODE" || updateCol == "COUNTRY_CODE") { sqlCommand.Parameters.AddWithValue($"@{updateCol}", Convert.ToInt32(updateResult)); } else if (updateCol == "PHONE_NUMBER") { sqlCommand.Parameters.AddWithValue($"@{updateCol}", Convert.ToInt64(updateResult)); } else { sqlCommand.Parameters.AddWithValue($"@{updateCol}", updateResult); } sqlCommand.ExecuteNonQuery(); } connect.Close(); }; ConnectToDB(connect, command, sqlCommand, myPhone, AddList, CtryList, "READ_CONTACTS"); Console.WriteLine("Contact Successfully Updated! Press (1) to continue Press (2) to Cancel"); string continueUpdate = Console.ReadLine(); if (continueUpdate == "1") { continue; } else { reDisplayList = false; currMenu = mainMenu + "\nContact Successfully Updated!"; currDisplay = "main"; continue; } } break; case "4": //Delete Contact if (myPhone.contactList.Count == 0) { currMenu = mainMenu + "There are no Contacts to Delete.\n"; currDisplay = "main"; continue; } redisplay = true; while (redisplay) { currMenu = ":::::Delete Contact:::::\n"; foreach (Contact contact in myPhone.contactList) { currMenu += contact.displayContact(AddList, CtryList) + System.Environment.NewLine; } currMenu += "\nSelect a record to Delete by Contact ID:"; reDisplayList = true; Contact delContact = new Contact(); while (reDisplayList) { Console.Clear(); Console.WriteLine(currMenu); if (int.TryParse(Console.ReadLine(), out contactID)) { foreach (var contact in myPhone.contactList) { if (contact.ContactId == contactID) { delContact = contact; reDisplayList = false; break; } } currMenu += "\nThat Contact ID wasn't found please try again.\n"; continue; } else { currMenu += "\nPlease enter only numeric values for Contact ID.\n"; continue; } } command = $"DELETE FROM dbo.Contacts " + $"WHERE CONTACT_ID = @contactID"; using (SqlDataAdapter dataAdapter = new SqlDataAdapter()) { connect.Open(); using (sqlCommand = new SqlCommand(command, connect)) { sqlCommand.Parameters.AddWithValue("@contactID", delContact.ContactId); sqlCommand.ExecuteNonQuery(); } connect.Close(); }; myPhone.contactList.Remove(delContact); redisplay = true; while (redisplay) { Console.WriteLine("Contact Deleted Press (1) to Continue (2) to Cancel"); if (int.TryParse(Console.ReadLine(), out result)) { if (result == 1) { break; } else if (result == 2) { currMenu = mainMenu; currDisplay = "main"; redisplay = false; break; } else { Console.WriteLine("\nInvalid Entry try again.\n"); continue; } } else { currMenu += "\nPlease enter only numeric values for Contact ID.\n"; continue; } } } break; case "5": currMenu = mainMenu; currDisplay = "main"; continue; default: currMenu += "\n \nSelection entered wasn't valid, please select options 1-5."; continue; } continue; } case "view-contacts": { switch (menuSel) { case "1": if (myPhone.contactList.Count == 0) { currMenu += System.Environment.NewLine + "No Contacts Saved to Display"; currDisplay = "main"; continue; } Console.Clear(); currMenu = ":::::View All Contacts::::: \n"; foreach (Contact contact in myPhone.contactList) { currMenu += contact.displayContact(AddList, CtryList) + System.Environment.NewLine; } currMenu += "Press (1) to return to Main Menu, Press (2) to close app."; redisplay = true; continue; case "2": Console.WriteLine("Search contacts."); string search = Console.ReadLine(); var searchQuery = from elements in myPhone.contactList where search.Equals(elements.FName, StringComparison.InvariantCultureIgnoreCase) || search.Equals(elements.LName, StringComparison.InvariantCultureIgnoreCase) select elements; currMenu = ":::::Search Contacts::::: \n"; foreach (var contact in searchQuery) { currMenu += contact.displayContact(AddList, CtryList) + System.Environment.NewLine; } currMenu += "Press (1) to return to Main Menu, Press (2) to close app."; redisplay = true; continue; case "3": currMenu = mainMenu; currDisplay = "main"; continue; default: break; } break; } } } } catch (Exception ex) { Console.WriteLine(ex.Message); Console.ReadLine(); } finally { connect.Close(); } }
public static void ConnectToDB(SqlConnection connect, string command, SqlCommand sqlCommand, Phone myPhone, List <Address> addList, List <Country> ctryList, string cmd) { switch (cmd) { case "INSERT_PHONE": command = $"INSERT INTO Phone " + "VALUES (@phoneName, @firstName, @lastName, @phoneNumber, @email);"; using (SqlDataAdapter dataAdapter = new SqlDataAdapter()) { connect.Open(); using (sqlCommand = new SqlCommand(command, connect)) { //myPhone = (Phone)myPhone; sqlCommand.Parameters.AddWithValue("@phoneName", myPhone.PhoneName); sqlCommand.Parameters.AddWithValue("@firstName", myPhone.Fname); sqlCommand.Parameters.AddWithValue("@lastName", myPhone.Lname); sqlCommand.Parameters.AddWithValue("@phoneNumber", myPhone.PhoneNumber); sqlCommand.Parameters.AddWithValue("@email", myPhone.Email); sqlCommand.ExecuteNonQuery(); } }; connect.Close(); break; case "READ_PHONE": //connect = new SqlConnection(conString); connect.Open(); command = "SELECT * FROM PHONE"; sqlCommand = new SqlCommand(command, connect); SqlDataReader data = sqlCommand.ExecuteReader(); while (data.Read()) { myPhone.PhoneName = (string)data[0]; myPhone.Fname = (string)data[1]; myPhone.Lname = (string)data[2]; myPhone.PhoneNumber = (long)data[3]; myPhone.Email = (string)data[4]; } connect.Close(); break; case "READ_CONTACTS": CountryDA.read(ctryList); /*connect.Open(); * command = "SELECT * FROM COUNTRY"; * sqlCommand = new SqlCommand(command, connect); * data = sqlCommand.ExecuteReader(); * ctryList.RemoveAll(contact => contact.CountryID >= 0); * while (data.Read()) * { * Country country = new Country(); * country.CountryID = (int)data[0]; * country.CountryName = (string)data[1]; * country.CountryCode = (int)data[2]; * * ctryList.Add(country); * } * connect.Close();*/ AddressDA.read(addList, ctryList); /*connect.Open(); * command = "SELECT * FROM ADDRESS"; * sqlCommand = new SqlCommand(command, connect); * data = sqlCommand.ExecuteReader(); * addList.RemoveAll(address => address.AddressID >= 0); * while (data.Read()) * { * Address address = null; * foreach (var item in ctryList) * { * if(item.CountryID == (int)data[5]) * { * address = new Address( * (string)data[1], * (string)data[2], * (string)data[3], * (int)data[4], * (int)data[5], * item); * } * } * address.AddressID = (int)data[0]; * * addList.Add(address); * } * connect.Close();*/ myPhone.contactList = ContactDA.read(addList); /*connect.Open(); * command = "SELECT * FROM CONTACTS"; * sqlCommand = new SqlCommand(command, connect); * data = sqlCommand.ExecuteReader(); * myPhone.contactList = new List<Contact>(); * while (data.Read()) * { * Contact contact = null; * foreach (var item in addList) * { * if (item.AddressID == (int)data[5]) * { * contact = new Contact(item); * } * } * contact.ContactId = (int)data[0]; * contact.FName = (string)data[1]; * contact.LName = (string)data[2]; * contact.Age = (int)data[3]; * contact.Gender = (string)data[4]; * contact.AddressID = (int)data[5]; * contact.PhoneNumber = (long)data[6]; * * myPhone.contactList.Add(contact); * } * connect.Close();*/ break; default: break; } }
static void Main(string[] args) { //SqlConnection connect = null; try { Phone myPhone = new Phone(); bool phoneCheck = myPhone.read(); //Check if phone data exists if (phoneCheck) { //if data doesn't exist ask use for phone information Console.WriteLine(":::::New Phone Creation:::::"); Console.WriteLine(); Console.WriteLine("First Name*:"); myPhone.Fname = Console.ReadLine(); myPhone.PhoneName = myPhone.Fname + "'s Phone"; Console.WriteLine("Last Name (Optional):"); myPhone.Lname = Console.ReadLine(); Console.WriteLine("Email (Optional):"); myPhone.Email = Console.ReadLine(); Console.WriteLine("Phone Number*:"); myPhone.PhoneNumber = Convert.ToInt64(Console.ReadLine()); //insert into database using ExecuteNonQuery(). myPhone.insert(); } //Declare lists to store Addresses and Countries //Load Contacts myPhone.contactList = ContactDA.read(); //ConnectToDB(myPhone, AddList, CtryList, "READ_CONTACTS"); //Displa Main menu bool display = true; string currDisplay = "main"; string mainMenu = ":::::Main Menu:::::" + System.Environment.NewLine + "(1) Manage Contacts" + System.Environment.NewLine + "(2) Phone Logs" + System.Environment.NewLine + "(3) Factory Reset" + System.Environment.NewLine + "(4) Turn Off" + System.Environment.NewLine + ":::::Main Menu:::::"; string currMenu = mainMenu; string menuSel; bool redisplay = false; int result; while (display == true && currDisplay != null) { Console.Clear(); Console.WriteLine(currMenu); //Console.WriteLine(currDisplay); menuSel = Console.ReadLine(); if (redisplay) { switch (menuSel) { case "1": currMenu = mainMenu; currDisplay = "main"; break; case "2": display = false; break; default: break; } redisplay = false; continue; } switch (currDisplay) { case "main": { switch (menuSel) { case "1": currMenu = ":::::Manage Contacts:::::" + System.Environment.NewLine + "(1) View Contacts" + System.Environment.NewLine + "(2) Add Contacts" + System.Environment.NewLine + "(3) Update Contact" + System.Environment.NewLine + "(4) Delete Contact" + System.Environment.NewLine + "(5) Cancel" + System.Environment.NewLine + ":::::Manage Contacts:::::"; currDisplay = "contacts"; continue; case "2": currMenu = ":::::Phone Logs:::::" + System.Environment.NewLine + "(1) View Phone Logs" + System.Environment.NewLine + "(2) Delete Phone Log Entry" + System.Environment.NewLine + "(3) Clear Phone Logs" + System.Environment.NewLine + "(4) Cancel" + System.Environment.NewLine + ":::::Phone Logs:::::"; currDisplay = "phonelogs"; continue; case "3": currMenu = ":::::Factory Reset:::::" + System.Environment.NewLine + "(1) Reset Phone to Factory Settings" + System.Environment.NewLine + "(2) Cancel" + System.Environment.NewLine + ":::::Factory Reset:::::"; currDisplay = "reset"; continue; case "4": currMenu = ":::::Shut Down:::::" + System.Environment.NewLine + "(1) Are you sure you want to shut down?" + System.Environment.NewLine + "(2) Cancel" + System.Environment.NewLine + ":::::Shut Down:::::"; continue; default: currMenu += "\n \nSelection entered wasn't valid, please select options 1-4."; continue; } } case "contacts": { /* *":::::Manage Contacts:::::" + System.Environment.NewLine + * "(1) View Contacts" + System.Environment.NewLine + * "(2) Add Contacts" + System.Environment.NewLine + * "(3) Update Contact" + System.Environment.NewLine + * "(4) Delete Contact" + System.Environment.NewLine + * "(5) Cancel" + System.Environment.NewLine + * ":::::Manage Contacts:::::"; */ bool reDisplayList; switch (menuSel) { case "1": // Update Contact currMenu = ":::::View Contact::::: \n(1) View All Contacts \n(2) Search Contacts \n(3) Cancel \n:::::View Contact:::::"; currDisplay = "view-contacts"; continue; case "2": //Add Contact Console.Clear(); Console.WriteLine(":::::Add Contact:::::"); Console.WriteLine(); string fname, lname, gender, state, city, countryName, addressSt; int age, zip, countryCode, addressID = 0, countryID = 0; long phoneNum; Console.WriteLine("First Name:"); fname = Console.ReadLine(); Console.WriteLine("Last Name:"); lname = Console.ReadLine(); Console.WriteLine("Gender (Male , Female):"); gender = Console.ReadLine(); Console.WriteLine("Phone Number:"); phoneNum = Convert.ToInt64(Console.ReadLine()); Console.WriteLine("Address:"); addressSt = Console.ReadLine(); Console.WriteLine("State:"); state = Console.ReadLine(); Console.WriteLine("City:"); city = Console.ReadLine(); Console.WriteLine("Age:"); age = Convert.ToInt32(Console.ReadLine()); Console.WriteLine("Zip Code:"); zip = Convert.ToInt32(Console.ReadLine()); Console.WriteLine("Country:"); countryName = Console.ReadLine(); Console.WriteLine("Country Code:"); countryCode = Convert.ToInt32(Console.ReadLine()); Console.WriteLine("Save Contact?: (1) Save, (2) Cancel"); result = Convert.ToInt16(Console.ReadLine()); if (result == 1) { //connect.Open(); Country c = null; bool storeData = true; foreach (var item in CountryDA.CtryList) { if (Convert.ToString(item.CountryName).ToLower() == countryName.ToLower()) { c = item; storeData = false; } } if (storeData) { c = new Country(); c.CountryName = countryName; c.CountryCode = countryCode; //=============================================== //DATA ACCESS METHOD CountryDA.insert(c); //=============================================== } Address a = new Address(addressSt, city, state, zip, c.CountryID, c); AddressDA.insert(a); Contact con = new Contact(fname, lname, age, gender, a.AddressID, phoneNum, a); ContactDA.insert(con); myPhone.contactList.Add(con); currMenu = mainMenu + "\n \n Contact Added!"; currDisplay = "main"; redisplay = true; } else { currMenu = mainMenu; currDisplay = "main"; } continue; case "3": //Update Contacts int contactID = 0; if (myPhone.contactList.Count == 0) { currMenu = mainMenu + "There are no Contacts to Update.\n"; currDisplay = "main"; continue; } Console.Clear(); currMenu = ":::::Update Contact::::: \n Search for a contact to edit by First name or Last name"; reDisplayList = true; while (reDisplayList) { Console.Clear(); Console.WriteLine(currMenu); string search = Console.ReadLine(); var searchQuery = from elements in myPhone.contactList where search.Equals(elements.FName, StringComparison.InvariantCultureIgnoreCase) || search.Equals(elements.LName, StringComparison.InvariantCultureIgnoreCase) select elements; if (searchQuery.Count() == 0) { currMenu += "\n \nThe Search returned no results please try again"; continue; } foreach (var contact in searchQuery) { currMenu += System.Environment.NewLine + contact.displayContact(); } reDisplayList = false; } Console.Clear(); reDisplayList = true; while (reDisplayList) { currMenu += "Please enter the Contact ID of the contact to update."; Console.WriteLine(currMenu); if (int.TryParse(Console.ReadLine(), out contactID)) { Console.WriteLine(contactID); reDisplayList = false; break; } else { currMenu += "\nPlease enter only numeric values for Contact ID.\n"; continue; } } currMenu += "\n \nWhat would you like to update? Press (12) to Cancel \n(1) First Name \n(2) Last Name \n(3) Gender \n(4) Address \n(5) State \n(6) City \n(7) Country \n(8) Age \n(9) Zip Code \n(10) Country Code \n(11) Phone Number"; var updateCol = ""; var updateElement = new Contact(); foreach (var item in myPhone.contactList) { if (item.ContactId == contactID) { updateElement = item; break; } } reDisplayList = true; while (reDisplayList) { Console.Clear(); Console.WriteLine(currMenu); string sel = Console.ReadLine(); string updateResult = ""; switch (sel) { case "1": Console.Write("First Name: "); updateCol = "FIRST_NAME"; break; case "2": Console.Write("Last Name: "); updateCol = "LAST_NAME"; break; case "3": Console.Write("Gender: "); updateCol = "GENDER"; break; case "4": Console.Write("Addres: "); updateCol = "ADDRESS"; break; case "5": Console.Write("State: "); updateCol = "STATE"; break; case "6": Console.Write("City: "); updateCol = "CITY"; break; case "7": Console.Write("Country: "); updateCol = "COUNTRY_NAME"; break; case "8": Console.Write("Age: "); updateCol = "AGE"; break; case "9": Console.Write("Zip Code: "); updateCol = "ZIP_CODE"; break; case "10": Console.Write("Country Code: "); updateCol = "COUNTRY_CODE"; break; case "11": Console.Write("Phone Number: "); updateCol = "PHONE_NUMBER"; break; case "12": currMenu = mainMenu; currDisplay = "main"; reDisplayList = false; continue; default: currMenu += "\n \nSelection entered wasn't valid, please select options 1-11 or 12 to Cancel"; continue; } updateResult = Console.ReadLine(); /*string command; * if (updateCol == "COUNTRY_NAME" || updateCol == "COUNTRY_CODE") * { * command = $"UPDATE dbo.Country " + * $"SET {updateCol} = @{updateCol} " + * $"WHERE COUNTRY_ID = {updateElement.Address.Country.CountryID}"; * }else if(updateCol == "ADDRESS" || updateCol == "CITY" || updateCol == "STATE" || updateCol == "ZIP_CODE") * { * command = $"UPDATE dbo.Address " + * $"SET {updateCol} = @{updateCol} " + * $"WHERE ADDRESS_ID = {updateElement.Address.AddressID}"; * } * else * { * command = $"UPDATE dbo.Contacts " + * $"SET {updateCol} = @{updateCol} " + * $"WHERE CONTACT_ID = {updateElement.ContactId}"; * } * using (SqlDataAdapter dataAdapter = new SqlDataAdapter()) * { * connect.Open(); * using (sqlCommand = new SqlCommand(command, connect)) * { * if(updateCol.Equals("AGE") || updateCol == "ZIP_CODE" || updateCol == "COUNTRY_CODE") * { * sqlCommand.Parameters.AddWithValue($"@{updateCol}", Convert.ToInt32(updateResult)); * }else if (updateCol == "PHONE_NUMBER") * { * sqlCommand.Parameters.AddWithValue($"@{updateCol}", Convert.ToInt64(updateResult)); * } * else * { * sqlCommand.Parameters.AddWithValue($"@{updateCol}", updateResult); * } * sqlCommand.ExecuteNonQuery(); * } * connect.Close(); * };*/ ContactDA.update(updateCol, updateElement, updateResult); myPhone.contactList = ContactDA.read(); Console.WriteLine("Contact Successfully Updated! Press (1) to continue Press (2) to Cancel"); string continueUpdate = Console.ReadLine(); if (continueUpdate == "1") { continue; } else { reDisplayList = false; currMenu = mainMenu + "\nContact Successfully Updated!"; currDisplay = "main"; continue; } } break; case "4": //Delete Contact if (myPhone.contactList.Count == 0) { currMenu = mainMenu + "There are no Contacts to Delete.\n"; currDisplay = "main"; continue; } redisplay = true; while (redisplay) { currMenu = ":::::Delete Contact:::::\n"; foreach (Contact contact in myPhone.contactList) { currMenu += contact.displayContact() + System.Environment.NewLine; } currMenu += "\nSelect a record to Delete by Contact ID:"; reDisplayList = true; Contact delContact = new Contact(); while (reDisplayList) { Console.Clear(); Console.WriteLine(currMenu); if (int.TryParse(Console.ReadLine(), out contactID)) { foreach (var contact in myPhone.contactList) { if (contact.ContactId == contactID) { delContact = contact; reDisplayList = false; break; } } currMenu += "\nThat Contact ID wasn't found please try again.\n"; continue; } else { currMenu += "\nPlease enter only numeric values for Contact ID.\n"; continue; } } /*command = $"DELETE FROM dbo.Contacts " + * $"WHERE CONTACT_ID = @contactID"; * using (SqlDataAdapter dataAdapter = new SqlDataAdapter()) * { * connect.Open(); * using (sqlCommand = new SqlCommand(command, connect)) * { * sqlCommand.Parameters.AddWithValue("@contactID", delContact.ContactId); * sqlCommand.ExecuteNonQuery(); * } * connect.Close(); * };*/ ContactDA.delete(delContact); myPhone.contactList.Remove(delContact); redisplay = true; while (redisplay) { Console.WriteLine("Contact Deleted Press (1) to Continue (2) to Cancel"); if (int.TryParse(Console.ReadLine(), out result)) { if (result == 1) { break; } else if (result == 2) { currMenu = mainMenu; currDisplay = "main"; redisplay = false; break; } else { Console.WriteLine("\nInvalid Entry try again.\n"); continue; } } else { currMenu += "\nPlease enter only numeric values for Contact ID.\n"; continue; } } } break; case "5": currMenu = mainMenu; currDisplay = "main"; continue; default: currMenu += "\n \nSelection entered wasn't valid, please select options 1-5."; continue; } continue; } case "view-contacts": { switch (menuSel) { case "1": if (myPhone.contactList.Count == 0) { currMenu += System.Environment.NewLine + "No Contacts Saved to Display"; currDisplay = "main"; continue; } Console.Clear(); currMenu = ":::::View All Contacts::::: \n"; foreach (Contact contact in myPhone.contactList) { currMenu += contact.displayContact() + System.Environment.NewLine; } currMenu += "Press (1) to return to Main Menu, Press (2) to close app."; redisplay = true; continue; case "2": Console.WriteLine("Search contacts."); string search = Console.ReadLine(); var searchQuery = from elements in myPhone.contactList where search.Equals(elements.FName, StringComparison.InvariantCultureIgnoreCase) || search.Equals(elements.LName, StringComparison.InvariantCultureIgnoreCase) select elements; currMenu = ":::::Search Contacts::::: \n"; foreach (var contact in searchQuery) { currMenu += contact.displayContact() + System.Environment.NewLine; } currMenu += "Press (1) to return to Main Menu, Press (2) to close app."; redisplay = true; continue; case "3": currMenu = mainMenu; currDisplay = "main"; continue; default: break; } break; } } } } catch (Exception ex) { Console.WriteLine(ex.Message); Console.ReadLine(); } }