public bool DeleteBookIssues(int studentID, int bookNumber) { LibraryManagementEntities context = new LibraryManagementEntities(); bool flag = false; var query = (from data in context.Books where data.Book_Number == bookNumber select data).FirstOrDefault(); int quantity = query.Quantity; query.Quantity = quantity + 1; var deleteQuery = (from data in context.BookIssues where data.Student_Number == studentID && data.Book_Number == bookNumber select data).FirstOrDefault(); context.BookIssues.Remove(deleteQuery); context.SaveChanges(); flag = true; return(flag); }
public List <Book> SearchBooks(string searchData) { try { LibraryManagementEntities context = new LibraryManagementEntities(); int search = 0; if (int.TryParse(searchData, out search)) { ; } var query = from data in context.Books where data.Book_Number == search || data.Book_Name.Contains(searchData) || data.Publication.Contains(searchData) || data.Author.Contains(searchData) select data; return(query.ToList()); } catch (Exception ex) { throw new Exception(ex.Message); } }
public bool NewBookIssue(BookIssue book) { try { bool flag = false; LibraryManagementEntities context = new LibraryManagementEntities(); var query = (from data in context.Books where data.Book_Number == book.Book_Number select data).FirstOrDefault(); int quantity = query.Quantity; query.Quantity = quantity - 1; context.BookIssues.Add(book); context.SaveChanges(); flag = true; return(flag); } catch (Exception ex) { throw new Exception(ex.Message); } }