public ActionResult Print(string UserID)
{
var name = db.Students.Find(UserID);
var student = name.StudentLastName + ", " + name.StudentFirstName;
CounsellingContract check = db.CounsellingContract.FirstOrDefault(x => x.StudentUserID == UserID);
if (check == null)
{
TempData["Error"] = "This user has not agreed to the Counselling Terms!";
return(RedirectToAction("Index", "CounsellingContracts"));
}
else if (check.CompletionDate == null)
{
TempData["Error"] = "This user has not agreed to the Counselling Terms!";
return(RedirectToAction("Index", "CounsellingContracts"));
}
return(new ActionAsPdf(
"Details",
new { UserID = UserID })
{
FileName = string.Format("Counselling_Contract_{0}.pdf", student),
PageHeight = 105,
PageWidth = 210
});
}
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 Student(CounsellingContract 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 counsellingContract = db.CounsellingContract.FirstOrDefault(d => d.StudentUserID == currentUserId);
if (counsellingContract == null)
{
counsellingContract = db.CounsellingContract.Create();
counsellingContract.StudentUserID = currentUserId;
db.CounsellingContract.Add(counsellingContract);
db.SaveChanges();
}
CounsellingContract contract = db.CounsellingContract.FirstOrDefault(user => user.StudentUserID == currentUserId);
if (contract == null)
{
return(HttpNotFound());
}
if (ModelState.IsValid)
{
contract.CompletionDate = DateTime.Now;
bool studentAgrees = false;
if (vm.StudentAgrees == true)
{
studentAgrees = true;
TempData["Message"] = "You successsfully agreed to the Guidance and Counselling Terms!";
}
else
{
studentAgrees = false;
TempData["Message"] = "You did not agree to the Guidance and Counselling Terms! Note that you have to agree prior any consultation with the Guidance Office.";
}
contract.StudentAgrees = studentAgrees;
db.SaveChanges();
}
else
{
TempData["Error"] = "Error: Entry not saved!";
}
return(RedirectToAction("Index", "Home"));
}
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.CounsellingContract
where ans.StudentUserID == pvm.UserID
select new { CompletionDate = ans.CompletionDate })
.ToList();
CounsellingContract contract = db.CounsellingContract.FirstOrDefault(x => x.StudentUserID == pvm.UserID);
if (completionDate.Count() != 0)
{
pvm.CompletionDate = contract.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)));
}
}
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));
}
