System.Data.DataRowVersion.Original

        this.dataAdapter = new System.Data.SqlClient.SqlDataAdapter();

        this.sqlDeleteCommand = new System.Data.SqlClient.SqlCommand();
        this.sqlInsertCommand = new System.Data.SqlClient.SqlCommand();
        this.sqlSelectCommand = new System.Data.SqlClient.SqlCommand();
        this.sqlUpdateCommand = new System.Data.SqlClient.SqlCommand();

        this.dataAdapter.DeleteCommand = this.sqlDeleteCommand;
        this.dataAdapter.InsertCommand = this.sqlInsertCommand;
        this.dataAdapter.SelectCommand = this.sqlSelectCommand;
        this.dataAdapter.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
            new System.Data.Common.DataTableMapping("Table", "ShowIntlMetaCodes", new System.Data.Common.DataColumnMapping[] {
                        new System.Data.Common.DataColumnMapping("META_CODE_NAME", "META_CODE_NAME"),
                        new System.Data.Common.DataColumnMapping("META_CODE", "META_CODE"),
                        new System.Data.Common.DataColumnMapping("COUNTRY", "COUNTRY"),
                        new System.Data.Common.DataColumnMapping("AREA", "AREA"),
                        new System.Data.Common.DataColumnMapping("STATUS", "STATUS"),
                        new System.Data.Common.DataColumnMapping("EFFECTIVE_FROM", "EFFECTIVE_FROM"),
                        new System.Data.Common.DataColumnMapping("ADDED_BY_USER", "ADDED_BY_USER"),
                        new System.Data.Common.DataColumnMapping("CREATION_TIME", "CREATION_TIME")}),
            new System.Data.Common.DataTableMapping("Table1", "Table1", new System.Data.Common.DataColumnMapping[] {
                        new System.Data.Common.DataColumnMapping("META_CODE_NAME", "META_CODE_NAME"),
                        new System.Data.Common.DataColumnMapping("META_CODE", "META_CODE"),
                        new System.Data.Common.DataColumnMapping("COUNTRY", "COUNTRY"),
                        new System.Data.Common.DataColumnMapping("AREA", "AREA"),
                        new System.Data.Common.DataColumnMapping("STATUS", "STATUS"),
                        new System.Data.Common.DataColumnMapping("EFFECTIVE_FROM", "EFFECTIVE_FROM"),
                        new System.Data.Common.DataColumnMapping("ADDED_BY_USER", "ADDED_BY_USER"),
                        new System.Data.Common.DataColumnMapping("CREATION_TIME", "CREATION_TIME")})});
        this.dataAdapter.UpdateCommand = this.sqlUpdateCommand;
        // 
        // sqlDeleteCommand
        // 
        this.sqlDeleteCommand.CommandText = "dbo.IntlMetaCodeDelete";
        this.sqlDeleteCommand.CommandType = System.Data.CommandType.StoredProcedure;
        this.sqlDeleteCommand.Connection = this.connector;
        this.sqlDeleteCommand.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] {
            new System.Data.SqlClient.SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int,  4 , System.Data.ParameterDirection.ReturnValue, false, ((byte)( 0 )), ((byte)( 0 )), "", System.Data.DataRowVersion.Current, null),
            new System.Data.SqlClient.SqlParameter("@COUNTRY", System.Data.SqlDbType.NVarChar,  10 , "COUNTRY"),
            new System.Data.SqlClient.SqlParameter("@AREA", System.Data.SqlDbType.NVarChar,  10 , "AREA"),
            new System.Data.SqlClient.SqlParameter("@ReturnCode", System.Data.SqlDbType.Int,  4 , System.Data.ParameterDirection.InputOutput, false, ((byte)( 0 )), ((byte)( 0 )), "", System.Data.DataRowVersion.Current, null)});
        // 
        // sqlInsertCommand
        // 
        this.sqlInsertCommand.CommandText = "dbo.IntlMetaCodeAdd";
        this.sqlInsertCommand.CommandType = System.Data.CommandType.StoredProcedure;
        this.sqlInsertCommand.Connection = this.connector;
        this.sqlInsertCommand.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] {
            new System.Data.SqlClient.SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int,  4 , System.Data.ParameterDirection.ReturnValue, false, ((byte)( 0 )), ((byte)( 0 )), "", System.Data.DataRowVersion.Current, null),
            new System.Data.SqlClient.SqlParameter("@COUNTRY", System.Data.SqlDbType.NVarChar,  10 , "COUNTRY"),
            new System.Data.SqlClient.SqlParameter("@AREA", System.Data.SqlDbType.NVarChar,  10 , "AREA"),
            new System.Data.SqlClient.SqlParameter("@META_CODE_NAME", System.Data.SqlDbType.NVarChar,  40 , "META_CODE_NAME"),
            new System.Data.SqlClient.SqlParameter("@EFFECTIVE_DATE", System.Data.SqlDbType.DateTime,  8 , "EFFECTIVE_FROM"),
            new System.Data.SqlClient.SqlParameter("@IS_INACTIVE", System.Data.SqlDbType.Bit,  1 , "STATUS"),
            new System.Data.SqlClient.SqlParameter("@ReturnCode", System.Data.SqlDbType.Int,  4 , System.Data.ParameterDirection.InputOutput, false, ((byte)( 0 )), ((byte)( 0 )), "", System.Data.DataRowVersion.Current, null)});
        // 
        // sqlSelectCommand
        // 
        this.sqlSelectCommand.CommandText = "dbo.ShowIntlMetaCodes";
        this.sqlSelectCommand.CommandType = System.Data.CommandType.StoredProcedure;
        this.sqlSelectCommand.Connection = this.connector;
        this.sqlSelectCommand.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] {
            new System.Data.SqlClient.SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int,  4 , System.Data.ParameterDirection.ReturnValue, false, ((byte)( 0 )), ((byte)( 0 )), "", System.Data.DataRowVersion.Current, null),
            new System.Data.SqlClient.SqlParameter("@ACTIVE_OLY", System.Data.SqlDbType.Bit,  1 ),
            new System.Data.SqlClient.SqlParameter("@ReturnCode", System.Data.SqlDbType.Int,  4 , System.Data.ParameterDirection.InputOutput, false, ((byte)( 0 )), ((byte)( 0 )), "", System.Data.DataRowVersion.Current, null)});
        // 
        // sqlUpdateCommand
        // 
        this.sqlUpdateCommand.CommandText = "dbo.IntlMetaCodeAdd";
        this.sqlUpdateCommand.CommandType = System.Data.CommandType.StoredProcedure;
        this.sqlUpdateCommand.Connection = this.connector;
        this.sqlUpdateCommand.Parameters.AddRange(new System.Data.SqlClient.SqlParameter[] {
            new System.Data.SqlClient.SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int,  4 , System.Data.ParameterDirection.ReturnValue, false, ((byte)( 0 )), ((byte)( 0 )), "", System.Data.DataRowVersion.Current, null),
            new System.Data.SqlClient.SqlParameter("@COUNTRY", System.Data.SqlDbType.NVarChar,  10 , "COUNTRY"),
            new System.Data.SqlClient.SqlParameter("@AREA", System.Data.SqlDbType.NVarChar,  10 , "AREA"),
            new System.Data.SqlClient.SqlParameter("@META_CODE_NAME", System.Data.SqlDbType.NVarChar,  40 , "META_CODE_NAME"),
            new System.Data.SqlClient.SqlParameter("@EFFECTIVE_DATE", System.Data.SqlDbType.DateTime,  8 , "EFFECTIVE_FROM"),
            new System.Data.SqlClient.SqlParameter("@IS_INACTIVE", System.Data.SqlDbType.Bit,  1 , "STATUS"),
            new System.Data.SqlClient.SqlParameter("@ReturnCode", System.Data.SqlDbType.Int,  4 , System.Data.ParameterDirection.InputOutput, false, ((byte)( 0 )), ((byte)( 0 )), "", System.Data.DataRowVersion.Current, null)});

          if (dsUpdate.HasChanges())
            dataAdapter.Update(dsUpdate, dsName);

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


ALTER procedure [dbo].[IntlMetaCodeDelete] (
 	@COUNTRY nvarchar( 10 ),
 	@AREA nvarchar( 10 ),
 	@ReturnCode int= 0  OUTPUT
 )
 
BEGIN

  SET NOCOUNT ON

  DECLARE @tran int
  DECLARE @procname nvarchar( 200 )
  DECLARE @ModuleItemID int
  DECLARE @retcode int
  DECLARE @Message nvarchar( 100 );
  DECLARE @META_CODE NVARCHAR( 20 );

  
  SET @procname = 'IntlMetaCodeDelete' -- Указать имя текущей процедуры
  SET @ModuleItemID =  3  --'International Codes'
  SET @ReturnCode =  0 
  SET @META_CODE = RTRIM(LTRIM(@COUNTRY))+RTRIM(LTRIM(@AREA))
 
  SET @tran=@@TRANCOUNT

  BEGIN TRY

      
		IF(RTRIM(LTRIM(@AREA)) = '') --if code is base CC
		BEGIN

			/*we should not be deleteing country code*/
			SET @Message = dbo.fn_GetMessage('CountryCodeCanNotBeDeleted')
			RAISERROR (@Message,  16 ,   1 ) WITH SETERROR
		END --IF @AREA = ''
		
		
	declare		@OLD_EFFECTIVE_DATE datetime,
				@CodeHistoryExists bit,
				@MaxDate as datetime
				
	set			@MaxDate = dbo.GET_MAX_DATE()
	
	SELECT top  1 
		@OLD_EFFECTIVE_DATE = DATEADD(SECOND, - 1 , EFFECTIVE_FROM)
		--,@IS_DEACTIVATED = IS_DEACTIVATED
	FROM RepMetaCodes --WITH (NOLOCK)
	WHERE	META_CODE = @META_CODE
			AND EFFECTIVE_FROM = @MaxDate;
			

	IF(@OLD_EFFECTIVE_DATE IS NULL) --there is no code to be deleted, no action to perform
	BEGIN

		SET @Message = dbo.fn_GetMessage('MetaCodeDoesNotExist')
		RAISERROR (@Message,  16 ,   1 ) WITH SETERROR

	END --IF(@OLD_RATE IS NULL)
	
	IF EXISTS --If the historic code info exists
             (	select top  1  META_CODE
				from RepMetaCodes --WITH (NOLOCK)
				where		META_CODE = @META_CODE
							and EFFECTIVE_TO = @OLD_EFFECTIVE_DATE
			)
	BEGIN
		set @CodeHistoryExists =  1 
	END
		ELSE
	BEGIN
		set @CodeHistoryExists =  0 
	END
      
    
      IF @tran= 0  BEGIN TRAN
      
 		SET XACT_ABORT ON;
			
			--TAKE META CODE OUT OF ROUTING IF NO HISTORY AVAILABLE

			IF(@CodeHistoryExists =  0 )
			BEGIN
				--EXEC [dbo].[RoutePlansIntlDeleteCode] @META_CODE = @META_CODE;
				
				DELETE FROM RoutePlansIntlMetaCodes WHERE META_CODE = @META_CODE;
				DELETE FROM RoutePlansIntlMetaCodesQoS WHERE META_CODE = @META_CODE;
				--it may be same as some carrier code, so we'll not delete it here
				--DELETE FROM dbo.RoutePlansIntlCarrierCodesQoS WHERE DIAL_STRING = @META_CODE;
				DELETE FROM GroupedMetaCodes WHERE META_CODE = @META_CODE;
				DELETE FROM RepMetaCodes WHERE META_CODE = @META_CODE;

			END
			
			--ACTIVATE PREVIOUS CODE INFO IN THE TARIFF IF HISTORY EXISTS

			IF(@CodeHistoryExists =  1 )
			BEGIN
			
				DELETE FROM RepMetaCodes
				WHERE 	META_CODE = @META_CODE
						and EFFECTIVE_TO = @MaxDate;
			
				UPDATE RepMetaCodes
				SET	EFFECTIVE_TO = @MaxDate
					--,IS_INACTIVE = @IS_INACTIVE
				WHERE	META_CODE = @META_CODE
						and EFFECTIVE_TO = @OLD_EFFECTIVE_DATE
					
			END
			
	    --SET @ReturnCode = 1 /*SUCCESS*/
	    
      IF @tran= 0  COMMIT TRAN
  END TRY
  BEGIN CATCH
      IF (@@TRANCOUNT >  0  AND @tran= 0 )
         ROLLBACK TRAN;
      ELSE   
         IF ((@@TRANCOUNT >  0 ) AND (XACT_STATE() <> - 1 ))
             ROLLBACK TRAN;

	  IF (@@TRANCOUNT= 0  AND @ReturnCode= 0 ) EXECUTE dbo.uspLogError @procname,@ReturnCode OUTPUT;

      EXEC usp_RethrowError @procname;
      
   END CATCH
 
 END