How to return only the ref. data to the logged in user

Question

I have a table that returns the following data from an SQL Server database:

• INITIAL KM;
• KM Final;
• Liters;
• R-value$.

However I would like to return only the values ref. to the logged in user.

In the table in BD, I have a column that saves the user name (Note: I know that the name is not the best way, but the user ID, but at the moment we will work with names).

Controller:

public class CombustivelController : Controller
{
    private CombustiveisContext db = new CombustiveisContext();

    // GET: Combustivel
    public async Task<ActionResult> Index()
    {
        return View(await db.CombustivelModels.ToListAsync());
    }

    .
    .
    .
    .
}

How could I do this consultation?

Answer 1

If you want to get the username logged in, just use the following code:

public class CombustivelController : Controller
{
    private CombustiveisContext db = new CombustiveisContext();

    // GET: Combustivel
    public async Task<ActionResult> Index()
    {
        var name = User.Identity.Name;
        return View(await db.CombustivelModels.Where(c => c.UserId == name).ToListAsync());
    }
}

However, this is not a very appropriate approach. I advise saving the ID user correctly.

To obtain the ID logged in user, just use this code:

using Microsoft.AspNet.Identity;
 ...
 public class CombustivelController : Controller
    {
        private CombustiveisContext db = new CombustiveisContext();

        // GET: Combustivel
        public async Task<ActionResult> Index()
        {
            var userId= User.Identity.GetUserId();
            return View(await db.CombustivelModels.Where(c => c.UserId == userId).ToListAsync());
        }
    }