//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 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 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);
}
//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);
}