How to get a identity back

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

Not sure if you need more here, but I am sending all these values in an
object. I am not sure how to get the Identity back from the SP using an
object like this


Public Shared Sub PacketSave(ByVal packet As PacketBO)

Dim p() As Object = New Object() {packet.EnteredUserID,
packet.OfferingCompany, packet.CompanyName, _

packet.InstallAddress.Address1, packet.InstallAddress.City,
packet.InstallAddress.State, _

packet.InstallAddress.Zip, packet.InstallAddress.Township,
packet.InstallAddress.ContactName, _

packet.InstallAddress.ContactPhone, packet.InstallAddress.ContactFax,
packet.InstallAddress.ContactEmail, _

packet.InstallAddress.County, packet.BillingAddress.Address1,
packet.BillingAddress.City, _

packet.BillingAddress.State, packet.BillingAddress.Zip,
packet.BillingAddress.Township, _

packet.BillingAddress.ContactName, packet.BillingAddress.ContactPhone,
packet.BillingAddress.ContactFax, _

packet.BillingAddress.ContactEmail, packet.TaxUCC, packet.FederalSaleTax,
packet.StateSaleTax, _

packet.StateGRSurcharge, packet.County911Cost, packet.VoiceSaleName,
packet.DataSaleName, _

packet.HowCustomerHear, packet.TypeOfService, packet.EngineerRequired,
packet.DeliveryArea, _

packet.RequestedInstallDate, packet.RequestedTime, packet.LOADate,
packet.PacketDate, _

packet.SaleDate, packet.AccountRepUserID, packet.AccountRepName,
packet.AccountRepAddress.ContactPhone, _

packet.InstallAddress.ContactFax, packet.InstallAddress.ContactEmail,
packet.AuthorizedExcutiveUserID, _

packet.AuthorizedExcutiveName, packet.AuthorizedExecutiveInfo,
packet.PhoneSystemVendor, packet.PhoneNumber, packet.IsThisRenewal, _

packet.TermContract}

Proxy.ExecuteNonQuery("usp_Packet_ins", p)

End Sub







CREATE PROCEDURE usp_Packet_ins
(@EnteredUserID_2 [int],
@OfferingCompany_4 [varchar](100),
@CompanyName_5 [varchar](100),
@InstallAddress_6 [varchar](50),
@InstallCity_7 [varchar](50),
@InstallState_8 [varchar](2),
@InstallZip_9 [varchar](10),
@InstallTownship_10 [varchar](50),
@InstallContactName_11 [varchar](50),
@InstallContactPhone_12 [varchar](20),
@InstallContactFax_13 [varchar](20),
@InstallContactEmail_14 [varchar](100),
@InstallCounty_15 [varchar](50),
@BillingAddress_16 [varchar](50),
@BillingCity_17 [varchar](50),
@BillingState_18 [varchar](2),
@BillingZip_19 [varchar](10),
@BillingTownship_20 [varchar](50),
@BillingContactName_21 [varchar](50),
@BillingContactPhone_22 [varchar](20),
@BillingContactFax_23 [varchar](20),
@BillingContactEmail_24 [varchar](100),
@TaxUCC_25 float,
@FederalSaleTax_26 float,
@StateSaleTax_27 float,
@StateGRSurcharge_28 float,
@County911Cost_29 float,
@VoiceSaleName_30 [varchar](50),
@DataSaleName_31 [varchar](50),
@HowCustomerHear_32 [varchar](50),
@TypeOfService_33 [varchar](50),
@EngineerRequired_34 [varchar](50),
@DeliveryArea_35 [varchar](50),
@RequestedInstallDate_36 [datetime],
@RequestedTime_37 [varchar](50),
@LOADate_38 [datetime],
@ProposalDate_39 [datetime],
@SaleDate_40 [datetime],
@AccountRepUserID_41 [int],
@AccountRepName_42 [varchar](50),
@AccountRepPhone_43 [varchar](20),
@AccountRepFax_44 [varchar](20),
@AccountRepEmail_45 [varchar](50),
@AuthorizedExcutiveUserID_46 [int],
@AuthorizedExcutiveName_47 [varchar](50),
@AuthorizedExecutiveInfo_48 [varchar](50),
@PhoneSystemVendor_49 [varchar](50),
@PhoneNumber_50 [varchar](50),
@IsThisRenewal_51 [tinyint],
@TermContract_52 [varchar](50),
@Identity int OUTPUT)

AS INSERT INTO [SaleProposal].[dbo].[tblPacket]
([EnteredUserID],
[EnteredDate],
[OfferingCompany],
[CompanyName],
[InstallAddress],
[InstallCity],
[InstallState],
[InstallZip],
[InstallTownship],
[InstallContactName],
[InstallContactPhone],
[InstallContactFax],
[InstallContactEmail],
[InstallCounty],
[BillingAddress],
[BillingCity],
[BillingState],
[BillingZip],
[BillingTownship],
[BillingContactName],
[BillingContactPhone],
[BillingContactFax],
[BillingContactEmail],
[TaxUCC],
[FederalSaleTax],
[StateSaleTax],
[StateGRSurcharge],
[County911Cost],
[VoiceSaleName],
[DataSaleName],
[HowCustomerHear],
[TypeOfService],
[EngineerRequired],
[DeliveryArea],
[RequestedInstallDate],
[RequestedTime],
[LOADate],
[ProposalDate],
[SaleDate],
[AccountRepUserID],
[AccountRepName],
[AccountRepPhone],
[AccountRepFax],
[AccountRepEmail],
[AuthorizedExcutiveUserID],
[AuthorizedExcutiveName],
[AuthorizedExecutiveInfo],
[PhoneSystemVendor],
[PhoneNumber],
[IsThisRenewal],
[TermContract])

VALUES
( @EnteredUserID_2,
GETDATE(),
@OfferingCompany_4,
@CompanyName_5,
@InstallAddress_6,
@InstallCity_7,
@InstallState_8,
@InstallZip_9,
@InstallTownship_10,
@InstallContactName_11,
@InstallContactPhone_12,
@InstallContactFax_13,
@InstallContactEmail_14,
@InstallCounty_15,
@BillingAddress_16,
@BillingCity_17,
@BillingState_18,
@BillingZip_19,
@BillingTownship_20,
@BillingContactName_21,
@BillingContactPhone_22,
@BillingContactFax_23,
@BillingContactEmail_24,
@TaxUCC_25,
@FederalSaleTax_26,
@StateSaleTax_27,
@StateGRSurcharge_28,
@County911Cost_29,
@VoiceSaleName_30,
@DataSaleName_31,
@HowCustomerHear_32,
@TypeOfService_33,
@EngineerRequired_34,
@DeliveryArea_35,
@RequestedInstallDate_36,
@RequestedTime_37,
@LOADate_38,
@ProposalDate_39,
@SaleDate_40,
@AccountRepUserID_41,
@AccountRepName_42,
@AccountRepPhone_43,
@AccountRepFax_44,
@AccountRepEmail_45,
@AuthorizedExcutiveUserID_46,
@AuthorizedExcutiveName_47,
@AuthorizedExecutiveInfo_48,
@PhoneSystemVendor_49,
@PhoneNumber_50,
@IsThisRenewal_51,
@TermContract_52)
SET @Identity = SCOPE_IDENTITY()
GO
 
The simpliest way is to remove @Identity from the list of parameters and
return it with a select statement:

select @Identity

Then you can read it as

(int) Proxy.ExecuteScalar ()

Eliyahu

Dave said:
Not sure if you need more here, but I am sending all these values in an
object. I am not sure how to get the Identity back from the SP using an
object like this


Public Shared Sub PacketSave(ByVal packet As PacketBO)

Dim p() As Object = New Object() {packet.EnteredUserID,
packet.OfferingCompany, packet.CompanyName, _

packet.InstallAddress.Address1, packet.InstallAddress.City,
packet.InstallAddress.State, _

packet.InstallAddress.Zip, packet.InstallAddress.Township,
packet.InstallAddress.ContactName, _

packet.InstallAddress.ContactPhone, packet.InstallAddress.ContactFax,
packet.InstallAddress.ContactEmail, _

packet.InstallAddress.County, packet.BillingAddress.Address1,
packet.BillingAddress.City, _

packet.BillingAddress.State, packet.BillingAddress.Zip,
packet.BillingAddress.Township, _

packet.BillingAddress.ContactName, packet.BillingAddress.ContactPhone,
packet.BillingAddress.ContactFax, _

packet.BillingAddress.ContactEmail, packet.TaxUCC, packet.FederalSaleTax,
packet.StateSaleTax, _

packet.StateGRSurcharge, packet.County911Cost, packet.VoiceSaleName,
packet.DataSaleName, _

packet.HowCustomerHear, packet.TypeOfService, packet.EngineerRequired,
packet.DeliveryArea, _

packet.RequestedInstallDate, packet.RequestedTime, packet.LOADate,
packet.PacketDate, _

packet.SaleDate, packet.AccountRepUserID, packet.AccountRepName,
packet.AccountRepAddress.ContactPhone, _

packet.InstallAddress.ContactFax, packet.InstallAddress.ContactEmail,
packet.AuthorizedExcutiveUserID, _

packet.AuthorizedExcutiveName, packet.AuthorizedExecutiveInfo,
packet.PhoneSystemVendor, packet.PhoneNumber, packet.IsThisRenewal, _

packet.TermContract}

Proxy.ExecuteNonQuery("usp_Packet_ins", p)

End Sub







CREATE PROCEDURE usp_Packet_ins
(@EnteredUserID_2 [int],
@OfferingCompany_4 [varchar](100),
@CompanyName_5 [varchar](100),
@InstallAddress_6 [varchar](50),
@InstallCity_7 [varchar](50),
@InstallState_8 [varchar](2),
@InstallZip_9 [varchar](10),
@InstallTownship_10 [varchar](50),
@InstallContactName_11 [varchar](50),
@InstallContactPhone_12 [varchar](20),
@InstallContactFax_13 [varchar](20),
@InstallContactEmail_14 [varchar](100),
@InstallCounty_15 [varchar](50),
@BillingAddress_16 [varchar](50),
@BillingCity_17 [varchar](50),
@BillingState_18 [varchar](2),
@BillingZip_19 [varchar](10),
@BillingTownship_20 [varchar](50),
@BillingContactName_21 [varchar](50),
@BillingContactPhone_22 [varchar](20),
@BillingContactFax_23 [varchar](20),
@BillingContactEmail_24 [varchar](100),
@TaxUCC_25 float,
@FederalSaleTax_26 float,
@StateSaleTax_27 float,
@StateGRSurcharge_28 float,
@County911Cost_29 float,
@VoiceSaleName_30 [varchar](50),
@DataSaleName_31 [varchar](50),
@HowCustomerHear_32 [varchar](50),
@TypeOfService_33 [varchar](50),
@EngineerRequired_34 [varchar](50),
@DeliveryArea_35 [varchar](50),
@RequestedInstallDate_36 [datetime],
@RequestedTime_37 [varchar](50),
@LOADate_38 [datetime],
@ProposalDate_39 [datetime],
@SaleDate_40 [datetime],
@AccountRepUserID_41 [int],
@AccountRepName_42 [varchar](50),
@AccountRepPhone_43 [varchar](20),
@AccountRepFax_44 [varchar](20),
@AccountRepEmail_45 [varchar](50),
@AuthorizedExcutiveUserID_46 [int],
@AuthorizedExcutiveName_47 [varchar](50),
@AuthorizedExecutiveInfo_48 [varchar](50),
@PhoneSystemVendor_49 [varchar](50),
@PhoneNumber_50 [varchar](50),
@IsThisRenewal_51 [tinyint],
@TermContract_52 [varchar](50),
@Identity int OUTPUT)

AS INSERT INTO [SaleProposal].[dbo].[tblPacket]
([EnteredUserID],
[EnteredDate],
[OfferingCompany],
[CompanyName],
[InstallAddress],
[InstallCity],
[InstallState],
[InstallZip],
[InstallTownship],
[InstallContactName],
[InstallContactPhone],
[InstallContactFax],
[InstallContactEmail],
[InstallCounty],
[BillingAddress],
[BillingCity],
[BillingState],
[BillingZip],
[BillingTownship],
[BillingContactName],
[BillingContactPhone],
[BillingContactFax],
[BillingContactEmail],
[TaxUCC],
[FederalSaleTax],
[StateSaleTax],
[StateGRSurcharge],
[County911Cost],
[VoiceSaleName],
[DataSaleName],
[HowCustomerHear],
[TypeOfService],
[EngineerRequired],
[DeliveryArea],
[RequestedInstallDate],
[RequestedTime],
[LOADate],
[ProposalDate],
[SaleDate],
[AccountRepUserID],
[AccountRepName],
[AccountRepPhone],
[AccountRepFax],
[AccountRepEmail],
[AuthorizedExcutiveUserID],
[AuthorizedExcutiveName],
[AuthorizedExecutiveInfo],
[PhoneSystemVendor],
[PhoneNumber],
[IsThisRenewal],
[TermContract])

VALUES
( @EnteredUserID_2,
GETDATE(),
@OfferingCompany_4,
@CompanyName_5,
@InstallAddress_6,
@InstallCity_7,
@InstallState_8,
@InstallZip_9,
@InstallTownship_10,
@InstallContactName_11,
@InstallContactPhone_12,
@InstallContactFax_13,
@InstallContactEmail_14,
@InstallCounty_15,
@BillingAddress_16,
@BillingCity_17,
@BillingState_18,
@BillingZip_19,
@BillingTownship_20,
@BillingContactName_21,
@BillingContactPhone_22,
@BillingContactFax_23,
@BillingContactEmail_24,
@TaxUCC_25,
@FederalSaleTax_26,
@StateSaleTax_27,
@StateGRSurcharge_28,
@County911Cost_29,
@VoiceSaleName_30,
@DataSaleName_31,
@HowCustomerHear_32,
@TypeOfService_33,
@EngineerRequired_34,
@DeliveryArea_35,
@RequestedInstallDate_36,
@RequestedTime_37,
@LOADate_38,
@ProposalDate_39,
@SaleDate_40,
@AccountRepUserID_41,
@AccountRepName_42,
@AccountRepPhone_43,
@AccountRepFax_44,
@AccountRepEmail_45,
@AuthorizedExcutiveUserID_46,
@AuthorizedExcutiveName_47,
@AuthorizedExecutiveInfo_48,
@PhoneSystemVendor_49,
@PhoneNumber_50,
@IsThisRenewal_51,
@TermContract_52)
SET @Identity = SCOPE_IDENTITY()
GO
Click to expand...
 
Back
Top