public ActionResult Delete(int id) { try { using (AjaxCRUD_DBEntities db = new AjaxCRUD_DBEntities()) { Student std = db.Students.Where(x => x.StudentId == id).FirstOrDefault <Student>(); db.Students.Remove(std); db.SaveChanges(); } return(Json(new { success = true, html = GlobalClass.RenderRazorViewToString(this, "ViewAll", GetAllStudents()), message = "Deleted Successfully." }, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json(new { success = false, message = ex.Message }, JsonRequestBehavior.AllowGet)); } }
public ActionResult AddOrEdit([Bind(Include = "GradeId,Grade1,TeacherId,StudentId")] Grade grd) { using (AjaxCRUD_DBEntities db = new AjaxCRUD_DBEntities()) { if (grd.GradeId == 0 && ModelState.IsValid) { db.Grades.Add(grd); db.SaveChanges(); } else if (grd.GradeId != 0 && ModelState.IsValid) { db.Entry(grd).State = EntityState.Modified; db.SaveChanges(); } ViewBag.StudentId = new SelectList(db.Students, "StudentId", "Name", "LastName"); ViewBag.TeacherId = new SelectList(db.Teachers, "TeacherId", "FirstName", "LastName"); } return(Json(new { success = true, html = GlobalClass.RenderRazorViewToString(this, "ViewAll", GetAllGrades()), message = "Submitted Successfully." }, JsonRequestBehavior.AllowGet)); }
public ActionResult AddOrEdit(int id = 0) { Student std = new Student(); if (id != 0) { using (AjaxCRUD_DBEntities db = new AjaxCRUD_DBEntities()) { std = db.Students.Where(x => x.StudentId == id).FirstOrDefault <Student>(); } } ViewBag.UniversityId = new SelectList(db.Universities, "UniversityId", "Name"); return(View(std)); }
public ActionResult AddOrEdit(int id = 0) { Grade grd = new Grade(); if (id != 0) { using (AjaxCRUD_DBEntities db = new AjaxCRUD_DBEntities()) { grd = db.Grades.Where(x => x.GradeId == id).FirstOrDefault <Grade>(); } } ViewBag.StudentId = new SelectList(db.Students, "StudentId", "FirstName", "LastName"); ViewBag.TeacherId = new SelectList(db.Teachers, "TeacherId", "FirstName", "LastName"); return(View(grd)); }
public ActionResult AddOrEdit([Bind(Include = "StudentId,FirstName,LastName,Age,UniversityId")] Student std) { using (AjaxCRUD_DBEntities db = new AjaxCRUD_DBEntities()) { if (std.StudentId == 0 && ModelState.IsValid) { db.Students.Add(std); db.SaveChanges(); } else if (std.StudentId != 0 && ModelState.IsValid) { db.Entry(std).State = EntityState.Modified; db.SaveChanges(); } ViewBag.StudentId = new SelectList(db.Universities, "UniversityId", "Name"); } return(Json(new { success = true, html = GlobalClass.RenderRazorViewToString(this, "ViewAll", GetAllStudents()), message = "Submitted Successfully." }, JsonRequestBehavior.AllowGet)); }