public ExportScoreBook()
{
// Retrieve data from database
mySanctionNum = Properties.Settings.Default.AppSanctionNum;
if ( mySanctionNum == null ) {
MessageBox.Show( "An active tournament must be selected from the Administration menu Tournament List option" );
} else {
if ( mySanctionNum.Length < 6 ) {
MessageBox.Show( "An active tournament must be selected from the Administration menu Tournament List option" );
} else {
CalcScoreSummary curCalcSummary = new CalcScoreSummary();
mySkierClassList = new ListSkierClass();
mySkierClassList.ListSkierClassLoad();
DataTable curTourDataTable = getTourData( mySanctionNum );
if ( curTourDataTable.Rows.Count > 0 ) {
myTourRow = curTourDataTable.Rows[0];
myTourRules = (String)myTourRow["Rules"];
myTourClass = myTourRow["Class"].ToString().Trim();
int curSlalomRounds = 0, curTrickRounds = 0, curJumpRounds = 0;
try {
curSlalomRounds = Convert.ToInt16( myTourRow["SlalomRounds"].ToString() );
} catch {
curSlalomRounds = 0;
}
try {
curTrickRounds = Convert.ToInt16( myTourRow["TrickRounds"].ToString() );
} catch {
curTrickRounds = 0;
}
try {
curJumpRounds = Convert.ToInt16( myTourRow["JumpRounds"].ToString() );
} catch {
curJumpRounds = 0;
}
if ( curSlalomRounds > myTourRounds ) { myTourRounds = curSlalomRounds; }
if ( curTrickRounds > myTourRounds ) { myTourRounds = curTrickRounds; }
if ( curJumpRounds > myTourRounds ) { myTourRounds = curJumpRounds; }
if ( myTourRounds == 1 ) { myTourRounds = 2; }
}
}
}
}
//Constructor
public TourEventReg()
{
getTourInfo();
mySkierClassList = new ListSkierClass();
mySkierClassList.ListSkierClassLoad();
myMatchCommand = "";
myMatchCommandPrev = "";
myMatchDialog = new ImportMatchDialogForm();
if ( myTourRow == null ) {
myAgeDivList = new AgeGroupDropdownList();
} else {
String curRules = (String)myTourRow["Rules"];
myAgeDivList = new AgeGroupDropdownList( myTourRow );
}
}
public Boolean exportBoatTimes( String inSanctionId )
{
String curMethodName = "exportBoatTimes";
Boolean returnStatus = false;
Int16 curRowCountSlalom = 0, curRowCountJump = 0;
StreamWriter outBuffer = null;
try {
DataTable curTourDataTable = getTourData( inSanctionId );
if ( curTourDataTable != null ) {
if ( curTourDataTable.Rows.Count > 0 ) {
myTourRow = curTourDataTable.Rows[0];
String curFilename = inSanctionId.Trim() + "BT.prn";
outBuffer = getExportFile( curFilename );
}
returnStatus = true;
}
if ( outBuffer != null ) {
mySkierClassList = new ListSkierClass();
mySkierClassList.ListSkierClassLoad();
myTourClass = myTourRow["Class"].ToString().ToUpper();
myClassCRow = mySkierClassList.SkierClassDataTable.Select("ListCode = 'C'")[0];
myClassERow = mySkierClassList.SkierClassDataTable.Select("ListCode = 'E'")[0];
curRowCountJump = exportBoatTimesJump( inSanctionId, outBuffer );
StringBuilder outLine = new StringBuilder( Environment.NewLine );
outBuffer.WriteLine( outLine.ToString() );
curRowCountSlalom = exportBoatTimesSlalom( inSanctionId, outBuffer );
outBuffer.Close();
MessageBox.Show( curRowCountJump + " jump rows found and written"
+ "\n" + curRowCountSlalom + " slalom rows found and written" );
}
} catch ( Exception ex ) {
MessageBox.Show( "Error: " + curMethodName
+ "\n\nException: " + ex.Message
);
}
return returnStatus;
}
private void ScoreEntry_Load(object sender, EventArgs e)
{
if (Properties.Settings.Default.SlalomEntry_Width > 0) {
this.Width = Properties.Settings.Default.SlalomEntry_Width;
}
if (Properties.Settings.Default.SlalomEntry_Height > 0) {
this.Height = Properties.Settings.Default.SlalomEntry_Height;
}
if (Properties.Settings.Default.SlalomEntry_Location.X > 0
&& Properties.Settings.Default.SlalomEntry_Location.Y > 0) {
this.Location = Properties.Settings.Default.SlalomEntry_Location;
}
myTourProperties = TourProperties.Instance;
mySortCommand = myTourProperties.RunningOrderSortSlalom;
int curDelim = mySortCommand.IndexOf( "AgeGroup" );
if (curDelim < 0) {
} else if (curDelim > 0) {
mySortCommand = mySortCommand.Substring( 0, curDelim ) + "DivOrder" + mySortCommand.Substring( curDelim + "AgeGroup".Length );
myTourProperties.RunningOrderSortSlalom = mySortCommand;
} else {
mySortCommand = "DivOrder" + mySortCommand.Substring( "AgeGroup".Length );
myTourProperties.RunningOrderSortSlalom = mySortCommand;
}
ResizeNarrow.Visible = false;
ResizeNarrow.Enabled = false;
ResizeWide.Visible = true;
ResizeWide.Enabled = true;
ResizeNarrow.Location = ResizeWide.Location;
EventDelayReasonTextBox.Visible = false;
EventDelayReasonLabel.Visible = false;
StartTimerButton.Visible = false;
PauseTimerButton.Visible = true;
StartTimerButton.Location = PauseTimerButton.Location;
String[] curList = { "SkierName", "Div", "DivOrder", "EventGroup", "RunOrder", "TeamCode", "EventClass", "RankingScore", "RankingRating", "HCapBase", "HCapScore", "Status" };
sortDialogForm = new SortDialogForm();
sortDialogForm.ColumnListArray = curList;
filterDialogForm = new Common.FilterDialogForm();
filterDialogForm.ColumnListArray = curList;
rerideReasonDialogForm = new RerideReason();
skierDoneReasonDialogForm = new SkierDoneReason();
OptUpDialogForm = new SlalomOptUp();
myCheckEventRecord = new CheckEventRecord();
// Retrieve data from database
mySanctionNum = Properties.Settings.Default.AppSanctionNum;
Cursor.Current = Cursors.WaitCursor;
if (mySanctionNum == null) {
MessageBox.Show("An active tournament must be selected from the Administration menu Tournament List option");
} else {
if (mySanctionNum.Length < 6) {
MessageBox.Show("An active tournament must be selected from the Administration menu Tournament List option");
} else {
//Retrieve selected tournament attributes
DataTable curTourDataTable = getTourData(mySanctionNum);
if (curTourDataTable.Rows.Count > 0) {
myTourRow = curTourDataTable.Rows[0];
myTourRules = (String)myTourRow["Rules"];
if ( myTourRules.ToLower().Equals( "ncwsa" ) ) {
TeamCode.Visible = true;
} else {
TeamCode.Visible = false;
}
if ( (byte)myTourRow["SlalomRounds"] > 0 ) {
mySortCommand = myTourProperties.RunningOrderSortSlalom;
EventRunInfoLabel.Text = " Event Start:\n" + " Event Delay:\n" + "Skiers, Passes:";
EventRunInfoData.Text = "";
EventRunPerfLabel.Text = "Event Duration:\n" + "Mins Per Skier:\n" + " Mins Per Pass:"******"";
//Load round selection list based on number of rounds specified for the tournament
roundSelect.SelectList_Load( myTourRow["SlalomRounds"].ToString(), roundSelect_Click );
roundActiveSelect.SelectList_LoadHorztl( myTourRow["SlalomRounds"].ToString(), roundActiveSelect_Click );
roundActiveSelect.RoundValue = "1";
//Load rope length selection list
SlalomLineSelect.SelectList_Load( SlalomLineSelect_Change );
//Load slalom speed selection list
SlalomSpeedSelect.SelectList_Load( SlalomSpeedSelect_Change );
mySkierClassList = new ListSkierClass();
mySkierClassList.ListSkierClassLoad();
scoreEventClass.DataSource = mySkierClassList.DropdownList;
scoreEventClass.DisplayMember = "ItemName";
scoreEventClass.ValueMember = "ItemValue";
myTourClass = myTourRow["Class"].ToString().ToUpper();
myClassCRow = mySkierClassList.SkierClassDataTable.Select("ListCode = 'C'")[0];
myClassERow = mySkierClassList.SkierClassDataTable.Select("ListCode = 'E'")[0];
//Determine required number of judges for event
myNumJudges = 5;
StringBuilder curSqlStmt = new StringBuilder( "" );
curSqlStmt.Append( "Select ListCode, CodeValue, MaxValue, MinValue FROM CodeValueList " );
curSqlStmt.Append( "Where ListName = 'SlalomJudgesNum' And ListCode = '" + myTourClass + "' ORDER BY SortSeq" );
DataTable curNumJudgesDataTable = getData( curSqlStmt.ToString() );
if (curNumJudgesDataTable.Rows.Count > 0) {
setShowByNumJudges( Convert.ToInt16( (Decimal)curNumJudgesDataTable.Rows[0]["MaxValue"] ));
} else {
setShowByNumJudges ( 1 );
}
if ( myNumJudges > 3 ) {
ClassC5JudgeCB.Visible = false;
ClassC5JudgeCB.Enabled = false;
ClassR3JudgeCB.Visible = true;
ClassR3JudgeCB.Enabled = true;
ClassR3JudgeCB.Checked = true;
} else {
ClassC5JudgeCB.Visible = true;
ClassC5JudgeCB.Enabled = true;
ClassR3JudgeCB.Visible = false;
ClassR3JudgeCB.Enabled = false;
}
//Retrieve and load boat times
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() );
//Retrieve list of approved tournament boats
getApprovedTowboats();
listApprovedBoatsDataGridView.Visible = false;
BoatSelectInfoLabel.Visible = false;
//Retrieve and load tournament event entries
loadEventGroupList( Convert.ToByte( roundActiveSelect.RoundValue ) );
if (ExportLiveWeb.LiveWebLocation.Length > 1) {
LiveWebLabel.Visible = true;
} else {
LiveWebLabel.Visible = false;
}
} else {
MessageBox.Show( "The slalom event is not defined for the active tournament" );
}
} else {
MessageBox.Show( "The active tournament is not properly defined. You must select from the Administration menu Tournament List option" );
}
}
}
Cursor.Current = Cursors.Default;
}
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;
}
private void JumpMeterSetup_Load( object sender, EventArgs e )
{
if (Properties.Settings.Default.JumpMeterSetup_Width > 0) {
this.Width = Properties.Settings.Default.JumpMeterSetup_Width;
}
if (Properties.Settings.Default.JumpMeterSetup_Height > 0) {
this.Height = Properties.Settings.Default.JumpMeterSetup_Height;
}
if (Properties.Settings.Default.JumpMeterSetup_Location.X > 0
&& Properties.Settings.Default.JumpMeterSetup_Location.Y > 0) {
this.Location = Properties.Settings.Default.JumpMeterSetup_Location;
}
// Retrieve data from database
mySanctionNum = Properties.Settings.Default.AppSanctionNum;
Cursor.Current = Cursors.WaitCursor;
TriangleZeroMsg.Visible = false;
Triangle15ETMsg.Visible = false;
if ( mySanctionNum == null ) {
MessageBox.Show( "An active tournament must be selected from the Administration menu Tournament List option" );
} else {
if ( mySanctionNum.Length < 6 ) {
MessageBox.Show( "An active tournament must be selected from the Administration menu Tournament List option" );
} else {
//Retrieve selected tournament attributes
DataTable curTourDataTable = getTourData( );
if ( curTourDataTable.Rows.Count > 0 ) {
myTourRow = curTourDataTable.Rows[0];
if ( (byte)myTourRow["JumpRounds"] > 0 ) {
myNumJudges = 0;
mySkierClassList = new ListSkierClass();
mySkierClassList.ListSkierClassLoad();
myTourClass = myTourRow["Class"].ToString().ToUpper();
myClassCRow = mySkierClassList.SkierClassDataTable.Select("ListCode = 'C'")[0];
myClassERow = mySkierClassList.SkierClassDataTable.Select("ListCode = 'E'")[0];
jumpDirectionSelectList.SelectList_Load( JumpDirection_Click );
StringBuilder curSqlStmt = new StringBuilder( "" );
curSqlStmt.Append( "SELECT ListName, ListCode, CodeValue as TriangleFeet FROM CodeValueList " );
curSqlStmt.Append( "WHERE ListName in ('JumpMeter6Tol', 'JumpTriangle', 'JumpTriangleZero') " );
curSqlStmt.Append( "And ListCode = '" + myTourClass + "' " );
curSqlStmt.Append( "ORDER BY SortSeq" );
DataTable curTolDataTable = getData( curSqlStmt.ToString() );
DataRow myTolRow = curTolDataTable.Select( "ListName = 'JumpTriangle'" )[0];
myMeterDistTol = Convert.ToDecimal( (String)myTolRow["TriangleFeet"]);
myTolRow = curTolDataTable.Select( "ListName = 'JumpTriangleZero'" )[0];
myMeterZeroTol = Convert.ToDecimal( (String)myTolRow["TriangleFeet"]);
myTolRow = curTolDataTable.Select( "ListName = 'JumpMeter6Tol'" )[0];
myMeter6Tol = Convert.ToDecimal( (String)myTolRow["TriangleFeet"] );
navRefresh_Click( null, null );
} else {
MessageBox.Show( "The jump event is not defined for the active tournament" );
}
} else {
MessageBox.Show( "The active tournament is not properly defined. You must select from the Administration menu Tournament List option" );
}
}
}
Cursor.Current = Cursors.Default;
}
public Boolean exportTourPerfData( String inSanctionId )
{
Boolean returnStatus = false;
String curMemberId = "", curReadyToSki = "", curAgeGroup = "";
StringBuilder outLine = new StringBuilder( "" );
StreamWriter outBuffer = null;
String curFilename = "", curRules = "";
myTourProperties = TourProperties.Instance;
DataTable curTourDataTable = getTourData( inSanctionId );
if ( curTourDataTable != null ) {
if ( curTourDataTable.Rows.Count > 0 ) {
myTourRow = curTourDataTable.Rows[0];
curRules = (String)myTourRow["Rules"];
curFilename = inSanctionId.Trim() + myTourRow["Class"].ToString().Trim() + ".wsp";
outBuffer = getExportFile( curFilename );
if ( outBuffer != null ) {
Log.WriteFile( "Export performance data file begin: " + curFilename );
//Build file header line and write to file
outLine.Append( writeHeader( inSanctionId ) );
outBuffer.WriteLine( outLine.ToString() );
//Initialize output buffer
outLine = new StringBuilder( "" );
}
}
}
if ( outBuffer != null ) {
myProgressInfo = new ProgressWindow();
myProgressInfo.setProgessMsg( "Processing Skier Performance Data File" );
myProgressInfo.Show();
myProgressInfo.Refresh();
myProgressInfo.setProgressMax( 10 );
DataTable curMemberDataTable = getMemberData( inSanctionId );
if ( curMemberDataTable != null ) {
DataRow[] curScoreRows, curScoreSlalomRows, curScoreTrickRows, curScoreJumpRows;
String curPlcmtMethod = "score", curPlcmtOverallOrg = "agegroup";
String curDataType = myTourProperties.MasterSummaryDataType;
//String curDataType = Properties.Settings.Default.MasterSummaryV2DataType;
if ( curDataType.ToLower().Equals( "total" )
|| curDataType.ToLower().Equals( "best" )
|| curDataType.ToLower().Equals( "final" )
|| curDataType.ToLower().Equals( "first" ) ) {
} else {
curDataType = "best";
}
String curPointsMethod = myTourProperties.MasterSummaryPointsMethod;
//String curPointsMethod = Properties.Settings.Default.MasterSummaryV2PointsMethod;
if ( curPointsMethod.ToLower().Equals( "nops" )
|| curPointsMethod.ToLower().Equals( "plcmt" )
|| curPointsMethod.ToLower().Equals( "kbase" )
|| curPointsMethod.ToLower().Equals( "ratio" ) ) {
} else {
curPointsMethod = "nops";
}
String curPlcmtOrg = myTourProperties.MasterSummaryPlcmtOrg;
//String curPlcmtOrg = Properties.Settings.Default.MasterSummaryV2PlcmtOrg;
if ( curPlcmtOrg.ToLower().Equals("div") ) {
curPlcmtOverallOrg = "agegroup";
} else if ( curPlcmtOrg.ToLower().Equals( "divgr" ) ) {
curPlcmtOverallOrg = "agegroupgroup";
} else {
curPlcmtOverallOrg = "agegroup";
curPlcmtOrg = "div";
}
CalcScoreSummary curCalcSummary = new CalcScoreSummary();
DataTable mySummaryDataTable = null;
DataTable myMemberData = curCalcSummary.getMemberData( inSanctionId );
myProgressInfo.setProgressValue( 1 );
myProgressInfo.Refresh();
if (curRules.ToLower().Equals( "iwwf" ) && curPointsMethod.ToLower().Equals( "kbase" )) {
mySummaryDataTable = curCalcSummary.CalcIwwfEventPlcmts( myTourRow, inSanctionId, "Scorebook", curRules, curDataType, curPlcmtMethod, curPlcmtOrg, curPointsMethod, null, null );
myProgressInfo.setProgressValue( 5 );
myProgressInfo.Refresh();
DataTable mySlalomDetail = curCalcSummary.getSlalomScoreDetail( myTourRow, curPlcmtMethod, curPlcmtOrg, curPointsMethod, null, null );
myProgressInfo.setProgressValue( 6 );
myProgressInfo.Refresh();
DataTable myTrickDetail = curCalcSummary.getTrickScoreDetail( myTourRow, curPlcmtMethod, curPlcmtOrg, curPointsMethod, null, null );
myProgressInfo.setProgressValue( 7 );
myProgressInfo.Refresh();
DataTable myJumpDetail = curCalcSummary.getJumpScoreDetail( myTourRow, curPlcmtMethod, curPlcmtOrg, curPointsMethod, null, null );
myProgressInfo.setProgressValue( 8 );
myProgressInfo.Refresh();
DataTable newSummaryDataTable = curCalcSummary.buildTourScorebook( inSanctionId, myTourRow, myMemberData, mySummaryDataTable, mySlalomDetail, myTrickDetail, myJumpDetail );
mySummaryDataTable = newSummaryDataTable;
myProgressInfo.setProgressValue( 9 );
myProgressInfo.Refresh();
} else {
DataTable mySlalomDataTable = curCalcSummary.getSlalomSummary( myTourRow, curDataType, curPlcmtMethod, curPlcmtOrg, curPointsMethod );
myProgressInfo.setProgressValue( 2 );
myProgressInfo.Refresh();
DataTable myTrickDataTable = curCalcSummary.getTrickSummary( myTourRow, curDataType, curPlcmtMethod, curPlcmtOrg, curPointsMethod );
myProgressInfo.setProgressValue( 3 );
myProgressInfo.Refresh();
DataTable myJumpDataTable = curCalcSummary.getJumpSummary( myTourRow, curDataType, curPlcmtMethod, curPlcmtOrg, curPointsMethod );
myProgressInfo.setProgressValue( 4 );
myProgressInfo.Refresh();
mySummaryDataTable = curCalcSummary.buildOverallSummary( myTourRow, mySlalomDataTable, myTrickDataTable, myJumpDataTable, curDataType, curPlcmtOverallOrg );
myProgressInfo.setProgressValue( 5 );
myProgressInfo.Refresh();
DataTable mySlalomDetail = curCalcSummary.getSlalomScoreDetail( myTourRow, curPlcmtMethod, curPlcmtOrg, curPointsMethod, null, null );
myProgressInfo.setProgressValue( 6 );
myProgressInfo.Refresh();
DataTable myTrickDetail = curCalcSummary.getTrickScoreDetail( myTourRow, curPlcmtMethod, curPlcmtOrg, curPointsMethod, null, null );
myProgressInfo.setProgressValue( 7 );
myProgressInfo.Refresh();
DataTable myJumpDetail = curCalcSummary.getJumpScoreDetail( myTourRow, curPlcmtMethod, curPlcmtOrg, curPointsMethod, null, null );
myProgressInfo.setProgressValue( 8 );
myProgressInfo.Refresh();
DataTable newSummaryDataTable = curCalcSummary.buildTourScorebook( inSanctionId, myTourRow, myMemberData, mySummaryDataTable, mySlalomDetail, myTrickDetail, myJumpDetail );
mySummaryDataTable = newSummaryDataTable;
myProgressInfo.setProgressValue( 9 );
myProgressInfo.Refresh();
}
mySkierClassList = new ListSkierClass();
mySkierClassList.ListSkierClassLoad();
int curRowCount = 0;
myProgressInfo.setProgressMax( curMemberDataTable.Rows.Count );
foreach ( DataRow curMemberRow in curMemberDataTable.Rows ) {
curRowCount++;
myProgressInfo.setProgressValue( curRowCount );
myProgressInfo.Refresh();
curMemberId = curMemberRow["MemberId"].ToString();
curAgeGroup = curMemberRow["AgeGroup"].ToString();
curReadyToSki = curMemberRow["ReadyToSki"].ToString();
curScoreRows = mySummaryDataTable.Select( "MemberId = '" + curMemberId + "' AND AgeGroup = '" + curAgeGroup + "'" );
//curScoreSlalomRows = mySlalomDataTable.Select( "MemberId = '" + curMemberId + "' AND AgeGroup = '" + curAgeGroup + "'" );
//curScoreTrickRows = myTrickDataTable.Select( "MemberId = '" + curMemberId + "' AND AgeGroup = '" + curAgeGroup + "'" );
//curScoreJumpRows = myJumpDataTable.Select( "MemberId = '" + curMemberId + "' AND AgeGroup = '" + curAgeGroup + "'" );
if ( curReadyToSki.Equals( "Y" ) ) {
if ( curScoreRows.Length > 0 ) {
//Write skier identification information
outLine.Append( writeSkierInfo( curMemberRow, inSanctionId, curRules, curAgeGroup ) );
//Write skier performance summary information
//outLine.Append( writeSkierPerfSmry( curMemberId, curAgeGroup, curDataType, curMemberRow, curScoreRows, curScoreSlalomRows, curScoreTrickRows, curScoreJumpRows ) );
outLine.Append( writeSkierPerfSmry( curMemberId, curAgeGroup, curDataType, curMemberRow, curScoreRows, curScoreRows, curScoreRows, curScoreRows ) );
//Write skier performance summary information
outLine.Append( writeSkierPerfData( curMemberId, curAgeGroup, curRules, curMemberRow, curScoreRows ) );
//Write output line to file
outBuffer.WriteLine( outLine.ToString() );
}
}
//Initialize output buffer
outLine = new StringBuilder( "" );
}
returnStatus = true;
outBuffer.Close();
myProgressInfo.Close();
if ( curMemberDataTable.Rows.Count > 0 ) {
MessageBox.Show( curMemberDataTable.Rows.Count + " rows found and written" );
} else {
MessageBox.Show( "No rows found" );
}
Log.WriteFile( "Export performance data file complete: " + curFilename );
}
}
return returnStatus;
}
public Boolean exportScoreBookData()
{
String curMethodName = "exportScoreBookHtml";
Boolean returnStatus = false;
StringBuilder outLine = new StringBuilder( "" );
String curMsg = "", curMemberId = "", curAgeGroup = "", prevMemberId = "", prevAgeGroup = "", curReadyToSki = "";
String curFileFilter = "HTML files (*.htm)|*.htm|All files (*.*)|*.*";
Int16 curRound = 0;
DataRow prevRow = null;
DataRow[] curScoreSlalomRows = null, curScoreTrickRows = null, curScoreJumpRows = null;
myTourProperties = TourProperties.Instance;
ExportScorebookTypeDialogForm curDialogForm = new ExportScorebookTypeDialogForm();
curDialogForm.ShowDialog();
if ( curDialogForm.DialogResult == DialogResult.OK ) {
String curReportFormat = curDialogForm.ReportFormat;
if ( curReportFormat.Equals( "Magazine" ) ) {
Tools.ExportScorebookPublishFmt myExportDataReport = new ExportScorebookPublishFmt();
myExportDataReport.ExportScorebookPublishFmtData();
returnStatus = true;
} else {
try {
curMsg = "Exporting Scorebook Html";
Log.WriteFile( curMethodName + ":begin: " + curMsg );
mySkierClassList = new ListSkierClass();
mySkierClassList.ListSkierClassLoad();
String curFilename = mySanctionNum.Trim() + "CS.HTM";
StreamWriter outBuffer = getExportFile( curFileFilter, curFilename );
if ( outBuffer == null ) {
curMsg = "Output file not available";
} else {
String curPlcmtMethod = "score", curPlcmtOverallOrg = "agegroup";
String curDataType = myTourProperties.MasterSummaryDataType;
//String curDataType = Properties.Settings.Default.MasterSummaryV2DataType;
if ( curDataType.ToLower().Equals( "total" )
|| curDataType.ToLower().Equals( "best" )
|| curDataType.ToLower().Equals( "final" )
|| curDataType.ToLower().Equals( "first" ) ) {
} else {
curDataType = "best";
}
String curPointsMethod = myTourProperties.MasterSummaryPointsMethod;
//String curPointsMethod = Properties.Settings.Default.MasterSummaryV2PointsMethod;
if (curPointsMethod.ToLower().Equals( "nops" )
|| curPointsMethod.ToLower().Equals( "plcmt" )
|| curPointsMethod.ToLower().Equals( "kbase" )
|| curPointsMethod.ToLower().Equals( "ratio" )) {
} else {
curPointsMethod = "nops";
}
String curPlcmtOrg = myTourProperties.MasterSummaryPlcmtOrg;
//String curPlcmtOrg = Properties.Settings.Default.MasterSummaryV2PlcmtOrg;
if ( curPlcmtOrg.ToLower().Equals( "div" ) ) {
curPlcmtOverallOrg = "agegroup";
} else if ( curPlcmtOrg.ToLower().Equals( "divgr" ) ) {
curPlcmtOverallOrg = "agegroupgroup";
} else {
curPlcmtOverallOrg = "agegroup";
curPlcmtOrg = "div";
}
myProgressInfo = new ProgressWindow();
myProgressInfo.setProgessMsg( "Processing Scorebook HTML" );
myProgressInfo.Show();
myProgressInfo.Refresh();
myProgressInfo.setProgressMax( 10 );
CalcScoreSummary curCalcSummary = new CalcScoreSummary();
DataTable mySlalomDataTable = curCalcSummary.getSlalomSummary( myTourRow, curDataType, curPlcmtMethod, curPlcmtOrg, curPointsMethod );
myProgressInfo.setProgressValue( 1 );
myProgressInfo.Refresh();
DataTable myTrickDataTable = curCalcSummary.getTrickSummary( myTourRow, curDataType, curPlcmtMethod, curPlcmtOrg, curPointsMethod );
myProgressInfo.setProgressValue( 2 );
myProgressInfo.Refresh();
DataTable myJumpDataTable = curCalcSummary.getJumpSummary( myTourRow, curDataType, curPlcmtMethod, curPlcmtOrg, curPointsMethod );
myProgressInfo.setProgressValue( 3 );
myProgressInfo.Refresh();
DataTable myOverallDataTable = curCalcSummary.buildOverallSummary( myTourRow, mySlalomDataTable, myTrickDataTable, myJumpDataTable, curDataType, curPlcmtOverallOrg );
myProgressInfo.setProgressValue( 4 );
myProgressInfo.Refresh();
DataTable myMemberData = curCalcSummary.getMemberData( mySanctionNum );
myProgressInfo.setProgressValue( 5 );
myProgressInfo.Refresh();
DataTable mySlalomDetail = curCalcSummary.getSlalomScoreDetail( myTourRow, curPlcmtMethod, curPlcmtOrg, curPointsMethod, null, null );
myProgressInfo.setProgressValue( 6 );
myProgressInfo.Refresh();
DataTable myTrickDetail = curCalcSummary.getTrickScoreDetail( myTourRow, curPlcmtMethod, curPlcmtOrg, curPointsMethod, null, null );
myProgressInfo.setProgressValue( 7 );
myProgressInfo.Refresh();
DataTable myJumpDetail = curCalcSummary.getJumpScoreDetail( myTourRow, curPlcmtMethod, curPlcmtOrg, curPointsMethod, null, null );
myProgressInfo.setProgressValue( 8 );
myProgressInfo.Refresh();
DataTable mySummaryDataTable = curCalcSummary.buildTourScorebook( mySanctionNum, myTourRow, myMemberData, myOverallDataTable, mySlalomDetail, myTrickDetail, myJumpDetail );
myProgressInfo.setProgressValue( 9 );
myProgressInfo.Refresh();
myProgressInfo.setProgressMax( mySummaryDataTable.Rows.Count );
myProgressInfo.Refresh();
//Build file header line and write to file
writeHeader( outBuffer, curPlcmtOrg );
if ( curReportFormat.Equals( "Index" ) ) {
//Build index header
writeIndexHeader( outBuffer, curPlcmtOrg, mySlalomDataTable, myTrickDataTable, myJumpDataTable, myOverallDataTable );
}
//Build master summary header
writeMasterSummaryHeader( outBuffer, curPlcmtOrg );
int curRowCount = 0;
foreach ( DataRow curRow in mySummaryDataTable.Rows ) {
curRowCount++;
myProgressInfo.setProgressValue( curRowCount );
myProgressInfo.Refresh();
curMemberId = curRow["MemberId"].ToString();
curAgeGroup = curRow["AgeGroup"].ToString();
curReadyToSki = curRow["ReadyToSki"].ToString();
if ( curMemberId != prevMemberId || curAgeGroup != prevAgeGroup ) {
curScoreSlalomRows = mySlalomDataTable.Select( "MemberId = '" + curMemberId + "' AND AgeGroup = '" + curAgeGroup + "'" );
curScoreTrickRows = myTrickDataTable.Select( "MemberId = '" + curMemberId + "' AND AgeGroup = '" + curAgeGroup + "'" );
curScoreJumpRows = myJumpDataTable.Select( "MemberId = '" + curMemberId + "' AND AgeGroup = '" + curAgeGroup + "'" );
}
//Initialize control fields
prevMemberId = curMemberId;
prevAgeGroup = curAgeGroup;
curRound = (Int16)curRow["Round"];
//Initialize output buffer
outLine = new StringBuilder( "<tr>" );
//Write skier identification information
writeSkierInfo( curRow, curRound, outBuffer );
//Write skier performance summary information
writeSkierSlalomScore( curRow, curScoreSlalomRows, curPlcmtOrg, outBuffer );
writeSkierTrickScore( curRow, curScoreTrickRows, curPlcmtOrg, outBuffer );
writeSkierJumpScore( curRow, curScoreJumpRows, curPlcmtOrg, outBuffer );
writeSkierOverallScore( curRow, outBuffer );
//Write output line to file
outLine = new StringBuilder( "</tr>" );
outBuffer.WriteLine( outLine.ToString() );
}
outLine = new StringBuilder( "</table>" );
outBuffer.WriteLine( outLine.ToString() );
if ( curReportFormat.Equals( "Index" ) ) {
outLine = new StringBuilder( "<br/><br/><a href=#PageTop>Return to Index</a><br/></div>" );
outBuffer.WriteLine( outLine.ToString() );
writeIndexSlalomResults( curPlcmtOrg, mySlalomDataTable, outBuffer );
writeIndexTrickResults( curPlcmtOrg, myTrickDataTable, outBuffer );
writeIndexJumpResults( curPlcmtOrg, myJumpDataTable, outBuffer );
writeIndexOverallResults( curPlcmtOrg, myOverallDataTable, outBuffer );
Boolean curTeamsAvailble = isTeamAvailable();
//if ( this.myTourClass.Equals("B") || this.myTourClass.Equals("A") ) {
// curTeamsAvailble = false;
//}
if ( curTeamsAvailble ) {
Int16 myNumPerTeam = Convert.ToInt16( myTourProperties.TeamSummary_NumPerTeam);
String curTeamPlcmtOrg = myTourProperties.TeamSummaryPlcmtOrg;
//String curTeamPlcmtOrg = Properties.Settings.Default.TeamSummaryPlcmtOrg;
if (curTeamPlcmtOrg.ToLower().Equals( "tour" )
|| curTeamPlcmtOrg.ToLower().Equals( "div" )) {
} else {
curTeamPlcmtOrg = "tour";
}
String curTeamPlcmtMethod = "points";
String curTeamDataType = myTourProperties.TeamSummaryDataType;
//String curTeamDataType = Properties.Settings.Default.TeamSummaryDataType;
if (curTeamDataType.ToLower().Equals( "total" )
|| curTeamDataType.ToLower().Equals( "best" )
|| curTeamDataType.ToLower().Equals( "final" )
|| curTeamDataType.ToLower().Equals( "first" )) {
} else {
curTeamDataType = "best";
}
String curTeamPointsMethod = myTourProperties.TeamSummaryPointsMethod;
//String curTeamPointsMethod = Properties.Settings.Default.MasterSummaryV2PointsMethod;
if (curTeamPointsMethod.ToLower().Equals( "nops" )
|| curTeamPointsMethod.ToLower().Equals( "plcmt" )
|| curTeamPointsMethod.ToLower().Equals( "kbase" )
|| curTeamPointsMethod.ToLower().Equals( "ratio" )) {
} else {
curTeamPointsMethod = "nops";
}
if ( this.myTourClass.Equals("B") || this.myTourClass.Equals("A") ) {
curTeamPointsMethod = "nops";
curTeamDataType = "best";
curTeamPlcmtOrg = "awsa";
curTeamPlcmtMethod = "points";
myNumPerTeam = 4;
}
String curGroupValue = "all";
mySlalomDataTable = curCalcSummary.getSlalomSummary(myTourRow, curTeamDataType, curTeamPlcmtMethod, curTeamPlcmtOrg, curTeamPointsMethod, "Team", curGroupValue);
myTrickDataTable = curCalcSummary.getTrickSummary(myTourRow, curTeamDataType, curTeamPlcmtMethod, curTeamPlcmtOrg, curTeamPointsMethod, "Team", curGroupValue);
myJumpDataTable = curCalcSummary.getJumpSummary(myTourRow, curTeamDataType, curTeamPlcmtMethod, curTeamPlcmtOrg, curTeamPointsMethod, "Team", curGroupValue);
DataTable myTeamDataTable = null;
myTeamDataTable = curCalcSummary.getSlalomSummaryTeam(mySlalomDataTable, myTourRow, myNumPerTeam, curTeamDataType, curTeamPlcmtMethod, curTeamPlcmtOrg, curTeamPointsMethod);
myTeamDataTable = curCalcSummary.getTrickSummaryTeam(myTeamDataTable, myTrickDataTable, myTourRow, myNumPerTeam, curTeamDataType, curTeamPlcmtMethod, curTeamPlcmtOrg, curTeamPointsMethod);
myTeamDataTable = curCalcSummary.getJumpSummaryTeam(myTeamDataTable, myJumpDataTable, myTourRow, myNumPerTeam, curTeamDataType, curTeamPlcmtMethod, curTeamPlcmtOrg, curTeamPointsMethod);
if ( curTeamPlcmtOrg.ToLower().Equals("tour") ) {
myTeamDataTable = curCalcSummary.CalcTeamCombinedSummary(myTourRow, mySlalomDataTable, myTrickDataTable, myJumpDataTable, myNumPerTeam);
}
if ( myTourClass.Equals("B") || myTourClass.Equals("A") ) {
mySlalomDataTable = curCalcSummary.CalcTeamAwsaEventPoints(mySlalomDataTable, "Slalom");
myTrickDataTable = curCalcSummary.CalcTeamAwsaEventPoints(myTrickDataTable, "Trick");
myJumpDataTable = curCalcSummary.CalcTeamAwsaEventPoints(myJumpDataTable, "Jump");
myTeamDataTable = curCalcSummary.CalcTeamAwsaCombinedSummary(myTourRow, mySlalomDataTable, myTrickDataTable, myJumpDataTable, myNumPerTeam);
writeIndexTeamResults(myTeamDataTable, myNumPerTeam, curTeamPlcmtOrg, outBuffer);
writeIndexTeamDetailResults(mySlalomDataTable, myTrickDataTable, myJumpDataTable, myNumPerTeam, curTeamPlcmtOrg, outBuffer);
} else {
writeIndexTeamResults(myTeamDataTable, myNumPerTeam, curTeamPlcmtOrg, outBuffer);
}
}
} else {
outLine = new StringBuilder( "</div>" );
outBuffer.WriteLine( outLine.ToString() );
}
//Build file footer and write to file
writeFooter( outBuffer );
outLine = new StringBuilder( "" );
outBuffer.WriteLine( outLine.ToString() );
returnStatus = true;
outBuffer.Close();
myProgressInfo.Close();
if ( mySummaryDataTable.Rows.Count > 0 ) {
curMsg = mySummaryDataTable.Rows.Count + " skiers found and written";
} else {
curMsg = "No rows found";
}
}
MessageBox.Show( curMsg );
Log.WriteFile( curMethodName + ":conplete: " + curMsg );
} catch ( Exception ex ) {
MessageBox.Show( "Error:" + curMethodName + " Error writing scorebook html file\n\nError: " + ex.Message );
curMsg = curMethodName + ":Exception=" + ex.Message;
Log.WriteFile( curMsg );
returnStatus = false;
}
}
} else {
returnStatus = false;
}
return returnStatus;
}
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;
}
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, 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;
}
private void ScoreEntry_Load(object sender, EventArgs e)
{
if (Properties.Settings.Default.JumpEntry_Width > 0) {
this.Width = Properties.Settings.Default.JumpEntry_Width;
}
if (Properties.Settings.Default.JumpEntry_Height > 0) {
this.Height = Properties.Settings.Default.JumpEntry_Height;
}
if (Properties.Settings.Default.JumpEntry_Location.X > 0
&& Properties.Settings.Default.JumpEntry_Location.Y > 0) {
this.Location = Properties.Settings.Default.JumpEntry_Location;
}
myTourProperties = TourProperties.Instance;
mySortCommand = myTourProperties.RunningOrderSortJump;
int curDelim = mySortCommand.IndexOf( "AgeGroup" );
if (curDelim < 0) {
} else if (curDelim > 0) {
mySortCommand = mySortCommand.Substring( 0, curDelim ) + "DivOrder" + mySortCommand.Substring( curDelim + "AgeGroup".Length );
myTourProperties.RunningOrderSortJump = mySortCommand;
} else {
mySortCommand = "DivOrder" + mySortCommand.Substring( "AgeGroup".Length );
myTourProperties.RunningOrderSortJump = mySortCommand;
}
ResizeNarrow.Visible = false;
ResizeNarrow.Enabled = false;
ResizeWide.Visible = true;
ResizeWide.Enabled = true;
ResizeNarrow.Location = ResizeWide.Location;
EventRunInfoLabel.Text = " Event Start:\n" + " Event Delay:\n" + "Skiers, Passes:";
EventRunInfoData.Text = "";
EventRunPerfLabel.Text = "Event Duration:\n" + "Mins Per Skier:\n" + " Mins Per Pass:"******"";
EventDelayReasonTextBox.Visible = false;
EventDelayReasonLabel.Visible = false;
StartTimerButton.Visible = false;
PauseTimerButton.Visible = true;
StartTimerButton.Location = PauseTimerButton.Location;
String[] curList = { "SkierName", "Div", "DivOrder", "EventGroup", "RunOrder", "TeamCode", "EventClass", "RankingScore", "RankingRating", "HCapBase", "HCapScore", "Status" };
sortDialogForm = new SortDialogForm();
sortDialogForm.ColumnListArray = curList;
filterDialogForm = new Common.FilterDialogForm();
filterDialogForm.ColumnListArray = curList;
eventGroupSelect = new EventGroupSelect();
rerideReasonDialogForm = new RerideReason();
skierDoneReasonDialogForm = new SkierDoneReason();
// Retrieve data from database
mySanctionNum = Properties.Settings.Default.AppSanctionNum;
Cursor.Current = Cursors.WaitCursor;
if (mySanctionNum == null) {
MessageBox.Show("An active tournament must be selected from the Administration menu Tournament List option");
} else {
if (mySanctionNum.Length < 6) {
MessageBox.Show("An active tournament must be selected from the Administration menu Tournament List option");
} else {
//Retrieve selected tournament attributes
DataTable curTourDataTable = getTourData(mySanctionNum);
if (curTourDataTable.Rows.Count > 0) {
myTourRow = curTourDataTable.Rows[0];
myTourRules = (String)myTourRow["Rules"];
if ( myTourRules.ToLower().Equals( "ncwsa" ) ) {
TeamCode.Visible = true;
} else {
TeamCode.Visible = false;
}
if ( (byte)myTourRow["JumpRounds"] > 0 ) {
mySanctionYear = Convert.ToInt16( mySanctionNum.Substring( 0, 2 ) );
//Load round selection list based on number of rounds specified for the tournament
roundSelect.SelectList_Load( myTourRow["JumpRounds"].ToString(), roundSelect_Click );
roundActiveSelect.SelectList_LoadHorztl( myTourRow["JumpRounds"].ToString(), roundActiveSelect_Click );
roundActiveSelect.RoundValue = "1";
roundSelect.RoundValue = "1";
//Load jump speed selection list
JumpSpeedSelect.SelectList_Load( JumpSpeedSelect_Change );
//Load ramp height selection list
RampHeightSelect.SelectList_Load( RampHeightSelect_Change );
mySkierClassList = new ListSkierClass();
mySkierClassList.ListSkierClassLoad();
scoreEventClass.DataSource = mySkierClassList.DropdownList;
scoreEventClass.DisplayMember = "ItemName";
scoreEventClass.ValueMember = "ItemValue";
myRuleType = ((String)myTourRow["Rules"]).ToUpper();
myTourClass = myTourRow["Class"].ToString().ToUpper();
myClassCRow = mySkierClassList.SkierClassDataTable.Select("ListCode = 'C'")[0];
myClassERow = mySkierClassList.SkierClassDataTable.Select("ListCode = 'E'")[0];
myAgeDivList = new AgeGroupDropdownList( myTourRow );
//Setup for meter input if using meters to calculate distances
NumJudges = Convert.ToInt16( myTourProperties.JumpEntryNumJudges);
if ( NumJudges > 0 ) {
JumpCalcMetersCB.Checked = true;
JumpCalcVideoCB.Checked = false;
} else {
JumpCalcMetersCB.Checked = false;
JumpCalcVideoCB.Checked = true;
}
//Retrieve boat times
StringBuilder curSqlStmt = new StringBuilder( "" );
curSqlStmt.Append( "SELECT ListCode, CodeValue, MinValue, MaxValue, CodeDesc FROM CodeValueList WHERE ListName = 'JumpBoatTime3Seg' ORDER BY SortSeq" );
myTimesDataTable = getData( curSqlStmt.ToString() );
//Retrieve maximum speeds by age group
getMaxSpeedData();
//Retrieve minimum speeds by class
getMinSpeedData();
//Retrieve maximum ramp heights by age group
getMaxRampData();
//Retrieve list of divisions and scores that require 3 segment validation for L and R tournaments
try {
DataTable curTourClassDataTable = mySkierClassList.getTourClassList();
myClassRow = curTourClassDataTable.Select( "ListCode = '" + myTourClass + "'" )[0];
if ((Decimal)myClassRow["ListCodeNum"] > (Decimal)myClassERow["ListCodeNum"]) {
getJump3TimesDivData();
} else {
myJump3TimesDivDataTable = null;
}
} catch {
myJump3TimesDivDataTable = null;
}
//Get list of approved tow boats
getApprovedTowboats();
BoatSelectInfoLabel.Visible = false;
listApprovedBoatsDataGridView.Visible = false;
//Retrieve and load tournament event entries
loadEventGroupList( Convert.ToByte( roundActiveSelect.RoundValue ) );
if (ExportLiveWeb.LiveWebLocation.Length > 1) {
LiveWebLabel.Visible = true;
} else {
LiveWebLabel.Visible = false;
}
} else {
MessageBox.Show( "The jump event is not defined for the active tournament" );
}
} else {
MessageBox.Show( "The active tournament is not properly defined. You must select from the Administration menu Tournament List option" );
}
}
}
Cursor.Current = Cursors.Default;
}
private void RunningOrderTour_Load(object sender, EventArgs e)
{
if (Properties.Settings.Default.RunningOrder_Width > 0) {
this.Width = Properties.Settings.Default.RunningOrder_Width;
}
if (Properties.Settings.Default.RunningOrder_Height > 0) {
this.Height = Properties.Settings.Default.RunningOrder_Height;
}
if (Properties.Settings.Default.RunningOrder_Location.X > 0
&& Properties.Settings.Default.RunningOrder_Location.Y > 0) {
this.Location = Properties.Settings.Default.RunningOrder_Location;
}
isLoadInProg = true;
myTourProperties = TourProperties.Instance;
String[] curList = { "SkierName", "EventGroup", "Div", "DivOrder", "RunOrder", "TeamCode", "EventClass", "RankingScore", "RankingRating", "JumpHeight", "HCapBase", "HCapScore" };
sortDialogForm = new SortDialogForm();
sortDialogForm.ColumnListArray = curList;
filterDialogForm = new Common.FilterDialogForm();
filterDialogForm.ColumnListArray = curList;
// Retrieve data from database
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( mySanctionNum );
if ( curTourDataTable.Rows.Count > 0 ) {
myTourRow = curTourDataTable.Rows[0];
myTourRules = (String)myTourRow["Rules"];
myTourEventClass = (String)myTourRow["EventClass"];
myTourClass = (String)myTourRow["Class"];
mySkierClassList = new ListSkierClass();
mySkierClassList.ListSkierClassLoad();
EventClass.DataSource = mySkierClassList.DropdownList;
EventClass.DisplayMember = "ItemName";
EventClass.ValueMember = "ItemValue";
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;
}
myFilterCmd = "";
if (slalomButton.Checked) {
mySortCmd = myTourProperties.RunningOrderSortSlalom;
} else if (trickButton.Checked) {
mySortCmd = myTourProperties.RunningOrderSortTrick;
} else if (jumpButton.Checked) {
mySortCmd = myTourProperties.RunningOrderSortJump;
}
if (ExportLiveWeb.LiveWebLocation.Length > 1) {
LiveWebLabel.Visible = true;
} else {
LiveWebLabel.Visible = false;
}
} else {
MessageBox.Show( "An active tournament must be selected from the Administration menu Tournament List option" );
}
}
}
isDataModified = false;
isLoadInProg = false;
}
