public List <Borrow> AllBorrows()
{
var borrowTable = new UserData.TabBorrowDataTable();
var borrowAdapter = new TabBorrowTableAdapter();
List <Borrow> list = new List <Borrow>();
int rowCount = borrowAdapter.GetBorrows(borrowTable);
if (rowCount > 0)
{
foreach (DataRow r in borrowTable)
{
Borrow borrow = new Borrow();
borrow.BID = int.Parse(r["BID"].ToString());
borrow.MediaID = int.Parse(r["MediaID"].ToString());
borrow.BorrowDate = r["BorrowDate"].ToString();
borrow.ReturnDate = r["ReturnDate"].ToString();
borrow.ActualReturnDate = r["ActualReturnDate"].ToString();
borrow.BStatus = r["BStatus"].ToString();
borrow.LateFee = decimal.Parse(r["LateFee"].ToString());
list.Add(borrow);
}
}
return(list);
}
public void InsertReturn(string actualReturnDate, decimal lateFee, int BID, int MID)
{
var borrowTable = new UserData.TabBorrowDataTable();
var borrowAdapter = new TabBorrowTableAdapter();
int rowCount = borrowAdapter.ReturnUpdate(actualReturnDate, lateFee, BID);
rowCount = mediaAdapter.UpdateReturn(MID);
}
public void InsertBorrow(int UID, int MediaID, string borrowDate, string returnDate)
{
var borrowTable = new UserData.TabBorrowDataTable();
var borrowAdapter = new TabBorrowTableAdapter();
int countRow = borrowAdapter.InsertBorrow(UID, MediaID, borrowDate, returnDate);
countRow = mediaAdapter.UpdateBorrow(MediaID);
}
public MediaDAO()
{
mediaDataSet = new MediaDS();
viewMediaAdapter = new ViewMediaTableAdapter();
languageTableAdapter = new TabLanguageTableAdapter();
genreTableAdapter = new TabGenreTableAdapter();
tabMediaTableAdapter = new TabMediaTableAdapter();
borrowTableAdapter = new TabBorrowTableAdapter();
reservedTableAdapter = new TabReservedTableAdapter();
}
public MediaDAO()
{
viewMediaAdapter = new ViewMediaTableAdapter();
genreTableAdapter = new TabGenreTableAdapter();
tabMediaTableAdapter = new TabMediaTableAdapter();
languageTableAdapter = new TabLanguageTableAdapter();
directorTableAdapter = new TabDirectorTableAdapter();
tabReserveTableAdapter = new TabReservedTableAdapter();
tabBorrowTableAdapter = new TabBorrowTableAdapter();
}
public MediaDAO()
{
mediaDataSet = new MediaDS();
viewMediaTableAdapter = new ViewMediaTableAdapter();
languageTableAdapter = new TabLanguageTableAdapter();
genreTableAdapter = new TabGenreTableAdapter();
directorTableAdapter = new TabDirectorTableAdapter();
MediaTableAdapter = new TabMediaTableAdapter();
reserveTableAdapter = new TabReservedTableAdapter();
borrowTableAdapter = new TabBorrowTableAdapter();
returnTableAdapter = new TabReturnTableAdapter();
}
//if we need TabMediaTableAdapter, we'll add it later :/
public MediaDAO()
{
mediaDataSet = new MediaDS();
viewMediaAdapter = new ViewMediaTableAdapter();
languageTableAdapter = new TabLanguageTableAdapter();
genreTableAdapter = new TabGenreTableAdapter();
mediaTableAdapter = new TabMediaTableAdapter();
directorTableAdapter = new TabDirectorTableAdapter();
reservedTableAdapter = new TabReservedTableAdapter();
borrowTableAdapter = new TabBorrowTableAdapter();
viewMediaAvailavleAdapter = new ViewMediaAvailableTableAdapter();
viewMediaBorrwedAdapter = new ViewMediaBorrowedTableAdapter();
}
public BookDAO()
{
_bookDataSet = new DataSet1();
_viewBookTableAdapter = new ViewBookTableAdapter();
_tabAuthorTableAdaptater = new TabAuthorTableAdapter();
_tabCategoryTableAdaptater = new TabCategoryTableAdapter();
_viewBookAvailableTableAdapter = new ViewBookAvailableTableAdapter();
_viewBookBorrowedTableAdapter = new ViewBookBorrowedTableAdapter();
_tabLanguageTableAdapter = new TabLanguageTableAdapter();
_tabBorrowTableAdapter = new TabBorrowTableAdapter();
_tabBookTableAdapter = new TabBookTableAdapter();
_tabReservedTableAdapter = new TabReservedTableAdapter();
}
/// <summary>
/// Class constructor
/// </summary>
public BookDAO()
{
//Initialize objects
_bookDataSet = new BookDS();
_tabBookTableAdapter = new TabBookTableAdapter();
_tabReservedTableAdapter = new TabReservedTableAdapter();
_tabBorrowTableAdapter = new TabBorrowTableAdapter();
_viewBookTableAdapter = new ViewBookTableAdapter();
_viewBookAvailableTableAdapter = new ViewBookAvailableTableAdapter();
_viewBookBorrowedTableAdapter = new ViewBookBorrowedTableAdapter();
_viewBookBorrowedWithUserTableAdapter = new ViewBookBorrowedWithUserTableAdapter();
_viewBookReservedTableAdapter = new ViewBookReservedTableAdapter();
}
public bool IsMediaDeleted(int ID)
{
// delete media from TabMedia
tabMediaTableAdapter.DeleteMedia(ID);
// delete borrow record from TabBorrow
TabBorrowTableAdapter tabBorrowTableAdapter = new TabBorrowTableAdapter();
tabBorrowTableAdapter.DeleteBorrow(ID);
// delete reserve record from TabReserved
TabReservedTableAdapter tabReservedTableAdapter = new TabReservedTableAdapter();
tabReservedTableAdapter.DeleteReserved(ID);
return(true);
}
public BorrowDAO()
{
borrowDataSet = new BorrowDS();
tabBorrowTableAdapter = new TabBorrowTableAdapter();
}
