public List <MediaModel> ListMediaByGenre(string genreName)
{
List <MediaModel> medias = new List <MediaModel>();
mediaTable = mediaDAO.ListMediaByGenre(genreName);
foreach (MediaDS.ViewMediaRow row in mediaTable.Rows)
{
MediaModel media = MediaModel.Parse(row);
medias.Add(media);
}
return(medias);
}
public List <MediaModel> ListMediaByPublishYear(int publishYear)
{
List <MediaModel> medias = new List <MediaModel>();
mediaTable = mediaDAO.ListMediaByPublishYear(publishYear);
foreach (MediaDS.ViewMediaRow row in mediaTable.Rows)
{
MediaModel media = MediaModel.Parse(row);
medias.Add(media);
}
return(medias);
}
public List <MediaModel> searchmedaibyMediaID(int MediaID)
{
List <MediaModel> medias = new List <MediaModel>();
mediaTable = mediaDAO.searchmediabyMediaID(MediaID);;
foreach (MediaDS.ViewMediaRow row in mediaTable.Rows)
{
MediaModel media = MediaModel.Parse(row);
medias.Add(media);
}
return(medias);
}
/// <summary>
/// Get Media Data by Director
/// </summary>
/// <param name="director"></param>
/// <returns></returns>
public List <MediaModel> ListMediaByDirector(String director)
{
try
{
List <MediaModel> medias = new List <MediaModel>();
mediaTable = mediaDAO.ListMediaByDirector(director);
foreach (MediaDS.ViewMediaRow row in mediaTable.Rows)
{
MediaModel media = MediaModel.Parse(row);
medias.Add(media);
}
return(medias);
}
catch (Exception ex)
{
throw ex;
}
}
public List <MediaModel> ListMediaBorrowed()
{
try
{
List <MediaModel> medias = new List <MediaModel>();
mediaBorrowedTable = mediaDAO.ListMediaBorrowed();
foreach (MediaDS.ViewMediaBorrowedRow row in mediaBorrowedTable.Rows)
{
MediaModel media = MediaModel.Parse(row);
medias.Add(media);
}
return(medias);
}
catch (Exception ex)
{
throw ex;
}
}
public List <MediaModel> ListMediaByBudget(decimal budget)
{
try
{
List <MediaModel> medias = new List <MediaModel>();
mediaTable = mediaDAO.ListMediaByBudget(budget);
foreach (MediaDS.ViewMediaRow row in mediaTable.Rows)
{
MediaModel media = MediaModel.Parse(row);
medias.Add(media);
}
return(medias);
}
catch (Exception ex)
{
throw ex;
}
}
public List <MediaModel> getAllMedia()
{
MediaList = new List <MediaModel>();
try
{
//get table data from DAO
MediaDataTable = _mediaDAO.GetMediaAll();
//prepare presentation of data
foreach (MediaDataSet.TabMediaRow row in MediaDataTable.Rows)
{
MediaList.Add(MediaModel.Parse(row));
}
//return list
return(MediaList);
}
catch (Exception ex)
{
throw ex;
}
}