State Machine Complier And Asp.net

��USE [CarAutomation]

GO

/****** Object:  StoredProcedure [dbo].[isp_WorkFlowStatePersistence]    Script Date: 10/20/2008 18:55:51 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

 

CREATE PROCEDURE [dbo].[isp_WorkFlowStatePersistence]  

 -- Add the parameters for the stored procedure here  

    @Car_ID int,  

    @Updated_By int,  

    @Current_State_ID int,  

    @Previous_State_ID int,  

    @Remarks VARCHAR(max)  

AS   



   

 

  if Exists (select Car_ID From Car where Car_ID=  @Car_ID

   and Current_State_ID=@Previous_State_ID)  

  BEGIN   

   -- Audit Log  

   BEGIN  TRAN

    INSERT INTO [CarAutomation].[dbo].[StateAuditLog]

           ([Car_ID]

           ,[State_ID]

           ,[Remarks]

           ,[Last_Updated_By]

           ,[Last_Updated_Date])

     VALUES

           (@Car_ID

           ,@Current_State_ID

           ,@Remarks



           ,@Updated_By

           ,GetDate())

   

   -- Update State Demand Table  

   UPDATE  Car  

   SET     [Current_State_ID] = @Current_State_ID,  

     [Previous_State_ID] = @Previous_State_ID,  

     [Last_Updated_By] = @Updated_By  

   WHERE   [Car_ID] = @Car_ID   

  if(@@error=0)

	commit

  else

    Rollback

END