-
Notifications
You must be signed in to change notification settings - Fork 0
/
Save-DatabaseTableData.ps1
32 lines (31 loc) · 1.05 KB
/
Save-DatabaseTableData.ps1
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
<#
.DESCRIPTION
Call to Save data into the database to all Global objects here.
.EXAMPLE
Save-DatabaseTableData
#>
function Save-DatabaseTableData() {
Begin {
}
Process {
try {
if ($Global:Resources.IsDataTable) {
Write-BulkData -TableName $Global:DatabaseTable.UsersTable -Data (Out-DataTable $Global:UsersTableObject);
}
else {
$userDetailQuery = $("INSERT INTO {0} (UserCode,FirstName,LastName,Email,AddressLine1,AddressLine2,
Country,State,City,PostCode,IsActive,CreatedDate,ModifiedDate)
{1}" -f ($Global:DatabaseTable.UsersTable), ($Global:UsersTableSqlQuery));
ExecuteNonQuery -Name $userDetailQuery -Procedure $false
}
}
catch {
Write-Exception -ErrorObj $_ -Message "Throws an exception in 'Save-DatabaseTableData'" -Stop $true
}
finally {
Initialize-GlobalObjects
}
}
End {
}
}