public ActionResult GetData()
{
using (DataTableCRUDDbContext db = new DataTableCRUDDbContext())
{
List <User> userList = db.Users.ToList <User>();
return(Json(new { data = userList }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Delete(int id)
{
using (DataTableCRUDDbContext db = new DataTableCRUDDbContext())
{
User user = db.Users.Where(x => x.UserID == id).FirstOrDefault <User>();
db.Users.Remove(user);
db.SaveChanges();
return(Json(new { success = true, message = "Data deleted successfully" }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult AddOrEdit(int id = 0)
{
if (id == 0)
{
return(View(new User()));
}
else
{
using (DataTableCRUDDbContext db = new DataTableCRUDDbContext())
{
return(View(db.Users.Where(x => x.UserID == id).FirstOrDefault <User>()));
}
}
}
public ActionResult AddOrEdit(User user)
{
using (DataTableCRUDDbContext db = new DataTableCRUDDbContext())
{
if (user.UserID == 0)
{
db.Users.Add(user);
db.SaveChanges();
return(Json(new { success = true, message = "Data inserted successfully" }, JsonRequestBehavior.AllowGet));
}
else
{
db.Entry(user).State = EntityState.Modified;
db.SaveChanges();
return(Json(new { success = true, message = "Data updated successfully" }, JsonRequestBehavior.AllowGet));
}
}
}
