How to update AppDBContext in ASP.NET Core Web API

Question

I am quite new to ASP.NET and I am bit stuck with this. I am creating an entry in my DB while registering the user:

private async Task<bool> CreateEntryInUserActions(AppUser user)
        {
                var entity = new UserActionEntity
                {
                    UserId = user.Id,
                };

                await _context.tbl_UserActions.AddAsync(entity);
                await _context.SaveChangesAsync();

                return true;
         }

I want to change the IsPasswordChanged field in the UserActions table to true when a user changes his/her password. I am trying something like:

private async Task<bool> UpdateUserAction()
        {
            var userId = _httpContextAccessor.HttpContext.User.FindFirst(ClaimTypes.NameIdentifier).Value; // gives me current user's id

            var user = _context.tbl_UserActions
                .Where(x => x.UserId.ToString() == userId).Select(x => x.IsPasswordChanged);

        }

but I am not sure how to proceed and update this to "true". How do I update this entry?

shobhit vaish · Accepted Answer · 2020-04-27 08:49:22Z

1

You need to fetch the useraction entity from the table and then set the IsPasswordChanged property to true.

Try this:

private async Task<bool> UpdateUserAction()
    {
        var userId = _httpContextAccessor.HttpContext.User.FindFirst(ClaimTypes.NameIdentifier).Value; // gives me current user's id

        var user = _context.tbl_UserActions.FirstOrDefault(x => x.UserId.ToString() == userId);
        if(user != null) //check if the record is not null
        {
            user.IsPasswordChanged = true; // set the column to desired value
            _context.tbl_UserActions.Update(user);
            await _context.SaveChangesAsync();
         }

    }

answered Apr 27, 2020 at 8:49

shobhit vaish

9509 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Mansi Over a year ago

Oh I see. I though I had to query over the user and then use some pre-defined method to update the field. But this worked nicely. Thank you! :)

Collectives™ on Stack Overflow

How to update AppDBContext in ASP.NET Core Web API

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related