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));
        }