I want a C# console tool that parses the following two Azure VM public pricing pages:
[login to view URL]
[login to view URL]
The tool must parse the entire page and create a ROW for every VM SKU option, based on. The currency should be set to “British Pounds £” and the pricing set to “Hour” The columns muse be:
1. VM SKU Family (e.g. D1s-5s v2)
5. Temporary Storage
5. Pay as you go amount (just the £ amount)
6. Pay as you go amount with AHB (just the £ amount)
7. 1 year reserved with AHB (in the format of $/hour (~ %)
8. 3 year reserved with AHB (in the format of $/hour (~ %)
9. Spot with AHB (in the format of $/hour (~ %)
10. Operating System (value selected from the list box at the top of the page)
11. Region (value selected from the list box at the top of the page)
The currency and display pricing should always “British Pounds £” and “Hour” respectively.
The output of the C# console utility must be a CSV or XLSX file
The command line options are:
-all (represents parsing the entire file)
-sku="x, y, z, etc." where x, y, z, etc. are the VM family SKUs names. The sku list can be 1 or more
-in = URL to page (test with the two URLS shown above)
If the filename exists, append to the file, if the filename does NOT exist, create the file. Always write at the bottom of the file
Validation? I want a Visual Studio project file, version 2017 (preferably) where I can debug the code as appropriate.
BONUS: If you have the ability to programmatically select the OS/Software and Region at run-time, that would be ideal. That would allow me to create a batch file where I can run the tool multiple times but specify the OS/Software and Region. Only if this is possible, you must add two more command line options:
-os (for operating system matching value in the list box)
-region (for region matching value in the list box)
I would like to use this application by before the end of the month (June 2021).
When bidding, please indicate whether you can accomplish the BONUS request. If not, I will accept the tool without the BONUS capabilities.
You must FULLY document your code and minimize unnecessary libraries.
I prefer C# as I understand it. But if someone can accomplish the same thing in Python or VBA via EXCEL, please bid and demonstrate your confidence to complete the job in those tools. But ideally, I prefer the implementation be done in:
Priority 1: C#
Priority 2: PowerShell
Priority 3: VBA Excel
Priority 4: Python