Tan LE

Before my current automation work, I spent about a year as a freelancer building a market-intelligence and purchasing-workflow platform for a US ticket-brokerage client. The secondary ticket market moves fast: events go on sale at a fixed minute, prices and seat availability shift constantly across a dozen marketplaces, and the brokers who win are the ones who see changes first. My job was to give a small operations team that visibility — and to automate as much of the surrounding workflow as possible. This post is a technical retrospective of that system: what it did, how it was architected, and what I learned running data pipelines across two clouds. What the platform did At its core, the system ran four loops for the operations team: Primary-market ingest. Scheduled jobs pulled upcoming events from Ticketmaster's APIs — by state, by venue, by on-sale date — into a local SQL Server database, so the team planned their week from one screen instead of a dozen browser tabs...

Code first DB:  dotnet tool install --global dotnet-ef dotnet ef migrations add "Initial" -o "Data/Migrations" dotnet ef database update ng g c employee --module app --skipTests=true External libraries:           @angular/material (Angular npm package)       Doing this will trigger the Angular Material command-line setup wizard, which will install the following npm packages: --> npm install xxxxx @angular/material @angular/cdk  (prerequisite) System.Linq.Dynamic.Core (.NET Core NuGet package) Microsoft.EntityFrameworkCore NuGet package      Microsoft.EntityFrameworkCore.Tools NuGet package      Microsoft.EntityFrameworkCore.SqlServer NuGet package If we prefer to do this using the NuGet package manager command line, we can input the following:    PM> Install-Package Microsoft.EntityFrameworkCore -Version 5.0.0 PM> Install-Package Microsoft.EntityFrameworkCore.Tools -Version 5.0.0...

  Installing the Angular CLI npm install -g @angular/cli@11.0.1  or the latest. npm install -g @angular/cli@latest Creating a new Angular app ng new ClientHREmp Wait for  the tool to complete the task, and then do the following: Type  cd ClientHREmp  to enter the newly created folder Execute the  npm install  and  npm update  commands to update the npm packages Switch client app by updating the Startup.cs file configuration.RootPath = "ClientApp/dist" ; --> configuration.RootPath = "ClientHREmp/dist" ; spa.Options.SourcePath = "ClientApp" ; --> spa.Options.SourcePath = "ClientHREmp" ; ---------------------------------------------------- dotnet new angular -o  HREmp CREATING COMPONENTS USING THE ANGULAR CLI ng generate component health-check --skipTests=true OR ng g c employee --module app --skipTests=true -------------------------------------- Create the sample API to return a "Hello world" by get route      [Ro...