/// <summary> /// Add New Book Loan Touple to Database And Fines. /// </summary> /// <param name="bookId">Book Id</param> /// <param name="branchId">Branch Id</param> /// <param name="cardNumber">Card Number</param> /// <param name="dateOut">Date Out</param> /// <param name="dueDate">Due Date</param> public bool AddNewBookLoanAndFines(string bookId, int branchId, int cardNumber, DateTime dateOut, DateTime dueDate) { tblBOOK_LOANS bookLoans; tblFINE fines; bool result; int newLoanId; try { using (LibraryEntities entity = new LibraryEntities()) { #region Add New Book Loans bookLoans = new tblBOOK_LOANS(); bookLoans.Book_id = bookId.Trim(); bookLoans.Branch_id = branchId; bookLoans.Card_no = cardNumber; bookLoans.Date_out = dateOut; bookLoans.Due_date = dueDate; entity.AddTotblBOOK_LOANS(bookLoans); entity.SaveChanges(); newLoanId = (from latest in entity.tblBOOK_LOANS where latest.Book_id == bookId.Trim() && latest.Branch_id == branchId && latest.Card_no == cardNumber select latest.Loan_id).FirstOrDefault(); #endregion #region Add New Fines fines = new tblFINE(); fines.Book_id = bookId.Trim(); fines.Loan_id = newLoanId; fines.paid = true; fines.Fine_amount = 0; fines.Branch_id = branchId; entity.AddTotblFINES(fines); entity.SaveChanges(); #endregion result = true; } return(result); } catch (Exception e) { result = false; return(result); // Exception In Entity } }