예제 #1
0
 public void racerwritetofile(BoatsRacing racer, string path)
 {
     using (StreamWriter sw = System.IO.File.AppendText(@path + @"\Race List.txt"))
     {
         sw.WriteLine("{0}, {1}, {2}", racer.name,
                      racer.boatName,
                      racer.boatNumber);
     }
 }
예제 #2
0
        public static Dictionary <string, BoatsRacing> loadRaceFile(Dictionary <string, BoatsRacing> raceDictionary, string path)
        {
            StreamReader reader = System.IO.File.OpenText(@path + @"\Race List.txt");
            string       line;

            while ((line = reader.ReadLine()) != null)
            {
                string[] items = line.Split(char.Parse(", "));
                Console.WriteLine("{0}, {1}, {2}", items[0], items[1], items[2]);
                BoatsRacing boat1 = new BoatsRacing(items[0], items[1], int.Parse(items[2]));


                raceDictionary.Add(items[0], boat1);
            }
            reader.Close();
            return(raceDictionary);
        }
예제 #3
0
 public static void SQLaddnewracer(Boats personboat, BoatsRacing BoatRacing)
 {
     try
     {
         using (IDbConnection connection = new MySql.Data.MySqlClient.MySqlConnection(Helper.CnnVal("sailingDB")))
         {
             //connection.Query("call enterraceperson('" + BoatRacing.name + "', '" + BoatRacing.boatName + "', '" +
             //BoatRacing.boatNumber + "')");
             connection.Query("call enterraceperson(@name, @boatname, @boatnumber)", new { name     = BoatRacing.name,
                                                                                           boatname = BoatRacing.boatName, boatnumber = BoatRacing.boatNumber });
         }
         Console.WriteLine(personboat.name + " is racing a(n) " +
                           BoatRacing.boatName);
     }
     catch
     {
         Console.WriteLine("Your name has already been added to the race, would you like to remove it?");
         if (Console.ReadLine() == "y" || Console.ReadLine() == "Y")
         {
             SQLremove(true, BoatRacing.name);
         }
     }
 }
예제 #4
0
        public static BoatsRacing converter5(Boats boat)
        {
            BoatsRacing racer1 = new BoatsRacing(boat.name, boat.boat5, boat.boatNumber5);

            return(racer1);
        }
예제 #5
0
 public static void SQLremoveboat(Boats 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);
      *
      */
 }
예제 #6
0
        public static void AddBoat(Boats 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 <Boats>("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");
                    }
                }
            }
        }
예제 #7
0
        public static void SQLremoveboat(Boats 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);
            }
        }