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