get UserId and nameId with Entity Framework login

RobertoCarlos Melgar

Good afternoon, I am working with Entity Framework, C # and Sql server, in a project, I have this method for login, which works correctly.

public static bool ValidarUsuario(string Usuario, string Password)
{
using (GourmetEntities db = new GourmetEntities())
{
// bcryp para encriptar, buscar información
var Usu = from u in db.tblUsuarios
where u.Usuario == Usuario && u.Password == Password
select new { u.Usuario,u.Perfil_Id};
if (Usu.Count() > 0)
{
return true;
}
else
{
return false;
}
}
}

but after that I need to get the UserId, UserName, and profileId to perform other operations, and I would like to save them in session variables, please how can I do that, since the return of my method is bool. This is the code of my button

private void BtnIngresar_Click(object sender, EventArgs e)
{
if(CapaDatos.tblUsuario.ValidarUsuario(TxtUsuario.Text, TxtPassword.Text))
{
FrmPadre frmPadre = new FrmPadre();
frmPadre.Show();
}
else
{
return;
}
}

Now with Entity Framework and linq I generate this sql server code which brings me the data I need,

but I don't know how to get it in c #

declare @p__linq__0 varchar(30) set @p__linq__0 = 'rmelgar';
declare @p__linq__1 varchar(30) set @p__linq__1 = '123456789sc';
SELECT
1 AS [C1],
[Extent1].[Usuario] AS [Usuario],
[Extent1].[Perfil_Id] AS [Perfil_Id]
FROM [dbo].[tblUsuarios] AS [Extent1]
WHERE ([Extent1].[Usuario] = @p__linq__0) AND ([Extent1].[Password] = @p__linq__1)

Please can you help me solve my problem, thank you very much

Please excuse me, I still don't know how to use the forum, I think I have formats that should not be

Roberto

8 Replies

Know the answer? Post it — somebody with the same question will find it here.

Salman Beg6y ago
Accepted answer
If you use FirstOrDefault then count will not work. Then during FirstOrDefault you need to use like this, if(Usu!=null) and then your rest of code. But if you use ToList() then you need to do a loop and as per your code it is perfect. Thanks.
RobertoCarlos Melgar6y ago
Salman Beg, thank you very much to help me solve my problem, I'll keep that code

Thank you

R Roberto
RobertoCarlos Melgar6y ago
Alright, I did this, add a Global class
namespace CapaDatos

{

    static class Global

    {

        //public static string nombreUsuario = "This is a global string.";

        private static string Usuario;



        public static string miUsuario



        {

            get { return Usuario; }

            set { Usuario = value; }

        }

    }

}
I did what you told me to do but I have a problem
when I make the change from Tolist () to FirtsOrDefault and remove var Usu = new List (); I have this problem

now i make this change inside if code add foreach

public static bool ValidarUsuario(string Usuario, string Password)

{



    using (GourmetEntities db = new GourmetEntities())

{

        //var Usu = new List();

        // bcryp para encriptar, buscar información

var Usu = (from u in db.tblUsuarios

where u.Usuario == Usuario && u.Password == Password

select new

{

u.Usuario,

u.Perfil_Id,

}).ToList();



  if (Usu.Count() > 0)

{

            foreach (var curren in Usu)

{

Global.miUsuario = curren.Usuario;

Global.MyPerfilId = (int)curren.Perfil_Id;

}

            return true;

}

        else

{

            return false;

}

}

}

To finish with this topic I ask you, is this correct to do work in three layers, and I did my class in the Data layer, and another question is correct to do the foreach inside the if, please can you help me with that more. Thanks a lot

Roberto
Salman Beg6y ago
Before return true line write our session related code. thanks
RobertoCarlos Melgar6y ago
Thank you where does the Classe Session ["User"] = please have an example since or a page that tells me how to do these. please Thank you
Salman Beg6y ago
Hey. Use like this, Session ["Usuario"]=Usu.Usuario; Session ["Perfil"]=Usu.Perfil_Id; And then get the value from session wherever required. Thanks
RobertoCarlos Melgar6y ago
Hi Salman Beg

Yes, thanks, but how do I do that, I already have the data in Usu, how do I create and assign a session variable.

thanks
Salman Beg6y ago
Hi. I think in the Usu you will get the Usuario and Perfil_Id as per your code. Just store these two values in session variable and use it everywhere. Thanks.