State Machine Complier And Asp.net

    using System;
using System.Collections.Generic;
using System.Text;
using System.Data.SqlClient;
using System.Configuration;
using Domain;
using System.Data;

namespace DataAccess
{
    public partial class DataProvider
    {
        public static void PersistWorkFlowStateMachine(Car car,Domain.Utilities.CarState currentState,Domain.Utilities.CarState previousState)
        {
            int isSuccess;
            SqlConnection sqlCon=null;
            try
            {
                sqlCon = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"].ToString());
                sqlCon.Open();

                SqlCommand sqlCmd = new SqlCommand();                
                sqlCmd.CommandText = "isp_WorkFlowStatePersistence";
                sqlCmd.CommandType = CommandType.StoredProcedure;
                sqlCmd.Connection = sqlCon;

                SqlParameter param1 = new SqlParameter();
                param1.ParameterName = "@Car_ID";
                param1.Value = car.CarID;
                sqlCmd.Parameters.Add(param1);

                SqlParameter param2 = new SqlParameter();
                param2.ParameterName = "@Updated_By";
                param2.Value = car.User;
                sqlCmd.Parameters.Add(param2);

                SqlParameter param3 = new SqlParameter();
                param3.ParameterName = "@Current_State_ID";
                param3.Value = Convert.ToInt32(currentState);
                sqlCmd.Parameters.Add(param3);

                SqlParameter param4 = new SqlParameter();
                param4.ParameterName = "@Previous_State_ID";
                param4.Value = Convert.ToInt32(previousState);
                sqlCmd.Parameters.Add(param4);

                SqlParameter param5 = new SqlParameter();
                param5.ParameterName = "@Remarks";
                param5.Value = car.Remark;
                sqlCmd.Parameters.Add(param5);
                              
                isSuccess = sqlCmd.ExecuteNonQuery();
                sqlCon.Close();
                sqlCmd.Dispose();
            }
            catch (Exception ex)
            {
                sqlCon.Close();
                throw ex;
            }        
        }
    }
}