private TabReturnTableAdapter returnTableAdapter; //new
public MediaDAO()
{
mediaDataSet = new MediaDS();
viewMediaTableAdapter = new ViewMediaTableAdapter();
languageTableAdapter = new TabLanguageTableAdapter();
genreTableAdapter = new TabGenreTableAdapter();
directorTableAdapter = new TabDirectorTableAdapter();
MediaTableAdapter = new TabMediaTableAdapter();
reserveTableAdapter = new TabReservedTableAdapter();
borrowTableAdapter = new TabBorrowTableAdapter();
returnTableAdapter = new TabReturnTableAdapter(); //new
}
//if we need TabMediaTableAdapter, we'll add it later :/
public MediaDAO()
{
mediaDataSet = new MediaDS();
viewMediaAdapter = new ViewMediaTableAdapter();
languageTableAdapter = new TabLanguageTableAdapter();
genreTableAdapter = new TabGenreTableAdapter();
mediaTableAdapter = new TabMediaTableAdapter();
directorTableAdapter = new TabDirectorTableAdapter();
reservedTableAdapter = new TabReservedTableAdapter();
borrowTableAdapter = new TabBorrowTableAdapter();
viewMediaAvailavleAdapter = new ViewMediaAvailableTableAdapter();
viewMediaBorrwedAdapter = new ViewMediaBorrowedTableAdapter();
}
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 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 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);
}
