private void Mannschaft1_Load(object sender, EventArgs e)
{
if (DesignMode)
{
return;
}
//Your code to run on load goes here
var teamsModel = new TeamsModel();
teamsModel.Teams.Load();
_me = teamsModel.Teams.Where(item => item.Me == 1).FirstOrDefault();
var _playerModel = new PlayerModel();
_playerModel.Players.Load();
_bindingList = new BindingList <Player>(_playerModel.Players.Where(item => item.TeamId == _me.Id).ToList());
this.bindingSource1.DataSource = _bindingList;
dataGridView1.Columns[0].DataPropertyName = "Nachname";
dataGridView1.Columns[1].DataPropertyName = "Vorname";
dataGridView1.Columns[2].DataPropertyName = "Att";
dataGridView1.Columns[3].DataPropertyName = "Deff";
dataGridView1.AutoGenerateColumns = false;
}
public bool Update(TeamsModel team)
{
if (team is null)
{
return(false);
}
try
{
using (SqlConnection connection = new SqlConnection(ConnectionString))
{
string queryString = $"UPDATE {TeamsTable} " +
$"SET Name = '{team.Name}' " +
$" WHERE {TeamsTable}.Id = {team.Id}";;
connection.Open();
SqlCommand command = new SqlCommand(queryString, connection);
command.Prepare();
int number = command.ExecuteNonQuery();
return(number > 0 ? true : false);
}
}
catch (Exception)
{
return(false);
}
}
private TeamsModel LoadAll(int derbyId)
{
var model = new TeamsModel();
using (SqlConnection con = new SqlConnection(_connectionString))
{
con.Open();
try
{
// Load teams
using (SqlCommand command = new SqlCommand(@"select t.id, t.name, t.secret_string, d.name derby_name
from sturgeonteams t
join sturgeonderbies d on d.id = t.derby_id
where t.derby_id = @derby_id", con))
{
command.Parameters.Add(new SqlParameter("derby_id", derbyId));
var reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
model.Teams.Add(new TeamModel()
{
TeamName = reader["name"].ToString(),
Password = reader["secret_string"].ToString(),
TeamId = reader.GetInt32(0)
});
model.DerbyName = reader["derby_name"].ToString();
}
}
reader.Close();
}
// Load scores
using (SqlCommand command = new SqlCommand(@"select s.team_id, s.slot, s.score
from sturgeonscores s
join sturgeonteams t on s.team_id = t.id
where t.derby_id = @derby_id", con))
{
command.Parameters.Add(new SqlParameter("derby_id", derbyId));
var reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
var team = model.Teams.First(x => x.TeamId == reader.GetInt32(0));
team.SetScore(reader.GetInt32(1), reader.GetInt32(2));
}
}
reader.Close();
}
}
catch (Exception ex)
{
throw ex;
}
}
return(model);
}
public ActionResult SaveEdititngTeam(TeamsVm model)
{
if (model is null || string.IsNullOrWhiteSpace(model.Name))
{
TempData["error"] = $"You did not fill name. Name is required.";
return(RedirectToAction("Edit", new { team_id = model.Id }));
}
TeamsModel team = new TeamsModel()
{
Id = model.Id,
Name = model.Name
};
try
{
if (!_teamService.Update(team))
{
TempData["error"] = $"Problems with updating team (Service error \"Update/Edit\").";
return(RedirectToAction("Edit", new { team_id = model.Id }));
}
}
catch (Exception e)
{
TempData["error"] = $"Problems with getting information from database (services). {e.Message}";
return(RedirectToAction("Edit", new { team_id = model.Id }));
}
return(RedirectToAction("Index"));
}
public async Task <IActionResult> Edit(int id, [Bind("Id,Name")] TeamsModel teamsModel)
{
if (id != teamsModel.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(teamsModel);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!TeamsModelExists(teamsModel.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(teamsModel));
}
public ActionResult Create(TeamsVm model)
{
if (model is null || string.IsNullOrWhiteSpace(model.Name))
{
TempData["error"] = $"You did not fill name. Name is required.";
return(RedirectToAction("Create"));
}
TeamsModel team = new TeamsModel()
{
Name = model.Name
};
try
{
if (!_teamService.Create(team))
{
TempData["error"] = $"Problems with create team (Service error \"Create\").";
return(RedirectToAction("Create"));
}
}
catch (Exception e)
{
TempData["error"] = $"Problems with saving information to database (services). {e.Message}";
return(RedirectToAction("Create"));
}
return(RedirectToAction("Index"));
}
public ActionResult Edit(int team_id)
{
string errorMsg = String.Empty;
if (TempData.ContainsKey("error"))
{
errorMsg = TempData["error"].ToString();
}
TeamsModel team = new TeamsModel();
TeamsVm model = new TeamsVm();
try
{
team = _teamService.GetTeam(team_id);
}
catch (Exception e)
{
TempData["error"] = $"Problems with getting information from database (services). {e.Message}";
return(RedirectToAction("Index"));
}
model.Id = team.Id;
model.Name = team.Name;
return(View("Edit", model));
}
public TeamsModel GetTeam(int team_id)
{
TeamsModel team = new TeamsModel();
try
{
using (SqlConnection connection = new SqlConnection(ConnectionString))
{
string queryString = $"SELECT * FROM {TeamsTable} WHERE {TeamsTable}.id = {team_id};";
connection.Open();
SqlCommand command = new SqlCommand(queryString, connection);
command.Prepare();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
try
{
team.Id = int.Parse(reader["Id"].ToString());
team.Name = reader["Name"].ToString();
}
catch (Exception)
{
return(new TeamsModel());
}
}
}
}
catch (Exception)
{
return(new TeamsModel());
}
return(team);
}
public TeamsModel GetPlayers()
{
var teamsModel = new TeamsModel();
teamsModel.BlackTeam.AddRange(File.ReadLines(_blackTeamFilename));
teamsModel.RedTeam.AddRange(File.ReadLines(_redTeamFilename));
return(teamsModel);
}
public ActionResult TeamRegister(TeamsModel _RegTeam)
{
if (ModelState.IsValid)
{
_TeamDataAccess.AddTeams(_mapper.Map(_RegTeam));
return(RedirectToAction("Index", "Home"));
}
return(View());
}
public TeamsModel GetPlayers()
{
var model = new TeamsModel();
model.RedTeam.Add("John Doe");
model.RedTeam.Add("Jane Doe");
model.BlackTeam.Add("Mr Smith");
return(model);
}
public ActionResult TeamUpdate(TeamsModel _UpdateTeams)
{
if (ModelState.IsValid)
{
_UpdateTeams.TeamName = (string)Session["TeamName"];
_TeamDataAccess.UpdateTeams(_mapper.Map(_UpdateTeams));
return(RedirectToAction("Index", "Home"));
}
return(View());
}
public async Task <IActionResult> Create([Bind("Id,Name")] TeamsModel teamsModel)
{
if (ModelState.IsValid)
{
_context.Add(teamsModel);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(teamsModel));
}
public ActionResult AndyAdmin(int id)
{
TeamsModel model = new TeamsModel();
if (id <= 0)
{
return(View(model));
}
model = LoadAll(id);
return(View(model));
}
public async Task <Result> Handle(ListTeamQuery request, CancellationToken cancellationToken)
{
Result result;
try
{
var filter = request.Filter;
int?skip = request.Skip.ToNullableInt();
int?top = request.Top.ToNullableInt();
var teamDomains = await _teamReadRepository.ListAsync(filter, skip, top);
var teamModels = new List <TeamModel>();
foreach (var teamDomain in teamDomains)
{
var members = new List <MemberModel>();
foreach (var member in teamDomain.Members)
{
var operatorDomain = await _operatorReadRepository.GetAsync(member);
members.Add(_mapper.Map <MemberModel>(operatorDomain));
}
var teamModel = _mapper.Map <TeamModel>(teamDomain);
teamModel.Members = new List <MemberModel>(members);
teamModels.Add(teamModel);
}
var count = teamModels.Count;
var teamsModel = new TeamsModel {
Value = teamModels, Count = count, NextLink = null
};
result = Result.Ok(teamsModel);
}
catch (FilterODataException)
{
result = Result.Fail(new List <Failure>()
{
new HandlerFault()
{
Code = HandlerFaultCode.InvalidQueryFilter.Name,
Message = HandlerFailures.InvalidQueryFilter,
Target = "$filter"
}
});
}
catch
{
result = Result.Fail(CustomFailures.ListTeamFailure);
}
return(result);
}
private async Task <bool> apiCall()
{
string[] matchPaths = { "v2/competitions/CL/matches", "v2/competitions/PL/matches", "v2/competitions/PD/matches" };
string[] teamPaths = { "v2/competitions/CL/teams", "v2/competitions/PL/teams", "v2/competitions/PD/teams" };
string[] standingPaths = { "v2/competitions/CL/standings", "v2/competitions/PL/standings", "v2/competitions/PD/standings" };
string[] scorerPaths = { "v2/competitions/CL/scorers", "v2/competitions/PL/scorers", "v2/competitions/PD/scorers" };
IEnumerable <MatchesModel> matches = await ApiMatchModelAsync(matchPaths);
IEnumerable <TeamsModel> teams = await ApiTeamModelAsync(teamPaths);
IEnumerable <StandingsModel> standings = await ApiStandingModelAsync(standingPaths);
IEnumerable <ScorerModel> scorers = await ApiScorerModelAsync(scorerPaths);
clMatches = matches.Where(match => match.competition.id == 2001).FirstOrDefault();
plMatches = matches.Where(match => match.competition.id == 2021).FirstOrDefault();
pdMatches = matches.Where(match => match.competition.id == 2014).FirstOrDefault();
allMatch.AddRange(clMatches.matches);
allMatch.AddRange(plMatches.matches);
allMatch.AddRange(pdMatches.matches);
clTeams = teams.Where(team => team.competition.id == 2001).FirstOrDefault();
plTeams = teams.Where(team => team.competition.id == 2021).FirstOrDefault();
pdTeams = teams.Where(team => team.competition.id == 2014).FirstOrDefault();
allTeams.AddRange(clTeams.teams);
allTeams.AddRange(plTeams.teams);
allTeams.AddRange(pdTeams.teams);
clStanding = standings.Where(standing => standing.competition.id == 2001).FirstOrDefault();
plStanding = standings.Where(standing => standing.competition.id == 2021).FirstOrDefault();
pdStanding = standings.Where(standing => standing.competition.id == 2014).FirstOrDefault();
clScorers = scorers.Where(scorer => scorer.competition.id == 2001).FirstOrDefault();
plScorers = scorers.Where(scorer => scorer.competition.id == 2021).FirstOrDefault();
pdScorers = scorers.Where(scorer => scorer.competition.id == 2014).FirstOrDefault();
return(true);
}
public bool Create(TeamsModel team)
{
if (team == null)
{
return(false);
}
try
{
using (SqlConnection connection = new SqlConnection(ConnectionString))
{
string queryString = $"INSERT INTO {TeamsTable} (Name) " +
$"VALUES ('{team.Name}')";
connection.Open();
SqlCommand command = new SqlCommand(queryString, connection);
command.Prepare();
int number = command.ExecuteNonQuery();
return(number > 0 ? true : false);
}
}
catch (Exception)
{
return(false);
}
}
public List <TeamsModel> GetTeams()
{
List <TeamsModel> teams = new List <TeamsModel>();
try
{
using (SqlConnection connection = new SqlConnection(ConnectionString))
{
string queryString = $"SELECT * FROM {TeamsTable};";
connection.Open();
SqlCommand command = new SqlCommand(queryString, connection);
command.Prepare();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
try
{
TeamsModel team = new TeamsModel();
team.Id = int.Parse(reader["Id"].ToString());
team.Name = reader["Name"].ToString();
teams.Add(team);
}
catch (Exception)
{
return(new List <TeamsModel>());
}
}
}
}
catch (Exception)
{
return(new List <TeamsModel>());
}
return(teams);
}
public ActionResult TeamRegister()
{
TeamsModel _Teams = new TeamsModel();
return(View(_Teams));
}
public ActionResult TeamUpdate()
{
TeamsModel _UpdateTeam = new TeamsModel();
return(View(_UpdateTeam));
}
