public long Login(Credenciales cre)
{
DSL _connection = new DSL();
try
{
_connection.Open(ConfigurationManager.ConnectionStrings["dbLogin"].ToString(), RNConnection.DataAbstractionLayer.eProvider.SQLServer);
_connection.InitialSQLStatement("dbo.Autenticarse", System.Data.CommandType.StoredProcedure);
_connection.SetParameterProcedure("@nick", System.Data.ParameterDirection.Input, RNConnection.DataAbstractionLayer.eTypes.Cadena, cre.Nick);
_connection.SetParameterProcedure("@pwd", System.Data.ParameterDirection.Input, RNConnection.DataAbstractionLayer.eTypes.Cadena, cre.Password);
long IdCredencial = long.Parse(_connection.ReturnObject().ToString());
return IdCredencial;
}
catch (Exception ex)
{
throw new Exception("Error: " + ex.Message, ex);
}
}
public int CompAuth(long obtainedCred)
{
DSL _connection = new DSL();
try
{
_connection.Open(ConfigurationManager.ConnectionStrings["dbLogin"].ToString(), RnConection.DataAbstractionLayer.Provedor.SQLServer);
_connection.InitialSQLStatement("ComprobarNivel", System.Data.CommandType.StoredProcedure);
_connection.SetParameterProcedure("@id", System.Data.ParameterDirection.Input, RnConection.DataAbstractionLayer.eTypes.Entero, obtainedCred);
int NivelAuth = int.Parse(_connection.ReturnObject().ToString());
return(NivelAuth);
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
finally
{
_connection.Close();
}
}
public long Login(Username users)
{
DSL _connection = new DSL();
try
{
_connection.Open(ConfigurationManager.ConnectionStrings["dbLogin"].ToString(), RnConection.DataAbstractionLayer.Provedor.SQLServer);
_connection.InitialSQLStatement("Autenticarse", System.Data.CommandType.StoredProcedure);
_connection.SetParameterProcedure("@nick", System.Data.ParameterDirection.Input, RnConection.DataAbstractionLayer.eTypes.Cadena, users.user);
_connection.SetParameterProcedure("@pwd", System.Data.ParameterDirection.Input, RnConection.DataAbstractionLayer.eTypes.Cadena, users.password);
long IdCredencial = long.Parse(_connection.ReturnObject().ToString());
return(IdCredencial);
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
finally
{
_connection.Close();
}
}
