AngularJS CRUD (Create Read Update Delete) Operation Using MVC

Using AutoMapper;using Azure; using IUMS.PRD.API.Middleware; using Microsoft.AspNetCore.Authorization; using Microsoft.AspNetCore.Cors; using Microsoft.AspNetCore.Http; using Microsoft.AspNetCore.Http.HttpResults; using Microsoft.AspNetCore.Identity; using Microsoft.AspNetCore.Mvc; using Microsoft.IdentityModel.Tokens; using System.IdentityModel.Tokens.Jwt; using System.Security.Claims; using System.Security.Cryptography; using System.Text; using UMS.PRD.SERVICES; using UMS.PRD.SERVICES.Model; using UMS.PRD.SERVICES.Models; namespace IUMS.PRD.API.Controllers { [Route("api/[controller]")] [ApiController] public class AuthenticateController : ControllerBase { private readonly IUserManagement _svc; private readonly IRoleMaster _role; //private readonly IMapper _mapper; private readonly IConfiguration _configuration; private readonly ILogger<GlobalExceptionHandlingMiddleware> _logger; public AuthenticateController(IUserManagement svc, IRoleMaster role, IConfiguration configuration, ILogger<GlobalExceptionHandlingMiddleware> logger) { _svc = svc; _role = role; _configuration = configuration; // _mapper = mapper; _logger = logger; } [AllowAnonymous] [HttpPost] [Route("login")] public async Task<IActionResult> GetUser([FromBody] UserLoginModel model) { // try // { var users = await _svc.GetUser(model.Username, model.Password); var USerDetails = users.FirstOrDefault(); if (USerDetails != null) { var userrole = await _svc.GetuserRole(USerDetails.UserId.ToString()); var authClaims = new List<Claim> { new Claim(ClaimTypes.Name, USerDetails.UserName), new Claim(ClaimTypes.Email, USerDetails.Email), new Claim(ClaimTypes.Gender, "M"), new Claim("FULLNAME", USerDetails.Firstname +""+ USerDetails.Lastname), new Claim(ClaimTypes.Surname,"KUMAR"), new Claim("UserId", USerDetails.UserId.ToString()), new Claim(JwtRegisteredClaimNames.Jti, Guid.NewGuid().ToString()), }; foreach (var userRole in userrole) { authClaims.Add(new Claim(ClaimTypes.Role, userRole.UserRoleName)); } var token = CreateToken(authClaims); var refreshToken = GenerateRefreshToken(); _ = int.TryParse(_configuration["JWT:RefreshTokenValidityInDays"], out int refreshTokenValidityInDays); // user.RefreshToken = refreshToken; // user.RefreshTokenExpiryTime = DateTime.Now.AddDays(refreshTokenValidityInDays); return Ok(new { Token = new JwtSecurityTokenHandler().WriteToken(token), RefreshToken = refreshToken, Expiration = token.ValidTo, Firstname = USerDetails.UserName, Lastname = USerDetails.Lastname, id= USerDetails.UserId, roles=userrole }); } return Unauthorized(); //} //catch //{ // _logger.LogError("Error"); // // throw ex; // return Ok(new Exception { Errorcode = "500", Message = "Error" }); //} } [HttpPost] [Authorize] [Route("register")] public async Task<IActionResult> Register([FromBody] UserManagementModel model) { var result = await _svc.AddUser(model); if (result == -1) return StatusCode(StatusCodes.Status500InternalServerError, new Response { Status = "Error", Message = "User already exists!" }); if (result.ToString() == "") return StatusCode(StatusCodes.Status500InternalServerError, new Response { Status = "Error", Message = "User creation failed! Please check user details and try again." }); return Ok(new Response { Status = "Success", Message = "User created successfully!" }); } [HttpGet] [Authorize] //[ValidateAntiForgeryToken] [Route("GetAlluser")] public async Task<IActionResult> userAll() { var users = await _svc.GetAllUser(); if (users != null) return Ok(users); return NoContent(); } [HttpGet] [Authorize] [Route("Getrole")] public async Task<IActionResult> GetRole() { var role = await _svc.GetRole(); if (role != null) return Ok(role); return NoContent(); } [HttpGet] [Authorize] [Route("GetUserById/{userid}")] public async Task<IActionResult> GetUserById(string userid) { var users = await _svc.GetById(Convert.ToInt32(userid)); if (users != null) return Ok(users.FirstOrDefault()); return NoContent(); } [HttpPut] [Authorize] [Route("updateuser/{id}")] public async Task<IActionResult> updateuser([FromRoute] int id, [FromBody] UserManagementModel model) { var users = await _svc.updateUser(id, model); if (users != 0) return Ok(users); return NoContent(); } [HttpDelete] [Authorize] [Route("deleteuser/{id}")] public async Task<IActionResult> DeleteUser([FromRoute] int id) { var users = await _svc.delteUser(id); if (users != 0) return Ok(users); return NoContent(); } [HttpPost] [Authorize] [Route("AddRole")] public async Task<IActionResult> Addrole([FromBody] RoleModel model) { var result = await _role.AddRole(model); if (result == -1) return StatusCode(StatusCodes.Status500InternalServerError, new Response { Status = "Error", Message = "Role already exists!" }); if (result.ToString() == "") return StatusCode(StatusCodes.Status500InternalServerError, new Response { Status = "Error", Message = "User Role failed! Please check user details and try again." }); return Ok(new Response { Status = "Success", Message = "Role created successfully!" }); } [HttpPost] [Authorize] [Route("GetAllrole")] public async Task<IActionResult> GetAllrole() { var users = await _role.Getrole(); if (User != null) return Ok(users); return NoContent(); } [AllowAnonymous] [HttpPost("refresh-token")] public async Task<IActionResult> RefreshToken(UserManagementModel2 tokenModel) { if (tokenModel is null) { return BadRequest("Invalid client request"); } string? accessToken = tokenModel.Token; string? refreshToken = tokenModel.RefreshToken; var principal = GetPrincipalFromExpiredToken(accessToken); if (principal == null) { return BadRequest("Invalid access token or refresh token"); } #pragma warning disable CS8600 // Converting null literal or possible null value to non-nullable type. #pragma warning disable CS8602 // Dereference of a possibly null reference. string username = principal.Identity.Name; // Get the claims values var UserId = principal.Claims.Where(c => c.Type == "UserId") .Select(c => c.Value).SingleOrDefault(); var UFullName = principal.Claims.Where(c => c.Type == "FULLNAME") .Select(c => c.Value).SingleOrDefault(); //var sid = principal.Claims.Where(c => c.Type == ClaimTypes.Sid) // .Select(c => c.Value).SingleOrDefault(); #pragma warning restore CS8602 // Dereference of a possibly null reference. #pragma warning restore CS8600 // Converting null literal or possible null value to non-nullable type. var users = await _svc.GetById(Convert.ToInt32(UserId)); var user = users.FirstOrDefault(); // var userrole = await _svc.GetuserRole(USerDetails.UserId.ToString()); if (user == null) //|| //user.RefreshToken != refreshToken || user.RefreshTokenExpiryTime <= DateTime.Now) { return BadRequest("Invalid access token or refresh token"); } var newAccessToken = CreateToken(principal.Claims.ToList()); var newRefreshToken = GenerateRefreshToken(); // user.RefreshToken = newRefreshToken; //await _userManager.UpdateAsync(user); //return new ObjectResult(new //{ // accessToken = new JwtSecurityTokenHandler().WriteToken(newAccessToken), // refreshToken = newRefreshToken //}); _ = int.TryParse(_configuration["JWT:TokenValidityInMinutes"], out int tokenValidityInMinutes); return Ok(new { Token = new JwtSecurityTokenHandler().WriteToken(newAccessToken), RefreshToken = newRefreshToken, Expiration = DateTime.Now.AddMinutes(tokenValidityInMinutes), Firstname = username, Lastname = UFullName, id = UserId, roles=user.UserRoleModel }); } private JwtSecurityToken CreateToken(List<Claim> authClaims) { var authSigningKey = new SymmetricSecurityKey(Encoding.UTF8.GetBytes(_configuration["JWT:Secret"])); _ = int.TryParse(_configuration["JWT:TokenValidityInMinutes"], out int tokenValidityInMinutes); var token = new JwtSecurityToken( issuer: _configuration["JWT:ValidIssuer"], audience: _configuration["JWT:ValidAudience"], expires: DateTime.Now.AddMinutes(tokenValidityInMinutes), claims: authClaims, signingCredentials: new SigningCredentials(authSigningKey, SecurityAlgorithms.HmacSha256) ); return token; } private static string GenerateRefreshToken() { var randomNumber = new byte[64]; using var rng = RandomNumberGenerator.Create(); rng.GetBytes(randomNumber); return Convert.ToBase64String(randomNumber); } private ClaimsPrincipal? GetPrincipalFromExpiredToken(string? token) { var tokenValidationParameters = new TokenValidationParameters { ValidateAudience = false, ValidateIssuer = false, ValidateIssuerSigningKey = true, IssuerSigningKey = new SymmetricSecurityKey(Encoding.UTF8.GetBytes(_configuration["JWT:Secret"])), ValidateLifetime = false }; var tokenHandler = new JwtSecurityTokenHandler(); var principal = tokenHandler.ValidateToken(token, tokenValidationParameters, out SecurityToken securityToken); if (securityToken is not JwtSecurityToken jwtSecurityToken || !jwtSecurityToken.Header.Alg.Equals(SecurityAlgorithms.HmacSha256, StringComparison.InvariantCultureIgnoreCase)) throw new SecurityTokenException("Invalid token"); return principal; } } }

Nice Example, with simple steps

Very nice and easy to understand

Code Downloaded. But I got the same content of this page in word file format. But having Source code in a visual studio would be better.

Well said! I am expert in MVC Ajax,etc but not in Angular. Thank you. Realy it is nice to learn.

Code downloaded. but unable to open files.unzip file name as .~lock.AngularJsWithMVC.odt# and AngularJsWithMVC.odt. any one can help

Code downloaded. but unable to open files

Where did getData come from on you StudentController.js Update?

Nice Article it is useful

Entity Data Model further description ?

Can you please put here details for TestDBEntities().....

Nice article thanks

Nice post......