public ActionResult Details(StudentInterviewViewModel vm, int IncidentReportID) { GetCurrentUserInViewBag(); IncidentReport report = db.IncidentReport.FirstOrDefault(x => x.IncidentReportID == IncidentReportID); if (report == null) { return(HttpNotFound()); } report.CounsellorNotes = vm.CounselorNotes; int result = db.SaveChanges(); if (result > 0) { TempData["Message"] = "Counselor notes successfully saved!"; } else { var errors = ModelState.Values.SelectMany(v => v.Errors); TempData["Error"] = errors; } return(RedirectToAction("Index", "Home")); }
public ActionResult Details(string UserID) { GetCurrentUserInViewBag(); if (UserID == null) { TempData["Error"] = "No record found!"; return(RedirectToAction("Index", "ExitInterviews")); } Student student = db.Students.Find(UserID); if (student == null) { TempData["Error"] = "No record found!"; return(RedirectToAction("Index", "ExitInterviews")); } ExitInterview exit = db.ExitInterview.FirstOrDefault(user => user.StudentUserID == UserID); if (exit == null) { TempData["Error"] = "This student has no exit interview record!"; return(RedirectToAction("Index", "ExitInterviews")); } StudentInterviewViewModel vm = new StudentInterviewViewModel(); vm.UserID = student.UserID; vm.StudentID = student.StudentID; vm.Program = student.Program; vm.StudentFirstName = student.StudentFirstName; vm.StudentMiddleName = student.StudentMiddleName; vm.StudentLastName = student.StudentLastName; vm.CompletionDate = exit.CompletionDate; vm.MMCCLikes = exit.MMCCLikes; vm.MMCCDislikes = exit.MMCCDislikes; vm.MMCCMoments = exit.MMCCMoments; vm.Professors = exit.Professors; vm.Staff = exit.Staff; vm.Future = exit.Future; vm.Others = exit.Others; vm.GuidanceNotes = exit.GuidanceNotes; ViewBag.DateCompleted = vm.CompletionDate; return(View(vm)); }
public ActionResult Details([Bind(Include = "GuidanceNotes")] StudentInterviewViewModel vm, string UserID) { GetCurrentUserInViewBag(); var u = db.Students.FirstOrDefault(d => d.UserID == UserID); if (u == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Student student = db.Students.Find(u.UserID); if (student == null) { return(HttpNotFound()); } var exitInterview = db.ExitInterview.FirstOrDefault(d => d.StudentUserID == UserID); if (exitInterview == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ExitInterview exit = db.ExitInterview.FirstOrDefault(user => user.StudentUserID == UserID); if (exit == null) { return(HttpNotFound()); } exit.GuidanceNotes = vm.GuidanceNotes; int result = db.SaveChanges(); if (result > 0) { TempData["Message"] = "Counselor notes successfully saved!"; } else { var errors = ModelState.Values.SelectMany(v => v.Errors); TempData["Error"] = errors; } return(RedirectToAction("Index", "Home")); }
public ActionResult Details1(string UserID) { GetCurrentUserInViewBag(); if (UserID == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Student student = db.Students.Find(UserID); if (student == null) { return(HttpNotFound()); } ExitInterview exit = db.ExitInterview.FirstOrDefault(user => user.StudentUserID == UserID); if (exit == null) { return(HttpNotFound()); } StudentInterviewViewModel vm = new StudentInterviewViewModel(); vm.UserID = student.UserID; vm.StudentID = student.StudentID; vm.Program = student.Program; vm.StudentFirstName = student.StudentFirstName; vm.StudentMiddleName = student.StudentMiddleName; vm.StudentLastName = student.StudentLastName; vm.CompletionDate = exit.CompletionDate; vm.MMCCLikes = exit.MMCCLikes; vm.MMCCDislikes = exit.MMCCDislikes; vm.MMCCMoments = exit.MMCCMoments; vm.Professors = exit.Professors; vm.Staff = exit.Staff; vm.Future = exit.Future; vm.Others = exit.Others; vm.GuidanceNotes = exit.GuidanceNotes; ViewBag.DateCompleted = vm.CompletionDate; return(View(vm)); }
//[Authorize(Roles = "Counselor")] public ActionResult Report(string UserID) { GetCurrentUserInViewBag(); Student student = db.Students.Find(UserID); if (student == null) { return(HttpNotFound()); } RoutineInterview routine = db.RoutineInterview.FirstOrDefault(user => user.UserID == UserID); if (routine == null) { TempData["Error"] = "This user has not completed the test yet!"; return(RedirectToAction("Index", "RoutineInterviews")); } else if (routine.CompletionDate == null) { TempData["Error"] = "This user has not completed the test yet!"; return(RedirectToAction("Index", "RoutineInterviews")); } StudentInterviewViewModel vm = new StudentInterviewViewModel(); vm.UserID = student.UserID; vm.StudentID = student.StudentID; vm.Program = student.Program; vm.StudentFirstName = student.StudentFirstName; vm.StudentMiddleName = student.StudentMiddleName; vm.StudentLastName = student.StudentLastName; vm.CompletionDate = routine.CompletionDate; vm.Q1 = routine.Q1; vm.Q2 = routine.Q2; vm.Q3 = routine.Q3; vm.Q4 = routine.Q4; vm.Q5 = routine.Q5; vm.OtherMatters = routine.OtherMatters; ViewBag.DateCompleted = vm.CompletionDate; return(View(vm)); }
public ActionResult Add(string UserID) { GetCurrentUserInViewBag(); var currentUserId = User.Identity.GetUserId(); if (UserID == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Student student = db.Students.Find(UserID); if (student == null) { return(HttpNotFound()); } IncidentReport incident = new IncidentReport(); var counsellor = db.Counsellor.FirstOrDefault(d => d.UserID == currentUserId); StudentInterviewViewModel vm = new StudentInterviewViewModel(); vm.UserID = student.UserID; vm.StudentID = student.StudentID; vm.Program = student.Program; vm.YearLevel = student.YearLevel; vm.StudentFirstName = student.StudentFirstName; vm.StudentMiddleName = student.StudentMiddleName; vm.StudentLastName = student.StudentLastName; vm.CounsellorFirstName = counsellor.CounsellorFirstName; vm.CounsellorMiddleName = counsellor.CounsellorMiddleName; vm.CounsellorLastName = counsellor.CounsellorLastName; vm.CompletionDate = incident.CompletionDate; vm.PlaceOfIncident = incident.PlaceOfIncident; vm.DateTimeOfIncident = incident.DateTimeOfIncident; vm.Witness = incident.Witness; vm.Details = incident.Details; vm.CounselorNotes = incident.CounsellorNotes; return(View(vm)); }
public ActionResult Student([Bind(Include = "MMCCLikes,MMCCDislikes,MMCCMoments,Professors,Staff,Future,Others,CompletionDate")] StudentInterviewViewModel vm) { GetCurrentUserInViewBag(); var currentUserId = User.Identity.GetUserId(); var userName = User.Identity.GetUserName(); var u = db.Students.FirstOrDefault(d => d.UserID == currentUserId); if (u == null) { u = db.Students.Create(); u.UserID = currentUserId; db.Students.Add(u); } Student student = db.Students.Find(u.UserID); if (student == null) { return(HttpNotFound()); } var exitInterview = db.ExitInterview.FirstOrDefault(d => d.StudentUserID == currentUserId); if (exitInterview == null) { exitInterview = db.ExitInterview.Create(); exitInterview.StudentUserID = currentUserId; db.ExitInterview.Add(exitInterview); db.SaveChanges(); } ExitInterview exit = db.ExitInterview.FirstOrDefault(user => user.StudentUserID == currentUserId); if (exit == null) { return(HttpNotFound()); } exit.CompletionDate = DateTime.Now; exit.MMCCLikes = vm.MMCCLikes; exit.MMCCDislikes = vm.MMCCDislikes; exit.MMCCMoments = vm.MMCCMoments; exit.Professors = vm.Professors; exit.Staff = vm.Staff; exit.Future = vm.Future; exit.Others = vm.Others; int result = db.SaveChanges(); if (result > 0) { TempData["Message"] = "User: "******"'s, exit interview successfully saved!"; } else { var errors = ModelState.Values.SelectMany(v => v.Errors); TempData["Error"] = errors; } return(RedirectToAction("Index", "Home")); }
public ActionResult Student() { GetCurrentUserInViewBag(); var currentUserId = User.Identity.GetUserId(); var check = db.ExitInterview .Where(x => x.StudentUserID == currentUserId && x.CompletionDate != null) .ToList(); if (check.Count() != 0) { TempData["Message"] = "You have already completed the Exit Interview!"; return(RedirectToAction("Index", "Home")); } var newid = db.Students.FirstOrDefault(d => d.UserID == currentUserId); if (newid == null) { newid = db.Students.Create(); newid.UserID = currentUserId; db.Students.Add(newid); } Student student = db.Students.Find(newid.UserID); if (student == null) { return(HttpNotFound()); } var exitInterview = db.ExitInterview.FirstOrDefault(d => d.StudentUserID == currentUserId); if (exitInterview == null) { exitInterview = db.ExitInterview.Create(); exitInterview.StudentUserID = currentUserId; db.ExitInterview.Add(exitInterview); db.SaveChanges(); } ExitInterview exit = db.ExitInterview.FirstOrDefault(user => user.StudentUserID == currentUserId); if (exit == null) { return(HttpNotFound()); } StudentInterviewViewModel vm = new StudentInterviewViewModel(); vm.UserID = student.UserID; vm.StudentID = student.StudentID; vm.Program = student.Program; vm.StudentFirstName = student.StudentFirstName; vm.StudentMiddleName = student.StudentMiddleName; vm.StudentLastName = student.StudentLastName; vm.CompletionDate = exit.CompletionDate; vm.MMCCLikes = exit.MMCCLikes; vm.MMCCDislikes = exit.MMCCDislikes; vm.MMCCMoments = exit.MMCCMoments; vm.Professors = exit.Professors; vm.Staff = exit.Staff; vm.Future = exit.Future; vm.Others = exit.Others; return(View(vm)); }
public ActionResult Student(StudentInterviewViewModel vm) { GetCurrentUserInViewBag(); var currentUserId = User.Identity.GetUserId(); var userName = User.Identity.GetUserName(); var u = db.Students.FirstOrDefault(d => d.UserID == currentUserId); if (u == null) { u = db.Students.Create(); u.UserID = currentUserId; db.Students.Add(u); } Student student = db.Students.Find(u.UserID); if (student == null) { return(HttpNotFound()); } var initialInterview = db.InitialInterview.FirstOrDefault(d => d.UserID == currentUserId); if (initialInterview == null) { initialInterview = db.InitialInterview.Create(); initialInterview.UserID = currentUserId; db.InitialInterview.Add(initialInterview); db.SaveChanges(); } InitialInterview initial = db.InitialInterview.FirstOrDefault(user => user.UserID == currentUserId); if (initial == null) { return(HttpNotFound()); } if (ModelState.IsValid) { initial.CompletionDate = DateTime.Now; initial.ReasonForProgram = vm.ReasonForProgram; initial.ReasonForMMCC = vm.ReasonForMMCC; initial.CollegeLifeAdjustments = vm.CollegeLifeAdjustments; initial.ChoiceOfProgramAdjustments = vm.ChoiceOfProgramAdjustments; initial.PeersAdjustments = vm.PeersAdjustments; initial.MMCCStaffAdjustments = vm.MMCCStaffAdjustments; initial.FamilyAdjustments = vm.FamilyAdjustments; db.SaveChanges(); TempData["Message"] = "User: "******"'s, initial interview successfully saved!"; } else { TempData["Error"] = "Error: Entry not saved!"; } return(RedirectToAction("Index", "Home")); }
public ActionResult Student() { GetCurrentUserInViewBag(); var currentUserId = User.Identity.GetUserId(); var check = db.InitialInterview .Where(x => x.UserID == currentUserId && x.CompletionDate != null) .ToList(); if (check.Count() != 0) { TempData["Message"] = "You have already completed the Initial Interview Form!"; return(RedirectToAction("Index", "Home")); } var newid = db.Students.FirstOrDefault(d => d.UserID == currentUserId); if (newid == null) { newid = db.Students.Create(); newid.UserID = currentUserId; db.Students.Add(newid); } Student student = db.Students.Find(newid.UserID); if (student == null) { return(HttpNotFound()); } var initialInterview = db.InitialInterview.FirstOrDefault(d => d.UserID == currentUserId); if (initialInterview == null) { initialInterview = db.InitialInterview.Create(); initialInterview.UserID = currentUserId; db.InitialInterview.Add(initialInterview); db.SaveChanges(); } InitialInterview initial = db.InitialInterview.FirstOrDefault(user => user.UserID == currentUserId); if (initial == null) { return(HttpNotFound()); } StudentInterviewViewModel vm = new StudentInterviewViewModel(); vm.UserID = student.UserID; vm.StudentID = student.StudentID; vm.Program = student.Program; vm.StudentFirstName = student.StudentFirstName; vm.StudentMiddleName = student.StudentMiddleName; vm.StudentLastName = student.StudentLastName; vm.CompletionDate = initial.CompletionDate; vm.ReasonForProgram = initial.ReasonForProgram; vm.ReasonForMMCC = initial.ReasonForMMCC; vm.CollegeLifeAdjustments = initial.CollegeLifeAdjustments; vm.ChoiceOfProgramAdjustments = initial.ChoiceOfProgramAdjustments; vm.PeersAdjustments = initial.PeersAdjustments; vm.MMCCStaffAdjustments = initial.MMCCStaffAdjustments; vm.FamilyAdjustments = initial.FamilyAdjustments; return(View(vm)); }
public ActionResult Report(string UserID) { GetCurrentUserInViewBag(); InitialInterview check = db.InitialInterview.FirstOrDefault(x => x.UserID == UserID); if (check == null) { TempData["Error"] = "This user has not completed the test yet!"; return(RedirectToAction("Index", "InitialInterviews")); } else if (check.CompletionDate == null) { TempData["Error"] = "This user has not completed the test yet!"; return(RedirectToAction("Index", "InitialInterviews")); } if (UserID == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Student student = db.Students.Find(UserID); if (student == null) { return(HttpNotFound()); } InitialInterview initial = db.InitialInterview.FirstOrDefault(user => user.UserID == UserID); if (initial == null) { return(HttpNotFound()); } if (initial == null) { return(HttpNotFound()); } StudentInterviewViewModel vm = new StudentInterviewViewModel(); vm.UserID = student.UserID; vm.StudentID = student.StudentID; vm.Program = student.Program; vm.StudentFirstName = student.StudentFirstName; vm.StudentMiddleName = student.StudentMiddleName; vm.StudentLastName = student.StudentLastName; vm.CompletionDate = initial.CompletionDate; vm.ReasonForProgram = initial.ReasonForProgram; vm.ReasonForMMCC = initial.ReasonForMMCC; vm.CollegeLifeAdjustments = initial.CollegeLifeAdjustments; vm.ChoiceOfProgramAdjustments = initial.ChoiceOfProgramAdjustments; vm.PeersAdjustments = initial.PeersAdjustments; vm.MMCCStaffAdjustments = initial.MMCCStaffAdjustments; vm.FamilyAdjustments = initial.FamilyAdjustments; vm.CounselorNotes = initial.CounselorNotes; ViewBag.DateCompleted = vm.CompletionDate; return(View(vm)); }
public ActionResult Student() { GetCurrentUserInViewBag(); var currentUserId = User.Identity.GetUserId(); var check = db.RoutineInterview .Where(x => x.UserID == currentUserId && x.CompletionDate != null) .ToList(); if (check.Count() != 0) { TempData["Message"] = "You have already completed the Routine Interview!"; return(RedirectToAction("Index", "Home")); } var newid = db.Students.FirstOrDefault(d => d.UserID == currentUserId); if (newid == null) { newid = db.Students.Create(); newid.UserID = currentUserId; db.Students.Add(newid); } Student student = db.Students.Find(newid.UserID); if (student == null) { return(HttpNotFound()); } var routineInterview = db.RoutineInterview.FirstOrDefault(d => d.UserID == currentUserId); if (routineInterview == null) { routineInterview = db.RoutineInterview.Create(); routineInterview.UserID = currentUserId; db.RoutineInterview.Add(routineInterview); db.SaveChanges(); } RoutineInterview routine = db.RoutineInterview.FirstOrDefault(user => user.UserID == currentUserId); if (routine == null) { return(HttpNotFound()); } StudentInterviewViewModel vm = new StudentInterviewViewModel(); vm.UserID = student.UserID; vm.StudentID = student.StudentID; vm.Program = student.Program; vm.StudentFirstName = student.StudentFirstName; vm.StudentMiddleName = student.StudentMiddleName; vm.StudentLastName = student.StudentLastName; vm.CompletionDate = routine.CompletionDate; vm.Q1 = routine.Q1; vm.Q2 = routine.Q2; vm.Q3 = routine.Q3; vm.Q4 = routine.Q4; vm.Q5 = routine.Q5; vm.OtherMatters = routine.OtherMatters; return(View(vm)); }
public ActionResult Report(int IncidentReportID) { GetCurrentUserInViewBag(); var currentUserId = User.Identity.GetUserId(); var FormID = db.IncidentReport.FirstOrDefault(x => x.IncidentReportID == IncidentReportID); var StudentUserID = FormID.StudentUserID; Student student = db.Students.Find(StudentUserID); if (student == null) { return(HttpNotFound()); } var form = db.IncidentReport.FirstOrDefault(x => x.StudentUserID == StudentUserID); if (form == null) { return(HttpNotFound()); } StudentInterviewViewModel vm = new StudentInterviewViewModel(); vm.StudentUserID = student.UserID; vm.StudentID = student.StudentID; vm.Program = student.Program; vm.YearLevel = student.YearLevel; vm.StudentFirstName = student.StudentFirstName; vm.StudentMiddleName = student.StudentMiddleName; vm.StudentLastName = student.StudentLastName; var UserIDReporter = form.EeportedBy; Counsellor counsellor = db.Counsellor.Find(UserIDReporter); if (counsellor != null) { vm.ReportedByName = counsellor.CounsellorLastName + ", " + counsellor.CounsellorFirstName; } else { Student studentReporter = db.Students.Find(UserIDReporter); vm.ReportedByName = studentReporter.StudentLastName + ", " + studentReporter.StudentFirstName; } var counselloR = db.Counsellor.FirstOrDefault(x => x.UserID == currentUserId); if (counselloR != null) { vm.CounsellorLastName = counselloR.CounsellorLastName; vm.CounsellorFirstName = counselloR.CounsellorFirstName; vm.CounsellorMiddleName = counselloR.CounsellorMiddleName; } vm.CompletionDate = form.CompletionDate; vm.PlaceOfIncident = form.PlaceOfIncident; vm.DateTimeOfIncident = form.DateTimeOfIncident; vm.Witness = form.Witness; vm.Details = form.Details; vm.CounselorNotes = form.CounsellorNotes; return(View(vm)); }
public ActionResult Submit(string[] name, StudentInterviewViewModel vm, string UserID, string date, string time) { GetCurrentUserInViewBag(); var currentUserId = User.Identity.GetUserId(); //if (ModelState.IsValid) //{ IncidentReport incident = new IncidentReport(); var student = db.Students.FirstOrDefault(X => X.UserID == UserID); //yung nirereport var reportedBy = db.Students.FirstOrDefault(x => x.UserID == currentUserId); //nagrereport incident.EeportedBy = reportedBy.UserID; incident.StudentUserID = UserID.TrimEnd().TrimStart(); incident.CompletionDate = DateTime.Now; incident.PlaceOfIncident = vm.PlaceOfIncident; incident.DateTimeOfIncident = DateTime.Parse(date + " " + time); incident.Witness = vm.Witness; incident.Details = vm.Details; incident.CounsellorNotes = vm.CounselorNotes; db.IncidentReport.Add(incident); var selectedTags = name.ToList(); foreach (var item in selectedTags) { var dlist = (from ans in db.IncidentReportIncidents where ans.Type == item select new { TypeID = ans.TypeID }).Single(); //check if may row na may laman ang IncidentReportID, TypeID var check = db.IncidentReportTags .Where(x => x.IncidentReportID == incident.IncidentReportID && x.TypeID == dlist.TypeID) .ToList(); if (check.Count() == 0) { //create ng bagong entry and lagyan ng laman the ff: var newTagId = db.IncidentReportTags.Create(); newTagId.IncidentReportID = incident.IncidentReportID; newTagId.TypeID = dlist.TypeID; db.IncidentReportTags.Add(newTagId); } } int result = db.SaveChanges(); if (result > 0) { TempData["Message"] = "You have successfullly filed an Incident Report for student: " + student.StudentID + "!"; } else { var errors = ModelState.Values.SelectMany(v => v.Errors); TempData["Error"] = errors; } //} //else //{ // var errors = ModelState.Values.SelectMany(v => v.Errors); // TempData["Error"] = errors; //} return(RedirectToAction("Index", "Home")); //return Json(Url.Action("Index", "Home")); //return Json(new { redirectToUrl = Url.Action("Index", "Home") }); }