public async Task <ActionResult <GamesResponseModel> > GetAllGames() { GamesResponseModel gamesResponseModel = new GamesResponseModel(); gamesResponseModel = await Task.Run(() => _lessonPlannerRepository.GetAllGames()); return(Ok(gamesResponseModel)); }
public GamesResponseModel GetAllGames() { GamesResponseModel gamesResponseModel = new GamesResponseModel(); gamesResponseModel.Data = new List <GamesDto>(); DataTable dataTable = new DataTable(); SqlConnection conn = new SqlConnection(DbHelper.DbConnectionString); try { SqlCommand command = new SqlCommand(@"dbo.uspGetAllGames", conn); command.CommandType = CommandType.StoredProcedure; conn.Open(); SqlDataAdapter dataAdapter = new SqlDataAdapter(command); dataAdapter.Fill(dataTable); gamesResponseModel.Message = "Success"; gamesResponseModel.StatusCode = 200; foreach (DataRow row in dataTable.Rows) { GamesDto gamesModel = new GamesDto(); gamesModel.GameID = row["GameID"] != DBNull.Value ? Convert.ToInt64(row["GameID"].ToString()) : 0; gamesModel.MainTopicID = row["MainTopicID"] != DBNull.Value ? Convert.ToInt64(row["MainTopicID"].ToString()) : 0; gamesModel.MainTopicNumber = row["MainTopicNumber"] != DBNull.Value ? Convert.ToString(row["MainTopicNumber"]) : string.Empty; gamesModel.GameDescription = row["GameDescription"] != DBNull.Value ? Convert.ToString(row["GameDescription"].ToString()) : string.Empty; gamesResponseModel.Data.Add(gamesModel); } } catch (Exception ex) { gamesResponseModel.StatusCode = 500; gamesResponseModel.Message = ex.Message; gamesResponseModel.Data = null; } finally { dataTable.Clear(); dataTable = null; conn.Close(); } return(gamesResponseModel); }