private void addResult()
{
using (FormulaOneDataContext Data = new FormulaOneDataContext())
{
var allResults = Data.RaceResults.Where(RaceResult => RaceResult.RaceID == Int32.Parse(RaceTitleDpd.SelectedValue));
foreach (RaceResult result in allResults)
{
if (result.FinalPosition.Trim() == PositionTxt.Text || result.DriverID == Int32.Parse(DriverCbx.SelectedValue))
{
return;
}
}
RaceResult raceResult = new RaceResult();
raceResult.RaceID = Int32.Parse(RaceTitleDpd.SelectedValue);
raceResult.DriverID = Int32.Parse(DriverCbx.SelectedValue);
raceResult.TeamID = Int32.Parse(TeamCbx.SelectedValue);
raceResult.FinalPosition = PositionTxt.Text;
raceResult.RaceTime = TimeSpan.FromHours(Int32.Parse(HourTxt.Text))
+ TimeSpan.FromMinutes(Int32.Parse(MinuteTxt.Text))
+ TimeSpan.FromSeconds(Int32.Parse(SecondTxt.Text));
Data.RaceResults.InsertOnSubmit(raceResult);
Data.SubmitChanges();
GridViewRaceResult.DataBind();
}
getRaceResults(Int32.Parse(RaceTitleDpd.SelectedValue));
}
private void getRaceResults(int raceID)
{
using (FormulaOneDataContext Data = new FormulaOneDataContext())
{
var race = Data.Races.Single(Race => Race.RaceID == raceID);
RaceTitleDpd.SelectedValue = string.Format("{0}", race.RaceID);
RaceTitleLbl.Text = race.RaceName;
GridViewRaceResult.DataBind();
PositionTxt.Text = SetPosition(race.RaceID);
}
}