How Can I get the id of logged user? - ASP.NET MVC

Question

3.00/5 (1 vote)

See more:

Hi. Here is my login controller:

SQL

public ActionResult Login(Login login)
{
    if (ModelState.IsValid)
    {
        if (new AllFictionMembershipProvider().ValidateUser(login.Email, Criptografia.Encriptar(login.Senha)))
        {
            FormsAuthentication.SetAuthCookie(login.Email, false);

            return RedirectToDefault();

        }
    }

    ModelState.AddModelError("Erro", "Login ou senha incorretos!");
    return View(login);
}

I am thinking in creating a session that saves the id of the user after his login, because I need to access it in another controller, to make an insert. How Can I do it?

Posted 15-Oct-14 6:04am

Member 11126363

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Suraj Sahoo | Coding Passion · Accepted Answer · 2014-10-15T06:31:00

Solution 2

When you are using this ActionResult, you are passing the Login Model, as in Username/Email and Password oviously. Out of these, atleast the Username/Email should be unique. So, out of these unique property, retreive the User Id from the database using the Unique property like

The context method LINQ would go like:

SQL

var userID = Context.USER.Where(user=>user.UserName == login.userName).select(user=>user.UserID);

Here I have considered, UserName as the Unique property, use the context method in the Service not in the controller.
Then Store the UserID in a session like

C#

Session["UserID"] = userID;
var idToBeUsedForInsert = Convert.ToInt32(Session["UserID"]);

Then try parse the Session into int and Then user the ID to insert into the database.
Hope you get some idea from this, else please post back your comments regarding your queries.
Thanks
:)

Posted 15-Oct-14 6:31am

Suraj Sahoo | Coding Passion

Comments

Member 11126363 15-Oct-14 13:04pm

I think i got it. But how can I call it in another controller?

[no name] 15-Oct-14 13:06pm

There is a very nice method, butbefore suggesting that I would like to know if your using repository pattern and dependency Injection ofcourse!!

Member 11126363 15-Oct-14 13:35pm

Let me explain better. My table login has the following columns: IdLogin, IdUser, Email, password, and DateLogin. The Email and passoword, are the same that the user used to register on my site. On my db, I have a table called text that contains: IdText,IdUser, Texts). The user can write the text on my site, but they need to be logged on. So, When a user choose to write a text, I have to retrieve his Id, to put it in text table. So I will know who write that text.

[no name] 15-Oct-14 13:50pm

This is pretty straight forward. Have you tried using the session and use that in the controller??

Member 11126363 15-Oct-14 14:01pm

I tried to do with that example you posted earlier, but i'm not getting any Id.

[no name] 15-Oct-14 14:03pm

you are not getting any Id from the query??

Member 11126363 15-Oct-14 14:06pm

Yep. it's gettin null

[no name] 15-Oct-14 14:08pm

Are you getting values in the login passed as parameter?
Please check the values and the query is right.Please check again.

Member 11126363 15-Oct-14 14:16pm

I'm getting values, but the id is null, don't know why

[no name] 15-Oct-14 14:19pm

This sounds strange. Try the query once in the Sql Server and check if get the data. This should return the ID.

Member 11126363 15-Oct-14 14:24pm

Yeah, I already checked there. The values are there. Could you post a example how would you do a login?

[no name] 15-Oct-14 14:28pm

I can help you get out of this.
The approach you have taken is correct.
Just the query seems not to be working for you
But according to the logic the query seems to be correct.
You are getting the email and password from the login parameter??

Member 11126363 15-Oct-14 14:41pm

Yes! I get both email and password. only the id that is null