CRUD Using ASP.NET MVC 5 And Entity Framework

Similarly, to insert the records into the Employee Table use the following commands.

PM> Add-Migration 'UpdateEmployeeData'

With this, a new UpdateEmployeeData class will be created like below.

namespace MVCCRUDProject.Migrations
{
    using System;
    using System.Data.Entity.Migrations;
    public partial class UpdateEmployeeData : DbMigration
    {
        public override void Up()
        {
            Sql("Insert into Employees(EmployeeName,EmployeeDesignation,EmployeeAddress,EmployeePassport,EmployeePhone,EmployeeGender,City,Project,CompanyName,PinCode,DepartmentId)" +
                "Values('KM','S.E','Hyderabad','K849271',123456789,'Male','Hyderabad','Automation','Infosys',500045,1)");
        }

        public override void Down()
        {
        }
    }
}

Update the code in the Up() method with the number of records you want to insert into the Employee Table.

PM> Update-Database

With the above command, the new records will be inserted into the Employee Table.

In order to work with the CRUD Operations, right-click on the Controllers folder click on Add Controller select MVC 5 Controller-Empty, and click on Add and rename the EmployeeController.cs and Add.

Open the EmployeeController.cs file and place the below code.

using System;
using System.Collections.Generic;
using System.Data.Entity;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using MVCCRUDProject.Models;
using MVCCRUDProject.ViewModels;

namespace MVCCRUDProject.Controllers
{
    public class EmployeeController : Controller
    {
        private readonly EmployeeDbContext _dbContext;

        public EmployeeController()
        {
            this._dbContext = new EmployeeDbContext();
        }
        // GET: Employee
        public ActionResult Index()
        {
            var employeeList = this._dbContext.Employee.Include(x => x.Department).ToList();
            return View(employeeList);
        }

        public ActionResult AddEmployees()
        {
            var employeeViewModel = new EmployeeViewModel()
            {
                Department = this._dbContext.Department.ToList(),
                Employee = new Employee()
            };
            return View("EmployeeForm", employeeViewModel);
        }

        public ActionResult Edit(int id)
        {
            var employees = this._dbContext.Employee.FirstOrDefault(x => x.EmployeeId == id);
            var department = this._dbContext.Department.ToList();

            var viewModel = new EmployeeViewModel()
            {
                Department = department,
                Employee = employees
            };
            return View("EmployeeForm", viewModel);
        }

        [HttpPost]
        public ActionResult Save(Employee employee)
        {
            if (!ModelState.IsValid)
            {
                return RedirectToAction("AddEmployees", "Employee");
            }

            if (employee.EmployeeId == 0)
                this._dbContext.Employee.Add(employee);

            else
            {
                var employeesDb = this._dbContext.Employee.FirstOrDefault(x => x.EmployeeId == employee.EmployeeId);
                employeesDb.EmployeeName = employee.EmployeeName;
                employeesDb.EmployeeDesignation = employee.EmployeeDesignation;
                employeesDb.EmployeeAddress = employee.EmployeeAddress;
                employeesDb.EmployeePassport = employee.EmployeePassport;
                employeesDb.EmployeePhone = employee.EmployeePhone;
                employeesDb.EmployeeGender = employee.EmployeeGender;
                employeesDb.City = employee.City;
                employeesDb.Project = employee.Project;
                employeesDb.CompanyName = employee.CompanyName;
                employeesDb.PinCode = employee.PinCode;
                employeesDb.DepartmentId = employee.DepartmentId;
            }

            this._dbContext.SaveChanges();
            return RedirectToAction("Index", "Employee");
        }

        public ActionResult Delete(int id)
        {
            var employeeDb = this._dbContext.Employee.FirstOrDefault(x => x.EmployeeId == id);
            this._dbContext.Employee.Remove(employeeDb);
            this._dbContext.SaveChanges();

            return RedirectToAction("Index", "Employee");
        }
    }
}

In the Views Folder, add a new folder as Employee and add two Views or .cshtml files as EmployeeForm.cshtml and Index. cshtml under the Employee folder.

Open Index. cshtml add place the below code.

@model IEnumerable<MVCCRUDProject.Models.Employee>
@{
    ViewBag.Title = "Index";
}
<h2>Employee Details</h2>
<hr/>

<button class="">@Html.ActionLink("Add Employees", "AddEmployees", "Employee")</button>
<table class="table">
    <thead>
        <tr>
            <th>@Html.DisplayNameFor(m => m.EmployeeName)</th>
            <th>@Html.DisplayNameFor(m => m.EmployeeDesignation)</th>
            <th>@Html.DisplayNameFor(m => m.EmployeeAddress)</th>
            <th>@Html.DisplayNameFor(m => m.EmployeePassport)</th>
            <th>@Html.DisplayNameFor(m => m.EmployeePhone)</th>
            <th>@Html.DisplayNameFor(m => m.EmployeeGender)</th>
            <th>@Html.DisplayNameFor(m => m.City)</th>
            <th>@Html.DisplayNameFor(m => m.Project)</th>
            <th>@Html.DisplayNameFor(m => m.CompanyName)</th>
            <th>@Html.DisplayNameFor(m => m.PinCode)</th>
            <th>@Html.DisplayNameFor(m => m.DepartmentId)</th>
        </tr>
    </thead>
    <tbody>
        @foreach (var employees in Model)
        {
            <tr>
                <td>@employees.EmployeeName</td>
                <td>@employees.EmployeeDesignation</td>
                <td>@employees.EmployeeAddress</td>
                <td>@employees.EmployeePassport</td>
                <td>@employees.EmployeePhone</td>
                <td>@employees.EmployeeGender</td>
                <td>@employees.City</td>
                <td>@employees.Project</td>
                <td>@employees.CompanyName</td>
                <td>@employees.PinCode</td>
                <td>@employees.Department.DepartmentName</td>
                <td>@Html.ActionLink("Edit", "Edit", new { id = employees.EmployeeId })</td>
                <td>@Html.ActionLink("Delete", "Delete", new { id = employees.EmployeeId })</td>
            </tr>
        }
    </tbody>
</table>

Similarly, open the EmployeeForm.cshtml and place the below code.

@model MVCCRUDProject.ViewModels.EmployeeViewModel
@{
    ViewBag.Title = "EmployeeForm";
}
<h2>Employee Details</h2>
<hr />
@using (@Html.BeginForm("Save", "Employee"))
{
    <div class="form-group">
        @Html.LabelFor(m => m.Employee.EmployeeName)
        @Html.TextBoxFor(m => m.Employee.EmployeeName, new { @class = "form-control" })
    </div>
    <div class="form-group">
        @Html.LabelFor(m => m.Employee.EmployeeDesignation)
        @Html.TextBoxFor(m => m.Employee.EmployeeDesignation, new { @class = "form-control" })
    </div>
    <div class="form-group">
        @Html.LabelFor(m => m.Employee.EmployeeAddress)
        @Html.TextBoxFor(m => m.Employee.EmployeeAddress, new { @class = "form-control" })
    </div>
    <div class="form-group">
        @Html.LabelFor(m => m.Employee.EmployeePassport)
        @Html.TextBoxFor(m => m.Employee.EmployeePassport, new { @class = "form-control" })
    </div>
    <div class="form-group">
        @Html.LabelFor(m => m.Employee.EmployeePhone)
        @Html.TextBoxFor(m => m.Employee.EmployeePhone, new { @class = "form-control" })
    </div>
    <div class="form-group">
        @Html.LabelFor(m => m.Employee.EmployeeGender)
        @Html.TextBoxFor(m => m.Employee.EmployeeGender, new { @class = "form-control" })
    </div>
    <div class="form-group">
        @Html.LabelFor(m => m.Employee.City)
        @Html.TextBoxFor(m => m.Employee.City, new { @class = "form-control" })
    </div>
    <div class="form-group">
        @Html.LabelFor(m => m.Employee.Project)
        @Html.TextBoxFor(m => m.Employee.Project, new { @class = "form-control" })
    </div>

    <div class="form-group">
        @Html.LabelFor(m => m.Employee.CompanyName)
        @Html.TextBoxFor(m => m.Employee.CompanyName, new { @class = "form-control" })
    </div>
    <div class="form-group">
        @Html.LabelFor(m => m.Employee.PinCode)
        @Html.TextBoxFor(m => m.Employee.PinCode, new { @class = "form-control" })
    </div>
    <div class="form-group">
        @Html.LabelFor(m => m.Employee.DepartmentId)
        @Html.DropDownListFor(m => m.Employee.DepartmentId, new SelectList(Model.Department, "DepartmentId", "DepartmentName"), "Select Department", new { @class = "form-control" })
    </div>
    @Html.HiddenFor(m => m.Employee.EmployeeId)
    var c = @Model.Employee.EmployeeId > 0 ? "Update" : "Save";
    <button type="submit" class="btn btn-primary">@c</button>
}

Here in the above code for declaration, we used ViewModel as we are using Employee and Department properties.

Create a New Folder as ViewModels add a class file rename it to EmployeeViewModel.cs and place the below code.

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using MVCCRUDProject.Models;

namespace MVCCRUDProject.ViewModels
{
    public class EmployeeViewModel
    {
        public IEnumerable<Department> Department { get; set; }
        public Employee Employee { get; set; }
    }
}

Now build & run the application.

Conclusion

In this article, we have learned the basic CRUD Operations using ASP.NET MVC 5 and Entity Framework.