/// <summary>
/// inserts a genre by name
/// </summary>
/// <param name="genreName">name of genre</param>
/// <returns>id of genre</returns>
public static int InsertGenre(string genreName)
{
return(DalHelper.InsertIfNotExist($"INSERT INTO Genres ([Genre Name]) VALUES ('{genreName}')",
$"SELECT ID FROM Genres WHERE [Genre Name] LIKE '{genreName}'"));
}
