// POST: api/Publish
public string Post([FromBody] RequestPub requestPub)
{
HttpClient clienteHttp = new HttpClient();
//Abrir conexion
CorePOSApi.Business.Data.context.DataModelService da = new CorePOSApi.Business.Data.context.DataModelService();
string cadena = "SP_CONSULTAR_PROVEEDORES";
SqlCommand comando = new SqlCommand(cadena, da._connection);
//Ejecuto consulta de proveedores
SqlDataReader registros = comando.ExecuteReader();
while (registros.Read())
{
string url_consumo = registros["URL_CONSUMO"].ToString();
//Si esta subscrito
if (url_consumo != "")
{
requestPub.Codigo_proveedor = registros["CODIGO"].ToString();
var request = clienteHttp.PostAsync(url_consumo, requestPub, new JsonMediaTypeFormatter());
request.Wait();
GestorCorreo gestor = new GestorCorreo();
gestor.EnviarCorreo(registros["CORREO"].ToString(), "Cotización",
"Cotización - Codigo Despacho: " + requestPub.Codigo_despacho + " - Volumen: " + requestPub.Volumen + " - Peso: " + requestPub.Peso + " - Direccion_origen: " + requestPub.Direccion_origen + " - Direccion_destino: " + requestPub.Direccion_destino);
}
}
da._connection.Close();
return("Oferta enviada");
}
public static async Task <IActionResult> Run(
[HttpTrigger(AuthorizationLevel.Anonymous, "get", "post", Route = null)] HttpRequest req,
ILogger log)
{
// log.LogInformation("C# HTTP trigger function processed a request.");
// string name = req.Query["name"];
string responseMessage;
try
{
string requestBody = await new StreamReader(req.Body).ReadToEndAsync();
Modelos.DespachoMd data = JsonConvert.DeserializeObject <Modelos.DespachoMd>(requestBody);
// name = name ?? data?.name;
CorePOSApi.Business.Data.context.DataModelService da = new CorePOSApi.Business.Data.context.DataModelService();
da.ExecuteNonQueryModel <Modelos.DespachoMd>("dbo.spr_despachos_disponibles_insert", data);
responseMessage = "OK";
}
catch (Exception ex)
{
responseMessage = ex.Message;
}
return(new OkObjectResult(responseMessage));
}
// PUT api/Subscriber/5
public string Put(int id, [FromBody] RequestSub requestSub)
{
ProveedoresMd pmd = new ProveedoresMd();
pmd.Codigo = requestSub.Codigo_proveedor;
pmd.Url_Consumo = "";
CorePOSApi.Business.Data.context.DataModelService da = new CorePOSApi.Business.Data.context.DataModelService();
da.ExecuteNonQueryModel <Models.ProveedoresMd>("dbo.SP_UPDATE_PROVEEDORES_URL", pmd);
return("Subscripción cancelada");
}
