protected void ShowRace(int raceId) { var ctx = new SailTallyDataContext(); var race = (from r in ctx.SS_Races where r.RaceID == raceId select r).Single(); // should only be one record // Populate Header fields hiddenRaceID.Value = raceId.ToString(CultureInfo.InvariantCulture); // save for future use labelWarning.Text = CentralLibrary.FormatDisplayTime(race.FirstWarningDate); labelSeries.Text = GetFleetSeries(raceId, null); textPRO.Text = race.PRO; textAssistPRO.Text = race.AssistPRO; textHelpers.Text = race.Helper; textDocked.Text = race.DockedDate?.ToShortTimeString() ?? CentralLibrary.GetCurrentDateTime().ToShortTimeString(); textWindDirection.Text = race.WindDirection; textWindSpeed.Text = race.WindSpeed; textCourseChange.Text = race.CourseChange; listWindUnits.SelectedValue = (string.IsNullOrEmpty(race.WindUnits) ? "kts" : race.WindUnits); textProtests.Text = race.Protests; textComments.Text = race.Comments; var fleets = GetFleetsForRace(raceId); listFleet.DataSource = fleets; listFleet.DataValueField = "fleetid"; listFleet.DataTextField = "fleetname"; listFleet.DataBind(); buttonScoreFleet.Enabled = (fleets.Any()); buttonRemoveScored.Visible = (!fleets.Any() && CentralLibrary.IsRacesScored(raceId)); // special case to have this function available ButtonAbandonRaces.Enabled = true; }
protected void Page_Load(object sender, EventArgs e) { var row = new TableRow(); AddColumn(row, "Action", CellType.Header); AddColumn(row, "Race ID", CellType.Header); AddColumn(row, "First Warning", CellType.Header); AddColumn(row, "Scored Races", CellType.Header); tableOrphans.Rows.Add(row); var ctx = new SailTallyDataContext(); // Sub Query var raceSeries = (from rs in ctx.SS_RaceSeries orderby rs.RaceID select rs.RaceID).Distinct(); // Main Query var races = from r in ctx.SS_Races where !raceSeries.Contains(r.RaceID) select r; foreach (var race in races) { row = new TableRow(); AddColumn(row, "Delete", CellType.Delete, race.RaceID); AddColumn(row, race.RaceID.ToString(), CellType.Normal); AddColumn(row, CentralLibrary.FormatDisplayTime(race.FirstWarningDate), CellType.Normal); AddColumn(row, (CentralLibrary.IsRacesScored(race.RaceID) ? "Yes" : "No"), CellType.Normal); tableOrphans.Rows.Add(row); } }