How to create string out of this ajax post? [Answered]RSS

2 replies

Last post Nov 20, 2019 03:45 PM by napalm911

‹ Previous Thread|Next Thread ›

Shortcuts

Related Links

napalm911

Member

3 Points

9 Posts

How to create string out of this ajax post?

Nov 19, 2019 11:51 PM|napalm911|LINK

Hello everyone I currently have this scenario.

@{

}


@model comercial.Models.ModelPagosRecibidos
@{
    System.Data.DataSet ds_cargarClientes = Model.ligarPagoDoc();
    System.Data.DataTable dt_Clientes = new System.Data.DataTable();
    System.Data.DataSet ds_DocAbiertosCliente = Model.DocAbiertosCliente();
    System.Data.DataTable dt_DocAbiertos = ds_DocAbiertosCliente.Tables[1];
    System.Data.DataSet ds_MovimientosCliente = Model.MovimientosCliente();
    System.Data.DataTable dt_Movimientos = ds_MovimientosCliente.Tables[1];
}

<div class="row align-content-center">
    <div class="col-2">Pago Seleccionado</div>
    <div class="col-2">No Operacion:</div>
    <div class="col-2">Fecha:</div>
    <div class="col-2">Forma de Pago:</div>
    <div class="col-2">Importe:</div>
    <div class="col-2">Por Pagar:</div>
</div>

<div class="row align-content-center">
    <div class="col-2"></div>
    <div class="col-2">@Model._seleccionar_numoperacion.ToString()</div>
    <div class="col-2">@Model._seleccionar_fechaval.ToString()</div>
    <div class="col-2">@Model._seleccionar_formapago.ToString()</div>
    <div class="col-2"><font color="green">$@Model._seleccionar_deposito.ToString()</font></div>
    <div class="col-2"><font color="red">$ Por Pagar</font></div>
</div>


<br />


<div class="container-fluid">
    <!-- Page Heading -->
    <div class="table-striped">
        <table class="table table-bordered" width="100%" cellspacing="0" id="DocumentosAbiertos">
            <thead align="center">
                <tr>
                    <th>No.</th>
                    <th>No. Documento</th>
                    <th>Documento</th>
                    <th>Fecha</th>
                    <th>Hasta</th>
                    <th>Monto</th>
                    <th>Aplicar Pago</th>
                </tr>
            </thead>
            <tbody>
                @{
                    int autoincrement_docabiertos = 1;
                    foreach (System.Data.DataRow dr in dt_DocAbiertos.Rows)
                    {
                        string trans_no = dr["trans-no"].ToString();
                        string trans_date = dr["trans-date"].ToString();
                        string due_date = dr["due-date"].ToString();
                        string monto = dr["monto"].ToString();
                        string trans_code = dr["trans-code"].ToString();
                        <tr>
                            <td align="center">@(autoincrement_docabiertos++)</td>
                            <td align="center">@trans_no.Trim()<input type="hidden" id="txtDocumento@(trans_no)" name="txtDocumento@(trans_no)" value="@trans_no.Trim()" /></td>
                            <td><img src="~/Content/img/xml-icon.png" data-toggle="modal" data-target="#creditoXML" alt="Descargar XML" width="30" height="30"><img src="~/Content/img/pdf-icon.png" data-toggle="modal" data-target="#creditoPDF" alt="Descargar PDF" width="30" height="30"></td>
                            <td align="center">@trans_date.Trim()</td>
                            <td align="center">@due_date.Trim()</td>
                            <td align="center">$@monto.Trim()<input type="hidden" id="txtMonto" name="txtMonto" value="@monto.Trim()" /></td>
                            <td hidden>@trans_code.Trim()<input type="hidden" id="txtTipoDoc" name="txtTipoDoc" value="@trans_code.Trim()" /></td>
                            <td align="center"><input type="number" name="txtID" class="txtID" oninput="setValueAttr(this)" value="" min="0" max="@monto.Trim()" style="width: 100px" /></td>
                            <td hidden>@Model._seleccionar_numoperacion.ToString()</td>
                        </tr>
                    }
                }
            </tbody>
        </table>
    </div>
</div>

<button type="button" onclick="aplicar()">Aplicar</button>

<script>
    function setValueAttr(el) {
        el.setAttribute('value', el.value)
    }

    function aplicar() {
        var myTab = document.querySelectorAll('#DocumentosAbiertos tbody tr .txtID:not([value=""]):valid');
        var tableData = [];
        Array.from(myTab).forEach(input => {
            var tds = input.closest('tr').children;
            var obj = {};
            obj.A = tds[8].textContent;
            obj.B = tds[1].textContent;
            obj.C = tds[6].textContent;
            obj.D = tds[5].textContent;
            obj.E = input.value;
            tableData.push(obj);
        });
        console.log(tableData);

        var postData = { values: tableData };

    $.ajax({
        type: "POST",
        url: "/MovimientosCliente/SaveList",
        data: postData,
        success: function(data){
            alert(data.Result);
        },
        dataType: "json",
        traditional: true,
        error: function (error) {
            console.error(error);
        }
    });
    }
</script>

This is my controller

        [HttpPost]
        public JsonResult SaveList(List<LigarPagoModel> values)
        {
            return Json(new { Result = String.Format("Ejemplo indice 0: '{0}'", values[0]) });
        }

And this is my model

    public class LigarPagoModel
    {
        public string A { get; set; }
        public string  B { get; set; }
        public string  C { get; set; }
        public string D { get; set; }
        public string E { get; set; }
    }

I need to create a string out of this values from the array I pull from the view I posted at the beggining for example if there's n ammount of elements in tabledata[] for example 2 elements I need to create a string that looks like this

total[]=&num1={}&mon1={}&doc1={}&type1={}&val1={}&num2={}&mon2={}&doc2={}&type2={}&val2={}

Where

total = *n* the ammount of elements inside tableData[]

And

numN monN typeN valN = the values inside an element of tableData[]

Used that structure because of the output of the html example

[
  {
    "A": "val1",
    "B": "val2",
    "C": "val3",
    "D": "1500",
    "E": "1000"
  }
]

- Reply
jiadongm
Member

440 Points

163 Posts
Re: How to create string out of this ajax post?

Nov 20, 2019 06:13 AM|jiadongm|LINK
Hi napalm911,

I am not very clear from your description. Are you trying to make a query string with each element of tableData[]? If so, I think you can just splice the string with the element value.
```
for (i = 0; i < tableData.length; i++) {
            total[i] = "&num" + i + "=" + tableData[i].A +
                "&mon" + i + "=" + tableData[i].B +
                "&doc" + i + "=" + tableData[i].C +
                "&type" + i + "=" + tableData[i].D +
                "&val" + i + "=" + tableData[i].E
        }
```
Best Regards,

Jiadong Meng
MSDN Community Support

Please remember to click "Mark as Answer" the responses that resolved your issue.

If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com
- Reply
napalm911
Member

3 Points

9 Posts

Re: How to create string out of this ajax post?

Nov 20, 2019 03:45 PM|napalm911|LINK

Thanks a lot jiadongm this helped me to create the string I was going to create in my model, so instead of doing it over there, I'd rather create the string using javascript and post it as normal string, solved my issue thanks!