public void navRefresh_Click( object sender, EventArgs e )
{
// Retrieve data from database
if ( mySanctionNum != null && myEvent != null ) {
String curDataType = "all", curPlcmtMethod = "score";
String curPlcmtOrg, curPointsMethod;
Int16 curNumPrelimRounds = 0;
CalcScoreSummary curCalcSummary = new CalcScoreSummary();
// Retrieve data from database depending on selection criteria
String curMsg = "Tournament scores retrieved ";
if ( bestScoreButton.Checked ) {
curDataType = "best";
winStatusMsg.Text = curMsg + "- best scores ";
} else if ( totalScoreButton.Checked ) {
curDataType = "total";
winStatusMsg.Text = curMsg + "- total scores";
} else if ( finalScoreButton.Checked ) {
curDataType = "final";
winStatusMsg.Text = curMsg + "- final scores";
} else if ( firstScoreButton.Checked ) {
curDataType = "first";
winStatusMsg.Text = curMsg + "- first scores";
} else if ( roundScoreButton.Checked ) {
curDataType = "round";
winStatusMsg.Text = curMsg + "- all scores";
} else if (h2hScoreButton.Checked) {
curDataType = "h2h";
winStatusMsg.Text = curMsg + "- head to head";
} else {
curDataType = "best";
winStatusMsg.Text = curMsg + "- best scores ";
}
myTourProperties.SlalomSummaryDataType = curDataType;
if ( rawScoreButton.Checked ) {
curPlcmtMethod = "score";
} else if ( pointsScoreButton.Checked ) {
curPlcmtMethod = "points";
} else {
curPlcmtMethod = "score";
}
myTourProperties.SlalomSummaryPlcmtMethod = curPlcmtMethod;
if ( groupPlcmtButton.Checked ) {
curPlcmtOrg = "group";
EventGroup.Visible = true;
} else if ( plcmtTourButton.Checked ) {
curPlcmtOrg = "tour";
EventGroup.Visible = false;
} else if (plcmtDivButton.Checked) {
curPlcmtOrg = "div";
EventGroup.Visible = false;
} else if (plcmtDivGrpButton.Checked) {
curPlcmtOrg = "divgr";
EventGroup.Visible = true;
} else {
curPlcmtOrg = "tour";
EventGroup.Visible = false;
}
myTourProperties.SlalomSummaryPlcmtOrg = curPlcmtOrg;
HCapBase.Visible = false;
HCapScore.Visible = false;
if ( nopsPointsButton.Checked ) {
curPointsMethod = "nops";
} else if ( plcmtPointsButton.Checked ) {
curPointsMethod = "plcmt";
} else if ( kBasePointsButton.Checked ) {
curPointsMethod = "kbase";
} else if ( handicapPointsButton.Checked ) {
curPointsMethod = "hcap";
HCapBase.Visible = true;
HCapScore.Visible = true;
} else if ( ratioPointsButton.Checked ) {
curPointsMethod = "ratio";
HCapBase.Visible = true;
HCapScore.Visible = true;
} else {
curPointsMethod = "nops";
}
myTourProperties.SlalomSummaryPointsMethod = curPointsMethod;
if (myTourRules.ToLower().Equals( "iwwf" ) && kBasePointsButton.Checked) {
HCapBase.Visible = false;
HCapScore.Visible = false;
}
if ( myTourRules.ToLower().Equals( "ncwsa" )
&& plcmtPointsButton.Checked
&& pointsScoreButton.Checked
) {
rawScoreButton.Checked = true;
curPlcmtMethod = "score";
myTourProperties.SlalomSummaryPlcmtMethod = curPlcmtMethod;
}
if (h2hScoreButton.Checked) {
EventGroup.Visible = true;
if (plcmtTourButton.Checked) {
curPlcmtOrg = "tour";
} else {
curPlcmtOrg = "div";
}
}
if ( h2hScoreButton.Checked || finalScoreButton.Checked ) {
if ( numPrelimTextBox.Text.Length == 0 ) {
MessageBox.Show( "Number of preliminary rounds is required for Head to Head reporting" );
return;
} else {
curNumPrelimRounds = Convert.ToInt16( numPrelimTextBox.Text );
}
}
String curGroupValue = "";
try {
curGroupValue = EventGroupList.SelectedItem.ToString();
if (!( curGroupValue.ToLower().Equals( "all" ) )) {
if (myTourRules.ToLower().Equals( "ncwsa" )) {
if (curGroupValue.ToUpper().Equals( "MEN A" )) {
curGroupValue = "CM";
} else if (curGroupValue.ToUpper().Equals( "WOMEN A" )) {
curGroupValue = "CW";
} else if (curGroupValue.ToUpper().Equals( "MEN B" )) {
curGroupValue = "BM";
} else if (curGroupValue.ToUpper().Equals( "WOMEN B" )) {
curGroupValue = "BW";
} else {
curGroupValue = "All";
}
}
}
} catch {
curGroupValue = "All";
}
this.Cursor = Cursors.WaitCursor;
if (curGroupValue.ToLower().Equals( "all" )) {
if ( myTourRules.ToLower().Equals( "iwwf" ) ) {
curPointsMethod = "kbase";
mySummaryDataTable = curCalcSummary.CalcIwwfEventPlcmts( myTourRow, mySanctionNum, "Slalom", myTourRules, curDataType, curPlcmtMethod, curPlcmtOrg, curPointsMethod, null, null );
} else if ( h2hScoreButton.Checked || ( finalScoreButton.Checked && curNumPrelimRounds > 0 ) ) {
mySummaryDataTable = curCalcSummary.getSlalomSummary( myTourRow, curDataType, curPlcmtMethod, curPlcmtOrg, curPointsMethod, curNumPrelimRounds );
} else {
mySummaryDataTable = curCalcSummary.getSlalomSummary( myTourRow, curDataType, curPlcmtMethod, curPlcmtOrg, curPointsMethod );
}
} else {
if (myTourRules.ToLower().Equals( "iwwf" )) {
curPointsMethod = "kbase";
mySummaryDataTable = curCalcSummary.CalcIwwfEventPlcmts( myTourRow, mySanctionNum, "Slalom", myTourRules, curDataType, curPlcmtMethod, curPlcmtOrg, curPointsMethod, "All", curGroupValue );
} else if ( h2hScoreButton.Checked || ( finalScoreButton.Checked && curNumPrelimRounds > 0 ) ) {
mySummaryDataTable = curCalcSummary.getSlalomSummary( myTourRow, curDataType, curPlcmtMethod, curPlcmtOrg, curPointsMethod, "All", curGroupValue, curNumPrelimRounds );
} else {
if (myTourRules.ToLower().Equals( "ncwsa" )) {
mySummaryDataTable = curCalcSummary.getSlalomSummary( myTourRow, curDataType, curPlcmtMethod, curPlcmtOrg, curPointsMethod, "All", curGroupValue );
} else {
mySummaryDataTable = curCalcSummary.getSlalomSummary( myTourRow, curDataType, curPlcmtMethod, curPlcmtOrg, curPointsMethod, "All", curGroupValue );
}
}
}
if (mySummaryDataTable.Rows.Count > 0) {
if (h2hScoreButton.Checked || ( finalScoreButton.Checked && curNumPrelimRounds > 0) ) {
mySummaryDataTable = curCalcSummary.buildHeadToHeadSummary( mySummaryDataTable, myTourRow, curDataType, curPlcmtMethod, curPlcmtOrg, curPointsMethod, curNumPrelimRounds, "Slalom" );
} else {
if (mySortCommand.Length > 1) {
if (myTourRules.ToLower().Equals( "iwwf" ) && curPointsMethod.ToLower().Equals( "kbase" )) {
} else {
mySummaryDataTable.DefaultView.Sort = mySortCommand;
mySummaryDataTable = mySummaryDataTable.DefaultView.ToTable();
}
}
}
loadDataGrid( mySummaryDataTable );
} else {
scoreSummaryDataGridView.Rows.Clear();
MessageBox.Show( "No data available for report" );
}
}
this.Cursor = Cursors.Default;
}
public void navRefresh_Click( object sender, EventArgs e )
{
// Retrieve data from database
if ( mySanctionNum != null && myTourRow != null ) {
String curDataType = "best", curPlcmtMethod = "score", curPointsMethod = "";
String curPlcmtOrg = "", curPlcmtOverallOrg = "";
//String curPlcmtOrg = "div";
CalcScoreSummary curCalcSummary = new CalcScoreSummary();
// Retrieve data from database depending on selection criteria
String curMsg = "Tournament scores retrieved ";
if ( bestScoreButton.Checked ) {
curDataType = "best";
winStatusMsg.Text = curMsg + "- best scores ";
} else if ( totalScoreButton.Checked ) {
curDataType = "total";
winStatusMsg.Text = curMsg + "- total scores";
} else if ( finalScoreButton.Checked ) {
curDataType = "final";
winStatusMsg.Text = curMsg + "- final scores";
} else if ( firstScoreButton.Checked ) {
curDataType = "first";
winStatusMsg.Text = curMsg + "- first scores";
}
myTourProperties.SlalomScorebookDataType = curDataType;
if ( nopsPointsButton.Checked ) {
curPointsMethod = "nops";
} else if ( plcmtPointsButton.Checked ) {
curPointsMethod = "plcmt";
} else if ( kBasePointsButton.Checked ) {
curPointsMethod = "kbase";
} else if ( ratioPointsButton.Checked ) {
curPointsMethod = "ratio";
} else {
curPointsMethod = "nops";
}
myTourProperties.SlalomScorebookPointsMethod = curPointsMethod;
if ( plcmtDivButton.Checked ) {
curPlcmtOrg = "div";
curPlcmtOverallOrg = "agegroup";
EventGroup.Visible = false;
} else if ( plcmtDivGrpButton.Checked ) {
curPlcmtOrg = "divgr";
curPlcmtOverallOrg = "agegroupgroup";
EventGroup.Visible = true;
} else {
curPlcmtOrg = "div";
curPlcmtOverallOrg = "agegroup";
EventGroup.Visible = false;
}
myTourProperties.SlalomScorebookPlcmtOrg = curPlcmtOrg;
Cursor.Current = Cursors.WaitCursor;
scoreSummaryDataGridView.BeginInvoke( (MethodInvoker)delegate() {
Application.DoEvents();
winStatusMsg.Text = "Tournament entries retrieved";
} );
String curGroupValue = "";
try {
curGroupValue = EventGroupList.SelectedItem.ToString();
if (!( curGroupValue.ToLower().Equals( "all" ) )) {
if (myTourRules.ToLower().Equals( "ncwsa" )) {
if (curGroupValue.ToUpper().Equals( "MEN A" )) {
curGroupValue = "CM";
} else if (curGroupValue.ToUpper().Equals( "WOMEN A" )) {
curGroupValue = "CW";
} else if (curGroupValue.ToUpper().Equals( "MEN B" )) {
curGroupValue = "BM";
} else if (curGroupValue.ToUpper().Equals( "WOMEN B" )) {
curGroupValue = "BW";
} else {
curGroupValue = "All";
}
}
}
} catch {
curGroupValue = "All";
}
if ( curGroupValue.ToLower().Equals( "all" ) ) {
if ( myTourRules.ToLower().Equals( "iwwf" ) && curPointsMethod.ToLower().Equals( "kbase" ) ) {
mySummaryDataTable = curCalcSummary.CalcIwwfEventPlcmts( myTourRow, mySanctionNum, "Scorebook", myTourRules, curDataType, curPlcmtMethod, curPlcmtOrg, curPointsMethod, null, null );
} else {
mySummaryDataTable = curCalcSummary.getSlalomSummary( myTourRow, curDataType, curPlcmtMethod, curPlcmtOrg, curPointsMethod );
myMemberData = curCalcSummary.getMemberData( mySanctionNum );
mySlalomDetail = curCalcSummary.getSlalomScoreDetail( myTourRow, curPlcmtMethod, curPlcmtOrg, curPointsMethod, null, null );
mySummaryDataTable = curCalcSummary.buildTourScorebook( mySanctionNum, myTourRow, myMemberData, mySummaryDataTable, mySlalomDetail, null, null );
}
} else {
if ( myTourRules.ToLower().Equals( "iwwf" ) && curPointsMethod.ToLower().Equals( "kbase" ) ) {
mySummaryDataTable = curCalcSummary.CalcIwwfEventPlcmts( myTourRow, mySanctionNum, "Scorebook", myTourRules, curDataType, curPlcmtMethod, curPlcmtOrg, curPointsMethod, "All", curGroupValue );
} else {
mySummaryDataTable = curCalcSummary.getSlalomSummary( myTourRow, curDataType, curPlcmtMethod, curPlcmtOrg, curPointsMethod, "All", curGroupValue );
myMemberData = curCalcSummary.getMemberData( mySanctionNum, curGroupValue );
mySlalomDetail = curCalcSummary.getSlalomScoreDetail( myTourRow, curPlcmtMethod, curPlcmtOrg, curPointsMethod, "All", curGroupValue );
mySummaryDataTable = curCalcSummary.buildTourScorebook( mySanctionNum, myTourRow, myMemberData, mySummaryDataTable, mySlalomDetail, null, null );
}
}
loadSummaryDataGrid();
Cursor.Current = Cursors.Default;
}
}
public void navRefresh_Click( object sender, EventArgs e )
{
this.Cursor = Cursors.WaitCursor;
// Retrieve data from database
if ( mySanctionNum != null && myEvent != null ) {
String curDataType = "all", curPlcmtMethod = "score";
String curPlcmtOrg, curPointsMethod;
CalcScoreSummary curCalcSummary = new CalcScoreSummary();
// Retrieve data from database depending on selection criteria
String curMsg = "Tournament scores retrieved ";
if ( bestScoreButton.Checked ) {
curDataType = "best";
winStatusMsg.Text = curMsg + "- best scores ";
} else if ( totalScoreButton.Checked ) {
curDataType = "total";
winStatusMsg.Text = curMsg + "- total scores";
} else if ( finalScoreButton.Checked ) {
curDataType = "final";
winStatusMsg.Text = curMsg + "- final scores";
}
myTourProperties.TrickTeamSummaryDataType = curDataType;
if ( rawScoreButton.Checked ) {
curPlcmtMethod = "score";
} else if ( pointsScoreButton.Checked ) {
curPlcmtMethod = "points";
} else {
curPlcmtMethod = "score";
}
myTourProperties.TrickTeamSummaryPlcmtMethod = curPlcmtMethod;
if ( divPlcmtButton.Checked ) {
curPlcmtOrg = "div";
TeamDiv.Visible = true;
} else if (groupPlcmtButton.Checked) {
curPlcmtOrg = "group";
} else if (plcmtTourButton.Checked) {
curPlcmtOrg = "tour";
TeamDiv.Visible = false;
} else {
curPlcmtOrg = "tour";
TeamDiv.Visible = false;
}
myTourProperties.TrickTeamSummaryPlcmtOrg = curPlcmtOrg;
HCapBase.Visible = false;
HCapScore.Visible = false;
if ( nopsPointsButton.Checked ) {
curPointsMethod = "nops";
} else if ( plcmtPointsButton.Checked ) {
curPointsMethod = "plcmt";
curPlcmtMethod = "score";
} else if ( kBasePointsButton.Checked ) {
curPointsMethod = "kbase";
} else if ( handicapPointsButton.Checked ) {
curPointsMethod = "hcap";
HCapBase.Visible = true;
HCapScore.Visible = true;
} else if ( ratioPointsButton.Checked ) {
curPointsMethod = "ratio";
HCapBase.Visible = true;
HCapScore.Visible = true;
} else {
curPointsMethod = "nops";
}
myTourProperties.TrickTeamSummaryPointsMethod = curPointsMethod;
String curGroupValue = "";
try {
curGroupValue = EventGroupList.SelectedItem.ToString();
if (!( curGroupValue.ToLower().Equals( "all" ) )) {
if (myTourRules.ToLower().Equals( "ncwsa" )) {
if (curGroupValue.ToUpper().Equals( "MEN A" )) {
curGroupValue = "CM";
} else if (curGroupValue.ToUpper().Equals( "WOMEN A" )) {
curGroupValue = "CW";
} else if (curGroupValue.ToUpper().Equals( "MEN B" )) {
curGroupValue = "BM";
} else if (curGroupValue.ToUpper().Equals( "WOMEN B" )) {
curGroupValue = "BW";
} else {
curGroupValue = "All";
}
}
}
} catch {
curGroupValue = "All";
}
if (myTourRules.ToLower().Equals( "iwwf" )) {
curPointsMethod = "kbase";
myScoreDataTable = curCalcSummary.CalcIwwfEventPlcmts( myTourRow, mySanctionNum, "Trick", myTourRules, curDataType, curPlcmtMethod, curPlcmtOrg, curPointsMethod, "Team", curGroupValue );
loadScoreDataGrid( myScoreDataTable );
myTeamDataTable = curCalcSummary.getTrickSummaryTeam( myTeamDataTable, myScoreDataTable, myTourRow, myNumPerTeam, curDataType, curPlcmtMethod, curPlcmtOrg, curPointsMethod );
if (plcmtTourButton.Checked) {
myTeamDataTable = curCalcSummary.CalcTeamCombinedSummary( myTourRow, null, myScoreDataTable, null, myNumPerTeam );
}
} else if (myTourRules.ToLower().Equals( "ncwsa" )) {
if (plcmtTourButton.Checked) {
curPlcmtOrg = "div";
}
myScoreDataTable = curCalcSummary.getTrickSummary( myTourRow, curDataType, curPlcmtMethod, curPlcmtOrg, curPointsMethod, "Team", curGroupValue );
loadScoreDataGrid( myScoreDataTable );
myTeamDataTable = curCalcSummary.getTrickSummaryTeam( myScoreDataTable, myTourRow, myNumPerTeam, curDataType, curPlcmtMethod, curPlcmtOrg, curPointsMethod );
if (plcmtTourButton.Checked) {
myTeamDataTable = curCalcSummary.CalcTeamEventCombinedNcwsaSummary( myTeamDataTable, mySanctionNum );
}
} else {
myScoreDataTable = curCalcSummary.getTrickSummary( myTourRow, curDataType, curPlcmtMethod, curPlcmtOrg, curPointsMethod, "Team", curGroupValue );
loadScoreDataGrid( myScoreDataTable );
myTeamDataTable = curCalcSummary.getTrickSummaryTeam( myScoreDataTable, myTourRow, myNumPerTeam, curDataType, curPlcmtMethod, curPlcmtOrg, curPointsMethod );
if (plcmtTourButton.Checked) {
myTeamDataTable = curCalcSummary.CalcTeamCombinedSummary( myTourRow, null, myScoreDataTable, null, myNumPerTeam );
}
}
String curSortCmd = "";
if (TeamDiv.Visible) {
curSortCmd = "DivOrder ASC, Div ASC, TeamScoreTotal DESC";
} else {
curSortCmd = "TeamScoreTotal DESC";
}
myTeamDataTable.DefaultView.Sort = curSortCmd;
myTeamDataTable = myTeamDataTable.DefaultView.ToTable();
loadTeamDataGrid( myTeamDataTable );
}
this.Cursor = 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 = "exportScoreBookData";
Boolean returnStatus = false;
StringBuilder outLine = new StringBuilder( "" );
String curMsg = "", curMemberId = "", curAgeGroup = "", prevMemberId = "", prevAgeGroup = "", curReadyToSki = "";
String curFileFilter = "SBK files (*.sbk)|*.sbk|All files (*.*)|*.*";
Int16 curRound = 0;
DataRow prevRow = null;
DataRow[] curScoreRows = null;
myTourProperties = TourProperties.Instance;
try {
curMsg = "Exporting Scorebook";
Log.WriteFile( curMethodName + ":begin: " + curMsg );
String curFilename = mySanctionNum.Trim() + myTourClass + ".sbk";
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" );
myProgressInfo.Show();
myProgressInfo.Refresh();
myProgressInfo.setProgressMax( 10 );
CalcScoreSummary curCalcSummary = new CalcScoreSummary();
mySummaryDataTable = null;
DataTable myMemberData = curCalcSummary.getMemberData( mySanctionNum );
myProgressInfo.setProgressValue( 1 );
myProgressInfo.Refresh();
if (myTourRules.ToLower().Equals( "iwwf" )) {
mySummaryDataTable = curCalcSummary.CalcIwwfEventPlcmts( myTourRow, mySanctionNum, "Scorebook", myTourRules, curDataType, curPlcmtMethod, curPlcmtOrg, curPointsMethod, null, null );
myProgressInfo.setProgressValue( 2 );
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( mySanctionNum, 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( 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();
mySummaryDataTable = curCalcSummary.buildOverallSummary( myTourRow, mySlalomDataTable, myTrickDataTable, myJumpDataTable, curDataType, curPlcmtOverallOrg );
myProgressInfo.setProgressValue( 4 );
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();
mySummaryDataTable = curCalcSummary.buildTourScorebook( mySanctionNum, myTourRow, myMemberData, mySummaryDataTable, 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 );
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 ) {
outLine = new StringBuilder( "" );
outBuffer.WriteLine( outLine.ToString() );
curScoreRows = mySummaryDataTable.Select( "MemberId = '" + curMemberId + "' AND AgeGroup = '" + curAgeGroup + "'" );
}
//Initialize control fields
prevMemberId = curMemberId;
prevAgeGroup = curAgeGroup;
curRound = (Int16)curRow["RoundOverall"];
//Initialize output buffer
outLine = new StringBuilder( "" );
//Write skier identification information
outLine.Append( writeSkierInfo( curRow, curRound ) );
//Write skier performance summary information
outLine.Append( writeSkierSlalomScore( curRow, curScoreRows ) );
outLine.Append( writeSkierTrickScore( curRow, curScoreRows ) );
outLine.Append( writeSkierJumpScore( curRow, curScoreRows ) );
outLine.Append( writeSkierOverallScore( curRow ) );
//Write output line to file
outBuffer.WriteLine( outLine.ToString() );
}
//Build file footer and write to file
outLine = new StringBuilder( "" );
outBuffer.WriteLine( outLine.ToString() );
outLine.Append( writeFooter() );
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 + ":complete: " + curMsg );
} catch ( Exception ex ) {
MessageBox.Show( "Error:" + curMethodName + " Could not write file from DataGridView\n\nError: " + ex.Message );
curMsg = curMethodName + ":Exception=" + ex.Message;
Log.WriteFile( curMsg );
returnStatus = false;
}
return returnStatus;
}
public void navRefresh_Click( object sender, EventArgs e )
{
this.Cursor = Cursors.WaitCursor;
// Retrieve data from database
if ( mySanctionNum != null && myTourRow != null ) {
String curDataType = "all", curPlcmtMethod = "score";
String curPlcmtOrg, curPointsMethod;
CalcScoreSummary curCalcSummary = new CalcScoreSummary();
// Retrieve data from database depending on selection criteria
String curMsg = "Tournament scores retrieved ";
if ( bestScoreButton.Checked ) {
curDataType = "best";
winStatusMsg.Text = curMsg + "- best scores ";
} else if ( roundScoreButton.Checked ) {
curDataType = "round";
winStatusMsg.Text = curMsg + "- total scores";
} else if ( finalScoreButton.Checked ) {
curDataType = "final";
winStatusMsg.Text = curMsg + "- final scores";
}
myTourProperties.MasterSummaryOverallDataType = curDataType;
if ( pointsScoreButton.Checked ) {
curPlcmtMethod = "points";
} else if ( handicapScoreButton.Checked ) {
curPlcmtMethod = "hcap";
} else if ( ratioScoreButton.Checked ) {
curPlcmtMethod = "ratio";
} else {
curPlcmtMethod = "points";
}
myTourProperties.MasterSummaryOverallPlcmtMethod = curPlcmtMethod;
EventGroup.Visible = false;
if ( groupPlcmtButton.Checked ) {
curPlcmtOrg = "group";
EventGroup.Visible = true;
} else if ( plcmtTourButton.Checked ) {
curPlcmtOrg = "tour";
} else if ( plcmtDivButton.Checked ) {
curPlcmtOrg = "div";
} else if ( plcmtDivGrpButton.Checked ) {
curPlcmtOrg = "divgr";
EventGroup.Visible = true;
} else {
curPlcmtOrg = "tour";
}
myTourProperties.MasterSummaryOverallPlcmtOrg = curPlcmtOrg;
if ( nopsPointsButton.Checked ) {
curPointsMethod = "nops";
} else if ( plcmtPointsButton.Checked ) {
curPointsMethod = "plcmt";
} else if ( kBasePointsButton.Checked ) {
curPointsMethod = "kbase";
} else if ( ratioPointsButton.Checked ) {
curPointsMethod = "ratio";
} else {
curPointsMethod = "nops";
}
myTourProperties.MasterSummaryOverallPointsMethod = curPointsMethod;
String curFilterSetting = "All";
if ( showAllButton.Checked ) {
curFilterSetting = "All";
} else if ( showQlfyButton.Checked ) {
curFilterSetting = "Qualifed";
} else {
curFilterSetting = "All";
}
myTourProperties.MasterSummaryOverallFilter = curFilterSetting;
/*
if ( EventGroup.Visible ) {
SlalomLabel.Location = new Point( 208, SlalomLabel.Location.Y );
TrickLabel.Location = new Point( 573, SlalomLabel.Location.Y );
JumpLabel.Location = new Point( 830, SlalomLabel.Location.Y );
OverallLabel.Location = new Point( 1062, SlalomLabel.Location.Y );
} else {
SlalomLabel.Location = new Point( 168, SlalomLabel.Location.Y );
TrickLabel.Location = new Point( 533, SlalomLabel.Location.Y );
JumpLabel.Location = new Point( 790, SlalomLabel.Location.Y );
OverallLabel.Location = new Point( 1022, SlalomLabel.Location.Y );
}
*/
String curGroupValue = "";
try {
curGroupValue = EventGroupList.SelectedItem.ToString();
if (!( curGroupValue.ToLower().Equals( "all" ) )) {
if (myTourRules.ToLower().Equals( "ncwsa" )) {
if (curGroupValue.ToUpper().Equals( "MEN A" )) {
curGroupValue = "CM";
} else if (curGroupValue.ToUpper().Equals( "WOMEN A" )) {
curGroupValue = "CW";
} else if (curGroupValue.ToUpper().Equals( "MEN B" )) {
curGroupValue = "BM";
} else if (curGroupValue.ToUpper().Equals( "WOMEN B" )) {
curGroupValue = "BW";
} else {
curGroupValue = "All";
}
}
}
} catch {
curGroupValue = "All";
}
if ( curGroupValue.ToLower().Equals( "all" ) ) {
if ( myTourRules.ToLower().Equals( "iwwf" ) && curPointsMethod.ToLower().Equals( "kbase" ) ) {
mySummaryDataTable = curCalcSummary.CalcIwwfEventPlcmts( myTourRow, mySanctionNum, "Overall", myTourRules, curDataType, curPlcmtMethod, curPlcmtOrg, curPointsMethod, null, null );
} else {
mySlalomDataTable = curCalcSummary.getSlalomSummary( myTourRow, curDataType, curPlcmtMethod, curPlcmtOrg, curPointsMethod );
myTrickDataTable = curCalcSummary.getTrickSummary( myTourRow, curDataType, curPlcmtMethod, curPlcmtOrg, curPointsMethod );
myJumpDataTable = curCalcSummary.getJumpSummary( myTourRow, curDataType, curPlcmtMethod, curPlcmtOrg, curPointsMethod );
mySummaryDataTable = curCalcSummary.buildOverallSummary( myTourRow, mySlalomDataTable, myTrickDataTable, myJumpDataTable, curDataType, curPlcmtOrg );
}
} else {
if ( myTourRules.ToLower().Equals( "iwwf" ) && curPointsMethod.ToLower().Equals( "kbase" ) ) {
mySummaryDataTable = curCalcSummary.CalcIwwfEventPlcmts( myTourRow, mySanctionNum, "Overall", myTourRules, curDataType, curPlcmtMethod, curPlcmtOrg, curPointsMethod, "All", curGroupValue );
} else {
mySlalomDataTable = curCalcSummary.getSlalomSummary( myTourRow, curDataType, curPlcmtMethod, curPlcmtOrg, curPointsMethod, "All", curGroupValue );
myTrickDataTable = curCalcSummary.getTrickSummary( myTourRow, curDataType, curPlcmtMethod, curPlcmtOrg, curPointsMethod, "All", curGroupValue );
myJumpDataTable = curCalcSummary.getJumpSummary( myTourRow, curDataType, curPlcmtMethod, curPlcmtOrg, curPointsMethod, "All", curGroupValue );
mySummaryDataTable = curCalcSummary.buildOverallSummary( myTourRow, mySlalomDataTable, myTrickDataTable, myJumpDataTable, curDataType, curPlcmtOrg );
}
}
loadSummaryDataGrid();
}
this.Cursor = Cursors.Default;
}
public Boolean exportScoreBookData()
{
String curMethodName = "ExportScoreBookHtmlIwwf";
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;
myTourProperties = TourProperties.Instance;
ExportScorebookTypeDialogForm curDialogForm = new ExportScorebookTypeDialogForm();
curDialogForm.ShowDialog();
if (curDialogForm.DialogResult == DialogResult.OK) {
String curReportFormat = curDialogForm.ReportFormat;
if (curReportFormat.Equals( "Magazine" )) {
MessageBox.Show( "This feature is not currently supported for IWWF tournaments" );
} else {
try {
curMsg = "Exporting Scorebook Html";
Log.WriteFile( curMethodName + ":begin: " + curMsg );
String curFilename = mySanctionNum.Trim() + "CS.HTM";
StreamWriter outBuffer = getExportFile( curFileFilter, curFilename );
if (outBuffer == null) {
curMsg = "Output file not available";
} else {
String curPlcmtMethod = "score", curPlcmtOrg = "div", curPointsMethod = "kbase";
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";
}
myProgressInfo = new ProgressWindow();
myProgressInfo.setProgessMsg( "Processing Scorebook HTML" );
myProgressInfo.Show();
myProgressInfo.Refresh();
myProgressInfo.setProgressMax( 10 );
CalcScoreSummary curCalcSummary = new CalcScoreSummary();
DataTable myMemberData = curCalcSummary.getMemberData( mySanctionNum );
myProgressInfo.setProgressValue( 4 );
myProgressInfo.Refresh();
DataTable mySummaryDataTable = curCalcSummary.CalcIwwfEventPlcmts( myTourRow, mySanctionNum, "Scorebook", myTourRules, 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( mySanctionNum, myTourRow, myMemberData, mySummaryDataTable, mySlalomDetail, myTrickDetail, myJumpDetail );
mySummaryDataTable = newSummaryDataTable;
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, mySummaryDataTable );
}
//Build master summary header
writeMasterSummaryHeader( outBuffer, curPlcmtOrg, curReportFormat );
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();
//Initialize control fields
prevMemberId = curMemberId;
prevAgeGroup = curAgeGroup;
curRound = (Int16)curRow["RoundOverall"];
//Initialize output buffer
outLine = new StringBuilder( "<tr>" );
//Write skier identification information
writeSkierInfo( curRow, curRound, outBuffer );
//Write skier performance summary information
writeSkierSlalomScore( curRow, curPlcmtOrg, outBuffer );
writeSkierTrickScore( curRow, curPlcmtOrg, outBuffer );
writeSkierJumpScore( curRow, curPlcmtOrg, outBuffer );
writeSkierOverallScore( curRow, curReportFormat, 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() );
DataTable mySlalomDataTable = curCalcSummary.CalcIwwfEventPlcmts( myTourRow, mySanctionNum, "Slalom", myTourRules, curDataType, curPlcmtMethod, curPlcmtOrg, curPointsMethod, null, null );
writeIndexSlalomResults( curPlcmtOrg, mySlalomDataTable, outBuffer );
DataTable myTrickDataTable = curCalcSummary.CalcIwwfEventPlcmts( myTourRow, mySanctionNum, "Trick", myTourRules, curDataType, curPlcmtMethod, curPlcmtOrg, curPointsMethod, null, null );
writeIndexTrickResults( curPlcmtOrg, myTrickDataTable, outBuffer );
DataTable myJumpDataTable = curCalcSummary.CalcIwwfEventPlcmts( myTourRow, mySanctionNum, "Jump", myTourRules, curDataType, curPlcmtMethod, curPlcmtOrg, curPointsMethod, null, null );
writeIndexJumpResults( curPlcmtOrg, myJumpDataTable, outBuffer );
DataTable myOverallDataTable = curCalcSummary.CalcIwwfEventPlcmts( myTourRow, mySanctionNum, "Overall", myTourRules, "best", curPlcmtMethod, curPlcmtOrg, curPointsMethod, null, null );
writeIndexOverallResults( curPlcmtOrg, myOverallDataTable, outBuffer );
if (isTeamAvailable()) {
//Write team summary
Int16 myNumPerTeam = Convert.ToInt16( myTourProperties.TeamSummary_NumPerTeam);
String curTeamPlcmtOrg = myTourProperties.TeamSummaryPlcmtOrg;
//Int16 myNumPerTeam = Properties.Settings.Default.TeamSummary_NumPerTeam;
//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";
}
String curSortCmd = "";
if (curTeamPlcmtOrg.ToLower().Equals( "div" )) {
curSortCmd = "AgeGroup ASC, PointsSlalom DESC, SkierName ASC";
} else {
curSortCmd = "PointsSlalom DESC, SkierName ASC";
}
mySlalomDataTable.DefaultView.Sort = curSortCmd;
mySlalomDataTable = mySlalomDataTable.DefaultView.ToTable();
DataTable myTeamDataTable = curCalcSummary.getSlalomSummaryTeam( mySlalomDataTable, myTourRow, myNumPerTeam, curTeamDataType, curTeamPlcmtMethod, curTeamPlcmtOrg, curTeamPointsMethod );
if (curTeamPlcmtOrg.ToLower().Equals( "div" )) {
curSortCmd = "AgeGroup ASC, PointsTrick DESC, SkierName ASC";
} else {
curSortCmd = "PointsTrick DESC, SkierName ASC";
}
myTrickDataTable.DefaultView.Sort = curSortCmd;
myTrickDataTable = myTrickDataTable.DefaultView.ToTable();
myTeamDataTable = curCalcSummary.getTrickSummaryTeam( myTeamDataTable, myTrickDataTable, myTourRow, myNumPerTeam, curTeamDataType, curTeamPlcmtMethod, curTeamPlcmtOrg, curTeamPointsMethod );
if (curTeamPlcmtOrg.ToLower().Equals( "div" )) {
curSortCmd = "AgeGroup ASC, PointsJump DESC, SkierName ASC";
} else {
curSortCmd = "PointsJump DESC, SkierName ASC";
}
myJumpDataTable.DefaultView.Sort = curSortCmd;
myJumpDataTable = myJumpDataTable.DefaultView.ToTable();
myTeamDataTable = curCalcSummary.getJumpSummaryTeam( myTeamDataTable, myJumpDataTable, myTourRow, myNumPerTeam, curTeamDataType, curTeamPlcmtMethod, curTeamPlcmtOrg, curTeamPointsMethod );
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;
}