public ActionResult GetData()
{
using (AJAXEntities db = new AJAXEntities())
{
List <Employee> empList = db.Employees.ToList <Employee>();
return(Json(new { data = empList }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Delete(int id)
{
using (AJAXEntities db = new AJAXEntities())
{
Employee emp = db.Employees.Where(x => x.EmployeeID == id).FirstOrDefault <Employee>();
db.Employees.Remove(emp);
db.SaveChanges();
return(Json(new { success = true, message = "Deleted Successfully" }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult AddOrEdit(int id = 0)
{
if (id == 0)
{
return(View(new Employee()));
}
else
{
using (AJAXEntities db = new AJAXEntities())
{
return(View(db.Employees.Where(x => x.EmployeeID == id).FirstOrDefault <Employee>()));
}
}
}
public ActionResult AddOrEdit(Employee emp)
{
using (AJAXEntities db = new AJAXEntities())
{
if (emp.EmployeeID == 0)
{
db.Employees.Add(emp);
db.SaveChanges();
return(Json(new { success = true, message = "Saved Successfully" }, JsonRequestBehavior.AllowGet));
}
else
{
db.Entry(emp).State = EntityState.Modified;
db.SaveChanges();
return(Json(new { success = true, message = "Updated Successfully" }, JsonRequestBehavior.AllowGet));
}
}
}