private void listAgeDivisionsComboBox_SelectedIndexChanged(object sender, EventArgs e) { if (listAgeDivisionsComboBox.SelectedValue != null) { String curAgeGroup = listAgeDivisionsComboBox.SelectedValue.ToString(); String myFilterCommand = "AgeGroup = '" + curAgeGroup + "'"; dataGridView.Rows.Clear(); DataGridViewRow curViewRow; int curIdx = 0; DataRow[] curFindRows = myNopsDataTable.Select(myFilterCommand); foreach (DataRow curDataRow in curFindRows) { curIdx = dataGridView.Rows.Add(); curViewRow = dataGridView.Rows[curIdx]; //N.PK, SkiYear, Event, AgeGroup, V.SortSeq as SortSeqDiv, N.SortSeq, Base, Adj, RatingOpen, RatingRec, RatingMedian, OverallBase, OverallExp, EventsReqd curViewRow.Cells["Event"].Value = (String)curDataRow["Event"]; curViewRow.Cells["AgeGroup"].Value = (String)curDataRow["AgeGroup"]; curViewRow.Cells["RatingRec"].Value = ((Decimal)curDataRow["RatingRec"]).ToString("####0.00"); curViewRow.Cells["RatingMedian"].Value = ((Decimal)curDataRow["RatingMedian"]).ToString("####0.00"); curViewRow.Cells["Base"].Value = ((Decimal)curDataRow["Base"]).ToString("#####0"); curViewRow.Cells["Adj"].Value = ((Decimal)curDataRow["Adj"]).ToString("##0.00"); curViewRow.Cells["OverallBase"].Value = ((Decimal)curDataRow["OverallBase"]).ToString("##0"); curViewRow.Cells["OverallExp"].Value = ((Decimal)curDataRow["OverallExp"]).ToString("#.000"); curViewRow.Cells["EventsReqd"].Value = (byte)curDataRow["EventsReqd"]; } if (ScoreList[idxSlalom].Score > 0 || ScoreList[idxTrick].Score > 0 || ScoreList[idxJump].Score > 0) { appNopsCalc.calcNops(listAgeDivisionsComboBox.SelectedValue.ToString(), ScoreList); Nops1.Text = Math.Round(ScoreList[idxSlalom].Nops, 1).ToString(); Nops2.Text = Math.Round(ScoreList[idxTrick].Nops, 1).ToString(); Nops3.Text = Math.Round(ScoreList[idxJump].Nops, 1).ToString(); Nops4.Text = Math.Round(ScoreList[idxOverall].Nops, 1).ToString(); if (ScoreList[idxSlalom].Score > 0) { calcSlalomScoreText(ScoreList[idxSlalom].Score, curAgeGroup); } } } }
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); }