MVC Application With MongoDB - Part 2

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