Output parameter returns null
Hi,In my stored procedure output parameter returns null in value in business logic class below i put my SP and business logic code.
Can anybody guide to me?
alter Procedure BD_InsertMobileClient_GpsLogPlanogram
(
@SalesPersonID int,
@MobileRowID int,
@StatusCode int output
)
AS
INSERT INTO dbo.tblGpsplanogram
(
SalespersonID,
MobileGpsRowID
)
VALUES
(
@SalesPersonID,
@MobileRowID
)
Declare @CurrentrowID int;
set @CurrentrowID = @@IDENTITY
select @StatusCode = MobileGpsRowID from tblGpsplanogram
where ID = @CurrentrowID
RETURN @StatusCode
Business logic:
public int InsertBdDetails()
{ try
{
SqlParameter[] paramStock =
{
new SqlParameter("@SalesPersonID", SqlDbType.Int, 50,ParameterDirection.Input,false,0,0,"SalespersonID",DataRowVersion.Original,sSalesPersonID),
new SqlParameter("@MobileRowID",SqlDbType.Int, 30,ParameterDirection.Input,false,0,0,"MobileGpsRowID",DataRowVersion.Original,MobileRowID),
new SqlParameter("@StatusCode",SqlDbType.Int,30,ParameterDirection.Output,false,0,0,"",DataRowVersion.Original,StockStausCode)
};
SqlHelper.ExecuteNonQuery("BD_InsertMobileClient_GpsLogPlanogram", paramStock);
if (StockStausCode > 0)
{
StockStausCode = Convert.ToInt32(paramStock[2].Value);
}
return StockStausCode ;
}
catch (Exception ex)
{
objErrorHandler.LogError(1, "BlmrmService", "InsertBdDetails", ex.Message, "", "1");
throw ex;
}
}
Thanks and regards
brite