protected void buttonAdd_Click(object sender, EventArgs e)
{
// Make sure to add to find the correct position (so raceNumber can be 0 when added) and then RecalcRaceNumbers
var when = Convert.ToDateTime(calendarRace.SelectedDate.ToShortDateString() + " " + listRace.SelectedValue);
int repeatWeeks;
try
{
repeatWeeks = Convert.ToInt32(textRepeatWeeks.Text);
}
catch
{
repeatWeeks = 1;
}
while (repeatWeeks > 0)
{
AddRaceDate(when, 0); // raceNumber = 0 for now since finding slot and will recalc later
if (checkBackToBack.Checked)
{
AddRaceDate(Convert.ToDateTime(when.ToShortDateString() + " " + CentralLibrary.GetNextTime(listRace.SelectedValue)), 0); // raceNumber = 0 for now since finding slot and will recalc later
}
when = when.AddDays(7); // next week
repeatWeeks--;
}
RecalcRaceNumbers();
}
protected void buttonRemoveFleetSeries_Click(object sender, EventArgs e)
{
SetError();
if (listSelectedFleetSeries.SelectedItem != null)
{
var position = listSelectedFleetSeries.SelectedIndex;
try
{
// Save the removed information in the add area in case the user wishes to add back in with minor changes
listFleet.SelectedValue = _fleetSeriesRace[position].FleetId.ToString();
CentralLibrary.GetFleetSeries(listFleetSeries, SelectedFleet, SelectedSeason);
listFleetSeries.SelectedValue = _fleetSeriesRace[position].FleetSeriesId.ToString();
textRaceNo.Text = _fleetSeriesRace[position].RaceNo.ToString();
textPointsFactor.Text = _fleetSeriesRace[position].PointsFactor.ToString();
checkExcludable.Checked = _fleetSeriesRace[position].Excludable;
}
catch (Exception ex)
{
SetError("Exception: " + ex);
}
_fleetSeriesRace.RemoveAt(listSelectedFleetSeries.SelectedIndex);
listSelectedFleetSeries.Items.RemoveAt(listSelectedFleetSeries.SelectedIndex);
}
else
{
SetError("Select an existing Fleet/Series for removal first.");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack)
{
_fleetSeriesDateRace = (List <FleetSeriesDateRace>)ViewState["_FleetSeriesDateRace"]; // Load state
}
else
{
_fleetSeriesDateRace = new List <FleetSeriesDateRace>(); // allocate memory
// Set the values via the IsCrossPagePostBack because the PreviousPage values won't be available after a PostBack here.
hiddenSeasonID.Value = PreviousPage.SelectedSeason;
labelSeason.Text = CentralLibrary.GetSeason(SelectedSeason);
if (PreviousPage.SelectedDate.Trim().Length > 0)
{
UpdateDate(PreviousPage.SelectedDate);
}
else
{
UpdateDate(CentralLibrary.GetCurrentDateTime());
}
CentralLibrary.GetFleets(listFleet); // Get the fleets
CentralLibrary.GetFleetSeries(listFleetSeries, SelectedFleet, SelectedSeason); // After getting the fleets, get the series for the selected fleet
CentralLibrary.GetTimes(listRace);
panelSchedule.Visible = false;
labelErrorSeries.Visible = false;
labelErrorSave.Visible = false;
buttonRemove.Enabled = false;
}
}
protected void link_Click(object sender, EventArgs e)
{
var link = (LinkButton)sender;
var raceId = Convert.ToInt32(link.CommandArgument);
labelError.Text = "";
try
{
CentralLibrary.RemoveScores(raceId);
// Remove Races
var ctx = new SailTallyDataContext();
var race = (from r in ctx.SS_Races
where r.RaceID == raceId
select r).Single();
ctx.SS_Races.DeleteOnSubmit(race);
ctx.SubmitChanges();
Server.Transfer("~/OrphanRaces.aspx");
}
catch (Exception ex)
{
labelError.Text = "Unable to remove Orphan Race (Race ID: " + raceId.ToString() + "). Reason:" + ex.Message;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack)
{
return;
}
CentralLibrary.GetSeasons(listSeason);
var showSchedule = false;
// ReSharper disable once MergeSequentialChecks (Done to support Visual Studio 2013)
if (Page.PreviousPage != null && Page.PreviousPage.Master != null) // if a calling page (such as ScheduleModify), get its information to pull up the schedule
{
var cph = (ContentPlaceHolder)Page.PreviousPage.Master.FindControl("MainContent");
var seasonId = (HiddenField)cph.FindControl("hiddenSeasonID");
if (seasonId != null)
{
listSeason.SelectedValue = seasonId.Value;
showSchedule = true;
}
var dateLastUsed = (Label)cph.FindControl("labelSchedule");
if (dateLastUsed != null)
{
hiddenLastDateUsed.Value = dateLastUsed.Text;
}
}
HideFilterOptions(showSchedule);
}
private void GetBoatResults()
{
var report = "";
var ctx = new SailTallyDataContext();
var boatResults = from rs in ctx.SS_ResultSummaries
join b in ctx.SS_Boats on rs.BoatID equals b.BoatID
join f in ctx.SS_Fleets on b.FleetID equals f.FleetID
where rs.SeasonID == Convert.ToInt32(listSeason.SelectedValue)
orderby f.FleetName, b.BoatID, rs.Position, rs.SeriesName
select new { rs.FleetName, rs.BoatName, rs.Skipper, rs.SeriesName, rs.Position, rs.BoatID, rs.SailNumber };
var boatId = -1;
report += "<table>";
foreach (var boatResult in boatResults)
{
if (boatId != boatResult.BoatID) // Have we moved to another boat? If so, new "header"
{
boatId = boatResult.BoatID;
report += "<tr><td colspan='2'><h3>" + boatResult.FleetName + " #" + boatResult.SailNumber + (boatResult.BoatName != null && boatResult.BoatName.Length > 0 ? " " : "") + boatResult.BoatName + ", " + boatResult.Skipper + "</h3></td></tr>";
}
report += "<tr><td>" + boatResult.SeriesName + "</td><td>" + CentralLibrary.PositionSuffix(boatResult.Position) + "</td></tr>";
}
report += "</table>";
labelBoatResults.Text = report;
}
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);
}
}
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)
{
if (!IsPostBack)
{
CentralLibrary.GetSeasons(listSeason);
}
}
protected void buttonRemoveScored_Click(object sender, EventArgs e)
{
var raceId = Convert.ToInt32(hiddenRaceID.Value);
CentralLibrary.RemoveScores(raceId);
buttonRemoveScored.Visible = false;
}
private void BuildSchedule()
{
if (ShowTheSchedule())
{
CentralLibrary.DisplaySchedule(tableSchedule, "~/ScheduleModify.aspx", Convert.ToInt32(listSeason.SelectedValue), false);
}
}
protected void buttonView_Click(object sender, EventArgs e)
{
ShowSummary(true);
labelResults.Text = CentralLibrary.GetResultsHeader(listSeason.SelectedItem.Text, listFleet.SelectedValue)
+ CentralLibrary.GetResultsKeyHeader()
+ CentralLibrary.GetResults(SelectedSeason, listFleet.SelectedValue)
+ CentralLibrary.GetResultsKeyFooter();
}
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack)
{
return;
}
CentralLibrary.GetFleets(listFleet);
ShowSummary(false);
}
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack)
{
return;
}
ShowSummary(false);
CentralLibrary.GetSeasons(listSeason, true);
}
protected void ShowRaces()
{
if (tableRaces.Visible)
{
var ctx = new SailTallyDataContext();
IQueryable <SS_Race> races;
if (radioScheduledAll.Checked)
{
races = from r in ctx.SS_Races
where r.SeasonID == Convert.ToInt32(listSeason.SelectedValue)
orderby r.FirstWarningDate
select r;
}
else if (radioScheduledScored.Checked)
{
races = from r in ctx.SS_Races
where r.SeasonID == Convert.ToInt32(listSeason.SelectedValue) && r.DockedDate != null
orderby r.FirstWarningDate descending
select r;
}
else // Unscored
{
races = from r in ctx.SS_Races
where r.SeasonID == Convert.ToInt32(listSeason.SelectedValue) && r.DockedDate == null
orderby r.FirstWarningDate
select r;
}
tableRaces.Rows.Clear();
var row = new TableRow();
var col = AddColumn("First Warning", -1, true);
col.Width = 130;
row.Cells.Add(col);
//row.Cells.Add(this.AddColumn("Actual Warning", -1, true));
row.Cells.Add(AddColumn("PRO", -1, true));
row.Cells.Add(AddColumn("Series", -1, true));
tableRaces.Rows.Add(row);
foreach (var race in races)
{
row = new TableRow();
row.Cells.Add(AddColumn(CentralLibrary.FormatDisplayTime(race.FirstWarningDate), race.RaceID, false));
//row.Cells.Add(this.AddColumn(race.ActualDate.ToString(), -1, false));
row.Cells.Add(AddColumn(race.PRO, -1, false));
var fleetSeries = GetFleetSeries(race.RaceID, null);
row.Cells.Add(AddColumn(fleetSeries, -1, false));
tableRaces.Rows.Add(row);
}
}
}
partial void OnValidate(ChangeAction action)
{
// Validate the URL
if (Website != null && !Website.ToLower().StartsWith("http://"))
{
Website = "http://" + Website;
}
CentralLibrary.Post(action, "Fleet", FleetID);
}
protected void UpdateDate()
{
try
{
var parsedSchedule = calendarRace.SelectedDate.ToShortDateString() + " " + listRace.Text;
var calculatedSchedule = Convert.ToDateTime(parsedSchedule.Trim());
labelSchedule.Text = calculatedSchedule.ToShortDateString() + " " + CentralLibrary.FormatTime(calculatedSchedule);
}
catch
{
labelSchedule.Text = "Invalid";
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack)
{
return;
}
CentralLibrary.GetSeasons(listSeasonFrom);
CentralLibrary.GetSeasons(listSeasonTo);
labelPreflight.Visible = false;
buttonCopy.Visible = false;
labelReport.Visible = false;
}
protected void linkSave_Click(object sender, EventArgs e)
{
var raceId = Convert.ToInt32(hiddenRaceID.Value);
var fleetId = Convert.ToInt32(listFleet.SelectedValue);
var ctx = new SailTallyDataContext();
// Delete the existing scores
var scoredBoats = from s in ctx.SS_Scores
join b in ctx.SS_Boats on s.BoatID equals b.BoatID
where s.RaceID == raceId && b.FleetID == fleetId
select s;
var raceFleets = from rf in ctx.SS_RaceFleets
where rf.RaceID == raceId && rf.FleetID == fleetId
select rf;
ctx.SS_Scores.DeleteAllOnSubmit(scoredBoats);
ctx.SS_RaceFleets.DeleteAllOnSubmit(raceFleets);
ctx.SubmitChanges();
// Save the scores
var raceFleet = new SS_RaceFleet
{
RaceID = raceId,
FleetID = fleetId,
IsAbandoned = checkAbandoned.Checked,
Course = textCourse.Text,
Distance = CentralLibrary.ConvertToDouble(textDistance.Text, 0),
DistanceUnits = textDistanceUnits.Text
};
ctx.SS_RaceFleets.InsertOnSubmit(raceFleet);
// ReSharper disable once LoopCanBePartlyConvertedToQuery
foreach (var boatScore in _boatScores)
{
var score = new SS_Score
{
RaceID = raceId,
BoatID = boatScore.BoatId,
PenaltyID = boatScore.PenaltyId,
FinishPlace = boatScore.FinishPosition
};
ctx.SS_Scores.InsertOnSubmit(score);
}
ctx.SubmitChanges();
ShowDetail(true);
ShowRaces();
}
protected void detailsFleetSeries_ItemUpdating(object sender, DetailsViewUpdateEventArgs e)
{
var listSeries = (DropDownList)((DetailsView)sender).FindControl("listSeriesEdit");
var seriesId = Convert.ToInt32(listSeries.SelectedValue);
var fleetSeriesId = Convert.ToInt32(detailsFleetSeries.SelectedValue);
if (CentralLibrary.IsFleetSeriesExist(SelectedSeason, SelectedFleet, seriesId, fleetSeriesId))
{
labelDetailError.Text = listFleet.SelectedItem.Text + " " + listSeries.Text + " for " + listSeason.SelectedItem.Text + " already exists. Unable to change.";
e.Cancel = true;
}
else
{
labelDetailError.Text = "";
}
}
protected void detailsFleetSeries_ItemInserting(object sender, DetailsViewInsertEventArgs e)
{
var listSeries = (DropDownList)((DetailsView)sender).FindControl("listSeriesInsert");
var seriesId = Convert.ToInt32(listSeries.SelectedValue);
if (CentralLibrary.IsFleetSeriesExist(SelectedSeason, SelectedFleet, seriesId))
{
labelDetailError.Text = listFleet.SelectedItem.Text + " " + listSeries.SelectedItem.Text + " for " + listSeason.SelectedItem.Text + " already exists. Unable to add.";
e.Cancel = true;
}
else
{
labelDetailError.Text = "";
e.Values.Add("SeasonID", listSeason.SelectedValue);
e.Values.Add("FleetID", listFleet.SelectedValue);
}
}
partial void OnValidate(ChangeAction action)
{
if (action == ChangeAction.Insert && ScorePointsFactor == 0)
{
// This is to correct an issue encountered since moving to WinHost with the MSSQL Default Value for the column
// not being set to the specificed default value. Initially the thought was that MSSQL default values weren't being
// honored. However, it is likely that a newer version of the Entity Framework (EF) is passing default values,
// which would supercede the MSSQL Default Constraint value.
ScorePointsFactor = 1;
}
if (action == ChangeAction.Insert && !IsScoreExcludable)
{
// See above note for ScorePointsFactor :-)
IsScoreExcludable = true;
}
CentralLibrary.Post(action, "RaceSeries", RaceID);
}
protected void buttonSelect_Click(object sender, EventArgs e)
{
var ctx = new SailTallyDataContext();
var fleetNames = (from rs in ctx.SS_ResultSummaries
where rs.SeasonID == SelectedSeason
orderby rs.FleetName
select new { rs.FleetName }).Distinct();
var resultsData = string.Empty;
foreach (var fleetName in fleetNames)
{
resultsData += CentralLibrary.GetResultsHeader(listSeason.SelectedItem.Text, fleetName.FleetName) + CentralLibrary.GetResults(SelectedSeason, fleetName.FleetName, true);
}
labelResults.Text = resultsData + CentralLibrary.GetResultsKeyFooter();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
LabelAbandon.Text = "";
CentralLibrary.GetSeasons(listSeason);
CentralLibrary.GetPenalties(listPenalty);
ShowSummary(false);
}
ShowRaces(); // Since dynamically generated, not part of ViewState
if (ViewState["_fleetBoats"] != null)
{
_boatScores = (List <BoatScore>)ViewState["_fleetBoats"]; // Load state
}
else
{
_boatScores = new List <BoatScore>();
}
}
protected void buttonSelect_Click(object sender, EventArgs e)
{
if (listFleetSeries.SelectedItem != null)
{
listFleet.Enabled = false;
listFleetSeries.Enabled = false;
buttonSelect.Enabled = false;
buttonCancel.Visible = false;
panelSchedule.Visible = true;
labelErrorSeries.Visible = false;
// Store the next race number for use going forward
hiddenNextRaceNumber.Value = CentralLibrary.GetNextRaceNumber(SelectedSeason, SelectedFleetSeries).ToString();
}
else
{
labelErrorSeries.Visible = true;
}
}
protected void detailsFleets_PageIndexChanging(object sender, DetailsViewPageEventArgs e)
{
CentralLibrary.SyncGridView(ref gridFleets, detailsFleets);
}
protected void gridFleets_SelectedIndexChanged(object sender, EventArgs e)
{
CentralLibrary.SyncDataView(gridFleets, ref detailsFleets);
ShowDetail(true);
}
protected void buttonSelect_Click(object sender, EventArgs e)
{
labelSeason.Text = listSeason.SelectedItem.Text;
//CentralLibrary.DisplaySchedule(this.tableSchedule, null, "", Convert.ToInt32(this.listSeason.SelectedValue), true);
CentralLibrary.DisplaySchedule(tableSchedule, "", Convert.ToInt32(listSeason.SelectedValue), true);
}
protected void gridTimes_SelectedIndexChanged(object sender, EventArgs e)
{
CentralLibrary.SyncDataView(gridTimes, ref detailsTimes);
ShowSummary(false);
}
protected void detailsThrowoutMethod_PageIndexChanging(object sender, DetailsViewPageEventArgs e)
{
CentralLibrary.SyncGridView(ref gridThrowout, detailsThrowoutMethod);
}
