public ActionResult DeleteConfirmed(int id) { try { StudentProgramEnrollment studentProgramEnrollment = db.StudentProgramEnrollments.Find(id); db.StudentProgramEnrollments.Remove(studentProgramEnrollment); db.SaveChanges(); ViewBag.MessageType = "success"; ViewBag.Message = "Record has been removed successfully."; } catch (DbUpdateException ex) { ViewBag.MessageType = "error"; ViewBag.Message = ex.Message; ModelState.AddModelError(string.Empty, ex.Message); } model.StudentProgramEnrollments = db.StudentProgramEnrollments.OrderByDescending(e => e.EnrollmentID).ToList(); model.SelectedStudentProgramEnrollment = null; model.DisplayMode = "WriteOnly"; ViewBag.IsActive = new SelectList(db.Options, "OptionDesc", "OptionDesc"); ViewBag.BatchProgramID = new SelectList(db.GetBatchProgramNameConcat("", 0), "ID", "Name"); ViewBag.DegreeCompleted = new SelectList(db.Options, "OptionDesc", "OptionDesc"); return(View("Index", model)); }
public ActionResult Create(StudentProgramEnrollment studentProgramEnrollment) { StudentProgramEnrollment en = db.StudentProgramEnrollments.FirstOrDefault(e => e.StudentID == studentProgramEnrollment.StudentID); if (en == null) { studentProgramEnrollment.CreatedBy = Convert.ToInt32(Session["emp_id"]); try { if (studentProgramEnrollment.EnrollmentNo != null && studentProgramEnrollment.EnrollmentNo != "") { db.Insert_StudentEnrollment(studentProgramEnrollment.StudentID , studentProgramEnrollment.BatchProgramID , studentProgramEnrollment.AdmissionDate , studentProgramEnrollment.EnrollmentNo , studentProgramEnrollment.RegistrationNo , studentProgramEnrollment.DegreeCompleted , studentProgramEnrollment.DegreeCompletionDate , studentProgramEnrollment.CreatedBy , studentProgramEnrollment.IsActive); ViewBag.MessageType = "success"; ViewBag.Message = "Data has been saved successfully."; } else { ModelState.AddModelError(string.Empty, "Enrollment is already exists."); ViewBag.MessageType = "error"; ViewBag.Message = "Enrollment No is required."; } } catch (SqlException ex) { ViewBag.MessageType = "error"; ViewBag.Message = ex.Message; ModelState.AddModelError(string.Empty, ex.Message); } } else { ModelState.AddModelError(string.Empty, "Enrollment is already exists."); ViewBag.MessageType = "error"; ViewBag.Message = "Enrollment is already exists."; } model.StudentProgramEnrollments = db.StudentProgramEnrollments.OrderByDescending(e => e.EnrollmentID).ToList(); model.SelectedStudentProgramEnrollment = null; model.DisplayMode = "WriteOnly"; ViewBag.IsActive = new SelectList(db.Options, "OptionDesc", "OptionDesc", studentProgramEnrollment.IsActive); ViewBag.BatchProgramID = new SelectList(db.GetBatchProgramNameConcat("", 0), "ID", "Name", studentProgramEnrollment.BatchProgramID); ViewBag.DegreeCompleted = new SelectList(db.Options, "OptionDesc", "OptionDesc"); return(View("Index", model)); }
public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } StudentProgramEnrollment studentProgramEnrollment = db.StudentProgramEnrollments.Find(id); if (studentProgramEnrollment == null) { return(HttpNotFound()); } model.StudentProgramEnrollments = db.StudentProgramEnrollments.OrderByDescending(e => e.EnrollmentID).ToList(); model.SelectedStudentProgramEnrollment = studentProgramEnrollment; model.DisplayMode = "Delete"; ViewBag.MessageType = ""; ViewBag.Message = ""; return(View("Index", model)); }