public ActionResult Counsellor(string UserID)
{
GetCurrentUserInViewBag();
var currentUserId = User.Identity.GetUserId();
StudentCounsellingViewModel vm = new StudentCounsellingViewModel();
CounsellingForm form = new CounsellingForm();
var Student = db.Students.FirstOrDefault(x => x.UserID == UserID);
vm.StudentUserID = Student.UserID;
vm.StudentFirstName = Student.StudentFirstName;
vm.StudentMiddleName = Student.StudentMiddleName;
vm.StudentLastName = Student.StudentLastName;
vm.Program = Student.Program;
vm.YearLevel = Student.YearLevel;
vm.StudentID = Student.StudentID;
var counsellor = db.Counsellor.FirstOrDefault(x => x.UserID == currentUserId);
vm.CounsellorLastName = counsellor.CounsellorLastName;
vm.CounsellorFirstName = counsellor.CounsellorFirstName;
vm.CounsellorMiddleName = counsellor.CounsellorMiddleName;
vm.CompletionDate = DateTime.Now;
vm.Session = form.Session;
vm.PctionPlan = form.PctionPlan;
vm.Recommendation = form.Recommendation;
vm.Followup = form.Followup;
return(View(vm));
}
public ActionResult Details(StudentCounsellingViewModel vm, int AnecdotalRecordID)
{
GetCurrentUserInViewBag();
AnecdotalRecord report = db.AnecdotalRecord.FirstOrDefault(x => x.AnecdotalRecordID == AnecdotalRecordID);
if (report == null)
{
return(HttpNotFound());
}
report.Summary = vm.Summary;
int result = db.SaveChanges();
if (result > 0)
{
TempData["Message"] = "Counselor notes and summary successfully saved!";
}
else
{
var errors = ModelState.Values.SelectMany(v => v.Errors);
TempData["Error"] = errors;
}
return(RedirectToAction("Index", "Home"));
}
public ActionResult Search(string searchStringStudentID)
{
GetCurrentUserInViewBag();
var currentUserId = User.Identity.GetUserId();
StudentCounsellingViewModel vm = new StudentCounsellingViewModel();
CounsellingForm form = new CounsellingForm();
Student student = new Student();
var check = db.Students
.Where(d => d.StudentID == searchStringStudentID)
.Count();
if (check != 0)
{
var Student = db.Students.FirstOrDefault(x => x.StudentID == searchStringStudentID);
vm.StudentUserID = Student.UserID;
vm.StudentFirstName = Student.StudentFirstName;
vm.StudentMiddleName = Student.StudentMiddleName;
vm.StudentLastName = Student.StudentLastName;
vm.Program = Student.Program;
vm.YearLevel = Student.YearLevel;
TempData["StudentUserID"] = Student.UserID;
return(RedirectToAction("Counsellor"));
}
else
{
TempData["Error"] = "No student number: " + searchStringStudentID + " found!";
}
return(View(vm));
}
public ActionResult Report(int AnecdotalRecordID)
{
GetCurrentUserInViewBag();
var currentUserId = User.Identity.GetUserId();
var FormID = db.AnecdotalRecord.FirstOrDefault(x => x.AnecdotalRecordID == AnecdotalRecordID);
var StudentUserID = FormID.StudentUserID;
Student student = db.Students.Find(StudentUserID);
if (student == null)
{
return(HttpNotFound());
}
var record = db.AnecdotalRecord.FirstOrDefault(x => x.StudentUserID == StudentUserID);
if (record == null)
{
return(HttpNotFound());
}
StudentCounsellingViewModel vm = new StudentCounsellingViewModel();
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 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 = record.CompletionDate;
vm.Place = record.Place;
vm.Observer = record.Observer;
vm.BehaviorObserved = record.BehaviorObserved;
vm.Action = record.Action;
vm.Summary = record.Summary;
return(View(vm));
}
public ActionResult Details(int CounsellingFormID)
{
GetCurrentUserInViewBag();
var FormID = db.CounsellingForm.FirstOrDefault(x => x.CounsellingFormID == CounsellingFormID);
var StudentUserID = FormID.StudentUserID;
Student student = db.Students.Find(StudentUserID);
if (student == null)
{
TempData["Error"] = "No record found!";
return(RedirectToAction("Student", "CounsellingForms"));
}
var form = db.CounsellingForm.FirstOrDefault(x => x.StudentUserID == StudentUserID);
if (form == null)
{
TempData["Error"] = "No record found!";
return(RedirectToAction("Student", "CounsellingForms"));
}
StudentCounsellingViewModel vm = new StudentCounsellingViewModel();
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 counsellorUserID = form.UserID;
Counsellor counsellor = db.Counsellor.Find(counsellorUserID);
vm.CounsellorLastName = counsellor.CounsellorLastName;
vm.CounsellorFirstName = counsellor.CounsellorFirstName;
vm.CounsellorMiddleName = counsellor.CounsellorMiddleName;
vm.CompletionDate = form.CompletionDate;
vm.Session = form.Session;
vm.PctionPlan = form.PctionPlan;
vm.Recommendation = form.Recommendation;
vm.Followup = form.Followup;
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());
}
AnecdotalRecord record = new AnecdotalRecord();
var counsellor = db.Counsellor.FirstOrDefault(d => d.UserID == currentUserId);
StudentCounsellingViewModel vm = new StudentCounsellingViewModel();
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 = record.CompletionDate;
vm.DateTimeObserved = record.DateTimeObserved;
vm.Place = record.Place;
vm.Observer = record.Observer;
vm.BehaviorObserved = record.BehaviorObserved;
vm.Action = record.Action;
vm.Summary = record.Summary;
return(View(vm));
}
public ActionResult Details(string UserID)
{
GetCurrentUserInViewBag();
CounsellingContract contract = db.CounsellingContract.FirstOrDefault(x => x.StudentUserID == UserID);
if (contract == null)
{
TempData["Error"] = "This user has not agreed to the Counselling Terms!";
return(RedirectToAction("Index", "CounsellingContracts"));
}
else if (contract.CompletionDate == null)
{
TempData["Error"] = "This user has not agreed to the Counselling Terms!";
return(RedirectToAction("Index", "CounsellingContracts"));
}
Student student = db.Students.Find(UserID);
if (student == null)
{
return(HttpNotFound());
}
StudentCounsellingViewModel vm = new StudentCounsellingViewModel();
vm.StudentID = student.StudentID;
vm.Program = student.Program;
vm.StudentFirstName = student.StudentFirstName;
vm.StudentMiddleName = student.StudentMiddleName;
vm.StudentLastName = student.StudentLastName;
vm.Program = student.Program;
vm.YearLevel = student.YearLevel;
if (contract.StudentAgrees != null)
{
vm.StudentAgrees = (bool)contract.StudentAgrees;
}
return(View(vm));
}
public ActionResult Add(StudentCounsellingViewModel vm, string UserID)
{
GetCurrentUserInViewBag();
var currentUserId = User.Identity.GetUserId();
AnecdotalRecord record = new AnecdotalRecord();
var student = db.Students.FirstOrDefault(X => X.UserID == UserID);
var counsellor = db.Counsellor.FirstOrDefault(x => x.UserID == currentUserId);
record.UserID = counsellor.UserID;
record.StudentUserID = student.UserID;
record.CompletionDate = DateTime.Now;
record.DateTimeObserved = vm.DateTimeObserved;
record.Place = vm.Place;
record.Observer = vm.Observer;
record.BehaviorObserved = vm.BehaviorObserved;
record.Action = vm.Action;
record.Summary = vm.Summary;
db.AnecdotalRecord.Add(record);
int result = db.SaveChanges();
if (result > 0)
{
TempData["Message"] = "You have successfullly added an Anecdotal Record for student: " + student.StudentID + ":" + student.StudentFirstName + " " + student.StudentLastName + " !";
}
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.CounsellingContract
.Where(x => x.StudentUserID == currentUserId && x.CompletionDate != null && x.StudentAgrees == true)
.ToList();
if (check.Count() != 0)
{
TempData["Message"] = "You have already completed the Counselling Contract!";
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 contract = db.CounsellingContract.FirstOrDefault(d => d.StudentUserID == currentUserId);
if (contract == null)
{
contract = db.CounsellingContract.Create();
contract.StudentUserID = currentUserId;
db.CounsellingContract.Add(contract);
db.SaveChanges();
}
CounsellingContract Contract = db.CounsellingContract.FirstOrDefault(user => user.StudentUserID == currentUserId);
if (Contract == null)
{
return(HttpNotFound());
}
StudentCounsellingViewModel vm = new StudentCounsellingViewModel();
vm.StudentID = student.StudentID;
vm.Program = student.Program;
vm.StudentFirstName = student.StudentFirstName;
vm.StudentMiddleName = student.StudentMiddleName;
vm.StudentLastName = student.StudentLastName;
vm.Program = student.Program;
vm.YearLevel = student.YearLevel;
if (contract.StudentAgrees != null)
{
vm.StudentAgrees = (bool)contract.StudentAgrees;
}
return(View(vm));
}
public ActionResult Counsellor(StudentCounsellingViewModel vm, string[] name, string StudentUserID)
{
GetCurrentUserInViewBag();
var currentUserId = User.Identity.GetUserId();
CounsellingForm form = new CounsellingForm();
if (ModelState.IsValid)
{
if (StudentUserID == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
form.UserID = currentUserId;
form.StudentUserID = StudentUserID;
form.CompletionDate = DateTime.Now;
form.Session = vm.Session;
form.PctionPlan = vm.PctionPlan;
form.Recommendation = vm.Recommendation;
form.Followup = vm.Followup;
db.CounsellingForm.Add(form);
var selectedTags = name.ToList();
foreach (var item in selectedTags)
{
var dlist =
(from ans in db.CounsellingFormCasesList
where ans.Type == item
select new { TypeID = ans.TypeID }).Single();
//check if may row na may laman ang CounsellingFormID, TypeID
var check = db.CounsellingFormCases
.Where(x => x.CounsellingFormID == form.CounsellingFormID && x.TypeID == dlist.TypeID)
.ToList();
if (check.Count() == 0)
{
//create ng bagong entry and lagyan ng laman the ff:
var newCaseId = db.CounsellingFormCases.Create();
newCaseId.CounsellingFormID = form.CounsellingFormID;
newCaseId.TypeID = dlist.TypeID;
db.CounsellingFormCases.Add(newCaseId);
}
}
db.SaveChanges();
TempData["Message"] = "Counselling form " + form.CounsellingFormID + " successfully added!";
}
else
{
TempData["Error"] = "Error: Counselling form not added!";
}
return(RedirectToAction("Index", "Home"));
}