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(); } }