public ActionResult Edit(int id)
{
TeamsMapper teamsMapper = new TeamsMapper();
Teams team = teamsMapper.SelectTeam(id);
if (!(User.IsInRole("Admin") || ButtonEnable.TeamsEdit(team.UserId, new UsersMapper().SelectUser(User.Identity.Name))))
{
TempData["message-error"] = "Nemáte oprávnění provádět tyto změny";
return(RedirectToAction("Detail", "Teams", new { id = team.Id }));
}
team.State = States.FindForTeam(team);
team.Manufacturer = Manufacturers.FindForTeam(team);
ViewBag.Name = team.Name;
ViewBag.States = new StatesMapper().SelectAll();
((Collection <States>)ViewBag.States).Insert(0, new States().EmptyState());
ViewBag.Manufacturers = new ManufacturersMapper().SelectAll();
((Collection <Manufacturers>)ViewBag.Manufacturers).Insert(0, new Manufacturers().EmptyManufacturer());
ViewBag.IfTeam = User.Identity.IsAuthenticated && ButtonEnable.TeamsEdit(team.UserId, new UsersMapper().SelectUser(User.Identity.Name));
return(View(team));
}
public ActionResult Edit(Teams team)
{
TeamsMapper teamsMapper = new TeamsMapper();
Teams teamFromDb = teamsMapper.SelectTeam(team.Id);
if (!(User.IsInRole("Admin") || ButtonEnable.TeamsEdit(teamFromDb.UserId, new UsersMapper().SelectUser(User.Identity.Name))))
{
TempData["message-error"] = "Nemáte oprávnění provádět tyto změny";
return(RedirectToAction("Detail", "Teams", new { id = team.Id }));
}
if (ModelState.IsValid)
{
teamsMapper.Edit(team);
TempData["message-success"] = "Tým byl zmeněn";
return(RedirectToAction("Detail", "Teams", new { id = team.Id }));
}
TempData["message-error"] = "Při zpracování se stala chyba";
team.State = States.FindForTeam(team);
team.Manufacturer = Manufacturers.FindForTeam(team);
ViewBag.Name = team.Name;
ViewBag.States = new StatesMapper().SelectAll();
((Collection <States>)ViewBag.States).Insert(0, new States().EmptyState());
ViewBag.Manufacturers = new ManufacturersMapper().SelectAll();
((Collection <Manufacturers>)ViewBag.Manufacturers).Insert(0, new Manufacturers().EmptyManufacturer());
return(View(team));
}
public TeamsManager(ITeamsRepository teamsRepository, IPlayersRepository playersRepository, IGamesRepository gamesRepository, ILeaguesRepository leaguesRepository, TeamsMapper teamMapper, IEventsRepository eventsRepository)
{
_teamsRepository = teamsRepository;
_playersRepository = playersRepository;
_gamesRepository = gamesRepository;
_leaguesRepository = leaguesRepository;
_teamMapper = teamMapper;
_eventsRepository = eventsRepository;
}
public static States FindForTeam(Teams team)
{
var teamsMapper = new TeamsMapper();
if (teamsMapper.SelectState(team.Id) == null)
{
return(null);
}
return(new StatesMapper().SelectState((int)teamsMapper.SelectState(team.Id)));
}
public static Manufacturers FindForTeam(Teams team)
{
var teamsMapper = new TeamsMapper();
if (teamsMapper.SelectManufacturer(team.Id) == null)
{
return(null);
}
return(new ManufacturersMapper().SelectManufacturer(id: (int)teamsMapper.SelectManufacturer(team.Id)));
}
public static void ToTeams(ComboBox box)
{
var teams = new TeamsMapper().SelectAll();
box.Items.Insert(0, "");
foreach (var team in teams)
{
box.Items.Insert(team.Id, team.Name);
}
}
public LeaguesManager(ILeaguesRepository leaguesRepository, ITeamsRepository teamsRepository, IGamesRepository gamesRepository, IPlayersRepository playersRepository, IUsersRepository usersRepository, TeamsMapper teamMapper, UserStatisticCalculation userStatisticCalculation, LeaguesMapper leaguesMapper, IEventsRepository eventsRepository)
{
_leaguesRepository = leaguesRepository;
_teamsRepository = teamsRepository;
_gamesRepository = gamesRepository;
_playersRepository = playersRepository;
_usersRepository = usersRepository;
_teamMapper = teamMapper;
_userStatisticCalculation = userStatisticCalculation;
_leaguesMapper = leaguesMapper;
_eventsRepository = eventsRepository;
}
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 ActionResult Detail(int id)
{
TeamsMapper teamsMapper = new TeamsMapper();
Teams team = teamsMapper.SelectTeam(id);
team.State = States.FindForTeam(team);
team.Manufacturer = Manufacturers.FindForTeam(team);
teamsMapper.GetPrevNextDriver(id, out int?prev, out int?next);
ViewBag.Prev = prev;
ViewBag.Next = next;
ViewBag.IfTeam = User.Identity.IsAuthenticated && ButtonEnable.TeamsEdit(team.UserId, new UsersMapper().SelectUser(User.Identity.Name));
return(View(team));
}
private void RefreshData()
{
var auctions = new TeamsMapper().SelectAll();
var bindingList = new BindingList <Teams>(auctions);
dataGridViewTeams.AutoGenerateColumns = false;
dataGridViewTeams.Rows.Clear();
foreach (var team in bindingList)
{
var rowIndex = dataGridViewTeams.Rows.Add();
var row = dataGridViewTeams.Rows[rowIndex];
row.Cells["NameOfTeam"].Value = team.Name;
row.Cells["ID"].Value = team.Id;
}
}
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)
{
InsertItems.ToStatesNames(comboBoxState);
InsertItems.Manufacturers(comboBoxManufacturer);
if (primaryKey == null)
{
return(false);
}
_teamId = (int)primaryKey;
var team = new TeamsMapper().SelectTeam(_teamId);
textBoxName.Text = team.Name;
textBoxTyres.Text = team.Tyres;
team.Manufacturer = Manufacturers.FindForTeam(team);
if (team.Manufacturer != null)
{
comboBoxManufacturer.SelectedIndex = team.Manufacturer.Id;
}
else
{
comboBoxManufacturer.SelectedIndex = -1;
}
team.State = States.FindForTeam(team);
if (team.State != null)
{
comboBoxState.SelectedIndex = team.State.Id;
}
else
{
comboBoxState.SelectedIndex = -1;
}
labelHeader.Text = @"Úprava týmu - " + team.Name;
Text = labelHeader.Text;
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);
}
