RememberThis

The following list includes the work done in the Service Refactor Branch

• cleaned up SQLDB service removing unused lines of code and bad copy/paste from Cocktail project
• Created ImageService, which provides image file validation logic
• Minor fixes in Insert and Delete logic
• Implemented Delete Item logic in SQL Service, Storage Service and Controller
• Created Azure Storage Class a Service
• Created SQLDB Class a service

The following list includes the work done in the B2C Branch

• imlemented SQL Command Parameters

• Azure Storage Rollback logic

• changed User to UserObjectId

• discovered Properties\launchsettings.json and added https support

• minimze3d the meta data collected on the insert page

• moved AuthN code from B2C proj into blazorWebApp

• PR on 3/30/23

• Fixed B2C

  • Identity Options
  • Default policy

• cleaned up numerous Null Reference Warnings using ? and !

• refactored code to display item for Create & Update process

• Used ChatGPT to come up with name for Item Service

• PoC ticks and milliseconds

• PoC for SAS and Stream

The following list includes the work done in the Read Branch

• Added Persist service
• file size check moved to file picker method
• start of ReadlAll
• rounded cirlces
• NavigationLock
• PoC - SAS & Stream
• PoC - ticks and milliseconds
• changed safe file name to datetime vs. guid
• made a re-usable component for 1 Item
• Bing CoPilot suggested Persist Service name to ItemService
• added logic for group transaction of SQL and Storage
• cleaned up multiple null refernce warning messages
• tested successfully with new B2C tenant and app registration

The following list includes the work done in the MultiPart Branch

• Added a B2C project as a template
• Blazor Component calling an API
  • added HTTPClientFactory
  • pass both class data and file to API
• Updated to Bootstrap 5.2.3
• Added Bootstrap Modal dialog box
• Created Modal as child component
  • eventcallback parameter
  • added fancy icons
• Added Try Catch on call to API - PostAsync
  • This is for the use case where we have not yet started the API, but the client calls it
• Added File Validation logic
  • file size
  • extension type
  • header check
• Azure Storage
  • added code to write image to storage
    • using client secrets
  • generate safe file name
• SQL
  • created class for CRUD operations to SQL
  • copied from Cocktail project
  • using client secrets for pswd at this point
  • only insert statement completed