public override ViewModelBase AddNewItem(out DatabaseCommand addAction)
{
var model = new LoanMaterial()
{
Returned = false, NumSpecimens = "1", DateAdded = DateTime.Now
};
addAction = new InsertLoanMaterialCommand(model, Loan);
return(new LoanMaterialViewModel(model));
}
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);
}