// get genre ID based on genre name
public static int GetGID(string genreName)
{
int gID = -1;
MediaDataSet.TabGenreDataTable tabGenreDataTable = new MediaDataSet.TabGenreDataTable();
TabGenreTableAdapter tabGenreTableAdapter = new TabGenreTableAdapter();
try
{
// retrieve data from database
tabGenreTableAdapter.SelectGenre(tabGenreDataTable, genreName);
// convert data into int
gID = (int)tabGenreDataTable.Rows[0]["GID"];
}
catch (IndexOutOfRangeException e)
{
Console.WriteLine(genreName + " cannot be found in the database.");
Console.WriteLine(e.Message);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
return(gID);
}
public List <PairModel> GetGenres()
{
List <PairModel> pairList = new List <PairModel>();
MediaDataSet.TabGenreDataTable genreTable = mediaDAO.GetGenres();
if (genreTable != null)
{
foreach (MediaDataSet.TabGenreRow row in genreTable.Rows)
{
PairModel pair = PairModel.Parse(row);
pairList.Add(pair);
}
return(pairList);
}
else
{
return(null);
}
}
