public void showClassChangeWindow(DataRow inTourRow, String inEvent) { String curListCode = ""; String curListValue = ""; RadioButtonWithValue curRadioButton; int curItemLoc = 15; int curItemSize = 0; myTourRules = (String)inTourRow["Rules"]; myTourClass = (String)inTourRow["Class"]; mySanctionNum = (String)inTourRow["SanctionId"]; myCopyFromClass = myTourClass; myCopyToClass = myTourClass; mySkierClassList = new ListSkierClass(); mySkierClassList.ListSkierClassLoad(); curRadioButton = new RadioButtonWithValue(); curRadioButton.Parent = FromClassGroupBox; curRadioButton.AutoSize = true; curRadioButton.Location = new System.Drawing.Point(15, curItemLoc); curRadioButton.Name = "All"; curRadioButton.Size = new System.Drawing.Size(curItemSize, 15); curRadioButton.TabIndex = 0; curRadioButton.TabStop = true; curRadioButton.Text = "All"; curRadioButton.UseVisualStyleBackColor = true; curRadioButton.Value = "All"; curItemLoc += 17; curRadioButton.Click += new System.EventHandler(radioButtonFrom_Click); FromClassGroupBox.Controls.Add(curRadioButton); foreach (ListItem curEntry in mySkierClassList.DropdownList) { curListCode = (String)curEntry.ItemName; curListValue = (String)curEntry.ItemValue; curItemSize = curListValue.Length * 8; curRadioButton = new RadioButtonWithValue(); curRadioButton.Parent = FromClassGroupBox; curRadioButton.AutoSize = true; curRadioButton.Location = new System.Drawing.Point(15, curItemLoc); curRadioButton.Name = curListValue; curRadioButton.Size = new System.Drawing.Size(curItemSize, 15); curRadioButton.TabIndex = 0; curRadioButton.TabStop = true; curRadioButton.Text = curListCode; curRadioButton.UseVisualStyleBackColor = true; curRadioButton.Value = curListValue; if (curListValue.ToLower().Equals(myTourClass.ToLower())) { curRadioButton.Checked = true; } curItemLoc += 17; curRadioButton.Click += new System.EventHandler(radioButtonFrom_Click); FromClassGroupBox.Controls.Add(curRadioButton); } curItemLoc = 15; foreach (ListItem curEntry in mySkierClassList.DropdownList) { curListCode = (String)curEntry.ItemName; curListValue = (String)curEntry.ItemValue; curItemSize = curListValue.Length * 8; curRadioButton = new RadioButtonWithValue(); curRadioButton.Parent = ToClassGroupBox; curRadioButton.AutoSize = true; curRadioButton.Location = new System.Drawing.Point(15, curItemLoc); curRadioButton.Name = curListValue; curRadioButton.Size = new System.Drawing.Size(curItemSize, 15); curRadioButton.TabIndex = 0; curRadioButton.TabStop = true; curRadioButton.Text = curListCode; curRadioButton.UseVisualStyleBackColor = true; curRadioButton.Value = curListValue; if (curListValue.ToLower().Equals(myTourClass.ToLower())) { curRadioButton.Checked = true; } curItemLoc += 17; curRadioButton.Click += new System.EventHandler(radioButtonTo_Click); ToClassGroupBox.Controls.Add(curRadioButton); loadEventGroupList(); } }
public Boolean exportBoatTimes(String inSanctionId) { Boolean returnStatus = false; Int16 curSanctionYear = 0; char DoubleQuote = '"'; String curMemberId = "", curTourClass = "", curEventDateOut = "", curRunTime = ""; StringBuilder outLine = new StringBuilder(""); StreamWriter outBuffer = null; myProgressInfo = new ProgressWindow(); DataTable curTourDataTable = getTourData(inSanctionId); if (curTourDataTable != null) { if (curTourDataTable.Rows.Count > 0) { curSanctionYear = Convert.ToInt16(inSanctionId.Substring(0, 2)); myTourRow = curTourDataTable.Rows[0]; curTourClass = myTourRow["Class"].ToString().Trim(); String curFilename = inSanctionId.Trim() + "JT.csv"; outBuffer = getExportFile(curFilename); curEventDateOut = myTourRow["EventDates"].ToString(); if (curEventDateOut.Length > 7) { try { DateTime curEventDate = Convert.ToDateTime(curEventDateOut); curEventDateOut = curEventDate.ToString("yyyyMMdd"); } catch { curEventDateOut = ""; } } else { curEventDateOut = ""; } mySkierClassList = new ListSkierClass(); mySkierClassList.ListSkierClassLoad(); myTourClass = myTourRow["Class"].ToString().ToUpper(); myClassCRow = mySkierClassList.SkierClassDataTable.Select("ListCode = 'C'")[0]; myClassERow = mySkierClassList.SkierClassDataTable.Select("ListCode = 'E'")[0]; } } Decimal curSplitTime30M, curSplitTime52M, curSplitTime82M, curBoatEndTime, curScoreMeters, curScoreFeet; Decimal curActualSeg52m, curActualSeg30m, curActualSeg41m, curActualSeg82m; String curResults, curTimeClass; if (outBuffer != null) { outLine.Append("Sanction"); outLine.Append(", Skier Class"); outLine.Append(", Boat"); outLine.Append(", EventDate"); outLine.Append(", Time"); outLine.Append(", SkierName"); outLine.Append(", Div"); outLine.Append(", Pass"); outLine.Append(", Speed"); outLine.Append(", Meters"); outLine.Append(", Feet"); outLine.Append(", Time30M"); outLine.Append(", Time52M"); outLine.Append(", Time82M"); outLine.Append(", Time41M"); outLine.Append(", Actual30M"); outLine.Append(", Actual52M"); outLine.Append(", Actual82M"); outLine.Append(", Actual41M"); //Write output line to file outBuffer.WriteLine(outLine.ToString()); outLine = new StringBuilder(""); myProgressInfo.setProgessMsg("Export jump boat times "); myProgressInfo.Show(); myProgressInfo.Refresh(); int curRowCount = 0; DataTable curBoatTimeResults = getBoatTimeResults(inSanctionId); myProgressInfo.setProgressMax(curBoatTimeResults.Rows.Count); if (curBoatTimeResults != null) { foreach (DataRow curRow in curBoatTimeResults.Rows) { curRowCount++; myProgressInfo.setProgressValue(curRowCount); myProgressInfo.Refresh(); curTimeClass = getTimeClass((String)curRow["EventClass"]); curResults = (String)curRow["Results"]; try { curSplitTime52M = (Decimal)curRow["BoatSplitTime"]; } catch { curSplitTime52M = 0; } try { curSplitTime82M = (Decimal)curRow["BoatSplitTime2"]; } catch { curSplitTime82M = 0; } try { curSplitTime30M = curSplitTime82M - curSplitTime52M; } catch { curSplitTime30M = 0; } try { curBoatEndTime = ((Decimal)curRow["BoatEndTime"]); } catch { curBoatEndTime = 0; } try { curScoreMeters = ((Decimal)curRow["ScoreMeters"]); } catch { curScoreMeters = 0; } try { curScoreFeet = ((Decimal)curRow["ScoreFeet"]); } catch { curScoreFeet = 0; } if (curTimeClass.Equals("R")) { try { curActualSeg52m = Convert.ToDecimal((String)curRow["ActualTime52mSeg"]); } catch { curActualSeg52m = 0; } try { curActualSeg41m = Convert.ToDecimal((String)curRow["ActualTime41mSeg"]); } catch { curActualSeg41m = 0; } try { curActualSeg82m = Convert.ToDecimal((String)curRow["ActualTime82mSeg"]); } catch { curActualSeg82m = 0; } } else { try { curActualSeg52m = Convert.ToDecimal((String)curRow["ActualTime52mSegR"]); } catch { curActualSeg52m = 0; } try { curActualSeg41m = Convert.ToDecimal((String)curRow["ActualTime41mSegR"]); } catch { curActualSeg41m = 0; } try { curActualSeg82m = Convert.ToDecimal((String)curRow["ActualTime82mSegR"]); } catch { curActualSeg82m = 0; } } try { curActualSeg30m = curActualSeg82m - curActualSeg52m; } catch { curActualSeg30m = 0; } try { curRunTime = ((DateTime)curRow["LastUpdateDate"]).ToString("hhmm"); } catch { curRunTime = "0000"; } outLine.Append(DoubleQuote.ToString() + inSanctionId + curTourClass + DoubleQuote.ToString()); // 1. (7) SanctionId with class outLine.Append("," + DoubleQuote.ToString() + curRow["EventClass"].ToString() + DoubleQuote.ToString()); // 2. (1) Skier Class outLine.Append("," + DoubleQuote.ToString() + curRow["Boat"].ToString().PadRight(11, ' ') + DoubleQuote.ToString()); // 3. (11) Boat outLine.Append("," + DoubleQuote.ToString() + curEventDateOut + DoubleQuote.ToString()); // 4. (8) Date YYYYMMDD outLine.Append("," + DoubleQuote.ToString() + curRunTime + DoubleQuote.ToString()); // 5. (4) Time HHMM outLine.Append("," + DoubleQuote.ToString() + curRow["SkierName"].ToString().PadRight(22, ' ') + DoubleQuote.ToString()); // 6. (22) Skier Name outLine.Append("," + DoubleQuote.ToString() + curRow["AgeGroup"].ToString() + DoubleQuote.ToString()); // 7. (2) Age Division outLine.Append("," + DoubleQuote.ToString() + ((byte)curRow["PassNum"]).ToString("#0").PadLeft(2, ' ') + DoubleQuote.ToString()); // 8. (2) Pass Number outLine.Append("," + DoubleQuote.ToString() + ((byte)curRow["BoatSpeed"]).ToString("00") + DoubleQuote.ToString()); // 9. (2) Boat Speed KM if (curResults.ToUpper().Equals("JUMP")) { outLine.Append("," + DoubleQuote.ToString() + curScoreMeters.ToString("#0.0").PadLeft(4, ' ') + DoubleQuote.ToString()); //10. (4) Distance in Meters outLine.Append("," + DoubleQuote.ToString() + curScoreFeet.ToString("#00").PadLeft(3, ' ') + DoubleQuote.ToString()); //11. (3) Distance in Feet } else { outLine.Append("," + DoubleQuote.ToString() + curResults.ToUpper() + DoubleQuote.ToString()); //10. (4) Distance in Meters outLine.Append("," + DoubleQuote.ToString() + " " + DoubleQuote.ToString()); //11. (3) Distance in Feet } outLine.Append(", " + curSplitTime30M.ToString("0.00")); //12. (4 Num) 1st segment 30M Time outLine.Append(", " + curSplitTime52M.ToString("0.00")); //13. (4 Num) 2nd segment 52M Time outLine.Append(", " + curSplitTime82M.ToString("0.00")); //14. (4 Num) 1st & 2nd segment 82M Time outLine.Append(", " + curBoatEndTime.ToString("0.00")); //15. (4 Num) 3rd segment 41M Time outLine.Append(", " + curActualSeg52m.ToString("0.00")); //16. (4 Num) 1st segment 30M Actual outLine.Append(", " + curActualSeg30m.ToString("0.00")); //17. (4 Num) 2nd segment 52M Actual outLine.Append(", " + curActualSeg82m.ToString("0.00")); //18. (4 Num) 1st & 2nd segment 82M Actual outLine.Append(", " + curActualSeg41m.ToString("0.00")); //19. (4 Num) 3rd segment 41M Actual //Write output line to file outBuffer.WriteLine(outLine.ToString()); //Initialize output buffer outLine = new StringBuilder(""); } myProgressInfo.Close(); } returnStatus = true; outBuffer.Close(); if (curBoatTimeResults.Rows.Count > 0) { MessageBox.Show(curBoatTimeResults.Rows.Count + " rows found and written"); } else { MessageBox.Show("No rows found"); } } return(returnStatus); }
private void TourDivOrder_Load(object sender, EventArgs e) { if (Properties.Settings.Default.DivOrder_Width > 0) { this.Width = Properties.Settings.Default.DivOrder_Width; } if (Properties.Settings.Default.DivOrder_Height > 0) { this.Height = Properties.Settings.Default.DivOrder_Height; } if (Properties.Settings.Default.DivOrder_Location.X > 0 && Properties.Settings.Default.DivOrder_Location.Y > 0) { this.Location = Properties.Settings.Default.DivOrder_Location; } mySanctionNum = Properties.Settings.Default.AppSanctionNum; if (mySanctionNum == null) { MessageBox.Show("An active tournament must be selected from the Administration menu Tournament List option"); //this.Close(); } else { if (mySanctionNum.Length < 6) { MessageBox.Show("An active tournament must be selected from the Administration menu Tournament List option"); //this.Close(); } else { //Retrieve selected tournament attributes DataTable curTourDataTable = getTourData(); if (curTourDataTable.Rows.Count > 0) { myTourRow = curTourDataTable.Rows[0]; myTourRules = (String)myTourRow["Rules"]; mySkierClass = myTourRow["Class"].ToString(); mySkierClassList = new ListSkierClass(); mySkierClassList.ListSkierClassLoad(); if (myTourRow["SlalomRounds"] == DBNull.Value) { myTourRow["SlalomRounds"] = 0; } if (myTourRow["TrickRounds"] == DBNull.Value) { myTourRow["TrickRounds"] = 0; } if (myTourRow["JumpRounds"] == DBNull.Value) { myTourRow["JumpRounds"] = 0; } if (Convert.ToInt16(myTourRow["SlalomRounds"]) == 0) { slalomButton.Visible = false; } if (Convert.ToInt16(myTourRow["TrickRounds"]) == 0) { trickButton.Visible = false; } if (Convert.ToInt16(myTourRow["JumpRounds"]) == 0) { jumpButton.Visible = false; } if (slalomButton.Visible) { slalomButton.Checked = true; } else if (trickButton.Visible) { trickButton.Checked = true; } else if (jumpButton.Visible) { jumpButton.Checked = true; } myTourDivDataTable = getTourDivData(); loadDataView(); } else { MessageBox.Show("An active tournament must be selected from the Administration menu Tournament List option"); } } } isDataModified = false; }
public Boolean exportBoatTimes(String inSanctionId) { Boolean returnStatus = false, curActiveTour = false; char DoubleQuote = '"'; String curMemberId = "", curEventDateOut = ""; StringBuilder outLine = new StringBuilder(""); StreamWriter outBuffer = null; myProgressInfo = new ProgressWindow(); DataTable curTourDataTable = getTourData(inSanctionId); if (curTourDataTable != null) { if (curTourDataTable.Rows.Count > 0) { curActiveTour = true; myTourRow = curTourDataTable.Rows[0]; myTourClass = myTourRow["Class"].ToString().ToUpper(); String curFilename = inSanctionId.Trim() + "ST.csv"; outBuffer = getExportFile(curFilename); curEventDateOut = myTourRow["EventDates"].ToString(); if (curEventDateOut.Length > 7) { try { DateTime curEventDate = Convert.ToDateTime(curEventDateOut); curEventDateOut = curEventDate.ToString("yyyyMMdd"); } catch { curEventDateOut = ""; } } else { curEventDateOut = ""; } } } if (curActiveTour) { StringBuilder curSqlStmt = new StringBuilder(""); curSqlStmt.Append("SELECT ListCode, ListCodeNum, SortSeq, CodeValue, MinValue, MaxValue, CodeDesc "); curSqlStmt.Append("FROM CodeValueList WHERE ListName = 'SlalomBoatTime' ORDER BY SortSeq"); myTimesDataTable = getData(curSqlStmt.ToString()); mySkierClassList = new ListSkierClass(); mySkierClassList.ListSkierClassLoad(); myClassCRow = mySkierClassList.SkierClassDataTable.Select("ListCode = 'C'")[0]; myClassERow = mySkierClassList.SkierClassDataTable.Select("ListCode = 'E'")[0]; DataTable curSpeedByPassDataTable; Int16 curMaxSpeed, curPassNum, curRound; Decimal curBoatTime, curScore, curSpeed, curActualTime; String curSpeedDesc, curTimeKey, curTimeKeyScore, curEventClass, curRunTime; DataRow[] curTimeRowsFound; if (outBuffer != null) { outLine.Append("Sanction"); outLine.Append(", Skier Class"); outLine.Append(", Boat"); outLine.Append(", EventDate"); outLine.Append(", Time"); outLine.Append(", SkierName"); outLine.Append(", Div"); outLine.Append(", MaxSpeed"); outLine.Append(", Round"); outLine.Append(", PassNum"); outLine.Append(", PassDesc"); outLine.Append(", PassScore"); outLine.Append(", BoatTime"); outLine.Append(", ActualTime"); //Write output line to file outBuffer.WriteLine(outLine.ToString()); outLine = new StringBuilder(""); myProgressInfo.setProgessMsg("Export slalom boat times "); myProgressInfo.Show(); myProgressInfo.Refresh(); int curRowCount = 0; DataTable curBoatTimeResults = getBoatTimeResults(inSanctionId); if (curBoatTimeResults != null) { myProgressInfo.setProgressMax(curBoatTimeResults.Rows.Count); foreach (DataRow curRow in curBoatTimeResults.Rows) { curRowCount++; myProgressInfo.setProgressValue(curRowCount); myProgressInfo.Refresh(); try { curBoatTime = (Decimal)curRow["BoatTime"]; } catch { curBoatTime = 0; } try { curScore = ((Decimal)curRow["PassScore"]); } catch { curScore = 0; } try { curRound = ((Byte)curRow["Round"]); } catch { curRound = 0; } try { curPassNum = ((Byte)curRow["PassNum"]); } catch { curPassNum = 0; } try { curEventClass = ((String)curRow["EventClass"]); } catch { curEventClass = ""; } try { curRunTime = ((DateTime)curRow["LastUpdateDate"]).ToString("hhmm"); } catch { curRunTime = "0000"; } try { curMaxSpeed = ((Byte)curRow["MaxSpeed"]); curSpeedByPassDataTable = getSpeedByPass(curMaxSpeed, curPassNum); if (curSpeedByPassDataTable.Rows.Count > 0) { curSpeedDesc = (String)curSpeedByPassDataTable.Rows[0]["CodeValue"]; curSpeed = (Decimal)curSpeedByPassDataTable.Rows[0]["MaxValue"]; curTimeKeyScore = curScore.ToString("0.00"); curTimeKey = curSpeed.ToString("00") + "-" + getTimeClass(curEventClass) + "-" + curTimeKeyScore.Substring(0, 1); curTimeRowsFound = myTimesDataTable.Select("ListCode = '" + curTimeKey + "'"); if (curTimeRowsFound.Length > 0) { myTimeRow = curTimeRowsFound[0]; } else { myTimeRow = null; } curActualTime = Convert.ToDecimal((String)myTimeRow["CodeValue"]); } else { curSpeed = 0; curActualTime = 0; curSpeedDesc = ""; myTimeRow = null; } } catch { curActualTime = 0; curSpeed = 0; curMaxSpeed = 0; curSpeedDesc = ""; myTimeRow = null; } outLine.Append(DoubleQuote.ToString() + inSanctionId + myTourClass + DoubleQuote.ToString()); // 1. (7) SanctionId with class outLine.Append("," + DoubleQuote.ToString() + curRow["EventClass"].ToString() + DoubleQuote.ToString()); // 2. (1) Skier Class outLine.Append("," + DoubleQuote.ToString() + curRow["Boat"].ToString().PadRight(11, ' ') + DoubleQuote.ToString()); // 3. (11) Boat outLine.Append("," + DoubleQuote.ToString() + curEventDateOut + DoubleQuote.ToString()); // 4. (8) Date YYYYMMDD outLine.Append("," + DoubleQuote.ToString() + curRunTime + DoubleQuote.ToString()); // 5. (4) Time HHMM outLine.Append("," + DoubleQuote.ToString() + curRow["SkierName"].ToString().PadRight(22, ' ') + DoubleQuote.ToString()); // 6. (22) Skier Name outLine.Append("," + DoubleQuote.ToString() + curRow["AgeGroup"].ToString() + DoubleQuote.ToString()); // 7. (2) Age Division outLine.Append("," + DoubleQuote.ToString() + curMaxSpeed.ToString("#0").PadLeft(2, ' ') + DoubleQuote.ToString()); // 8. (2) Max Speed for division outLine.Append("," + DoubleQuote.ToString() + curRound.ToString("#0").PadLeft(2, ' ') + DoubleQuote.ToString()); // 9. (2) Round outLine.Append("," + DoubleQuote.ToString() + curPassNum.ToString("#0").PadLeft(2, ' ') + DoubleQuote.ToString()); // 10. (2) Pass Number outLine.Append("," + DoubleQuote.ToString() + curSpeedDesc.PadRight(28, ' ') + DoubleQuote.ToString()); // 11. (28) Boat Speed Desc outLine.Append("," + DoubleQuote.ToString() + curScore.ToString("#.00").PadLeft(4, ' ') + DoubleQuote.ToString()); //10. (4) Score for Pass outLine.Append("," + curBoatTime.ToString("##.00")); //12. (5 Num) Boat Time outLine.Append("," + curActualTime.ToString("##.00")); //13. (5 Num) Actual Time //Write output line to file outBuffer.WriteLine(outLine.ToString()); //Initialize output buffer outLine = new StringBuilder(""); } myProgressInfo.Close(); } returnStatus = true; outBuffer.Close(); if (curBoatTimeResults.Rows.Count > 0) { MessageBox.Show(curBoatTimeResults.Rows.Count + " rows found and written"); } else { MessageBox.Show("No rows found"); } } } return(returnStatus); }