private void scoutingSubmitButton_Click(object sender, EventArgs e) { scoutingSubmitButton.Enabled = false; Program.selectedEventName = "RecycleRush_GTR_East"; var match = new Match_Scout { Author = Settings.Default.username, TimeCreated = DateTime.Now.ToString("yyyy-MM-dd H:mm:ss"), UniqueID = Guid.NewGuid().ToString(), Team_Number = currentTeamNumber, Team_Name = currentTeamName, Match_Number = Convert.ToInt32(scoutingMatchNumberNumericUpDown.Value), Alliance_Colour = allianceColour, Robot_Dead = scoutingDidTheRobotDieCheckBox.Checked, Auto_Starting_X = startingX, Auto_Starting_Y = startingY, Auto_Drive_To_Autozone = scoutingDriveToAutoZoneCheckBox.Checked, Auto_Robot_Set = scoutingRobotSetCheckBox.Checked, Auto_Tote_Set = scoutingToteSetCheckBox.Checked, Auto_Bin_Set = scoutingBinSetCheckBox.Checked, Auto_Stacked_Tote_Set = scoutingStackedToteSetCheckBox.Checked, Auto_Acquired_Step_Bins = Convert.ToInt32(scoutingAcquiredStepBinsNumUpDown.Value), Auto_Fouls = Convert.ToInt32(scoutingAutoFoulsNumUpDown.Value), Auto_Did_Nothing = scoutingDidNothingCheckBox.Checked, Tele_Tote_Pickup_Upright = scoutingTotePickupUprightCheckbox.Checked, Tele_Tote_Pickup_Upside_Down = scoutingTotePickupUpsideDownCheckBox.Checked, Tele_Tote_Pickup_Sideways = scoutingTotePickupSideWaysCheckBox.Checked, Tele_Bin_Pickup_Upright = scoutingBinPickupUprightCheckBox.Checked, Tele_Bin_Pickup_Upside_Down = scoutingBinPickupUpsideDownCheckBox.Checked, Tele_Bin_Pickup_Sideways = scoutingBinPickupSidewaysCheckBox.Checked, Tele_Human_Station_Load_Totes = scoutingHumanStationLoadTotesCheckBox.Checked, Tele_Human_Station_Stack_Totes = scoutingHumanStationStackTotesCheckBox.Checked, Tele_Human_Station_Insert_Litter = scoutingHumanStationInsertLitterCheckBox.Checked, Tele_Human_Throwing_Litter = scoutingHumanThrowingLitterCheckBox.Checked, Tele_Pushed_Litter_To_Landfill = scoutingPushedLitterToLandfill.Checked, Tele_Fouls = Convert.ToInt32(scoutingTeleFoulPointsNumUpDown.Value), Comments = scoutingCommentsRichTextBox.Text, Stacks = matchStacks, Coopertition_Set = scoutingCoopertitionSetCheckBox.Checked, Coopertition_Stack = scoutingCoopertitionStackCheckBox.Checked, Final_Score_Red = Convert.ToInt32(scoutingRedAllianceFinalScoreNumUpDown.Value), Final_Score_Blue = Convert.ToInt32(scoutingBlueAllianceFinalScoreNumUpDown.Value), Driver_Rating = driverRating }; if (match.Comments.Contains(";")) { match.Comments = Regex.Replace(match.Comments, "[;]", string.Empty); } try { Directory.CreateDirectory(AppDomain.CurrentDomain.BaseDirectory + "\\Saves"); var jsonText = JsonConvert.SerializeObject(match, Formatting.Indented); var matchLocation = AppDomain.CurrentDomain.BaseDirectory + "\\Saves\\RecycleRush_GTR_East_" + Convert.ToInt32(scoutingMatchNumberNumericUpDown.Value) + "_" + currentTeamName + ".json"; File.WriteAllText(matchLocation, jsonText); } catch (Exception exception) { Console.Write("Error Occured: " + exception.Message); ConsoleWindow.WriteLine("Error Occured: " + exception.Message); Notifications.ReportCrash(exception); } try { var conn = new MySqlConnection(MySQLMethods.MakeMySqlConnectionString()); conn.Open(); var cmd = conn.CreateCommand(); var commandText = string.Format( "Insert into RecycleRush_GTR_East_Matches (EntryID,UniqueID,Author,TimeCreated,Team_Number,Team_Name,Match_Number,Alliance_Colour,Robot_Dead,Auto_Starting_X,Auto_Starting_Y,Auto_Drive_To_Autozone,Auto_Robot_Set,Auto_Tote_Set,Auto_Bin_Set,Auto_Stacked_Tote_Set,Auto_Acquired_Step_Bins,Auto_Fouls,Auto_Did_Nothing,Tele_Tote_Pickup_Upright,Tele_Tote_Pickup_Upside_Down,Tele_Tote_Pickup_Sideways,Tele_Bin_Pickup_Upright,Tele_Bin_Pickup_Upside_Down,Tele_Bin_Pickup_Sideways,Tele_Human_Station_Load_Totes,Tele_Human_Station_Stack_Totes,Tele_Human_Station_Insert_Litter,Tele_Human_Throwing_Litter,Tele_Pushed_Litter_To_Landfill,Tele_Fouls,Comments,Stacks,Coopertition_Set,Coopertition_Stack,Final_Score_Red,Final_Score_Blue,Driver_Rating) values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}','{14}','{15}','{16}','{17}','{18}','{19}','{20}','{21}','{22}','{23}','{24}','{25}','{26}','{27}','{28}','{29}','{30}','{31}','{32}','{33}','{34}','{35}','{36}','{37}');", MySQLMethods.GetNumberOfRowsInATable() + 1, match.UniqueID, match.Author, match.TimeCreated, match.Team_Number, match.Team_Name, match.Match_Number, match.Alliance_Colour, Convert.ToInt16(match.Robot_Dead), match.Auto_Starting_X, match.Auto_Starting_Y, Convert.ToInt16(match.Auto_Drive_To_Autozone), Convert.ToInt16(match.Auto_Robot_Set), Convert.ToInt16(match.Auto_Tote_Set), Convert.ToInt16(match.Auto_Bin_Set), Convert.ToInt16(match.Auto_Stacked_Tote_Set), match.Auto_Acquired_Step_Bins, match.Auto_Fouls, Convert.ToInt16(match.Auto_Did_Nothing), Convert.ToInt16(match.Tele_Tote_Pickup_Upright), Convert.ToInt16(match.Tele_Tote_Pickup_Upside_Down), Convert.ToInt16(match.Tele_Tote_Pickup_Sideways), Convert.ToInt16(match.Tele_Bin_Pickup_Upright), Convert.ToInt16(match.Tele_Bin_Pickup_Upside_Down), Convert.ToInt16(match.Tele_Bin_Pickup_Sideways), Convert.ToInt16(match.Tele_Human_Station_Load_Totes), Convert.ToInt16(match.Tele_Human_Station_Stack_Totes), Convert.ToInt16(match.Tele_Human_Station_Insert_Litter), Convert.ToInt16(match.Tele_Human_Throwing_Litter), Convert.ToInt16(match.Tele_Pushed_Litter_To_Landfill), match.Tele_Fouls, match.Comments, JsonConvert.SerializeObject(match.Stacks), Convert.ToInt16(match.Coopertition_Set), Convert.ToInt16(match.Coopertition_Stack), match.Final_Score_Red, match.Final_Score_Blue, match.Driver_Rating); cmd.CommandText = commandText; cmd.ExecuteNonQuery(); conn.Close(); } catch (Exception exception) { Console.Write("Error Occured: " + exception.Message); ConsoleWindow.WriteLine("Error Occured: " + exception.Message); Notifications.ReportCrash(exception); } ResetScoutingInterface(); scoutingSubmitButton.Enabled = true; }
private void teamSelector_SelectedIndexChanged(object sender, EventArgs e) { currentTeamName = teamNameArray[teamSelector.SelectedIndex]; currentTeamNumber = teamNumberArray[teamSelector.SelectedIndex]; Program.selectedTeamNumber = currentTeamNumber; teamInformationTeamName.Text = "Team Name: " + teamNameArray[teamSelector.SelectedIndex]; teamInformationTeamNumber.Text = "Team Number: " + teamNumberArray[teamSelector.SelectedIndex]; ResetMatchBreakdownInterface(); try { var teamImage = Resources.ResourceManager.GetObject("FRC" + teamNumberArray[teamSelector.SelectedIndex]); teamInformationLogo.Image = (Image)teamImage; } catch (Exception exception) { Console.Write("Error Occured: " + exception.Message); ConsoleWindow.WriteLine("Error Occured: " + exception.Message); } if (Network.CheckForInternetConnection()) { var url = "http://www.thebluealliance.com/api/v2/team/frc"; url = url + Convert.ToString(teamNumberArray[teamSelector.SelectedIndex]); string downloadedData; var wc = new WebClient(); wc.Headers.Add("X-TBA-App-Id", "3710-xNovax:FRC_Scouting_V2:" + Assembly.GetExecutingAssembly().GetName().Version); try { downloadedData = wc.DownloadString(url); var deserializedData = JsonConvert.DeserializeObject <AerialAssist_RahChaCha.TeamInformationJSONData>(downloadedData); teamInformationTeamLocation.Text = "Team Location: " + Convert.ToString(deserializedData.location); teamInformationRookieYear.Text = "Rookie Year: " + Convert.ToString(deserializedData.rookie_year); teamInformationWebsiteLinkLabel.Text = Convert.ToString(deserializedData.website); } catch (Exception webError) { ConsoleWindow.WriteLine("Error Message: " + webError.Message); } } else { teamInformationTeamLocation.Text = "Team Location: "; teamInformationRookieYear.Text = "Rookie Year: "; teamInformationWebsiteLinkLabel.Text = ""; } if (Network.CheckForInternetConnection()) { try { var conn = new MySqlConnection(MySQLMethods.MakeMySqlConnectionString()); var cmd = conn.CreateCommand(); MySqlDataReader reader; cmd.CommandText = string.Format("SELECT * FROM RecycleRush_GTR_East_Matches WHERE Team_Number = '{0}'", Program.selectedTeamNumber); conn.Open(); reader = cmd.ExecuteReader(); while (reader.Read()) { var match = new Match_Scout { Author = reader["Author"].ToString(), TimeCreated = reader["TimeCreated"].ToString(), Match_Number = Convert.ToInt32(reader["Match_Number"]), Alliance_Colour = Convert.ToString(reader["Alliance_Colour"]), Robot_Dead = Convert.ToBoolean(reader["Robot_Dead"]), Auto_Starting_X = Convert.ToInt32(reader["Auto_Starting_X"]), Auto_Starting_Y = Convert.ToInt32(reader["Auto_Starting_Y"]), Auto_Drive_To_Autozone = Convert.ToBoolean(reader["Auto_Drive_To_Autozone"]), Auto_Robot_Set = Convert.ToBoolean(reader["Auto_Robot_Set"]), Auto_Tote_Set = Convert.ToBoolean(reader["Auto_Tote_Set"]), Auto_Bin_Set = Convert.ToBoolean(reader["Auto_Bin_Set"]), Auto_Stacked_Tote_Set = Convert.ToBoolean(reader["Auto_Stacked_Tote_Set"]), Auto_Acquired_Step_Bins = Convert.ToInt32(reader["Auto_Acquired_Step_Bins"]), Auto_Fouls = Convert.ToInt32(reader["Auto_Fouls"]), Auto_Did_Nothing = Convert.ToBoolean(reader["Auto_Did_Nothing"]), Tele_Tote_Pickup_Upright = Convert.ToBoolean(reader["Tele_Tote_Pickup_Upright"]), Tele_Tote_Pickup_Upside_Down = Convert.ToBoolean(reader["Tele_Tote_Pickup_Upside_Down"]), Tele_Tote_Pickup_Sideways = Convert.ToBoolean(reader["Tele_Tote_Pickup_Sideways"]), Tele_Bin_Pickup_Upright = Convert.ToBoolean(reader["Tele_Bin_Pickup_Upright"]), Tele_Bin_Pickup_Upside_Down = Convert.ToBoolean(reader["Tele_Bin_Pickup_Upside_Down"]), Tele_Bin_Pickup_Sideways = Convert.ToBoolean(reader["Tele_Bin_Pickup_Sideways"]), Tele_Human_Station_Load_Totes = Convert.ToBoolean(reader["Tele_Human_Station_Load_Totes"]), Tele_Human_Station_Stack_Totes = Convert.ToBoolean(reader["Tele_Human_Station_Stack_Totes"]), Tele_Human_Station_Insert_Litter = Convert.ToBoolean(reader["Tele_Human_Station_Insert_Litter"]), Tele_Human_Throwing_Litter = Convert.ToBoolean(reader["Tele_Human_Throwing_Litter"]), Tele_Pushed_Litter_To_Landfill = Convert.ToBoolean(reader["Tele_Pushed_Litter_To_Landfill"]), Tele_Fouls = Convert.ToInt32(reader["Tele_Fouls"]), Comments = Convert.ToString(reader["Comments"]), Stacks = JsonConvert.DeserializeObject <List <Stack> >(reader["Stacks"].ToString()), Coopertition_Set = Convert.ToBoolean(reader["Coopertition_Set"]), Coopertition_Stack = Convert.ToBoolean(reader["Coopertition_Stack"]), Final_Score_Red = Convert.ToInt32(reader["Final_Score_Red"]), Final_Score_Blue = Convert.ToInt32(reader["Final_Score_Blue"]), Driver_Rating = Convert.ToInt32(reader["Driver_Rating"]) }; teamsMatches.Add(match); matchBreakdownMatchList.Items.Add("Match Number: " + reader["Match_Number"]); } conn.Close(); } catch (MySqlException exception) { Console.Write("Error Occured: " + exception.Message); ConsoleWindow.WriteLine("Error Occured: " + exception.Message); } } }