Countroller Code:-
using System;using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using mvc_entity_jquery_21july.Models;
using System.Data;
namespace mvc_entity_jquery_21july.Controllers
{
public class HomeController : Controller
{
Entityframework21julyEntities _db = new Entityframework21julyEntities();
Emp _emp = new Emp();
[HttpGet]
public ActionResult Index()
{
return View();
}
[HttpPost]
public ActionResult Index(string A, string B, int C)
{
_emp.name = A;
_emp.address = B;
_emp.age = C;
_db.Emps.Add(_emp);
_db.SaveChanges();
return View();
}
public JsonResult Get()
{
var _data = _db.Emps.ToList();
return Json(_data, JsonRequestBehavior.AllowGet);
}
public JsonResult Delete(int A)
{
var _data = _db.Emps.Find(A);
_db.Emps.Remove(_data);
_db.SaveChanges();
return Json("", JsonRequestBehavior.AllowGet);
}
public JsonResult Edit(int A)
{
var _data = (from a in _db.Emps where a.empid==A select a).ToList();
return Json(_data, JsonRequestBehavior.AllowGet);
}
public JsonResult Update(string A, string B, int C, int D)
{
_emp.name = A;
_emp.address = B;
_emp.age = C;
_emp.empid = D;
_db.Entry(_emp).State = EntityState.Modified;
_db.SaveChanges();
return Json("", JsonRequestBehavior.AllowGet);
}
}
}
View page Code:-
@{
ViewBag.Title = "Index";
}
<h2>Index</h2>
<table>
<tr>
<td>Name :</td>
<td>
<input type="text" id="txtname" /></td>
</tr>
<tr>
<td>Address :</td>
<td>
<input type="text" id="txtaddress" /></td>
</tr>
<tr>
<td>Age :</td>
<td>
<input type="text" id="txtage" /></td>
</tr>
<tr>
<td></td>
<td>
<input type="button" id="btnsave" value="Save" onclick="SaveData()" /></td>
</tr>
</table>
<table id="tbl" style="background-color:pink" border="1">
<tr style="background-color:maroon;color:white">
<th>Name</th>
<th>Address</th>
<th>Age</th>
<th></th>
<th></th>
</tr>
</table>
<script src="~/jquery.min.js"></script>
<script type="text/javascript">
$(document).ready(function () {
GetData();
});
function GetData() {
$.ajax({
url: 'Home/Get',
type: 'post',
data: {},
success: function (_ds) {
$("#tbl").find("tr:gt(0)").remove();
for (var i = 0; i < _ds.length; i++) {
$("#tbl").append('<tr> <td>' + _ds[i].name + '</td> <td>' + _ds[i].address + '</td> <td>' + _ds[i].age + '</td> <td><input type="button" id="btndelete" value="Delete" onclick="DeleteData(' + _ds[i].empid + ')" /></td> <td><input type="button" id="btnedit" value="Edit" onclick="EditData(' + _ds[i].empid + ')" /></td> </tr>');
}
},
error: function () {
alert('get error !!');
}
});
}
function SaveData() {
if ($("#btnsave").val() == "Save") {
$.ajax({
url: 'Home/Index',
type: 'post',
data: { A: $("#txtname").val(), B: $("#txtaddress").val(), C: $("#txtage").val() },
success: function () {
alert('insert success !!');
GetData();
},
error: function () {
alert('insert error !!');
}
});
}
else {
$.ajax({
url: 'Home/Update',
type: 'post',
data: { A: $("#txtname").val(), B: $("#txtaddress").val(), C: $("#txtage").val(), D: idd },
success: function () {
alert('update success !!');
GetData();
},
error: function () {
alert('update error !!');
}
});
}
}
function DeleteData(eid) {
$.ajax({
url: 'Home/Delete',
type: 'post',
data: { A: eid },
success: function () {
alert('delete success !!');
GetData();
},
error: function () {
alert('delete error !!');
}
});
}
var idd = 0;
function EditData(eid) {
$.ajax({
url: 'Home/Edit',
type: 'post',
data: { A: eid },
success: function (_ds) {
$("#txtname").val(_ds[0].name);
$("#txtaddress").val(_ds[0].address);
$("#txtage").val(_ds[0].age);
$("#btnsave").val("Update");
idd = eid;
},
error: function () {
alert('edit error !!');
}
});
}
</script>
1 comment:
bad
Post a Comment