MVC Application With MongoDB - Part 2

Please reference below link to understand how to connect to MongoDB server & create Database for our MVC application.

• MVC Application with MongoDB – Part 1

Please keep MongoDB server in running state while running MVC application.

Part-1 section include steps to start MongoDB server. Both command prompt need to be running ( mongod & mongo ).

Step 1: Create a new database.

ObjectId id = new ObjectId();

MongoClient client = null;
MongoServer server = null;
MongoDatabase database = null;
MongoCollection UserDetailscollection = null;

string connectionString = "mongodb://localhost";
private List<UserModel> _UserList = new List<UserModel>();

public UserRepositary()
{
    try
    {
        client = new MongoClient(connectionString);

        server = client.GetServer();

        database = server.GetDatabase("MVCDBTest");

        UserDetailscollection = database.GetCollection<UserModel>("UserModel");
    }
    catch (Exception ex)
    {
        Console.WriteLine(ex.Message);
    }
}

Firstly create MongoClient object. In this example we have MongoDB server installed on our machine so we pass local server connection string to MongoClient object. Using client object we get Server object.

database = server.GetDatabase("MVCDBTest");

Above line create database at MongoDB server.

UserDetailscollection = database.GetCollection<UserModel>("UserModel");

Above line create Collection inside MVCDBTest database. All data get inserted into this collection object as document.

The following commands are used to check database is created or not.

• show dbs – Display List of database available at server.
  
  If Database is created successfully, above command list down database name in command prompt.
  
  
• use MVCDBTest
  
  We can switch to database now to check collection present in the current database.
  
  
• show collections
  
  It lists down number of collection present into database. One database can have multiple collections present into it.

Step 2: UserModel Class.

In this class we are going to define attributes for our MVC application. MVC support data Annotation for validation purpose, so I added some validation for class attributes.

using MongoDB.Bson;
using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.Linq;
using System.Web;

namespace MvcRegistration.Models
{
    public class UserModel
    {
        public ObjectId _id { get; set; }

        [Required(ErrorMessage = "Please enter your name.")]
        public string UserName { get; set; }

        [Required(ErrorMessage = "Please enter your password.")]
        [DataType(DataType.Password)]
        public string Password { get; set; }

        [Required(ErrorMessage = "Please enter your Email.")]
        [DataType(DataType.EmailAddress)]
        public string Email { get; set; }

        [Required(ErrorMessage = "Please enter your PhoneNo.")]
        public string PhoneNo { get; set; }

        [Required(ErrorMessage = "Please enter your Address.")]
        public string Address { get; set; }
    }
}

"Required" data Annotation indicate that this field is compulsory to enter to user otherwise MVC model return ModelState as invalid.

public ObjectId _id { get; set; }

Each record of MongoDB is having unique id associated with it like primary key of table. So we need to declare attribute _id with data type as ObjectId.

Step 3: Dashboard Page ( index.cshtml ).



Application dashboard contain link to add New User. Below the link, database records are displayed in tabular format. Tabular format contain Edit & Delete button per record.

RouteConfig - Set starting point of application i.e Index method of UserController.

public class RouteConfig
{
    public static void RegisterRoutes(RouteCollection routes)
    {
        routes.IgnoreRoute("{resource}.axd/{*pathInfo}");

        routes.MapRoute(
            name: "Default",
            url: "{controller}/{action}/{id}",
            defaults: new { controller = "User", action = "Index", id = UrlParameter.Optional }
        );
    }
}

Index.cshtml

@model IEnumerable<MvcRegistration.Models.UserModel>

@{
    ViewBag.Title = "User DashBoard";
}

<style type="text/css">
    table, tr {
        width:100%;
    }

    th, td {
        width:20%;
    }
    th {
        background-color:yellow;
    }

    td {
        background-color:aqua;
    }
</style>

<h2>Index</h2>
<div>
    <div>
        @Html.ActionLink("Add User","Registration", "User")
    </div>
    <div>
        @if (Model != null)
        {
            <table>
                <thead>
                    <tr>
                        <th>User Name</th>
                        <th>Email</th>
                        <th>Address</th>
                        <th>PhoneNo</th>
                        <th>Object ID</th>
                        <th colspan="2">Action</th>
                    </tr>
                </thead>
                <tbody>

                    @if (Model != null)
                    {
                        foreach (var UM in Model)
                        {
                        <tr>
                            <td>@UM.UserName</td>
                            <td>@UM.Email</td>
                            <td>@UM.Address</td>
                            <td>@UM.PhoneNo</td>
                            <td>@UM._id</td>
                            <td>
                                <a href="@Url.Action("Edit", "User", new { ID = @UM.UserName})">Edit</a>
                                <a onclick="return confirm('Are you sure about record Deletion ??');" href="@Url.Action("Delete", "User", new { ID = @UM.UserName })">Delete</a>
                            </td>
                        </tr>
                        }
                    }

                </tbody>
            </table>
        }
    </div>
</div>

Controller Level code : Index() Method

public ActionResult Index()
{
    return View("Index", Context.GetAllUsers());
}

Step 4: Registration.cshtml.

Razor syntax is used to create view.



HTML helper classes are used to bind model with html tags.

@Html.ValidationMessageFor(model => model.UserName)

In order to show validation error message, the above syntax is used.

using (Html.BeginForm("Registration", "User"))

It indicate which ActionResult method to execute after form submission.

Source Code

@model MvcRegistration.Models.UserModel

@{
    ViewBag.Title = "Registration";
}

<script src="/Scripts/jquery-1.7.1.min.js" type="text/javascript"></script>
<script src="/Scripts/jquery.validate.min.js" type="text/javascript"></script>
<script src="/Scripts/jquery.validate.unobtrusive.min.js" type="text/javascript"></script>

<h2>Registration</h2>

@using (Html.BeginForm("Registration", "User"))
{


    <table>
        <tr>
            <td>@Html.LabelFor(model => model.UserName)</td>
            <td>@Html.TextBoxFor(model => model.UserName)</td>
            <td>@Html.ValidationMessageFor(model => model.UserName)</td>
        </tr>
        <tr>
            <td colspan="2"></td>
        </tr>
        <tr>
            <td>@Html.LabelFor(model => model.Password)</td>
            <td>@Html.PasswordFor(model => model.Password)</td>
            <td>@Html.ValidationMessageFor(model => model.Password)</td>
        </tr>
        <tr>
            <td colspan="2"></td>
        </tr>
        <tr>
            <td>@Html.LabelFor(model => model.Address)</td>
            <td>@Html.TextBoxFor(model => model.Address)</td>
            <td>@Html.ValidationMessageFor(model => model.Address)</td>
        </tr>
        <tr>
            <td colspan="2"></td>
        </tr>
        <tr>
            <td>@Html.LabelFor(model => model.Email)</td>
            <td>@Html.TextBoxFor(model => model.Email)</td>
            <td>@Html.ValidationMessageFor(model => model.Email)</td>
        </tr>
        <tr>
            <td colspan="2"></td>
        </tr>
        <tr>
            <td>@Html.LabelFor(model => model.PhoneNo)</td>
            <td>@Html.TextBoxFor(model => model.PhoneNo)</td>
            <td>@Html.ValidationMessageFor(model => model.PhoneNo)</td>
        </tr>
        <tr>
            <td colspan="2"></td>
        </tr>
        <tr>
            <td colspan="2">
               <input type="submit" value="Add" class="submitButton" />
            </td>
        </tr>
    </table>
}

Controller Level code : Registration() Method

public ActionResult Registration()
{
    return View();
}

[HttpPost]
public ActionResult Registration(UserModel UM)
{
    if (ModelState.IsValid)
    {
        var result = Context.Add(UM);

        return RedirectToAction("Index");
    }
    else
    {
        return RedirectToAction("Registration");
    }
}

Example



Step 5: Edit User Details (Edit.cshtml).

Razor syntax is used to create view.



Source Code

@model MvcRegistration.Models.UserModel

@{
    ViewBag.Title = "Edit";
}
<script src="/Scripts/jquery-1.7.1.min.js" type="text/javascript"></script>
<script src="/Scripts/jquery.validate.min.js" type="text/javascript"></script>
<script src="/Scripts/jquery.validate.unobtrusive.min.js" type="text/javascript"></script>
<h2>Edit</h2>
@using (Html.BeginForm("Edit", "User"))
{
    @Html.ValidationSummary(true)

    <table>
        <tr>
            <td>@Html.LabelFor(model => model.UserName)</td>
            <td>@Html.TextBoxFor(model => model.UserName, new { @readonly="readonly"})</td>
            <td>@Html.ValidationMessageFor(model => model.UserName)</td>
        </tr>
        <tr>
            <td colspan="2"></td>
        </tr>
         <tr>
            <td>@Html.LabelFor(model => model.Password)</td>
            <td>@Html.PasswordFor(model => model.Password, new { value= Model.Password })</td>
            <td>@Html.ValidationMessageFor(model => model.Password)</td>
        </tr>
        <tr>
            <td colspan="2"></td>
        </tr>
        <tr>
            <td>@Html.LabelFor(model => model.Address)</td>
            <td>@Html.TextBoxFor(model => model.Address)</td>
            <td>@Html.ValidationMessageFor(model => model.Address)</td>
        </tr>
        <tr>
            <td colspan="2"></td>
        </tr>
        <tr>
            <td>@Html.LabelFor(model => model.Email)</td>
            <td>@Html.TextBoxFor(model => model.Email)</td>
            <td>@Html.ValidationMessageFor(model => model.Email)</td>
        </tr>
        <tr>
            <td colspan="2"></td>
        </tr>
        <tr>
            <td>@Html.LabelFor(model => model.PhoneNo)</td>
            <td>@Html.TextBoxFor(model => model.PhoneNo)</td>
            <td>@Html.ValidationMessageFor(model => model.PhoneNo)</td>
        </tr>
        <tr>
            <td colspan="2"></td>
        </tr>
        <tr>
            <td colspan="2">
               <input type="submit" value="Save" class="submitButton" />
            </td>
        </tr>
    </table>
}

Explanation

@using (Html.BeginForm("Edit", "User"))

Indicate which method to execute on form submission.

@Html.TextBoxFor(model => model.UserName, new { @readonly="readonly"})

UserName is readonly field so it is done using the following code.

@Html.PasswordFor(model => model.Password, new { value= Model.Password })

We want to set value to password field so the following code is used.

Controller Level code : Edit() Method

public ActionResult Edit(string id)
{
    var User = Context.GetUserByID(id);

    return View(User);
}

[HttpPost]
public ActionResult Edit(UserModel UM)
{
    if (ModelState.IsValid)
    {
        Context.Update(UM.UserName, UM);

        return RedirectToAction("Index");
    }
    else
    {
        return RedirectToAction("Edit");
    }
}

Step 6: Record Deletion.

Index.cshtml code - The following code call delete method of UserController which has logic to delete user record.

<a onclick="return confirm('Are you sure about record Deletion ??');"href="@Url.Action("Delete", "User", new { ID = @UM.UserName })">Delete</a>

Controller Level code : Delete() Method

public ActionResult Delete(string id)
{
    Context.Delete(id);
    return RedirectToAction("Index");
}

Step 7: Controller Code

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using System.Data.Entity;
using System.Data.SqlClient;

using MongoDB.Bson;
using MongoDB.Driver;
using MongoDB.Driver.Linq;
using MvcRegistration.Models;
using MongoDB.Driver.Builders;

namespace MvcRegistration.Controllers
{
    public class UserController : Controller
    {
        public UserRepositary Context = new UserRepositary();

        public ActionResult Index()
        {
            return View("Index", Context.GetAllUsers());
        }

        public ActionResult Registration()
        {
            return View();
        }

        [HttpPost]
        public ActionResult Registration(UserModel UM)
        {
            if (ModelState.IsValid)
            {
                var result = Context.Add(UM);

                return RedirectToAction("Index");
            }
            else
            {
                return RedirectToAction("Registration");
            }
        }

        public ActionResult Edit(string id)
        {
            var User = Context.GetUserByID(id);

            return View(User);
        }

        [HttpPost]
        public ActionResult Edit(UserModel UM)
        {
            if (ModelState.IsValid)
            {
                Context.Update(UM.UserName, UM);

                return RedirectToAction("Index");
            }
            else
            {
                return RedirectToAction("Edit");
            }
        }

        public ActionResult Delete(string id)
        {
            Context.Delete(id);
            return RedirectToAction("Index");
        }
    }
}

Step 8: UserRepositary.cs

using MongoDB.Bson;
using MongoDB.Driver;
using MongoDB.Driver.Builders;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;

namespace MvcRegistration.Models
{
    public class UserRepositary : IUserRepositary
    {
        ObjectId id = new ObjectId();

        MongoClient client = null;
        MongoServer server = null;
        MongoDatabase database = null;
        MongoCollection UserDetailscollection = null;

        string connectionString = "mongodb://localhost";
        private List<UserModel> _UserList = new List<UserModel>();

        public UserRepositary()
        {
            try
            {
                client = new MongoClient(connectionString);

                server = client.GetServer();

                database = server.GetDatabase("MVCDBTest");

                UserDetailscollection = database.GetCollection<UserModel>("UserModel");
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
            }
        }

        public IEnumerable<UserModel> GetAllUsers()
        {
            if (Convert.ToInt32(UserDetailscollection.Count()) > 0)
            {
                _UserList.Clear();

                var AllUsers = UserDetailscollection.FindAs(typeof(UserModel), Query.NE("UserName", "null"));

                if (AllUsers.Count() > 0)
                {
                    foreach (UserModel user in AllUsers)
                    {
                        _UserList.Add(user);
                    }
                }
            }

            var result = _UserList.AsQueryable();
            return result;
        }

        public UserModel Add(UserModel UM)
        {
            UserDetailscollection.Save(UM);

            return UM;
        }

        public UserModel GetUserByID(string id)
        {
            UserModel SearchUser = null;

            if (!string.IsNullOrEmpty(id))
            {
                SearchUser = (UserModel)UserDetailscollection.FindOneAs(typeof(UserModel), Query.EQ("UserName", id));
            }

            return SearchUser;
        }

        public bool Update(string objectid, UserModel UM)
        {
            UpdateBuilder upBuilder = MongoDB.Driver.Builders.Update
                .Set("UserName", UM.UserName)
                .Set("Password", UM.Password)
                .Set("Address", UM.Address)
                .Set("Email", UM.Email)
                .Set("PhoneNo", UM.PhoneNo);

            UserDetailscollection.Update(Query.EQ("UserName",objectid), upBuilder);

            return true;
        }

        public bool Delete(string objectid)
        {
            UserDetailscollection.Remove(Query.EQ("UserName", objectid));
            return true;
        }
    }
}

Output



I hope it is useful to all the readers of C# corner like my previous articles on this series