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