Post
Ask Question

Multiple Models In One View Using ASP.NET MVC And Entity Framework

Introduction
 
In a client requirement, I needed to create a page where two forms or models exist in a single view (page), like login and registration in the same single view.
 
Description
 
To fulfill this requirement, I used MVC with Entity Framework and SQL Server. For more details about MVC, go through my previous articles and blogs.
On the registration page, the user will register as new and on the login page, existing users will log in with their credentials. These two functionalities need to be implemented in the same view using MVC facility. The other script related part is added to show the message for successful or ivalid credentials during registration and login operations.
 
Source Code
Steps to be followed.
 
Step 1
 
Create a table named Users.
  1. CREATE TABLE [dbo].[Users](  
  2.     [UserID] [int] IDENTITY(1,1) NOT NULL,  
  3.     [Username] [varchar](50) NULL,  
  4.     [Password] [varchar](50) NULL,  
  5.     [FullName] [varchar](150) NULL,  
  6. PRIMARY KEY CLUSTERED   
  7. (  
  8.     [UserID] ASC  
  9. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]  
  10. ) ON [PRIMARY]  
  11.   
  12. GO 
Step 2 - Add Entity Data Model
 
I have added entity data model named "Satyadatabasemodel.edmx" . After creating the Data model, we have to modify our generated entity (table) for applying the validation to the required fields. Here, we need to modify the User.cs file.
 
Code Ref
  1. namespace SatyaprakashMultimodels  
  2. {  
  3.     using System;  
  4.     using System.Collections.Generic;  
  5.     using System.ComponentModel.DataAnnotations;  
  6.     public partial class User  
  7.     {  
  8.         public int UserID { get; set; }  
  9.         [Required]  
  10.         public string Username { get; set; }  
  11.         [Required]  
  12.         [DataType(System.ComponentModel.DataAnnotations.DataType.Password)]  
  13.         public string Password { get; set; }  
  14.         [Required]  
  15.         public string FullName { get; set; }  
  16.     }  
  17. } 
Code Description
 
Here, all the fields are put with the required attribute for validation purposes.
 
Step 3
 
I need a ViewModel for getting the data as a single entity.  Here, I created a class file named "SignIn.cs" in the ViewModel folder.
 
Code Ref
  1. using System;  
  2. using System.Collections.Generic;  
  3. using System.Linq;  
  4. using System.Text;  
  5. using System.Threading.Tasks;  
  6. using System.ComponentModel.DataAnnotations;  
  7.   
  8. namespace SatyaprakashMultimodels.ViewModel  
  9. {  
  10.     public class SignIn  
  11.     {  
  12.         public User User { get; set; }  
  13.         public Login Login { get; set; }  
  14.     }  
  15.   
  16.     public class Login  
  17.     {  
  18.         [Required]  
  19.         public string UserName { get; set; }  
  20.         [Required]  
  21.         [DataType(System.ComponentModel.DataAnnotations.DataType.Password)]  
  22.         public string Password { get; set; }  
  23.     }  
  24. } 
Code Description
 
I used two classes, SignIn and Login, for new user registration and for logging the existing users in respectively.
 
Step 4
 
Then, I have added one controller action method named "LoginRegister" to the HomeController.cs file.
 
Code Ref
  1. using SatyaprakashMultimodels.ViewModel;  
  2. using System;  
  3. using System.Collections.Generic;  
  4. using System.Linq;  
  5. using System.Web;  
  6. using System.Web.Mvc;  
  7.   
  8. namespace SatyaprakashMultimodels.Controllers  
  9. {  
  10.     public class HomeController : Controller  
  11.     {  
  12.         public ActionResult Index()  
  13.         {  
  14.             return View();  
  15.         }  
  16.   
  17.         public ActionResult LoginRegister(SignIn lr)  
  18.         {  
  19.             return View(new SignIn { Login = new Login(), User = new User() });  
  20.   
  21.         }  
  22.   
  23.         [HttpPost]  
  24.         public ActionResult Login(SignIn l)  
  25.         {  
  26.             string message = "";  
  27.             if (ModelState.IsValid)  
  28.             {  
  29.                 using (CrystalGranite2016Entities1 dc = new CrystalGranite2016Entities1())  
  30.                 {  
  31.                     var v = dc.Users.Where(a => a.Username.Equals(l.Login.UserName) && a.Password.Equals(l.Login.Password)).FirstOrDefault();  
  32.                     if (v != null)  
  33.                     {  
  34.                         message = "Login Success";  
  35.                         return RedirectToAction("Success", new { message = message });  
  36.                     }  
  37.                     else  
  38.                     {  
  39.                         message = "login failed";  
  40.                     }  
  41.                 }  
  42.             }  
  43.             ViewBag.Message = message;  
  44.             return View("LoginRegister", l);  
  45.   
  46.         }  
  47.   
  48.         [HttpPost]  
  49.         public ActionResult Register(SignIn r)  
  50.         {  
  51.             string message = "";  
  52.             if (ModelState.IsValid)  
  53.             {  
  54.                 using (CrystalGranite2016Entities1 dc = new CrystalGranite2016Entities1())  
  55.                 {  
  56.                     var v = dc.Users.Where(a => a.Username.Equals(r.User.Username)).FirstOrDefault();  
  57.                     if (v == null)  
  58.                     {  
  59.                         dc.Users.Add(r.User);  
  60.                         dc.SaveChanges();  
  61.                         message = "Successfully Registered";  
  62.                         return RedirectToAction("Success", new { message = message });  
  63.                     }  
  64.                     else  
  65.                     {  
  66.                         message = "Username no available";  
  67.                     }  
  68.                 }  
  69.             }  
  70.             ViewBag.Message = message;  
  71.             return View("LoginRegister", r);  
  72.   
  73.         }  
  74.   
  75.         public ActionResult Success(string message)  
  76.         {  
  77.             ViewBag.Message = message;  
  78.             return View();  
  79.         }  
  80.   
  81.         public ActionResult About()  
  82.         {  
  83.             ViewBag.Message = "Your application description page.";  
  84.   
  85.             return View();  
  86.         }  
  87.   
  88.         public ActionResult Contact()  
  89.         {  
  90.             ViewBag.Message = "Your contact page.";  
  91.   
  92.             return View();  
  93.         }  
  94.     }  
  95. } 
Code Description
 
This Action method is used to render one view for both Login & New User Registration.
  1. public ActionResult LoginRegister(SignIn lr)  
  2. {  
  3.     return View(new SignIn { Login = new Login(), User = new User() });  
  4.   
  5. } 
Then, I added another controller action method named Login for existing login purposes and CrystalGranite2016Entities1 is the name of the Database entity class file. It will show a message to the end user informing them if the credentials are correct or not.
  1. [HttpPost]  
  2. public ActionResult Login(SignIn l)  
  3. {  
  4.     string message = "";  
  5.     if (ModelState.IsValid)  
  6.     {  
  7.         using (CrystalGranite2016Entities1 dc = new CrystalGranite2016Entities1())  
  8.         {  
  9.             var v = dc.Users.Where(a => a.Username.Equals(l.Login.UserName) && a.Password.Equals(l.Login.Password)).FirstOrDefault();  
  10.             if (v != null)  
  11.             {  
  12.                 message = "Login Success";  
  13.                 return RedirectToAction("Success", new { message = message });  
  14.             }  
  15.             else  
  16.             {  
  17.                 message = "login failed";  
  18.             }  
  19.         }  
  20.     }  
  21.     ViewBag.Message = message;  
  22.     return View("LoginRegister", l);  
  23.   
  24. } 
Like this, we have added another controller action method named "Register". It is used for new user registration entries and it will show a message based on the new user registration.
  1. public ActionResult Register(SignIn r)  
  2. {  
  3.     string message = "";  
  4.     if (ModelState.IsValid)  
  5.     {  
  6.         using (CrystalGranite2016Entities1 dc = new CrystalGranite2016Entities1())  
  7.         {  
  8.             var v = dc.Users.Where(a => a.Username.Equals(r.User.Username)).FirstOrDefault();  
  9.             if (v == null)  
  10.             {  
  11.                 dc.Users.Add(r.User);  
  12.                 dc.SaveChanges();  
  13.                 message = "Successfully Registered";  
  14.                 return RedirectToAction("Success", new { message = message });  
  15.             }  
  16.             else  
  17.             {  
  18.                 message = "Username no available";  
  19.             }  
  20.         }  
  21.     }  
  22.     ViewBag.Message = message;  
  23.     return View("LoginRegister", r);  
  24.   
  25. } 
I have created another controller action method named Success to manage different Success messages in the View.
  1. public ActionResult Success(string message)  
  2. {  
  3.     ViewBag.Message = message;  
  4.     return View();  
  5. } 
Step 5
 
Add a View named "LoginRegister.cshtml"  in Views >> Home Folder.
 
Code Ref
  1. @model SatyaprakashMultimodels.ViewModel.SignIn  
  2. @{  
  3.     ViewBag.Title = "User SignIn";  
  4.  }  
  5.   
  6. <h2>Login Register</h2><link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">  
  7. <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>  
  8. <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>    
  9. <script src="https://cdnjs.cloudflare.com/ajax/libs/bootbox.js/4.4.0/bootbox.min.js">  
  10.   
  11. </script>   
  12.   
  13. <script>  
  14. bootbox.alert({  
  15.         message: '@ViewBag.Message',  
  16.         size:'large'  
  17. });  
  18. </script>  
  19.   
  20. <div style="color:red">  
  21.     @ViewBag.Message  
  22. </div>  
  23. <style>    
  24.         table {    
  25.             font-family: arial, sans-serif;    
  26.             border-collapse: collapse;    
  27.             width: 100%;    
  28.         }    
  29.     
  30.         td, th {    
  31.             border: 1px solid #dddddd;    
  32.             text-align: left;    
  33.             padding: 8px;    
  34.         }    
  35.     
  36.         tr:nth-child(even) {    
  37.             background-color: #dddddd;    
  38.         }    
  39.     
  40.         .button {    
  41.             background-color: #4CAF50;    
  42.             border: none;    
  43.             color: white;    
  44.             padding: 15px 32px;    
  45.             text-align: center;    
  46.             text-decoration: none;    
  47.             display: inline-block;    
  48.             font-size: 16px;    
  49.             margin: 4px 2px;    
  50.             cursor: pointer;    
  51.         }    
  52.     
  53.         .button4 {    
  54.             border-radius: 9px;    
  55.         }    
  56.     
  57.         input[type=text], select {    
  58.             width: 60%;    
  59.             padding: 12px 20px;    
  60.             margin: 8px 0;    
  61.             display: inline-block;    
  62.             border: 1px solid #ccc;    
  63.             border-radius: 4px;    
  64.             box-sizing: border-box;    
  65.         }    
  66.         input[type=password], select {    
  67.             width: 60%;    
  68.             padding: 12px 20px;    
  69.             margin: 8px 0;    
  70.             display: inline-block;    
  71.             border: 1px solid #ccc;    
  72.             border-radius: 4px;    
  73.             box-sizing: border-box;    
  74.         }   
  75.     </style>    
  76. <table>  
  77.     <tr>  
  78.         <th style="background-color: Yellow;color: blue"><b>Existing User SignIn</b></th>  
  79.         <th style="background-color: Yellow;color: blue"><b>New User Register</b></th>  
  80.     </tr>  
  81.     <tr>  
  82.         <td>  
  83.             @using (Html.BeginForm("Login", "Home", FormMethod.Post))  
  84.             {  
  85.                 <table>  
  86.                     <tr>  
  87.                         <td>Username : </td>  
  88.                         <td>@Html.TextBoxFor(a => a.Login.UserName)</td>  
  89.                     </tr>  
  90.                     <tr>  
  91.                         <td>Password : </td>  
  92.                         <td>@Html.EditorFor(a => a.Login.Password)</td>  
  93.                     </tr>  
  94.                     <tr>  
  95.                         <td></td>  
  96.                         <td> <input type="submit" class="button button4"  value="Go" /></td>  
  97.                     </tr>  
  98.                 </table>  
  99.             }  
  100.         </td>  
  101.         <td>  
  102.             @using (Html.BeginForm("Register", "Home", FormMethod.Post))  
  103.             {  
  104.                 <table>  
  105.                     <tr>  
  106.                         <td>Fullname : </td>  
  107.                         <td>@Html.TextBoxFor(a => a.User.FullName)</td>  
  108.                     </tr>  
  109.                     <tr>  
  110.                         <td>Username : </td>  
  111.                         <td>@Html.TextBoxFor(a => a.User.Username)</td>  
  112.                     </tr>  
  113.                     <tr>  
  114.                         <td>Password : </td>  
  115.                         <td>@Html.EditorFor(a => a.User.Password)</td>  
  116.                     </tr>  
  117.                     <tr>  
  118.                         <td></td>  
  119.                         <td>  
  120.                             <input type="submit" class="button button4" value="Submit" />  
  121.                         </td>  
  122.                     </tr>  
  123.                 </table>  
  124.             }  
  125.         </td>  
  126.     </tr>  
  127. </table>  
  128.   
  129. @*@section Scripts {  
  130.     @Scripts.Render("~/bundles/jqueryval")  
  131. }*@  
  132.   
  133. <footer>  
  134.     <p style="background-color: Yellow; font-weight: bold; color:blue; text-align: center; font-style: oblique">© @DateTime.Now.ToLocalTime()</p> @*Add Date Time*@  
  135. </footer> 
Code Description
 
I have added one single view for both  Login and New User Registration. Inside BeginForm, we set the action tag to the specified controller and action for Login and Register action methods in Home Controller.
  1. @using (Html.BeginForm("Login", "Home", FormMethod.Post))  
  2. {  
  3. }  
  4.   
  5. @using (Html.BeginForm("Register", "Home", FormMethod.Post))  
  6. {  
  7. } 
I have added Bootbox JavaScript library and Div tag to show an error message to the end user.
 
Error Message displayed using Bootbox.
  1. <script>  
  2. bootbox.alert({  
  3.         message: '@ViewBag.Message',  
  4.         size:'large'  
  5. });  
  6. </script> 
Another Error Message displayed using Div tag.
  1. <div style="color:red">  
  2.     @ViewBag.Message  
  3. </div> 
Step-6
 
I have added another View named "Success.cshtml".
 
Code Ref
  1. @{  
  2.     ViewBag.Title = "Success";  
  3. }  
  4.   
  5. <h2>Message Confirmation....</h2>  
  6. <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">  
  7. <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>  
  8. <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>  
  9.   
  10.   
  11. <script src="https://cdnjs.cloudflare.com/ajax/libs/bootbox.js/4.4.0/bootbox.min.js">  
  12.   
  13. </script>    
  14.   
  15. <script>  
  16. bootbox.alert({  
  17.         message: '@ViewBag.Message',  
  18.         size:'large'  
  19. });  
  20. </script>  
  21.   
  22. <div style="color:green">  
  23.         @ViewBag.Message  
  24.     </div>  
  25.   
  26. <footer>  
  27.     <p style="background-color: Yellow; font-weight: bold; color:blue; text-align: center; font-style: oblique">© @DateTime.Now.ToLocalTime()</p> @*Add Date Time*@  
  28. </footer> 
Code Decription
 
This View shows up in case of successful user login and user registration only. I have added Bootbox JavaScript library and Div tag to show this success message to the end user.
  1. <script>  
  2. bootbox.alert({  
  3.         message: '@ViewBag.Message',  
  4.         size:'large'  
  5. });  
  6. </script>  
  7.   
  8. <div style="color:green">  
  9.         @ViewBag.Message  
  10. </div> 
Step-7
 
Check Web.Config for Database Connection String. Here, add name and nothing but the Autogenerate Database Entity class file name, i.e., "CrystalGranite2016Entities1".
  1. <connectionStrings>  
  2. <add name="DefaultConnection" connectionString="Data Source=(LocalDb)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\aspnet-SatyaprakashMultimodels-20171223092521.mdf;Initial Catalog=aspnet-SatyaprakashMultimodels-20171223092521;Integrated Security=True" providerName="System.Data.SqlClient" />
  3. <add name="CrystalGranite2016Entities1" connectionString="metadata=res://*/Satyadatabasemodel.csdl|res://*/Satyadatabasemodel.ssdl|res://*/Satyadatabasemodel.msl;provider=System.Data.SqlClient;provider connection string="data source=SODN-PAVILION\SQLEXPRESS;initial catalog=CrystalGranite2016;persist security info=True;user id=sa;password=satya;multipleactiveresultsets=True;application name=EntityFramework"" providerName="System.Data.EntityClient" />  
  4. </connectionStrings> 
Step-8
 
In RouteConfig File, I have added Controller name and Action method name for setting the start page.
  1. routes.MapRoute(  
  2.                 name: "Default",  
  3.                 url: "{controller}/{action}/{id}",  
  4.                 defaults: new { controller = "Home", action = "LoginRegister", id = UrlParameter.Optional }  
  5.             );  
OUTPUT
 
The URL is: http://localhost:2546/Home/LoginRegister
 

I created a new user as the below image. But already, a user in our database goes by the same username, Satya.
 
 
So, I tried different names Satyadev. After that, I got a successful message.
 
 
Try for the login part using Satyadev username.
 
 
Check In the database:
 
 
Mobile View
 
 
Summary
  • Use more than one model in one view.
  • MVC with Entity Framework and Bootstrap.
  • Bootbox library for message display.


Similar Articles