public void UpdateLoanMaterial(LoanMaterial m)
{
StoredProcUpdate("spLoanMaterialUpdate",
_P("intLoanMaterialID", m.LoanMaterialID),
_P("intLoanID", m.LoanID),
_P("intMaterialID", m.MaterialID),
_P("vchrNumSpecimens", m.NumSpecimens),
_P("vchrTaxonName", m.TaxonName),
_P("vchrMaterialDescription", m.MaterialDescription),
_P("dtDateAdded", m.DateAdded),
_P("dtDateReturned", m.DateReturned),
_P("bitReturned", m.Returned));
}
public int InsertLoanMaterial(LoanMaterial m)
{
var retval = ReturnParam("NewLoanMaterialID");
StoredProcUpdate("spLoanMaterialInsert",
_P("intLoanID", m.LoanID),
_P("intMaterialID", m.MaterialID),
_P("vchrNumSpecimens", m.NumSpecimens),
_P("vchrTaxonName", m.TaxonName),
_P("vchrMaterialDescription", m.MaterialDescription),
_P("dtDateAdded", m.DateAdded),
_P("dtDateReturned", m.DateReturned),
_P("bitReturned", m.Returned),
retval
);
return (int)retval.Value;
}
