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