public static void ToStatesNationality(ComboBox box) { var states = new StatesMapper().SelectAll(); box.Items.Insert(0, ""); foreach (var state in states) { box.Items.Insert(state.Id, state.Nationality); } }
public bool OpenRecord(object primaryKey) { if (primaryKey == null) { return(false); } var idDriver = (int)primaryKey; var driverMapper = new DriversMapper(); var driver = driverMapper.SelectDriver(idDriver); labelFirstNameEdit.Text = driver.FirstName; labelLastNameEdit.Text = driver.LastName; labelNumberEdit.Text = driver.Number.ToString(); if (driver.DateOfBirth != null) { labelDateOfBirthEdit.Text = ((DateTime)driver.DateOfBirth).ToString("dd/MM/yyyy"); } driver.Team = Teams.FindForDriver(driver); if (driver.Team != null) { var team = new TeamsMapper().SelectTeam(driver.Team.Id); labelTeamEdit.Text = team.Name; } else { labelTeamEdit.Text = @"N/A"; } driver.State = States.FindForDriver(driver); var state = new StatesMapper().SelectState(driver.State.Id); labelNationailityEdit.Text = state.Nationality; labelHeader.Text = @"Výpis jezdce - " + driver.FirstName + @" " + driver.LastName; Text = labelHeader.Text; _driverId = driver.Id; driverMapper.GetPrevNextDriver(_driverId, out _prevId, out _nextId); buttonDriverEdit.Visible = driver.Team != null && ButtonEnable.TeamsEdit(driver.Team.UserId, new UsersMapper().SelectUser(Logged.CurrentUser.UserRole)); return(true); }
public bool OpenRecord(object primaryKey) { if (primaryKey == null) { return(false); } var idDriver = (int)primaryKey; var driverMapper = new GpMapper(); var gp = driverMapper.SelectGp(idDriver); labelNameEdit.Text = gp.Name; labelCircuitEdit.Text = gp.Circuit; if (gp.Date != null) { labelDateEdit.Text = ((DateTime)gp.Date).ToString("dd/MM/yyyy"); } if (gp.Lenght != null) { labelLenghtEdit.Text = gp.Lenght.ToString(); } if (gp.Laps != null) { labelLapsEdit.Text = gp.Laps.ToString(); } gp.State = States.FindForGp(gp); var state = new StatesMapper().SelectState(gp.State.Id); labelStateEdit.Text = state.Name; labelHeader.Text = @"Výpis GP - " + gp.Name; Text = labelHeader.Text; _gpId = gp.Id; driverMapper.GetPrevNextDriver(_gpId, out _prevId, out _nextId); buttonGpEdit.Visible = ButtonEnable.TeamsEdit(gp.UserId, new UsersMapper().SelectUser(Logged.CurrentUser.UserRole)); return(true); }
public bool OpenRecord(object primaryKey) { if (primaryKey == null) { return(false); } var idTeam = (int)primaryKey; var teamsMapper = new TeamsMapper(); var team = teamsMapper.SelectTeam(idTeam); labelName.Text = team.Name; labelTyres.Text = team.Tyres; team.Manufacturer = Manufacturers.FindForTeam(team); if (team.Manufacturer != null) { var manufacturer = new ManufacturersMapper().SelectManufacturer(team.Manufacturer.Id); labelManufacturer.Text = manufacturer.Name; } else { labelManufacturer.Text = @"N/A"; } team.State = States.FindForTeam(team); var state = new StatesMapper().SelectState(team.State.Id); labelState.Text = state.Name; labelHeader.Text = @"Výpis týmu - " + team.Name; Text = labelHeader.Text; _teamId = team.Id; teamsMapper.GetPrevNextDriver(_teamId, out _prevId, out _nextId); buttonTeamEdit.Visible = ButtonEnable.TeamsEdit(team.UserId, new UsersMapper().SelectUser(Logged.CurrentUser.UserRole)); return(true); }