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