public Data executeRequest(string name, List <Parameter> parameters, string connectionString)
{
lock (conexion) {
try
{
conexion.ConnectionString = connectionString;
var cmd = new SqlCommand(name, conexion);
cmd.CommandType = CommandType.StoredProcedure;
foreach (var p in parameters)
{
var p1 = new SqlParameter(string.Format("{0}{1}", "@", p.nombre)
, p.valor);
p1.Direction = ParameterDirection.Input;
cmd.Parameters.Add(p1);
}
conexion.Open();
var reader = cmd.ExecuteReader();
return(DataBuilder.getData(reader));
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (conexion != null && conexion.State == ConnectionState.Open)
{
conexion.Close();
}
}
}
}
public Data executeRequest(string name, List <Parameter> parameters, string connectionString)
{
var parametros = "";
foreach (var p in parameters)
{
if (p.localizacion == 2)
{
parametros += p.valor + ",";
}
}
var uri = new Uri(connectionString + name + "/" + (parametros.Length > 0 ? parametros.Substring(0, parametros.Length - 1) : ""));
var http = (HttpWebRequest)HttpWebRequest.Create(uri);
var byteArray = new UTF8Encoding().GetBytes(ConfigurationManager.AppSettings["UserSICOM"] + ":" + ConfigurationManager.AppSettings["PasswordSICOM"]);
http.Method = "POST";
if (ConfigurationManager.AppSettings["ApiCredentials"] == "True")
{
var credentialCache = new System.Net.CredentialCache();
credentialCache.Add(
uri,
"Basic",
new System.Net.NetworkCredential(ConfigurationManager.AppSettings["User"], ConfigurationManager.AppSettings["Password"])
);
http.Credentials = credentialCache;
}
http.ContentType = "application/json; charset=utf-8";
foreach (var p in parameters)
{
if (p.localizacion == 1)
{
http.Headers.Add(p.nombre, p.valor);
}
if (p.localizacion == 3)
{
using (var streamWriter = new StreamWriter(http.GetRequestStream()))
{
streamWriter.Write(p.valor);
streamWriter.Flush();
streamWriter.Close();
}
}
}
try
{
var response = (HttpWebResponse)http.GetResponse();
if (response.StatusCode == HttpStatusCode.OK || response.StatusCode == HttpStatusCode.Created)
{
var Data = new Data();
using (var sr = new StreamReader(response.GetResponseStream()))
{
var responseJson = sr.ReadToEnd();
var jObj = JObject.Parse(responseJson);
return(DataBuilder.getData(jObj));
}
}
else
{
var jObj = JObject.Parse("{\"estado\":\"" + response.StatusDescription + "\"}");
return(DataBuilder.getData(jObj));
}
}
catch (Exception e)
{
JObject jObj = JObject.Parse("{\"estado\":\"error\"}");
return(DataBuilder.getData(jObj));
}
}