using System;

public class Program

{

    public static void Main(){

        ExecUpdateSSCCFromPackageId(221138);

        ExecUpdateSSCCFromPackageId(221139);        

        UpdateSSCCFromPackageId(218590);

    }

    static public int SSCCCheckDigit (long sscc){   

        int odd = 0;

        //int even = 0;

        char[] ssccNumberArray = sscc.ToString().ToCharArray();

        if(ssccNumberArray.Length != 17){

        return 99;

        }

            for (int i = 0; i < 17; i++)

            {

                if (i % 2 == 0)

                {

                    odd += (Convert.ToInt32(ssccNumberArray.GetValue(i))) * 3;

                }

                else

                {

                    odd += (Convert.ToInt32(ssccNumberArray.GetValue(i))) * 1;

                }

            }

            int checksum = 10 - ((odd) % 10);

            return checksum;

    }

    static public bool IsValidSSCC (long sscc){ 

            if(sscc < 100000000000000000){

                return false;

            }

            if(SSCCCheckDigit(sscc/10) != sscc%10){

                return false ;

            }

​

            return true;

    }

​

    static public bool IsValidCLDSSCC (long sscc){  

            if(sscc < 854250255900000000){

                return false;

            }

            if(SSCCCheckDigit(sscc/10) != sscc%10){

                return false ;

            }

​

            return true;

    }   

        static public long GenerateSSCCFromPackageId (long PackageId){  

            long sscc = 85425025590000000 + PackageId ;

            sscc = sscc * 10 + SSCCCheckDigit(sscc) ;

​

            return sscc;

    }

            static public void UpdateSSCCFromPackageId (long PackageId){

            Console.WriteLine("update packing.Package set scc = " + GenerateSSCCFromPackageId(PackageId).ToString() + " where id = " + PackageId.ToString());

​

    }

                static public void ExecUpdateSSCCFromPackageId (long PackageId){

            Console.WriteLine("EXEC [packing].[CLD_DevTools_Set_SCC] @id = " + PackageId.ToString() + ", @scc = " + GenerateSSCCFromPackageId(PackageId).ToString());

​

    }

}