private bool DoesGenreExist(Genre genre)
{
try
{
_genreRepository.GetGenreByName(genre.GenreName);
return true;
}
catch
{
return false;
}
}
public int CreateGenre(Genre genre)
{
var sql = "INSERT INTO dbo.Genre (Name) VALUES (@genreName); SELECT CAST(SCOPE_IDENTITY() as int;";
return _connection.ExecuteScalar<int>(sql, new { genreName = genre.GenreName});
}