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