public NopsCalcForm() { InitializeComponent(); appNopsCalc = CalcNops.Instance; appNopsCalc.LoadDataForTour(); myNopsDataTable = appNopsCalc.NopsDataTable; //dataGridView.DataSource = myNopsDataTable; //N.PK, SkiYear, Event, AgeGroup, V.SortSeq as SortSeqDiv, N.SortSeq, Base, Adj, RatingOpen, RatingRec, RatingMedian, OverallBase, OverallExp, EventsReqd //dataGridView.Columns["PK"].Visible = false; ScoreList.Add(new ScoreEntry("Slalom", 0, "", 0)); ScoreList.Add(new ScoreEntry("Trick", 0, "", 0)); ScoreList.Add(new ScoreEntry("Jump", 0, "", 0)); ScoreList.Add(new ScoreEntry("Overall", 0, "", 0)); Event1.Text = ScoreList[0].Event + ": "; Score1.Text = Convert.ToString(ScoreList[0].Score); Nops1.Text = Convert.ToString(ScoreList[0].Nops); Event2.Text = ScoreList[1].Event + ": "; Score2.Text = Convert.ToString(ScoreList[1].Score); Nops2.Text = Convert.ToString(ScoreList[1].Nops); Event3.Text = ScoreList[2].Event + ": "; Score3.Text = Convert.ToString(ScoreList[2].Score); Nops3.Text = Convert.ToString(ScoreList[2].Nops); Event4.Text = ScoreList[3].Event + ": "; Nops4.Text = Convert.ToString(ScoreList[3].Nops); }
private bool execUpdateNops() { //Update NOPS values due to unavailable 2014 NOPS tables //Prior to version 1.0.1.82 bool curReturnValue = true; SqlCeCommand sqlStmt = null; SqlCeConnection myDbConn = null; DataTable myDataTable = new DataTable(); StringBuilder curSqlStmt = new StringBuilder(); List <Common.ScoreEntry> curScoreList = new List <Common.ScoreEntry>(); int rowsProc, rowUpdateCount = 0; try { myDbConn = new global::System.Data.SqlServerCe.SqlCeConnection(); myDbConn.ConnectionString = Properties.Settings.Default.waterskiConnectionStringApp; myDbConn.Open(); sqlStmt = myDbConn.CreateCommand(); myNopsCalc = CalcNops.Instance; myNopsCalc.LoadDataForTour(); curScoreList.Add(new Common.ScoreEntry("Trick", 0, "", 0)); curSqlStmt = new StringBuilder(); curSqlStmt.Append("Select PK, SanctionId, MemberId, AgeGroup, Score, Round "); curSqlStmt.Append("From TrickScore "); curSqlStmt.Append("Where SanctionId = '" + mySanctionNum + "' "); curSqlStmt.Append("Order by AgeGroup, MemberId, Round "); myDataTable = getData(curSqlStmt.ToString()); rowUpdateCount = 0; foreach (DataRow curRow in myDataTable.Rows) { try { curScoreList[0].Nops = 0; curScoreList[0].Score = Convert.ToDecimal((Int16)curRow["Score"]); myNopsCalc.calcNops((String)curRow["AgeGroup"], curScoreList); sqlStmt.CommandText = "Update TrickScore " + "SET NopsScore = " + Math.Round(curScoreList[0].Nops, 1).ToString() + " " + "WHERE PK = " + (Int64)curRow["PK"] + " And NopsScore != " + Math.Round(curScoreList[0].Nops, 1).ToString() + " "; rowsProc = sqlStmt.ExecuteNonQuery(); rowUpdateCount += rowsProc; if (rowsProc == 0) { //MessageBox.Show( "Record for " + (String)curRow["MemberId"] + " not updated \nCalculated value is " + Math.Round( curScoreList[0].Nops, 1 ).ToString() ); } } catch (Exception ex) { String ExcpMsg = ex.Message; if (sqlStmt != null) { ExcpMsg += "\n" + sqlStmt.CommandText; } MessageBox.Show("Error updating trick NOPS " + "\n\nError: " + ExcpMsg); curReturnValue = false; } } MessageBox.Show(myDataTable.Rows.Count.ToString() + " Trick scores read" + "\nTrick NOPS scores updated = " + rowUpdateCount.ToString() + "\nNote: Records with no change in score were bypassed"); curScoreList[0].Event = "Jump"; curSqlStmt = new StringBuilder(); curSqlStmt.Append("Select PK, SanctionId, MemberId, AgeGroup, ScoreFeet, Round "); curSqlStmt.Append("From JumpScore "); curSqlStmt.Append("Where SanctionId = '" + mySanctionNum + "' "); curSqlStmt.Append("Order by AgeGroup, MemberId, Round "); myDataTable = getData(curSqlStmt.ToString()); rowUpdateCount = 0; foreach (DataRow curRow in myDataTable.Rows) { try { curScoreList[0].Nops = 0; curScoreList[0].Score = (Decimal)curRow["ScoreFeet"]; myNopsCalc.calcNops((String)curRow["AgeGroup"], curScoreList); sqlStmt.CommandText = "Update JumpScore " + "SET NopsScore = " + Math.Round(curScoreList[0].Nops, 1).ToString() + " " + "WHERE PK = " + (Int64)curRow["PK"] + " And NopsScore != " + Math.Round(curScoreList[0].Nops, 1).ToString() + " "; rowsProc = sqlStmt.ExecuteNonQuery(); rowUpdateCount += rowsProc; if (rowsProc == 0) { //MessageBox.Show( "Record for " + (String)curRow["MemberId"] + " not updated \nCalculated value is " + Math.Round( curScoreList[0].Nops, 1 ).ToString() ); } } catch (Exception ex) { String ExcpMsg = ex.Message; if (sqlStmt != null) { ExcpMsg += "\n" + sqlStmt.CommandText; } MessageBox.Show("Error updating jump NOPS \n\nError: " + ExcpMsg); curReturnValue = false; } } MessageBox.Show(myDataTable.Rows.Count.ToString() + " Jump scores read" + "\nJump NOPS scores updated = " + rowUpdateCount.ToString() + "\nNote: Records with no change in score were bypassed"); curScoreList[0].Event = "Slalom"; curSqlStmt = new StringBuilder(); curSqlStmt.Append("Select PK, SanctionId, MemberId, AgeGroup, Score, Round "); curSqlStmt.Append("From SlalomScore "); curSqlStmt.Append("Where SanctionId = '" + mySanctionNum + "' "); curSqlStmt.Append("Order by AgeGroup, MemberId, Round "); myDataTable = getData(curSqlStmt.ToString()); rowUpdateCount = 0; foreach (DataRow curRow in myDataTable.Rows) { try { curScoreList[0].Nops = 0; curScoreList[0].Score = (Decimal)curRow["Score"]; myNopsCalc.calcNops((String)curRow["AgeGroup"], curScoreList); sqlStmt.CommandText = "Update SlalomScore " + "SET NopsScore = " + Math.Round(curScoreList[0].Nops, 1).ToString() + " " + "WHERE PK = " + (Int64)curRow["PK"] + " And NopsScore != " + Math.Round(curScoreList[0].Nops, 1).ToString() + " "; rowsProc = sqlStmt.ExecuteNonQuery(); rowUpdateCount += rowsProc; if (rowsProc == 0) { //MessageBox.Show( "Record for " + (String)curRow["MemberId"] + " not updated \nCalculated value is " + Math.Round( curScoreList[0].Nops, 1 ).ToString() ); } } catch (Exception ex) { String ExcpMsg = ex.Message; if (sqlStmt != null) { ExcpMsg += "\n" + sqlStmt.CommandText; } MessageBox.Show("Error updating Slalom NOPS \n\nError: " + ExcpMsg); curReturnValue = false; } } MessageBox.Show(myDataTable.Rows.Count.ToString() + " Slalom scores read" + "\nSlalom NOPS scores updated = " + rowUpdateCount.ToString() + "\nNote: Records with no change in score were bypassed"); } catch (Exception excp) { String curMsg = ":Error attempting to update 2015 Nops values \n" + excp.Message; MessageBox.Show(curMsg); curReturnValue = false; } finally { myDbConn.Close(); } return(curReturnValue); }