public/project_item.ps1
|
<# .SYNOPSIS Get a project item. .DESCRIPTION Fields will show th emerge between Project and Staged Item fields values .EXAMPLE Get-ProjectItem -Owner "someOwner" -ProjectNumber 164 -ItemId PVTI_lADOBCrGTM4ActQazgMuXXc #> function Get-ProjectItem{ [CmdletBinding()] param( [Parameter(Position = 0)][string]$Owner, [Parameter(Position = 1)][string]$ProjectNumber, [Parameter(Mandatory,Position = 2)][string]$ItemId, [Parameter()][switch]$Force ) ($Owner,$ProjectNumber) = Get-OwnerAndProjectNumber -Owner $Owner -ProjectNumber $ProjectNumber if([string]::IsNullOrWhiteSpace($owner) -or [string]::IsNullOrWhiteSpace($ProjectNumber)){ "Owner and ProjectNumber are required" | Write-MyError; return $null} $db = Get-Project -Owner $Owner -ProjectNumber $ProjectNumber -Force:$Force $item = Get-Item $db $ItemId return $item } Export-ModuleMember -Function Get-ProjectItem <# .SYNOPSIS Edit a project item .EXAMPLE Edit-ProjectItem -Owner "someOwner" -ProjectNumber 164 -Title "Item 1 - title" -FieldName "comment" -Value "new value of the comment" Edit-ProjectItem -Owner "someOwner" -ProjectNumber 164 -Title "Item 1 - title" -FieldName "title" -Value "new value of the title" #> function Edit-ProjectItem{ [CmdletBinding()] param( [Parameter(Position = 0)] [string]$Owner, [Parameter(Position = 1)] [string]$ProjectNumber, [Parameter(Position = 2)] [string]$ItemId, [Parameter(Position = 3)] [string]$FieldName, [Parameter(Position = 4)] [string]$Value, [Parameter()][switch]$Force ) ($Owner,$ProjectNumber) = Get-OwnerAndProjectNumber -Owner $Owner -ProjectNumber $ProjectNumber if([string]::IsNullOrWhiteSpace($owner) -or [string]::IsNullOrWhiteSpace($ProjectNumber)){ "Owner and ProjectNumber are required" | Write-MyError; return $null} # get the database $db = Get-Project -Owner $Owner -ProjectNumber $ProjectNumber -Force:$Force # Find the actual value of the item. Item+Staged $item = Get-Item $db $ItemId $itemStaged = Get-ItemStaged $db $ItemId # if the item is not found if($null -eq $item){ "Item [$ItemId] not found" | Write-MyError; return $null} # Consolidate value with staged to calculate the actual value $actualFieldValue = $itemStaged.Fields.$FieldName ?? $item.$FieldName # check if the value is the same if(IsAreEqual -Object1:$actualFieldValue -Object2:$Value){ return } # save the new value Save-ItemFieldValue $db $itemId $FieldName $Value # Commit change changes to the database Save-ProjectDatabase -Owner $Owner -ProjectNumber $ProjectNumber -Database $db } Export-ModuleMember -Function Edit-ProjectItem function IsAreEqual{ param( [object]$Object1, [object]$Object2 ) $Object1 = [string]::IsNullOrEmpty($Object1) ? $null : $Object1 $Object2 = [string]::IsNullOrEmpty($Object2) ? $null : $Object2 # Check if the objects are equal $ret = $Object1 -eq $Object2 return $ret } |