Maintaining Tax Rates - Update and Delete - Blazor Purchase Orders Part 6
A C# project using Blazor to create a simple Purchase Order System, incorporating Syncfusion controls and using Dapper to link to a SQL database. In this video we complete the first razor page to maintain Tax Rates by adding the ability to edit and delete Tax Rates. Deletion is achieved by marking records 'as archived' and excluding them from view. Consideration is also given to whether to include archived records in tests for duplicates.
The video also demonstrates how error CS0266 can be inadvertently triggered - and how to avoid it.
I forgot to mention in the video that I had altered the SQL stored procedure to list tax rates so that it only included non-archived records. See the website link below.
Timeline
00.00 - Introduction
00:40 - Introduction to Edit razor page summary
01:40 - SQL to prevent duplicates when updating a record
03:03 - C# Service code
04:37 - C# Interface code
05:35 - Razor page Syncfusion GridEvent RowHandler
07:10 - Toolbar Handler for editing record
08:35 - C# to save edited record
11:07 - Add Syncfusion dialog to handle delete function
17:22 - How to allow addition of duplicate if original has been archived
21:30 - Demonstration of C# error CS0266
Description and code: https://blazorcode.uk/purchaseorders/...
Watch video Maintaining Tax Rates - Update and Delete - Blazor Purchase Orders Part 6 online without registration, duration hours minute second in high quality. This video was added by user Christopher Bell 18 January 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 1,025 once and liked it 17 people.