public BookCopy findBookCopyByCopyNo(int copyNo) { BookCopy rb = new BookCopy(); bool found = false; var bookCopy = from bc in db.BookCopies where bc.CopyNumber == copyNo select bc; foreach (var bc in bookCopy) { rb.CopyNumber = bc.CopyNumber; rb.CatalogueNumber = bc.CatalogueNumber; rb.dateDueBackIn = bc.dateDueBackIn; rb.edition = bc.edition.Trim(); rb.ISBN = bc.ISBN.Trim(); rb.status = bc.status.Trim(); rb.year = bc.year.Trim(); found = true; } if (!found) return null; return rb; }
public int addBookCopy(int catNum, string sEdition, string sYear, string sIsbn) { int copyNum = 0; BookCopy bookCopy = new BookCopy { CatalogueNumber = catNum, edition = sEdition, year = sYear, ISBN = sIsbn, status = ST_AVAILABLE, dateDueBackIn = null }; db.BookCopies.InsertOnSubmit(bookCopy); db.SubmitChanges(); //submit the action to customer table copyNum = bookCopy.CopyNumber; return copyNum; }
partial void UpdateBookCopy(BookCopy instance);
partial void DeleteBookCopy(BookCopy instance);
partial void InsertBookCopy(BookCopy instance);