public ReserveModel GetReserved(int mediaId)
{
List <ReserveModel> reservedMedias = new List <ReserveModel>();
MediaDS.TabReservedDataTable reservedTable = mediaDAO.ListReserved();
foreach (MediaDS.TabReservedRow row in reservedTable.Rows)
{
if (row.MediaID == mediaId)
{
ReserveModel reservedMedia = ReserveModel.Parse(row);
reservedMedias.Add(reservedMedia);
}
}
ReserveModel reserved = null;
if (reservedMedias.Count == 0)
{
reservedMedias = null;
}
else
{
reserved = reservedMedias[0];
}
return(reserved);
}
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();
reservedTable = new MediaDS.TabReservedDataTable();
}
public List <MediaModel2> ListReserveByUID(int UID)
{
List <MediaModel2> medias = new List <MediaModel2>();
MediaDS.TabReservedDataTable reservedTable = mediaDAO.ListByUID(UID);
foreach (MediaDS.TabReservedRow row in reservedTable.Rows)
{
MediaModel2 media = MediaModel2.Parse(row);
medias.Add(media);
}
return(medias);
}
//List All reserve
public List <ReserveModel> ListAllMediasReserved()
{
//empty list of media models to start us off
List <ReserveModel> reservedMedias = new List <ReserveModel>();
MediaDS.TabReservedDataTable reservedTable = mediaDAO.ListReserved();
foreach (MediaDS.TabReservedRow row in reservedTable.Rows)
{
//create a model representing that row
ReserveModel media = ReserveModel.Parse(row);
reservedMedias.Add(media);//add it to our list of media
}
return(reservedMedias);
}
public List <BRModel> ListOfReservedMedia()
{
try
{
List <BRModel> medias = new List <BRModel>();
reservedTable = mediaDAO.ListOfReservedMedia();
foreach (MediaDS.TabReservedRow row in reservedTable.Rows)
{
BRModel media = BRModel.Parse(row);
medias.Add(media);
}
return(medias);
}
catch (Exception ex)
{
throw ex;
}
}
public List <MediaModel2> ListReserve(int mediaID)
{
List <MediaModel2> medias = new List <MediaModel2>();
MediaDS.TabReservedDataTable reservedTable = mediaDAO.ListReserve();
foreach (MediaDS.TabReservedRow row in reservedTable.Rows)
{
if (row.MediaID == mediaID)
{
MediaModel2 media = MediaModel2.Parse(row);
medias.Add(media);
}
}
if (medias.Count == 0)
{
medias = null;
}
return(medias);
}
