public static void displayboats(Boatsold personboat) { Console.WriteLine("Your first boat, a(n) {0}, has boat number {1}", personboat.boat1, personboat.boatNumber1); Console.WriteLine("Your second boat, a(n) {0}, has boat number {1}", personboat.boat2, personboat.boatNumber2); Console.WriteLine("Your third boat, a(n) {0}, has boat number {1}", personboat.boat3, personboat.boatNumber3); Console.WriteLine("Your fourth boat, a(n) {0}, has boat number {1}", personboat.boat4, personboat.boatNumber4); Console.WriteLine("Your fifth boat, a(n) {0}, has boat number {1}", personboat.boat5, personboat.boatNumber5); }
public static BoatsRacing converter5(Boatsold boat) { BoatsRacing racer1 = new BoatsRacing(boat.name, boat.boat5, boat.boatNumber5); return(racer1); }
public static void AddBoat(Boatsold personboat) { /* * Console.WriteLine("Would you like to add a new boat, Y/N?"); * string response1 = Console.ReadLine(); * if (response1 == "y" || response1 == "Y") * { * Console.WriteLine("Enter boatname"); * string boat = Console.ReadLine(); * Console.WriteLine("Enter boatnumber"); * int boatnumber = int.Parse(Console.ReadLine()); * * using (IDbConnection connection = new MySql.Data.MySqlClient.MySqlConnection(Helper.CnnVal("sailingDB"))) * { * * try * { * var boat1 = connection.Query<Boatsold>("call returnboat(@name)", new { name = personboat.name }).First(); * if (boat1.boat1 == "") * { * SQLAddboat(personboat.name, 0, boat, boatnumber); * } * else if (boat1.boat2 == "") * { * SQLAddboat(personboat.name, 1, boat, boatnumber); * } * else if (boat1.boat3 == "") * { * SQLAddboat(personboat.name, 2, boat, boatnumber); * } * else if (boat1.boat4 == "") * { * SQLAddboat(personboat.name, 3, boat, boatnumber); * } * else if (boat1.boat5 == "") * { * SQLAddboat(personboat.name, 4, boat, boatnumber); * } * else * { * Console.WriteLine("You have the max number of boats(5), would you like to remove one?"); * Console.WriteLine("Here are your 5 boats"); * displayboats(personboat); * if (Console.ReadLine() == "Y" || Console.ReadLine() == "y") * { * BoatsRacing boatsracing = new BoatsRacing(); * Console.WriteLine("Which boat would you like to remove?"); * var answer = Console.ReadLine(); * if (answer == personboat.boat1) * { * boatsracing.name = personboat.name; * boatsracing.boatName = personboat.boat1; * boatsracing.boatNumber = personboat.boatNumber1; * LoadFullSQL.SQLremoveboat(personboat, boatsracing); * * } * else if (answer == personboat.boat2) * { * boatsracing.name = personboat.name; * boatsracing.boatName = personboat.boat2; * boatsracing.boatNumber = personboat.boatNumber2; * LoadFullSQL.SQLremoveboat(personboat, boatsracing); * * } * else if (answer == personboat.boat3) * { * boatsracing.name = personboat.name; * boatsracing.boatName = personboat.boat3; * boatsracing.boatNumber = personboat.boatNumber3; * LoadFullSQL.SQLremoveboat(personboat, boatsracing); * * } * else if (answer == personboat.boat4) * { * boatsracing.name = personboat.name; * boatsracing.boatName = personboat.boat4; * boatsracing.boatNumber = personboat.boatNumber4; * LoadFullSQL.SQLremoveboat(personboat, boatsracing); * * } * else if (answer == personboat.boat5) * { * boatsracing.name = personboat.name; * boatsracing.boatName = personboat.boat5; * boatsracing.boatNumber = personboat.boatNumber5; * LoadFullSQL.SQLremoveboat(personboat, boatsracing); * * } * else * Console.WriteLine("That is not one of the boats."); * * } * } * * } * catch * { * Console.WriteLine("Your name is not in my database"); * } * * * } * } */ }
public static void SQLremoveboat(Boatsold boats, BoatsRacing boat) { /* * if (boats.name == boat.name) * { * boats.noOfBoats = boats.noOfBoats - 1; * LoadFullSQL.SQLremove(false, boats.name); * if (boats.boat1 == boat.boatName) * { * if (boats.noOfBoats == 1) * { * boats.boat1 = ""; * boats.boatNumber1 = 0; * } * else if (boats.noOfBoats == 2) * { * boats.boat1 = boats.boat2; * boats.boat2 = ""; * boats.boatNumber1 = boats.boatNumber2; * boats.boatNumber2 = 0; * } * else if (boats.noOfBoats == 3) * { * boats.boat1 = boats.boat3; * boats.boat3 = ""; * boats.boatNumber1 = boats.boatNumber3; * boats.boatNumber3 = 0; * } * else if (boats.noOfBoats == 4) * { * boats.boat1 = boats.boat4; * boats.boat4 = ""; * boats.boatNumber1 = boats.boatNumber4; * boats.boatNumber4 = 0; * } * else if (boats.noOfBoats == 5) * { * boats.boat1 = boats.boat5; * boats.boat5 = ""; * boats.boatNumber1 = boats.boatNumber5; * boats.boatNumber5 = 0; * } * * } * else if (boats.boat2 == boat.boatName) * { * if (boats.noOfBoats == 2) * { * boats.boat2 = ""; * boats.boatNumber2 = 0; * } * else if (boats.noOfBoats == 3) * { * boats.boat2 = boats.boat3; * boats.boat3 = ""; * boats.boatNumber2 = boats.boatNumber3; * boats.boatNumber3 = 0; * } * else if (boats.noOfBoats == 4) * { * boats.boat2 = boats.boat4; * boats.boat4 = ""; * boats.boatNumber2 = boats.boatNumber4; * boats.boatNumber4 = 0; * } * else if (boats.noOfBoats == 5) * { * boats.boat2 = boats.boat5; * boats.boat5 = ""; * boats.boatNumber2 = boats.boatNumber5; * boats.boatNumber5 = 0; * } * * * } * * else if (boats.boat3 == boat.boatName) * { * if (boats.noOfBoats == 3) * { * boats.boat3 = ""; * boats.boatNumber3 = 0; * } * else if (boats.noOfBoats == 4) * { * boats.boat3 = boats.boat4; * boats.boat4 = ""; * boats.boatNumber3 = boats.boatNumber4; * boats.boatNumber4 = 0; * } * else if (boats.noOfBoats == 5) * { * boats.boat3 = boats.boat5; * boats.boat5 = ""; * boats.boatNumber3 = boats.boatNumber5; * boats.boatNumber5 = 0; * } * * } * else if (boats.boat4 == boat.boatName) * { * if (boats.noOfBoats == 4) * { * boats.boat4 = ""; * boats.boatNumber4 = 0; * } * else if (boats.noOfBoats == 5) * { * boats.boat4 = boats.boat5; * boats.boat5 = ""; * boats.boatNumber4 = boats.boatNumber5; * boats.boatNumber5 = 0; * } * * } * else if (boats.boat5 == boat.boatName) * { * boats.boat5 = ""; * boats.boatNumber5 = 0; * * } * * LoadFullSQL.SQLAddboat(boats.name, boats.noOfBoats, boats.boat1, boats.boatNumber1); * LoadFullSQL.SQLAddboat(boats.name, boats.noOfBoats, boats.boat2, boats.boatNumber2); * LoadFullSQL.SQLAddboat(boats.name, boats.noOfBoats, boats.boat3, boats.boatNumber3); * LoadFullSQL.SQLAddboat(boats.name, boats.noOfBoats, boats.boat4, boats.boatNumber4); * LoadFullSQL.SQLAddboat(boats.name, boats.noOfBoats, boats.boat5, boats.boatNumber5); * } */ }
public static Dictionary <string, Boatsold> loadFullFile(string path) //public static string LoadFullFile() { StreamReader reader = System.IO.File.OpenText(@path + @"Full List.txt"); string line; Dictionary <int, Boats> BoatDictionaryInterim = new Dictionary <int, Boats>(); Dictionary <string, Boatsold> BoatDictionary = new Dictionary <string, Boatsold>(); int count1 = 0; while ((line = reader.ReadLine()) != null) { string[] items = line.Split(char.Parse("\n")); while ((line = reader.ReadLine()) != null) { /* * string[] items1 = line.Split('\t'); * Boats boat1 = new Boats(items1[0], int.Parse(items1[1]), items1[2]); * BoatDictionaryInterim.Add(count1, boat1); */ count1++; } } List <string> keys = new List <string>(); int m = 0; foreach (KeyValuePair <int, Boats> Boat in BoatDictionaryInterim) { if (keys.Contains(BoatDictionaryInterim[m].name)) { if (BoatDictionary[BoatDictionaryInterim[m].name].boat2 == null) { Boatsold boat1 = new Boatsold(BoatDictionaryInterim[m].name, BoatDictionary[BoatDictionaryInterim[m].name].boat1, BoatDictionary[BoatDictionaryInterim[m].name].boatNumber1, BoatDictionaryInterim[m].boatName, BoatDictionaryInterim[m].boatNumber); BoatDictionary.Remove(BoatDictionaryInterim[m].name); BoatDictionary.Add(boat1.name, boat1); } else if (BoatDictionary[BoatDictionaryInterim[m].name].boat3 == null) { Boatsold boat1 = new Boatsold(BoatDictionaryInterim[m].name, BoatDictionary[BoatDictionaryInterim[m].name].boat1, BoatDictionary[BoatDictionaryInterim[m].name].boatNumber1, BoatDictionary[BoatDictionaryInterim[m].name].boat2, BoatDictionary[BoatDictionaryInterim[m].name].boatNumber2, BoatDictionaryInterim[m].boatName, BoatDictionaryInterim[m].boatNumber); BoatDictionary.Remove(BoatDictionaryInterim[m].name); BoatDictionary.Add(boat1.name, boat1); } else if (BoatDictionary[BoatDictionaryInterim[m].name].boat4 == null) { Boatsold boat1 = new Boatsold(BoatDictionaryInterim[m].name, BoatDictionary[BoatDictionaryInterim[m].name].boat1, BoatDictionary[BoatDictionaryInterim[m].name].boatNumber1, BoatDictionary[BoatDictionaryInterim[m].name].boat2, BoatDictionary[BoatDictionaryInterim[m].name].boatNumber2, BoatDictionary[BoatDictionaryInterim[m].name].boat3, BoatDictionary[BoatDictionaryInterim[m].name].boatNumber3, BoatDictionaryInterim[m].boatName, BoatDictionaryInterim[m].boatNumber); BoatDictionary.Remove(BoatDictionaryInterim[m].name); BoatDictionary.Add(boat1.name, boat1); } else if (BoatDictionary[BoatDictionaryInterim[m].name].boat5 == null) { Boatsold boat1 = new Boatsold(BoatDictionaryInterim[m].name, BoatDictionary[BoatDictionaryInterim[m].name].boat1, BoatDictionary[BoatDictionaryInterim[m].name].boatNumber1, BoatDictionary[BoatDictionaryInterim[m].name].boat2, BoatDictionary[BoatDictionaryInterim[m].name].boatNumber2, BoatDictionary[BoatDictionaryInterim[m].name].boat3, BoatDictionary[BoatDictionaryInterim[m].name].boatNumber3, BoatDictionary[BoatDictionaryInterim[m].name].boat4, BoatDictionary[BoatDictionaryInterim[m].name].boatNumber4, BoatDictionaryInterim[m].boatName, BoatDictionaryInterim[m].boatNumber); BoatDictionary.Remove(BoatDictionaryInterim[m].name); BoatDictionary.Add(boat1.name, boat1); } } else { Boatsold boat3 = new Boatsold(BoatDictionaryInterim[m].name, BoatDictionaryInterim[m].boatName, BoatDictionaryInterim[m].boatNumber); BoatDictionary.Add(boat3.name, boat3); keys.Add(BoatDictionaryInterim[m].name); } m++; } reader.Close(); return(BoatDictionary); }
//public List<Boats> boatlist = new List<Boats>(); //public Boats personboat = new Boats(); //public static void Main1() public static void hello(string name) { //Boats boat1 = new Boats("Adrian Stanislaus", 2, "Laser Stratos", 927, "Laser", 182782); //Boats boat2 = new Boats("Luke Stanislaus", 1, "Laser Stratos", 182782, null, 0); //Boats boat3 = new Boats("Simon Clark", 2, "Phantom", 1080, "Laser", 1234); //List<Boats> boat = new Dictionary<string, Boats>(); List <BoatsRacing> raceList = new List <BoatsRacing>(); List <Boatsold> boatlist = new List <Boatsold>(); Boatsold personboat = new Boatsold(); //Console.WriteLine("Enter path to folder of files"); string[] path1 = System.Reflection.Assembly.GetEntryAssembly().Location.Split(char.Parse(@"\")); string path = ""; int b = 0; while (path1[b] != "SailingUWP") { path = string.Concat(path + path1[b] + @"\"); b++; } //string path2 = path.Split(path) /* * Console.WriteLine("Enter name"); * string name1 = Console.ReadLine(); * LoadFullSQL db = new LoadFullSQL(); * boatlist = db.GetBoats(); * Console.WriteLine(db.GetBoat(name1).boat1); */ //boatDictionary = LoadFullSQL.getdictionary(boatlist); /* * Console.WriteLine("Enter name"); * string name2 = Console.ReadLine(); * Console.WriteLine("Enter boatname"); * string boatname2 = Console.ReadLine(); * Console.WriteLine("Enter boatnumber"); * int boatnumber2 = int.Parse(Console.ReadLine()); * if (LoadFullSQL.AddBoat(name2, boatname2, boatnumber2) == true) * Console.WriteLine("Success"); * else * Console.WriteLine("Fail"); */ //boatDictionary = LoadFullFile.loadFullFile(path); //Console.WriteLine(boatDictionary["Adrian Stanislaus"].boat1); //string hi = LoadFullFile(); //Console.WriteLine(boatDictionary["Abc"].name); //boatDictionary.Add(boat1.name, boat1); //boatDictionary.Add(boat2.name, boat2); //boatDictionary.Add(boat3.name, boat3); //LoadFullFile.ExportToFile(boatDictionary, path); /* * while (0==1) * { * Console.WriteLine("Who is it?"); * string person = name; * try * { * LoadFullSQL db1 = new LoadFullSQL(); * //Boats personboat = db1.GetBoat(person); * personboat = db1.GetBoat(person); * while (person == personboat.name) * { * * if (personboat.noOfBoats > 0) * { * Console.WriteLine("Is your boat a(n) {0}, Y/N?", personboat.boat1); * string response = Console.ReadLine(); * if (response == "Y" || response == "y") * { * * //BoatsRacing.converter1(personboat); * LoadFullSQL.SQLaddnewracer(personboat, BoatsRacing.converter1(personboat)); * Console.ReadLine(); * * break; * * } * else if (personboat.noOfBoats == 1) * { * LoadFullSQL.AddBoat(personboat); * } * } * if (personboat.noOfBoats > 1) * { * Console.WriteLine("Is your boat a(n) {0}, Y/N?", personboat.boat2); * string response = Console.ReadLine(); * if (response == "Y" || response == "y") * { * * LoadFullSQL.SQLaddnewracer(personboat, BoatsRacing.converter1(personboat)); * Console.ReadLine(); * break; * * } * else if (personboat.noOfBoats == 2) * { * LoadFullSQL.AddBoat(personboat); * } * } * if (personboat.noOfBoats > 2) * { * Console.WriteLine("Is your boat a(n) {0}, Y/N?", personboat.boat3); * string response = Console.ReadLine(); * if (response == "Y" || response == "y") * { * * LoadFullSQL.SQLaddnewracer(personboat, BoatsRacing.converter1(personboat)); * Console.ReadLine(); * break; * * } * else if (personboat.noOfBoats == 3) * { * LoadFullSQL.AddBoat(personboat); * } * } * if (personboat.noOfBoats > 3) * { * Console.WriteLine("Is your boat a(n) {0}, Y/N?", personboat.boat4); * string response = Console.ReadLine(); * if (response == "Y" || response == "y") * { * * LoadFullSQL.SQLaddnewracer(personboat, BoatsRacing.converter1(personboat)); * Console.ReadLine(); * break; * * } * else if (personboat.noOfBoats == 4) * { * LoadFullSQL.AddBoat(personboat); * } * } * if (personboat.noOfBoats > 4) * { * Console.WriteLine("Is your boat a(n) {0}, Y/N?", personboat.boat5); * string response = Console.ReadLine(); * if (response == "Y" || response == "y") * { * * LoadFullSQL.SQLaddnewracer(personboat, BoatsRacing.converter1(personboat)); * Console.ReadLine(); * break; * * } * else if (personboat.noOfBoats == 5) * { * LoadFullSQL.AddBoat(personboat); * } * } * Console.Clear(); * personboat = db1.GetBoat(person); * } * } * * catch (KeyNotFoundException) * { * * * } * //Dictionary<string, Boats> nothing = new Dictionary<string, Boats>(); * //boatDictionary = LoadFullFile.loadFullFile(path); * //string hi2 = LoadFullFile(); * Console.Clear(); * Console.WriteLine("Escape, Y/N?"); * if (Console.ReadLine() == "y" || Console.ReadLine() == "Y") * break; * * } * foreach (var item in raceList) * { * Console.WriteLine("Name = {0}, BoatName = {1}, BoatNumber = {2}", item.name, item.boatName, item.boatNumber); * } * Console.ReadLine(); * /* * Console.WriteLine("Would you like to remove a boat?"); * if (Console.ReadLine() == "y" || Console.ReadLine() == "Y") * { * LoadFullSQL.SQLremoveboat() * } */ }