public async Task <IActionResult> Edit(int id, [Bind("Id,StudentName,DateOfBirth,Photo,Height,Weight,GradeId")] TblStudentDetails tblStudentDetails) { if (id != tblStudentDetails.Id) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(tblStudentDetails); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!TblStudentDetailsExists(tblStudentDetails.Id)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } ViewData["GradeId"] = new SelectList(_context.TblGrade, "Id", "Id", tblStudentDetails.GradeId); return(View(tblStudentDetails)); }
public async Task <ActionResult <TblStudentDetails> > AddStudentDetails(TblStudentDetails studentDetails) { TblStudentDetails objTblStudentDetails = new TblStudentDetails(); objTblStudentDetails = studentDetails; try { if (objTblStudentDetails.StudentID == 0) { objTblStudentDetails.IsActive = true; objTblStudentDetails.CreatedDtTm = DateTime.Now; await _context.tbl_StudentDetails.AddAsync(objTblStudentDetails); await _context.SaveChangesAsync(); } else { _context.tbl_StudentDetails.Update(objTblStudentDetails); await _context.SaveChangesAsync(); } } catch (Exception ex) { Console.WriteLine("Exception", ex); return(Conflict(ex)); } return(Ok(objTblStudentDetails)); }
public async Task <ActionResult <TblStudentDetails> > DeleteStudent(int StudentId) { TblStudentDetails objTblStudentDetails = await _context.tbl_StudentDetails.Where(e => e.StudentID == StudentId).SingleOrDefaultAsync(); objTblStudentDetails.IsActive = false; _context.tbl_StudentDetails.Update(objTblStudentDetails); await _context.SaveChangesAsync(); return(Ok(objTblStudentDetails)); }
public async Task <IActionResult> Create([Bind("Id,StudentName,DateOfBirth,Photo,Height,Weight,GradeId")] TblStudentDetails tblStudentDetails) { if (ModelState.IsValid) { _context.Add(tblStudentDetails); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } ViewData["GradeId"] = new SelectList(_context.TblGrade, "Id", "Id", tblStudentDetails.GradeId); return(View(tblStudentDetails)); }
public async Task <ActionResult <TblStudentDetails> > GetStudent(int StudentId) { TblStudentDetails objTblStudentDetails = await _context.tbl_StudentDetails.Where(e => e.StudentID == StudentId).SingleOrDefaultAsync(); return(Ok(objTblStudentDetails)); }