//GetData public ActionResult GetData() { using (DBModel2 db = new DBModel2()) { List <Player> playList = db.Players.ToList <Player>(); return(Json(new { data = playList }, JsonRequestBehavior.AllowGet)); } }
public ActionResult Delete(int id) { using (DBModel2 db = new DBModel2()) { Player emp = db.Players.Where(x => x.PlayerID == id).FirstOrDefault <Player>(); db.Players.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 Player())); } else { using (DBModel2 db = new DBModel2()) { return(View(db.Players.Where(x => x.PlayerID == id).FirstOrDefault <Player>())); } } }
public ActionResult AddOrEdit(Player play) { using (DBModel2 db = new DBModel2()) { if (play.PlayerID == 0) { db.Players.Add(play); db.SaveChanges(); return(Json(new { success = true, message = "Saved Successfully" }, JsonRequestBehavior.AllowGet)); } else { db.Entry(play).State = EntityState.Modified; db.SaveChanges(); return(Json(new { success = true, message = "Updated Successfully" }, JsonRequestBehavior.AllowGet)); } } }