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