public ActionResult DeleteConfirmed(int id) { try { BatchProgramCourse batchProgramCourse = db.BatchProgramCourses.Find(id); db.BatchProgramCourses.Remove(batchProgramCourse); 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.BatchProgramCourses = db.BatchProgramCourses.OrderByDescending(a => a.ProgramCourseID).ToList(); model.SelectedBatchProgramCourse = null; model.DisplayMode = "WriteOnly"; ViewBag.IsActive = new SelectList(db.Options, "OptionDesc", "OptionDesc"); ViewBag.CourseID = new SelectList(db.Courses, "CourseID", "CourseName"); ViewBag.BatchProgramID = new SelectList(db.GetBatchProgramNameConcat("", 0).ToList(), "ID", "Name"); ViewBag.CourseTypeID = new SelectList(db.CourseTypes, "CourseTypeID", "CourseTypeName"); return(View("Index", model)); }
public ActionResult Update(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } BatchProgramCourse batchProgramCourse = db.BatchProgramCourses.Find(id); if (batchProgramCourse == null) { return(HttpNotFound()); } model.BatchProgramCourses = db.BatchProgramCourses.OrderByDescending(a => a.ProgramCourseID).ToList(); model.SelectedBatchProgramCourse = batchProgramCourse; model.DisplayMode = "ReadWrite"; ViewBag.IsActive = new SelectList(db.Options, "OptionDesc", "OptionDesc", batchProgramCourse.IsActive); ViewBag.CourseID = new SelectList(db.Courses, "CourseID", "CourseName", batchProgramCourse.CourseID); ViewBag.BatchProgramID = new SelectList(db.GetBatchProgramNameConcat("", 0).ToList(), "ID", "Name", batchProgramCourse.BatchProgramID); ViewBag.CourseTypeID = new SelectList(db.CourseTypes, "CourseTypeID", "CourseTypeName", batchProgramCourse.CourseTypeID); ViewBag.MessageType = ""; ViewBag.Message = ""; return(View("Index", model)); }
public ActionResult Edit(BatchProgramCourse batchProgramCourse) { try { if (batchProgramCourse.YearSemesterNo == 0) { ViewBag.MessageType = "error"; ViewBag.Message = "Year/Semester # should not be 0."; ModelState.AddModelError(string.Empty, "Year/Semester # should not be 0."); } else { db.Entry(batchProgramCourse).State = EntityState.Modified; batchProgramCourse.ModifiedBy = Convert.ToInt32(Session["emp_id"]); batchProgramCourse.ModifiedOn = DateTime.Now; try { db.SaveChanges(); ViewBag.MessageType = "success"; ViewBag.Message = "Data has been saved successfully."; } catch (DbUpdateException ex) { ViewBag.MessageType = "error"; ViewBag.Message = ex.Message; ModelState.AddModelError(string.Empty, ex.Message); } } } catch (DbEntityValidationException ex) { string ErrorMessage = ""; int count = 0; foreach (DbEntityValidationResult validationResult in ex.EntityValidationErrors) { string entityName = validationResult.Entry.Entity.GetType().Name; foreach (DbValidationError error in validationResult.ValidationErrors) { ModelState.AddModelError(string.Empty, error.ErrorMessage); count++; ErrorMessage += string.Concat(count, "-", error.ErrorMessage, "\n"); } } ViewBag.MessageType = "error"; ViewBag.Message = ErrorMessage; } model.BatchProgramCourses = db.BatchProgramCourses.OrderByDescending(a => a.ProgramCourseID).ToList(); model.SelectedBatchProgramCourse = null; model.DisplayMode = "WriteOnly"; ViewBag.IsActive = new SelectList(db.Options, "OptionDesc", "OptionDesc", batchProgramCourse.IsActive); ViewBag.CourseID = new SelectList(db.Courses, "CourseID", "CourseName", batchProgramCourse.CourseID); ViewBag.BatchProgramID = new SelectList(db.GetBatchProgramNameConcat("", 0).ToList(), "ID", "Name", batchProgramCourse.BatchProgramID); ViewBag.CourseTypeID = new SelectList(db.CourseTypes, "CourseTypeID", "CourseTypeName", batchProgramCourse.CourseTypeID); return(View("Index", model)); }
public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } BatchProgramCourse batchProgramCourse = db.BatchProgramCourses.Find(id); if (batchProgramCourse == null) { return(HttpNotFound()); } model.BatchProgramCourses = db.BatchProgramCourses.OrderByDescending(a => a.ProgramCourseID).ToList(); model.SelectedBatchProgramCourse = batchProgramCourse; model.DisplayMode = "Delete"; ViewBag.MessageType = ""; ViewBag.Message = ""; return(View("Index", model)); }
public ActionResult Assign(int?id, int?sID) { BatchProgramCourse bpc = new BatchProgramCourse(); try { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } bpc = db.BatchProgramCourses.Find(id); if (bpc == null) { return(HttpNotFound()); } else { bpc.CreatedBy = Convert.ToInt32(Session["emp_id"]); db.InsertStudentBatchProgramCourse(bpc.ProgramCourseID, sID, bpc.CourseID , bpc.YearSemesterNo, bpc.BatchProgramID, bpc.CreatedBy, bpc.IsActive, 0); ViewBag.MessageType = "success"; ViewBag.Message = "Data has been saved successfully."; ViewBag.BatchProgramID = new SelectList(db.GetBatchProgramNameConcat("", 0), "ID", "Name", bpc.BatchProgramID); ViewBag.YearSemesterNo = new SelectList(db.Semesters, "YearSemesterNo", "YearSemesterNo", bpc.YearSemesterNo); ViewBag.hdnBatchProgramID = bpc.BatchProgramID; ViewBag.hdnYearSemesterNo = bpc.YearSemesterNo; ViewBag.StudentID = sID; } } catch (Exception ex) { ViewBag.MessageType = "error"; ViewBag.Message = ex.Message; } return(View("Index")); }
public ActionResult Create(BatchProgramCourse batchProgramCourse) { string ErrorMessage = ""; int count = 0; try { if (batchProgramCourse.YearSemesterNo == 0) { ViewBag.MessageType = "error"; ViewBag.Message = "Year/Semester # should not be 0."; ModelState.AddModelError(string.Empty, "Year/Semester # should not be 0."); } else { BatchProgramCourse pc = db.BatchProgramCourses.FirstOrDefault( p => p.BatchProgramID == batchProgramCourse.BatchProgramID && p.CourseID == batchProgramCourse.CourseID && p.YearSemesterNo == batchProgramCourse.YearSemesterNo); if (pc != null) { ViewBag.MessageType = "error"; ViewBag.Message = "Selected Course is already exists against the same Program and Year/Semester #."; ModelState.AddModelError(string.Empty, "Selected Course is already exists against the same Program and Year/Semester #."); } else { batchProgramCourse.CreatedBy = Convert.ToInt32(Session["emp_id"]); batchProgramCourse.CreatedOn = DateTime.Now; db.BatchProgramCourses.Add(batchProgramCourse); try { db.SaveChanges(); ViewBag.MessageType = "success"; ViewBag.Message = "Data has been saved successfully."; } catch (DbUpdateException ex) { ViewBag.MessageType = "error"; ViewBag.Message = ex.Message; ModelState.AddModelError(string.Empty, ex.Message); } } } } catch (DbEntityValidationException ex) { foreach (DbEntityValidationResult validationResult in ex.EntityValidationErrors) { string entityName = validationResult.Entry.Entity.GetType().Name; foreach (DbValidationError error in validationResult.ValidationErrors) { ModelState.AddModelError(string.Empty, error.ErrorMessage); count++; ErrorMessage += count + "-" + string.Concat(error.PropertyName, " is required.") + "<br />"; } } ViewBag.MessageType = "error"; ViewBag.Message = ErrorMessage; } model.BatchProgramCourses = db.BatchProgramCourses.OrderByDescending(a => a.ProgramCourseID).ToList(); model.SelectedBatchProgramCourse = null; model.DisplayMode = "WriteOnly"; ViewBag.IsActive = new SelectList(db.Options, "OptionDesc", "OptionDesc", batchProgramCourse.IsActive); ViewBag.CourseID = new SelectList(db.Courses, "CourseID", "CourseName", batchProgramCourse.CourseID); ViewBag.BatchProgramID = new SelectList(db.GetBatchProgramNameConcat("", 0).ToList(), "ID", "Name", batchProgramCourse.BatchProgramID); ViewBag.CourseTypeID = new SelectList(db.CourseTypes, "CourseTypeID", "CourseTypeName", batchProgramCourse.CourseTypeID); return(View("Index", model)); }