Insert Update Delete in MVC
For Insert
See example by using this link.
For Update & Delete
--------------------
Code of View Page of Grid View Details
@model IEnumerable<VijayMVCWebApp.Models.UserNewReg>
@{
ViewBag.Title = "UserGridList";
Layout = "~/Views/Shared/_Layout.cshtml";
}
<h2>UserGridList</h2>
<table id="tblCustomers" cellpadding="0" cellspacing="0" class="table">
<tr>
<th>Name</th>
<th>Gender</th>
<th>EmailId</th>
<th>Password</th>
<th>MobileNo</th>
<th>Action</th>
</tr>
@foreach (var customer in Model)
{
<tr>
<td class="Name"><span>@customer.Name</span><input type="text" value="@customer.Name" style="display:none" /></td>
<td class="Gender"><span>@customer.Gender</span><input type="text" value="@customer.Gender" style="display:none" /></td>
<td class="EmailId"><span>@customer.EmailId</span><input type="text" value="@customer.EmailId" style="display:none" /></td>
<td class="Password"><span>@customer.Password</span><input type="text" value="@customer.Password" style="display:none" /></td>
<td class="MobileNo"><span>@customer.MobileNo</span><input type="text" value="@customer.MobileNo" style="display:none" /></td>
<td>
<a class="Edit" href="javascript:;">Edit</a>
<a class="Update" href="javascript:;" style="display:none">Update</a>
<a class="Cancel" href="javascript:;" style="display:none">Cancel</a>
<a class="Delete" href="javascript:;">Delete</a>
</td>
</tr>
}
</table>
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js"></script>
<script type="text/javascript" src="http://ajax.cdnjs.com/ajax/libs/json2/20110223/json2.js"></script>
<script type="text/javascript">
//Edit event handler.
$("body").on("click", "#tblCustomers .Edit", function () {
var row = $(this).closest("tr");
$("td", row).each(function () {
if ($(this).find("input").length > 0) {
$(this).find("input").show();
$(this).find("span").hide();
}
});
row.find(".Update").show();
row.find(".Cancel").show();
row.find(".Delete").hide();
$(this).hide();
});
//Update event handler.
$("body").on("click", "#tblCustomers .Update", function () {
var row = $(this).closest("tr");
$("td", row).each(function () {
if ($(this).find("input").length > 0) {
var span = $(this).find("span");
var input = $(this).find("input");
span.html(input.val());
span.show();
input.hide();
}
});
row.find(".Edit").show();
row.find(".Delete").show();
row.find(".Cancel").hide();
$(this).hide();
var customer = {};
customer.Name = row.find(".Name").find("span").html();
customer.Gender = row.find(".Gender").find("span").html();
customer.EmailId = row.find(".EmailId").find("span").html();
customer.Password = row.find(".Password").find("span").html();
customer.MobileNo = row.find(".MobileNo").find("span").html();
$.ajax({
type: "POST",
url: "/Home/UpdateCustomer",
data: '{customer:' + JSON.stringify(customer) + '}',
contentType: "application/json; charset=utf-8",
dataType: "json"
});
});
//Cancel event handler.
$("body").on("click", "#tblCustomers .Cancel", function () {
var row = $(this).closest("tr");
$("td", row).each(function () {
if ($(this).find("input").length > 0) {
var span = $(this).find("span");
var input = $(this).find("input");
input.val(span.html());
span.show();
input.hide();
}
});
row.find(".Edit").show();
row.find(".Delete").show();
row.find(".Update").hide();
$(this).hide();
});
//Delete event handler.
$("body").on("click", "#tblCustomers .Delete", function () {
if (confirm("Do you want to delete this row?")) {
var row = $(this).closest("tr");
var emailID = row.find(".EmailId").find("span").html();
$.ajax({
type: "POST",
url: "/Home/DeleteCustomer",
data: '{emailid: ' + emailID + '}',
contentType: "application/json; charset=utf-8",
dataType: "json",
success: function (response) {
row.remove();
}
});
}
});
</script>
=================================================
Add Function in Home Controller
FOR UPDATE & DELETE
//UPDATE
-----------------------------------------------------------------------------------
[HttpPost]
public ActionResult UpdateCustomer(UserNewReg customer)
{
using (DotNetDBEntities entities = new DotNetDBEntities())
{
UserNewReg updatedCustomer = (from c in entities.UserNewRegs
where c.EmailId == customer.EmailId
select c).FirstOrDefault();
updatedCustomer.Name = customer.Name;
updatedCustomer.MobileNo = customer.MobileNo;
updatedCustomer.EmailId = customer.EmailId;
updatedCustomer.Password = customer.Password;
entities.SaveChanges();
}
return new EmptyResult();
}
--------------------------------------------------------------------------------------
DELETE
[HttpPost]
public ActionResult DeleteCustomer(string emailid)
{
using (DotNetDBEntities entities = new DotNetDBEntities())
{
UserNewReg customer = (from c in entities.UserNewRegs
where c.EmailId == emailid
select c).FirstOrDefault();
entities.UserNewRegs.Remove(customer);
entities.SaveChanges();
}
return new EmptyResult();
}
--------------------------------------------------------------------------------------
SEE OUTPUT
