asp.net mvc - Populate a dropdownlist from a seperate model/Database Table

Question

Let's say I have two tables. Inventory and Supplier. Inventory has three fields : name, inventory_no and supplier_no and Supplier has two fields : name, supplier_no

In my View for Inventory is it possible to add a cell with a @Html.DropDownListFor() populated from a separate supplies model?

I can't figure out how to accomplish it using the Controller/View so I was thinking about using AJAX

Example:

Name    | Inv_no | Suppliers
------- | ------ | ------------------------------
Pen     | 101    | DDL populated of all suppliers
Pencil  | 102    | DDL populated of all suppliers
Erase   | 103    | DDL populated of all suppliers

VIEW:

<table>
    <tr>
        <th>Name</th>
        <th>Inventory_No</th>
        <th>Suppliers</th>
    <tr>
        @foreach(var item in Model)
        {
            <td>@Html.DisplayFor(modemItem => item.name)</td>
            <td>@Html.DisplayFor(modemItem => item.inventory_no)</td>
            <td><!-- @Html.DropDownListFor() ? --></td>
        }
</table>

Controller:

public virtual JsonResult  getListOfSuppliers(int? supplier_no)
{
    using (db)
    {
        var vendors = db.vendors.Select(c => new
        {
            Value = c.supplier_no,
            Text = c.name
        });
        return Json(vendors, JsonRequestBehavior.AllowGet);
    }
}

Yes, it is possible.

Quality Catalyst
– Quality Catalyst

2017-01-04 20:50:39 +00:00
Commented Jan 4, 2017 at 20:50 — Quality Catalyst
– Quality Catalyst, Commented Jan 4, 2017 at 20:50

Nowshad Rahaman · Accepted Answer · 2017-01-05 05:11:35Z

Yes, it is possible.

Your Model should be like:

    public class ViewModel
    {
        public string Name { get; set; }
        public int InventoryNo { get; set; }
        public int SupplierNo { get; set; }
        public IList<SelectListItem> Suppliers {get;set;}    
    }

Controller:

public virtual ActionResult  getListOfSuppliers(int? supplier_no)
{
    using (db)
    {
        var model = new ViewModel
        {
           Name = <name value>,
           InventoryNo = <name value>,
           Suppliers = db.vendors.Select(c => new SelectListItem
           {
              Value = c.supplier_no,
              Text = c.name
           }).ToList()
        };
        return View(model);
    }
}

in View:

<td><!-- @Html.DropDownListFor(x => x.SupplierNo, Model.Suppliers, new { @class = "form-control" }) ? --></td>

Joe · Accepted Answer · 2017-01-04 20:58:57Z

0

Not really.

The easiest way would be to create a viewmodel and then use that model in the view. The viewmodel class would be generated by the controller and then passed to the view. In this viewmodel object would be the inventory items as well as an IEnumerable list of the supplies objects.

Something to this effect would get the ball rolling:

public class InventoryViewModel
{
    public string Name { get; set; }
    public int Inventory_No { get; set; }
    public int Supplier_No { get; set; }

    public List<Supplies>
    {
        get
            {
                 return <your DAL>.Supplies.All().ToList();
            }
    }
}

answered Jan 4, 2017 at 20:58

Joe

374 bronze badges

Comments

user5886152 · Accepted Answer · 2017-01-04 21:07:49Z

0

You don't need to use AJAX for that, just change the model you're passing into the view. The model would be List<Item>, and Item would be defined as:

string Name
int Inv_No
IEnumerable<SelectListItem> Suppliers

This way, each item has its own supplier list, and you can use DropDownFor to create the dropdown for each item from the Suppliers field.

answered Jan 4, 2017 at 21:07

user5886152

Collectives™ on Stack Overflow

asp.net mvc - Populate a dropdownlist from a seperate model/Database Table

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related