Which model will select to be base of view Sales Order Entry Form ( SalesFooter Model OR Sales Header Model) ?
I work in project work in asp.net core 2.1 visual studio 2017 SQL Server 2012
I actually need to make entry form Sales Order consist from Sales Header Model and Sales Footer model
on Sales Order Entry Form
- on Sales Order Entry Form
- on Header(represent by Sales Header Model)
- SalesOrderNO 1
- SalesYear 2019
- SalesDate 2019-01-17
- BranchCode 1
- SalesTypeNo 1
- CustomerNo 2509
- on Footer(represent by Sales Footer Model)
- SalesLineNo ItemCode Quantity Price Total
- 1 12929 5 10 50
- 2 17918 4 5 20
Result of Process above when Save the Order
One record added to Sales Header Table.
Two record added to Sales Footer Table.
so that what Model I will select it to be based of Sales Order (Sales Footer Or Sales Header) :
- Sales Header Model
- public int SalesOrderNo { get; set; }
- public int SalesYear { get; set; }
- public int BranchCode { get; set; }
- public int SalesType { get; set; }
- public DateTime SalesDate { get; set; }
- public int CustomerID { get; set; }
- public Customer Customers { get; set; }
- public ICollection
SalesFooters { get; set; } - Sales Footer model
- public int SalesOrderNo { get; set; }
- public int SalesLineNo { get; set; }
- public int SalesType { get; set; }
- public int BranchCode { get; set; }
- public string ItemCode { get; set; }
- public decimal Quantity { get; set; }
- public decimal UnitPrice { get; set; }
- public decimal Total { get; set; }
- public Items Itemes { get; set; }
- public SalesHeader SaleHeaders { get; set; }
ahmed elbarbaryPosted Jan 18, 2019, 7:12 PM
Create
SalesHeader
Order Items
Jenith ThakkarPosted Jan 17, 2019, 10:14 PM
Please check below image here upper part is header and all line items are footer