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