public void RunningOrderForEvent(String inEvent)
{
myTourProperties = TourProperties.Instance;
if (inEvent.Equals( "Slalom" )) {
mySortCmd = myTourProperties.RunningOrderSortSlalom;
slalomButton.Checked = true;
} else if ( inEvent.Equals( "Trick" ) ) {
mySortCmd = myTourProperties.RunningOrderSortTrick;
trickButton.Checked = true;
} else if ( inEvent.Equals( "Jump" ) ) {
mySortCmd = myTourProperties.RunningOrderSortJump;
jumpButton.Checked = true;
}
}
public void RunningOrderForEvent(DataRow inTourRow, String inEvent) {
myTourProperties = TourProperties.Instance;
myTourRow = inTourRow;
myEvent = inEvent;
if (inEvent.Equals("Slalom")) {
this.Text = myWindowTitle + " - Slalom";
mySortCmd = myTourProperties.RunningOrderSortSlalom;
} else if (inEvent.Equals( "Trick" )) {
this.Text = myWindowTitle + " - Trick";
mySortCmd = myTourProperties.RunningOrderSortTrick;
} else if (inEvent.Equals( "Jump" )) {
this.Text = myWindowTitle + " - Jump";
mySortCmd = myTourProperties.RunningOrderSortJump;
}
myTourRules = (String)myTourRow["Rules"];
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 ( myEvent.ToLower().Equals("slalom") ) {
myRounds = Convert.ToInt16(myTourRow["SlalomRounds"]);
} else if (myEvent.ToLower().Equals("trick")) {
myRounds = Convert.ToInt16(myTourRow["TrickRounds"]);
} else if (myEvent.ToLower().Equals("jump")) {
myRounds = Convert.ToInt16(myTourRow["JumpRounds"]);
}
//Load round selection list based on number of rounds specified for the tournament
roundActiveSelect.SelectList_LoadHorztl( myRounds.ToString(), roundActiveSelect_Click, false );
roundActiveSelect.RoundValue = "1";
mySanctionNum = Properties.Settings.Default.AppSanctionNum;
//navRefresh_Click(null, null);
}
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 SlalomScorebook_Load( object sender, EventArgs e )
{
if ( Properties.Settings.Default.SlalomScorebook_Width > 0 ) {
this.Width = Properties.Settings.Default.SlalomScorebook_Width;
}
if ( Properties.Settings.Default.SlalomScorebook_Height > 0 ) {
this.Height = Properties.Settings.Default.SlalomScorebook_Height;
}
if ( Properties.Settings.Default.SlalomScorebook_Location.X > 0
&& Properties.Settings.Default.SlalomScorebook_Location.Y > 0 ) {
this.Location = Properties.Settings.Default.SlalomScorebook_Location;
}
myTourProperties = TourProperties.Instance;
bestScoreButton.Checked = true;
if ( myTourProperties.SlalomScorebookDataType.ToLower().Equals( "total" ) ) totalScoreButton.Checked = true;
if ( myTourProperties.SlalomScorebookDataType.ToLower().Equals( "final" ) ) finalScoreButton.Checked = true;
if ( myTourProperties.SlalomScorebookDataType.ToLower().Equals( "first" ) ) firstScoreButton.Checked = true;
nopsPointsButton.Checked = true;
if ( myTourProperties.SlalomScorebookPointsMethod.ToLower().Equals( "nops" ) ) nopsPointsButton.Checked = true;
if ( myTourProperties.SlalomScorebookPointsMethod.ToLower().Equals( "plcmt" ) ) plcmtPointsButton.Checked = true;
if ( myTourProperties.SlalomScorebookPointsMethod.ToLower().Equals( "kbase" ) ) kBasePointsButton.Checked = true;
if ( myTourProperties.SlalomScorebookPointsMethod.ToLower().Equals( "ratio" ) ) ratioPointsButton.Checked = true;
plcmtDivButton.Checked = true;
if ( myTourProperties.SlalomScorebookPlcmtOrg.ToLower().Equals( "div" ) ) plcmtDivButton.Checked = true;
if ( myTourProperties.SlalomScorebookPlcmtOrg.ToLower().Equals( "divgr" ) ) plcmtDivGrpButton.Checked = true;
// 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 {
//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( "iwwf" ) ) {
kBasePointsButton.Checked = true;
} else if ( myTourRules.ToLower().Equals( "ncwsa" ) ) {
plcmtPointsButton.Checked = true;
}
loadEventGroupList();
}
}
}
}
private void SlalomSummary_Load(object sender, EventArgs e)
{
if (Properties.Settings.Default.SlalomScoreSummary_Width > 0) {
this.Width = Properties.Settings.Default.SlalomScoreSummary_Width;
}
if (Properties.Settings.Default.SlalomScoreSummary_Height > 0) {
this.Height = Properties.Settings.Default.SlalomScoreSummary_Height;
}
if (Properties.Settings.Default.SlalomScoreSummary_Location.X > 0
&& Properties.Settings.Default.SlalomScoreSummary_Location.Y > 0) {
this.Location = Properties.Settings.Default.SlalomScoreSummary_Location;
}
myTourProperties = TourProperties.Instance;
bestScoreButton.Checked = true;
if (myTourProperties.SlalomSummaryDataType.ToLower().Equals( "best" )) bestScoreButton.Checked = true;
if ( myTourProperties.SlalomSummaryDataType.ToLower().Equals( "total" ) ) totalScoreButton.Checked = true;
if ( myTourProperties.SlalomSummaryDataType.ToLower().Equals( "final" ) ) finalScoreButton.Checked = true;
if ( myTourProperties.SlalomSummaryDataType.ToLower().Equals( "first" ) ) firstScoreButton.Checked = true;
if ( myTourProperties.SlalomSummaryDataType.ToLower().Equals( "round" ) ) roundScoreButton.Checked = true;
if (myTourProperties.SlalomSummaryDataType.ToLower().Equals( "h2h" )) h2hScoreButton.Checked = true;
rawScoreButton.Checked = true;
if ( myTourProperties.SlalomSummaryPlcmtMethod.ToLower().Equals( "points" ) ) pointsScoreButton.Checked = true;
groupPlcmtButton.Checked = true;
if ( myTourProperties.SlalomSummaryPlcmtOrg.ToLower().Equals( "tour" ) ) plcmtTourButton.Checked = true;
if ( myTourProperties.SlalomSummaryPlcmtOrg.ToLower().Equals( "div" ) ) plcmtDivButton.Checked = true;
if ( myTourProperties.SlalomSummaryPlcmtOrg.ToLower().Equals( "divgr" ) ) plcmtDivGrpButton.Checked = true;
nopsPointsButton.Checked = true;
if ( myTourProperties.SlalomSummaryPointsMethod.ToLower().Equals( "nops" ) ) nopsPointsButton.Checked = true;
if ( myTourProperties.SlalomSummaryPointsMethod.ToLower().Equals( "plcmt" ) ) plcmtPointsButton.Checked = true;
if ( myTourProperties.SlalomSummaryPointsMethod.ToLower().Equals( "kbase" ) ) kBasePointsButton.Checked = true;
if ( myTourProperties.SlalomSummaryPointsMethod.ToLower().Equals( "hcap" ) ) handicapPointsButton.Checked = true;
if ( myTourProperties.SlalomSummaryPointsMethod.ToLower().Equals( "ratio" ) ) ratioPointsButton.Checked = true;
numPrelimTextBox.Text = myTourProperties.SlalomSummaryNumPrelim;
String[] curList = { "MemberId", "SkierName", "City", "State", "SkiYearAge", "AgeGroup", "Event"
, "EventClassSlalom", "PlcmtSlalom", "TeamSlalom", "HCapBaseSlalom"
, "RoundSlalom", "ScoreSlalom", "PointsSlalom"
, "FinalPassNum", "FinalSpeedMph", "FinalSpeedKph", "FinalLen", "FinalLenOff", "FinalPassScore" };
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");
} 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];
myTourRules = (String)myTourRow["Rules"];
if ( myTourProperties.SlalomScoreSummary_Sort.Length > 0 ) {
mySortCommand = myTourProperties.SlalomScoreSummary_Sort;
} else {
mySortCommand = "";
}
if (myTourRules.ToLower().Equals( "ncwsa" )) {
Round.Visible = false;
EventClass.Visible = false;
TeamCodeNcwsa.Visible = true;
TeamCode.Visible = false;
} else {
TeamCodeNcwsa.Visible = false;
TeamCode.Visible = true;
}
loadGroupList();
}
}
}
}
private void TrickSummaryTeam_Load( object sender, EventArgs e )
{
if ( Properties.Settings.Default.TrickTeamSummary_Width > 0 ) {
this.Width = Properties.Settings.Default.TrickTeamSummary_Width;
}
if ( Properties.Settings.Default.TrickTeamSummary_Height > 0 ) {
this.Height = Properties.Settings.Default.TrickTeamSummary_Height;
}
if ( Properties.Settings.Default.TrickTeamSummary_Location.X > 0
&& Properties.Settings.Default.TrickTeamSummary_Location.Y > 0 ) {
this.Location = Properties.Settings.Default.TrickTeamSummary_Location;
}
myTourProperties = TourProperties.Instance;
bestScoreButton.Checked = true;
if (myTourProperties.TrickTeamSummaryDataType.ToLower().Equals( "best" )) bestScoreButton.Checked = true;
if (myTourProperties.TrickTeamSummaryDataType.ToLower().Equals( "total" )) totalScoreButton.Checked = true;
if ( myTourProperties.TrickTeamSummaryDataType.ToLower().Equals( "final" ) ) finalScoreButton.Checked = true;
rawScoreButton.Checked = true;
if (myTourProperties.TrickTeamSummaryPlcmtMethod.ToLower().Equals( "score" )) rawScoreButton.Checked = true;
if (myTourProperties.TrickTeamSummaryPlcmtMethod.ToLower().Equals( "points" )) pointsScoreButton.Checked = true;
plcmtTourButton.Checked = true;
if (myTourProperties.TrickTeamSummaryPlcmtOrg.ToLower().Equals( "tour" )) plcmtTourButton.Checked = true;
if (myTourProperties.TrickTeamSummaryPlcmtOrg.ToLower().Equals( "div" )) divPlcmtButton.Checked = true;
if (myTourProperties.SlalomTeamSummaryPlcmtOrg.ToLower().Equals( "group" )) groupPlcmtButton.Checked = true;
plcmtPointsButton.Checked = true;
if ( myTourProperties.TrickTeamSummaryPointsMethod.ToLower().Equals( "nops" ) ) nopsPointsButton.Checked = true;
if ( myTourProperties.TrickTeamSummaryPointsMethod.ToLower().Equals( "plcmt" ) ) plcmtPointsButton.Checked = true;
if ( myTourProperties.TrickTeamSummaryPointsMethod.ToLower().Equals( "kbase" ) ) kBasePointsButton.Checked = true;
if ( myTourProperties.TrickTeamSummaryPointsMethod.ToLower().Equals( "hcap" ) ) handicapPointsButton.Checked = true;
if ( myTourProperties.TrickTeamSummaryPointsMethod.ToLower().Equals( "ratio" ) ) ratioPointsButton.Checked = true;
// 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 {
myNumPerTeam = Convert.ToInt16( myTourProperties.TrickTeamSummary_NumPerTeam);
NumPerTeamTextBox.Text = myNumPerTeam.ToString();
//Retrieve selected tournament attributes
DataTable curTourDataTable = getTourData();
if (curTourDataTable.Rows.Count > 0) {
myTourRow = curTourDataTable.Rows[0];
myTourRules = (String)myTourRow["Rules"];
if (myTourRules.ToLower().Equals( "ncwsa" )) {
Round.Visible = false;
EventClass.Visible = false;
}
loadGroupList();
}
}
}
}
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;
}
private void TourList_Load(object sender, EventArgs e)
{
if (Properties.Settings.Default.TourList_Width > 0) {
this.Width = Properties.Settings.Default.TourList_Width;
}
if (Properties.Settings.Default.TourList_Height > 0) {
this.Height = Properties.Settings.Default.TourList_Height;
}
if (Properties.Settings.Default.TourList_Location.X > 0
&& Properties.Settings.Default.TourList_Location.Y > 0) {
this.Location = Properties.Settings.Default.TourList_Location;
}
myTourProperties = TourProperties.Instance;
mySortCommand = "SanctionId ASC";
sortDialogForm = new SortDialogForm();
sortDialogForm.ColumnList = dataGridView.Columns;
filterDialogForm = new Common.FilterDialogForm();
filterDialogForm.ColumnList = dataGridView.Columns;
//Retrieve tournament list and set current position to active tournament
navRefresh_Click( null, null );
}
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 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;
}
private void MasterSummaryOverallUS_Load( object sender, EventArgs e )
{
if ( Properties.Settings.Default.MasterSummaryOverallUS_Width > 0 ) {
this.Width = Properties.Settings.Default.MasterSummaryOverallUS_Width;
}
if ( Properties.Settings.Default.MasterSummaryOverallUS_Height > 0 ) {
this.Height = Properties.Settings.Default.MasterSummaryOverallUS_Height;
}
if ( Properties.Settings.Default.MasterSummaryOverallUS_Location.X > 0
&& Properties.Settings.Default.MasterSummaryOverallUS_Location.Y > 0 ) {
this.Location = Properties.Settings.Default.MasterSummaryOverallUS_Location;
}
myTourProperties = TourProperties.Instance;
bestScoreButton.Checked = true;
if (myTourProperties.MasterSummaryOverallDataType.ToLower().Equals( "best" )) bestScoreButton.Checked = true;
if (myTourProperties.MasterSummaryOverallDataType.ToLower().Equals( "round" )) roundScoreButton.Checked = true;
if (myTourProperties.MasterSummaryOverallDataType.ToLower().Equals( "final" )) finalScoreButton.Checked = true;
pointsScoreButton.Checked = true;
if (myTourProperties.MasterSummaryOverallPlcmtMethod.ToLower().Equals( "points" )) pointsScoreButton.Checked = true;
if (myTourProperties.MasterSummaryOverallPlcmtMethod.ToLower().Equals( "hcap" )) handicapScoreButton.Checked = true;
if (myTourProperties.MasterSummaryOverallPlcmtMethod.ToLower().Equals( "ratio" )) ratioScoreButton.Checked = true;
plcmtDivButton.Checked = true;
if (myTourProperties.MasterSummaryOverallPlcmtOrg.ToLower().Equals( "div" )) plcmtDivButton.Checked = true;
if (myTourProperties.MasterSummaryOverallPlcmtOrg.ToLower().Equals( "divgr" )) plcmtDivGrpButton.Checked = true;
if (myTourProperties.MasterSummaryOverallPlcmtOrg.ToLower().Equals( "tour" )) plcmtTourButton.Checked = true;
if (myTourProperties.MasterSummaryOverallPlcmtOrg.ToLower().Equals( "group" )) groupPlcmtButton.Checked = true;
nopsPointsButton.Checked = true;
if (myTourProperties.MasterSummaryOverallPointsMethod.ToLower().Equals( "nops" )) nopsPointsButton.Checked = true;
if (myTourProperties.MasterSummaryOverallPointsMethod.ToLower().Equals( "plcmt" )) plcmtPointsButton.Checked = true;
if (myTourProperties.MasterSummaryOverallPointsMethod.ToLower().Equals( "kbase" )) kBasePointsButton.Checked = true;
if (myTourProperties.MasterSummaryOverallPointsMethod.ToLower().Equals( "ratio" )) ratioPointsButton.Checked = true;
showAllButton.Checked = true;
if (myTourProperties.MasterSummaryOverallFilter.ToLower().Equals( "all" )) showAllButton.Checked = true;
if (myTourProperties.MasterSummaryOverallFilter.ToLower().Equals( "qualifed" )) showQlfyButton.Checked = true;
if (myTourProperties.MasterSummaryOverallFilter.ToLower().Equals( "eligible" )) showEligButton.Checked = true;
// 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 {
//Retrieve selected tournament attributes
DataTable curTourDataTable = getTourData();
if (curTourDataTable.Rows.Count > 0) {
myTourRow = curTourDataTable.Rows[0];
myTourRules = (String)myTourRow["Rules"];
if (myTourRules.ToLower().Equals( "ncwsa" )) {
RoundOverall.Visible = false;
RoundSlalom.Visible = false;
RoundTrick.Visible = false;
RoundJump.Visible = false;
EventClassSlalom.Visible = false;
EventClassTrick.Visible = false;
EventClassJump.Visible = false;
TeamCodeNcwsa.Visible = true;
} else {
RoundOverall.Visible = true;
RoundSlalom.Visible = true;
RoundTrick.Visible = true;
RoundJump.Visible = true;
EventClassSlalom.Visible = true;
EventClassTrick.Visible = true;
EventClassJump.Visible = true;
TeamCodeNcwsa.Visible = false;
}
loadEventGroupList();
}
}
}
}
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;
}
public bool ExportData()
{
DataTable curDataTable, curDetailDataTable, curScoresDataTable;
try {
//Retrieve selected tournament attributes
DataTable curTourDataTable = getTourData();
myTourRow = curTourDataTable.Rows[0];
myTourRules = (String)myTourRow["Rules"];
myTourProperties = TourProperties.Instance;
if (myTourRow["SlalomRounds"] == DBNull.Value) { myTourRow["SlalomRounds"] = 0; }
if ( myTourRow["TrickRounds"] == DBNull.Value ) { myTourRow["TrickRounds"] = 0; }
if ( myTourRow["JumpRounds"] == DBNull.Value ) { myTourRow["JumpRounds"] = 0; }
Int16 curEventRounds = 0;
try {
curEventRounds = Convert.ToInt16( myTourRow["SlalomRounds"] );
if ( curEventRounds > 0 ) {
isSlalomActive = true;
} else {
isSlalomActive = false;
}
} catch {
isSlalomActive = false;
}
try {
curEventRounds = Convert.ToInt16( myTourRow["TrickRounds"] );
if ( curEventRounds > 0 ) {
isTrickActive = true;
} else {
isTrickActive = false;
}
} catch {
isTrickActive = false;
}
try {
curEventRounds = Convert.ToInt16( myTourRow["JumpRounds"] );
if ( curEventRounds > 0 ) {
isJumpActive = true;
} else {
isJumpActive = false;
}
} catch {
isJumpActive = false;
}
StringBuilder outLine = new StringBuilder( "" );
String curFilename = mySanctionNum.Trim() + "TS.prn";
myOutBuffer = getExportFile( curFilename );
if ( myOutBuffer != null ) {
Log.WriteFile( "Export tournament summary: " + curFilename );
writeHeader();
OfficialWorkUpdate curWorkRecordUpdate = new OfficialWorkUpdate();
curWorkRecordUpdate.updateOfficialWorkRecord();
readExportTourSkierCounts();
readExportEventSkierCounts();
readExportEventSkierGroupCounts();
curDataTable = getOfficialWorkAsgmt();
readExportOfficialAsgmt(curDataTable);
if ( isSlalomActive ) {
curScoresDataTable = getSlalomScores();
curDetailDataTable = getSlalomDetail();
readExportSlalomData( curScoresDataTable, curDetailDataTable );
}
if ( isTrickActive ) {
curScoresDataTable = getTrickScores();
curDetailDataTable = getTrickDetail();
readExportTrickData( curScoresDataTable, curDetailDataTable );
}
if ( isJumpActive ) {
curScoresDataTable = getJumpScores();
curDetailDataTable = getJumpDetail();
readExportJumpData( curScoresDataTable, curDetailDataTable );
}
DataTable curTeamDataTable = getTeamList();
if ( curTeamDataTable.Rows.Count > 0 ) {
readExportTeamData();
}
writeFooter();
Log.WriteFile( "Export tournament summary complete: " + curFilename );
myOutBuffer.Close();
return true;
} else {
return false;
}
} catch ( Exception ex ) {
MessageBox.Show( "Exception encountered in ExportTourSummary processing"
+ "\n\nException: " + ex.Message
);
return false;
}
}
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;
}
private void RunningOrderRound_Load(object sender, EventArgs e) {
if (Properties.Settings.Default.RunningOrderRound_Width > 0) {
this.Width = Properties.Settings.Default.RunningOrderRound_Width;
}
if (Properties.Settings.Default.RunningOrderRound_Height > 0) {
this.Height = Properties.Settings.Default.RunningOrderRound_Height;
}
if (Properties.Settings.Default.RunningOrder_Location.X > 0
&& Properties.Settings.Default.RunningOrderRound_Location.Y > 0) {
this.Location = Properties.Settings.Default.RunningOrderRound_Location;
}
myTourProperties = TourProperties.Instance;
myRunOrderCopyDialog = new RunOrderCopyDialogForm();
myRunOrderElimDialog = new RunOrderElimDialogForm();
myCalcSummary = new CalcScoreSummary();
mySanctionNum = Properties.Settings.Default.AppSanctionNum;
loadGroupList();
isDataModified = false;
}
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;
}
