ASP.NET

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

.UseSetting(WebHostDefaults.DetailedErrorsKey, "true")

"90909090900"

public class ServiceChatsModel
{
    public string To { get; set; }
    public string From { get; set; }
}

[HttpPost]
[Route("api/CustomerService")]
public HttpResponseMessage  GetServiceChats(ServiceChatsModel model)
{
    ...

feelblue87 wrote:

Request Method: GET

feelblue87 wrote:

C#

string SQLCommand = "UPDATE [dbo].[M_EMP_MASTER] ";
SQLCommand = SQLCommand + "SET ";
SQLCommand = SQLCommand + "[EMP_GENDER] = '" + TempValue + "' ";
SQLCommand = SQLCommand + "WHERE [EMP_CODE] = '" + _EmpCode + "'";

[HttpPut]
[Route("api/PutEmployeeGenderEmpCode/{_EmpCode}")]
public void PutEmployeeGenderEmpCode(string _EmpCode)
{
    const string SQLCommand = "UPDATE [dbo].[M_EMP_MASTER] SET [EMP_GENDER] = @EmpGender WHERE [EMP_CODE] = @EmpCode";
    
    string TempValue = "1";
    
    using (var conn = new SqlConnection(ConnectionString))
    using (var cmd2 = new SqlCommand(SQLCommand, conn))
    {
        cmd2.Parameters.AddWithValue("@EmpGender", TempValue);
        cmd2.Parameters.AddWithValue("@EmpCode", _EmpCode);
        
        CheckConnectionStatus(conn);
        
        conn.Open();
        cmd2.ExecuteNonQuery();
    }
}