class XLSXInsert {
        [Array]$InfoInserts
        [Array]$vCPUInserts
        [Array]$MemInserts
        [Array]$DiskInserts
        [Array]$PartitionInserts
        [Array]$NetworkInserts
        [Array]$SnapShotInserts
        [Array]$VMWareToolsInserts
        [Array]$ClusterInserts
        [Array]$ResourcePoolInserts
        [Array]$HostInserts
        [Array]$HBAInserts
        [Array]$NICInserts
        [Array]$DataStoreInserts

    # Constructor (Client Only)

    XLSXInsert () {
        [Array]$this.InfoInserts = @()
    }

    # Method: Create General Information Inserts
    [void] createInfoInserts () {
        Try{
            $DeleteStatement = "Delete from [dbo].[VMGeneralInfo] where name = 'SOMETHING_SOMETHING';`r`n"
            $InsertHeader = "INSERT INTO [dbo].[VMGeneralInfo] VALUES`r`n"
            $GenericInsert = "('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}','{14}','{15}','{16}','{17}','{18}','{19}','{20}','{21}','{22}','{23}');"
            $GenericInsert = $GenericInsert -replace "''","NULL"
            $CompleteInsert = $DeleteStatement + $InsertHeader + $GenericInsert
            $this.InfoInserts += @($CompleteInsert)
        }
        Catch [System.Exception] {
            Write-Error $_.Exception.Message
        }

    }
}

$inserts = [XLSXInsert]::new();
$inserts.createInfoInserts();
$inserts.InfoInserts