Insert Update Delete in MVC

Insert Update Delete in MVC 

For Insert

See example by using this link.

http://dotnetbyvickypedia.blogspot.in/2017/06/registration-page-using-mvc.html

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