public List<IssueBook> GetIssueBooks(string regNo)
{
List<IssueBook> issueBooks=new List<IssueBook>();
try
{
SqlConnectionObj.Open();
string query = string.Format("select * from tbl_Issueed where student_Reg='{0}' and Return_date is null", regNo);
SqlCommandObj.CommandText = query;
SqlDataReader reader = SqlCommandObj.ExecuteReader();
while (reader.Read())
{
IssueBook issueBook=new IssueBook();
issueBook.Book =bookGateway.GetBooks(Convert.ToInt32(reader[0]));
issueBook.IssueCopy = Convert.ToInt32(reader[1]);
issueBook.DateTime = Convert.ToDateTime(reader[3]);
issueBook.Student = studentGateway.GetStudent(regNo);
issueBooks.Add(issueBook);
}
}
catch (Exception exception)
{
throw new Exception("Error occurred during search this book.",exception);
}
finally
{
SqlConnectionObj.Close();
}
return issueBooks;
}
private void UpdateReturn(IssueBook selectedIssueBook)
{
DateTime now = DateTime.Now;
try
{
SqlConnectionObj.Open();
string query = string.Format("Update tbl_Issueed set Return_date='{0}' where Book_id={1} and student_Reg='{2}' and Issue_date='{3}'", now, selectedIssueBook.Book.Id, selectedIssueBook.Student.RegNo, selectedIssueBook.DateTime);
SqlCommandObj.CommandText = query;
SqlCommandObj.ExecuteNonQuery();
}
catch (Exception exception)
{
throw new Exception("Error occurred during return this book.", exception);
}
finally
{
SqlConnectionObj.Close();
}
}
public void ReturnBook(IssueBook selectedIssueBook)
{
bookGateway.UpdateBook(selectedIssueBook.Book.Id,selectedIssueBook.IssueCopy, 2);
UpdateReturn(selectedIssueBook);
}
public void ReturnBook(IssueBook selectedIssueBook)
{
issueGateway.ReturnBook(selectedIssueBook);
}
