public void UpdateSANTypeData(SANTypeData data)
{
StoredProcUpdate("spSANTypeDataUpdate",
_P("intSANTypeDataID", data.SANTypeDataID),
_P("intBiotaID", data.BiotaID),
_P("vchrType", data.Type),
_P("vchrMuseum", data.Museum),
_P("vchrAccessionNum", data.AccessionNumber),
_P("vchrMaterial", data.Material),
_P("vchrLocality", data.Locality),
_P("intMaterialID", data.MaterialID, DBNull.Value),
_P("bitIDConfirmed", data.IDConfirmed));
}
public void AddNewSANTypeData()
{
var td = new SANTypeData {SANTypeDataID = -1, BiotaID = Taxon.TaxaID.GetValueOrDefault(-1)};
var viewModel = new SANTypeDataViewModel(td);
viewModel.Museum = NextNewName("<New {0}>", _typeData, () => viewModel.Museum);
_typeData.Add(viewModel);
lstTypeData.SelectedItem = viewModel;
RegisterPendingChange(new InsertSANTypeDataCommand(td));
}
public void InsertSANTypeData(SANTypeData data)
{
var retval = ReturnParam("RetVal");
StoredProcUpdate("spSANTypeDataInsert",
_P("intBiotaID", data.BiotaID),
_P("vchrType", data.Type),
_P("vchrMuseum", data.Museum),
_P("vchrAccessionNum", data.AccessionNumber),
_P("vchrMaterial", data.Material),
_P("vchrLocality", data.Locality),
_P("intMaterialID", data.MaterialID, DBNull.Value),
_P("bitIDConfirmed", data.IDConfirmed),
retval);
data.SANTypeDataID = (int) retval.Value;
}
