//List all borrowed medias by current user
public List <PairModel> ListBorrowedByUid(int uid)
{
List <PairModel> pairs = new List <PairModel>();
MediaDS.TabBorrowDataTable borrowTable = mediaDAO.ListBorrowed();
MediaDS.ViewMediaDataTable mediaTable = mediaDAO.ListMedia();
foreach (MediaDS.TabBorrowRow row in borrowTable.Rows)
{
foreach (MediaDS.ViewMediaRow row2 in mediaTable.Rows)
{
//Filter borrowed medias by user and actualReturnDate
if (row.MediaID == row2.MediaID && row.ActualReturnDate < row.BorrowDate && uid == row.UID)
{
PairModel pair = PairModel.Parse(row.BID, row2.Title);
pairs.Add(pair);
}
}
}
if (pairs.Count == 0)
{
pairs = null;
}
return(pairs);
}
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();
}
public List <Media> getMediaByGenre(String genreName)
{
List <Media> myList = new List <Media>();
MediaDS.ViewMediaDataTable myData = mediaDAO.getMediaByGenreName(genreName);
//parse data from datatable rows to list elements
myList = parseMediaDataTolistAll(myData);
return(myList);
}
public List <Media> getAllMedia()
{
List <Media> myList = new List <Media>();
MediaDS.ViewMediaDataTable myData = mediaDAO.getAllMediaView();
//parse data from datatable rows to list elements
myList = parseMediaDataTolistAll(myData);
return(myList);
}
//search by genre
public List <MediaModel> ListMediaGenre(string genre)
{
List <MediaModel> medias = new List <MediaModel>();
mediaTable = mediaDAO.ListMediaByGenre(genre);
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> allMedia = new List <MediaModel>();
mediaTable = mediaDAO.ListMediaByPublishYear(publishYear);
foreach (MediaDS.ViewMediaRow row in mediaTable.Rows)
{
MediaModel media = MediaModel.Parse(row);
allMedia.Add(media);
}
return(allMedia);
}
public List <MediaModel> ListMediaByBudget(int budget)
{
List <MediaModel> medias = new List <MediaModel>();
MediaDS.ViewMediaDataTable mediaTable = mediaDAO.ListMediaByBudget(budget);
foreach (MediaDS.ViewMediaRow row in mediaTable.Rows)
{
MediaModel media = MediaModel.Parse(row);
medias.Add(media);
}
return(medias);
}
public List <MediaModel> ListMediaByDirector(string Director)
{
List <MediaModel> medias = new List <MediaModel>();
MediaDS.ViewMediaDataTable mediaTable = mediaDAO.ListMediaByDirector(Director);
foreach (MediaDS.ViewMediaRow row in mediaTable.Rows)
{
MediaModel media = MediaModel.Parse(row);
medias.Add(media);
}
return(medias);
}
public List <MediaModel> ListMediaByLanguage(String language)
{
List <MediaModel> medias = new List <MediaModel>();
mediaTable = mediaDAO.ListMediaByLanguage(language);
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);
}
public List <MediaModel> ListMedia()
{
//empty list of media models to start us off
List <MediaModel> medias = new List <MediaModel>();
MediaDS.ViewMediaDataTable mediaTable = mediaDAO.ListMedia();
foreach (MediaDS.ViewMediaRow row in mediaTable.Rows)
{
//create a model representing that row
MediaModel media = MediaModel.Parse(row);
medias.Add(media);//add it to our list of 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> 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 <Media> parseMediaDataTolistAll(MediaDS.ViewMediaDataTable myDataTable)
{
List <Media> mediaList = new List <Media>();
foreach (MediaDS.ViewMediaRow row in myDataTable.Rows)
//foreach (UserDS.TabUserRow row in myDataTable.Rows)
{
if (row == null)
{
return(null);
}
else
{
Media mItem = new Media(row.MediaID, row.Title, row.GenreName, row.DirectorName, row.LanguageName, row.PublishYear, row.Budget, row.Genre, row.Director, row.Language);
//Media mItemNoFk = new Media(row.MediaID, row.Title, row.GenreName, row.DirectorName, row.LanguageName, row.PublishYear);
mediaList.Add(mItem);
}
}
return(mediaList);
}
