ResponcedbContex - Hightechrobo bin

CSHARP 7

ResponcedbContex Guest on 21st January 2025 10:58:09 AM

using System;
using System.Data;
using System.Collections.Generic;
using System.Configuration;
using System.Data.SqlClient;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
namespace DeviceMonitor.DBContext
{
internal class ResponcedbContex
{
public readonly string connectionString = ConfigurationManager.ConnectionStrings["connectionStr"].ConnectionString;
public void InsertResponce(string MyResponce, string MyError, string RCode, string MyRequest)
{
try
{
using (var con = new SqlConnection(connectionString))
{
SqlCommand cmd = new SqlCommand("spInsertResponce", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter parametrResponce = new SqlParameter()
{
ParameterName = "@MyResponce",
Value = Convert.ToString(MyResponce)
};
cmd.Parameters.Add(parametrResponce);
SqlParameter parametrError = new SqlParameter()
{
ParameterName = "@MyError",
Value = Convert.ToString(MyError)
};
cmd.Parameters.Add(parametrError);
SqlParameter parametrRCode = new SqlParameter()
{
ParameterName = "@RCode",
Value = Convert.ToString(RCode)
};
cmd.Parameters.Add(parametrRCode);
SqlParameter parametrMyRequest = new SqlParameter()
{
ParameterName = "@Request",
Value = Convert.ToString(MyRequest)
};
cmd.Parameters.Add(parametrMyRequest);
con.Open();
cmd.ExecuteReader();
con.Close();
}
}
catch (Exception ex)
{
string msg = ex.Message;
}
}
}
}

Advertise here

Recent Pastes

Russian Teen Gets[...]

Raw Paste

using System;
using System.Data;
using System.Collections.Generic;
using System.Configuration;
using System.Data.SqlClient;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace DeviceMonitor.DBContext
{
    internal class ResponcedbContex
    {

public readonly string connectionString = ConfigurationManager.ConnectionStrings["connectionStr"].ConnectionString;

public void InsertResponce(string MyResponce, string MyError, string RCode, string MyRequest) 
        {
            try
            {
                using (var con = new SqlConnection(connectionString))
                {
                    SqlCommand cmd = new SqlCommand("spInsertResponce", con);
                    cmd.CommandType = CommandType.StoredProcedure;

SqlParameter parametrResponce = new SqlParameter()
                    {
                        ParameterName = "@MyResponce",
                        Value = Convert.ToString(MyResponce)
                    };
                    cmd.Parameters.Add(parametrResponce);

SqlParameter parametrError = new SqlParameter()
                    {
                        ParameterName = "@MyError",
                        Value = Convert.ToString(MyError)
                    };
                    cmd.Parameters.Add(parametrError);

SqlParameter parametrRCode = new SqlParameter()
                    {
                        ParameterName = "@RCode",
                        Value = Convert.ToString(RCode)
                    };
                    cmd.Parameters.Add(parametrRCode);

SqlParameter parametrMyRequest = new SqlParameter()
                    {
                        ParameterName = "@Request",
                        Value = Convert.ToString(MyRequest)
                    };
                    cmd.Parameters.Add(parametrMyRequest);

con.Open();
                    cmd.ExecuteReader();
                    con.Close();
                }

}

catch (Exception ex)
            {
                string msg = ex.Message;
            }

}
    }
}