As a Laravel user for quite sometime, it's quite easy for me to add User creator, modifier and timestamp for each model.
In the case of .Net 6 (or even earlier) it can be handled at DbContext and creating your base class that has the generic properties for the timestamps (created at, modified at) and user details (created_by / modified_by)
using System.ComponentModel.DataAnnotations;
namespace YourApp.Models{
public class BaseEntity
{
public DateTime DateCreated { get; set; }
[Required]
//id of the user created
public string UserCreated { get; set; }
public DateTime? DateModified { get; set; }
[Required]
//id of the user edited
public string UserModified { get; set; }
}
}
Below is my subclass using the super class BaseEntity
using System.ComponentModel.DataAnnotations;using System.ComponentModel.DataAnnotations.Schema;namespace YourApp.Models;/** Patient Model*/public class MyCustomModel : BaseEntity{[StringLength(125)]public string FirstName { get; set; }[StringLength(125)]public string LastName { get; set; }[StringLength(125)]public string Middlename { get; set; } = string.Empty;}
So how to automatically do the timestamps and user details? I implemented the tutorial from the blog that I followed here. According to the blog, you can implement it at the override of your DbContext' SaveChangesAsync.
My DbContext below. I highlighted from the code below the important parts where the magic happens.
using Microsoft.EntityFrameworkCore;using YourApp.Models;using System.Security.Claims;namespace YourApp.Contexts{public class DataContext : DbContext{private readonly IHttpContextAccessor _httpContextAccessor;public DataContext(DbContextOptions <DataContext> options, IHttpContextAccessor httpContextAccessor) : base(options){_httpContextAccessor = httpContextAccessor;}public DbSet<MyCustomModel > CustomModels{ get; set; }protected override void OnModelCreating(ModelBuilder builder){base.OnModelCreating(builder);}public override Task<int> SaveChangesAsync(CancellationToken cancellationToken = default){var insertedEntries = this.ChangeTracker.Entries().Where(x => x.State == EntityState.Added).Select(x => x.Entity);var userId = _httpContextAccessor.HttpContext.User.FindFirst(ClaimTypes.NameIdentifier).Value;var currentUsername = !string.IsNullOrEmpty(userId)? userId: "Anonymous";foreach (var insertedEntry in insertedEntries){var auditableEntity = insertedEntry as BaseEntity;//If the inserted object is an Auditable.if (auditableEntity != null){auditableEntity.DateCreated = DateTime.Now;auditableEntity.UserCreated = currentUsername;auditableEntity.UserModified = currentUsername;}}var modifiedEntries = this.ChangeTracker.Entries().Where(x => x.State == EntityState.Modified).Select(x => x.Entity);foreach (var modifiedEntry in modifiedEntries){//If the inserted object is an Auditable.var auditableEntity = modifiedEntry as BaseEntity;if (auditableEntity != null){auditableEntity.DateModified = DateTime.Now;auditableEntity.UserModified = currentUsername;}}return base.SaveChangesAsync(cancellationToken);}}}
Aside from that, ensure also from your login that ClaimTypes.NameIdentifier is not empty
var userId = _httpContextAccessor.HttpContext.User.FindFirst(ClaimTypes.NameIdentifier).Value;
I set my value during login. See login method below.
[HttpPost][Route("login")]public async Task<IActionResult> Login([FromBody] UserLogin model){var user = await _userManager.FindByNameAsync(model.Username);if (user != null && await _userManager.CheckPasswordAsync(user, model.Password)){var userRoles = await _userManager.GetRolesAsync(user);var authClaims = new List<Claim>{new Claim(ClaimTypes.Name, user.UserName),new Claim(ClaimTypes.NameIdentifier, user.Id),new Claim(JwtRegisteredClaimNames.Jti, Guid.NewGuid().ToString()),};foreach (var userRole in userRoles){authClaims.Add(new Claim(ClaimTypes.Role, userRole));}var token = GetToken(authClaims);return Ok(new{token = new JwtSecurityTokenHandler().WriteToken(token),expiration = token.ValidTo});}return Unauthorized();}
That pretty much of it. Hope that helps you too.
