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