32 lines
768 B
Transact-SQL
32 lines
768 B
Transact-SQL
|
|
CREATE PROCEDURE [dbo].[SetBillingLog]
|
|
(
|
|
@userid varchar(50),
|
|
@charid varchar(128),
|
|
@uniqueid varchar(128),
|
|
@amount int,
|
|
@itemid int,
|
|
@itemcount int
|
|
)
|
|
AS
|
|
BEGIN
|
|
SET NOCOUNT ON;
|
|
|
|
BEGIN TRY
|
|
-- Insert the values into the BillingLog table
|
|
INSERT INTO BillingLog (BuyTime, WindyCode, CharId, UniqueId, Amount, ItemId, ItemCount)
|
|
VALUES (GETDATE(), @userid, @charid, @uniqueid, @amount, @itemid, @itemcount);
|
|
|
|
-- Return a success message
|
|
SELECT 'Success' AS Result;
|
|
END TRY
|
|
BEGIN CATCH
|
|
-- Log the error and return an error message
|
|
DECLARE @errorMessage varchar(4000) = ERROR_MESSAGE();
|
|
RAISERROR(@errorMessage, 16, 1);
|
|
|
|
-- Return an error message
|
|
SELECT 'Error: ' + @errorMessage AS Result;
|
|
END CATCH;
|
|
END;
|
|
|