public List <Loan> GetAllLoans(StudentSql studentSql, BookSql bookSql, TypeSql typeSql)
{
List <Loan> matchedLoans = new List <Loan>();
con.Open();
cmd.CommandText = "SELECT * FROM loan";
rdr = cmd.ExecuteReader();
while (rdr.Read())
{
Loan loan = new Loan();
loan.Id = rdr.GetInt32(0);
loan.Pupil = studentSql.FindStudentById(rdr.GetInt32(1));
loan.Tome = bookSql.FindBookById(rdr.GetInt32(2), typeSql);
loan.LoanDate = rdr.GetDateTime(3);
loan.LoanDue = rdr.GetDateTime(4);
loan.Active = rdr.GetBoolean(5);
loan.Accrued = rdr.GetDecimal(6);
if (loan.Active == true)
{
TimeSpan late = DateTime.Now - loan.LoanDue;
loan.Accrued = late.Days * loan.Tome.TomeType.Penalty;
}
matchedLoans.Add(loan);
}
return(matchedLoans);
}
public List <Loan> GetLoanByAccrued(Decimal accrued, StudentSql studentSql, BookSql bookSql, TypeSql typeSql)
{
List <Loan> matchedLoans = new List <Loan>();
if (accrued != 0)
{
try
{
con.Open();
cmd.CommandText = "SELECT * FROM loan WHERE loan_accrued=" + accrued;
rdr = cmd.ExecuteReader();
while (rdr.Read())
{
Loan loan = new Loan();
loan.Id = rdr.GetInt32(0);
loan.Pupil = studentSql.FindStudentById(rdr.GetInt32(1));
loan.Tome = bookSql.FindBookById(rdr.GetInt32(2), typeSql);
loan.LoanDate = rdr.GetDateTime(3);
loan.LoanDue = rdr.GetDateTime(4);
loan.Active = rdr.GetBoolean(5);
loan.Accrued = rdr.GetDecimal(6);
matchedLoans.Add(loan);
}
}
catch (MySqlException e)
{
log.Error("Get Loans(accrued) query Failure", e);
}
}
return(matchedLoans);
}
/************************************************************ Loan Getters **/
public Loan FindLoanById(int loanId, StudentSql studentSql, BookSql bookSql, TypeSql typeSql)
{
Loan loan = new Loan();
if (loanId != 0)
{
try
{
con.Open();
cmd.CommandText = "SELECT * FROM loan WHERE loan_id=" + loanId;
rdr = cmd.ExecuteReader();
while (rdr.Read())
{
loan.Id = rdr.GetInt32(0);
loan.Pupil = studentSql.FindStudentById(rdr.GetInt32(1));
loan.Tome = bookSql.FindBookById(rdr.GetInt32(2), typeSql);
loan.LoanDate = rdr.GetDateTime(3);
loan.LoanDue = rdr.GetDateTime(4);
loan.Active = rdr.GetBoolean(5);
loan.Accrued = rdr.GetDecimal(6);
}
}
catch (MySqlException e)
{
log.Error("Find Loan(id)", e);
}
finally
{
con.Close();
}
}
return(loan);
}
public List <Loan> GetLoansById(int loanId, StudentSql studentSql, BookSql bookSql, TypeSql typeSql)
{
List <Loan> matchedLoans = new List <Loan>();
if (loanId != 0)
{
try
{
con.Open();
cmd.CommandText = "SELECT * FROM loan WHERE loan_id=" + loanId;
rdr = cmd.ExecuteReader();
while (rdr.Read())
{
Loan loan = new Loan();
loan.Id = rdr.GetInt32(0);
loan.Pupil = studentSql.FindStudentById(rdr.GetInt32(1));
loan.Tome = bookSql.FindBookById(rdr.GetInt32(2), typeSql);
loan.LoanDate = rdr.GetDateTime(3);
loan.LoanDue = rdr.GetDateTime(4);
loan.Active = rdr.GetBoolean(5);
loan.Accrued = rdr.GetDecimal(6);
if (loan.Active == true)
{
TimeSpan late = DateTime.Now - loan.LoanDue;
loan.Accrued = late.Days * loan.Tome.TomeType.Penalty;
}
matchedLoans.Add(loan);
}
}
catch (MySqlException e)
{
log.Error("Get Loans(id) Query Failure", e);
}
finally
{
con.Close();
}
}
return(matchedLoans);
}