Create a Dropdown List by getting the values from a table in MVC .NET Web application
SQL Tables and Procedure
In this particular blog we will see how you can use a dropdown list inside your web application in a MVC environment
Our strategy will be:
We will have the two different table 1. aa_ManufacturerMaster_1637935 and another
2. aa_AssetMaster_1637935. While Inserting into the second table we will get the
Mname field in the second table but the data with respect to the Mname
, MID(as this is a foreign key reference in the second table) values will insert into the aa_AssetMaster_1637935 table.
Table Name: aa_ManufacturerMaster_1637935
This is our first table from where we will get the data for the dropdown.
<span class="pln"> CREATE TABLE aa_ManufacturerMaster_1637935 </span><span class="pun">(</span><span class="pln"> MID </span><span class="kwd">int</span><span class="pln"> identity</span><span class="pun">(</span><span class="lit">100</span><span class="pun">,</span><span class="lit">1</span><span class="pun">)</span><span class="pln"> primary key</span><span class="pun">,</span><span class="pln"> </span><span class="typ">Mname</span><span class="pln"> varchar</span><span class="pun">(</span><span class="lit">50</span><span class="pun">)</span><span class="pln"> </span><span class="pun">)</span><span class="pln"> </span>
File Name: aa_AssetMaster_1637935
This is our second table
<span class="pln"> CREATE TABLE aa_AssetMaster_1637935</span><span class="pun">(</span><span class="pln"> </span><span class="typ">AssetID</span><span class="pln"> </span><span class="kwd">int</span><span class="pln"> identity</span><span class="pun">(</span><span class="lit">100</span><span class="pun">,</span><span class="lit">1</span><span class="pun">)</span><span class="pln"> primary key</span><span class="pun">,</span><span class="pln"> </span><span class="typ">AssetUniqueName</span><span class="pln"> varchar</span><span class="pun">(</span><span class="lit">50</span><span class="pun">),</span><span class="pln"> </span><span class="typ">AssetType</span><span class="pln"> varchar</span><span class="pun">(</span><span class="lit">50</span><span class="pun">),</span><span class="pln"> </span><span class="typ">ManufacturerID</span><span class="pln"> </span><span class="kwd">int</span><span class="pln"> foreign key references aa_ManufacturerMaster_1637935</span><span class="pun">(</span><span class="pln">MID</span><span class="pun">),</span><span class="pln"> </span><span class="typ">AllocationStatus</span><span class="pln"> </span><span class="kwd">int</span><span class="pln"> </span><span class="pun">)</span><span class="pln"> </span>
Procedure Name: xx_sp_insert_AssetMaster
This is the procedure by which we will insert data inside the second table aa_AssetMaster_1637935
<span class="pln"> ALTER PROCEDURE xx_sp_insert_AssetMaster </span><span class="lit">@AssetUniqueName</span><span class="pln"> varchar</span><span class="pun">(</span><span class="lit">50</span><span class="pun">),</span><span class="pln"> </span><span class="lit">@AssetType</span><span class="pln"> varchar</span><span class="pun">(</span><span class="lit">50</span><span class="pun">),</span><span class="pln"> </span><span class="lit">@ManufacturerID</span><span class="pln"> </span><span class="kwd">int</span><span class="pun">,</span><span class="pln"> </span><span class="lit">@AllocationStatus</span><span class="pln"> </span><span class="kwd">int</span><span class="pun">,</span><span class="pln"> </span><span class="lit">@AssetID</span><span class="pln"> </span><span class="kwd">int</span><span class="pln"> OUT AS </span><span class="kwd">BEGIN</span><span class="pln"> INSERT INTO aa_AssetMaster_1637935 VALUES </span><span class="pun">(</span><span class="lit">@AssetUniqueName</span><span class="pun">,</span><span class="lit">@AssetType</span><span class="pun">,</span><span class="lit">@ManufacturerID</span><span class="pun">,</span><span class="lit">@AllocationStatus</span><span class="pun">)</span><span class="pln"> SET </span><span class="lit">@AssetID</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> </span><span class="pun">@</span><span class="lit">@IDENTITY</span><span class="pln"> </span><span class="kwd">END</span><span class="pln"> </span>
.NET CODE
File Name: HomeController.cs
This method will return List. Items will be fetched from the
aa_ManufacturerMaster_1637935 table.
<span class="pln"> DB012TMS214_1819Entities dbObject </span><span class="pun">=</span><span class="pln"> </span><span class="kwd">new</span><span class="pln"> DB012TMS214_1819Entities</span><span class="pun">();</span><span class="pln"> </span><span class="kwd">protected</span><span class="pln"> </span><span class="typ">List</span><span class="pun"><</span><span class="typ">SelectListItem</span><span class="pun">></span><span class="pln"> populateddlist_Manufacture</span><span class="pun">()</span><span class="pln"> </span><span class="pun">{</span><span class="pln"> </span><span class="typ">List</span><span class="str"><aa_ManufacturerMaster_1637935></span><span class="pln"> lstmfact </span><span class="pun">=</span><span class="pln"> </span><span class="kwd">new</span><span class="pln"> </span><span class="typ">List</span><span class="str"><aa_ManufacturerMaster_1637935></span><span class="pun">();</span><span class="pln"> lstmfact </span><span class="pun">=</span><span class="pln"> dbObject</span><span class="pun">.</span><span class="pln">aa_ManufacturerMaster_1637935</span><span class="pun">.</span><span class="typ">ToList</span><span class="pun">();</span><span class="pln"> </span><span class="typ">List</span><span class="pun"><</span><span class="typ">SelectListItem</span><span class="pun">></span><span class="pln"> manufacturenames </span><span class="pun">=</span><span class="pln"> </span><span class="kwd">new</span><span class="pln"> </span><span class="typ">List</span><span class="pun"><</span><span class="typ">SelectListItem</span><span class="pun">>();</span><span class="pln"> </span><span class="kwd">foreach</span><span class="pln"> </span><span class="pun">(</span><span class="kwd">var</span><span class="pln"> e </span><span class="kwd">in</span><span class="pln"> lstmfact</span><span class="pun">)</span><span class="pln"> </span><span class="pun">{</span><span class="pln"> </span><span class="typ">SelectListItem</span><span class="pln"> s </span><span class="pun">=</span><span class="pln"> </span><span class="kwd">new</span><span class="pln"> </span><span class="typ">SelectListItem</span><span class="pun">();</span><span class="pln"> s</span><span class="pun">.</span><span class="typ">Text</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> e</span><span class="pun">.</span><span class="typ">Mname</span><span class="pun">;</span><span class="pln"> s</span><span class="pun">.</span><span class="typ">Value</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> e</span><span class="pun">.</span><span class="pln">MID</span><span class="pun">.</span><span class="typ">ToString</span><span class="pun">();</span><span class="pln"> manufacturenames</span><span class="pun">.</span><span class="typ">Add</span><span class="pun">(</span><span class="pln">s</span><span class="pun">);</span><span class="pln"> </span><span class="pun">}</span><span class="pln"> </span><span class="kwd">return</span><span class="pln"> manufacturenames</span><span class="pun">;</span><span class="pln"> </span><span class="pun">}</span><span class="pln"> </span>
File Name: HomeController.cs
This is a ActionResult contoller which fetch the data from the aa_ManufacturerMaster_1637935
table which loading the page for that this is a [HttpGet]
<span class="pln"> </span><span class="pun">[</span><span class="typ">HttpGet</span><span class="pun">]</span><span class="pln"> </span><span class="kwd">public</span><span class="pln"> </span><span class="typ">ActionResult</span><span class="pln"> </span><span class="typ">AddAsset</span><span class="pun">()</span><span class="pln"> </span><span class="pun">{</span><span class="pln"> </span><span class="typ">List</span><span class="pun"><</span><span class="typ">SelectListItem</span><span class="pun">></span><span class="pln"> ddlistvalues </span><span class="pun">=</span><span class="pln"> </span><span class="kwd">new</span><span class="pln"> </span><span class="typ">List</span><span class="pun"><</span><span class="typ">SelectListItem</span><span class="pun">>();</span><span class="pln"> ddlistvalues </span><span class="pun">=</span><span class="pln"> populateddlist_Manufacture</span><span class="pun">();</span><span class="pln"> aa_AssetMaster_1637935 manufectureobj </span><span class="pun">=</span><span class="pln"> </span><span class="kwd">new</span><span class="pln"> aa_AssetMaster_1637935</span><span class="pun">();</span><span class="pln"> manufectureobj</span><span class="pun">.</span><span class="pln">namufactureName </span><span class="pun">=</span><span class="pln"> ddlistvalues</span><span class="pun">;</span><span class="pln"> </span><span class="kwd">return</span><span class="pln"> </span><span class="typ">View</span><span class="pun">(</span><span class="pln">manufectureobj</span><span class="pun">);</span><span class="pln"> </span><span class="pun">}</span><span class="pln"> </span>
File Name: HomeController.cs
This is a ActionResult contoller which controls the action of AddAsset. This is [HttpPost]
method.
<span class="pln"> </span><span class="pun">[</span><span class="typ">HttpPost</span><span class="pun">]</span><span class="pln"> </span><span class="kwd">public</span><span class="pln"> </span><span class="typ">ActionResult</span><span class="pln"> </span><span class="typ">AddAsset</span><span class="pun">(</span><span class="pln">aa_AssetMaster_1637935 assetObj</span><span class="pun">)</span><span class="pln"> </span><span class="pun">{</span><span class="pln"> </span><span class="kwd">if</span><span class="pln"> </span><span class="pun">(</span><span class="typ">ModelState</span><span class="pun">.</span><span class="typ">IsValid</span><span class="pun">)</span><span class="pln"> </span><span class="pun">{</span><span class="pln"> </span><span class="typ">ObjectParameter</span><span class="pln"> </span><span class="typ">AssetID</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> </span><span class="kwd">new</span><span class="pln"> </span><span class="typ">ObjectParameter</span><span class="pun">(</span><span class="str">"AssetID"</span><span class="pun">,</span><span class="pln"> </span><span class="kwd">typeof</span><span class="pun">(</span><span class="kwd">int</span><span class="pun">));</span><span class="pln"> assetObj</span><span class="pun">.</span><span class="typ">AllocationStatus</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> </span><span class="lit">0</span><span class="pun">;</span><span class="pln"> </span><span class="kwd">int</span><span class="pln"> rows </span><span class="pun">=</span><span class="pln"> dbObject</span><span class="pun">.</span><span class="pln">xx_sp_insert_AssetMaster</span><span class="pun">(</span><span class="pln">assetObj</span><span class="pun">.</span><span class="typ">AssetUniqueName</span><span class="pun">,</span><span class="pln"> assetObj</span><span class="pun">.</span><span class="typ">AssetType</span><span class="pun">,</span><span class="pln"> assetObj</span><span class="pun">.</span><span class="typ">ManufacturerID</span><span class="pun">,</span><span class="pln"> assetObj</span><span class="pun">.</span><span class="typ">AllocationStatus</span><span class="pun">,</span><span class="pln"> </span><span class="typ">AssetID</span><span class="pun">);</span><span class="pln"> </span><span class="kwd">if</span><span class="pln"> </span><span class="pun">(</span><span class="pln">rows </span><span class="pun">></span><span class="pln"> </span><span class="lit">0</span><span class="pun">)</span><span class="pln"> </span><span class="pun">{</span><span class="pln"> </span><span class="typ">TempData</span><span class="pun">[</span><span class="str">"Message"</span><span class="pun">]</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> </span><span class="str">"Inserted with id ="</span><span class="pln"> </span><span class="pun">+</span><span class="pln"> </span><span class="typ">AssetID</span><span class="pun">.</span><span class="typ">Value</span><span class="pun">.</span><span class="typ">ToString</span><span class="pun">();</span><span class="pln"> </span><span class="kwd">return</span><span class="pln"> </span><span class="typ">RedirectToAction</span><span class="pun">(</span><span class="str">"AddAllocation"</span><span class="pun">);</span><span class="pln"> </span><span class="pun">}</span><span class="pln"> </span><span class="typ">List</span><span class="pun"><</span><span class="typ">SelectListItem</span><span class="pun">></span><span class="pln"> ddlistvalues </span><span class="pun">=</span><span class="pln"> </span><span class="kwd">new</span><span class="pln"> </span><span class="typ">List</span><span class="pun"><</span><span class="typ">SelectListItem</span><span class="pun">>();</span><span class="pln"> ddlistvalues </span><span class="pun">=</span><span class="pln"> populateddlist_Manufacture</span><span class="pun">();</span><span class="pln"> aa_AssetMaster_1637935 manufectureobj </span><span class="pun">=</span><span class="pln"> </span><span class="kwd">new</span><span class="pln"> aa_AssetMaster_1637935</span><span class="pun">();</span><span class="pln"> manufectureobj</span><span class="pun">.</span><span class="pln">namufactureName </span><span class="pun">=</span><span class="pln"> ddlistvalues</span><span class="pun">;</span><span class="pln"> </span><span class="kwd">return</span><span class="pln"> </span><span class="typ">View</span><span class="pun">(</span><span class="pln">manufectureobj</span><span class="pun">);</span><span class="pln"> </span><span class="pun">}</span><span class="pln"> </span><span class="kwd">else</span><span class="pln"> </span><span class="pun">{</span><span class="pln"> </span><span class="kwd">return</span><span class="pln"> </span><span class="typ">View</span><span class="pun">();</span><span class="pln"> </span><span class="pun">}</span><span class="pln"> </span><span class="pun">}</span><span class="pln"> </span>
File Name: AddAsset.cshtml
This is view page where we are are getting the Mname (Manufacture name) through the MID (Manufacture id) in a drop down list.
<span class="pln"> </span><span class="lit">@model</span><span class="pln"> </span><span class="typ">MVCAssetManagementSystem</span><span class="pun">.</span><span class="typ">Models</span><span class="pun">.</span><span class="pln">aa_AssetMaster_1637935 </span><span class="pun">@{</span><span class="pln"> </span><span class="typ">ViewBag</span><span class="pun">.</span><span class="typ">Title</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> </span><span class="str">"AddAsset"</span><span class="pun">;</span><span class="pln"> </span><span class="pun">}</span><span class="pln"> </span><span class="str"><h2></span><span class="typ">AddAsset</span><span class="pun"></</span><span class="pln">h2</span><span class="pun">></span><span class="pln"> </span><span class="pun">@{</span><span class="pln"> </span><span class="typ">List</span><span class="pun"><</span><span class="typ">SelectListItem</span><span class="pun">></span><span class="pln"> list1 </span><span class="pun">=</span><span class="pln"> </span><span class="kwd">new</span><span class="pln"> </span><span class="typ">List</span><span class="pun"><</span><span class="typ">SelectListItem</span><span class="pun">>();</span><span class="pln"> list1</span><span class="pun">.</span><span class="typ">Add</span><span class="pun">(</span><span class="kwd">new</span><span class="pln"> </span><span class="typ">SelectListItem</span><span class="pln"> </span><span class="pun">{</span><span class="pln"> </span><span class="typ">Text</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> </span><span class="str">"Laptop"</span><span class="pun">,</span><span class="pln"> </span><span class="typ">Value</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> </span><span class="str">"Laptop"</span><span class="pun">,</span><span class="pln"> </span><span class="pun">});</span><span class="pln"> list1</span><span class="pun">.</span><span class="typ">Add</span><span class="pun">(</span><span class="kwd">new</span><span class="pln"> </span><span class="typ">SelectListItem</span><span class="pln"> </span><span class="pun">{</span><span class="pln"> </span><span class="typ">Text</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> </span><span class="str">"Desktop"</span><span class="pun">,</span><span class="pln"> </span><span class="typ">Value</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> </span><span class="str">"Desktop"</span><span class="pun">,</span><span class="pln"> </span><span class="pun">});</span><span class="pln"> </span><span class="com">//List<SelectListItem> list2 = new List<SelectListItem>();</span><span class="pln"> </span><span class="com">//list2.Add(new SelectListItem</span><span class="pln"> </span><span class="com">//{</span><span class="pln"> </span><span class="com">// Text = "Un Allocated",</span><span class="pln"> </span><span class="com">// Value = "0",</span><span class="pln"> </span><span class="com">//});</span><span class="pln"> </span><span class="com">//list2.Add(new SelectListItem</span><span class="pln"> </span><span class="com">//{</span><span class="pln"> </span><span class="com">// Text = "Allocated",</span><span class="pln"> </span><span class="com">// Value = "1",</span><span class="pln"> </span><span class="com">//});</span><span class="pln"> </span><span class="pun">}</span><span class="pln"> </span><span class="lit">@using</span><span class="pln"> </span><span class="pun">(</span><span class="typ">Html</span><span class="pun">.</span><span class="typ">BeginForm</span><span class="pun">())</span><span class="pln"> </span><span class="pun">{</span><span class="pln"> </span><span class="lit">@Html</span><span class="pun">.</span><span class="typ">AntiForgeryToken</span><span class="pun">()</span><span class="pln"> </span><span class="pun"><</span><span class="pln">div </span><span class="kwd">class</span><span class="pun">=</span><span class="str">"form-horizontal"</span><span class="pun">></span><span class="pln"> </span><span class="str"><div></span><span class="pln"> </span><span class="lit">@Html</span><span class="pun">.</span><span class="typ">ActionLink</span><span class="pun">(</span><span class="str">"AddAsset"</span><span class="pun">,</span><span class="pln"> </span><span class="str">"AddAsset"</span><span class="pun">)</span><span class="pln"> </span><span class="str"><br></span><span class="pln"> </span><span class="lit">@Html</span><span class="pun">.</span><span class="typ">ActionLink</span><span class="pun">(</span><span class="str">"AddAllocation"</span><span class="pun">,</span><span class="pln"> </span><span class="str">"AddAllocation"</span><span class="pun">)</span><span class="pln"> </span><span class="pun"></</span><span class="pln">div</span><span class="pun">></span><span class="pln"> </span><span class="str"><h4></span><span class="pln">aa_AssetMaster_1637935</span><span class="pun"></</span><span class="pln">h4</span><span class="pun">></span><span class="pln"> </span><span class="pun"><</span><span class="pln">hr </span><span class="pun">/></span><span class="pln"> </span><span class="lit">@Html</span><span class="pun">.</span><span class="typ">ValidationSummary</span><span class="pun">(</span><span class="kwd">true</span><span class="pun">,</span><span class="pln"> </span><span class="str">""</span><span class="pun">,</span><span class="pln"> </span><span class="kwd">new</span><span class="pln"> </span><span class="pun">{</span><span class="pln"> </span><span class="lit">@class</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> </span><span class="str">"text-danger"</span><span class="pln"> </span><span class="pun">})</span><span class="pln"> </span><span class="pun"><</span><span class="pln">div </span><span class="kwd">class</span><span class="pun">=</span><span class="str">"form-group"</span><span class="pun">></span><span class="pln"> </span><span class="lit">@Html</span><span class="pun">.</span><span class="typ">LabelFor</span><span class="pun">(</span><span class="pln">model </span><span class="pun">=></span><span class="pln"> model</span><span class="pun">.</span><span class="typ">AssetUniqueName</span><span class="pun">,</span><span class="pln"> htmlAttributes</span><span class="pun">:</span><span class="pln"> </span><span class="kwd">new</span><span class="pln"> </span><span class="pun">{</span><span class="pln"> </span><span class="lit">@class</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> </span><span class="str">"control-label col-md-2"</span><span class="pln"> </span><span class="pun">})</span><span class="pln"> </span><span class="pun"><</span><span class="pln">div </span><span class="kwd">class</span><span class="pun">=</span><span class="str">"col-md-10"</span><span class="pun">></span><span class="pln"> </span><span class="lit">@Html</span><span class="pun">.</span><span class="typ">EditorFor</span><span class="pun">(</span><span class="pln">model </span><span class="pun">=></span><span class="pln"> model</span><span class="pun">.</span><span class="typ">AssetUniqueName</span><span class="pun">,</span><span class="pln"> </span><span class="kwd">new</span><span class="pln"> </span><span class="pun">{</span><span class="pln"> htmlAttributes </span><span class="pun">=</span><span class="pln"> </span><span class="kwd">new</span><span class="pln"> </span><span class="pun">{</span><span class="pln"> </span><span class="lit">@class</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> </span><span class="str">"form-control"</span><span class="pln"> </span><span class="pun">}</span><span class="pln"> </span><span class="pun">})</span><span class="pln"> </span><span class="lit">@Html</span><span class="pun">.</span><span class="typ">ValidationMessageFor</span><span class="pun">(</span><span class="pln">model </span><span class="pun">=></span><span class="pln"> model</span><span class="pun">.</span><span class="typ">AssetUniqueName</span><span class="pun">,</span><span class="pln"> </span><span class="str">""</span><span class="pun">,</span><span class="pln"> </span><span class="kwd">new</span><span class="pln"> </span><span class="pun">{</span><span class="pln"> </span><span class="lit">@class</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> </span><span class="str">"text-danger"</span><span class="pln"> </span><span class="pun">})</span><span class="pln"> </span><span class="pun"></</span><span class="pln">div</span><span class="pun">></span><span class="pln"> </span><span class="pun"></</span><span class="pln">div</span><span class="pun">></span><span class="pln"> </span><span class="pun"><</span><span class="pln">div </span><span class="kwd">class</span><span class="pun">=</span><span class="str">"form-group"</span><span class="pun">></span><span class="pln"> </span><span class="lit">@Html</span><span class="pun">.</span><span class="typ">LabelFor</span><span class="pun">(</span><span class="pln">model </span><span class="pun">=></span><span class="pln"> model</span><span class="pun">.</span><span class="typ">AssetType</span><span class="pun">,</span><span class="pln"> htmlAttributes</span><span class="pun">:</span><span class="pln"> </span><span class="kwd">new</span><span class="pln"> </span><span class="pun">{</span><span class="pln"> </span><span class="lit">@class</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> </span><span class="str">"control-label col-md-2"</span><span class="pln"> </span><span class="pun">})</span><span class="pln"> </span><span class="pun"><</span><span class="pln">div </span><span class="kwd">class</span><span class="pun">=</span><span class="str">"col-md-10"</span><span class="pun">></span><span class="pln"> </span><span class="pun">@*</span><span class="lit">@Html</span><span class="pun">.</span><span class="typ">EditorFor</span><span class="pun">(</span><span class="pln">model </span><span class="pun">=></span><span class="pln"> model</span><span class="pun">.</span><span class="typ">AssetType</span><span class="pun">,</span><span class="pln"> </span><span class="kwd">new</span><span class="pln"> </span><span class="pun">{</span><span class="pln"> htmlAttributes </span><span class="pun">=</span><span class="pln"> </span><span class="kwd">new</span><span class="pln"> </span><span class="pun">{</span><span class="pln"> </span><span class="lit">@class</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> </span><span class="str">"form-control"</span><span class="pln"> </span><span class="pun">}</span><span class="pln"> </span><span class="pun">})*@</span><span class="pln"> </span><span class="typ">Laptop</span><span class="pln"> </span><span class="lit">@Html</span><span class="pun">.</span><span class="typ">RadioButtonFor</span><span class="pun">(</span><span class="pln">model </span><span class="pun">=></span><span class="pln"> model</span><span class="pun">.</span><span class="typ">AssetType</span><span class="pun">,</span><span class="pln"> </span><span class="str">"Lapto"</span><span class="pun">)</span><span class="pln"> </span><span class="typ">Desktop</span><span class="pln"> </span><span class="lit">@Html</span><span class="pun">.</span><span class="typ">RadioButtonFor</span><span class="pun">(</span><span class="pln">model </span><span class="pun">=></span><span class="pln"> model</span><span class="pun">.</span><span class="typ">AssetType</span><span class="pun">,</span><span class="pln"> </span><span class="str">"Desktop"</span><span class="pun">)</span><span class="pln"> </span><span class="lit">@Html</span><span class="pun">.</span><span class="typ">ValidationMessageFor</span><span class="pun">(</span><span class="pln">model </span><span class="pun">=></span><span class="pln"> model</span><span class="pun">.</span><span class="typ">AssetType</span><span class="pun">,</span><span class="pln"> </span><span class="str">""</span><span class="pun">,</span><span class="pln"> </span><span class="kwd">new</span><span class="pln"> </span><span class="pun">{</span><span class="pln"> </span><span class="lit">@class</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> </span><span class="str">"text-danger"</span><span class="pln"> </span><span class="pun">})</span><span class="pln"> </span><span class="pun"></</span><span class="pln">div</span><span class="pun">></span><span class="pln"> </span><span class="pun"></</span><span class="pln">div</span><span class="pun">></span><span class="pln"> </span><span class="pun"><</span><span class="pln">div </span><span class="kwd">class</span><span class="pun">=</span><span class="str">"form-group"</span><span class="pun">></span><span class="pln"> </span><span class="lit">@Html</span><span class="pun">.</span><span class="typ">LabelFor</span><span class="pun">(</span><span class="pln">model </span><span class="pun">=></span><span class="pln"> model</span><span class="pun">.</span><span class="typ">ManufacturerID</span><span class="pun">,</span><span class="pln"> </span><span class="str">"ManufacturerID"</span><span class="pun">,</span><span class="pln"> htmlAttributes</span><span class="pun">:</span><span class="pln"> </span><span class="kwd">new</span><span class="pln"> </span><span class="pun">{</span><span class="pln"> </span><span class="lit">@class</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> </span><span class="str">"control-label col-md-2"</span><span class="pln"> </span><span class="pun">})</span><span class="pln"> </span><span class="pun"><</span><span class="pln">div </span><span class="kwd">class</span><span class="pun">=</span><span class="str">"col-md-10"</span><span class="pun">></span><span class="pln"> </span><span class="pun">@*</span><span class="lit">@Html</span><span class="pun">.</span><span class="typ">DropDownList</span><span class="pun">(</span><span class="str">"ManufacturerID"</span><span class="pun">,</span><span class="pln"> </span><span class="kwd">null</span><span class="pun">,</span><span class="pln"> htmlAttributes</span><span class="pun">:</span><span class="pln"> </span><span class="kwd">new</span><span class="pln"> </span><span class="pun">{</span><span class="pln"> </span><span class="lit">@class</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> </span><span class="str">"form-control"</span><span class="pln"> </span><span class="pun">})*@</span><span class="pln"> </span><span class="lit">@Html</span><span class="pun">.</span><span class="typ">DropDownListFor</span><span class="pun">(</span><span class="pln">model </span><span class="pun">=></span><span class="pln"> model</span><span class="pun">.</span><span class="typ">ManufacturerID</span><span class="pun">,</span><span class="pln"> </span><span class="typ">Model</span><span class="pun">.</span><span class="pln">namufactureName</span><span class="pun">,</span><span class="pln"> </span><span class="str">"--Select Manufacture Name--"</span><span class="pun">)</span><span class="pln"> </span><span class="lit">@Html</span><span class="pun">.</span><span class="typ">ValidationMessageFor</span><span class="pun">(</span><span class="pln">model </span><span class="pun">=></span><span class="pln"> model</span><span class="pun">.</span><span class="typ">ManufacturerID</span><span class="pun">,</span><span class="pln"> </span><span class="str">""</span><span class="pun">,</span><span class="pln"> </span><span class="kwd">new</span><span class="pln"> </span><span class="pun">{</span><span class="pln"> </span><span class="lit">@class</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> </span><span class="str">"text-danger"</span><span class="pln"> </span><span class="pun">})</span><span class="pln"> </span><span class="pun"></</span><span class="pln">div</span><span class="pun">></span><span class="pln"> </span><span class="pun"></</span><span class="pln">div</span><span class="pun">></span><span class="pln"> </span><span class="pun">@*<</span><span class="pln">div </span><span class="kwd">class</span><span class="pun">=</span><span class="str">"form-group"</span><span class="pun">></span><span class="pln"> </span><span class="lit">@Html</span><span class="pun">.</span><span class="typ">LabelFor</span><span class="pun">(</span><span class="pln">model </span><span class="pun">=></span><span class="pln"> model</span><span class="pun">.</span><span class="typ">AllocationStatus</span><span class="pun">,</span><span class="pln"> htmlAttributes</span><span class="pun">:</span><span class="pln"> </span><span class="kwd">new</span><span class="pln"> </span><span class="pun">{</span><span class="pln"> </span><span class="lit">@class</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> </span><span class="str">"control-label col-md-2"</span><span class="pln"> </span><span class="pun">})</span><span class="pln"> </span><span class="pun"><</span><span class="pln">div </span><span class="kwd">class</span><span class="pun">=</span><span class="str">"col-md-10"</span><span class="pun">></span><span class="pln"> </span><span class="com">// @Html.EditorFor(model => model.AllocationStatus, new { htmlAttributes = new { @class = "form-control" } })</span><span class="pln"> </span><span class="lit">@Html</span><span class="pun">.</span><span class="typ">DropDownListFor</span><span class="pun">(</span><span class="pln">model </span><span class="pun">=></span><span class="pln"> model</span><span class="pun">.</span><span class="typ">AllocationStatus</span><span class="pun">,</span><span class="pln"> list2</span><span class="pun">)</span><span class="pln"> </span><span class="lit">@Html</span><span class="pun">.</span><span class="typ">ValidationMessageFor</span><span class="pun">(</span><span class="pln">model </span><span class="pun">=></span><span class="pln"> model</span><span class="pun">.</span><span class="typ">AllocationStatus</span><span class="pun">,</span><span class="pln"> </span><span class="str">""</span><span class="pun">,</span><span class="pln"> </span><span class="kwd">new</span><span class="pln"> </span><span class="pun">{</span><span class="pln"> </span><span class="lit">@class</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> </span><span class="str">"text-danger"</span><span class="pln"> </span><span class="pun">})</span><span class="pln"> </span><span class="pun"></</span><span class="pln">div</span><span class="pun">></span><span class="pln"> </span><span class="pun"></</span><span class="pln">div</span><span class="pun">>*@</span><span class="pln"> </span><span class="pun"><</span><span class="pln">div </span><span class="kwd">class</span><span class="pun">=</span><span class="str">"form-group"</span><span class="pun">></span><span class="pln"> </span><span class="pun"><</span><span class="pln">div </span><span class="kwd">class</span><span class="pun">=</span><span class="str">"col-md-offset-2 col-md-10"</span><span class="pun">></span><span class="pln"> </span><span class="pun"><</span><span class="pln">input type</span><span class="pun">=</span><span class="str">"submit"</span><span class="pln"> </span><span class="kwd">value</span><span class="pun">=</span><span class="str">"Create"</span><span class="pln"> </span><span class="kwd">class</span><span class="pun">=</span><span class="str">"btn btn-default"</span><span class="pln"> </span><span class="pun">/></span><span class="pln"> </span><span class="pun"></</span><span class="pln">div</span><span class="pun">></span><span class="pln"> </span><span class="pun"></</span><span class="pln">div</span><span class="pun">></span><span class="pln"> </span><span class="pun"></</span><span class="pln">div</span><span class="pun">></span><span class="pln"> </span><span class="pun">}</span><span class="pln"> </span><span class="pun"><</span><span class="pln">div style</span><span class="pun">=</span><span class="str">"background-color:orange"</span><span class="pun">></span><span class="pln"> </span><span class="lit">@TempData</span><span class="pun">[</span><span class="str">"Message"</span><span class="pun">]</span><span class="pln"> </span><span class="pun"></</span><span class="pln">div</span><span class="pun">></span><span class="pln"> </span><span class="str"><div></span><span class="pln"> </span><span class="lit">@Html</span><span class="pun">.</span><span class="typ">ActionLink</span><span class="pun">(</span><span class="str">"Index page"</span><span class="pun">,</span><span class="pln"> </span><span class="str">"Index"</span><span class="pun">)</span><span class="pln"> </span><span class="str"><br></span><span class="pln"> </span><span class="lit">@Html</span><span class="pun">.</span><span class="typ">ActionLink</span><span class="pun">(</span><span class="str">"View Asset Allocation Details"</span><span class="pun">,</span><span class="pln"> </span><span class="str">"ViewAssetAllocationDetails"</span><span class="pun">)</span><span class="pln"> </span><span class="pun"></</span><span class="pln">div</span><span class="pun">></span><span class="pln"> </span><span class="pun"><</span><span class="pln">script src</span><span class="pun">=</span><span class="str">"~/Scripts/jquery-1.10.2.min.js"</span><span class="pun">></</span><span class="pln">script</span><span class="pun">></span><span class="pln"> </span><span class="pun"><</span><span class="pln">script src</span><span class="pun">=</span><span class="str">"~/Scripts/jquery.validate.min.js"</span><span class="pun">></</span><span class="pln">script</span><span class="pun">></span><span class="pln"> </span><span class="pun"><</span><span class="pln">script src</span><span class="pun">=</span><span class="str">"~/Scripts/jquery.validate.unobtrusive.min.js"</span><span class="pun">></</span><span class="pln">script</span><span class="pun">></span><span class="pln"> </span><span class="pun"><</span><span class="pln">script src</span><span class="pun">=</span><span class="str">"~/Scripts/MyScripts.js"</span><span class="pun">></</span><span class="pln">script</span><span class="pun">></span><span class="pln"> </span>
File Name:
<span class="pln"> </span>
File Name:
Aa the namufactureName properties not present in the second table it will throw an error in the
view page. so this issues can be fixed though an AssetMetaClass.cs which you have to create that class inside the Model folder.
<span class="pln"> </span><span class="kwd">using</span><span class="pln"> </span><span class="typ">System</span><span class="pun">;</span><span class="pln"> </span><span class="kwd">using</span><span class="pln"> </span><span class="typ">System</span><span class="pun">.</span><span class="typ">Collections</span><span class="pun">.</span><span class="typ">Generic</span><span class="pun">;</span><span class="pln"> </span><span class="kwd">using</span><span class="pln"> </span><span class="typ">System</span><span class="pun">.</span><span class="typ">ComponentModel</span><span class="pun">.</span><span class="typ">DataAnnotations</span><span class="pun">;</span><span class="pln"> </span><span class="kwd">using</span><span class="pln"> </span><span class="typ">System</span><span class="pun">.</span><span class="typ">Linq</span><span class="pun">;</span><span class="pln"> </span><span class="kwd">using</span><span class="pln"> </span><span class="typ">System</span><span class="pun">.</span><span class="typ">Web</span><span class="pun">;</span><span class="pln"> </span><span class="kwd">using</span><span class="pln"> </span><span class="typ">System</span><span class="pun">.</span><span class="typ">Web</span><span class="pun">.</span><span class="typ">Mvc</span><span class="pun">;</span><span class="pln"> </span><span class="kwd">namespace</span><span class="pln"> </span><span class="typ">MVCAssetManagementSystem</span><span class="pun">.</span><span class="typ">Models</span><span class="pln"> </span><span class="pun">{</span><span class="pln"> </span><span class="kwd">public</span><span class="pln"> </span><span class="kwd">class</span><span class="pln"> </span><span class="typ">AssetMetaClass</span><span class="pln"> </span><span class="pun">{</span><span class="pln"> </span><span class="pun">}</span><span class="pln"> </span><span class="pun">[</span><span class="typ">MetadataType</span><span class="pun">(</span><span class="kwd">typeof</span><span class="pun">(</span><span class="typ">AssetMetaClass</span><span class="pun">))]</span><span class="pln"> </span><span class="kwd">public</span><span class="pln"> </span><span class="kwd">partial</span><span class="pln"> </span><span class="kwd">class</span><span class="pln"> aa_AssetMaster_1637935 </span><span class="pun">{</span><span class="pln"> </span><span class="kwd">public</span><span class="pln"> </span><span class="typ">List</span><span class="pun"><</span><span class="typ">SelectListItem</span><span class="pun">></span><span class="pln"> namufactureName </span><span class="pun">{</span><span class="pln"> </span><span class="kwd">get</span><span class="pun">;</span><span class="pln"> </span><span class="kwd">set</span><span class="pun">;</span><span class="pln"> </span><span class="pun">}</span><span class="pln"> </span><span class="pun">}</span><span class="pln"> </span><span class="pun">}</span><span class="pln"> </span>
