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);
}
