public List<Genre> GetAllGenres()
{
List<Genre> ganreList = new List<Genre>();
using (_connection)
{
_connection.Open();
string selectString = "SELECT * FROM GAME";
command.CommandText = selectString;
SqlDataReader reader = command.ExecuteReader();
if (!reader.HasRows) return null;
while (reader.Read())
{
Genre genre = new Genre();
genre.GenreId = reader["GenreId"].ToString();
genre.Description = reader["Description"].ToString();
ganreList.Add(genre);
}
reader.Close();
_connection.Close();
}
return ganreList;
}
public Genre GetGenreById(int id)
{
Genre genre = new Genre();
using (_connection)
{
_connection.Open();
string selectString = "SELECT * FROM GENRE WHERE GenreId = @GenreId";
command.CommandText = selectString;
command.Parameters.Add("@GenreId", id);
SqlDataReader reader = command.ExecuteReader();
if (!reader.HasRows) return null;
while (reader.Read())
{
genre.GenreId = reader["GenreId"].ToString();
genre.Description = reader["Description"].ToString();
}
reader.Close();
_connection.Close();
}
return genre;
}
public void InsertGenre(Genre genre)
{
using (_connection)
{
_connection.Open();
string insertString = @"INSERT INTO Genre(Description) VALUES(@Description)";
command.CommandText = insertString;
command.Parameters.Add("@Description", genre.Description);
command.ExecuteNonQuery();
_connection.Close();
}
}
public void UpdateGenre(Genre genre)
{
using (_connection)
{
_connection.Open();
string insertString = @"UPDATE Genre SET
Description = @Description
WHERE GenreId = @GenreId";
command.CommandText = insertString;
command.Parameters.Add("@Description", genre.Description);
command.ExecuteNonQuery();
_connection.Close();
}
}
