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(); }