Results 1 to 11 of 11

Thread: Which model will select to be base of view Sales Order Entry Form ( SalesFooter Model

Threaded View

  1. #1

    Thread Starter
    Lively Member
    Join Date
    Apr 2018
    Posts
    67

    Which model will select to be base of view Sales Order Entry Form ( SalesFooter 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

    Sales Order Design Code:
    1. on Header(represent by Sales Header Model)
    2. SalesOrderNO   1
    3. SalesYear      2019
    4. SalesDate      2019-01-17
    5. BranchCode     1
    6. SalesTypeNo    1
    7. CustomerNo     2509
    8. on Footer(represent by Sales Footer Model)
    9. SalesLineNo ItemCode  Quantity  Price Total
    10. 1                  12929         5          10       50
    11. 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) :

    Code:
    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<SalesFooter> 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; }
    Last edited by engbarbary; Jan 17th, 2019 at 05:58 PM. Reason: some text not good display

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width