public ActionResult Edit(ApplicationCommissioning applicationcommissioning) { if (ModelState.IsValid) { db.Entry(applicationcommissioning).State = EntityState.Modified; db.SaveChanges(); var thisStudent = db.Students.FirstOrDefault( o => o.StudentID == applicationcommissioning.StudentID); var newNotification = new Notification { Time = DateTime.Now, Details = "An Administrator has edited your application for Commissioning, filed on " + applicationcommissioning.DateFiled, Link = Url.Action("Details", "Commissioning", new { id = applicationcommissioning.Id }), ViewableBy = thisStudent.UserName, Complete = false }; db.Notification.Add(newNotification); db.SaveChanges(); TempData["message"] = "Changes saved."; return(this.RedirectToAction("AllCommissioningApplications")); } return(View(applicationcommissioning)); }
public ViewResult Details(int id) { Student student = db.Students.Find(id); //ViewBag.testCompletedCoreCourses = (from o in student where o.enrollment) int totalCoresPassed = db.Enrollments.Count(s => s.StudentID == id && s.Grade == "Credit Received" && s.Course.Elective == false); int totalElectivesPassed = db.Enrollments.Count(s => s.StudentID == id && s.Grade == "Credit Received" && s.Course.Elective); int totalCoresNeeded = db.CommissioningRequirements.Find(1).CoreCoursesRequired; int totalElectivesNeeded = db.CommissioningRequirements.Find(1).ElectiveCoursesRequired; ViewBag.coresPassed = totalCoresPassed; ViewBag.electivesPassed = totalElectivesPassed; ViewBag.coresNeeded = totalCoresNeeded; ViewBag.electivesNeeded = totalElectivesNeeded; IOrderedQueryable <ApplicationCommissioning> usersCommissionings = db.ApplicationCommissionings.Where(o => o.Student.UserName == student.UserName && o.Approved). OrderByDescending(m => m.DateApproved); ApplicationCommissioning usersMostRecentCommissioning = usersCommissionings.FirstOrDefault(); if (usersMostRecentCommissioning != null) { ViewBag.mostRecentCommissioningCertificateID = usersMostRecentCommissioning.Id; } return(View(student)); }
public ActionResult CertificateOfCommissioning(int id) { ApplicationCommissioning commissioning = db.ApplicationCommissionings.Find(id); if (commissioning.DateApproved != null) { DateTime dateTime = (DateTime)commissioning.DateApproved; var dateWithOrdinals = AddOrdinal(dateTime.Day); ViewBag.dateWithOrdinal = dateWithOrdinals; ViewBag.approvedDate = dateTime; ViewBag.approvedMonth = dateTime.ToString("MMMM"); ViewBag.expirationDate = dateTime.AddYears(5); } return(View(commissioning)); }
private static ApplicationCommissioning ApplicationWithUserData(Student thisStudent) { var applicationWithUserData = new ApplicationCommissioning { StudentID = thisStudent.StudentID, ReCommissioning = false, RecommendationFiled = false, PersonalStatement = "Type Personal Statement Here", DayOfReflection = false, ApplicationFeePaid = false, MeetsMinimumRequirements = false }; return(applicationWithUserData); }
public ViewResult Details(int id) { ApplicationCommissioning applicationcommissioning = db.ApplicationCommissionings.Find(id); var totalCoresNeeded = db.CommissioningRequirements.Find(1).CoreCoursesRequired; var totalElectivesNeeded = db.CommissioningRequirements.Find(1).ElectiveCoursesRequired; ViewBag.totalCoresNeeded = totalCoresNeeded; ViewBag.totalElectivesNeeded = totalElectivesNeeded; var thisStudent = db.Students.FirstOrDefault( o => o.StudentID == applicationcommissioning.StudentID); var doOrDoNotQualify = DoOrDoNotQualify(thisStudent, totalCoresNeeded, totalElectivesNeeded); ViewBag.doOrDoNotQualify = doOrDoNotQualify; return(View(applicationcommissioning)); }
public ActionResult Profile() { ProfileViewModel model = PreloadProfileViewModelWithCurrentUsersProfileData(); MembershipUser u = Membership.GetUser(User.Identity.Name); if (u != null) { ViewBag.Email = u.Email; } IOrderedQueryable <ApplicationCommissioning> usersCommissionings = db.ApplicationCommissionings.Where(o => o.Student.UserName == User.Identity.Name && o.Approved). OrderByDescending(m => m.DateApproved); ApplicationCommissioning usersMostRecentCommissioning = usersCommissionings.FirstOrDefault(); if (usersMostRecentCommissioning != null) { ViewBag.mostRecentCommissioningCertificateID = usersMostRecentCommissioning.Id; } return(View(model)); }
public ActionResult DeleteConfirmed(int id, ApplicationCommissioning hasReasonForDeletion) { ApplicationCommissioning applicationcommissioning = db.ApplicationCommissionings.Find(id); var newNotification = new Notification { Time = DateTime.Now, Details = "An Administrator has denied your application for Commissioning, filed on " + applicationcommissioning.DateFiled + " citing the following reason: " + hasReasonForDeletion.AdminDenialReason, Link = Url.Action("Create", "Commissioning"), ViewableBy = applicationcommissioning.Student.UserName, Complete = false }; db.Notification.Add(newNotification); db.ApplicationCommissionings.Remove(applicationcommissioning); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult ApproveCommissioningApplication(int id) { ApplicationCommissioning applicationcommissioning = db.ApplicationCommissionings.Find(id); var newNotification = new Notification { Time = DateTime.Now, Details = "Your application for Commissioning, filed on " + applicationcommissioning.DateFiled + " has been approved. Congratulations", Link = Url.Action("CertificateOfCommissioning", "Certificate", new { id = applicationcommissioning.Id }, null), ViewableBy = applicationcommissioning.Student.UserName, Complete = false }; db.Notification.Add(newNotification); applicationcommissioning.Approved = true; applicationcommissioning.DateApproved = DateTime.Now; db.SaveChanges(); return(RedirectToAction("CertificateOfCommissioning", "Certificate", new { id = applicationcommissioning.Id })); }
public ActionResult Create(ApplicationCommissioning applicationcommissioning) { if (ModelState.IsValid) { var thisStudent = db.Students.FirstOrDefault( o => o.UserName == User.Identity.Name); if (thisStudent != null) { applicationcommissioning.StudentID = thisStudent.StudentID; } applicationcommissioning.DateFiled = DateTime.Now; applicationcommissioning.Approved = false; db.ApplicationCommissionings.Add(applicationcommissioning); db.SaveChanges(); var newNotification = new Notification { Time = DateTime.Now, Details = "A student by the name of " + applicationcommissioning.Student.FirstMidName + " " + applicationcommissioning.Student.LastName + " has submitted an application for Commissioning", Link = Url.Action("Details", "Commissioning", new { id = applicationcommissioning.Id }), ViewableBy = "Admin", Complete = false }; db.Notification.Add(newNotification); db.SaveChanges(); TempData["message"] = "Please make sure you have completed all the steps for your application. Contact the St. Paul School of Catechesis at 361-882-6191 if you have any questions."; return(RedirectToAction("Index")); } return(View(applicationcommissioning)); }
public ActionResult Delete(int id) { ApplicationCommissioning applicationcommissioning = db.ApplicationCommissionings.Find(id); return(View(applicationcommissioning)); }