public async Task <ActionResult <Team2018> > PostTeam([FromBody] Team2018 newTeam)
{
_context.Teams.Add(newTeam);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetTeam", new { id = newTeam.TeamId }, newTeam));
}
public List <Team2018> Getteams()
{
List <Team2018> teamList = new List <Team2018>();
string queryString = "select * from team2018;";
using (connection)
{
SqlCommand command = new SqlCommand(queryString, connection);
int result = Method(connection, command).Result;
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
Team2018 temp = new Team2018
{
Id = reader.GetInt32(0),
TeamId = reader.GetInt32(1),
Name = reader[2].ToString(),
Scale = Convert.ToBoolean(reader[3]),
Switch = Convert.ToBoolean(reader[4]),
Exchange = Convert.ToBoolean(reader[5]),
Comments = reader[6].ToString()
};
teamList.Add(temp);
}
//using (connection)
//{
// SqlCommand command = new SqlCommand(queryString, connection);
// try
// {
// connection.Open();
// SqlDataReader reader = command.ExecuteReader();
// while (reader.Read())
// {
// Team2018 temp = new Team2018
// {
// Id = reader.GetInt32(0),
// TeamId = reader.GetInt32(1),
// Name = reader[2].ToString(),
// Scale = Convert.ToBoolean(reader[3]),
// Switch = Convert.ToBoolean(reader[4]),
// Exchange = Convert.ToBoolean(reader[5]),
// Comments = reader[6].ToString()
// };
// teamList.Add(temp);
// }
// reader.Close();
// }
// catch (Exception ex)
// {
// Console.WriteLine(ex.Message);
// }
return(teamList);
}
}
