Andres Edu's questions

I am trying to calculate the weekend days between two entered dates using the following code:

public int CalcularDias(DateTime fecha, DateTime fin)
    {
        int contador = 0;


        DateTime dtInicio = fecha;
        DateTime dtFin = fin;



        for (int k = dtInicio.Day; k < dtFin.Day;k++)
        {

            while (dtInicio.DayOfWeek == DayOfWeek.Saturday || dtInicio.DayOfWeek == DayOfWeek.Sunday)
            {
                dtInicio = dtInicio.AddDays(1);
                contador++;
            }

            dtInicio = dtInicio.AddDays(1);
        }



        return contador;

    }

The problem I have is that when the day of the date is greater than the date to compare it gives me a calculation error and I am trying to solve this error

I am trying to send an email from my system when creating a document, but I get the following error: 'The SMTP server requires a secure connection or the client was not authenticated. The response from the server was: 5.7.57 ' I have tried different methods that I have found, but they all give me the same error.

The code I am using is the following

  public static bool SendMail()
    {
        var resultado = false;
        string error = "";
        string claveCorreo = System.Configuration.ConfigurationManager.AppSettings["AdminPassword"];
        try
        {
            MailMessage mail = new MailMessage();
            mail.To.Add("[email protected]");
            mail.From = new MailAddress("[email protected]", "Portal Empleados");
            mail.Subject = "Correo de Prueba";
            mail.Body = "Este es una prueba";
            mail.IsBodyHtml = true;

            var smtp = new SmtpClient()
            {
                Credentials = new System.Net.NetworkCredential("[email protected]", claveCorreo),
                Host = "smtp.office365.com",
                Port = 587,
                EnableSsl = true,
            };
            smtp.Send(mail);
            resultado = true;
        }
        catch (Exception e)
        {
            error = e.Message.ToString();
            resultado = false;
        }
        return resultado;

    }

How can I send the data of the row that I select to create a pdf since when I press the button to generate the pdf it only takes the data of the first row. I am using MVC in c# where I get the data from the database in a table in the view and these are listed if they are valid there I have no problems with how to show my problem is how can I send the form that I have below which is the that sends the data to the controller which captures the data to generate the pdf, I do this through a script

@using Model
@using Sys.Remuneracion.Models
@model List<DiasAusencia>
@{
ViewBag.Title = "Index";
Layout = "~/Views/Shared/_Layout.cshtml";
}

@{
ViewBag.Title = "Index";
Layout = "~/Views/Shared/_Layout.cshtml";
var permisos = (PermisoView)ViewData["permisosUsuario"];
}



@section css{
<link href="~/Css/Ingreso.css" rel="stylesheet" />
}

<!-- Content Header (Page header) -->
<section class="content-header">
    <div class="container-fluid">
        <div class="row mb-2">
            <div class="col-sm-6">
                <h1>Mantenedor de Comprobantes</h1>
            </div>
            <div class="col-sm-6">
                <ol class="breadcrumb float-sm-right">
                    <li class="breadcrumb-item"><a href="@Url.Content("~/Home")">Inicio</a></li>
                    <li class="breadcrumb-item active">Comprobantes</li>
                </ol>
            </div>
        </div>
    </div>
</section>
<section class="content">

    <div class="container-fluid">

        <div class="row">

            <div class="col-12">

                <div class="card">
                    <div class="card-header">
                        <h3 class="card-title">Listado de Comprobantes</h3>



                    </div>

                    <!-- /.card-header -->
                    <form class="formAddImportacion" method="post">
                        <div class="card-body">
                            //tabla que se llena con los datos 
                            <table id="datatable" class="table table-bordered table- 
                             hover" style="width:100%">

                                <thead>

                                    <tr>
                                        <th>#</th>
                                        <th>Empleado</th>
                                        <th>Rut</th>
                                        <th>Permiso</th>
                                        <th>Días</th>
                                        <th>Fecha inicio</th>
                                        <th>Fecha termino</th>
                                        <th>Acciones</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @foreach (var item in Model)
                                    {
                                        <tr>
                                            <td id="idPermiso">@item.IdDiasAusencia</td>
                                            <td id="nombre">@($"{item.Contrato.Empleado.Nombre} 
                                            {item.Contrato.Empleado.Ap_Paterno}")</td>
                                            <td id="rutEmpleado">@item.Contrato.Empleado.Rut</td>
                                            <td id="tipoPermiso">@item.TipoPermisoLaboral.Nombre</td>
                                            <td id="dias">@item.Dias</td>
                                            <td id="fechaInicio">@item.FechaInicio.ToString("dd-MM-yyyy")</td>
                                            <td id="fechaFin">@item.FechaTermino.ToString("dd-MM-yyyy")</td>
                                            <td>
                                                <button style="margin:auto" class="c-btn c-btn--primary" type="button" onclick="generarPDF();" title="PDF">
                                                    <i class="fas fa-file-pdf"></i>
                                                </button>
                                            </td>
                                        </tr>
                                    }
                                </tbody>

                            </table>

                        </div>
                    </form>
                    //Formulario que se envia al controlador con los datos de la tabla
                    <form class="pdfForm" method="post" action="~/ComprobanteVacaciones/GenerarPDF" target="_blank">

                        <input type="hidden" id="idComprobante" name="idPermiso" value="" />
                        <input type="hidden" id="nombreEmpleado" name="nombre" value="" />
                        <input type="hidden" id="rut" name="rut" value="" />
                        <input type="hidden" id="tipoPermisoVac" name="tipoPermiso" value="" />
                        <input type="hidden" id="diasPermiso" name="dias" value="" />
                        <input type="hidden" id="fechasInicial" name="fechaInicio" value="" />
                        <input type="hidden" id="fechasFinal" name="fechaFinal" value="" />

                    </form>
                </div>

            </div>

        </div>
    </div>
</section>

</div>

this is the script that takes the data from the table and assigns it to the form that is sent to the controller

@section scripts{

    <script>
    function generarPDF() {
        const idPermiso = document.getElementById("idPermiso").innerHTML;
        document.getElementById("idComprobante").value = idPermiso;

        const rut = document.getElementById("rutEmpleado").innerHTML;
        document.getElementById("rut").value = rut;

        const nombre = document.getElementById("nombre").innerHTML;
        document.getElementById("nombreEmpleado").value = nombre;

        const tipo = document.getElementById("tipoPermiso").innerHTML;
        document.getElementById("tipoPermisoVac").value = tipo;

        const Permiso = document.getElementById("dias").innerHTML;
        document.getElementById("diasPermiso").value = Permiso;

        const inicial = document.getElementById("fechaInicio").innerHTML;
        document.getElementById("fechasInicial").value = inicial;

        const final = document.getElementById("fechaFin").innerHTML;
        document.getElementById("fechasFinal").value = final;

        $(".pdfForm").submit();
    }

</script>


}

I am trying to get the data of an array but I cannot access the index of this array

 string s = "https://20.85.239.243:50000/b1s/v1/Orders(26)";

 String[] numeroOrden = s.Split('(');

 foreach (String numeroOrdens in numeroOrden)
 {
 String[] numOrden = numeroOrdens.Split(')');
 foreach (String datos in numOrden)
 {
    Console.WriteLine(datos);
    
 }

 }

The Response of this code gives me

https://.85.239.243:50000/b1s/v1/Orders

26

I need to get data 26

I am trying to put together a json with the following structure

{
"CardCode": "C003",
"DocumentLines": [
    {
        "ItemCode": "A004",
        "Quantity": "100",
        "TaxCode": "IVA",
        "UnitPrice": "500",
        "DiscountPercent": 10
    },
    {
        "ItemCode": "A005",
        "Quantity": "300",
        "TaxCode": "IVA",
        "UnitPrice": "250",
        "DiscountPercent": 10
    }
    
]
}

but when using the code in my class I get an error in the part where I declare the array since this json can receive multiple items to send it to the server

The class I have is this

public partial class Oferta
{
    [JsonProperty("CardCode")]
    public string CardCode { get; set; }

    [JsonProperty("DocumentLines")]
    public List<DocumentLine> DocumentLines { get; set; }
}
public partial class DocumentLine
{
    [JsonProperty("ItemCode")]
    public string ItemCode { get; set; }

    [JsonProperty("Quantity")]
    public decimal Quantity { get; set; }

    [JsonProperty("TaxCode")]
    public string TaxCode { get; set; }

    [JsonProperty("UnitPrice")]
    public decimal UnitPrice { get; set; }

    [JsonProperty("DiscountPercent")]
    public decimal DiscountPercent { get; set; }
}

And the code I use to build the json is this

 var oferta = new Oferta();
        oferta.CardCode = pedido.CodigoSAP_Cliente;
        foreach (var item in listaPedido)
        {
            
            oferta.DocumentLines = new List<DocumentLine>
            {
                new DocumentLine
                {
                    ItemCode = item.Codigo,
                    DiscountPercent = item.Descuento,
                    TaxCode = "IVA",
                    Quantity = item.Cantidad,
                    UnitPrice = item.Precio
                }
            };

        }
        string ofertaJson = JsonConvert.SerializeObject(oferta, Formatting.Indented);

I found this on the web but it is not working for me and I have been searching and I get similar things

Good People I try to access the data of this html table in an ASP.NET view I can only access the data of one line but I cannot access the data of the other rows of the tbody, I have tried with several methods but I can not access data

I am using this Script to iterate the elements inside the table but it drops when I try to do the second iteration

<script>
$("#btnDatos").click(function () {

    'use strict'

  
    const tBody = document.getElementById('tableResultContent').children;
    for (let j = 0; j < tBody.length; j++) {
        const tablerow = tBody[j];
        console.log("Table Row = ", tablerow);
        for (let i = 0; i < tablerow.length; i++) {
            var td = document.getElementsByTagName("td")[i].innerHTML;
            console.log(td);
            $.ajax({
                type: "GET",
                url: 'ListarPedido',
                data: { listaPedido: td },
                success: function (data) {
                    console.log(data);
                    $("#txtListado").val(data.listadoFinal);
                }
            });
        }
    }

})

Controller code that receives the script request

 [HttpPost]
    public JsonResult ListarPedido(string listaPedido)
    {
        var listado = listaPedido.ToString();
        var listaPedidoViewModel = new PedidoViewModel()
        {
            NombrePedProducto = "Nombre",
            UnidadMedida = "Unidad",
            Precio = 10,//decimal
            Stock = 10,//decimal
            Cantidad = 10,//decimal
            Descuento = 10,//decimal
            Observacion = "Obs",
            Total = 10,//decimal

        };
        
        return Json(new { listaPedidoViewModel }, JsonRequestBehavior.AllowGet);

    }

I am trying to send the data that I load from the product form to a grid with the product details and then send it to the database, but I cannot insert the data in the grid. I was looking at some methods on the web and it does not fill the data since most of the examples that I have seen the data are taken to list the grids from the database and what I need is to load the data of my form

As seen in the image, I put the data where I obtain data from a SAP server, which are the name, unit of measure, Stock and price per Unit, the total is obtained through a calculation with the button calculate total where I I enter the quantity, the discount and the observation of the form. This data is then sent to the controller that makes the queries to save the data in the database. This is the structure of the view to get the data and send it to the controller

     <div class="card card-warning">
      <div class="card-header">
       <h3 class="card-title">Producto</h3>
     </div>
                                        <div class="card-body">
                                            <div class="row">
                                                <div class="col-md-12">
                                                    <div class="row">
                                                        <div class="col-sm-12">
                                                            <div class="form-group">
                                                                <label>Nombre</label>
                                                                @Html.DropDownList("Nomb", Model.CargaItem(), new { @class = "form-control", maxlength = "100", id = "drpItem" })
                                                                @Html.TextBox("Nombre", Model.NombrePedProducto, new { @class = "form-control", maxlength = "500", id = "txtNombrePedido", style = "float:right; margin-top: 25px; display:none" })
                                                                @Html.ValidationMessage("Nombre")
                                                            </div>
                                                        </div>
                                                        <div class="col-sm-12">
                                                            <div class="form-group">
                                                                <label>Unidad Medida</label>
                                                                @Html.TextBox("Unidad", Model.UnidadMedida, new { @class = "form-control", maxlength = "100", id = "txtUnidad", ReadOnly = true })
                                                                @Html.TextBox("UnidadMedida", Model.UnidadMedida, new { @class = "form-control", maxlength = "500", id = "txtUMedida", style = "float:right; margin-top: 25px; display:none" })
                                                                @Html.ValidationMessage("UnidadMedida")
                                                            </div>
                                                        </div>
                                                        <div class="col-sm-12">
                                                            <div class="form-group">
                                                                <label>Stock</label>
                                                                @Html.TextBox("Stock", Model.Stock, new { @class = "form-control", maxlength = "100", id = "txtStock", ReadOnly = true })
                                                                @Html.ValidationMessage("Stock")
                                                            </div>
                                                        </div>
                                                        <div class="col-sm-12">
                                                            <div class="form-group">
                                                                <label>Precio por Unidad</label>
                                                                @Html.TextBox("Precio", Model.Precio, new { @class = "form-control", maxlength = "100", id = "txtPrecio", ReadOnly = true })
                                                                @Html.ValidationMessage("Precio")
                                                            </div>
                                                        </div>
                                                        <div class="col-sm-12">
                                                            <div class="form-group">
                                                                <label>Cantidad</label>
                                                                @Html.TextBox("Cantidad", Model.Cantidad, new { @class = "form-control", maxlength = "100", id = "txtCantidad" })
                                                                @Html.ValidationMessage("Cantidad")
                                                            </div>
                                                        </div>
                                                        <div class="col-sm-12">
                                                            <div class="form-group">
                                                                <label>Descuento</label>
                                                                @Html.TextBox("Descuento", Model.Descuento, new { @class = "form-control", maxlength = "100", id = "txtDescuento" })
                                                                @Html.ValidationMessage("Descuento")
                                                            </div>
                                                        </div>

                                                        <div class="col-sm-12">
                                                            <div class="form-group">
                                                                @Html.TextBox("CodigoSAP", Model.CodigoSAP, new { @class = "form-control", id = "txtCodigoItem", ReadOnly = true, style = "float:right; margin-top: 25px; display:none" })
                                                                @Html.ValidationMessage("CodigoSAP")
                                                            </div>
                                                        </div>
                                                        <div class="col-sm-12">
                                                            <div class="form-group">
                                                                @Html.TextBox("Codigo", Model.Codigo, new { @class = "form-control", id = "txtCodigo", ReadOnly = true, style = "float:right; margin-top: 25px; display:none" })
                                                                @Html.ValidationMessage("Codigo")
                                                            </div>
                                                        </div>
                                                        <div class="col-sm-12">
                                                            <div class="form-group">
                                                                <label>Observacion</label>
                                                                @Html.TextBox("Observacion", Model.Observacion, new { @class = "form-control", maxlength = "500", id = "txtObservacion" })
                                                                @Html.ValidationMessage("Observacion")
                                                            </div>
                                                        </div>
                                                        <div class="col-sm-12">
                                                            <div class="form-group">
                                                                <label>Total</label>
                                                                @Html.TextBox("Total", Model.Total, new { @class = "form-control", maxlength = "100", id = "txtTotal", ReadOnly = true })
                                                                @Html.ValidationMessage("Total")
                                                            </div>
                                                        </div>

                                                        <div class="col-sm-12">
                                                            <div class="form-group">

                                                                <input type="button" value="Calcular Total" class="btn btn-primary btn-sm" id="btnCalcular" style="margin:auto">
                                                                <input type="button" value="Agregar Producto" class="btn btn-primary btn-sm" id="btnAgregar" style="margin:auto">
                                                                @*<button class="btn btn-secondary" type="button" data-target="#modal_detalle_seccion" data-toggle="modal"
                                                                            data-backdrop="static" data-keyboard="false" onclick="obtenerdetalle();">
                                                                        <span class="fa-glass">Agregar Producto</span>
                                                                    </button>*@

                                                            </div>
                                                        </div>
                                                        <div class="col-sm-12">
                                                            <div class="form-group">
                                                                <table id="tbpedidos" class="table table-bordered table-hover" style="width:100%">
                                                                    <thead>
                                                                        <tr>
                                                                            <th>Nombre</th>
                                                                            <th>Unidad Medida</th>
                                                                            <th>Stock</th>
                                                                            <th>Precio Unitario</th>
                                                                            <th>Cantidad</th>
                                                                            <th>Descuento</th>
                                                                            <th>Observacion</th>
                                                                            <th>Total</th>
                                                                            <th>Acciones</th>
                                                                        </tr>
                                                                    </thead>
                                                                    <tbody>
                                                                        <tr>
                                                                            <td>Cintas</td>
                                                                            <td>Unidad</td>
                                                                            <td>6000</td>
                                                                            <td>1500</td>
                                                                            <td>100</td>
                                                                            <td>10%</td>
                                                                            <td>Venta Cinta</td>
                                                                            <td>135.000</td>
                                                                            <td>
                                                                                @*<button class="btn btn-default" data-toggle="tooltip" data-placement="top" title="Editar"> <i class="fa fa-edit"></i></button>
                                                                                    <button  class="btn btn-default btnEliminar"  data-toggle="tooltip" data-placement="top" title="Eliminar"><i class="fas fa-trash"></i></button>*@
                                                                            </td>
                                                                        </tr>
                                                                    </tbody>
                                                                </table>
                                                            </div>
                                                        </div>
                                                    </div>
                                                </div>
                                            </div>
                                        </div>
                                    </div>

What happens is that I was trying a script to insert the data into the grid but it hasn't worked for me since I've been doing the tests in the console and I get the data from the controller to get a json and put the data in the table grid

<script>
$('#btnAgregar').click(function () {
    $("#tableResult").html('');
    var nombre = $("#drpItem").val();
    var unidad = $("#txtUnidad").val();
    var precio = $("#txtPrecio").val();
    var stock = $("#txtStock").val();
    var cantidad = $("#txtCantidad").val();
    var descuento = $("#txtDescuento").val();
    var observacion = $("#txtObservacion").val();
    var totalPed = $("#txtTotal").val();

    var params = {
        nombrePedido: nombre,
        unidadPedido: unidad,
        precioPedido: precio,
        stockPedido: stock,
        cantidadPedido: cantidad,
        descuentoPedido: descuento,
        observacionPedido: observacion,
        totalPedido: totalPed
    }
    $.ajax({
        url: '/Pedido/Detalle',
        data: params,
        type: 'GET',
        dataType: 'json',
        success: function (response) {
            if (response.IsSuccess == true) {
                console.log(response);
                var body = '';
                body += '<tbody style="text-align: center">';
                '<tr class="c-table__row">' +
                    '<td class="c-table__cell">' + response.nombrePedido + '</td>' +
                    '</tr>' +
                    '</tbody>';

            }
            $("#tableResult").html(body);

        },
    });
})

    [HttpGet]
    public JsonResult Detalle(string nombrePedido, string unidadPedido, int 
    precioPedido, double stockPedido,int cantidadPedido, int descuentoPedido, string 
    observacionPedido, double totalPedido)
    {
        PedidoViewModel pedidos = new PedidoViewModel();
        pedidos.NombrePedProducto = nombrePedido;
        pedidos.UnidadMedida = unidadPedido;
        pedidos.Precio = precioPedido;
        pedidos.Stock = stockPedido;
        pedidos.Cantidad = cantidadPedido;
        pedidos.Descuento = descuentoPedido;
        pedidos.Observacion = observacionPedido;
        pedidos.Total = totalPedido;
        return Json(new { nombrePedido }, JsonRequestBehavior.AllowGet);
    }

I have tried with several examples that I have seen on the web but I can not get out of this problem if someone could give me a solution to this problem