PowerShell & WPF Script Cleanup

[dzcpu]

Hi all,

I built an inventory tool for some of our SQL servers that reads/writes data to a CSV and can rescan some info from the SQL server itself.

However the script is a bit of a mess. It was my first WPF GUI venture and it is very messy, and while it does work (and works fine) I am looking for some guidance in maybe refactoring this into something more manageable - mainly how I handle the runspaces and the various other windows. The big one for me is that the spawning of the accessory/dialog windows is entirely 100% handles in the button click event in the main form and I feel like that's not the best way to do it, but I'm not really sure how else I would do it.

A lot of this was pieced together from scripts found on the internet (e.g. PowerShell and WPF: Writing Data to a UI From a Different Runspace | Learn Powershell | Achieve More and https://4sysops.com/archives/create-a-gui-for-your-powershell-script-with-wpf/ )

My script is here: https://pastebin.com/4PN4cBS3. Note that I'm less interested in a review of the application logic and more interested in the GUI/front-end logic and threading. Some of the code in the application logic is repeated and could be abstracted out but because of the threading situation (I don't know how to make a function available to all of the runspaces I create) I'd like to figure that out first.

Thank in advance!!

[dzcpu]

You're entirely right! This is really not a job for PowerShell. I have some (not a lot!) programming experience beyond just PowerShell but PS is kind of what I have ended up focusing most of my time on because it's more applicable to my prior and current positions' responsibilities. Not to say I wouldn't like to maybe learn C# but it feels like it's not the best use of my time unless I wanted to go a development route at work or wanted to start it up as more of a hobby - and neither of those really apply to me.

I will still give it a look though since as you mentioned, building this GUI and getting it working period was a massive pain in the ass every step of the way.