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