public async Task <IEnumerable <CreateTeamView> > GetAllTeamsAsync()
{
NpgsqlConnection conn = null;
List <CreateTeamView> list = new List <CreateTeamView> ();
var connStr = DbConnection.connectionString;
using (conn = new NpgsqlConnection(connStr)) {
var cmdStr = "Select * from team_dto";
using (NpgsqlCommand command = new NpgsqlCommand(cmdStr, conn)) {
await conn.OpenAsync();
using (NpgsqlDataReader reader = await command.ExecuteReaderAsync()) {
while (reader.Read())
{
var team = new CreateTeamView()
{
TeamName = reader["team_name"].ToString(),
TeamImage = reader["team_image"].ToString(),
StadiumID = Convert.ToInt32(reader["stadium_id"]),
StadiumName = reader["stadium_name"].ToString()
};
list.Add(team);
}
}
}
}
return(list);
}
public async Task <TeamView> AddTeamAsync(CreateTeamView teamView)
{
var team = new Team
{
Name = teamView.Name,
Members = teamView.MemberIds.Select(memberId => new User {
Id = memberId
}).ToList(),
Projects = teamView.ProjectIds.Select(memberId => new Project {
Id = memberId
}).ToList()
};
var result = await _teamRepository.CreateAsync(team);
return(result.Map());
}
public async Task <IActionResult> CreateTeam(CreateTeamView model, int stadiumID)
{
if (!ModelState.IsValid)
{
return(View("Error"));
}
var user = await _userManager.FindByNameAsync(model.Creator);
var team = new Team()
{
TeamName = model.TeamName,
TeamImage = model.TeamImage,
StadiumID = model.StadiumID,
CreatorID = user.Id
};
var result = await _repo.CreateTeamAsync(team);
if (result > 0)
{
return(RedirectToAction("ListTeams"));
}
return(View(model));
}
