private void LoadAgeGroupList()
{
try {
Int16 curValue = Convert.ToInt16(editSkiYearAge.Text);
editSkiYearAge.Text = curValue.ToString();
if (curValue > 1 && curValue < 100)
{
if (editGenderSelect.RatingValue.Length > 0)
{
AgeGroupSelect.SelectList_Load(curValue, editGenderSelect.RatingValue, myTourRow, AgeGroupSelect_Change);
}
else
{
AgeGroupSelect.SelectList_Load(AgeGroupSelect_Change);
}
}
else
{
AgeGroupSelect.SelectList_Load(editGenderSelect.RatingValue, myTourRow, AgeGroupSelect_Change);
editSkiYearAge.Text = "";
}
AgeGroupSelect.CurrentValue = "";
} catch {
}
}
private bool checkSkierEventReg()
{
bool curReturnStatus = true;
StringBuilder curSqlStmt = new StringBuilder("");
DataTable curDataTable = null;
if (AgeGroupSelect.isDivisionIntl(AgeGroupSelect.CurrentValue))
{
//Check for event registrations using the original age group
String curMemberId = editMemberId.Text;
curSqlStmt.Append("Select MemberId, AgeGroup, Event, EventClass ");
curSqlStmt.Append("From EventReg ");
curSqlStmt.Append("Where SanctionId = '" + mySanctionNum + "' AND MemberId = '" + curMemberId + "' AND AgeGroup = '" + myAgeGroup + "' ");
curDataTable = DataAccess.getDataTable(curSqlStmt.ToString());
if (curDataTable == null)
{
curReturnStatus = true;
}
else
{
curReturnStatus = true;
curSqlStmt = new StringBuilder("");
curSqlStmt.Append("SELECT ListCode, CodeValue, ListCodeNum, SortSeq FROM CodeValueList WHERE ListName = 'AWSAAgeGroup' AND CodeValue = '" + AgeGroupSelect.CurrentValue + "'");
curDataTable = DataAccess.getDataTable(curSqlStmt.ToString());
if (curDataTable.Rows.Count > 0)
{
DataRow[] curFindClassERow, curFindEventClassRow;
DataRow curClassERow, curTourClassRow;
int curClassEValue = 0, curEventClassValue = 0;
curSqlStmt = new StringBuilder("");
curSqlStmt.Append("SELECT ListCode, CodeValue, ListCodeNum, SortSeq FROM CodeValueList WHERE ListName = 'ClassTour' ORDER BY SortSeq");
DataTable curTourClassDataTable = DataAccess.getDataTable(curSqlStmt.ToString());
curFindClassERow = curTourClassDataTable.Select("ListCode = 'E'");
curClassERow = curFindClassERow[0];
curClassEValue = Convert.ToInt32((Decimal)curClassERow["ListCodeNum"]);
foreach (DataRow curEventRegRow in curDataTable.Rows)
{
curFindEventClassRow = curTourClassDataTable.Select("ListCode = '" + curEventRegRow["EventClass"] + "'");
if (curFindEventClassRow.Length > 0)
{
curTourClassRow = curFindEventClassRow[0];
curEventClassValue = Convert.ToInt32((Decimal)curTourClassRow["ListCodeNum"]);
if (curEventClassValue > curClassEValue)
{
}
else
{
MessageBox.Show("Skier registered in an event with a class less than allowed for an international division");
curReturnStatus = false;
break;
}
}
}
}
curSqlStmt = new StringBuilder("");
curSqlStmt.Append("SELECT S.MemberId, S.AgeGroup, R.Event, S.Round ");
curSqlStmt.Append("FROM EventReg R ");
curSqlStmt.Append("INNER JOIN SlalomScore S ON S.SanctionId = R.SanctionId AND S.MemberId = R.MemberId AND S.AgeGroup = R.AgeGroup ");
curSqlStmt.Append("Where R.SanctionId = '" + mySanctionNum + "' AND R.MemberId = '" + curMemberId + "' AND R.AgeGroup = '" + myAgeGroup + "' AND R.Event = 'Slalom' ");
curSqlStmt.Append("UNION ");
curSqlStmt.Append("SELECT S.MemberId, S.AgeGroup, R.Event, S.Round ");
curSqlStmt.Append("FROM EventReg R ");
curSqlStmt.Append("INNER JOIN TrickScore S ON S.SanctionId = R.SanctionId AND S.MemberId = R.MemberId AND S.AgeGroup = R.AgeGroup ");
curSqlStmt.Append("Where R.SanctionId = '" + mySanctionNum + "' AND R.MemberId = '" + curMemberId + "' AND R.AgeGroup = '" + myAgeGroup + "' AND R.Event = 'Trick' ");
curSqlStmt.Append("UNION ");
curSqlStmt.Append("SELECT S.MemberId, S.AgeGroup, R.Event, S.Round ");
curSqlStmt.Append("FROM EventReg R ");
curSqlStmt.Append("INNER JOIN JumpScore S ON S.SanctionId = R.SanctionId AND S.MemberId = R.MemberId AND S.AgeGroup = R.AgeGroup ");
curSqlStmt.Append("Where R.SanctionId = '" + mySanctionNum + "' AND R.MemberId = '" + curMemberId + "' AND R.AgeGroup = '" + myAgeGroup + "' AND R.Event = 'Jump' ");
curDataTable = DataAccess.getDataTable(curSqlStmt.ToString());
if (curDataTable != null)
{
if (curDataTable.Rows.Count > 0)
{
MessageBox.Show("Skier has scores that should be reviewed to determine if they need to be recalculated. "
+ "Slalom scores will be significantly different when switching from an AWSA division to an IWWF division."
+ "\n\nTo recalculate a slalom score simply re-enter the boat time for the last passed and this will trigger a recalculation including rules analysis."
+ "\n\nJump scores should also be re-calculated by re-entering the boat times for the last pass."
+ "\n\nTrick scores can be recalculated by using the 'Calc' button."
);
}
}
}
}
else
{
String curMemberId = editMemberId.Text;
curSqlStmt = new StringBuilder("");
curSqlStmt.Append("SELECT S.MemberId, S.AgeGroup, R.Event, S.Round ");
curSqlStmt.Append("FROM EventReg R ");
curSqlStmt.Append("INNER JOIN SlalomScore S ON S.SanctionId = R.SanctionId AND S.MemberId = R.MemberId AND S.AgeGroup = R.AgeGroup ");
curSqlStmt.Append("Where R.SanctionId = '" + mySanctionNum + "' AND R.MemberId = '" + curMemberId + "' AND R.AgeGroup = '" + myAgeGroup + "' AND R.Event = 'Slalom' ");
curSqlStmt.Append("UNION ");
curSqlStmt.Append("SELECT S.MemberId, S.AgeGroup, R.Event, S.Round ");
curSqlStmt.Append("FROM EventReg R ");
curSqlStmt.Append("INNER JOIN TrickScore S ON S.SanctionId = R.SanctionId AND S.MemberId = R.MemberId AND S.AgeGroup = R.AgeGroup ");
curSqlStmt.Append("Where R.SanctionId = '" + mySanctionNum + "' AND R.MemberId = '" + curMemberId + "' AND R.AgeGroup = '" + myAgeGroup + "' AND R.Event = 'Trick' ");
curSqlStmt.Append("UNION ");
curSqlStmt.Append("SELECT S.MemberId, S.AgeGroup, R.Event, S.Round ");
curSqlStmt.Append("FROM EventReg R ");
curSqlStmt.Append("INNER JOIN JumpScore S ON S.SanctionId = R.SanctionId AND S.MemberId = R.MemberId AND S.AgeGroup = R.AgeGroup ");
curSqlStmt.Append("Where R.SanctionId = '" + mySanctionNum + "' AND R.MemberId = '" + curMemberId + "' AND R.AgeGroup = '" + myAgeGroup + "' AND R.Event = 'Jump' ");
curDataTable = DataAccess.getDataTable(curSqlStmt.ToString());
if (curDataTable != null)
{
if (curDataTable.Rows.Count > 0)
{
MessageBox.Show("Skier has scores that should be reviewed to determine if they need to be recalculated. "
+ "\n\nTo recalculate a slalom score simply re-enter the boat time for the last passed and this will trigger a recalculation including rules analysis."
+ "\n\nJump scores should also be re-calculated by re-entering the boat times for the last pass."
+ "\n\nTrick scores can be recalculated by using the 'Calc' button."
);
}
}
}
return(curReturnStatus);
}
private void editMemberDataLoad(String inMemberId, String inAgeGroup)
{
DataRow curDataRow = getMemberTourReg(inMemberId, inAgeGroup);
if (curDataRow == null)
{
MessageBox.Show("Tournament registration entry not found for member " + inMemberId + " in division " + inAgeGroup);
return;
}
editMemberId.Text = (String)curDataRow["MemberId"];
try {
String curFirstName = "", curLastName = "", curSkierName = "";
if (curDataRow["SkierName"] != System.DBNull.Value)
{
curSkierName = (String)curDataRow["SkierName"];
}
if (curDataRow["FirstName"] != System.DBNull.Value)
{
curFirstName = (String)curDataRow["FirstName"];
}
if (curDataRow["FirstName"] != System.DBNull.Value)
{
curLastName = (String)curDataRow["LastName"];
}
if (curSkierName.Length == 0)
{
curSkierName = curLastName + ", " + curFirstName;
}
if (curFirstName.Length > 0 && curLastName.Length > 0)
{
editFirstName.Text = curFirstName;
editLastName.Text = curLastName;
}
else
{
String[] curNameList = curSkierName.Split(',');
if (curNameList.Length > 1)
{
editFirstName.Text = curNameList[1].Trim();
editLastName.Text = curNameList[0].Trim();
}
else
{
editFirstName.Text = "";
editLastName.Text = curNameList[0].Trim();
}
}
} catch {
editFirstName.Text = "";
editLastName.Text = "";
}
try {
editGenderSelect.RatingValue = (String)curDataRow["Gender"];
} catch {
editGenderSelect.RatingValue = "";
}
try {
Byte curValue = (byte)curDataRow["SkiYearAge"];
editSkiYearAge.Text = curValue.ToString();
if (curValue > 1 && curValue < 100)
{
if (editGenderSelect.RatingValue.Length > 0)
{
AgeGroupSelect.SelectList_Load(curValue, editGenderSelect.RatingValue, myTourRow, AgeGroupSelect_Change);
}
else
{
AgeGroupSelect.SelectList_Load(AgeGroupSelect_Change);
}
}
else
{
if (editGenderSelect.RatingValue.Length > 0)
{
AgeGroupSelect.SelectList_Load(editGenderSelect.RatingValue, myTourRow, AgeGroupSelect_Change);
}
else
{
AgeGroupSelect.SelectList_Load(AgeGroupSelect_Change);
}
editSkiYearAge.Text = "";
}
AgeGroupSelect.CurrentValue = (String)curDataRow["AgeGroup"];
} catch {
if (editGenderSelect.RatingValue.Length > 0)
{
AgeGroupSelect.SelectList_Load(editGenderSelect.RatingValue, myTourRow, AgeGroupSelect_Change);
}
else
{
AgeGroupSelect.SelectList_Load(AgeGroupSelect_Change);
}
AgeGroupSelect.CurrentValue = (String)curDataRow["AgeGroup"];
editSkiYearAge.Text = "";
}
try {
editCity.Text = (String)curDataRow["City"];
} catch {
editCity.Text = "";
}
try {
editState.Text = (String)curDataRow["State"];
} catch {
editState.Text = "";
}
try {
editFederation.SelectedValue = (String)curDataRow["Federation"];
} catch {
editFederation.SelectedValue = "";
}
if (((String)curDataRow["MemberStatus"]).Length > 0)
{
editMemberStatus.Text = (String)curDataRow["MemberStatus"];
}
else
{
try {
if (((String)curDataRow["ReadyToSki"]).Equals("Y"))
{
editMemberStatus.Text = "Active";
}
else
{
editMemberStatus.Text = "Inactive";
}
} catch {
editMemberStatus.Text = "Inactive";
}
}
showMemberRegList();
}
private void editMemberDataLoad(String inMemberId)
{
myMemberRow = getMemberData(myMemberId);
if (myMemberRow == null)
{
MessageBox.Show("Member data not found for MemberId " + myMemberId);
return;
}
editMemberId.Text = (String)myMemberRow["MemberId"];
try {
editFirstName.Text = (String)myMemberRow["FirstName"];
editLastName.Text = (String)myMemberRow["LastName"];
} catch {
String curSkierName = (String)myMemberRow["SkierName"];
String[] curNameList = curSkierName.Split(',');
if (curNameList.Length > 1)
{
editLastName.Text = curNameList[0].Trim();
editFirstName.Text = curNameList[1].Trim();
}
else
{
editLastName.Text = curNameList[0].Trim();
editFirstName.Text = "";
}
}
try {
editGenderSelect.RatingValue = (String)myMemberRow["Gender"];
} catch {
editGenderSelect.RatingValue = "";
}
try {
editSkiYearAge.Text = ((Byte)myMemberRow["SkiYearAge"]).ToString();
} catch {
if (editGenderSelect.RatingValue.Length > 0)
{
AgeGroupSelect.SelectList_Load(editGenderSelect.RatingValue, myTourRow, AgeGroupSelect_Change);
}
else
{
AgeGroupSelect.SelectList_Load(AgeGroupSelect_Change);
}
AgeGroupSelect.CurrentValue = "";
editSkiYearAge.Text = "0";
}
LoadAgeGroupList();
try {
editMemberStatus.Text = (String)myMemberRow["MemberStatus"];
} catch {
editMemberStatus.Text = "";
}
try {
editCity.Text = (String)myMemberRow["City"];
} catch {
editCity.Text = "";
}
try {
editState.Text = (String)myMemberRow["State"];
} catch {
editState.Text = "";
}
try {
editFederation.SelectedValue = (String)myMemberRow["Federation"];
} catch {
editFederation.SelectedValue = "";
}
showMemberRegList();
}
