static void Main() { Application.EnableVisualStyles(); Application.SetCompatibleTextRenderingDefault(false); try { if (Properties.Settings.Default.SeasonID < 0) { SeasonSelectForm ssForm = new SeasonSelectForm(); ssForm.ShowDialog(); } MatchListForm frm = new MatchListForm(); Application.Run(frm); } catch (Exception) { Console.Out.WriteLine("Could not create form due to database issues"); } }
private void SaveData(bool exit) { MySqlConnection connection = new MySqlConnection(Utils.getConnectionString()); MySqlCommand cmd; bool saved = true, validated = true; long[] teamIDs = new long[] { -1, -1, -1, -1, -1, -1 }; string[] alliancePositions = new string[] { "Blue1", "Blue2", "Blue3", "Red1", "Red2", "Red3" }; long blue1ID = -1, blue2ID = -1, blue3ID = -1, red1ID = -1, red2ID = -1, red3ID = -1; connection.Open(); try { teamIDs[0] = Utils.getLongIDFromComboSelectedValue(cmbBlue1, lblStatus); teamIDs[1] = Utils.getLongIDFromComboSelectedValue(cmbBlue2, lblStatus); teamIDs[2] = Utils.getLongIDFromComboSelectedValue(cmbBlue3, lblStatus); teamIDs[3] = Utils.getLongIDFromComboSelectedValue(cmbRed1, lblStatus); teamIDs[4] = Utils.getLongIDFromComboSelectedValue(cmbRed2, lblStatus); teamIDs[5] = Utils.getLongIDFromComboSelectedValue(cmbRed3, lblStatus); blue1ID = Utils.getLongIDFromComboSelectedValue(cmbBlue1, lblStatus); blue2ID = Utils.getLongIDFromComboSelectedValue(cmbBlue2, lblStatus); blue3ID = Utils.getLongIDFromComboSelectedValue(cmbBlue3, lblStatus); red1ID = Utils.getLongIDFromComboSelectedValue(cmbRed1, lblStatus); red2ID = Utils.getLongIDFromComboSelectedValue(cmbRed2, lblStatus); red3ID = Utils.getLongIDFromComboSelectedValue(cmbRed3, lblStatus); } catch (Exception e) { validated = false; Console.Out.WriteLine(e.Message); } if (validated) { try { cmd = connection.CreateCommand(); cmd.CommandText = "INSERT INTO match_data(tablet_id, competition_id, match_number, match_type, match_time, match_location," + "blue_team_one_id, blue_team_two_id, blue_team_three_id, red_team_one_id, red_team_two_id, red_team_three_id, ready_to_export)" + "VALUES(@tabletID, @competitionID, @matchNumber, @matchType, @matchTime, @matchLocation," + "@blueTeamOneId, @blueTeamTwoId, @blueTeamThreeId, @redTeamOneId, @redTeamTwoId, @redTeamThreeId, @readyToExport)"; cmd.Parameters.AddWithValue("@tabletID", 0); cmd.Parameters.AddWithValue("@competitionID", this.compID); cmd.Parameters.AddWithValue("@matchNumber", int.Parse(txtMatchNumber.Text)); cmd.Parameters.AddWithValue("@matchType", txtMatchType.Text); cmd.Parameters.AddWithValue("@matchTime", txtMatchTime.Text); cmd.Parameters.AddWithValue("@matchLocation", txtMatchLocation.Text); cmd.Parameters.AddWithValue("@blueTeamOneId", teamIDs[0]); //blue1ID); cmd.Parameters.AddWithValue("@blueTeamTwoId", teamIDs[1]); //blue2ID); cmd.Parameters.AddWithValue("@blueTeamThreeId", teamIDs[2]); //blue3ID); cmd.Parameters.AddWithValue("@redTeamOneId", teamIDs[3]); //red1ID); cmd.Parameters.AddWithValue("@redTeamTwoId", teamIDs[4]); //red2ID); cmd.Parameters.AddWithValue("@redTeamThreeId", teamIDs[5]); //red3ID); cmd.Parameters.AddWithValue("@readyToExport", "false"); cmd.ExecuteNonQuery(); long match_id = cmd.LastInsertedId; long tablet_id = 0; cmd.Parameters.Clear(); cmd.CommandText = "INSERT INTO team_match(tablet_id, team_id, match_id, competition_id, alliance_position, " + "broke_down, no_move, lost_connection, starting_location, starting_location_X, starting_location_Y, starting_location_on_field, " + "auto_totes_picked_up, auto_totes_stacked, auto_totes_scored, auto_cans_picked_up, auto_cans_scored, auto_cans_pulled_from_step, " + "auto_mode_saved, auto_final_location_X, auto_final_location_Y, auto_tote_1_location_X, auto_tote_1_location_Y, " + "auto_tote_2_location_X, auto_tote_2_location_Y, auto_tote_3_location_X, auto_tote_3_location_Y, " + "auto_can_1_location_X, auto_can_1_location_Y, auto_can_2_location_X, auto_can_2_location_Y, auto_can_3_location_X, " + "auto_can_3_location_Y, auto_can_4_location_X, auto_can_4_location_Y, auto_can_5_location_X, auto_can_5_location_Y, " + "auto_can_6_location_X, auto_can_6_location_Y, auto_can_7_location_X, auto_can_7_location_Y, " + "auto_robot_visible, auto_tote1_visible, auto_tote2_visible, auto_tote3_visible, auto_can1_visible, " + "auto_can2_visible, auto_can3_visible, auto_can4_visible, auto_can5_visible, auto_can6_visible, auto_can7_visible, " + "auto_robot_stack_list, team_match_notes, tote_stacker, can_kinger, cooperative, " + "noodler, ni, tote_control_inside_robot, tote_control_fork_lift, tote_control_handle_grabber, " + "tote_control_drop_alot, tote_control_great_control, ready_to_export)" + "VALUES(@tablet_id, @team_id, @match_id, @competition_id, @alliance_position, " + "@broke_down, @no_move, @lost_connection, @starting_location, @starting_location_X, @starting_location_Y, @starting_location_on_field, " + "@auto_totes_picked_up, @auto_totes_stacked, @auto_totes_scored, @auto_cans_picked_up, @auto_cans_scored, @auto_cans_pulled_from_step, " + "@auto_mode_saved, @auto_final_location_X, @auto_final_location_Y, @auto_tote_1_location_X, @auto_tote_1_location_Y, " + "@auto_tote_2_location_X, @auto_tote_2_location_Y, @auto_tote_3_location_X, @auto_tote_3_location_Y, " + "@auto_can_1_location_X, @auto_can_1_location_Y, @auto_can_2_location_X, @auto_can_2_location_Y, @auto_can_3_location_X, " + "@auto_can_3_location_Y, @auto_can_4_location_X, @auto_can_4_location_Y, @auto_can_5_location_X, @auto_can_5_location_Y, " + "@auto_can_6_location_X, @auto_can_6_location_Y, @auto_can_7_location_X, @auto_can_7_location_Y, " + "@auto_robot_visible, @auto_tote1_visible, @auto_tote2_visible, @auto_tote3_visible, @auto_can1_visible, " + "@auto_can2_visible, @auto_can3_visible, @auto_can4_visible, @auto_can5_visible, @auto_can6_visible, @auto_can7_visible, " + "@auto_robot_stack_list, @team_match_notes, @tote_stacker, @can_kinger, @cooperative, " + "@noodler, @ni, @tote_control_inside_robot, @tote_control_fork_lift, @tote_control_handle_grabber, " + "@tote_control_drop_alot, @tote_control_great_control, @ready_to_export)"; cmd.Parameters.AddWithValue("@tablet_id", tablet_id); cmd.Parameters.AddWithValue("@team_id", 0); cmd.Parameters.AddWithValue("@match_id", 0); cmd.Parameters.AddWithValue("@competition_id", 0); cmd.Parameters.AddWithValue("@alliance_position", ""); cmd.Parameters.AddWithValue("@broke_down", "false"); cmd.Parameters.AddWithValue("@no_move", "false"); cmd.Parameters.AddWithValue("@lost_connection", "false"); cmd.Parameters.AddWithValue("@starting_location", 0); cmd.Parameters.AddWithValue("@starting_location_X", 0); cmd.Parameters.AddWithValue("@starting_location_Y", 0); cmd.Parameters.AddWithValue("@starting_location_on_field", 0); cmd.Parameters.AddWithValue("@auto_totes_picked_up", 0); cmd.Parameters.AddWithValue("@auto_totes_stacked", 0); cmd.Parameters.AddWithValue("@auto_totes_scored", 0); cmd.Parameters.AddWithValue("@auto_cans_picked_up", 0); cmd.Parameters.AddWithValue("@auto_cans_scored", 0); cmd.Parameters.AddWithValue("@auto_cans_pulled_from_step", 0); cmd.Parameters.AddWithValue("@auto_mode_saved", "false"); cmd.Parameters.AddWithValue("@auto_final_location_X", 0); cmd.Parameters.AddWithValue("@auto_final_location_Y", 0); cmd.Parameters.AddWithValue("@auto_tote_1_location_X", 0); cmd.Parameters.AddWithValue("@auto_tote_1_location_Y", 0); cmd.Parameters.AddWithValue("@auto_tote_2_location_X", 0); cmd.Parameters.AddWithValue("@auto_tote_2_location_Y", 0); cmd.Parameters.AddWithValue("@auto_tote_3_location_X", 0); cmd.Parameters.AddWithValue("@auto_tote_3_location_Y", 0); cmd.Parameters.AddWithValue("@auto_can_1_location_X", 0); cmd.Parameters.AddWithValue("@auto_can_1_location_Y", 0); cmd.Parameters.AddWithValue("@auto_can_2_location_X", 0); cmd.Parameters.AddWithValue("@auto_can_2_location_Y", 0); cmd.Parameters.AddWithValue("@auto_can_3_location_X", 0); cmd.Parameters.AddWithValue("@auto_can_3_location_Y", 0); cmd.Parameters.AddWithValue("@auto_can_4_location_X", 0); cmd.Parameters.AddWithValue("@auto_can_4_location_Y", 0); cmd.Parameters.AddWithValue("@auto_can_5_location_X", 0); cmd.Parameters.AddWithValue("@auto_can_5_location_Y", 0); cmd.Parameters.AddWithValue("@auto_can_6_location_X", 0); cmd.Parameters.AddWithValue("@auto_can_6_location_Y", 0); cmd.Parameters.AddWithValue("@auto_can_7_location_X", 0); cmd.Parameters.AddWithValue("@auto_can_7_location_Y", 0); cmd.Parameters.AddWithValue("@auto_robot_visible", "false"); cmd.Parameters.AddWithValue("@auto_tote1_visible", "false"); cmd.Parameters.AddWithValue("@auto_tote2_visible", "false"); cmd.Parameters.AddWithValue("@auto_tote3_visible", "false"); cmd.Parameters.AddWithValue("@auto_can1_visible", "false"); cmd.Parameters.AddWithValue("@auto_can2_visible", "false"); cmd.Parameters.AddWithValue("@auto_can3_visible", "false"); cmd.Parameters.AddWithValue("@auto_can4_visible", "false"); cmd.Parameters.AddWithValue("@auto_can5_visible", "false"); cmd.Parameters.AddWithValue("@auto_can6_visible", "false"); cmd.Parameters.AddWithValue("@auto_can7_visible", "false"); cmd.Parameters.AddWithValue("@auto_robot_stack_list", ""); cmd.Parameters.AddWithValue("@team_match_notes", ""); cmd.Parameters.AddWithValue("@tote_stacker", "false"); cmd.Parameters.AddWithValue("@can_kinger", "false"); cmd.Parameters.AddWithValue("@cooperative", "false"); cmd.Parameters.AddWithValue("@noodler", "false"); cmd.Parameters.AddWithValue("@ni", "false"); cmd.Parameters.AddWithValue("@tote_control_inside_robot", "false"); cmd.Parameters.AddWithValue("@tote_control_fork_lift", "false"); cmd.Parameters.AddWithValue("@tote_control_handle_grabber", "false"); cmd.Parameters.AddWithValue("@tote_control_drop_alot", "false"); cmd.Parameters.AddWithValue("@tote_control_great_control", "false"); cmd.Parameters.AddWithValue("@ready_to_export", "false"); for (int tm = 0; tm < teamIDs.Length; tm++) { cmd.Parameters["@tablet_id"].Value = tablet_id; cmd.Parameters["@team_id"].Value = teamIDs[tm]; cmd.Parameters["@match_id"].Value = match_id; cmd.Parameters["@competition_id"].Value = this.compID; cmd.Parameters["@alliance_position"].Value = alliancePositions[tm]; cmd.Parameters["@broke_down"].Value = "false"; cmd.Parameters["@no_move"].Value = "false"; cmd.Parameters["@lost_connection"].Value = "false"; cmd.Parameters["@starting_location"].Value = 0; cmd.Parameters["@starting_location_X"].Value = 0; cmd.Parameters["@starting_location_Y"].Value = 0; cmd.Parameters["@starting_location_on_field"].Value = 0; cmd.Parameters["@auto_totes_picked_up"].Value = 0; cmd.Parameters["@auto_totes_stacked"].Value = 0; cmd.Parameters["@auto_totes_scored"].Value = 0; cmd.Parameters["@auto_cans_picked_up"].Value = 0; cmd.Parameters["@auto_cans_scored"].Value = 0; cmd.Parameters["@auto_cans_pulled_from_step"].Value = 0; cmd.Parameters["@auto_mode_saved"].Value = "false"; cmd.Parameters["@auto_final_location_X"].Value = 0; cmd.Parameters["@auto_final_location_Y"].Value = 0; cmd.Parameters["@auto_tote_1_location_X"].Value = 0; cmd.Parameters["@auto_tote_1_location_Y"].Value = 0; cmd.Parameters["@auto_tote_2_location_X"].Value = 0; cmd.Parameters["@auto_tote_2_location_Y"].Value = 0; cmd.Parameters["@auto_tote_3_location_X"].Value = 0; cmd.Parameters["@auto_tote_3_location_Y"].Value = 0; cmd.Parameters["@auto_can_1_location_X"].Value = 0; cmd.Parameters["@auto_can_1_location_Y"].Value = 0; cmd.Parameters["@auto_can_2_location_X"].Value = 0; cmd.Parameters["@auto_can_2_location_Y"].Value = 0; cmd.Parameters["@auto_can_3_location_X"].Value = 0; cmd.Parameters["@auto_can_3_location_Y"].Value = 0; cmd.Parameters["@auto_can_4_location_X"].Value = 0; cmd.Parameters["@auto_can_4_location_Y"].Value = 0; cmd.Parameters["@auto_can_5_location_X"].Value = 0; cmd.Parameters["@auto_can_5_location_Y"].Value = 0; cmd.Parameters["@auto_can_6_location_X"].Value = 0; cmd.Parameters["@auto_can_6_location_Y"].Value = 0; cmd.Parameters["@auto_can_7_location_X"].Value = 0; cmd.Parameters["@auto_can_7_location_Y"].Value = 0; cmd.Parameters["@auto_robot_visible"].Value = "false"; cmd.Parameters["@auto_tote1_visible"].Value = "false"; cmd.Parameters["@auto_tote2_visible"].Value = "false"; cmd.Parameters["@auto_tote3_visible"].Value = "false"; cmd.Parameters["@auto_can1_visible"].Value = "false"; cmd.Parameters["@auto_can2_visible"].Value = "false"; cmd.Parameters["@auto_can3_visible"].Value = "false"; cmd.Parameters["@auto_can4_visible"].Value = "false"; cmd.Parameters["@auto_can5_visible"].Value = "false"; cmd.Parameters["@auto_can6_visible"].Value = "false"; cmd.Parameters["@auto_can7_visible"].Value = "false"; cmd.Parameters["@auto_robot_stack_list"].Value = "none"; cmd.Parameters["@team_match_notes"].Value = "none"; cmd.Parameters["@tote_stacker"].Value = "false"; cmd.Parameters["@can_kinger"].Value = "false"; cmd.Parameters["@cooperative"].Value = "false"; cmd.Parameters["@noodler"].Value = "false"; cmd.Parameters["@ni"].Value = "false"; cmd.Parameters["@tote_control_inside_robot"].Value = "false"; cmd.Parameters["@tote_control_fork_lift"].Value = "false"; cmd.Parameters["@tote_control_handle_grabber"].Value = "false"; cmd.Parameters["@tote_control_drop_alot"].Value = "false"; cmd.Parameters["@tote_control_great_control"].Value = "false"; cmd.Parameters["@ready_to_export"].Value = "false"; cmd.ExecuteNonQuery(); } } catch (Exception) { saved = false; lblStatus.Text = "Failed to save data, check that database is active, and verify data is entered correctly"; //throw; } finally { if (connection.State == System.Data.ConnectionState.Open) { connection.Close(); } } } if (saved) { if (exit) { MatchListForm formObj = (MatchListForm)Application.OpenForms["Form1"]; formObj.LoadData(); this.Close(); } else { txtMatchNumber.Text = ""; txtMatchTime.Text = ""; txtMatchType.Text = "Qualification"; txtMatchLocation.Text = "Auburn"; cmbBlue1.Text = ""; cmbBlue2.Text = ""; cmbBlue3.Text = ""; cmbRed1.Text = ""; cmbRed2.Text = ""; cmbRed3.Text = ""; } } }