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)); }