public MediaLogic()
{
mediaDAO = new MediaDAO();
mediaTable = new MediaDS.ViewMediaDataTable();
languageTable = new MediaDS.TabLanguageDataTable();
genreTable = new MediaDS.TabGenreDataTable();
tabMediaTable = new MediaDS.TabMediaDataTable();
}
public MediaLogic()
{
mediaDAO = new MediaDAO();
mediaTable = new MediaDS.ViewMediaDataTable();
languageTable = new MediaDS.TabLanguageDataTable();
genreTable = new MediaDS.TabGenreDataTable();
directorTable = new MediaDS.TabDirectorDataTable();
borrowTable = new MediaDS.TabBorrowDataTable();
mediaAvailableTable = new MediaDS.ViewMediaAvailableDataTable();
mediaBorrowedTable = new MediaDS.ViewMediaBorrowedDataTable();
}
//Genre tabel ---------------------
public List <IdAndValue> getAllGenreTable()
{
List <IdAndValue> myList = new List <IdAndValue>();
MediaDS.TabGenreDataTable myData = mediaDAO.getAllGenre();
//parse data from datatable rows to list elements
myList = parseGenreDataTolist(myData);
return(myList);
}
public List <PairModel> ListGenres()
{
List <PairModel> list = new List <PairModel>();
genreTable = mediaDAO.ListGenres();
foreach (MediaDS.TabGenreRow row in genreTable.Rows)
{
PairModel pair = PairModel.Parse(row);
list.Add(pair);
}
return(list);
}
public List <PairModel> ListGenres()
{
//unused code from file in canvas that allows list all genres based on TabGenre
List <PairModel> list = new List <PairModel>();
genreTable = mediaDAO.ListGenres();
foreach (MediaDS.TabGenreRow row in genreTable.Rows)
{
PairModel pair = PairModel.Parse(row);
list.Add(pair);
}
return(list);
}
public List <PairModel> ListGenre()
{
List <PairModel> pairs = new List <PairModel>();
MediaDS.TabGenreDataTable genreTable = mediaDAO.ListGenre();
foreach (MediaDS.TabGenreRow row in genreTable.Rows)
{
PairModel pair = PairModel.Parse(row);
pairs.Add(pair);
}
return(pairs);
}
public List <PairModel> ListGenre()
{
List <PairModel> medias = new List <PairModel>();
MediaDS.TabGenreDataTable genreTable = mediaDAO.ListGenre();
foreach (MediaDS.TabGenreRow row in genreTable.Rows)
{
PairModel media = PairModel.Parse(row);
medias.Add(media);
}
return(medias);
}
public int getGenreIdByName(string genreName)
{
//get data from DAO
MediaDS.TabGenreDataTable myData = mediaDAO.getGenreByName(genreName);
int recievedId = -1;
foreach (MediaDS.TabGenreRow row in myData.Rows) //should only result to one row
{
if (row != null)
{
recievedId = row.GID;
}
}
return(recievedId); //if is -1 their is an error
}
//tableGenre
public List <IdAndValue> parseGenreDataTolist(MediaDS.TabGenreDataTable myDataTable)
{
List <IdAndValue> idVal = new List <IdAndValue>();
foreach (MediaDS.TabGenreRow row in myDataTable.Rows)
//foreach (UserDS.TabUserRow row in myDataTable.Rows)
{
if (row == null)
{
return(null);
}
else
{
IdAndValue item = new IdAndValue(row.GID, row.GenreName);
idVal.Add(item);
}
}
return(idVal);
}