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 void navRefresh_Click(object sender, EventArgs e)
{
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.TrickScorebookDataType = 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.TrickScorebookPointsMethod = 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.TrickScorebookPlcmtOrg = 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
{
myTrickDataTable = curCalcSummary.getTrickSummary(myTourRow, curDataType, curPlcmtMethod, curPlcmtOrg, curPointsMethod);
mySummaryDataTable = curCalcSummary.buildOverallSummary(myTourRow, null, myTrickDataTable, null, curDataType, curPlcmtOverallOrg);
myMemberData = curCalcSummary.getMemberData(mySanctionNum);
myTrickDetail = curCalcSummary.getTrickScoreDetail(myTourRow, curPlcmtMethod, curPlcmtOrg, curPointsMethod, null, null);
mySummaryDataTable = curCalcSummary.buildTourScorebook(mySanctionNum, myTourRow, myMemberData, mySummaryDataTable, null, myTrickDetail, 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
{
myTrickDataTable = curCalcSummary.getTrickSummary(myTourRow, curDataType, curPlcmtMethod, curPlcmtOrg, curPointsMethod, "All", curGroupValue);
mySummaryDataTable = curCalcSummary.buildOverallSummary(myTourRow, null, myTrickDataTable, null, curDataType, curPlcmtOverallOrg);
myMemberData = curCalcSummary.getMemberData(mySanctionNum, curGroupValue);
myTrickDetail = curCalcSummary.getTrickScoreDetail(myTourRow, curPlcmtMethod, curPlcmtOrg, curPointsMethod, "All", curGroupValue);
mySummaryDataTable = curCalcSummary.buildTourScorebook(mySanctionNum, myTourRow, myMemberData, mySummaryDataTable, null, myTrickDetail, 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 && 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;
}