const PlayPower = {
    getEnvironment: function(id) {
        switch(Number(id)) {
            case 1: 
            default: return 'Development';
            case 2: return'Testing';
            case 3: return  'Production';
        }
    },
    getEnvironmentList: function(environmentArray) {
        var elist = null;
        environmentArray.forEach((environmentID) => {
            if (elist === null)
                elist = '';
            else 
                elist += ', ';
            elist += PlayPower.getEnvironment(environmentID);

        });
        return elist;
    },
    getDate: function () {	
        return new Date().toLocaleDateString();
    },
    getTime: function () {	
        return new Date().toLocaleTimeString();
    },
    toLowerCatalogName: function(c) {
        var catalogName = c.replace(/\s/g, '')
        return(catalogName.toLowerCase());
    },
    getComponentID: function (IsAda, catalogName) {	// Used in the INIT & DELETE processes
        var componentID = null;
        switch (PlayPower.toLowerCatalogName(catalogName)) {
            case 'hags':
                componentID = "8000116";
                break;
            case 'wabash':
                componentID = "ADULT-CHAIR-MAN-05";    // used for init and remove requests
                break;
            case 'ezdock':
                componentID = "100240SS";
                break;
            case 'miracle':
                if (IsAda)
                    componentID = "11141";
                else
                    componentID = "160203";
                break;
            case 'playworld':
                if (IsAda)
                    componentID = "ZZAC0030";
                else
                    componentID = "A-CH-ZZUN6160";
                break;
            case 'littletikes':
                componentID = "188MIRAGE";
                break;
            default:
                componentID="Tmd"
                break;
        }
        return componentID;
    },
    getCosmosBody: function (proc, para, keys, envID, dups, init, db, container, key){
            cosmosBody = {
            StoreProcedureName: proc,
            Parameters: para,
            UniqueKey: keys,
            Environment: parseInt(envID),
            RemoveDuplicates: dups,
            InitializeCatalog: false,
            Database: db,
            CollectionName: container,
            PartitionKey: key
        };
        return cosmosBody;
    },   
    getMaxBatch: function(catalogName) {
        var mb = 0;
        switch(PlayPower.toLowerCatalogName(catalogName)) {
            case 'hags':		mb = 6000;break;
            case 'wabash':		mb = 1000;break;
            case 'ezdock':		mb = 1000;break;
            case 'miracle':		mb = 6000;break;
            case 'playworld':	mb = 5000;break;
            case 'littletikes': mb = 5000;break;
            default:mb = null;break;
        }
        return mb;
    },
    getBatchArray: function(catalogName, ic) {
        var maxBatch = PlayPower.getMaxBatch(CatalogName);
        arr = [];

        for (sc = 1, ec = ic; sc <= maxBatch; ec += ic, sc += ic) {	
            var j = {
                CatalogName: catalogName,
                StartCnt: 1, EndCnt: 1 }           
            j.StartCnt = sc;
            j.EndCnt = ec;
            arr.push(j);
        }
        return arr;
    },
    getParameters: function(container, obj) {
        var para = null;
        var catalogName = obj.catalogName;
        switch (container) {
            case 'Risers':
            case 'ProductLines':
            case 'GroundMaterials':
            case 'SheetComponents':
            case 'ColorCatalog':
            case 'PaletteItems':
            case 'PostStyles':
                para = [
                    { Name: "@CatalogName", Value: obj.catalogName },
                    { Name: "@EnvironmentId", "Value": parseInt(obj.environmentID) }
                ];
                break;
            case 'ComponentAda':
                para = [
                    { Name: "@CatalogName", Value: obj.catalogName },
                    { Name: "@EnvironmentId", "Value": parseInt(obj.environmentID) },
                    { Name: "@ComponentID", "Value": obj.componentID },
                ];
                break;   
            case 'Components':
                para = [
                    { Name: "@CatalogName", Value: obj.catalogName },
                    { Name: "@EnvironmentId", "Value": parseInt(obj.environmentID) },
                    { Name: "@ComponentID", "Value": obj.componentID },
                    { Name: "@StartCnt", "Value": obj.startCount },
                    { Name: "@EndCnt", "Value": obj.endCount }
                ];
                break; 
        /*
            case 'Rankings':
            case 'Families':
            case 'MountingTypes':
            case 'GuideLines':
            case 'AgeRanges':
            case 'CatalogSpecs':
            case 'LabelStyles':
            case 'Layers':
            case 'LineType':
            case 'Monetary':
            case 'OutputActions':
            case 'OutputTabs':
            case 'PortLayerConfigxx':
            case 'Scales':
            case 'Sheets':
            case 'Views':
            case 'Substitute':
        */
            default:
                obj.catalogName = null;
                para = [
                    { Name: "@CatalogName", Value: null }
                ];
                break;
        }
        return [para, obj.catalogName];
    },
    isOdd: function(num) { return num % 2;},
    PostHttp: function(body, respObj, Url) { // Both Body, respObj are defined by the API
        // Sammple of RespObjs as Defined by the URL returning the Object
        // var respObj = {
        //     "comments": body.Comments,
        //     "sqlDataSource": "",
        //     "sqlDatabase": "PlayPower",
        //     "storeProcedure": body.StoreProcedureName,
        //     "cosmosUri": "",
        //     "cosmosDatabase": body.Database,
        //     "collection": body.CollectionName,
        //     "total": 0,
        //     "success": 0,
        //     "failed": 0
        // };
        var mesgObj = {
            "Status": null,
            "StatusCode": null,
            "Message": null
        };

        $.ajax({
            type: "POST",
            async: false,
            url: Url,
            dataType: "json",
            data: JSON.stringify(body),
            contentType: "application/json; charset=utf-8",
            success: function (response) {
                respObj = response;
                mesgObj.Status = 'Successful';
                mesgObj.StatusCode = 200;
                mesgObj.Message = 'Successfully Executed Cosmos API';
            },
            error: function (req, status, error) {
                console.log(status, req, error);
                mesgObj.Status = 'Failed';
                mesgObj.statusCode = error.status;
                mesgObj.Message = req.responseText;
            }
        });
        return [respObj, mesgObj];
    },
    Format: String.prototype.format = function () {
        var args = arguments;
    
        return this.replace(/{(\d+)}/g, function (match, number) {
            return typeof args[number] != 'undefined' ? args[number] :
                '{' + number + '}';
        });
    }
};

var EnvID = 0;
var EnvironmentName = "";
var CatID = 0;
var CatalogName = "";
var PipID = 0;
var PipelineName = "None";
var ShowErrorsMessage = true;

var ComponentID = "None";
var ContainerName = "None";
var StartCnt = 1;
var EndCnt = 1000;
var BatchCount = 1000;
var DBName = "testdb";

var ADAComponentID = PlayPower.getComponentID(true, CatalogName);
var INITComponentID = PlayPower.getComponentID(false, CatalogName);

var distinctTables = [];
var linkedContainersJSON = [
    {
        Name: "ColorCatalog",
        Linked: [
            { Name: "ColorCatalog", Priority: 1 },
            { Name: "GroundMaterials", Priority: 2 },
            { Name: "PaletteItems", Priority: 3 },
            { Name: "PostStyles", Priority: 4 },
            { Name: "ProductLines", Priority: 5 },
            { Name: "Risers", Priority: 6 },
            { Name: "SheetComponents", Priority: 7 },
            { Name: "InitAda", Priority: 8 },
            { Name: "LoadAda", Priority: 9 },
            { Name: "DeleteAda", Priority: 10 },
            { Name: "InitComponents", Priority: 11 },
            { Name: "LoadComponents", Priority: 12 },
            { Name: "DeleteComponents", Priority: 13 }
        ]
    },
    {
        Name: "GroudMaterials",
        Linked: [
            { Name: "ColorCatalog", Priority: 1 },
            { Name: "GroundMaterials", Priority: 2 },
            { Name: "PaletteItems", Priority: 3 },
            { Name: "PostStyles", Priority: 4 },
            { Name: "ProductLines", Priority: 5 },
            { Name: "Risers", Priority: 6 },
            { Name: "SheetComponents", Priority: 7 },
            { Name: "InitAda", Priority: 8 },
            { Name: "LoadAda", Priority: 9 },
            { Name: "DeleteAda", Priority: 10 },
            { Name: "InitComponents", Priority: 11 },
            { Name: "LoadComponents", Priority: 12 },
            { Name: "DeleteComponents", Priority: 13 }
        ]
    },
    {
        Name: "PaletteItems",
        Linked: [
            { Name: "ColorCatalog", Priority: 1 },
            { Name: "GroundMaterials", Priority: 2 },
            { Name: "PaletteItems", Priority: 3 },
            { Name: "PostStyles", Priority: 4 },
            { Name: "ProductLines", Priority: 5 },
            { Name: "Risers", Priority: 6 },
            { Name: "SheetComponents", Priority: 7 },
            { Name: "InitAda", Priority: 8 },
            { Name: "LoadAda", Priority: 9 },
            { Name: "DeleteAda", Priority: 10 },
            { Name: "InitComponents", Priority: 11 },
            { Name: "LoadComponents", Priority: 12 },
            { Name: "DeleteComponents", Priority: 13 }
        ]
    },
    {
        Name: "PostStyles",
        Linked: [
            { Name: "ColorCatalog", Priority: 1 },
            { Name: "GroundMaterials", Priority: 2 },
            { Name: "PaletteItems", Priority: 3 },
            { Name: "PostStyles", Priority: 4 },
            { Name: "ProductLines", Priority: 5 },
            { Name: "Risers", Priority: 6 },
            { Name: "SheetComponents", Priority: 7 },
            { Name: "InitAda", Priority: 8 },
            { Name: "LoadAda", Priority: 9 },
            { Name: "DeleteAda", Priority: 10 },
            { Name: "InitComponents", Priority: 11 },
            { Name: "LoadComponents", Priority: 12 },
            { Name: "DeleteComponents", Priority: 13 }
        ]
    },
    {
        Name: "ProductLines",
        Linked: [
            { Name: "ColorCatalog", Priority: 1 },
            { Name: "GroundMaterials", Priority: 2 },
            { Name: "PaletteItems", Priority: 3 },
            { Name: "PostStyles", Priority: 4 },
            { Name: "ProductLines", Priority: 5 },
            { Name: "Risers", Priority: 6 },
            { Name: "SheetComponents", Priority: 7 },
            { Name: "InitAda", Priority: 8 },
            { Name: "LoadAda", Priority: 9 },
            { Name: "DeleteAda", Priority: 10 },
            { Name: "InitComponents", Priority: 11 },
            { Name: "LoadComponents", Priority: 12 },
            { Name: "DeleteComponents", Priority: 13 }
        ]
    },
    {
        Name: "Risers",
        Linked: [
            { Name: "ColorCatalog", Priority: 1 },
            { Name: "GroundMaterials", Priority: 2 },
            { Name: "PaletteItems", Priority: 3 },
            { Name: "PostStyles", Priority: 4 },
            { Name: "ProductLines", Priority: 5 },
            { Name: "Risers", Priority: 6 },
            { Name: "SheetComponents", Priority: 7 },
            { Name: "InitAda", Priority: 8 },
            { Name: "LoadAda", Priority: 9 },
            { Name: "DeleteAda", Priority: 10 },
            { Name: "InitComponents", Priority: 11 },
            { Name: "LoadComponents", Priority: 12 },
            { Name: "DeleteComponents", Priority: 13 }
        ]
    },
    {
        Name: "SheetComponents",
        Linked: [
            { Name: "ColorCatalog", Priority: 1 },
            { Name: "GroundMaterials", Priority: 2 },
            { Name: "PaletteItems", Priority: 3 },
            { Name: "PostStyles", Priority: 4 },
            { Name: "ProductLines", Priority: 5 },
            { Name: "Risers", Priority: 6 },
            { Name: "SheetComponents", Priority: 7 },
            { Name: "InitAda", Priority: 8 },
            { Name: "LoadAda", Priority: 9 },
            { Name: "DeleteAda", Priority: 10 },
            { Name: "InitComponents", Priority: 11 },
            { Name: "LoadComponents", Priority: 12 },
            { Name: "DeleteComponents", Priority: 13 }
        ]
    },
    {
        Name: "InitAda",
        Linked: [
            { Name: "ColorCatalog", Priority: 1 },
            { Name: "GroundMaterials", Priority: 2 },
            { Name: "PaletteItems", Priority: 3 },
            { Name: "PostStyles", Priority: 4 },
            { Name: "ProductLines", Priority: 5 },
            { Name: "Risers", Priority: 6 },
            { Name: "SheetComponents", Priority: 7 },
            { Name: "InitAda", Priority: 8 },
            { Name: "LoadAda", Priority: 9 },
            { Name: "DeleteAda", Priority: 10 },
            { Name: "InitComponents", Priority: 11 },
            { Name: "LoadComponents", Priority: 12 },
            { Name: "DeleteComponents", Priority: 13 }
        ]
    },
    {
        Name: "LoadAda",
        Linked: [
            { Name: "ColorCatalog", Priority: 1 },
            { Name: "GroundMaterials", Priority: 2 },
            { Name: "PaletteItems", Priority: 3 },
            { Name: "PostStyles", Priority: 4 },
            { Name: "ProductLines", Priority: 5 },
            { Name: "Risers", Priority: 6 },
            { Name: "SheetComponents", Priority: 7 },
            { Name: "InitAda", Priority: 8 },
            { Name: "LoadAda", Priority: 9 },
            { Name: "DeleteAda", Priority: 10 },
            { Name: "InitComponents", Priority: 11 },
            { Name: "LoadComponents", Priority: 12 },
            { Name: "DeleteComponents", Priority: 13 }
        ]
    },
    {
        Name: "DeleteAda",
        Linked: [
            { Name: "ColorCatalog", Priority: 1 },
            { Name: "GroundMaterials", Priority: 2 },
            { Name: "PaletteItems", Priority: 3 },
            { Name: "PostStyles", Priority: 4 },
            { Name: "ProductLines", Priority: 5 },
            { Name: "Risers", Priority: 6 },
            { Name: "SheetComponents", Priority: 7 },
            { Name: "InitAda", Priority: 8 },
            { Name: "LoadAda", Priority: 9 },
            { Name: "DeleteAda", Priority: 10 },
            { Name: "InitComponents", Priority: 11 },
            { Name: "LoadComponents", Priority: 12 },
            { Name: "DeleteComponents", Priority: 13 }
        ]
    },
    {
        Name: "InitComponents",
        Linked: [
            { Name: "ColorCatalog", Priority: 1 },
            { Name: "GroundMaterials", Priority: 2 },
            { Name: "PaletteItems", Priority: 3 },
            { Name: "PostStyles", Priority: 4 },
            { Name: "ProductLines", Priority: 5 },
            { Name: "Risers", Priority: 6 },
            { Name: "SheetComponents", Priority: 7 },
            { Name: "InitAda", Priority: 8 },
            { Name: "LoadAda", Priority: 9 },
            { Name: "DeleteAda", Priority: 10 },
            { Name: "InitComponents", Priority: 11 },
            { Name: "LoadComponents", Priority: 12 },
            { Name: "DeleteComponents", Priority: 13 }
        ]
    },
    {
        Name: "LoadComponents",
        Linked: [
            { Name: "ColorCatalog", Priority: 1 },
            { Name: "GroundMaterials", Priority: 2 },
            { Name: "PaletteItems", Priority: 3 },
            { Name: "PostStyles", Priority: 4 },
            { Name: "ProductLines", Priority: 5 },
            { Name: "Risers", Priority: 6 },
            { Name: "SheetComponents", Priority: 7 },
            { Name: "InitAda", Priority: 8 },
            { Name: "LoadAda", Priority: 9 },
            { Name: "DeleteAda", Priority: 10 },
            { Name: "InitComponents", Priority: 11 },
            { Name: "LoadComponents", Priority: 12 },
            { Name: "DeleteComponents", Priority: 13 }
        ]
    },
    {
        Name: "DeleteComponents",
        Linked: [
            { Name: "ColorCatalog", Priority: 1 },
            { Name: "GroundMaterials", Priority: 2 },
            { Name: "PaletteItems", Priority: 3 },
            { Name: "PostStyles", Priority: 4 },
            { Name: "ProductLines", Priority: 5 },
            { Name: "Risers", Priority: 6 },
            { Name: "SheetComponents", Priority: 7 },
            { Name: "InitAda", Priority: 8 },
            { Name: "LoadAda", Priority: 9 },
            { Name: "DeleteAda", Priority: 10 },
            { Name: "InitComponents", Priority: 11 },
            { Name: "LoadComponents", Priority: 12 },
            { Name: "DeleteComponents", Priority: 13 }
        ]
    }
];
var CosmosArray = [
    {
        Name: "Rankings",
        Comments: "LOAD: Rankings",
        StoreProcedureName: 'dbo.sp_GetRankingsJson',
        Parameters: [
            { Name: "@CatalogName", Value: CatalogName }
        ],
        UniqueKey: ["CatalogName", "Type"],
        Environment: EnvID,
        RemoveDuplicates: true,
        InitializeCatalog: false,
        Database: DBName,
        CollectionName: "Rankings",
        PartitionKey: "/CatalogName"
    },
    {
        Name: "Families",
        Comments: "LOAD: Families",
        StoreProcedureName: 'dbo.sp_GetCatalogFamiliesJson',
        Parameters: [
            { Name: "@CatalogName", Value: CatalogName }
        ],
        UniqueKey: ["CatalogName"],
        Environment: EnvID,
        RemoveDuplicates: true,
        InitializeCatalog: false,
        Database: DBName,
        CollectionName: "Families",
        PartitionKey: "/CatalogName"
    },
    {
        Name: "MountingTypes",
        Comments: "LOAD: Mounting Types",
        StoreProcedureName: 'dbo.sp_GetMountingTypesJson',
        Parameters: [
            { Name: "@CatalogName", Value: CatalogName }
        ],
        UniqueKey: ["CatalogName"],
        Environment: EnvID,
        RemoveDuplicates: true,
        InitializeCatalog: false,
        Database: DBName,
        CollectionName: "MountingTypes",
        PartitionKey: "/CatalogName"
    },
    {
        Name: "Risers",
        Comments: "LOAD: Risers",
        StoreProcedureName: 'dbo.sp_GetRisersJson',
        Parameters: [
            { Name: "@CatalogName", Value: CatalogName },
            { Name: "@EnvironmentID", Value: EnvID }
        ],
        UniqueKey: ["CatalogName", "ProductLine"],
        Environment: EnvID,
        RemoveDuplicates: true,
        InitializeCatalog: false,
        Database: DBName,
        CollectionName: "Risers",
        PartitionKey: "/ProductLine"
    },
    {
        Name: "ProductLines",
        Comments: "LOAD: Product Lines",
        StoreProcedureName: 'dbo.sp_GetProductLinesJson',
        Parameters: [
            { Name: "@CatalogName", Value: CatalogName },
            { Name: "@EnvironmentID", Value: EnvID },
            { Name: "@ProductLine", Value: null },
            { Name: "@GroupName", Value: null }
        ],
        UniqueKey: ["CatalogName"],
        Environment: EnvID,
        RemoveDuplicates: true,
        InitializeCatalog: false,
        Database: DBName,
        CollectionName: "ProductLines",
        PartitionKey: "/CatalogName"
    },
    {
        Name: "GuideLines",
        Comments: "LOAD: Guide Lines",
        StoreProcedureName: 'dbo.sp_GetGuideLinesJson',
        Parameters: [
            { Name: "@CatalogName", Value: CatalogName },
            { Name: "@GuideLine", Value: null },
            { Name: "@Country", Value: null }
        ],
        UniqueKey: ["Name", "CatalogName"],
        Environment: EnvID,
        RemoveDuplicates: true,
        InitializeCatalog: false,
        Database: DBName,
        CollectionName: "GuideLines",
        PartitionKey: "/Name"
    },
    {
        Name: "AgeRanges",
        Comments: "LOAD: AgeRanges",
        StoreProcedureName: 'dbo.sp_GetAgeRangesJson',
        Parameters: [
            { Name: "@CatalogName", Value: CatalogName },
            { Name: "@GuideLine", Value: null },
            { Name: "@ID", Value: null }
        ],
        UniqueKey: ["CatalogName"],
        Environment: EnvID,
        RemoveDuplicates: true,
        InitializeCatalog: false,
        Database: DBName,
        CollectionName: "AgeRanges",
        PartitionKey: "/GuideLine"
    },
    // {
    //     Name: "CatalogSpecifications",
    //     Comments: "LOAD: Catalog Specifications",
    //     StoreProcedureName: 'dbo.sp_GetCatalogSpecificationJson',
    //     Parameters: [
    //         { Name: "@CatalogName", Value: CatalogName }
    //     ],
    //     UniqueKey: ["CatalogName"],
    //     Environment: EnvID,
    //     RemoveDuplicates: true,
    //     InitializeCatalog: false,
    //     Database: DBName,
    //     CollectionName: "CatalogSpecs",
    //     PartitionKey: "/CatalogName"
    // },
    {
        Name: "GroundMaterials",
        Comments: "LOAD: Ground Materials",
        StoreProcedureName: 'dbo.sp_GetGroundMaterialsJson',
        Parameters: [
            { Name: "@CatalogName", Value: CatalogName },
            { Name: "@EnvironmentID", Value: EnvID }
        ],
        UniqueKey: ["CatalogName"],
        Environment: EnvID,
        RemoveDuplicates: true,
        InitializeCatalog: false,
        Database: DBName,
        CollectionName: "GroundMaterials",
        PartitionKey: "/CatalogName"
    },
    {
        Name: "LabelStyles",
        Comments: "LOAD: Label Styles",
        StoreProcedureName: 'dbo.sp_GetCatalogLabelStylesJson',
        Parameters: [
            { Name: "@CatalogName", Value: CatalogName }
        ],
        UniqueKey: ["CatalogName"],
        Environment: EnvID,
        RemoveDuplicates: true,
        InitializeCatalog: false,
        Database: DBName,
        CollectionName: "LabelStyles",
        PartitionKey: "/CatalogName"
    },
    {
        Name: "Layers",
        Comments: "LOAD: Layers",
        StoreProcedureName: 'dbo.sp_GetCatalogLayersJson',
        Parameters: [
            { Name: "@CatalogName", Value: CatalogName }
        ],
        UniqueKey: ["CatalogName"],
        Environment: EnvID,
        RemoveDuplicates: true,
        InitializeCatalog: false,
        Database: DBName,
        CollectionName: "Layers",
        PartitionKey: "/CatalogName"
    },
    {
        Name: "LineType",
        Comments: "LOAD: Line Type",
        StoreProcedureName: 'dbo.sp_GetCatalogLinetypeThicknessScalarsJson',
        Parameters: [
            { Name: "@CatalogName", Value: CatalogName }
        ],
        UniqueKey: ["CatalogName"],
        Environment: EnvID,
        RemoveDuplicates: true,
        InitializeCatalog: false,
        Database: DBName,
        CollectionName: "LineType",
        PartitionKey: "/CatalogName"
    },
    {
        Name: "Monetary",
        Comments: "LOAD: Monetary",
        StoreProcedureName: 'dbo.sp_GetMonetaryJson',
        Parameters: [
            { Name: "@CatalogName", Value: CatalogName }
        ],
        UniqueKey: ["CatalogName"],
        Environment: EnvID,
        RemoveDuplicates: true,
        InitializeCatalog: false,
        Database: DBName,
        CollectionName: "Monetary",
        PartitionKey: "/CatalogName"
    },
    {
        Name: "Substitution",
        Comments: "LOAD: Substitution",
        StoreProcedureName: 'dbo.sp_SubstituteJson',
        Parameters: [
            { Name: "@CatalogName", Value: CatalogName }
        ],
        UniqueKey: ["CatalogName"],
        Environment: EnvID,
        RemoveDuplicates: true,
        InitializeCatalog: false,
        Database: DBName,
        CollectionName: "Substitute",
        PartitionKey: "/CatalogName"
    },
    {
        Name: "OutputActions",
        Comments: "LOAD: Output Actions",
        StoreProcedureName: 'dbo.sp_GetCatalogOutputActionsJson',
        Parameters: [
            { Name: "@CatalogName", Value: CatalogName }
        ],
        UniqueKey: ["CatalogName"],
        Environment: EnvID,
        RemoveDuplicates: true,
        InitializeCatalog: false,
        Database: DBName,
        CollectionName: "OutputActions",
        PartitionKey: "/CatalogName"
    },
    {
        Name: "OutputTabs",
        Comments: "LOAD: Output Tabs",
        StoreProcedureName: 'dbo.sp_GetCatalogOutputTabsJson',
        Parameters: [
            { Name: "@CatalogName", Value: CatalogName }
        ],
        UniqueKey: ["CatalogName"],
        Environment: EnvID,
        RemoveDuplicates: true,
        InitializeCatalog: false,
        Database: DBName,
        CollectionName: "OutputTabs",
        PartitionKey: "/CatalogName"
    },
    {
        Name: "PortLayerConfig",
        Comments: "LOAD: Port Layer Config",
        StoreProcedureName: 'dbo.sp_GetCatalogViewPortLayerConfigsJson',
        Parameters: [
            { Name: "@CatalogName", Value: CatalogName }
        ],
        UniqueKey: ["CatalogName"],
        Environment: EnvID,
        RemoveDuplicates: true,
        InitializeCatalog: false,
        Database: DBName,
        CollectionName: "PortLayerConfig",
        PartitionKey: "/CatalogName"
    },
    {
        Name: "Scales",
        Comments: "LOAD: Scales",
        StoreProcedureName: 'dbo.sp_GetCatalogDrawingScalesJson',
        Parameters: [
            { Name: "@CatalogName", Value: CatalogName }
        ],
        UniqueKey: ["CatalogName"],
        Environment: EnvID,
        RemoveDuplicates: true,
        InitializeCatalog: false,
        Database: DBName,
        CollectionName: "Scales",
        PartitionKey: "/CatalogName"
    },
    {
        Name: "SheetComponents",
        Comments: "LOAD: Sheet Components",
        StoreProcedureName: 'dbo.sp_GetSheetComponentsJson',
        Parameters: [
            { Name: "@CatalogName", Value: CatalogName },
            { Name: "@EnvironmentID", Value: EnvID }
        ],
        UniqueKey: ["CatalogName"],
        Environment: EnvID,
        RemoveDuplicates: true,
        InitializeCatalog: false,
        Database: DBName,
        CollectionName: "SheetComponents",
        PartitionKey: "/CatalogName"
    },
    {
        Name: "DrawingSheets",
        Comments: "LOAD: Drawing Sheets",
        StoreProcedureName: 'dbo.sp_GetDrawingSheetsJson',
        Parameters: [
            { Name: "@CatalogName", Value: CatalogName }
        ],
        UniqueKey: ["CatalogName"],
        Environment: EnvID,
        RemoveDuplicates: true,
        InitializeCatalog: false,
        Database: DBName,
        CollectionName: "Sheets",
        PartitionKey: "/CatalogName"
    },
    {
        Name: "Views",
        Comments: "LOAD: Views",
        StoreProcedureName: 'dbo.sp_GetViewsJson',
        Parameters: [
            { Name: "@CatalogName", Value: CatalogName }
        ],
        UniqueKey: ["CatalogName"],
        Environment: EnvID,
        RemoveDuplicates: true,
        InitializeCatalog: false,
        Database: DBName,
        CollectionName: "Views",
        PartitionKey: "/CatalogName"
    },
    {
        Name: "PaletteItems",
        Comments: "LOAD: Palette Items",
        StoreProcedureName: 'dbo.sp_GetPaletteItemsJson',
        Parameters: [
            { Name: "@CatalogName", Value: CatalogName },
            { Name: "@EnvironmentID", Value: EnvID },
            { Name: "@StartCount", Value: null },
            { Name: "@EndCount", Value: null }
        ],
        UniqueKey: ["CatalogName"],
        Environment: EnvID,
        RemoveDuplicates: true,
        InitializeCatalog: false,
        Database: DBName,
        CollectionName: "PaletteItems",
        PartitionKey: "/ProductLine"
    },
    {
        Name: "ColorCatalog",
        Comments: "LOAD: Color Catalog",
        StoreProcedureName: 'dbo.sp_GetColorCatalogJson',
        Parameters: [
            { Name: "@CatalogName", Value: CatalogName },
            { Name: "@EnvironmentID", Value: EnvID }
        ],
        UniqueKey: ["CatalogName"],
        Environment: EnvID,
        RemoveDuplicates: true,
        InitializeCatalog: false,
        Database: DBName,
        CollectionName: "ColorCatalog",
        PartitionKey: "/CatalogName"
    },
    {
        Name: "PostStyles",
        Comments: "LOAD: Post Styles",
        StoreProcedureName: 'dbo.sp_GetPostStylesJson',
        Parameters: [
            { Name: "@CatalogName", Value: CatalogName },
            { Name: "@EnvironmentID", Value: EnvID }
        ],
        UniqueKey: ["CatalogName"],
        Environment: EnvID,
        RemoveDuplicates: true,
        InitializeCatalog: false,
        Database: DBName,
        CollectionName: "PostStyles",
        PartitionKey: "/CatalogName"
    },
    {
        Name: "InitAda",
        Comments: "LOAD: Initialize ADA vomponents false",
        StoreProcedureName: 'dbo.sp_GetADAJson',
        Parameters: [
            { Name: "@CatalogName", Value: CatalogName },
            { Name: "@EnvironmentID", Value: EnvID },
            { Name: "@ComponentID", Value: ComponentID }
        ],
        UniqueKey: ["CatalogName"],
        Environment: EnvID,
        RemoveDuplicates: true,
        InitializeCatalog: false,
        Database: DBName,
        CollectionName: "ComponentAda",
        PartitionKey: "/CatalogName"
    },
    {
        Name: "LoadAda",
        Comments: "LOAD: All ADA components",
        StoreProcedureName: 'dbo.sp_GetADAJson',
        Parameters: [
            { Name: "@CatalogName", Value: CatalogName },
            { Name: "@EnvironmentID", Value: EnvID }
        ],
        UniqueKey: ["CatalogName"],
        Environment: EnvID,
        RemoveDuplicates: true,
        InitializeCatalog: false,
        Database: DBName,
        CollectionName: "ComponentAda",
        PartitionKey: "/CatalogName"
    },
    {
        Name: "DeleteAda",
        Comments: "LOAD: Delete duplicate ADA component false",
        StoreProcedureName: 'dbo.sp_GetADAJson',
        Parameters: [
            { Name: "@CatalogName", Value: CatalogName },
            { Name: "@EnvironmentID", Value: EnvID },
            { Name: "@ComponentID", Value: ComponentID }
        ],
        UniqueKey: ["CatalogName", "ComponentID"],
        Environment: EnvID,
        RemoveDuplicates: true,
        InitializeCatalog: false,
        Database: DBName,
        CollectionName: "ComponentAda",
        PartitionKey: "/CatalogName"
    },
    {
        Name: "InitComponents",
        Comments: "LOAD: Initialize Components false",
        StoreProcedureName: 'dbo.sp_GetComponentRangeJson',
        Parameters: [
            { Name: "@CatalogName", Value: CatalogName },
            { Name: "@EnvironmentID", Value: EnvID },
            { Name: "@StartCnt", Value: 1 },
            { Name: "@EndCnt", Value: 1 },
            { Name: "@ComponentID", Value: ComponentID },
            { Name: "@Json", Value: null },
        ],
        UniqueKey: ["CatalogName"],
        Environment: EnvID,
        RemoveDuplicates: true,
        InitializeCatalog: false,
        Database: DBName,
        CollectionName: "Components",
        PartitionKey: "/CatalogName"
    },
    {
        Name: "LoadComponents",
        Comments: "LOAD: All Components",
        StoreProcedureName: 'dbo.sp_GetComponentRangeJson',
        Parameters: [
            { Name: "@CatalogName", Value: CatalogName },
            { Name: "@EnvironmentID", Value: EnvID },
            { Name: "@StartCnt", Value: StartCnt },
            { Name: "@EndCnt", Value: EndCnt }
        ],
        UniqueKey: ["CatalogName", "ComponentID"],
        Environment: EnvID,
        RemoveDuplicates: true,
        InitializeCatalog: false,
        Database: DBName,
        CollectionName: "Components",
        PartitionKey: "/CatalogName"
    },
    {
        Name: "DeleteComponents",
        Comments: "LOAD: Delete duplicate components false",
        StoreProcedureName: 'dbo.sp_GetComponentRangeJson',
        Parameters: [
            { Name: "@CatalogName", Value: CatalogName },
            { Name: "@EnvironmentID", Value: EnvID },
            { Name: "@StartCnt", Value: 1 },
            { Name: "@EndCnt", Value: 1 },
            { Name: "@ComponentID", Value: ComponentID },
            { Name: "@Json", Value: null },
        ],
        UniqueKey: ["CatalogName", "ComponentID"],
        Environment: EnvID,
        RemoveDuplicates: true,
        InitializeCatalog: false,
        Database: DBName,
        CollectionName: "Components",
        PartitionKey: "/CatalogName"
    }
];
var TableArray = [
    {
        Table: "ADAComponentdata",
        Procedures: [
            "sp_GetADAJson",
            "sp_GetComponentRangeJson"
        ]
    },
    {
        Table: "ADAPrebuiltData",
        Procedures: [
            "sp_GetADAJson",
            "sp_GetComponentRangeJson"
        ]
    },
    {
        Table: "BlockMaster",
        Procedures: [
            "sp_GetADAJson",
            "sp_GetCatalogAssyConfigJson",
            "sp_GetComponentRangeJson",
            "sp_GetPaletteItemsJson",
            "sp_GetPostStylesJson",
            "sp_GetProductLinesJson",
            "sp_GetRisersJson",
            "sp_SubstituteJson"
        ]
    },
    {
        Table: "ItemMaster",
        Procedures: [
            "sp_GetADAJson",
            "sp_GetComponentRangeJson",
            "sp_GetPaletteItemsJson",
            "sp_GetPostStylesJson",
            "sp_GetRisersJson",
            "sp_SubstituteJson"
        ]
    },
    {
        Table: "RibbonMaster",
        Procedures: [
            "sp_GetComponentRangeJson",
            "sp_GetPaletteItemsJson",
            "sp_GetProductLinesJson"
        ]
    },
    {
        Table: "Spec",
        Procedures: [
            "sp_GetCatalogSpecificationJson"
        ]
    },
    {
        Table: "tbl3Dviews",
        Procedures: [
            "sp_GetViewsJson"
        ]
    },
    {
        Table: "tblAgeGroup",
        Procedures: [
            "sp_GetComponentRangeJson",
            "sp_GetPaletteItemsJson",
            "sp_GetRisersJson"
        ]
    },
    {
        Table: "tblAges",
        Procedures: [
            "sp_GetAgeRangesJson",
            "sp_GetGuideLinesJson"
        ]
    },
    {
        Table: "tblAssemblies",
        Procedures: [
            "sp_GetCatalogAssyConfigJson"
        ]
    },
    {
        Table: "tblAssemblyChildChars",
        Procedures: [
            "sp_GetCatalogAssyConfigJson"
        ]
    },
    {
        Table: "tblAssociatedComps",
        Procedures: [
            "sp_GetComponentRangeJson"
        ]
    },
    {
        Table: "tblChildren",
        Procedures: [
            "sp_GetComponentRangeJson"
        ]
    },
    {
        Table: "tblColorData",
        Procedures: [
            "sp_GetColorCatalogJson"
        ]
    },
    {
        Table: "tblColorList",
        Procedures: [
            "sp_GetColorCatalogJson"
        ]
    },
    {
        Table: "tblCountry",
        Procedures: [
            "sp_GetCountriesJson"
        ]
    },
    {
        Table: "tblCoupledComps",
        Procedures: [
            "sp_GetComponentRangeJson"
        ]
    },
    {
        Table: "tblCurrency",
        Procedures: [
            "sp_GetMonetaryJson"
        ]
    },
    {
        Table: "tblDrawingScales",
        Procedures: [
            "sp_GetCatalogDrawingScalesJson"
        ]
    },
    {
        Table: "tblDrawingSheetData",
        Procedures: [
            "sp_GetSheetComponentsJson"
        ]
    },
    {
        Table: "tblDrawingSheetElements",
        Procedures: [
            "sp_GetDrawingSheetsJson"
        ]
    },
    {
        Table: "tblDrawingSheetRules",
        Procedures: [
            "sp_GetDrawingSheetsJson"
        ]
    },
    {
        Table: "tblDrawingSheets",
        Procedures: [
            "sp_GetDrawingSheetsJson"
        ]
    },
    {
        Table: "tblDrawingSheetSymbols",
        Procedures: [
            "sp_GetDrawingSheetsJson"
        ]
    },
    {
        Table: "tblDrawingSheetViewports",
        Procedures: [
            "sp_GetDrawingSheetsJson"
        ]
    },
    {
        Table: "tblFamily",
        Procedures: [
            "sp_GetCatalogFamiliesJson"
        ]
    },
    {
        Table: "tblFamilySnapsTo",
        Procedures: [
            "sp_GetComponentRangeJson"
        ]
    },
    {
        Table: "tblGroundMaterials",
        Procedures: [
            "sp_GetGroundMaterialsJson"
        ]
    },
    {
        Table: "tblGuideLine",
        Procedures: [
            "sp_GetCountriesJson",
            "sp_GetGuideLinesJson"
        ]
    },
    {
        Table: "tblKidos",
        Procedures: [
            "sp_GetComponentRangeJson"
        ]
    },
    {
        Table: "tblLabelStyles",
        Procedures: [
            "sp_GetCatalogLabelStylesJson"
        ]
    },
    {
        Table: "tblLookupNames",
        Procedures: [
            "sp_GetComponentRangeJson"
        ]
    },
    {
        Table: "tblLtThicknessScalars",
        Procedures: [
            "sp_GetCatalogLinetypeThicknessScalarsJson"
        ]
    },
    {
        Table: "tblMatePointRules",
        Procedures: [
            "sp_GetComponentRangeJson",
            "sp_GetPostStylesJson",
            "sp_GetRisersJson"
        ]
    },
    {
        Table: "tblMatePoints",
        Procedures: [
            "sp_GetComponentRangeJson"
        ]
    },
    {
        Table: "tblMatingRules",
        Procedures: [
            "sp_GetComponentRangeJson",
            "sp_GetPostStylesJson",
            "sp_GetRisersJson"
        ]
    },
    {
        Table: "tblMountingTypes",
        Procedures: [
            "sp_GetMountingTypesJson"
        ]
    },
    {
        Table: "tblOutputTabItems",
        Procedures: [
            "sp_GetCatalogOutputTabsJson"
        ]
    },
    {
        Table: "tblOutputTabs",
        Procedures: [
            "sp_GetCatalogOutputActionsJson",
            "sp_GetCatalogOutputTabsJson"
        ]
    },
    {
        Table: "tblPostGroups",
        Procedures: [
            "sp_GetCatalogPostGroupRankingsJson",
            "sp_GetRankingsJson"
        ]
    },
    {
        Table: "tblPostLocations",
        Procedures: [
            "sp_GetComponentRangeJson",
            "sp_GetRisersJson"
        ]
    },
    {
        Table: "tblPostMaterials",
        Procedures: [
            "sp_GetCatalogPostMaterialRankingsJson",
            "sp_GetRankingsJson"
        ]
    },
    {
        Table: "tblPostPointRules",
        Procedures: [
            "sp_GetComponentRangeJson"
        ]
    },
    {
        Table: "tblPostRules",
        Procedures: [
            "sp_GetComponentRangeJson"
        ]
    },
    {
        Table: "tblPostsBaseData",
        Procedures: [
            "sp_GetPostStylesJson"
        ]
    },
    {
        Table: "tblPostStyles",
        Procedures: [
            "sp_GetPostStylesJson"
        ]
    },
    {
        Table: "tblPostTypes",
        Procedures: [
            "sp_GetCatalogPostTypeRankingsJson",
            "sp_GetRankingsJson"
        ]
    },
    {
        Table: "tblRibbonGroups",
        Procedures: [
            "sp_GetProductLinesJson"
        ]
    },
    {
        Table: "tblRibbonTabs",
        Procedures: [
            "sp_GetPostStylesJson",
            "sp_GetProductLinesJson",
            "sp_GetRisersJson"
        ]
    },
    {
        Table: "tblRiserKickPlate",
        Procedures: [
            "sp_GetRisersJson"
        ]
    },
    {
        Table: "tblSmartLayers",
        Procedures: [
            "sp_GetCatalogLayersJson"
        ]
    },
    {
        Table: "tblStates",
        Procedures: [
            "sp_GetCountriesJson"
        ]
    },
    {
        Table: "tblSubstitution",
        Procedures: [
            "sp_GetComponentRangeJson",
            "sp_SubstituteJson"
        ]
    },
    {
        Table: "tblThemeElements",
        Procedures: [
            "sp_GetColorCatalogJson"
        ]
    },
    {
        Table: "tblViewportLayers",
        Procedures: [
            "sp_GetCatalogViewPortLayerConfigsJson"
        ]
    }
];
var ProcedureArray = [
    {
        Procedure: "sp_GetADAJson",
        Tables: [
            "ADAComponentdata",
            "ADAPrebuiltData",
            "BlockMaster",
            "ItemMaster"
        ]
    },
    {
        Procedure: "sp_GetAgeRangesJson",
        Tables: [
            "tblAges"
        ]
    },
    {
        Procedure: "sp_GetCatalogAssyConfigJson",
        Tables: [
            "BlockMaster",
            "tblAssemblies",
            "tblAssemblyChildChars"
        ]
    },
    {
        Procedure: "sp_GetCatalogDrawingScalesJson",
        Tables: [
            "tblDrawingScales"
        ]
    },
    {
        Procedure: "sp_GetCatalogFamiliesJson",
        Tables: [
            "tblFamily"
        ]
    },
    {
        Procedure: "sp_GetCatalogLabelStylesJson",
        Tables: [
            "tblLabelStyles"
        ]
    },
    {
        Procedure: "sp_GetCatalogLayersJson",
        Tables: [
            "tblSmartLayers"
        ]
    },
    {
        Procedure: "sp_GetCatalogLinetypeThicknessScalarsJson",
        Tables: [
            "tblLtThicknessScalars"
        ]
    },
    {
        Procedure: "sp_GetCatalogOutputActionsJson",
        Tables: [
            "tblOutputTabs"
        ]
    },
    {
        Procedure: "sp_GetCatalogOutputTabsJson",
        Tables: [
            "tblOutputTabItems",
            "tblOutputTabs"
        ]
    },
    {
        Procedure: "sp_GetCatalogPostGroupRankingsJson",
        Tables: [
            "tblPostGroups"
        ]
    },
    {
        Procedure: "sp_GetCatalogPostMaterialRankingsJson",
        Tables: [
            "tblPostMaterials"
        ]
    },
    {
        Procedure: "sp_GetCatalogPostTypeRankingsJson",
        Tables: [
            "tblPostTypes"
        ]
    },
    {
        Procedure: "sp_GetCatalogSpecificationJson",
        Tables: [
            "Spec"
        ]
    },
    {
        Procedure: "sp_GetCatalogViewPortLayerConfigsJson",
        Tables: [
            "tblViewportLayers"
        ]
    },
    {
        Procedure: "sp_GetColorCatalogJson",
        Tables: [
             "tblColorData",
            "tblColorList",
            "tblThemeElements"
        ]
    },
    {
        Procedure: "sp_GetComponentRangeJson",
        Tables: [
            "ADAComponentdata",
            "ADAPrebuiltData",
            "BlockMaster",
            "ItemMaster",
            "RibbonMaster",
            "tblAgeGroup",
            "tblAssociatedComps",
            "tblChildren",
            "tblCoupledComps",
            "tblFamilySnapsTo",
            "tblKidos",
            "tblLookupNames",
            "tblMatePointRules",
            "tblMatePoints",
            "tblMatingRules",
            "tblPostLocations",
            "tblPostPointRules",
            "tblPostRules",
            "tblSubstitution"
        ]
    },
    {
        Procedure: "sp_GetCountriesJson",
        Tables: [
            "tblCountry",
            "tblGuideLine",
            "tblStates"
        ]
    },
    {
        Procedure: "sp_GetDrawingSheetsJson",
        Tables: [
            "tblDrawingSheetElements",
            "tblDrawingSheetRules",
            "tblDrawingSheets",
            "tblDrawingSheetSymbols",
            "tblDrawingSheetViewports"
        ]
    },
    {
        Procedure: "sp_GetGroundMaterialsJson",
        Tables: [
            "tblGroundMaterials"
        ]
    },
    {
        Procedure: "sp_GetGuideLinesJson",
        Tables: [
            "tblAges",
            "tblGuideLine"
        ]
    },
    {
        Procedure: "sp_GetMonetaryJson",
        Tables: [
            "tblCurrency"
        ]
    },
    {
        Procedure: "sp_GetMountingTypesJson",
        Tables: [
            "tblMountingTypes"
        ]
    },
    {
        Procedure: "sp_GetPaletteItemsJson",
        Tables: [
            "BlockMaster",
            "ItemMaster",
            "RibbonMaster",
            "tblAgeGroup"
        ]
    },
    {
        Procedure: "sp_GetPostStylesJson",
        Tables: [
            "BlockMaster",
            "ItemMaster",
            "tblMatePointRules",
            "tblMatingRules",
            "tblPostsBaseData",
            "tblPostStyles",
            "tblRibbonTabs"
        ]
    },
    {
        Procedure: "sp_GetProductLinesJson",
        Tables: [
            "BlockMaster",
            "RibbonMaster",
            "tblRibbonGroups",
            "tblRibbonTabs"
        ]
    },
    {
        Procedure: "sp_GetRankingsJson",
        Tables: [
            "tblPostGroups",
            "tblPostMaterials",
            "tblPostTypes"
        ]
    },
    {
        Procedure: "sp_GetRisersJson",
        Tables: [
            "BlockMaster",
            "ItemMaster",
            "tblAgeGroup",
            "tblMatePointRules",
            "tblMatingRules",
            "tblPostLocations",
            "tblRibbonTabs",
            "tblRiserKickPlate"
        ]
    },
    {
        Procedure: "sp_GetSheetComponentsJson",
        Tables: [
            "tblDrawingSheetData"
        ]
    },
    {
        Procedure: "sp_GetViewsJson",
        Tables: [
            "tbl3Dviews"
        ]
    },
    {
        Procedure: "sp_SubstituteJson",
        Tables: [
            "BlockMaster",
            "ItemMaster",
            "tblSubstitution"
        ]
    }
]