MVC .NET View, Insert, Update and Delete using Database
Question
The admin of a golf club has a requirement for an application which will help him manage the members of the club.
Create the tables in the following DB Create the following tables . Server -myserver User ID – yourid Password – yourpassword Database – yourdatabase
Table 1: tbl_Club<empid>
| Columns | Description |
| ClubID | ClubLocation |
| Should be auto generated | Location of the Club |
Insert the following data into the above table using only STORED PROCEDURE.
| ClubID | ClubLocation |
| 1001 | Trivandrum |
| 1002 | Kochi |
| 1003 | Calicut |
| 1004 | Paala |
Table 2: tbl_Member<empID>
| Columns | Description |
| MemberID | Should be auto generated |
| MemberName | Name of the Member |
| Gender | Gender ( use radiobutton ) |
| MemberShipType | Platinum,Gold and Ordinary (Use DropDownList) |
| ClubID | This should be a foreign Key to the previous table and the values should be bound as dropdown from the previous table. |
Create an MVC application with EF for the below operations :
Crud Operation 1 : Register Member
The Admin should be able to register new members in the club. Create a web page which is used to register the member and on click of submit button need to show a pop up message with success message and memberid. The available club id should be displayed to the admin in a dropdown list for registration.
Crud Operation 2 : View and Remove Member
The user should be able to view the memberid, membername and clublocation in a webgrid or table. These columns should be joined from two tables using SQL joins. There should be a button named 'Remove' which will delete the member from the database after getting confirmation from the user.
Solution
SQL SERVER OPERATIONS
Database used
<span class="pln"> USE DB02TEST01</span><span class="pun">;</span><span class="pln"> </span>
Table creation and insert data
<span class="pln"> CREATE TABLE aa_tbl_Club_1637935</span><span class="pun">(</span><span class="pln"> </span><span class="typ">ClubID</span><span class="pln"> INT PRIMARY KEY IDENTITY</span><span class="pun">(</span><span class="lit">1001</span><span class="pun">,</span><span class="lit">1</span><span class="pun">),</span><span class="pln"> </span><span class="typ">ClubLocation</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"> SELECT </span><span class="pun">*</span><span class="pln"> FROM aa_tbl_Club_1637935 INSERT INTO aa_tbl_Club_1637935 VALUES </span><span class="pun">(</span><span class="str">'Trivandrum'</span><span class="pun">),</span><span class="pln"> </span><span class="pun">(</span><span class="str">'Kochi'</span><span class="pun">),</span><span class="pln"> </span><span class="pun">(</span><span class="str">'Calicut'</span><span class="pun">),</span><span class="pln"> </span><span class="pun">(</span><span class="str">'Paala'</span><span class="pun">)</span><span class="pln"> </span>
Table creation and insert data
<span class="pln"> CREATE TABLE aa_bl_Member_16379</span><span class="pun">(</span><span class="pln"> </span><span class="typ">MemberID</span><span class="pln"> INT PRIMARY KEY IDENTITY</span><span class="pun">(</span><span class="lit">1</span><span class="pun">,</span><span class="lit">1</span><span class="pun">),</span><span class="pln"> </span><span class="typ">MemberName</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">Gender</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">MemberShipType</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">ClubID</span><span class="pln"> INT CONSTRAINT FK_club_Id FOREIGN KEY </span><span class="pun">(</span><span class="typ">ClubID</span><span class="pun">)</span><span class="pln"> REFERENCES tbl_Club_1637935</span><span class="pun">(</span><span class="typ">ClubID</span><span class="pun">)</span><span class="pln"> </span><span class="pun">)</span><span class="pln"> SELECT </span><span class="pun">*</span><span class="pln"> FROM aa_bl_Member_16379 INSERT INTO aa_bl_Member_16379 VALUES </span><span class="pun">(</span><span class="str">'Rumman Ansari'</span><span class="pun">,</span><span class="str">'Male'</span><span class="pun">,</span><span class="str">'Gold'</span><span class="pun">,</span><span class="lit">1001</span><span class="pun">)</span><span class="pln"> </span>
Create Procedures for select data using joining
<span class="pln"> </span><span class="com">// without joining</span><span class="pln"> ALTER PROCEDURE sp_select_bl_Member_16379 AS </span><span class="kwd">BEGIN</span><span class="pln"> SELECT </span><span class="pun">*</span><span class="pln"> FROM aa_bl_Member_16379 </span><span class="kwd">END</span><span class="pln"> </span><span class="com">// with joining</span><span class="pln"> ALTER PROCEDURE aa_sp_select_bl_Member_16379 AS </span><span class="kwd">BEGIN</span><span class="pln"> SELECT bl</span><span class="pun">.</span><span class="typ">MemberID</span><span class="pun">,</span><span class="pln"> bl</span><span class="pun">.</span><span class="typ">MemberName</span><span class="pun">,</span><span class="pln"> cl</span><span class="pun">.</span><span class="typ">ClubLocation</span><span class="pln"> </span><span class="kwd">from</span><span class="pln"> aa_bl_Member_16379 </span><span class="kwd">as</span><span class="pln"> bl</span><span class="pun">,</span><span class="pln"> aa_tbl_Club_1637935 </span><span class="kwd">as</span><span class="pln"> cl </span><span class="kwd">where</span><span class="pln"> bl</span><span class="pun">.</span><span class="typ">ClubID</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> cl</span><span class="pun">.</span><span class="typ">ClubID</span><span class="pln"> </span><span class="kwd">group</span><span class="pln"> </span><span class="kwd">by</span><span class="pln"> bl</span><span class="pun">.</span><span class="typ">MemberID</span><span class="pun">,</span><span class="pln"> bl</span><span class="pun">.</span><span class="typ">MemberName</span><span class="pun">,</span><span class="pln"> cl</span><span class="pun">.</span><span class="typ">ClubLocation</span><span class="pln"> </span><span class="kwd">END</span><span class="pln"> </span><span class="com">// procedure for insertion </span><span class="pln"> ALTER PROCEDURE aa_sp_insert_bl_Member_16379 </span><span class="lit">@MemberName</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">@Gender</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">@MemberShipType</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">@ClubID</span><span class="pln"> INT</span><span class="pun">,</span><span class="pln"> </span><span class="lit">@MemberID</span><span class="pln"> INT OUT AS </span><span class="kwd">BEGIN</span><span class="pln"> INSERT INTO aa_bl_Member_16379 VALUES </span><span class="pun">(</span><span class="lit">@MemberName</span><span class="pun">,</span><span class="pln"> </span><span class="lit">@Gender</span><span class="pun">,</span><span class="pln"> </span><span class="lit">@MemberShipType</span><span class="pun">,</span><span class="pln"> </span><span class="lit">@ClubID</span><span class="pun">)</span><span class="pln"> SET </span><span class="lit">@MemberID</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><span class="com">// code for checking the insertion</span><span class="pln"> DECLARE </span><span class="lit">@MemberID</span><span class="pln"> INT EXEC aa_sp_insert_bl_Member_16379 </span><span class="str">'A1 Ansari'</span><span class="pun">,</span><span class="str">'Male'</span><span class="pun">,</span><span class="str">'Gold'</span><span class="pun">,</span><span class="lit">1002</span><span class="pun">,</span><span class="pln"> </span><span class="lit">@MemberID</span><span class="pln"> OUT PRINT </span><span class="lit">@MemberID</span><span class="pln"> </span><span class="com">// procedure for delete database record</span><span class="pln"> ALTER PROCEDURE aa_delete_bl_Member_16379 </span><span class="lit">@hello</span><span class="pln"> INT AS </span><span class="kwd">BEGIN</span><span class="pln"> DELETE FROM aa_bl_Member_16379 WHERE </span><span class="typ">MemberID</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> </span><span class="lit">@hello</span><span class="pln"> </span><span class="kwd">END</span><span class="pln"> EXEC aa_delete_bl_Member_16379 </span><span class="lit">6</span><span class="pln"> </span><span class="com">// procedure for update the database</span><span class="pln"> CREATE PROCEDURE aa_update_sp_aa_bl_Member_16379 </span><span class="lit">@MemberName</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">@Gender</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">@MemberShipType</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">@ClubID</span><span class="pln"> INT</span><span class="pun">,</span><span class="pln"> </span><span class="lit">@MemberID</span><span class="pln"> INT AS </span><span class="kwd">BEGIN</span><span class="pln"> UPDATE aa_bl_Member_16379 SET </span><span class="typ">MemberName</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> </span><span class="lit">@MemberName</span><span class="pun">,</span><span class="pln"> </span><span class="typ">Gender</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> </span><span class="lit">@Gender</span><span class="pun">,</span><span class="pln"> </span><span class="typ">MemberShipType</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> </span><span class="lit">@MemberShipType</span><span class="pln"> </span><span class="pun">,</span><span class="pln"> </span><span class="typ">ClubID</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> </span><span class="lit">@ClubID</span><span class="pln"> WHERE </span><span class="typ">MemberID</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> </span><span class="lit">@MemberID</span><span class="pln"> </span><span class="kwd">END</span><span class="pln"> </span>
.NET CODE
RouteConfig
<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">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">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">Routing</span><span class="pun">;</span><span class="pln"> </span><span class="kwd">namespace</span><span class="pln"> </span><span class="typ">GolfWebApplication</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">RouteConfig</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">static</span><span class="pln"> </span><span class="kwd">void</span><span class="pln"> </span><span class="typ">RegisterRoutes</span><span class="pun">(</span><span class="typ">RouteCollection</span><span class="pln"> routes</span><span class="pun">)</span><span class="pln"> </span><span class="pun">{</span><span class="pln"> routes</span><span class="pun">.</span><span class="typ">IgnoreRoute</span><span class="pun">(</span><span class="str">"{resource}.axd/{*pathInfo}"</span><span class="pun">);</span><span class="pln"> routes</span><span class="pun">.</span><span class="typ">MapRoute</span><span class="pun">(</span><span class="pln"> name</span><span class="pun">:</span><span class="pln"> </span><span class="str">"Default"</span><span class="pun">,</span><span class="pln"> url</span><span class="pun">:</span><span class="pln"> </span><span class="str">"{controller}/{action}/{id}"</span><span class="pun">,</span><span class="pln"> defaults</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"> controller </span><span class="pun">=</span><span class="pln"> </span><span class="str">"Home"</span><span class="pun">,</span><span class="pln"> action </span><span class="pun">=</span><span class="pln"> </span><span class="str">"Index"</span><span class="pun">,</span><span class="pln"> id </span><span class="pun">=</span><span class="pln"> </span><span class="typ">UrlParameter</span><span class="pun">.</span><span class="typ">Optional</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><span class="pun">}</span><span class="pln"> </span><span class="pun">}</span><span class="pln"> </span>
DB02TEST01Entities
This is database connection part
<span class="pln"> </span><span class="com">//------------------------------------------------------------------------------</span><span class="pln"> </span><span class="com">// <auto-generated></span><span class="pln"> </span><span class="com">// This code was generated from a template.</span><span class="pln"> </span><span class="com">//</span><span class="pln"> </span><span class="com">// Manual changes to this file may cause unexpected behavior in your application.</span><span class="pln"> </span><span class="com">// Manual changes to this file will be overwritten if the code is regenerated.</span><span class="pln"> </span><span class="com">// </auto-generated></span><span class="pln"> </span><span class="com">//------------------------------------------------------------------------------</span><span class="pln"> </span><span class="kwd">namespace</span><span class="pln"> </span><span class="typ">GolfWebApplication</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">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">Data</span><span class="pun">.</span><span class="typ">Entity</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">Data</span><span class="pun">.</span><span class="typ">Entity</span><span class="pun">.</span><span class="typ">Infrastructure</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">Data</span><span class="pun">.</span><span class="typ">Entity</span><span class="pun">.</span><span class="typ">Core</span><span class="pun">.</span><span class="typ">Objects</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">public</span><span class="pln"> </span><span class="kwd">partial</span><span class="pln"> </span><span class="kwd">class</span><span class="pln"> DB02TEST01Entities </span><span class="pun">:</span><span class="pln"> </span><span class="typ">DbContext</span><span class="pln"> </span><span class="pun">{</span><span class="pln"> </span><span class="kwd">public</span><span class="pln"> DB02TEST01Entities</span><span class="pun">()</span><span class="pln"> </span><span class="pun">:</span><span class="pln"> </span><span class="kwd">base</span><span class="pun">(</span><span class="str">"name=DB02TEST01Entities"</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="kwd">protected</span><span class="pln"> </span><span class="kwd">override</span><span class="pln"> </span><span class="kwd">void</span><span class="pln"> </span><span class="typ">OnModelCreating</span><span class="pun">(</span><span class="typ">DbModelBuilder</span><span class="pln"> modelBuilder</span><span class="pun">)</span><span class="pln"> </span><span class="pun">{</span><span class="pln"> </span><span class="kwd">throw</span><span class="pln"> </span><span class="kwd">new</span><span class="pln"> </span><span class="typ">UnintentionalCodeFirstException</span><span class="pun">();</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">virtual</span><span class="pln"> </span><span class="typ">DbSet</span><span class="str"><aa_bl_Member_16379></span><span class="pln"> aa_bl_Member_16379 </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="kwd">public</span><span class="pln"> </span><span class="kwd">virtual</span><span class="pln"> </span><span class="typ">DbSet</span><span class="str"><aa_tbl_Club_1637935></span><span class="pln"> aa_tbl_Club_1637935 </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="kwd">public</span><span class="pln"> </span><span class="kwd">virtual</span><span class="pln"> </span><span class="kwd">int</span><span class="pln"> aa_sp_insert_bl_Member_16379</span><span class="pun">(</span><span class="kwd">string</span><span class="pln"> memberName</span><span class="pun">,</span><span class="pln"> </span><span class="kwd">string</span><span class="pln"> gender</span><span class="pun">,</span><span class="pln"> </span><span class="kwd">string</span><span class="pln"> memberShipType</span><span class="pun">,</span><span class="pln"> </span><span class="typ">Nullable</span><span class="str"><int></span><span class="pln"> clubID</span><span class="pun">,</span><span class="pln"> </span><span class="typ">ObjectParameter</span><span class="pln"> memberID</span><span class="pun">)</span><span class="pln"> </span><span class="pun">{</span><span class="pln"> </span><span class="kwd">var</span><span class="pln"> memberNameParameter </span><span class="pun">=</span><span class="pln"> memberName </span><span class="pun">!=</span><span class="pln"> </span><span class="kwd">null</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">"MemberName"</span><span class="pun">,</span><span class="pln"> memberName</span><span class="pun">)</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">"MemberName"</span><span class="pun">,</span><span class="pln"> </span><span class="kwd">typeof</span><span class="pun">(</span><span class="kwd">string</span><span class="pun">));</span><span class="pln"> </span><span class="kwd">var</span><span class="pln"> genderParameter </span><span class="pun">=</span><span class="pln"> gender </span><span class="pun">!=</span><span class="pln"> </span><span class="kwd">null</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">"Gender"</span><span class="pun">,</span><span class="pln"> gender</span><span class="pun">)</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">"Gender"</span><span class="pun">,</span><span class="pln"> </span><span class="kwd">typeof</span><span class="pun">(</span><span class="kwd">string</span><span class="pun">));</span><span class="pln"> </span><span class="kwd">var</span><span class="pln"> memberShipTypeParameter </span><span class="pun">=</span><span class="pln"> memberShipType </span><span class="pun">!=</span><span class="pln"> </span><span class="kwd">null</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">"MemberShipType"</span><span class="pun">,</span><span class="pln"> memberShipType</span><span class="pun">)</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">"MemberShipType"</span><span class="pun">,</span><span class="pln"> </span><span class="kwd">typeof</span><span class="pun">(</span><span class="kwd">string</span><span class="pun">));</span><span class="pln"> </span><span class="kwd">var</span><span class="pln"> clubIDParameter </span><span class="pun">=</span><span class="pln"> clubID</span><span class="pun">.</span><span class="typ">HasValue</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">"ClubID"</span><span class="pun">,</span><span class="pln"> clubID</span><span class="pun">)</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">"ClubID"</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"> </span><span class="kwd">return</span><span class="pln"> </span><span class="pun">((</span><span class="typ">IObjectContextAdapter</span><span class="pun">)</span><span class="kwd">this</span><span class="pun">).</span><span class="typ">ObjectContext</span><span class="pun">.</span><span class="typ">ExecuteFunction</span><span class="pun">(</span><span class="str">"aa_sp_insert_bl_Member_16379"</span><span class="pun">,</span><span class="pln"> memberNameParameter</span><span class="pun">,</span><span class="pln"> genderParameter</span><span class="pun">,</span><span class="pln"> memberShipTypeParameter</span><span class="pun">,</span><span class="pln"> clubIDParameter</span><span class="pun">,</span><span class="pln"> memberID</span><span class="pun">);</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">virtual</span><span class="pln"> </span><span class="typ">ObjectResult</span><span class="str"><aa_sp_select_bl_Member_16379_Result></span><span class="pln"> aa_sp_select_bl_Member_16379</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"> </span><span class="pun">((</span><span class="typ">IObjectContextAdapter</span><span class="pun">)</span><span class="kwd">this</span><span class="pun">).</span><span class="typ">ObjectContext</span><span class="pun">.</span><span class="typ">ExecuteFunction</span><span class="str"><aa_sp_select_bl_Member_16379_Result></span><span class="pun">(</span><span class="str">"aa_sp_select_bl_Member_16379"</span><span class="pun">);</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">virtual</span><span class="pln"> </span><span class="kwd">int</span><span class="pln"> aa_delete_bl_Member_16379</span><span class="pun">(</span><span class="typ">Nullable</span><span class="str"><int></span><span class="pln"> hello</span><span class="pun">)</span><span class="pln"> </span><span class="pun">{</span><span class="pln"> </span><span class="kwd">var</span><span class="pln"> helloParameter </span><span class="pun">=</span><span class="pln"> hello</span><span class="pun">.</span><span class="typ">HasValue</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">"hello"</span><span class="pun">,</span><span class="pln"> hello</span><span class="pun">)</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">"hello"</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"> </span><span class="kwd">return</span><span class="pln"> </span><span class="pun">((</span><span class="typ">IObjectContextAdapter</span><span class="pun">)</span><span class="kwd">this</span><span class="pun">).</span><span class="typ">ObjectContext</span><span class="pun">.</span><span class="typ">ExecuteFunction</span><span class="pun">(</span><span class="str">"aa_delete_bl_Member_16379"</span><span class="pun">,</span><span class="pln"> helloParameter</span><span class="pun">);</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">virtual</span><span class="pln"> </span><span class="kwd">int</span><span class="pln"> aa_update_sp_aa_bl_Member_16379</span><span class="pun">(</span><span class="kwd">string</span><span class="pln"> memberName</span><span class="pun">,</span><span class="pln"> </span><span class="kwd">string</span><span class="pln"> gender</span><span class="pun">,</span><span class="pln"> </span><span class="kwd">string</span><span class="pln"> memberShipType</span><span class="pun">,</span><span class="pln"> </span><span class="typ">Nullable</span><span class="str"><int></span><span class="pln"> clubID</span><span class="pun">,</span><span class="pln"> </span><span class="typ">Nullable</span><span class="str"><int></span><span class="pln"> memberID</span><span class="pun">)</span><span class="pln"> </span><span class="pun">{</span><span class="pln"> </span><span class="kwd">var</span><span class="pln"> memberNameParameter </span><span class="pun">=</span><span class="pln"> memberName </span><span class="pun">!=</span><span class="pln"> </span><span class="kwd">null</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">"MemberName"</span><span class="pun">,</span><span class="pln"> memberName</span><span class="pun">)</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">"MemberName"</span><span class="pun">,</span><span class="pln"> </span><span class="kwd">typeof</span><span class="pun">(</span><span class="kwd">string</span><span class="pun">));</span><span class="pln"> </span><span class="kwd">var</span><span class="pln"> genderParameter </span><span class="pun">=</span><span class="pln"> gender </span><span class="pun">!=</span><span class="pln"> </span><span class="kwd">null</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">"Gender"</span><span class="pun">,</span><span class="pln"> gender</span><span class="pun">)</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">"Gender"</span><span class="pun">,</span><span class="pln"> </span><span class="kwd">typeof</span><span class="pun">(</span><span class="kwd">string</span><span class="pun">));</span><span class="pln"> </span><span class="kwd">var</span><span class="pln"> memberShipTypeParameter </span><span class="pun">=</span><span class="pln"> memberShipType </span><span class="pun">!=</span><span class="pln"> </span><span class="kwd">null</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">"MemberShipType"</span><span class="pun">,</span><span class="pln"> memberShipType</span><span class="pun">)</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">"MemberShipType"</span><span class="pun">,</span><span class="pln"> </span><span class="kwd">typeof</span><span class="pun">(</span><span class="kwd">string</span><span class="pun">));</span><span class="pln"> </span><span class="kwd">var</span><span class="pln"> clubIDParameter </span><span class="pun">=</span><span class="pln"> clubID</span><span class="pun">.</span><span class="typ">HasValue</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">"ClubID"</span><span class="pun">,</span><span class="pln"> clubID</span><span class="pun">)</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">"ClubID"</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"> </span><span class="kwd">var</span><span class="pln"> memberIDParameter </span><span class="pun">=</span><span class="pln"> memberID</span><span class="pun">.</span><span class="typ">HasValue</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">"MemberID"</span><span class="pun">,</span><span class="pln"> memberID</span><span class="pun">)</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">"MemberID"</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"> </span><span class="kwd">return</span><span class="pln"> </span><span class="pun">((</span><span class="typ">IObjectContextAdapter</span><span class="pun">)</span><span class="kwd">this</span><span class="pun">).</span><span class="typ">ObjectContext</span><span class="pun">.</span><span class="typ">ExecuteFunction</span><span class="pun">(</span><span class="str">"aa_update_sp_aa_bl_Member_16379"</span><span class="pun">,</span><span class="pln"> memberNameParameter</span><span class="pun">,</span><span class="pln"> genderParameter</span><span class="pun">,</span><span class="pln"> memberShipTypeParameter</span><span class="pun">,</span><span class="pln"> clubIDParameter</span><span class="pun">,</span><span class="pln"> memberIDParameter</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>
Controler part
<span class="pln"> </span><span class="kwd">using</span><span class="pln"> </span><span class="typ">GolfWebApplication</span><span class="pun">.</span><span class="typ">Models</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="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">Data</span><span class="pun">.</span><span class="typ">Entity</span><span class="pun">.</span><span class="typ">Core</span><span class="pun">.</span><span class="typ">Objects</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">Net</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">GolfWebApplication</span><span class="pun">.</span><span class="typ">Controllers</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">HomeController</span><span class="pln"> </span><span class="pun">:</span><span class="pln"> </span><span class="typ">Controller</span><span class="pln"> </span><span class="pun">{</span><span class="pln"> DB02TEST01Entities modelEntityObject </span><span class="pun">=</span><span class="pln"> </span><span class="kwd">new</span><span class="pln"> DB02TEST01Entities</span><span class="pun">();</span><span class="pln"> </span><span class="com">// GET: Home</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">Index</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_sp_select_bl_Member_16379_Result></span><span class="pln"> listObj </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_sp_select_bl_Member_16379_Result></span><span class="pun">();</span><span class="pln"> listObj </span><span class="pun">=</span><span class="pln"> modelEntityObject</span><span class="pun">.</span><span class="pln">aa_sp_select_bl_Member_16379</span><span class="pun">().</span><span class="typ">ToList</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">listObj</span><span class="pun">);</span><span class="pln"> </span><span class="pun">}</span><span class="pln"> </span><span class="com">// this code is much more important to get the data</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">AddMember</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"> </span><span class="typ">View</span><span class="pun">();</span><span class="pln"> </span><span class="pun">}</span><span class="pln"> </span><span class="com">// this code is used to add member in the database</span><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">AddMember</span><span class="pun">(</span><span class="pln">aa_bl_Member_16379 objMemberClass</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"> memberID </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">"memberID"</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"> </span><span class="kwd">int</span><span class="pln"> rows </span><span class="pun">=</span><span class="pln"> modelEntityObject</span><span class="pun">.</span><span class="pln">aa_sp_insert_bl_Member_16379</span><span class="pun">(</span><span class="pln">objMemberClass</span><span class="pun">.</span><span class="typ">MemberName</span><span class="pun">,</span><span class="pln"> objMemberClass</span><span class="pun">.</span><span class="typ">Gender</span><span class="pun">,</span><span class="pln"> objMemberClass</span><span class="pun">.</span><span class="typ">MemberShipType</span><span class="pun">,</span><span class="pln"> objMemberClass</span><span class="pun">.</span><span class="typ">ClubID</span><span class="pun">,</span><span class="pln"> memberID</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"> memberID</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">"Index"</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="typ">ViewBag</span><span class="pun">.</span><span class="typ">Message</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> </span><span class="str">" Sorry !! Insert Failed"</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><span class="com">// this code is used to delete the information from the database</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">Delete</span><span class="pun">(</span><span class="kwd">int</span><span class="pln"> id</span><span class="pun">)</span><span class="pln"> </span><span class="pun">{</span><span class="pln"> </span><span class="kwd">int</span><span class="pln"> rowsEffected</span><span class="pun">;</span><span class="pln"> </span><span class="typ">Response</span><span class="pun">.</span><span class="typ">Write</span><span class="pun">(</span><span class="str">"<script> confirm('Are you sure?')</script>"</span><span class="pun">);</span><span class="pln"> rowsEffected </span><span class="pun">=</span><span class="pln"> modelEntityObject</span><span class="pun">.</span><span class="pln">aa_delete_bl_Member_16379</span><span class="pun">(</span><span class="pln">id</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">rowsEffected </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">Response</span><span class="pun">.</span><span class="typ">Write</span><span class="pun">(</span><span class="str">"<script> alert('Deleted Successfully')</script>"</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"> </span><span class="typ">RedirectToAction</span><span class="pun">(</span><span class="str">"Index"</span><span class="pun">);</span><span class="pln"> </span><span class="pun">}</span><span class="pln"> </span><span class="com">// this code is used to edit the information and this is a get method to get the data </span><span class="pln"> </span><span class="com">// from database and it will render the data in the edit form</span><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">Edit</span><span class="pun">(</span><span class="kwd">int</span><span class="pln"> id</span><span class="pun">)</span><span class="pln"> </span><span class="pun">{</span><span class="pln"> aa_bl_Member_16379 member </span><span class="pun">=</span><span class="pln"> </span><span class="kwd">new</span><span class="pln"> aa_bl_Member_16379</span><span class="pun">();</span><span class="pln"> member </span><span class="pun">=</span><span class="pln"> modelEntityObject</span><span class="pun">.</span><span class="pln">aa_bl_Member_16379</span><span class="pun">.</span><span class="typ">Where</span><span class="pun">(</span><span class="pln">x </span><span class="pun">=></span><span class="pln"> x</span><span class="pun">.</span><span class="typ">MemberID</span><span class="pln"> </span><span class="pun">==</span><span class="pln"> id</span><span class="pun">).</span><span class="typ">FirstOrDefault</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">member</span><span class="pun">);</span><span class="pln"> </span><span class="pun">}</span><span class="pln"> </span><span class="com">// remember the below method is used to edit the data taken from the edit page</span><span class="pln"> </span><span class="com">// This is a post method as this is sending the updated data in the database</span><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">Edit</span><span class="pun">(</span><span class="pln">aa_bl_Member_16379 objMemberClass</span><span class="pun">)</span><span class="pln"> </span><span class="pun">{</span><span class="pln"> modelEntityObject</span><span class="pun">.</span><span class="pln">aa_update_sp_aa_bl_Member_16379</span><span class="pun">(</span><span class="pln">objMemberClass</span><span class="pun">.</span><span class="typ">MemberName</span><span class="pun">,</span><span class="pln"> objMemberClass</span><span class="pun">.</span><span class="typ">Gender</span><span class="pun">,</span><span class="pln"> objMemberClass</span><span class="pun">.</span><span class="typ">MemberShipType</span><span class="pun">,</span><span class="pln"> objMemberClass</span><span class="pun">.</span><span class="typ">ClubID</span><span class="pun">,</span><span class="pln"> objMemberClass</span><span class="pun">.</span><span class="typ">MemberID</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">"Index"</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>
Model Part
aa_bl_Member_16379
This code is autogenerated don't try to change this page. If you need to change then you have to do it by importing the data table into your project and refresh your project and rebuild it again.
<span class="pln"> </span><span class="com">//------------------------------------------------------------------------------</span><span class="pln"> </span><span class="com">// <auto-generated></span><span class="pln"> </span><span class="com">// This code was generated from a template.</span><span class="pln"> </span><span class="com">//</span><span class="pln"> </span><span class="com">// Manual changes to this file may cause unexpected behavior in your application.</span><span class="pln"> </span><span class="com">// Manual changes to this file will be overwritten if the code is regenerated.</span><span class="pln"> </span><span class="com">// </auto-generated></span><span class="pln"> </span><span class="com">//------------------------------------------------------------------------------</span><span class="pln"> </span><span class="kwd">namespace</span><span class="pln"> </span><span class="typ">GolfWebApplication</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">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">public</span><span class="pln"> </span><span class="kwd">partial</span><span class="pln"> </span><span class="kwd">class</span><span class="pln"> aa_bl_Member_16379 </span><span class="pun">{</span><span class="pln"> </span><span class="kwd">public</span><span class="pln"> </span><span class="kwd">int</span><span class="pln"> </span><span class="typ">MemberID</span><span class="pln"> </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="kwd">public</span><span class="pln"> </span><span class="kwd">string</span><span class="pln"> </span><span class="typ">MemberName</span><span class="pln"> </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="kwd">public</span><span class="pln"> </span><span class="kwd">string</span><span class="pln"> </span><span class="typ">Gender</span><span class="pln"> </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="kwd">public</span><span class="pln"> </span><span class="kwd">string</span><span class="pln"> </span><span class="typ">MemberShipType</span><span class="pln"> </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="kwd">public</span><span class="pln"> </span><span class="typ">Nullable</span><span class="str"><int></span><span class="pln"> </span><span class="typ">ClubID</span><span class="pln"> </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>
aa_sp_select_bl_Member_16379_Result
This code is autogenerated don't try to change this page. If you need to change then you have to do it by importing the data table into your project and refresh your project and rebuild it again.
<span class="pln"> </span><span class="com">//------------------------------------------------------------------------------</span><span class="pln"> </span><span class="com">// <auto-generated></span><span class="pln"> </span><span class="com">// This code was generated from a template.</span><span class="pln"> </span><span class="com">//</span><span class="pln"> </span><span class="com">// Manual changes to this file may cause unexpected behavior in your application.</span><span class="pln"> </span><span class="com">// Manual changes to this file will be overwritten if the code is regenerated.</span><span class="pln"> </span><span class="com">// </auto-generated></span><span class="pln"> </span><span class="com">//------------------------------------------------------------------------------</span><span class="pln"> </span><span class="kwd">namespace</span><span class="pln"> </span><span class="typ">GolfWebApplication</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">using</span><span class="pln"> </span><span class="typ">System</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_sp_select_bl_Member_16379_Result </span><span class="pun">{</span><span class="pln"> </span><span class="kwd">public</span><span class="pln"> </span><span class="kwd">int</span><span class="pln"> </span><span class="typ">MemberID</span><span class="pln"> </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="kwd">public</span><span class="pln"> </span><span class="kwd">string</span><span class="pln"> </span><span class="typ">MemberName</span><span class="pln"> </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="kwd">public</span><span class="pln"> </span><span class="kwd">string</span><span class="pln"> </span><span class="typ">ClubLocation</span><span class="pln"> </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>
aa_tbl_Club_1637935
This code is autogenerated don't try to change this page. If you need to change then you have to do it by importing the data table into your project and refresh your project and rebuild it again.
<span class="pln"> </span><span class="com">//------------------------------------------------------------------------------</span><span class="pln"> </span><span class="com">// <auto-generated></span><span class="pln"> </span><span class="com">// This code was generated from a template.</span><span class="pln"> </span><span class="com">//</span><span class="pln"> </span><span class="com">// Manual changes to this file may cause unexpected behavior in your application.</span><span class="pln"> </span><span class="com">// Manual changes to this file will be overwritten if the code is regenerated.</span><span class="pln"> </span><span class="com">// </auto-generated></span><span class="pln"> </span><span class="com">//------------------------------------------------------------------------------</span><span class="pln"> </span><span class="kwd">namespace</span><span class="pln"> </span><span class="typ">GolfWebApplication</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">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">public</span><span class="pln"> </span><span class="kwd">partial</span><span class="pln"> </span><span class="kwd">class</span><span class="pln"> aa_tbl_Club_1637935 </span><span class="pun">{</span><span class="pln"> </span><span class="kwd">public</span><span class="pln"> </span><span class="kwd">int</span><span class="pln"> </span><span class="typ">ClubID</span><span class="pln"> </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="kwd">public</span><span class="pln"> </span><span class="kwd">string</span><span class="pln"> </span><span class="typ">ClubLocation</span><span class="pln"> </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>
ViewJoin Class (Created by myself)
This is page is written by myself. This is a properties which you need to view the joining the two table.
<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">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">namespace</span><span class="pln"> </span><span class="typ">GolfWebApplication</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">ViewJoin</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">int</span><span class="pln"> </span><span class="typ">MemberID</span><span class="pln"> </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="kwd">public</span><span class="pln"> </span><span class="kwd">int</span><span class="pln"> </span><span class="typ">MemberName</span><span class="pln"> </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="kwd">public</span><span class="pln"> </span><span class="kwd">int</span><span class="pln"> </span><span class="typ">ClubLocation</span><span class="pln"> </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>
View Part
Index.cshtml
This is a autogenerated page. You can write it by your own choice according to your requirement.
<span class="pln"> </span><span class="lit">@model</span><span class="pln"> </span><span class="typ">IEnumerable</span><span class="pun"><</span><span class="typ">GolfWebApplication</span><span class="pun">.</span><span class="typ">Models</span><span class="pun">.</span><span class="pln">aa_sp_select_bl_Member_16379_Result</span><span class="pun">></span><span class="pln"> </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">"Index"</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">Index</span><span class="pun"></</span><span class="pln">h2</span><span class="pun">></span><span class="pln"> </span><span class="str"><p></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">"Create New"</span><span class="pun">,</span><span class="pln"> </span><span class="str">"AddMember"</span><span class="pun">)</span><span class="pln"> </span><span class="pun"></</span><span class="pln">p</span><span class="pun">></span><span class="pln"> </span><span class="pun"><</span><span class="pln">table </span><span class="kwd">class</span><span class="pun">=</span><span class="str">"table"</span><span class="pun">></span><span class="pln"> </span><span class="str"><tr></span><span class="pln"> </span><span class="str"><th></span><span class="pln"> </span><span class="lit">@Html</span><span class="pun">.</span><span class="typ">DisplayNameFor</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">MemberID</span><span class="pun">)</span><span class="pln"> </span><span class="pun"></</span><span class="pln">th</span><span class="pun">></span><span class="pln"> </span><span class="str"><th></span><span class="pln"> </span><span class="lit">@Html</span><span class="pun">.</span><span class="typ">DisplayNameFor</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">MemberName</span><span class="pun">)</span><span class="pln"> </span><span class="pun"></</span><span class="pln">th</span><span class="pun">></span><span class="pln"> </span><span class="str"><th></span><span class="pln"> </span><span class="lit">@Html</span><span class="pun">.</span><span class="typ">DisplayNameFor</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">ClubLocation</span><span class="pun">)</span><span class="pln"> </span><span class="pun"></</span><span class="pln">th</span><span class="pun">></span><span class="pln"> </span><span class="str"><th></span><span class="pun"></</span><span class="pln">th</span><span class="pun">></span><span class="pln"> </span><span class="pun"></</span><span class="pln">tr</span><span class="pun">></span><span class="pln"> </span><span class="lit">@foreach</span><span class="pln"> </span><span class="pun">(</span><span class="kwd">var</span><span class="pln"> item </span><span class="kwd">in</span><span class="pln"> </span><span class="typ">Model</span><span class="pun">)</span><span class="pln"> </span><span class="pun">{</span><span class="pln"> </span><span class="str"><tr></span><span class="pln"> </span><span class="str"><td></span><span class="pln"> </span><span class="lit">@Html</span><span class="pun">.</span><span class="typ">DisplayFor</span><span class="pun">(</span><span class="pln">modelItem </span><span class="pun">=></span><span class="pln"> item</span><span class="pun">.</span><span class="typ">MemberID</span><span class="pun">)</span><span class="pln"> </span><span class="pun"></</span><span class="pln">td</span><span class="pun">></span><span class="pln"> </span><span class="str"><td></span><span class="pln"> </span><span class="lit">@Html</span><span class="pun">.</span><span class="typ">DisplayFor</span><span class="pun">(</span><span class="pln">modelItem </span><span class="pun">=></span><span class="pln"> item</span><span class="pun">.</span><span class="typ">MemberName</span><span class="pun">)</span><span class="pln"> </span><span class="pun"></</span><span class="pln">td</span><span class="pun">></span><span class="pln"> </span><span class="str"><td></span><span class="pln"> </span><span class="lit">@Html</span><span class="pun">.</span><span class="typ">DisplayFor</span><span class="pun">(</span><span class="pln">modelItem </span><span class="pun">=></span><span class="pln"> item</span><span class="pun">.</span><span class="typ">ClubLocation</span><span class="pun">)</span><span class="pln"> </span><span class="pun"></</span><span class="pln">td</span><span class="pun">></span><span class="pln"> </span><span class="str"><td></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">"Edit"</span><span class="pun">,</span><span class="pln"> </span><span class="str">"Edit"</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"> id</span><span class="pun">=</span><span class="pln">item</span><span class="pun">.</span><span class="typ">MemberID</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">ActionLink</span><span class="pun">(</span><span class="str">"Details"</span><span class="pun">,</span><span class="pln"> </span><span class="str">"Details"</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="com">/* id=item.PrimaryKey */</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">ActionLink</span><span class="pun">(</span><span class="str">"Delete"</span><span class="pun">,</span><span class="pln"> </span><span class="str">"Delete"</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"> id </span><span class="pun">=</span><span class="pln"> item</span><span class="pun">.</span><span class="typ">MemberID</span><span class="pln"> </span><span class="pun">})</span><span class="pln"> </span><span class="pun"></</span><span class="pln">td</span><span class="pun">></span><span class="pln"> </span><span class="pun"></</span><span class="pln">tr</span><span class="pun">></span><span class="pln"> </span><span class="pun">}</span><span class="pln"> </span><span class="pun"></</span><span class="pln">table</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">@ViewBag</span><span class="pun">.</span><span class="typ">Message</span><span class="pln"> </span><span class="pun"></</span><span class="pln">div</span><span class="pun">></span><span class="pln"> </span>
AddMember.cshtml
This is a autogenerated page. You can write it by your own choice according to your requirement.
<span class="pln"> </span><span class="lit">@model</span><span class="pln"> </span><span class="typ">GolfWebApplication</span><span class="pun">.</span><span class="typ">Models</span><span class="pun">.</span><span class="pln">aa_bl_Member_16379 </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">"AddMember"</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">AddMember</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"> list </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"> list</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="str">"Trivandrum "</span><span class="pun">,</span><span class="pln"> </span><span class="typ">Value</span><span class="pln"> </span><span class="pun">=</span><span class="str">"1001"</span><span class="pun">,</span><span class="pln"> </span><span class="pun">});</span><span class="pln"> list</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">"Kochi"</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">"1002"</span><span class="pun">,</span><span class="pln"> </span><span class="pun">});</span><span class="pln"> list</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">"Calicut"</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">"1003"</span><span class="pun">,</span><span class="pln"> </span><span class="pun">});</span><span class="pln"> list</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">"Paala"</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">"1004"</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><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="pun"><</span><span class="pln">table </span><span class="kwd">class</span><span class="pun">=</span><span class="str">"table table-bordered"</span><span class="pun">></span><span class="pln"> </span><span class="str"><tr></span><span class="pln"> </span><span class="str"><td></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">MemberName</span><span class="pun">)</</span><span class="pln">td</span><span class="pun">></span><span class="pln"> </span><span class="str"><td></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">MemberName</span><span class="pun">)</</span><span class="pln">td</span><span class="pun">></span><span class="pln"> </span><span class="pun"></</span><span class="pln">tr</span><span class="pun">></span><span class="pln"> </span><span class="str"><tr></span><span class="pln"> </span><span class="str"><td></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">Gender</span><span class="pun">)</</span><span class="pln">td</span><span class="pun">></span><span class="pln"> </span><span class="str"><td></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">Gender</span><span class="pun">,</span><span class="pln"> </span><span class="str">"Male"</span><span class="pun">)</span><span class="typ">Male</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">Gender</span><span class="pun">,</span><span class="pln"> </span><span class="str">"Female"</span><span class="pun">)</span><span class="typ">Female</span><span class="pln"> </span><span class="pun"></</span><span class="pln">td</span><span class="pun">></span><span class="pln"> </span><span class="pun">@*<</span><span class="pln">td</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">Gender</span><span class="pun">,</span><span class="pln"> </span><span class="kwd">new</span><span class="pln"> </span><span class="typ">SelectList</span><span class="pun">(),</span><span class="pln"> </span><span class="str">"Select Gender"</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">td</span><span class="pun">>*@</span><span class="pln"> </span><span class="pun"></</span><span class="pln">tr</span><span class="pun">></span><span class="pln"> </span><span class="str"><tr></span><span class="pln"> </span><span class="str"><td></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">MemberShipType</span><span class="pun">)</span><span class="pln"> </span><span class="pun"></</span><span class="pln">td</span><span class="pun">></span><span class="pln"> </span><span class="str"><td></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">MemberShipType</span><span class="pun">)</</span><span class="pln">td</span><span class="pun">></span><span class="pln"> </span><span class="pun"></</span><span class="pln">tr</span><span class="pun">></span><span class="pln"> </span><span class="str"><tr></span><span class="pln"> </span><span class="str"><td></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">ClubID</span><span class="pun">)</span><span class="pln"> </span><span class="pun"></</span><span class="pln">td</span><span class="pun">></span><span class="pln"> </span><span class="str"><td></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">ClubID</span><span class="pun">,</span><span class="pln"> list</span><span class="pun">,</span><span class="str">"--Select ID--"</span><span class="pun">)</span><span class="pln"> </span><span class="pun"></</span><span class="pln">td</span><span class="pun">></span><span class="pln"> </span><span class="pun"></</span><span class="pln">tr</span><span class="pun">></span><span class="pln"> </span><span class="str"><tr></span><span class="pln"> </span><span class="pun"><</span><span class="pln">td colspan</span><span class="pun">=</span><span class="str">"2"</span><span class="pun">></span><span class="pln"> </span><span class="pun"><</span><span class="pln">input id</span><span class="pun">=</span><span class="str">"Submit1"</span><span class="pln"> 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">"submit"</span><span class="pln"> </span><span class="pun">/></span><span class="pln"> </span><span class="pun"></</span><span class="pln">td</span><span class="pun">></span><span class="pln"> </span><span class="pun"></</span><span class="pln">tr</span><span class="pun">></span><span class="pln"> </span><span class="pun"></</span><span class="pln">table</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">@ViewBag</span><span class="pun">.</span><span class="typ">Message</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>
Edit.cshtml
This is a autogenerated page. You can write it by your own choice according to your requirement.
<span class="pln"> </span><span class="lit">@model</span><span class="pln"> </span><span class="typ">GolfWebApplication</span><span class="pun">.</span><span class="typ">Models</span><span class="pun">.</span><span class="pln">aa_bl_Member_16379 </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">"Edit"</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">Edit</span><span class="pun"></</span><span class="pln">h2</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"><h4></span><span class="pln">aa_bl_Member_16379</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">MemberID</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">MemberID</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">MemberID</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">MemberName</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">MemberName</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">MemberName</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">Gender</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">Gender</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">Gender</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">MemberShipType</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">MemberShipType</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">MemberShipType</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">ClubID</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">ClubID</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">ClubID</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="lit">@Html</span><span class="pun">.</span><span class="typ">ActionLink</span><span class="pun">(</span><span class="str">"Back to List"</span><span class="pun">,</span><span class="pln"> </span><span class="str">"Edit"</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">"Save"</span><span class="pln"> </span><span class="kwd">class</span><span class="pun">=</span><span class="str">"btn btn-default"</span><span class="pln"> formaction</span><span class="pun">=</span><span class="str">"EditMember"</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="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">"Back to List"</span><span class="pun">,</span><span class="pln"> </span><span class="str">"Index"</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>
