public int InsertGenre(String genreName) { var genreTable = new UserData.TabGenreDataTable(); var genreAdapter = new TabGenreTableAdapter(); int rowCount = 0; if (genreName != null) { rowCount = genreAdapter.InsertGenre(genreName); return(rowCount); } return(rowCount); }
public int UpdateGenre(string genreName, int genreID) { var genreTable = new UserData.TabGenreDataTable(); var genreAdapter = new TabGenreTableAdapter(); int rowCount = 0; if (genreID != 0) { rowCount = genreAdapter.UpdateGenre(genreName, genreID); return(rowCount); } return(rowCount); }
public List <Genre> getGenre() { List <Genre> genres = new List <Genre>(); var genreTable = new UserData.TabGenreDataTable(); var genreAdapter = new TabGenreTableAdapter(); int rowCount = genreAdapter.getGenre(genreTable); if (rowCount > 0) { foreach (DataRow dr in genreTable) { Genre gen = new Genre(); gen.GID = int.Parse(dr["GID"].ToString()); gen.GenreName = dr["GenreName"].ToString(); genres.Add(gen); } } return(genres); }
public void DeleteGenre(int genreID) { var genreTable = new UserData.TabGenreDataTable(); var genreAdapter = new TabGenreTableAdapter(); int rowCount = genreAdapter.DeleteGenre(genreID); }
public void DeleteLanguage(int languageID) { var languageTable = new UserData.TabGenreDataTable(); var languageAdapter = new TabGenreTableAdapter(); int rowCount = languageAdapter.DeleteGenre(languageID); }