Пример #1
0
    public long LoginOUTPUT(Credenciales cre)
    {
        DSL _connection = new DSL();
        try
        {
            _connection.Open(ConfigurationManager.ConnectionStrings["dbLogin"].ToString(), RNConnection.DataAbstractionLayer.eProvider.SQLServer);
            _connection.InitialSQLStatement("dbo.Autenticarse_out", 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);
            _connection.SetParameterProcedure("@Credencial", System.Data.ParameterDirection.Output, RNConnection.DataAbstractionLayer.eTypes.Entero, null);

            long IdCredencial = long.Parse(_connection.ExecuteStroedOutPut().ToString());
            return IdCredencial;
        }
        catch (Exception ex)
        {
            return 0;
        }
    }