public void GetLoanByActive()
{
Boolean active = true;
LoanSql loanSql = new LoanSql();
Console.WriteLine(loanSql.GetLoanByActive(active));
}
public void GetLoanByBookId()
{
int bookId = 1;
LoanSql loanSql = new LoanSql();
Console.WriteLine(loanSql.GetLoanByBookId(bookId));
}
public void GetLoanByDue()
{
DateTime loanDue = new DateTime(2001, 1, 2);
LoanSql loanSql = new LoanSql();
Console.WriteLine(loanSql.GetLoanByDue(loanDue));
}
public void GetLoansById()
{
int loanId = 1;
LoanSql loanSql = new LoanSql();
Console.WriteLine(loanSql.GetLoansById(loanId));
}
public void GetLoansByStudent()
{
int studentId = 1;
LoanSql loanSql = new LoanSql();
Console.WriteLine(loanSql.GetLoansByStudent(studentId));
}
public void FindLoanById()
{
int loanId = 1;
LoanSql loanSql = new LoanSql();
Console.WriteLine(loanSql.FindLoanById(loanId));
}
public void DeleteLoanTest1()
{
int loanId = 1;
LoanSql loanSql = new LoanSql();
Console.WriteLine(loanSql.DeleteLoan(loanId));
}
public void GetLoanByAccrued()
{
Decimal accrued = 11.11m;
LoanSql loanSql = new LoanSql();
Console.WriteLine(loanSql.GetLoanByAccrued(accrued));
}
public void InsertLoanTest1()
{
int studentId = 1;
int bookId = 1;
DateTime loanDate = new DateTime(2001, 1, 1);
DateTime loanDue = new DateTime(2001, 1, 2);
Boolean active = true;
Decimal accrued = 11.11m;
LoanSql loanSql = new LoanSql();
Console.WriteLine(loanSql.InsertLoan(studentId, bookId, loanDate, loanDue, active, accrued));
}
public void UpdateLoan()
{
int loanId = 1;
int studentId = 1;
int bookId = 1;
DateTime loanDate = new DateTime(2002, 2, 2);
DateTime loanDue = new DateTime(2002, 2, 3);
Boolean active = true;
Decimal accrued = 22.22m;
LoanSql loanSql = new LoanSql();
Console.WriteLine(loanSql.UpdateLoan(loanId, studentId, bookId, loanDate, loanDue, active, accrued));
}
