public static void Manufacturers(ComboBox box)
{
var manufacturers = new ManufacturersMapper().SelectAll();
box.Items.Insert(0, "");
foreach (var manufacturer in manufacturers)
{
box.Items.Insert(manufacturer.Id, manufacturer.Name);
}
}
private void buttonTeamSave_Click(object sender, EventArgs e)
{
var teamsMapper = new TeamsMapper();
var manufacturersMapper = new ManufacturersMapper();
var teamFromDb = teamsMapper.SelectTeam(_teamId);
teamFromDb.State = States.FindForTeam(teamFromDb);
var totalCount = manufacturersMapper.SelectTotalCount();
var count = manufacturersMapper.SelectCountId(comboBoxManufacturer.SelectedIndex);
if (totalCount / 2 < count)
{
labelError.Text = @"Dodavatel motorů nesmí dodávat motory více, jak polovině týmů.";
return;
}
var team = new Teams();
team.Id = _teamId;
team.Name = textBoxName.Text;
team.Tyres = textBoxTyres.Text;
if (comboBoxManufacturer.SelectedIndex == 0)
{
team.Manufacturer = null;
}
else
{
team.Manufacturer = new Manufacturers()
{
Id = comboBoxManufacturer.SelectedIndex
};
}
team.State = new States {
Id = comboBoxState.SelectedIndex
};
if (team.State.Id < 1)
{
labelError.Text = @"Tým musí mít vybraný stát";
return;
}
teamsMapper.Edit(team);
Close();
}
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);
}
