public ActionResult Print(string UserID) { var name = db.Students.Find(UserID); var student = name.StudentLastName + ", " + name.StudentFirstName; ExitInterview check = db.ExitInterview.FirstOrDefault(x => x.StudentUserID == UserID); if (check == null) { TempData["Error"] = "This student has no exit interview record!"; return(RedirectToAction("Index", "ExitInterviews")); } else if (check.CompletionDate == null) { TempData["Error"] = "This student has no exit interview record!"; return(RedirectToAction("Index", "ExitInterviews")); } return(new ActionAsPdf( "Details1", new { UserID = UserID }) { FileName = string.Format("Exit_Interview_{0}.pdf", student) }); }
public async Task <ActionResult> Create([Bind(Include = "No,EmployeeNo,EmployeeName,Reason,OtherReasons,LeavingOn,ReEmploy,InterviewDate,InterviewerNo,InterviewerName,Comment,Status,ApproveProcess,ProcessCompleted")] ExitInterview exitInterview, ICollection <ExitActivityLine> Line) { //if (!ModelState.IsValid) //{ // exitInterview.InterviewDate = DateTime.Now; // exitInterview.LeavingOn = DateTime.Now; // ViewBag.Employees = db.Employees.Select(p => new { Id = p.ID, Name = p.FirstName + " " + p.LastName, Number = p.EmployeeNumber, Department = p.OfficePosition.Department.DepartmentName }); // ViewBag.Error = "Form was not filled properly"; // return View(exitInterview); //} try { foreach (ExitActivityLine item in Line) { item.Id = Guid.NewGuid(); db.ExitActivityLines.Add(item); } db.ExitInterviews.Add(exitInterview); await db.SaveChangesAsync(); return(RedirectToAction("Index")); } catch { return(View(exitInterview)); } }
public async Task <ActionResult> DeleteConfirmed(string id) { ExitInterview exitInterview = await db.ExitInterviews.FindAsync(id); db.ExitInterviews.Remove(exitInterview); await db.SaveChangesAsync(); return(RedirectToAction("Index")); }
public async Task <ActionResult> Edit([Bind(Include = "No,EmployeeNo,EmployeeName,Reason,OtherReasons,LeavingOn,ReEmploy,InterviewDate,InterviewerNo,InterviewerName,Comment,Status,ApproveProcess,ProcessCompleted")] ExitInterview exitInterview) { if (ModelState.IsValid) { db.Entry(exitInterview).State = EntityState.Modified; await db.SaveChangesAsync(); return(RedirectToAction("Index")); } return(View(exitInterview)); }
public ActionResult Create() { var model = new ExitInterview(); var no = db.ExitInterviews.Count(); model.No = "TR" + String.Format("{0:D6}", no + 1); model.InterviewDate = DateTime.Now; model.LeavingOn = DateTime.Now; ViewBag.Employees = _repo.GetAll().Select(p => new { Id = p.ID, Name = p.FirstName + " " + p.LastName, Number = p.EmployeeNumber, Department = p.OfficePosition.Department.DepartmentName }); return(View(model)); }
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 async Task <ActionResult> Approve(string id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ExitInterview exitInterview = await db.ExitInterviews.FindAsync(id); if (exitInterview == null) { return(HttpNotFound()); } return(View(exitInterview)); }
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)); }
public async Task <ActionResult> Approve(string id, ExitInterview model) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ExitInterview exitInterview = await db.ExitInterviews.FindAsync(id); if (exitInterview == null) { return(HttpNotFound()); } exitInterview.ApproveProcess = model.ApproveProcess; exitInterview.Status = "Approved"; await db.SaveChangesAsync(); return(RedirectToAction("Index")); }
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 Index(string searchStringName, string currentFilter, int?page) { GetCurrentUserInViewBag(); try { int intPage = 1; int intPageSize = 10; int intTotalPageCount = 0; if (searchStringName != null) { intPage = 1; } else { if (currentFilter != null) { searchStringName = currentFilter; intPage = page ?? 1; } else { searchStringName = ""; intPage = page ?? 1; } } ViewBag.CurrentFilter = searchStringName; List <TestViewModel> StudentInventorylist = new List <TestViewModel>(); int intSkip = (intPage - 1) * intPageSize; intTotalPageCount = db.Students .Where(x => x.StudentFirstName.Contains(searchStringName)) .Count(); var datalist = db.Students .Where(x => x.StudentLastName.Contains(searchStringName) || x.StudentFirstName.Contains(searchStringName) || x.StudentID.Contains(searchStringName)) .OrderBy(x => x.StudentLastName) .Skip(intSkip) .Take(intPageSize) .ToList(); foreach (var item in datalist) { TestViewModel pvm = new TestViewModel(); pvm.StudentFirstName = item.StudentFirstName; pvm.StudentMiddleName = item.StudentMiddleName; pvm.StudentLastName = item.StudentLastName; pvm.UserID = item.UserID; var completionDate = (from ans in db.ExitInterview where ans.StudentUserID == pvm.UserID select new { CompletionDate = ans.CompletionDate }) .ToList(); ExitInterview exit = db.ExitInterview.FirstOrDefault(x => x.StudentUserID == pvm.UserID); if (completionDate.Count() != 0) { pvm.CompletionDate = exit.CompletionDate; } StudentInventorylist.Add(pvm); } // Set the number of pages var _UserAsIPagedList = new StaticPagedList <TestViewModel> ( StudentInventorylist, intPage, intPageSize, intTotalPageCount ); return(View(_UserAsIPagedList)); } catch (Exception ex) { ModelState.AddModelError(string.Empty, "Error: " + ex); List <TestViewModel> StudentInventorylist = new List <TestViewModel>(); return(View(StudentInventorylist.ToPagedList(1, 25))); } }