ASP.NET

Richard MacCutchan wrote:

No one here can guess what your code is doing.

signIn(): Observable<boolean> {

    let subject = new Subject<boolean>();
    this.auth2.signIn().then(user => {
      const profile = user.getBasicProfile(),
        auth = user.getAuthResponse(),
        token = localStorage.getItem("authToken");

      let gU = new SignIn();
      gU.Id = profile.getId();
      gU.FirstName = profile.getGivenName();
      gU.LastName = profile.getFamilyName();
      gU.AccountName = profile.getEmail();
      gU.Password = "2LsdFDdsfb5Ejr";
      gU.Token = token !== null ? token : "";
      gU.Role = "Account";
      gU.ExpiresAt = new Date(auth.expires_at);
      gU.IdpId = "google";
      gU.RememberMe = true;
      gU.Avatar = new Avatar();
      gU.Avatar.Url = profile.getImageUrl();

      this.validateTokenAsPromise(gU)        
        .then(user => {
          this.zone.run(() => {            
          if (user) {
            localStorage.setItem("Account", JSON.stringify(user, null, "\t"));
            if (user.Token) {
              localStorage.setItem("authToken", user.Token);
            }            
            this.user$.next(user);
            this.isLoggedIn$.next(true);
            this.auth2SignedIn.emit(true);
            subject.next(true);
          } else {
            this.isLoggedIn$.next(false);
            this.auth2SignedIn.emit(false);
            subject.next(false);
          }
        });
      },
      (err) => {
        console.error("GAuth2 Service Error", err);
        this.isLoggedIn$.next(false);
        this.auth2SignedIn.emit(false);
        subject.next(false);
      });
    });
    return subject.asObservable();
  }

Erreur du serveur dans l'application '/'.

Opération non valide. La connexion est fermée. 
  Description : Une exception non gérée s'est produite au moment de l'exécution de la requête Web actuelle. Contrôlez la trace de la pile pour plus d'informations sur l'erreur et son origine dans le code. 

 Détails de l'exception: System.InvalidOperationException: Opération non valide. La connexion est fermée.

Erreur source: 


 Une exception non gérée s'est produite lors de l'exécution de la requête Web actuelle. Les informations relatives à l'origine et l'emplacement de l'exception peuvent être identifiées en utilisant la trace de la pile d'exception ci-dessous.  

Trace de la pile: 



[InvalidOperationException: Opération non valide. La connexion est fermée.]
   System.Data.ProviderBase.DbConnectionClosed.get_ServerVersion() +80
   System.Data.Odbc.OdbcConnection.get_ServerVersion() +12

public DataSet GetLs(string que)
       {
           DataSet ds1 = new DataSet();
           try
           {
               cn.Open();
               cm.Connection = cn;
               cm.CommandText = que;
               cm.CommandType = CommandType.Text;
               OdbcDataAdapter da1 = new OdbcDataAdapter(cm);
               da1.Fill(ds1);
               return ds1;

           }
           catch (Exception e)
           {

               throw e;
           }
           finally
           {
               cn.Close();
                       }

       }

public JsonResult LstDepartement()
     {
         DataSet ds2 =Dt.GetLsts ("select * from Departement");
         List<Departement> lstDepart = new List<Departement>();
         foreach (DataRow dr1 in ds2.Tables[0].Rows)
         {
             lstDepart.Add(new Departement
             {
                 ID = dr1["Id_Depart"].ToString(),
                 Désignation = dr1["Departement"].ToString(),
             });
         }
         return Json(lstDepart, JsonRequestBehavior.AllowGet);
     }

public DataSet GetLs(string que)
       {
...
       }

public JsonResult LstDepartement()
     {
         DataSet ds2 =Dt.GetLsts ("select * from Departement");
...
     }

DataSet ds2 =Dt.GetLsts ("SELECT * FROM Departement WHERE SalesCode = " + salescCode);

SELECT * FROM MyTable WHERE StreetAddress = 'Baker's Wood'

SELECT * FROM MyTable WHERE StreetAddress = 'x';DROP TABLE MyTable;--'

SELECT * FROM MyTable WHERE StreetAddress = 'x';

DROP TABLE MyTable;

--'

public DataSet GetLsts(string que)
   {
       DataSet ds1 = new DataSet();
       try
       {

           cnxs.Open();
           cmds.Connection = cnxs;
           cmds.CommandText = que;
           cmds.CommandType = CommandType.Text;
           SqlDataAdapter da1 = new SqlDataAdapter(selectCommand: cmds);
           da1.Fill(ds1);

               return ds1;

       }
       catch (Exception e)
       {

           throw e;
      }
       finally
       {
           cnxs.Close();

          //  ds1.Clear();

           }

   }

using (OdbcConnection con = new OdbcConnection(strConnect))
    {
    con.Open();
    using (OdbcCommand cmd = new OdbcCommand("SELECT Age, Description FROM myTable WHERE ID = @ID", con))
        {
        cmd.Parameters.AddWithValue("@ID", myTextBox.Text);
        using (OdbcDataReader reader = cmd.ExecuteReader())
            {
            while (reader.Read())
                {
                int age = (int) reader["Age"];
                string desc = (string) reader["Description"];
                Console.WriteLine($"{age}\n{desc}");
                }
            }
        }
    }

using System;
using System.Text;
using System.Net;
using System.Net.Sockets;
using System.Runtime.InteropServices;

namespace BOMBuilder
{
    public class NetworkUtils
    {
        private StringBuilder errormessage = new StringBuilder();
        private bool portIsOpen = false;
        private bool serverIsUp = true;
        private bool hasErrors = false;

        private bool HasErrors
        {
            get
            {
                return hasErrors;
            }
            set
            {
                hasErrors = value;
            }
        }

        private bool ServerIsUp
        {
            get
            {
                return serverIsUp;
            }
            set
            {
                serverIsUp = value;
            }
        }

        private bool PortIsOpen
        {
            get
            {
                return portIsOpen;
            }
            set
            {
                portIsOpen = value;
            }
        }

        private StringBuilder Errormessage
        {
            get
            {
                return errormessage;
            }
            set
            {
                errormessage = value;
            }
        }

        public string GetErrorMessage()
        {
            return Errormessage.ToString();
        }

        [StructLayout(LayoutKind.Sequential, CharSet = CharSet.Ansi)]
        private struct ICMP_OPTIONS
        {
            public byte Ttl;
            public byte Tos;
            public byte Flags;
            public byte OptionsSize;
            public IntPtr OptionsData;
        }

        [StructLayout(LayoutKind.Sequential, CharSet = CharSet.Ansi)]
        private struct ICMP_ECHO_REPLY
        {
            public int Address;
            public int Status;
            public int RoundTripTime;
            public short DataSize;
            public short Reserved;
            public IntPtr DataPtr;
            public ICMP_OPTIONS Options;
            [MarshalAs(UnmanagedType.ByValTStr, SizeConst = 250)]
            public string Data;
        }

        [DllImport("icmp.dll", SetLastError = true)]
        private static extern IntPtr IcmpCreateFile();

        [DllImport("icmp.dll", SetLastError = true)]
        private static extern bool IcmpCloseHandle(IntPtr handle);

        [DllImport("icmp.dll", SetLastError = true)]
        private static extern int IcmpSendEcho(IntPtr icmpHandle, int destinationAddress, string requestData, short requestSize, ref ICMP_OPTIONS requestOptions, ref ICMP_ECHO_REPLY replyBuffer, int replySize, int timeout);
        // Try to ping ip and open port.
        public void Ping(IPAddress ip, int port)
        {
            this.ServerIsUp = false;
            this.PortIsOpen = true;
            IntPtr icmpHandle = IcmpCreateFile();
            ICMP_OPTIONS icmpOptions = new ICMP_OPTIONS();
            icmpOptions.Ttl = 20;
            ICMP_ECHO_REPLY icmpReply = new ICMP_ECHO_REPLY();
            string sData = "x";

            IcmpSendEcho(icmpHandle, BitConverter.ToInt32(ip.GetAddressBytes(), 0), sData, (short)sData.Length, ref icmpOptions, ref icmpReply, Marshal.SizeOf(icmpReply), 1);
            IcmpCloseHandle(icmpHandle);
            ServerIsUp = icmpReply.Status == 0;

            Socket s = new Socket(AddressFamily.InterNetwork, SocketType.Stream, ProtocolType.Tcp);

            try
            {
                if (ServerIsUp)
                    s.Connect(ip, port);
            }
            catch (SocketException se)
            {
                PortIsOpen = false;
                HasErrors = true;
                Errormessage.Append(se.Message);
            }
            finally
            {
                if (s.Connected)
                    s.Disconnect(false);
            }
        }

        // ****** I call this method *****
        public bool ServerIsRunningOn(IPAddress iPAddress, int port)
        {
            this.Ping(iPAddress, port);
            return (this.ServerIsUp && this.PortIsOpen);
        }
    }
}