//List borrowed by borrow Id
public BorrowModel ListBorrowedByBID(int borrowId)
{
//empty list of media models to start us off
List <BorrowModel> borrowedMedias = new List <BorrowModel>();
MediaDS.TabBorrowDataTable borrowedTable = mediaDAO.ListBorrowed();
foreach (MediaDS.TabBorrowRow row in borrowedTable.Rows)
{
if (row.BID == borrowId)
{
BorrowModel media = BorrowModel.Parse(row);
borrowedMedias.Add(media);//add it to our list of media
}
}
BorrowModel borrowed = null;
if (borrowedMedias.Count == 0)
{
borrowedMedias = null;
}
else
{
borrowed = borrowedMedias[0];
}
return(borrowed);
}
//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);
}
//List Borrowed by actual return date
public BorrowModel GetBorrowed(int mediaId)
{
List <BorrowModel> borrowedMedias = new List <BorrowModel>();
MediaDS.TabBorrowDataTable borrowedTable = mediaDAO.ListBorrowed();
foreach (MediaDS.TabBorrowRow row in borrowedTable.Rows)
{
if (row.MediaID == mediaId && row.ActualReturnDate < row.BorrowDate)
{
BorrowModel borrowedMedia = BorrowModel.Parse(row);
borrowedMedias.Add(borrowedMedia);
}
}
BorrowModel borrowed = null;
if (borrowedMedias.Count == 0)
{
borrowedMedias = null;
}
else
{
borrowed = borrowedMedias[0];
}
return(borrowed);
}
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 <BorrowModel> ListBorrowedItems()
{
List <BorrowModel> borrowList = new List <BorrowModel>();
borrowTable = mediaDAO.ListBorrow();
foreach (MediaDS.TabBorrowRow row in borrowTable.Rows)
{
BorrowModel borrowItem = BorrowModel.Parse(row);
borrowList.Add(borrowItem);
}
return(borrowList);
}
public List <BRModel> ListMediaBorrowUser(int UserID)
{
List <BRModel> medias = new List <BRModel>();
borrowTable = mediaDAO.ListMediaReturn(UserID);
foreach (MediaDS.TabBorrowRow row in borrowTable.Rows)
{
BRModel media = BRModel.Parse(row);
medias.Add(media);
}
return(medias);
}
public List <BorrowModel> ListBorrow()
{
List <BorrowModel> medias = new List <BorrowModel>();
MediaDS.TabBorrowDataTable borrowTable = mediaDAO.ListBorrow();
foreach (MediaDS.TabBorrowRow row in borrowTable.Rows)
{
BorrowModel media = BorrowModel.Parse(row);
medias.Add(media);
}
return(medias);
}
public List <MediaModel3> ListBorrow()
{
List <MediaModel3> medias = new List <MediaModel3>();
MediaDS.TabBorrowDataTable borrowTable = mediaDAO.ListBorrow();
foreach (MediaDS.TabBorrowRow row in borrowTable.Rows)
{
MediaModel3 media = MediaModel3.Parse(row);
medias.Add(media);
}
return(medias);
}
//Borrowed medias <<<<<
//Lista all borrowed medias
public List <BorrowModel> ListAllMediasBorrowed()
{
//empty list of media models to start us off
List <BorrowModel> borrowedMedias = new List <BorrowModel>();
MediaDS.TabBorrowDataTable borrowedTable = mediaDAO.ListBorrowed();
foreach (MediaDS.TabBorrowRow row in borrowedTable.Rows)
{
//create a model representing that row
BorrowModel media = BorrowModel.Parse(row);
borrowedMedias.Add(media);//add it to our list of media
}
return(borrowedMedias);
}
//List borrowed by media Id
public List <BorrowModel> GetBorrowedByMediaId(int mediaId)
{
List <BorrowModel> borrowedMedias = new List <BorrowModel>();
MediaDS.TabBorrowDataTable borrowedTable = mediaDAO.ListBorrowed();
foreach (MediaDS.TabBorrowRow row in borrowedTable.Rows)
{
if (row.MediaID == mediaId)
{
BorrowModel borrowedMedia = BorrowModel.Parse(row);
borrowedMedias.Add(borrowedMedia);
}
}
if (borrowedMedias.Count == 0)
{
borrowedMedias = null;
}
return(borrowedMedias);
}
public BorrowLogic()
{
mediaDAO = new MediaDAO();
borrowTable = new MediaDS.TabBorrowDataTable();
}
