Public/New-SPSAeriesDistrictAssetAssociation.ps1
|
# May want to reconsider how New-SPSAeriesDistrictAssetAssociation and Update-SPSAeriesDistrictAssetAssociation operate. # One option would be to get rid of New- and run everything out of update and have -checkin and -checkout parameters # Another option would be to make aliases the run those functions ex. CheckIn-AeriesDistrictAsset & CheckOut-AeriesDistrictAsset Function New-SPSAeriesDistrictAssetAssociation { <# .SYNOPSIS Create new District Asset Association in Aeries .DESCRIPTION The New-SPSAeriesDistrictAssetAssociation function uses SQL to create a new District Asset Association in the Aeries DB. .EXAMPLE New-SPSAeriesDistrictAssetAssociation .PARAMETER .INPUTS .OUTPUTS .NOTES .LINK #> [CmdletBinding()] #Enable all the default paramters, including -Verbose Param( [Parameter(Mandatory=$true, ValueFromPipeline=$false, ValueFromPipelineByPropertyName=$true, # HelpMessage='HelpMessage', Position=0)] [Alias("RID")] [int]$AssetTitleNumber, [Parameter(Mandatory=$true, ValueFromPipeline=$false, ValueFromPipelineByPropertyName=$true, # HelpMessage='HelpMessage', Position=1)] [Alias("RIN")] [int]$AssetItemNumber, [Parameter(Mandatory=$true)] [Alias("ID")] [int]$UserID, [Parameter(Mandatory=$true)] [ValidatePattern('[S,T]')] [ValidateLength(0,1)] [Alias("ST")] [string]$UserType, [Alias("CO")] [String]$Comment, [Parameter(Mandatory=$false)] [Alias("SCL")] [int]$School, [Alias("DT")] [datetime]$DateIssued ) Begin{ Write-Verbose -Message "Starting $($MyInvocation.InvocationName) with $($PsCmdlet.ParameterSetName) parameterset..." Write-Verbose -Message "Parameters are $($PSBoundParameters | Select-Object -Property *)" Connect-AeriesSQLDB } Process{ if (!$school) { $school = (Get-SPSAeriesDistrictAssetItem -AssetTitleNumber $AssetTitleNumber -AssetItemNumber $AssetItemNumber).School } # Check if it has any associations yet. $SQ = $null $recentAssociation = Get-SPSAeriesDistrictAssetAssociation -AssetTitleNumber $AssetTitleNumber -AssetItemNumber $AssetItemNumber write-verbose "recent association: $($recentAssociation)" if ([string]::IsNullOrEmpty($recentAssociation)) { $SQ = 1; } else { # Get next SQ number $SQ = ($recentAssociation.'SQ' | Select-Object -Last 1) + 1; # Don't allow new association if it's still checked out. $CheckInDate = $recentAssociation.DateReturned | Select-Object -Last 1 if ([string]::IsNullOrEmpty($CheckInDate)) { write-Error "Cannot create new association - Asset is currently checked out. Please check the asset in before creating a new asset association." return; } } Write-Verbose "SQ = $SQ" $Data = [pscustomobject]@{ RID= $AssetTitleNumber RIN= $AssetItemNumber SQ= $SQ ID= $UserID ST= $UserType PD= 0 # Not used RM= '' # Not used CN= '' # Not used SE= 0 # Not used CC= '' # Not currently used. Populated blank. (According to Aeries Documentation) CD= '' # Not currently used. Populated blank. (According to Aeries Documentation) CO= '' # Comment SCL= $School DT= Get-Date -Format 'yyyy-MM-dd HH:mm:ss.fff' RD= $null DD= $null # Not currently used. Populated blank. (According to Aeries Documentation) TG= '' # Not used DEL= 0 # 1 is "deleted" and will no longer show in Aeries Web, but will stay in DB for historical purposes DTS= Get-Date -Format 'yyyy-MM-dd HH:mm:ss.fff' } if ($Comment) {$Data.CO = $Comment} if ($DateIssued) {$Data.DT = $DateIssued} Write-Verbose $Data Write-SqlTableData @SQLSplat -TableName 'DRA' -InputData $Data # Update the Asset Item Status Update-SPSAeriesDistrictAssetItem -AssetTitleNumber $AssetTitleNumber -AssetItemNumber $AssetItemNumber -NewStatus $Data.ST } End{ $Script:SQLConnection.Close() Write-Verbose -Message "Ending $($MyInvocation.InvocationName)..." } } |