CRUD Operations in MVC in Asp.Net

Package

EntityFramework
Microsoft.AspNet.Mvc
Microsoft.AspNet.Razor
Microsoft.AspNet.WebPages
Microsoft.CodeDom.Providers.DotNetCompilerPlatform
Microsoft.jQuery.Unobtrusive.Validation

Database Code

create database Tutorials;

use Tutorials;

create table Employee(Employeeid int primary key ,EmployeeName varchar(50),EmployeeSalary varchar(50),EmployeeCity varchar(50));

Controllers[Folder]

EmployeesController.cs

using System;

using System.Collections.Generic;

using System.Data;

using System.Data.Entity;

using System.Linq;

using System.Net;

using System.Web;

using System.Web.Mvc;

using CrudMVCEntity.Models;

namespace CrudMVCEntity.Controllers

{

public class EmployeesController : Controller

{

private TutorialsEntities db = new TutorialsEntities();

// GET: Employees

public ActionResult Index()

{

return View(db.Employees.ToList());

}

// GET: Employees/Details/5

public ActionResult Details(int? id)

{

if (id == null)

{

return new HttpStatusCodeResult(HttpStatusCode.BadRequest);

}

Employee employee = db.Employees.Find(id);

if (employee == null)

{

return HttpNotFound();

}

return View(employee);

}

// GET: Employees/Create

public ActionResult Create()

{

return View();

}

// POST: Employees/Create

// To protect from overposting attacks, enable the specific properties you want to bind to, for

// more details see https://go.microsoft.com/fwlink/?LinkId=317598.

[HttpPost]

[ValidateAntiForgeryToken]

public ActionResult Create([Bind(Include = "Employeeid,EmployeeName,EmployeeSalary,EmployeeCity")] Employee employee)

{

if (ModelState.IsValid)

{

db.Employees.Add(employee);

db.SaveChanges();

return RedirectToAction("Index");

}

return View(employee);

}

// GET: Employees/Edit/5

public ActionResult Edit(int? id)

{

if (id == null)

{

return new HttpStatusCodeResult(HttpStatusCode.BadRequest);

}

Employee employee = db.Employees.Find(id);

if (employee == null)

{

return HttpNotFound();

}

return View(employee);

}

// POST: Employees/Edit/5

// To protect from overposting attacks, enable the specific properties you want to bind to, for

// more details see https://go.microsoft.com/fwlink/?LinkId=317598.

[HttpPost]

[ValidateAntiForgeryToken]

public ActionResult Edit([Bind(Include = "Employeeid,EmployeeName,EmployeeSalary,EmployeeCity")] Employee employee)

{

if (ModelState.IsValid)

{

db.Entry(employee).State = EntityState.Modified;

db.SaveChanges();

return RedirectToAction("Index");

}

return View(employee);

}

// GET: Employees/Delete/5

public ActionResult Delete(int? id)

{

if (id == null)

{

return new HttpStatusCodeResult(HttpStatusCode.BadRequest);

}

Employee employee = db.Employees.Find(id);

if (employee == null)

{

return HttpNotFound();

}

return View(employee);

}

// POST: Employees/Delete/5

[HttpPost, ActionName("Delete")]

[ValidateAntiForgeryToken]

public ActionResult DeleteConfirmed(int id)

{

Employee employee = db.Employees.Find(id);

db.Employees.Remove(employee);

db.SaveChanges();

return RedirectToAction("Index");

}

protected override void Dispose(bool disposing)

{

if (disposing)

{

db.Dispose();

}

base.Dispose(disposing);

}

HomeController.cs

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.Mvc;

namespace CrudMVCEntity.Controllers

{

public class HomeController : Controller

{

public ActionResult Index()

{

return View();

}

public ActionResult About()

{

ViewBag.Message = "Your application description page.";

return View();

}

public ActionResult Contact()

{

ViewBag.Message = "Your contact page.";

return View();

}

Models[Folder]

It is Automatic Created by the help of Database.

Views[Folder]

Employees

Create.cshtml

@model CrudMVCEntity.Models.Employee

ViewBag.Title = "Create";

}

<h2>Create</h2>

@using (Html.BeginForm())

{

@Html.AntiForgeryToken()

<h4>Employee</h4>

<hr />

@Html.ValidationSummary(true, "", new { @class = "text-danger" })

@Html.LabelFor(model => model.Employeeid, htmlAttributes: new { @class = "control-label col-md-2" })

@Html.EditorFor(model => model.Employeeid, new { htmlAttributes = new { @class = "form-control" } })

@Html.ValidationMessageFor(model => model.Employeeid, "", new { @class = "text-danger" })

</div>

@Html.LabelFor(model => model.EmployeeName, htmlAttributes: new { @class = "control-label col-md-2" })

@Html.EditorFor(model => model.EmployeeName, new { htmlAttributes = new { @class = "form-control" } })

@Html.ValidationMessageFor(model => model.EmployeeName, "", new { @class = "text-danger" })

</div>

@Html.LabelFor(model => model.EmployeeSalary, htmlAttributes: new { @class = "control-label col-md-2" })

@Html.EditorFor(model => model.EmployeeSalary, new { htmlAttributes = new { @class = "form-control" } })

@Html.ValidationMessageFor(model => model.EmployeeSalary, "", new { @class = "text-danger" })

</div>

@Html.LabelFor(model => model.EmployeeCity, htmlAttributes: new { @class = "control-label col-md-2" })

@Html.EditorFor(model => model.EmployeeCity, new { htmlAttributes = new { @class = "form-control" } })

@Html.ValidationMessageFor(model => model.EmployeeCity, "", new { @class = "text-danger" })

</div>

</div>

}

<div>

@Html.ActionLink("Back to List", "Index")

</div>

@section Scripts {

@Scripts.Render("~/bundles/jqueryval")

}

Delete.cshtml

@model CrudMVCEntity.Models.Employee

ViewBag.Title = "Delete";

}

<h2>Delete</h2>

<h3>Are you sure you want to delete this?</h3>

<div>

<h4>Employee</h4>

<hr />

<dt>

@Html.DisplayNameFor(model => model.EmployeeName)

</dt>

<dd>

@Html.DisplayFor(model => model.EmployeeName)

</dd>

<dt>

@Html.DisplayNameFor(model => model.EmployeeSalary)

</dt>

<dd>

@Html.DisplayFor(model => model.EmployeeSalary)

</dd>

<dt>

@Html.DisplayNameFor(model => model.EmployeeCity)

</dt>

<dd>

@Html.DisplayFor(model => model.EmployeeCity)

</dd>

</dl>

@using (Html.BeginForm()) {

@Html.AntiForgeryToken()

<input type="submit" value="Delete" class="btn btn-default" /> |

@Html.ActionLink("Back to List", "Index")

</div>

}

</div>

Details.cshtml

@model CrudMVCEntity.Models.Employee

ViewBag.Title = "Details";

}

<h2>Details</h2>

<div>

<h4>Employee</h4>

<hr />

<dt>

@Html.DisplayNameFor(model => model.EmployeeName)

</dt>

<dd>

@Html.DisplayFor(model => model.EmployeeName)

</dd>

<dt>

@Html.DisplayNameFor(model => model.EmployeeSalary)

</dt>

<dd>

@Html.DisplayFor(model => model.EmployeeSalary)

</dd>

<dt>

@Html.DisplayNameFor(model => model.EmployeeCity)

</dt>

<dd>

@Html.DisplayFor(model => model.EmployeeCity)

</dd>

</dl>

</div>

<p>

@Html.ActionLink("Edit", "Edit", new { id = Model.Employeeid }) |

@Html.ActionLink("Back to List", "Index")

</p>

Edit.cshtml

@model CrudMVCEntity.Models.Employee

ViewBag.Title = "Edit";

}

@using (Html.BeginForm())

{

@Html.AntiForgeryToken()

<h4>Employee</h4>

<hr />

@Html.ValidationSummary(true, "", new { @class = "text-danger" })

@Html.HiddenFor(model => model.Employeeid)

@Html.LabelFor(model => model.EmployeeName, htmlAttributes: new { @class = "control-label col-md-2" })

@Html.EditorFor(model => model.EmployeeName, new { htmlAttributes = new { @class = "form-control" } })

@Html.ValidationMessageFor(model => model.EmployeeName, "", new { @class = "text-danger" })

</div>

@Html.LabelFor(model => model.EmployeeSalary, htmlAttributes: new { @class = "control-label col-md-2" })

@Html.EditorFor(model => model.EmployeeSalary, new { htmlAttributes = new { @class = "form-control" } })

@Html.ValidationMessageFor(model => model.EmployeeSalary, "", new { @class = "text-danger" })

</div>

@Html.LabelFor(model => model.EmployeeCity, htmlAttributes: new { @class = "control-label col-md-2" })

@Html.EditorFor(model => model.EmployeeCity, new { htmlAttributes = new { @class = "form-control" } })

@Html.ValidationMessageFor(model => model.EmployeeCity, "", new { @class = "text-danger" })

</div>

</div>

}

<div>

@Html.ActionLink("Back to List", "Index")

</div>

@section Scripts {

@Scripts.Render("~/bundles/jqueryval")

}

Index.cshtm

@model IEnumerable<CrudMVCEntity.Models.Employee>

ViewBag.Title = "Index";

}

<h2>Index</h2>

<p>

@Html.ActionLink("Create New", "Create")

</p>

<tr>

<th>

@Html.DisplayNameFor(model => model.EmployeeName)

</th>

<th>

@Html.DisplayNameFor(model => model.EmployeeSalary)

</th>

<th>

@Html.DisplayNameFor(model => model.EmployeeCity)

</th>

</tr>

@foreach (var item in Model) {

<tr>

<td>

@Html.DisplayFor(modelItem => item.EmployeeName)

</td>

<td>

@Html.DisplayFor(modelItem => item.EmployeeSalary)

</td>

<td>

@Html.DisplayFor(modelItem => item.EmployeeCity)

</td>

<td>

@Html.ActionLink("Edit", "Edit", new { id=item.Employeeid }) |

@Html.ActionLink("Details", "Details", new { id=item.Employeeid }) |

@Html.ActionLink("Delete", "Delete", new { id=item.Employeeid })

</td>

</tr>

}

</table>

Home

About.cshtml

ViewBag.Title = "About";

}

<h2>@ViewBag.Title.</h2>

<h3>@ViewBag.Message</h3>

<p>Use this area to provide additional information.</p>

Contact.cshtml

ViewBag.Title = "Contact";

}

<h2>@ViewBag.Title.</h2>

<h3>@ViewBag.Message</h3>

One Microsoft Way<br />

Redmond, WA 98052-6399<br />

425.555.0100

</address>

<strong>Support:</strong> <a href="mailto:Support@example.com">Support@example.com</a><br />

<strong>Marketing:</strong> <a href="mailto:Marketing@example.com">Marketing@example.com</a>

</address>

Web.config

<?xml version="1.0" encoding="utf-8"?>

<!--

For more information on how to configure your ASP.NET application, please visit

https://go.microsoft.com/fwlink/?LinkId=301880

-->

</configSections>

</appSettings>

<system.web>

</system.web>

</dependentAssembly>

</dependentAssembly>

</dependentAssembly>

</dependentAssembly>

</dependentAssembly>

</dependentAssembly>

</dependentAssembly>

</assemblyBinding>

</runtime>

<system.codedom>

</compilers>

</system.codedom>

</providers>

</entityFramework>

</connectionStrings>

</configuration>

Follow us

CRUD Operations in MVC in Asp.Net