public ActionResult DeleteConfirmed(int id) { TblGrade tblGrade = db.TblGrades.Find(id); db.TblGrades.Remove(tblGrade); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "GradeId,SchoolId,LearnerId,GradeName,GradeMark,GradeStartDate,GradeEndDate")] TblGrade tblGrade) { if (ModelState.IsValid) { db.Entry(tblGrade).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.LearnerId = new SelectList(db.TblLearners.Where(a => a.SchoolId == tblGrade.SchoolId), "LearnerId", "LearnerCode", tblGrade.LearnerId); ViewBag.SchoolId = new SelectList(db.TblSchools.Where(a => a.SchoolId == tblGrade.SchoolId), "SchoolId", "SchoolCode", tblGrade.SchoolId); return(View(tblGrade)); }
public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } TblGrade tblGrade = db.TblGrades.Find(id); if (tblGrade == null) { return(HttpNotFound()); } return(View(tblGrade)); }
public ActionResult Edit(int?id) { Uri currentUrl = Request.UrlReferrer; if (currentUrl == null) { return(HttpNotFound()); } HttpCookie usesrCookie = Request.Cookies["UserInformation"]; if (usesrCookie == null) { return(RedirectToAction("LoginHomeIndex", "PCMSLogin")); } int?school = Int32.Parse(pcmsLoginController.LoggedOnUserData(usesrCookie)[1]); //Get UserID int?userID = Int32.Parse(pcmsLoginController.LoggedOnUserData(usesrCookie)[3]); if (db.TblUsers.Find(userID) != null) { ViewBag.UserName = db.TblUsers.Find(userID).UserName; } else if (db.TblSystemAdmins.Find(userID) != null) { ViewBag.UserName = "******"; } else { ViewBag.UserName = ""; } bool check = false; int userId = Int32.Parse(pcmsLoginController.LoggedOnUserData(usesrCookie)[3]); if (userId == db.TblSystemAdmins.FirstOrDefault().UserId) { check = true; } ViewBag.PCMS = check; var School = db.TblSchools.Find(school); if (School != null) { ViewBag.SchoolCode = School.SchoolCode; ViewBag.SchoolName = School.SchoolName; } else { ViewBag.SchoolCode = null; ViewBag.SchoolName = null; } if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } TblGrade tblGrade = db.TblGrades.Find(id); if (tblGrade == null) { return(HttpNotFound()); } ViewBag.LearnerId = new SelectList(db.TblLearners.Where(a => a.SchoolId == school), "LearnerId", "LearnerName", tblGrade.LearnerId); ViewBag.School = new SelectList(db.TblSchools.Where(a => a.SchoolId == school), "SchoolId", "SchoolName", tblGrade.SchoolId); ViewBag.SchoolId = tblGrade.SchoolId; return(View(tblGrade)); }