将ViewModels和Partial View与asp.net mvc结合使用

Question

我在创建适当的ViewModel以允许用户在一个视图中同时选择多个票证时遇到问题。

我有一张型号的票

 public class Ticket
{
   public int TicketID { get; set; }
   [Required]
   [ForeignKey("Event")]
   //foreign key
    public int EventID { get; set; }
   [Required]
   public string Description { get; set; }
   [Required]
   public float Price { get; set; }
    //navigation property
    public virtual Event Event { get; set; }
}

订单模型

 public class Order
{
    public int OrderID { get; set; }
    //foreign key
    [Required]
    [ForeignKey("Event")]
    public int EventID { get; set; }

    [Required]
    public DateTime OrderDate { get; set; }
    [Required]
    public float OrderTotal { get; set; }
    public ApplicationUser user { get; set; }
    public virtual Event Event { get; set; }
}

然后我有一个OrderDetails模型

public class OrderDetails
{
    [Required]
    public int OrderDetailsID { get; set; }

    [Required]
    //Foreign key
    [ForeignKey("Order")]
    public int OrderID { get; set; }
    [Required]
    //Foreign key
    [ForeignKey("Ticket")]
    public int TicketID { get; set; }
    [Required]
    public string FirstName { get; set; }
    [Required]
    public string LastName { get; set; }
    [Required]
    [DataType(DataType.EmailAddress)]
    public string email { get; set; }
    [Required]
    [DataType(DataType.PhoneNumber)]
    public int PhoneNumber { get; set; }
    //navigation properties
    public virtual Order Order { get; set; }
    public virtual Ticket Ticket { get; set; }
}

我还创建了一个额外的TicketsOrdered模型，因为我不知道还能在哪里保存用户选择的每种票类型的数量

public class TicketsOrdered
{
    public int OrderID;
    public int TicketID;
    public int Quantity;
}

我想创建一个视图，显示与特定事件相关的每张门票的门票描述和价格，然后还有一个下拉/文本框，允许用户输入他们需要的每张门票数量。然后我想将TicketID、OrderID和数量保存到我的TicketsOrdered数据库表中。我遇到的问题是，所有的数据都与这么多模型有关，我不知道如何将它们整合在一起。我完全不知道如何实现这一点，我希望它看起来如何的一个例子是当你点击EventBrite上的订票时。关于ViewModel的任何帮助，或者如何在视图中使用我当前的模型，都将非常有用，谢谢。

编辑事件模型

 public class Event
{
    public int EventID { get; set; }
    [Required]
    public String Name { get; set; }
    [Required]
    public String Location { get; set; }
    [Required]
    [DataType(DataType.Date)]
    public DateTime Date { get; set; }
    [Required]
    [DataType(DataType.MultilineText)]
    public String Description { get; set; }
    [Required]
    [Display(Name = "Total Tickets Available")]
    public int TicketsAvailable { get; set; }
    //navigation property
    public virtual IEnumerable<Order> Order { get; set; }
    //navigation property
    public virtual IEnumerable<Ticket> Tickets { get; set; }
}

Answer 1

首先创建表示要在视图中显示/编辑的视图模型

public class TicketVM
{
  public int TicketID { get; set; }
  public string Description { get; set; }
  public decimal Price { get; set; }
  public int Quantity { get; set; }
}
public class OrderVM
{
  public int ID { get; set; }
  public int EventID { get; set; }
  public string EventName { get; set; }
  // additional properties of Event you want to display
  public DateTime OrderDate { get; set; }
  public string FirstName { get; set; }
  // additional properties of Order and OrderDetails you want to edit
  public List<TicketVM> Tickets { get; set; }
}

附带说明：有点不清楚为什么Order和OrderDetails有单独的模型，或者为什么OrderDetails有public int TicketID { get; set; }，这表明Order只能有一个票证，所以我建议您可能需要对数据库结构进行一些更改。如果用户可以为不同的人订购多张票，那么每个持票人的姓名、电子邮件和电话可能应该存储在TicketsOrdered表中（以及添加到TicketVM类中的属性）

然后视图将是（假设它用于创建方法）

@model TicketVM
@using (Html.BeginForm())
{
  @Html.HiddenFor(m => m.EventID)
  <h2>@Model.EventName</h2>
  // other display properties of event
  @Html.TextBoxFor(m => m.OrderDate)
  @Html.TextBoxFor(m => m.FirstName)
  // other edit control for properties of Order and OrderDetails (see note above)
  @Html.EditorFor(m => m.Tickets)
  <input type="submit" value="Save" />
}

而EditorTemplate用于TicketVM（在/Views/Shared/EditorTemplates/TicketVM.cshtml中）

@model TicketVM
@Html.HiddenFor(m => m.TicketID)
@Html.DisplayFor(m => m.Description)
@Html.DisplayFor(m => m.Price)
@Html.TextBoxFor(m => m.Quantity)

然后控制器方法将是（注意，您没有向您展示Event型号，因此调整以下内容以适应）

public ActionResult Create(int ID) // assumes ID is the ID of the Event
{
  // Get the event and its tickets
  Event e = db.Events.Where(e = e.EventID = ID).Include(e => e.Tickets);
  // Initialize a new order
  OrderVM model = new OrderVM
  {
    EventID = e.EventID,
    EventName = e.EventName,
    // other properties of event as required
    Tickets = e.Tickets.Select(t => new TicketVM
    {
      TicketID = t.TicketID,
      Description = t.Description,
      Price = t.Price
    })
  };
  return View(model);
}
[HttpPost]
public ActionResult Create(OrderVM model)
{
  if (!ModelState.IsValid)
  {
    // repopulate any properties as required
    return View(model);
  }
  // Initialize an Order data model, save it and gets its ID
  Order order = new Order
  {
    OrderDate = model.OrderDate,
    // other properties of Order
  };
  db.Orders.Add(order);
  db.SaveChanges();
  // ditto for OrderDetails (but see notes above)
  // Initialize an TicketsOrdered data model for each valid ticket
  foreach(TicketVM ticket in model.Tickets.Where(t => t.Quantity > 0))
  {
    TicketsOrdered ticketOrder = new TicketsOrdered
    {
      OrderID = order.ID,
      TicketID = ticketOrder.TicketID,
      Quantity = ticketOrder.Quantity
    }
    db.TicketsOrdered.Add(ticketOrder);
  }
  db.SaveChanges();
  return RedirectToAction(...);
}