public ActionResult GetData()
{
using (mvcCRUDDBEntities db = new mvcCRUDDBEntities())
{
List <employee> emplist = db.employees.ToList <employee>();
return(Json(new { data = emplist }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Delete(int?id)
{
using (mvcCRUDDBEntities db = new mvcCRUDDBEntities())
{
employee em = db.employees.Where(x => x.EMPLOYEEID == id).FirstOrDefault <employee>();
db.employees.Remove(em);
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
public ActionResult Edit(employee newEmployee)
{
if (ModelState.IsValid)
{
using (mvcCRUDDBEntities db = new mvcCRUDDBEntities())
{
db.Entry(newEmployee).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
else
{
return(View());
}
}
public ActionResult Edit(int?id)
{
employee t;
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
using (mvcCRUDDBEntities db = new mvcCRUDDBEntities())
{
t = db.employees.Find(id);
}
if (t == null)
{
return(HttpNotFound());
}
return(View(t));
}
public ActionResult Create(employee newEmployee)
{
if (ModelState.IsValid)
{
using (mvcCRUDDBEntities db = new mvcCRUDDBEntities())
{
db.employees.Add(newEmployee);
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
else
{
return(View());
}
}