public static ObservableCollection<Genre> GetAllGenres()
{
ObservableCollection<Genre> genresList = new ObservableCollection<Genre>();
using (SqlConnection connection = MusicStoreDataDB.GetConnection())
{
using (SqlCommand selectCommand = new SqlCommand())
{
selectCommand.Connection = connection;
selectCommand.CommandText = "spGetAllGenres";
selectCommand.CommandType = CommandType.StoredProcedure;
connection.Open();
using (SqlDataReader reader = selectCommand.ExecuteReader())
{
while (reader.Read())
{
Genre genre = new Genre();
genre.GenreId = (int)reader["GenreId"];
genre.Name = reader["Name"].ToString();
genresList.Add(genre);
}
reader.Close();
}
}
}
return genresList;
}
public static List<Genre> GetGenresList()
{
List<Genre> genresList = new List<Genre>();
String selectStatement = "SELECT * FROM Genre";
using (SqlConnection connection = MusicStoreDB.GetConnection())
{
connection.Open();
using (SqlCommand selectCommand = new SqlCommand(selectStatement, connection))
{
using (SqlDataReader reader = selectCommand.ExecuteReader())
{
while (reader.Read())
{
Genre genre = new Genre();
genre.GenreId = (int)reader["GenreId"];
genre.Name = reader["Name"].ToString();
genre.Description = reader["Description"].ToString();
genresList.Add(genre);
}
reader.Close();
}
}
}
return genresList;
}
public static Genre GetGenreById(int GenreId)
{
Genre genre = new Genre();
using (SqlConnection connection = MusicStoreDataDB.GetConnection())
{
using (SqlCommand selectCommand = new SqlCommand())
{
selectCommand.Connection = connection;
selectCommand.CommandText = "spGetGenreByGenreId";
selectCommand.CommandType = CommandType.StoredProcedure;
selectCommand.Parameters.AddWithValue("@GenreId", GenreId);
connection.Open();
using (SqlDataReader reader = selectCommand.ExecuteReader())
{
if (reader.Read())
{
genre.GenreId = (int)reader["GenreId"];
genre.Name = reader["Name"].ToString();
}
reader.Close();
}
}
}
return genre;
}
