public async Task <IActionResult> StudentDetails(long Id)
{
Student student = studentRepository.FindStudentById(Id);
IdentityUser user = await userManager.FindByIdAsync(student.IdentityUserId);
student.IdentityUser = user;
StudentAccademicInformation accademicInformation = studentRepository.FindStudentAccademicInformationById(student.Id);
StudentNextOfKinInformation nextOfKinInformation = studentRepository.FindStudentNextofKinById(student.Id);
StudentSponsor studentSponsor = studentRepository.FindStudentSponsorById(student.Id);
if (student == null)
{
ViewBag.ErrorMessage = $"The Student with Id = { Id } could not be found";
return(View("NotFound"));
}
StudentDetailsViewModel model = new StudentDetailsViewModel
{
Student = student,
StudentAccademicInformation = accademicInformation,
StudentSponsor = studentSponsor,
StudentNextOfKinInformation = nextOfKinInformation
};
return(View(model));
}
public void UpdateStudentSponsorformation(StudentSponsor studentSponsor)
{
context.StudentSponsors.Attach(studentSponsor);
context.Entry(studentSponsor).State = EntityState.Modified;
}
public void InsertStudentSponsor(StudentSponsor studentSponsor)
{
context.StudentSponsors.Add(studentSponsor);
}
public async Task <IActionResult> AddStudent(AddStudentViewModel model)
{
if (ModelState.IsValid)
{
IdentityUser user = new IdentityUser
{
UserName = passwordGenerator.GenerateUsernameFromEmail(model.EmailAddress),
Email = model.EmailAddress,
PhoneNumber = model.PhoneNumber
};
IdentityResult result = await userManager.CreateAsync(user, passwordGenerator.GeneratePassword(15));
string uniqueName = processFileUpload.UploadImage(model.Image, "uploads");
Student student = new Student
{
Firstname = model.Firstname,
Middlename = model.Middlename,
Lastname = model.Lastname,
Gender = model.Gender,
DateOfBirth = model.DateOfBirth.ToLongDateString(),
PhoneNumber = model.PhoneNumber,
AlternateEmailAddress = model.AlternateEmailAddress,
EmailAddress = model.EmailAddress,
Religion = model.Religion,
MaritalStatus = model.MaritalStatus,
ResidentialAddress = model.ResidentialAddress,
ContactAddress = model.ContactAddress,
AlternatePhoneNumber = model.AlternatePhoneNumber,
IdentityUserId = user.Id,
DepartmentId = model.DepartmentId,
CourseYearId = SetStudentCurrentYear(model.PreviousLevel.Value.ToString()),
ProfilePhotoPath = uniqueName,
MatriculationNumber = SetMatriculationNumber(model.FacultyId, model.DepartmentId)
};
studentRepository.InsertStudent(student);
studentRepository.Save();
StudentAccademicInformation accademicInformation = new StudentAccademicInformation
{
NameOfInstitution = model.NameOfInstitution,
YearEnrolled = model.YearEnrolled.ToLongDateString(),
YearOfGraduation = model.YearOfGraduation.ToLongDateString(),
PreviousLevel = model.PreviousLevel,
StudentId = student.Id
};
studentRepository.InsertStudentAccademicInformation(accademicInformation);
studentRepository.Save();
StudentNextOfKinInformation nextOfKinInformation = new StudentNextOfKinInformation
{
NextOfKinFirstname = model.NextOfKinFirstname,
NextOfKinLastname = model.NextOfKinLastname,
RelationToNextOfKin = model.RelationToNextOfKin,
PhoneOfNextOfKin = model.PhoneOfNextOfKin,
EmailOfNextOfKin = model.EmailOfNextOfKin,
StudentId = student.Id
};
studentRepository.InsertStudentNextOfKin(nextOfKinInformation);
studentRepository.Save();
StudentSponsor studentSponsor = new StudentSponsor
{
SponsorFirstname = model.SponsorFirstname,
SponsorMiddlename = model.SponsorMiddlename,
SponsorLastname = model.SponsorLastname,
SponsorEmailAddress = model.SponsorEmailAddress,
SponsorPhoneNumber = model.SponsorPhoneNumber,
SponsorContactAddress = model.SponsorContactAddress,
SponsorProffession = model.SponsorProffession,
SponsorWorkAddress = model.SponsorWorkAddress,
StudentId = student.Id
};
SetStudentCourses(student.Id, student.DepartmentId, student.CourseYearId);
studentRepository.InsertStudentSponsor(studentSponsor);
studentRepository.Save();
return(Redirect("allstudents"));
}
ListAllFaculties(model);
ListAllDepartments(model);
return(View(model));
}
public async Task <IActionResult> UpdateStudentData(UpdateStudentDataViewModel model)
{
if (ModelState.IsValid)
{
Student student = studentRepository.FindStudentById(model.Id);
StudentAccademicInformation accademicInformation = studentRepository.FindStudentAccademicInformationById(student.Id);
StudentNextOfKinInformation nextOfKinInformation = studentRepository.FindStudentNextofKinById(student.Id);
StudentSponsor studentSponsor = studentRepository.FindStudentSponsorById(student.Id);
if (student == null)
{
ViewBag.ErrorMessage = $"The Student with Id = { model.Id } could not be found";
return(View("NotFound"));
}
IdentityUser user = await userManager.FindByIdAsync(student.IdentityUserId);
user.Email = model.EmailAddress;
user.PhoneNumber = model.PhoneNumber;
IdentityResult result = await userManager.UpdateAsync(user);
if (result.Succeeded)
{
// Update Student Personal information
student.Firstname = model.Firstname;
student.Middlename = model.Middlename;
student.Lastname = model.Lastname;
student.Gender = model.Gender;
student.DateOfBirth = model.DateOfBirth.ToLongDateString();
student.PhoneNumber = model.PhoneNumber;
student.AlternatePhoneNumber = model.AlternatePhoneNumber;
student.EmailAddress = model.EmailAddress;
student.Religion = model.Religion;
student.MaritalStatus = model.MaritalStatus;
student.ResidentialAddress = model.ResidentialAddress;
student.ContactAddress = model.ContactAddress;
student.AlternateEmailAddress = model.AlternateEmailAddress;
student.DepartmentId = model.DepartmentId;
student.CourseYearId = SetStudentCurrentYear(model.PreviousLevel.Value.ToString());
if (model.Image != null)
{
if (model.ExistingPhotoPath != null)
{
string filePath = Path.Combine(hostingEnvironment.WebRootPath, "uploads", model.ExistingPhotoPath);
System.IO.File.Delete(filePath);
}
student.ProfilePhotoPath = processFileUpload.UploadImage(model.Image, "uploads");
}
studentRepository.UpdateStudent(student);
studentRepository.Save();
// Update Student Accademic information
accademicInformation.NameOfInstitution = model.NameOfInstitution;
accademicInformation.YearEnrolled = model.YearEnrolled.ToLongDateString();
accademicInformation.YearOfGraduation = model.YearOfGraduation.ToLongDateString();
accademicInformation.PreviousLevel = model.PreviousLevel;
studentRepository.UpdateStudentAccademicInformation(accademicInformation);
studentRepository.Save();
// Update Student Next of kin information
nextOfKinInformation.NextOfKinFirstname = model.NextOfKinFirstname;
nextOfKinInformation.NextOfKinLastname = model.NextOfKinLastname;
nextOfKinInformation.EmailOfNextOfKin = model.EmailOfNextOfKin;
nextOfKinInformation.PhoneOfNextOfKin = model.PhoneOfNextOfKin;
nextOfKinInformation.RelationToNextOfKin = model.RelationToNextOfKin;
studentRepository.UpdateStudentNextofKinformation(nextOfKinInformation);
studentRepository.Save();
// Update student sponsor information
studentSponsor.SponsorFirstname = model.SponsorFirstname;
studentSponsor.SponsorMiddlename = model.SponsorMiddlename;
studentSponsor.SponsorLastname = model.SponsorLastname;
studentSponsor.SponsorEmailAddress = model.SponsorEmailAddress;
studentSponsor.SponsorPhoneNumber = model.SponsorPhoneNumber;
studentSponsor.SponsorContactAddress = model.SponsorContactAddress;
studentSponsor.SponsorProffession = model.SponsorProffession;
studentSponsor.SponsorWorkAddress = model.SponsorWorkAddress;
studentRepository.UpdateStudentSponsorformation(studentSponsor);
studentRepository.Save();
return(RedirectToAction("allstudents"));
}
foreach (var error in result.Errors)
{
ModelState.AddModelError(string.Empty, error.Description);
}
}
return(View(model));
}
public IActionResult UpdateStudentData(long Id)
{
if (Id.Equals(0))
{
ViewBag.ErrorMessage = $"The Id = { Id } could not be matched to any resource";
return(View("NotFound"));
}
Student student = studentRepository.FindStudentById(Id);
StudentAccademicInformation accademicInformation = studentRepository.FindStudentAccademicInformationById(student.Id);
StudentNextOfKinInformation nextOfKinInformation = studentRepository.FindStudentNextofKinById(student.Id);
StudentSponsor studentSponsor = studentRepository.FindStudentSponsorById(student.Id);
Faculty faculty = studentRepository.GetFacultyByDepartmentId(student.DepartmentId);
if (student == null)
{
ViewBag.ErrorMessage = $"The Student with Id = { Id } could not be found";
return(View("NotFound"));
}
UpdateStudentDataViewModel model = new UpdateStudentDataViewModel
{
// Student Personal Information
Id = student.Id,
Firstname = student.Firstname,
Middlename = student.Middlename,
Lastname = student.Lastname,
Gender = student.Gender,
DateOfBirth = Convert.ToDateTime(student.DateOfBirth),
PhoneNumber = student.PhoneNumber,
AlternateEmailAddress = student.AlternateEmailAddress,
EmailAddress = student.EmailAddress,
Religion = student.Religion,
MaritalStatus = student.MaritalStatus,
ResidentialAddress = student.ResidentialAddress,
ContactAddress = student.ContactAddress,
AlternatePhoneNumber = student.AlternatePhoneNumber,
ExistingPhotoPath = student.ProfilePhotoPath,
DepartmentId = student.DepartmentId,
FacultyId = faculty.Id,
// Student Accademic Information
NameOfInstitution = accademicInformation.NameOfInstitution,
YearEnrolled = Convert.ToDateTime(accademicInformation.YearEnrolled),
YearOfGraduation = Convert.ToDateTime(accademicInformation.YearOfGraduation),
PreviousLevel = accademicInformation.PreviousLevel,
// Student Next of kin information
NextOfKinFirstname = nextOfKinInformation.NextOfKinFirstname,
NextOfKinLastname = nextOfKinInformation.NextOfKinLastname,
RelationToNextOfKin = nextOfKinInformation.RelationToNextOfKin,
PhoneOfNextOfKin = nextOfKinInformation.PhoneOfNextOfKin,
EmailOfNextOfKin = nextOfKinInformation.EmailOfNextOfKin,
// Student Sponsor information
SponsorFirstname = studentSponsor.SponsorFirstname,
SponsorMiddlename = studentSponsor.SponsorMiddlename,
SponsorLastname = studentSponsor.SponsorLastname,
SponsorEmailAddress = studentSponsor.SponsorEmailAddress,
SponsorPhoneNumber = studentSponsor.SponsorPhoneNumber,
SponsorContactAddress = studentSponsor.SponsorContactAddress,
SponsorProffession = studentSponsor.SponsorProffession,
SponsorWorkAddress = studentSponsor.SponsorWorkAddress,
};
ListAllDepartments(model);
return(View(model));
}
