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