public async Task <IActionResult> OnGetAsync(int InstitutionOfficerId)
{
//id = 1;
var loginUser = _userManager.GetUserId(User);
//var userEmail = await _userManager.GetUserNameAsync(loginUser);
var userEmail = _userManager.GetUserName(User);
InstitutionOfficerId = await _context.InstitutionOfficers.Where(x => x.Email == userEmail).Select(x => x.Id).FirstOrDefaultAsync();
InstitutionOfficer = await _context.InstitutionOfficers.Where(x => x.Email == userEmail).FirstOrDefaultAsync();
if (InstitutionOfficerId < 0)
{
return(RedirectToPage("./Student_Visit_Form"));
}
//InstitutionOfficer = await _context.InstitutionOfficers.FindAsync(id = 19);
StudentSetUp = await _context.StudentSetUps.Include(x => x.Courses).Include(x => x.InstitutionOfficer).ThenInclude(x => x.Institution)
.Where(x => x.Suspended == false && x.InstitutionOfficerId == InstitutionOfficerId)
.ToListAsync();
if (StudentSetUp == null)
{
return(NotFound());
}
return(Page());
}
public async Task <IActionResult> PutInstitutionOfficer(int?id, InstitutionOfficer institutionOfficer)
{
if (id == null)
{
return(BadRequest("Intitution Officer is Empty"));
}
try
{
var updateOfficerRecord = await _context.InstitutionOfficers.FirstOrDefaultAsync(m => m.Id == id);
if (updateOfficerRecord == null)
{
return(NotFound($"Officer Not Found For The Selected Id {id}"));
}
updateOfficerRecord.Deactivate = institutionOfficer.Deactivate = true;
updateOfficerRecord.DateActivated = institutionOfficer.DateActivated;
updateOfficerRecord.ReasonDeactivate = institutionOfficer.ReasonDeactivate;
await _context.SaveChangesAsync();
return(Ok(updateOfficerRecord));
}
catch (Exception ex)
{
return(StatusCode(500, ex.Message));
}
}
public async Task <ActionResult <InstitutionOfficer> > PostInstitutionOfficer(InstitutionOfficer institutionOfficer)
{
try
{
var newOfficer = new InstitutionOfficer
{
InstitutionId = institutionOfficer.InstitutionId,
OfficerType = institutionOfficer.OfficerType,
IntOfficerName = institutionOfficer.IntOfficerName,
Address1 = institutionOfficer.Address1,
IntOfficerDesig = institutionOfficer.IntOfficerDesig,
PhoneNo = institutionOfficer.PhoneNo,
Email = institutionOfficer.Email,
//Change the stateID to LGA
LGAId = institutionOfficer.LGAId,
AccountName = institutionOfficer.AccountName,
BankSetUpId = institutionOfficer.BankSetUpId,
AccountNo = institutionOfficer.AccountNo,
SwitchCode = institutionOfficer.SwitchCode,
NumberOfStudent = institutionOfficer.NumberOfStudent,
};
_context.InstitutionOfficers.Add(newOfficer);
await _context.SaveChangesAsync();
return(CreatedAtAction("PostInstitutionOfficer", new { id = newOfficer.Id }, newOfficer));
}
catch (DbUpdateException)
{
return(StatusCode(500, "Menu Name Already Exist"));
}
}
public async Task <IActionResult> PutInstitutionOfficer(int?id, InstitutionOfficer institutionOfficer)
{
if (id == null)
{
return(BadRequest("Intitution Officer is Empty"));
}
try
{
var updateOfficerRecord = await _context.InstitutionOfficers.FirstOrDefaultAsync(m => m.Id == id);
if (updateOfficerRecord == null)
{
return(NotFound($"Officer Not Found For The Selected Id {id}"));
}
updateOfficerRecord.InstitutionId = institutionOfficer.InstitutionId;
updateOfficerRecord.OfficerType = institutionOfficer.OfficerType;
updateOfficerRecord.IntOfficerName = institutionOfficer.IntOfficerName;
updateOfficerRecord.Address1 = institutionOfficer.Address1;
updateOfficerRecord.IntOfficerDesig = institutionOfficer.IntOfficerDesig;
updateOfficerRecord.PhoneNo = institutionOfficer.PhoneNo;
updateOfficerRecord.Email = institutionOfficer.Email;
//Change the stateID to LGA
updateOfficerRecord.LGAId = institutionOfficer.LGAId;
updateOfficerRecord.AccountName = institutionOfficer.AccountName;
updateOfficerRecord.BankSetUpId = institutionOfficer.BankSetUpId;
updateOfficerRecord.AccountNo = institutionOfficer.AccountNo;
updateOfficerRecord.SwitchCode = institutionOfficer.SwitchCode;
updateOfficerRecord.NumberOfStudent = institutionOfficer.NumberOfStudent;
await _context.SaveChangesAsync();
return(Ok(updateOfficerRecord));
}
catch (Exception ex)
{
return(StatusCode(500, ex.Message));
}
}
public async Task <ActionResult <InstitutionOfficer> > PostInstitutionOfficer(InstitutionOfficer institutionOfficer)
{
_context.InstitutionOfficers.Add(institutionOfficer);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetInstitutionOfficer", new { id = institutionOfficer.Id }, institutionOfficer));
}
