private static async Task EnsureApprover(IServiceProvider svcProvider, string userName, string tempPW,
string firstName, string lastName,
string agencyID, string subagencyID, string programShortName,
bool emailNotify)
{
Console.WriteLine("DataSeed.EnsureApprover: BEGIN");
////////////////////////////////////////////////////////////////////
// Create Approver
////////////////////////////////////////////////////////////////////
var userMgr = svcProvider.GetService <UserManager <ApplicationUser> >();
var user = await userMgr.FindByNameAsync(userName);
if (user == null)
{
user = new ApplicationUser
{
UserName = userName,
Email = userName,
EmailConfirmed = true,
FirstName = firstName,
LastName = lastName,
JobTitle = "Program Administrator",
AgencyID = agencyID,
SubAgencyID = subagencyID,
DateRegistered = DateTime.Now,
DateAccountExpires = DateTime.Now.AddDays(AccountConstants.DAYS_ACCOUNT_EXPIRES),
DatePasswordExpires = DateTime.Now,
RulesOfBehaviorAgreedTo = true,
};
await userMgr.CreateAsync(user, tempPW);
////////////////////////////////////////////////////////////////////
// Assign Approver Role to Approver
////////////////////////////////////////////////////////////////////
await userMgr.AddToRoleAsync(user, RoleConstants.APPROVER);
////////////////////////////////////////////////////////////////////
// Assign Approver to Program that he/she is authorized for
////////////////////////////////////////////////////////////////////
var dbContext = svcProvider.GetRequiredService <ApplicationDbContext>();
LMSProgram program = await dbContext.LMSPrograms.FirstOrDefaultAsync(p => p.ShortName == programShortName);
var programApprover = new ProgramApprover
{
LMSProgramID = program.LMSProgramID,
ApproverUserId = user.Id,
EmailNotify = emailNotify
};
dbContext.ProgramApprovers.Add(programApprover);
await dbContext.SaveChangesAsync();
}
Console.WriteLine("DataSeed.EnsureApprover: END");
}
private static async Task EnsureProgram(ApplicationDbContext dbContext, string shortName, string longName, string commonInbox)
{
Console.WriteLine("DataSeed.EnsureProgram: BEGIN");
LMSProgram program = await dbContext.LMSPrograms.FirstOrDefaultAsync(p => p.ShortName == shortName);
if (program == null)
{
program = new LMSProgram
{
ShortName = shortName,
LongName = longName,
CommonInbox = commonInbox
};
dbContext.LMSPrograms.Add(program);
await dbContext.SaveChangesAsync();
}
Console.WriteLine("DataSeed.EnsureProgram: END");
}
public async Task <IActionResult> OnPostAsync()
{
Console.WriteLine("ModelState.IsValid: " + ModelState.IsValid);
if (!ModelState.IsValid)
{
Console.WriteLine("ModelState IS NOT valid");
return(Page());
}
Console.WriteLine("ModelState IS valid");
////////////////////////////////////////////////////////////
// Retrieve "NONE TO PENDING" StatusTransition
////////////////////////////////////////////////////////////
var statusTransition = await _context.StatusTransitions
.Where(st => st.TransitionCode == TransitionCodeConstants.NONE_TO_PENDING)
.SingleOrDefaultAsync();
////////////////////////////////////////////////////////////
// Create ProgramEnrollment (root class), adding newly
// created EnrollmentHistory to the EnrollmentHistory
// collection
////////////////////////////////////////////////////////////
var programEnrollment = new ProgramEnrollment
{
LMSProgramID = Int32.Parse(Input.LMSProgramID),
StudentUserId = _userManager.GetUserId(User),
UserCreated = _userManager.GetUserId(User),
DateCreated = DateTime.Now,
StatusCode = StatusCodeConstants.PENDING,
EnrollmentHistory = new List <EnrollmentHistory>
{
new EnrollmentHistory
{
StatusTransitionID = statusTransition.StatusTransitionID,
ActorUserId = _userManager.GetUserId(User),
ActorRemarks = Input.Remarks,
DateCreated = DateTime.Now
}
}
};
/////////////////////////////////////////////////////////////////////
// Persist ProgramEnrollment plus EnrollmentHistory to the database
/////////////////////////////////////////////////////////////////////
_context.ProgramEnrollments.Add(programEnrollment);
await _context.SaveChangesAsync();
///////////////////////////////////////////////////////////////////
// Log the 'ENROLLMENT_REQUSTED' event
///////////////////////////////////////////////////////////////////
ApplicationUser student = await GetCurrentUserAsync();
// _eventLogService.LogEvent(EventTypeCodeConstants.ENROLLMENT_REQUSTED, student, programEnrollment.ProgramEnrollmentID);
_eventLogService.LogEvent(EventTypeCodeConstants.ENROLLMENT_REQUSTED, student, programEnrollment);
////////////////////////////////////////////////////////////////////////////////////
// Send email notification to approvers who have their EmailNotify flag set to true
////////////////////////////////////////////////////////////////////////////////////
IList <ProgramApprover> approverList = await _context.ProgramApprovers
.Where(pa => pa.LMSProgramID == programEnrollment.LMSProgramID && pa.EmailNotify == true)
.Include(pa => pa.Approver)
.Include(pa => pa.LMSProgram)
.AsNoTracking()
.ToListAsync();
foreach (ProgramApprover approverObj in approverList)
{
string email = approverObj.Approver.Email;
string subject = "Program Enrollment Request (" + approverObj.LMSProgram.LongName + ")";
string message = student.FullName + " has requested to enroll in " + approverObj.LMSProgram.LongName;
await _emailSender.SendEmailAsync(email, subject, message);
}
////////////////////////////////////////////////////////////////////////////////////
// Send email notification to LMS Program's common inbox (if any)
////////////////////////////////////////////////////////////////////////////////////
LMSProgram lmsProgram = await _context.LMSPrograms
.Where(p => p.LMSProgramID == programEnrollment.LMSProgramID && p.CommonInbox != null)
.AsNoTracking()
.SingleOrDefaultAsync();
if (lmsProgram != null &&
String.IsNullOrEmpty(lmsProgram.CommonInbox) == false)
{
string email = lmsProgram.CommonInbox;
string subject = "Program Enrollment Request (" + lmsProgram.LongName + ")";
string message = student.FullName + " has requested to enroll in " + lmsProgram.LongName;
await _emailSender.SendEmailAsync(email, subject, message);
}
/////////////////////////////////////////////////////////////////
// Redirect to Enrollmentl Index Page
/////////////////////////////////////////////////////////////////
return(RedirectToPage("./Index"));
}
public async Task <IActionResult> OnPostAsync(int?id)
{
if (id == null)
{
return(NotFound());
}
////////////////////////////////////////////////////////////
// Step #1:
// Check to see if records exists
////////////////////////////////////////////////////////////
var lvProgramEnrollment = await _context.ProgramEnrollments
.Include(p => p.LMSProgram)
.SingleOrDefaultAsync(m => m.ProgramEnrollmentID == id);
////////////////////////////////////////////////////////////
// Return "Not Found" if record doesn't exist
////////////////////////////////////////////////////////////
if (lvProgramEnrollment == null)
{
return(NotFound());
}
////////////////////////////////////////////////////////////
// Step #2:
// Now that record exists, make sure that the logged-in user
// is authorized to withdraw this program enrollment
////////////////////////////////////////////////////////////
var loggedInUserID = _userManager.GetUserId(User);
lvProgramEnrollment = null;
lvProgramEnrollment = await _context.ProgramEnrollments
.Where(pe => pe.StudentUserId == loggedInUserID && pe.ProgramEnrollmentID == id)
.Include(p => p.LMSProgram)
.SingleOrDefaultAsync();
/////////////////////////////////////////////////////////////
// We already know that record exists from Step #1 so if we
// get a "Not Found" in Step #2, we know it's because the
// logged-in user is not authorized to withdraw this
// program enrollment.
/////////////////////////////////////////////////////////////
if (lvProgramEnrollment == null)
{
return(Unauthorized());
}
////////////////////////////////////////////////////////////
// Retrieve the correct StatusTransition
////////////////////////////////////////////////////////////
StatusTransition lvStatusTranstion = null;
//////////////////////////////////////////////////////////////////////
// STATUS TRANSITION: PENDING TO WITHDRAEN
//////////////////////////////////////////////////////////////////////
if (lvProgramEnrollment.StatusCode.Equals(StatusCodeConstants.PENDING))
{
lvStatusTranstion = await _context.StatusTransitions
.Where(st => st.TransitionCode == TransitionCodeConstants.PENDING_TO_WITHDRAWN)
.SingleOrDefaultAsync();
}
//////////////////////////////////////////////////////////////////////
// STATUS TRANSITION: APPROVED TO WITHDRAEN
//////////////////////////////////////////////////////////////////////
if (lvProgramEnrollment.StatusCode.Equals(StatusCodeConstants.APPROVED))
{
lvStatusTranstion = await _context.StatusTransitions
.Where(st => st.TransitionCode == TransitionCodeConstants.APPROVED_TO_WITHDRAWN)
.SingleOrDefaultAsync();
}
////////////////////////////////////////////////////////////////
// Create EnrollmentHistory using the correct StatusTranistion
////////////////////////////////////////////////////////////////
var lvEnrollmentHistory = new EnrollmentHistory()
{
StatusTransitionID = lvStatusTranstion.StatusTransitionID,
ActorUserId = _userManager.GetUserId(User),
ActorRemarks = Input.Remarks,
DateCreated = DateTime.Now
};
////////////////////////////////////////////////////////////
// Instantiate EnrollmentHistory Collection, if necessary
////////////////////////////////////////////////////////////
if (lvProgramEnrollment.EnrollmentHistory == null)
{
lvProgramEnrollment.EnrollmentHistory = new List <EnrollmentHistory>();
}
///////////////////////////////////////////////////////////////////
// Add newly created EnrollmentHistory with StatusTransition
// to ProgramEnrollment's EnrollmentHistory Collection
///////////////////////////////////////////////////////////////////
lvProgramEnrollment.EnrollmentHistory.Add(lvEnrollmentHistory);
/////////////////////////////////////////////////////////////////
// Update ProgramEnrollment Record with
// 1. EnrollmentStatus of "WITHDRAWN"
// 2. ApproverUserId (logged-in user)
// 3. EnrollmentHistory (PENDING TO WiTHDRAWN)
/////////////////////////////////////////////////////////////////
lvProgramEnrollment.StatusCode = StatusCodeConstants.WITHDRAWN;
lvProgramEnrollment.ApproverUserId = _userManager.GetUserId(User);
_context.ProgramEnrollments.Update(lvProgramEnrollment);
await _context.SaveChangesAsync();
////////////////////////////////////////////////////////////////////////////////////
// Send email notification to approvers who have their EmailNotify flag set to true
////////////////////////////////////////////////////////////////////////////////////
IList <ProgramApprover> approverList = await _context.ProgramApprovers
.Where(pa => pa.LMSProgramID == lvProgramEnrollment.LMSProgramID && pa.EmailNotify == true)
.Include(pa => pa.Approver)
.Include(pa => pa.LMSProgram)
.AsNoTracking()
.ToListAsync();
ApplicationUser student = await GetCurrentUserAsync();
foreach (ProgramApprover approverObj in approverList)
{
string email = approverObj.Approver.Email;
string subject = "Program Enrollment Withdrawal (" + approverObj.LMSProgram.LongName + ")";
string message = student.FullName + " has withdrawn his/her enrollment in " + approverObj.LMSProgram.LongName;
await _emailSender.SendEmailAsync(email, subject, message);
}
////////////////////////////////////////////////////////////////////////////////////
// Send email notification to LMS Program's common inbox (if any)
////////////////////////////////////////////////////////////////////////////////////
LMSProgram lmsProgram = await _context.LMSPrograms
.Where(p => p.LMSProgramID == lvProgramEnrollment.LMSProgramID && p.CommonInbox != null)
.AsNoTracking()
.SingleOrDefaultAsync();
if (String.IsNullOrEmpty(lmsProgram.CommonInbox) == false)
{
string email = lmsProgram.CommonInbox;
string subject = "Program Enrollment Withdrawal (" + lmsProgram.LongName + ")";
string message = student.FullName + " has withdrawn his/her enrollment in " + lmsProgram.LongName;
await _emailSender.SendEmailAsync(email, subject, message);
}
/////////////////////////////////////////////////////////////////
// Redirect to Student Index Page
/////////////////////////////////////////////////////////////////
return(RedirectToPage("./Index"));
}
