I am trying to implement a simple order management app with Asp.net Core Blazor Server. I am using SQL Server. The main entities are order, order detail, vendor, and customer. I have implemented listing, adding, and updating for vendors and customers.
The tricky part is listing, adding, and updating the order/order details. One of the requirements is to upload data with excel. This excel file consists of orders and details and I want to give another option to the user to insert data from the razor page other than uploading the excel file.
Searching for free Blazor libraries which include master-detail grids having update, and insert features. I couldn't find a solution that would meet the requirements. Hope you can help me.
Something like this in Blazor can solve my problems; https://demo.aspnetawesome.com/MasterDetailCrudDemo#Master-Detail-CRUD-using-Inline-Editing-and-nesting
Thanks.
Here are draft order and order detail entities
Orders
int OrderId,
int OrderNumber - autoincrement from 1,
DateTime OrderDate,
string DoneBy,
string Status,
string CustomerName,
string VendorName,
List OrderDetails
OrderDetails
int OrderDetailId,
int ProductNumber - autoincrement from 1,
string ProductCode,
string ProductName,
int BuyQuantity,
int SellQuantity,
double CostRatio,
double UnitCost,
double TotalBuyPrice,
double TotalSellPrice,
string ShippingNumber,
string Status,
string TrackingNumber,
Description,
int OrderId,
Order
What I have tried:
Didn't figure out how to implement master-detail page on Blazor