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