How to display two models with single view using asp.net core 6.0

pius joshua

Hi, Good morning all, I am new to asp.net core 6.0 and i have this issues...

I have this model Called OrderModel, inside it I have order class and orderDetails Class

public class Order
{
    [Key]
    public int OrderId { get; set; }



    [Display(Name = "Customer Name")]
    [Required(ErrorMessage = "Please Select Customer Name")]
    public String CustomerName { get; set; }

    public ICollection? OrderDetails { get; set; }

}

public class OrderDetail
{
    [Key]
    public int DetailId { get; set; }
    public int OrderId { get; set; }
    [Display(Name = "Service")]
    public string ServiceName { get; set; }

    [Display(Name = "Quantity")]
    public int Quantity { get; set; }

    [Display(Name ="Unit Price")]
    public float UnitPrice { get; set; }

    [ForeignKey("OrderId")]
    public Order? Order { get; set; }
}

//On my view, I want to be able to display the Order Class as a form and the OrderDetails as an editable table with 10 rows ..

public IActionResult Customer_Order()
{
    // I want to be able to display upto 10 rows..
    List od = new List();
    od.Add(new OrderDetail  { DetailId = 0, Discount = 0, Quantity = 0, ServiceName = "Select Service", UnitPrice = 0, TotalAmount = 0 });
    od.Add(new OrderDetail { DetailId = 0, Discount = 0, Quantity = 0, ServiceName = "Select Service", UnitPrice = 0, TotalAmount = 0 });
    return View(od);
}

On Post, I want to be able to save the data to both order table and orderdetails table


@model Customer.Models.Order



            
             
            
               
                
                 
                
                
             
                
                
          
            
            
             
                                        
                   int j = 0;
                 @foreach (var item in Model.OrderDetails)
                 {
                   
                     
                 }
             
         
    
        
            
                SN
            
            
                Services
            
            
                Qty/Hrs
            
            
                Unit Price
            
          
            
                Total
            
        
    
    
                         

                         
                         
                             @Html.DropDownListFor(model=>item.ServiceName, ViewBag.ServiceID as List, "Please Select", new{@class ="form-control dropdownlist select2"})

                         
                         
                             @Html.EditorFor(model=>item.Quantity) 
                         
                         
                             @Html.EditorFor(model=>item.UnitPrice)
                         
                        
                         
                             @Html.EditorFor(model=>item.TotalAmount)

SN	Services	Qty/Hrs	Unit Price	Total
	@Html.DropDownListFor(model=>item.ServiceName, ViewBag.ServiceID as List, "Please Select", new{@class ="form-control dropdownlist select2"})	@Html.EditorFor(model=>item.Quantity)	@Html.EditorFor(model=>item.UnitPrice)	@Html.EditorFor(model=>item.TotalAmount)

How do i display data into

Thank you very much for your lovely time..

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sachin Singh4y ago
what is the general flow of any ECommerce web app?
1. We log in.
2. we navigate to the products page.
3. we select any product and purchase it or we push the product to cart.
Or 4. we order all products in the cart in one go.

so, when the Customer submits the order we already have the customer Id (as the customer is logged in).
We just receive the product details (product id, quantity) in our CreateOrder method.
public IActionResult CreateOrder (Order order)
{


Order ord= new Order ();
  ord.CustomerName=order.CustomerName;
ord.OrderDetails= new Collection();
_context.Order.Add(ord);
}
OrderDetail details = new List();
details=order.OrderDetails;
ord.OrderDeatils.Add(details);
_context.SaveChanges();
}
There are another shortcut ways, but if you are learning EF then use the above method.
pius joshua4y ago
Thank you for your precious time...
This is not what I am Looking out for.. However,
What I just did now is to wrap the two models together in a single class
   public class Order_Model
    {
        public Order Order { get; set; }
        public List OrderDetails { get; set; }
    }

// To add Item List to the table
public List GetOrderDetail()
        {
            var Orderd = new List();
            Orderd.Add(new OrderDetail { DetailId = 0, Discount = 0, Quantity = 0, ServiceName = "Select Service", UnitPrice = 0, TotalAmount = 0 });
            Orderd.Add(new OrderDetail { DetailId = 1, Discount = 0, Quantity = 0, ServiceName = "Select Service", UnitPrice = 0, TotalAmount = 0 });
            return Orderd;
        }

//On my controller I had to do this

public IActionResult Customer_Order()
        {

            MultipleOrderModel od = new MultipleOrderModel();
            od.OrderDetails = GetOrderDetail().ToList();


            return View(od);
        }
And It worked for me... the next step is to post the data and save it on my database
Jay Krishna Reddy4y ago
Using this tuple object we can pass multiple models from the controller to the view.

Controller Code
public ActionResult IndexTuple()
{
    ViewBag.Message = "Welcome to my demo!";
    var tupleModel = new Tuple, List>(GetTeachers(), GetStudents());
    return View(tupleModel);
}
View Code
@using MultipleModelInOneView;
@model Tuple , List >
@{
    ViewBag.Title = "Home Page";
}
@ViewBag.Message

Teacher List












    @foreach (Teacher teacher in Model.Item1)
    {










    }
Id Code Name
@teacher.TeacherId @teacher.Code @teacher.Name

Student List














    @foreach (Student student in Model.Item2)
    {












    }
Id Code Name Enrollment No
@student.StudentId @student.Code @student.Name @student.EnrollmentNo

Hope, this solves your problem.

How to display two models with single view using asp.net core 6.0

@ViewBag.Message