public List <Issue_Detail> loadIssuedBooks() { List <Issue_Detail> issues = new List <Issue_Detail>(); try { using (var db = new ModelDB()) { var query = from issue in db.Issue_Detail select new { issue.book_id, issue.due_date }; var list = query.ToList(); foreach (var detail in list) { int? num = detail.book_id; DateTime?datetime = detail.due_date; Console.WriteLine("number "); Issue_Detail issueD = new Issue_Detail(); issueD.due_date = datetime; issueD.book_id = num; issues.Add(issueD); } } } catch (Exception ex) { Console.WriteLine("Load exception" + ex.InnerException); } return(issues); }
public Boolean bookReturnedUpdate(Issue_Detail issue) { BookController bookController = new BookController(); int bookID = (int)issue.book_id; Book_Detail book = bookController.findByBookID(bookID); int noOfCopies = (int)book.no_of_copies; book.no_of_copies = ++noOfCopies; Console.WriteLine("Issue ID" + issue.issue_id); Boolean status = false; try { using (var db = new ModelDB()) { bookController.updateBook(book); var entry = db.Entry(issue); entry.State = EntityState.Modified; db.SaveChanges(); status = true; } } catch (Exception ex) { Console.WriteLine("Book return update error " + ex.InnerException); } return(status); }
public Boolean issueBook(Book_Detail book, Member_Detail member, DateTime issueDate, DateTime retrunDate) { Issue_Detail issueDetail = new Issue_Detail(); issueDetail.book_id = book.book_id; issueDetail.member_id = member.member_id; int copies = (int)book.no_of_copies; Console.WriteLine("Number of copies now" + copies); copies--; book.no_of_copies = copies; issueDetail.issue_date = issueDate; issueDetail.due_date = retrunDate; Console.WriteLine("issue book contoller called issue book" + issueDetail); Boolean status = false; try { using (var db = new ModelDB()) { db.Issue_Detail.Add(issueDetail); db.SaveChanges(); status = true; BookController bookController = new BookController(); bookController.updateBook(book); } } catch (Exception ex) { Console.WriteLine("issue error " + ex.InnerException); } return(status); }