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