private string SetPosition(int raceID)
{
using (FormulaOneDataContext Data = new FormulaOneDataContext())
{
var RaceResults = Data.RaceResults.Where(Results => Results.RaceID == raceID);
Boolean match = true;
for (int i = 1; i <= 22; i++)
{
match = false;
foreach (RaceResult result in RaceResults)
{
if (result.FinalPosition.Trim() == string.Format("{0}", i))
{
match = true;
break;
}
}
if (!match)
{
return(string.Format("{0}", i));
}
}
}
return(null);
}
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 addNewCircuit()
{
using (FormulaOneDataContext Data = new FormulaOneDataContext())
{
Circuit circuit = new Circuit();
circuit.CircuitName = TextBox1.Text;
Data.Circuits.InsertOnSubmit(circuit);
Data.SubmitChanges();
Response.Redirect("~/AddCircuit");
}
}
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);
}
}
private void addNewRace()
{
using (FormulaOneDataContext Data = new FormulaOneDataContext())
{
Race race = new Race();
race.RaceName = RaceNameTxt.Text;
race.CircuitID = Int32.Parse(CircuitDpd.SelectedValue);
Data.Races.InsertOnSubmit(race);
Data.SubmitChanges();
Response.Redirect("~/AddRace");
}
}
protected void Page_Load(object sender, EventArgs e)
{
int raceID = Int32.Parse(SqlDataSource1.SelectParameters["param1"].DefaultValue);
using (FormulaOneDataContext Data = new FormulaOneDataContext())
{
if (!IsPostBack)
{
var race = Data.Races.Single(Race => Race.RaceID == raceID);
RaceTitleLbl.Text = race.RaceName;
RaceTitleDpd.SelectedValue = String.Format("{0}", raceID);
PositionTxt.Text = SetPosition(raceID);
}
}
}
private void addNewDriver()
{
using (FormulaOneDataContext Data = new FormulaOneDataContext())
{
Driver driver = new Driver();
driver.FirstName = FirstNameTxt.Text;
driver.SecondName = SecondNameTxt.Text;
driver.TeamID = Int32.Parse(DropDownTeams.SelectedValue);
Data.Drivers.InsertOnSubmit(driver);
Data.SubmitChanges();
Response.Redirect("~/AddDriver");
}
}
protected void addTeamBtn_Click(object sender, EventArgs e)
{
using (FormulaOneDataContext Data = new FormulaOneDataContext())
{
Team team = new Team();
team.TeamName = TeamNameTxt.Text;
team.Constructor = ConstructorTxt.Text;
team.Chassis = ChassisTxt.Text;
team.Engine = EngineTxt.Text;
Data.Teams.InsertOnSubmit(team);
Data.SubmitChanges();
Response.Redirect("~/AddTeam");
}
}
private void getTeamDetails()
{
using (FormulaOneDataContext Data = new FormulaOneDataContext())
{
Team team = Data.Teams.Single(Team => Team.TeamID == 3);
teamNameLbl.Text = team.TeamName;
// select the 2 drivers of that team
var Drivers = Data.Drivers.Where(Driver => Driver.TeamID == team.TeamID);
List <string> teamMembers = new List <string>();
foreach (Driver driver in Drivers)
{
teamMembers.Add(driver.FirstName + " " + driver.SecondName);
}
driver1Lbl.Text = teamMembers[0];
driver2Lbl.Text = teamMembers[1];
}
}