Home / user-105198

Huntzberger's questions

Martin Hope
Huntzberger
Asked: 2022-04-17 13:03:35 +0800 CST
  • 3

I have the following arrays:

//data
    [
    {
      "idAgen":36,
      "asesor":"ARCANGEL",
      "idRegion":3,
      "region":"U",
      "idZona":3,
      "zona":"ARIO",
      "campos":291
      },
      {
      "idAgen":67,
      "asesor":"MIGUEL",
      "idRegion":3,
      "region":"U",
      "idZona":3,
      "zona":"ARIO",
      "campos":888
      },
      {
      "idAgen":90,
      "asesor":"JOSE",
      "idRegion":3,
      "region":"U",
      "idZona":3,
      "zona":"ARIO",
      "campos":291
      }
     ]

//pronostico
    [
      {
      "idAgen": 36, 
      "pronostico": 410693
      },
      {
      "idAgen": 36, 
      "pronostico": 8347
      },
      {
      "idAgen": 67, 
      "pronostico": 9877
      },
      {
      "idAgen": 67, 
      "pronostico": 9000
      },
      {
      "idAgen": 67, 
      "pronostico": 5363
      },
      {
      "idAgen": 90, 
      "pronostico": 896
      }
    ]

And what I'm trying to do is the following (for each data object):

    [
    {
      "idAgen":36,
      "asesor":"ARCANGEL",
      "idRegion":3,
      "region":"U",
      "idZona":3,
      "zona":"ARIO",
      "campos":291,
      "pronostico":[
        {
        "pronostico": 410693  
        },
        {
        "pronostico": 8347 
        }  
        ]
      }
     ]

I've tried this but it doesn't work, it adds the values ​​separately, like so:

    //data
    [
    {
      "idAgen":36,
      "asesor":"ARCANGEL",
      "idRegion":3,
      "region":"U",
      "idZona":3,
      "zona":"ARIO",
      "campos":291
      },
      { 
      "pronostico": 410693
      },
      { 
      "pronostico": 8347
      }
    ]

First I iterate both arrays, I start with forecast since it is bigger than data, then I iterate data, where the idAgen property is the same in both, add the forecast values ​​with push.


        for (var i = 0; i < pronostico.length; i++) 
         {
          for (var j = 0; j < data.length; j++) {
            if (pronostico[i]['idAgen'] == data[j]['idAgen'])
            {
              data.push({pronostico :pronostico[i]['pronostico']});  
            }
          }        
        }
        console.log(JSON.stringify(data));
javascript
Martin Hope
Huntzberger
Asked: 2022-03-12 08:52:10 +0800 CST
  • 2

I have an api for surveys, the answers are optional and free. I keep the free responses in an array, and the optional ones in another, and then one.

But the problem is that if the user changes the answer, it will continue to be saved in the array, duplicating the question.

What I need is that when saving the answer in the array it compares if that question id already exists and deletes the previous one and adds the new one.

I have tried something like this but it deletes the new answer, not the previous one: Example, idQuestion is 28 in both but it must eliminate the first one it finds, that is, object 1, even if idRelacion is different:

1: Object
idRelacion: 1212
idPregunta: 28

2: Object
idRelacion: 1111
idPregunta: 28

test

import React, { useState } from "react";
import ReactDOM from "react-dom";

export default function App() {
  var respuestas = [];

  const preguntas = [
    {
      idEncuesta: 7,
      encuesta: "Encuesta2 ",
      idPregunta: 26,
      pregunta: "¿Que tan probable es que le recomiende su jefe/a a un colega?",
      listaRes: [
        {
          idRelacion: 11,
          idPregunta: 27,
          idRespuesta: 1,
          respuesta: "Muy probable"
        },
        {
          idRelacion: 22,
          idPregunta: 27,
          idRespuesta: 2,
          respuesta: "Nada probable"
        }
      ]
    },
    {
      idEncuesta: 7,
      encuesta: "Encuesta2",
      idPregunta: 27,
      pregunta:
        "¿Qué tan fácil es obtener ayuda de su jefe/a cuando la necesita?",
      listaRes: [
        {
          idRelacion: 158,
          idPregunta: 130,
          idRespuesta: 76,
          respuesta: "Texto libre"
        }
      ]
    },
    {
      idEncuesta: 7,
      encuesta: "Encuesta2",
      idPregunta: 28,
      pregunta: "¿Qué tan disponible para los empleados esta su jefe?",
      listaRes: [
        {
          idRelacion: 88,
          idPregunta: 28,
          idRespuesta: 8,
          respuesta: "Nada disponible"
        },
        {
          idRelacion: 99,
          idPregunta: 28,
          idRespuesta: 9,
          respuesta: "Poco disponible"
        },
        {
          idRelacion: 1010,
          idPregunta: 28,
          idRespuesta: 10,
          respuesta: "Moderadamente disponible"
        },
        {
          idRelacion: 1111,
          idPregunta: 28,
          idRespuesta: 11,
          respuesta: "Muy disponible"
        },
        {
          idRelacion: 1212,
          idPregunta: 28,
          idRespuesta: 12,
          respuesta: "Extremadamente disponible"
        }
      ]
    }
  ];

  var [arrayPreguntas, setarrayPreguntas] = useState([]);
  const [respuestaIdRelacion, setRespuestaIdRelacion] = useState([]);

  var [arrayIdRelacion, setArrayIdRelacion] = useState([]);

  const [respuestaLibre, setRespuestaLibre] = useState([]);

  var [arrayRespuestaLibre, setArrayRespuestaLibre] = useState([]);

  const handleChange = (e) => {
    const { name, value } = e.target;

    setRespuestaIdRelacion((prevState) => ({
      ...prevState,
      idRelacion: parseInt(value),
      idPregunta: parseInt(name)
    }));
  };

  const onblurRespuesta = function () {
    arrayRespuestaLibre.push(respuestaLibre);
  };

  const onblurIdRelacion = function (e) {
    arrayPreguntas.push(respuestaIdRelacion);
    console.log(arrayPreguntas);

    arrayPreguntas = arrayPreguntas.filter(
      (thing, index, self) =>
        index === self.findIndex((t) => t && t.idPregunta === thing.idPregunta)
    );

    console.log(arrayPreguntas);
  };

  const guardar = (e) => {
    e.preventDefault();

    for (var i = 0; i < arrayPreguntas.length; i++) {
      arrayIdRelacion.push(arrayPreguntas[i].idRelacion);
      console.log(arrayIdRelacion);
    }

    if (arrayIdRelacion.length === 0) {
      return;
    }

    for (var j = 0; j < arrayIdRelacion.length; ++j) {
      respuestas.push({
        idRelacion: arrayIdRelacion[j],
        respuestaLibre: arrayRespuestaLibre[j]
      });
    }

    console.log(respuestas);
    //guardarRespuestas();
    respuestas = [];
  };

  return (
    <section style={{ display: "flex", justifyContent: "space-around" }}>
      <div>
        <form onSubmit={guardar}>
          <ol>
            {preguntas.map((item) => (
              <li key={item.id}>
                {item.pregunta}
                <ul className="list-group">
                  {item.listaRes.map((subitem) => (
                    <React.Fragment>
                      <li
                        name="opciones"
                        className="list-group"
                        key={subitem.idRelacion}
                      >
                        <>
                          <input
                            className="form-check-input"
                            type="radio"
                            name={subitem.idPregunta}
                            defaultValue={subitem.idRelacion}
                            /*  onChange={(e) =>
                              setRespuestaIdRelacion(e.target.value)
                            } */
                            onChange={handleChange}
                            onBlur={onblurIdRelacion}
                          ></input>
                          <label
                            className="form-check-label"
                            htmlFor="exampleRadios1"
                          >
                            {subitem.respuesta}
                          </label>
                        </>
                      </li>
                    </React.Fragment>
                  ))}
                  Obs.
                  <br />
                  <textarea
                    className="form-control mb-2"
                    type="text"
                    required
                    name="respuestaLibre"
                    autoComplete="off"
                    onChange={(e) => setRespuestaLibre(e.target.value)}
                    onBlur={onblurRespuesta}
                  ></textarea>
                </ul>
              </li>
            ))}
          </ol>
          <button
            className="btn btn-primary btn-sm active float-right btn-block"
            type="submit"
          >
            Guardar
          </button>
        </form>
      </div>
    </section>
  );
}

const rootElement = document.getElementById("root");
ReactDOM.render(<App />, rootElement);

javascript
Martin Hope
Huntzberger
Asked: 2022-07-11 07:51:01 +0800 CST
  • 3

What I am trying to do is that when the user completes the editText codigoTxt, the function initViewModelsent with the parameters of codigoTxtand a is called 0, with this the spinner is filled. Later, when the user chooses an option of the spinner, I want it to be called again, initViewModelsending the parameters of the spinner codigoTxtand the selected option with this, it fills some textview according to the selected option.

The problem is that when the user selects an element, the method onItemSelectedis repeated the number of times that the elements that the spinner contains. Example if there are 15 elements in the spinner and I choose option 2, the method is repeated 15 times for option 2

 class Nuevo : Fragment(){

    private lateinit var viewModel: ViewModel
    private lateinit var codigoTxt:EditText
    private lateinit var mySpinner: Spinner
    var options: List<Int> = mutableListOf<Int>()
   
        
      override fun onCreateView(inflater: LayoutInflater, container: ViewGroup?,savedInstanceState: Bundle?): View? {
    val view= inflater.inflate(R.layout.fragment_nuevo, container, false)
      
 codigoTxt= view.findViewById<EditText>(R.id.codigo)

  codigoTxt.addTextChangedListener(object:TextWatcher{
            override fun afterTextChanged(s: Editable?)  = Unit

            override fun beforeTextChanged(s: CharSequence?, start: Int, count: Int, after: Int)  = Unit

            override fun onTextChanged(s: CharSequence?, start: Int, before: Int, count: Int) {
               try {
//aqui se llena el spinner cuando el usuario escribe algo en un EditText codigoTxt 
                   initViewModel(codigoTxt.text.toString(),0)
               }
               catch(e: Exception){

               }
            }
        })
                       
      mySpinner = view.findViewById<Spinner>(R.id.mySpinner)
        
      if(mySpinner!=null) {            
        mySpinner.onItemSelectedListener = object : AdapterView.OnItemSelectedListener {
        var count:Int=0
        override fun onNothingSelected(parent: AdapterView<*>?) {
          TODO("not implemented") 
        }
        
         override fun onItemSelected(parent: AdapterView<*>?,view: View?,position: Int,id: Long) {
          if (count >= 1) {
            var optionSelected=options.get(position)
            initViewModel(codigoTxt.text.toString(), optionSelected)   
          }
          count++
         }
        }
      }

val repository= Repository()
        val viewModelFactory= MainViewModelFactory(repository)
        viewModel= ViewModelProvider(this,viewModelFactory).get(ViewModel::class.java)
      return view
    }  

  private fun initViewModel(codigo:String,cod_Campo:Int){
    if(codigo.length==5)
        {
            viewModel.makeApiCallCampos(cod_Prod, cod_Campo)
            viewModel.myresponsecampos.observe(this, Observer { response ->
                response.clone().enqueue(object : Callback<List<MyDataItem>?> {

                    override fun onFailure(call: Call<List<MyDataItem>?>, t: Throwable) {
                        Toast.makeText(activity, "Error: " + t.message, Toast.LENGTH_LONG).show()
                    }

                    override fun onResponse(call: Call<List<MyDataItem>?>,response: Response<List<MyDataItem>?>) {
                        val responseBody: List<MyDataItem>? = response.body()
                        if (responseBody != null)
                        {
                            if(codigo.length==5 && cod_Campo==0) {
                                options = mutableListOf<Int>()
                                for (x in responseBody) {
                                    nombreTxt.setText(x.nombre)
                                    options += x.cod_Campo
                                }

                                val adapter = ArrayAdapter(
                                    activity!!,
                                    android.R.layout.simple_spinner_item,
                                    options
                                )
                                mySpinner.adapter = adapter
                                optionSelected = adapter.getItem(0)!!
                            }

                            else{
                                for (x in responseBody)
                                {
                                    telefonoTxt.setText(x.telefono)
                                    localidadTxt.setText(x.ubicacion)
                                    tipoTxt.setText(x.tipo)
                                    productoTxt.setText(x.producto)
                                }
                            }
                        }
                    }
                })
            })
        }
        else {
            codigoTxt.setError("El código debe ser de 5 digitos, rellene con 0 al principio")
            codigoTxt.requestFocus()
        }
    }

ViewModel

class ViewModel (private val repository: Repository): ViewModel() {

val myresponsecampos:MutableLiveData<Call<List<MyDataItem>>> = MutableLiveData()

    fun makeApiCall(codigo: String, cod_Campo: Int) {
        viewModelScope.launch {
            val response= repository.getCampos(codigo, cod_Campo)
            myresponse.value=response
        }
    }

}
android
Martin Hope
Huntzberger
Asked: 2020-04-29 13:22:37 +0800 CST
  • 3

I have a web system (.NET MVC) for the company where I work, in which the user does some CRUD operations. Then I made an app in Android Studio which shows a recyclerview of the records that users create in the web system that I mentioned at the beginning, for this I also created a .NET MVC server. But what I need is that every time an insert is made (to the database) in the web system, a notification arrives in the mobile app.

I was reading about PUSHER, I registered and it gave me the following code:

Android client 

PusherOptions options = new PusherOptions();
        options.setCluster("xxx");
        Pusher pusher = new Pusher("xxx", options);

        pusher.connect(new ConnectionEventListener() {
            @Override
            public void onConnectionStateChange(ConnectionStateChange change) {
                System.out.println("Estado cambio de " + change.getPreviousState() + " a " + change.getCurrentState());
            }

            @Override
            public void onError(String message, String code, Exception e) {
                System.out.println("Error de conexión! " +
                        "\ncode: " + code +
                        "\nmessage: " + message +
                        "\nException: " + e
                );
            }
        }, ConnectionState.ALL);

        Channel channel = pusher.subscribe("my-channel");

        channel.bind("my-event", new SubscriptionEventListener() {
            @Override
            public void onEvent(PusherEvent event) {
                System.out.println("Received event with data: " + event.toString());
            }
        });

And for the .NET MVC server

     public class HelloWorldController : Controller
     {
            [HttpPost]
            public async Task<ActionResult> Notificaciones()
            {
                var options = new PusherOptions
                {
                    Cluster = "xxx",
                    Encrypted = true
                };

                var pusher = new Pusher(
                  "xxx",
                  "xxxx",
                  "xxxx",
                  options);

                var result = await pusher.TriggerAsync(
                  "my-channel",
                  "my-event",
                  new { message = "hello world" });

            return new HttpStatusCodeResult((int)HttpStatusCode.OK);
            }
        }

The truth is that I am very lost and I don't know how to use it, I read the documentation but they use it with firebase, but I have to use the bases that they have on a private server of my company. If anyone can guide me or tell me about some other way to do what I need. Thank you

android-studio
Martin Hope
Huntzberger
Asked: 2020-03-12 11:03:19 +0800 CST
  • 3

Hello, it happens that I am consuming an API from which they give me the URL to which I must add some parameters so that it returns a result.

This API returns a JSON which I must load into a table in Excel

I based on this page

This is my code that finally works but the strange thing is that it does not bring me the position and orientation data

Option Explicit

Sub TestTablas()
    Dim Tablas As QueryTable
    Dim url As String
    Dim id As Integer
    Dim startDate As String
    Dim endDate As String

    Dim req As Object
    Dim strjson As String
    Dim jp As Object
    Dim dict
    Dim subdict
    Dim subsubdict
    Dim i As Integer
    Dim roleJson As String
    Dim jpRoles As Object
    Dim items
    Dim itemsId
    Dim attr
    Dim itemattr
    
    id = Hoja10.Range("C2")
    startDate = Format(Hoja10.Range("C3"), "yyyy-mm-dd hh:mm:ss")
    endDate = Format(Hoja10.Range("C4"), "yyyy-mm-dd hh:mm:ss")
    url = "https://xxx.yyy.com/api/zzz?id=" & id& "&startDate=" & startDate & "&endDate=" & endDate & "&timezone=-6"
        
    Set req = CreateObject("MSXML2.XMLHTTP")
    req.Open "GET", url, False
    req.Send
    
    Set jp = JsonConverter.ParseJson(req.ResponseText)
    Set items = jp("items")
    
    roleJson = req.ResponseText
    Set jpRoles = JsonConverter.ParseJson(roleJson)
    Set items = jpRoles("items")
    
    i = 7
    For Each itemsId In items
        For Each attr In itemsId
           ' Debug.Print attr
            'Debug.Print itemsId(attr)
            
            Sheets("Informacion").Cells(i, 1).Value = itemsId("name")
            Sheets("Informacion").Cells(i, 2).Value = itemsId("Position")
            Sheets("Informacion").Cells(i, 3).Value = itemsId("positionDate")
            Sheets("Informacion").Cells(i, 4).Value = itemsId("latitude")
            Sheets("Informacion").Cells(i, 5).Value = itemsId("longitude")
            Sheets("Informacion").Cells(i, 6).Value = itemsId("Orientation")
            Sheets("Informacion").Cells(i, 7).Value = itemsId("speed")
            Sheets("Informacion").Cells(i, 8).Value = itemsId("receiptDate")
            Sheets("Informacion").Cells(i, 9).Value = itemsId("notification")
            Sheets("Informacion").Cells(i, 10).Value = itemsId("kilometers")
            Sheets("Informacion").Cells(i, 11).Value = itemsId("unitVoltage")
            Sheets("Informacion").Cells(i, 12).Value = itemsId("gpsVoltage")
            Sheets("Informacion").Cells(i, 13).Value = itemsId("satellites")
            
        Next attr
         i = i + 1
    Next itemsId
    
End Sub

enter image description here

JSON example

enter image description here

json
Martin Hope
Huntzberger
Asked: 2020-02-14 10:12:47 +0800 CST
  • 3

I have a table with the following structure, which is populated with json data that I get from my controller.

<div class="table-responsive table-condensed table-sm table-bordered tabla">
    <table class="table table-hover content-tabla" id="Datos" cellpadding="0" cellspacing="0">
        <thead>
            <tr class="table-success">
                <td>Código</td>
                <td>Nombre</td>
                <td>Pronosticado</td>
                <td></td>
                <td>Pronosticado Acumulado</td>
                <td>Entregado</td>
                <td>Diferencia</td>
                <td></td>
                <td>Pronosticado Actual</td>
                <td>Entregado</td>
                <td>Diferencia</td>
                <td>Activar</td>
            </tr>
        </thead>
        <tbody>
            <tr></tr>
        </tbody>
    </table>
</div>

Now what I need is to apply a background with jquery to the columns called Difference but according to the values ​​obtained.

This is just an example of what I want to achieve:

if(micolumna=='100%')
{
background-color=black;
color:red;
}

So I fill my table

<script src="~/js/Jquery/jquery-3.1.0.min.js"></script>
<script type="text/javascript">
    $(document).ready(function () {
        datos();       
    });     

  function datos() {
        $.getJSON("/MyController/Index", function (data) {
            $.each(data, function (idx, opt) {
                $('#Datos').append('<tr><td>' + opt.Codigo + '</td><td>' + opt.Nombre + '</td><td>' + opt.Pronostico + '</td><td>' + '' + '</td><td>' + opt.PronosticoAA + '</td><td>' + opt.Entregado + '</td><td>' + opt.DiferenciaAA + '</td><td>' + '' + '</td><td>' + opt.PronosticoSA + '</td><td>' + opt.EntregadoSA + '</td><td>' + opt.DiferenciaSA + '</td><td><input type="checkbox" name="cod_A" id="cod_A" value="A" /></td></tr>');
            });
        }, 'json');
    }       
</script>

html
Martin Hope
Huntzberger
Asked: 2020-01-23 09:37:09 +0800 CST
  • 2

I have the following code to download data from sql in an excel, the problem is that it downloads the empty excel, only with the headers, I already debugged it and the query if it brings me data. I have guided myself with this tutorial but I don't know what I have done wrong. I have declared this int rowStart = 42; because my query returns 42 rows

public void ExportToExcel()
{
  ExcelPackage excel = new ExcelPackage();
  ExcelWorksheet ws = excel.Workbook.Worksheets.Add("Report");

  ws.Cells["A1"].Value = "Titulo";
  ws.Cells["A2"].Value = "Id";
  ws.Cells["B2"].Value = "Nombre";
  ws.Cells["C2"].Value = "Edad";
           
  var data = bd.Database.SqlQuery<MyClass>("Select ...").ToList();

   int rowStart = 42;
   foreach (var item in data)
   {
   ws.Cells[string.Format("A{0}", rowStart)].Value = item.Id;
   ws.Cells[string.Format("B{0}", rowStart)].Value = item.Nombre;
   ws.Cells[string.Format("C{0}", rowStart)].Value = item.Edad;
   rowStart++;
   }

   ws.Cells["A:AZ"].AutoFitColumns();
   Response.Clear();
   Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
   Response.AddHeader("content-disposition", "attachment: filename=" + "ExcelReport.xlsx");
   Response.BinaryWrite(excel.GetAsByteArray());
   Response.End();
}

asp.net-mvc
Martin Hope
Huntzberger
Asked: 2020-01-16 14:35:43 +0800 CST
  • 2

I have the following code which makes a query to my database and displays the data in an html table:

public JsonResult DataJson()
{
   List<MyClass> data = bd.Database.SqlQuery<MyClass>("Select * from mytabla").ToList();
   return Json(data, JsonRequestBehavior.AllowGet);
}

MyClass

public class MyClass
    {
        public int Usuario  { get; set; }
        public DateTime Fecha { get; set; }
        public int Semanas { get; set; }
        public double Cantidad { get; set; }
        public string Concepto { get; set; }
        public int Semana { get; set; }
     }

And with ajax I receive them and show the results in my view:

<script type="text/javascript">
    $(document).ready(function () 
    {
    Fill_tabla();
    });
    
    function Fill_tabla() {
    $.getJSON("/MyController/DataJson", function (data)     {
     $.each(data, function (idx, opt) {
     $('#datatable').append('<tr><td>' + opt.column1 + '</td><td>' + opt.column2 + '</td></tr>');
            });
        }, 'json');
    }
</script>

Now the following code sends an array with the data from my HTML table to the controller to update them in the database so far so good, the problem is that it shows the error:

The model element passed to the dictionary is of type .JsonResult, but this dictionary requires an IEnumerable.

Am I supposed to convert the array to IEnumerable? or as?

I clarify that both functions (ajax and controller) are repeated for each row of my table.

 function GuardarF() {
        $.ajax({
            type: 'POST',
            dataType: "json",
            url: '/MyController/MyView',
            traditional: true,
            data: {
                  array: array
            },
            success: function (data) {
                if (data.rstProceso === "true") {
                    console.log('Exito: ' + data.rstMensaje);
                } else if (data.rstProceso === "false") {
                    console.log('Algo salió mal ' + data.rstMensaje);
                }
            },
            error: function (jqXHR, status, err){
            console.log(jqXHR.responseText);
            }
        });
    }

[HttpPost]
public ActionResult MyView(int[] array)
{
  JsonResult dtaEjecucionTarea = default(JsonResult);
       
        if (Update_MyView(array))
        {
            dtaEjecucionTarea = Json(new
            {
                rstProceso = "true",
                MessageGestion = "Cambios guardados con éxito"
            });
        }
        else
        { 
            dtaEjecucionTarea = Json(new
            {
                rstProceso = "false",
                MessageGestion = "Error, algo salió mal, intente de nuevo"
            });
        }
  return View(dtaEjecucionTarea);
}

public bool Update_MyView(int[] array)
{
   if (array != null)
   {
    //my code
    bd.SaveChanges();
    return true;
   }
   else
   {
    return false;
   }
}

My model

public partial class MyModel
    {
        public int Id { get; set; }
        public Nullable<int> Usuario { get; set; }
        public Nullable<System.DateTime> Fecha { get; set; }
        public Nullable<int> Semanas { get; set; }
        public Nullable<double> Cantidad { get; set; }
        public string Concepto { get; set; }
        public Nullable<int> Semana { get; set; }
    }

Console error message:

enter image description here

ajax
Martin Hope
Huntzberger
Asked: 2020-01-12 11:55:43 +0800 CST
  • 2

I have the following code which sends an array with the data of my HTML table to the controller to update them in the database so far so good, the problem is that it shows the error: Error: No resource with given URL found, 500 (Internal Server Error) asp.net mvc

I clarify that both functions (ajax and controller) are repeated for each row of my table.

        function GuardarF() {
        $.ajax({
            type: 'POST',
            dataType: "json",
            url: '/MyController/MyView',
            traditional: true,
            data: {
                  array: array
            },
            success: function (data) {
                if (data.rstProceso === "true") {
                    console.log('Exito: ' + data.rstMensaje);
                } else if (data.rstProceso === "false") {
                    console.log('Algo salió mal ' + data.rstMensaje);
                }
            },
            error: function (jqXHR, status, err){
            console.log(jqXHR.responseText);
            }
        });
    }

MyController 

[HttpPost]
public ActionResult MyView(int[] array)
{
  JsonResult dtaEjecucionTarea = default(JsonResult);
        dtaEjecucionTarea = Json(new
        {
            rstProceso = "false",
            MessageGestion = "Error, algo salió mal, intente de nuevo"
        });

        if (Update_MyView(array))
        {
            dtaEjecucionTarea = Json(new
            {
                rstProceso = "true",
                MessageGestion = "Cambios guardados con éxito"
            });
        }
  return View(dtaEjecucionTarea);
}

public bool Update_MyView(int[] array)
{
   if (array != null)
   {
    //my code
    bd.SaveChanges();
    return true;
   }
   else
   {
    return false;
   }
}

ajax
Martin Hope
Huntzberger
Asked: 2020-12-31 15:11:06 +0800 CST
  • 3

I am new asn ASP.NET MVC 5 and I am trying to move a project from ASP.NET C# to MVC, but in my old project I have very long queries involving up to 5 tables with operations.

This is the query I need:

enter image description here

Model. This is my main table 

namespace Sistema.Models
{
    using System;
    using System.Collections.Generic;

    public partial class Visitas
    {
        public int Id { get; set; }
        public short IdUser { get; set; }
        public string Codigo { get; set; }
        public short Campo { get; set; }
        public System.DateTime Fecha { get; set; }
        public string Estatus { get; set; }
        public string Comentarios { get; set; }
    }
}

Context class. The other tables are the ones I need in my query.

namespace Sistema.Models
{
    using System;
    using System.Data.Entity;
    using System.Data.Entity.Infrastructure;
    
    public partial class MyBd : DbContext
    {
        public MyBd()
            : base("name=MyBd")
        {
        }
    
        protected override void OnModelCreating(DbModelBuilder modelBuilder)
        {
            throw new UnintentionalCodeFirstException();
        }
    
        public virtual DbSet<Semanas> Semanas { get; set; }
        public virtual DbSet<Usuarios> Usuarios { get; set; }
        public virtual DbSet<Campos> Campos { get; set; }
        public virtual DbSet<Visitas> Visitas { get; set; }
    }
}

What I try now is to use Json and Ajax

public JsonResult VisitasList()
{
var visitas = bd.Visitas.SqlQuery("select * from . . . .");
return Json(visitas, JsonRequestBehavior.AllowGet);
}

and with ajax

<script src="~/js/Jquery/jquery-3.1.0.min.js"></script>
<script type="text/javascript">
    $(document).ready(function () {
        $.getJSON("/Visitas/VisitasList", function (data) {
            console.log('Obtuve los datos');
            $.each(data, function (idx, opt) {
                $('#dataTableVisitas').append('<tr><td>' + opt.colum1 + '</td><td>' + opt.colum2 + '</td><td>' + opt.colum3 + '</td></tr>' + opt.colum4 + '</td></tr>');                
            });
        }, 'json');
    });
</script>

But it throws me the following error

The data reader is incompatible with the specified 'myContext.Visitas'. A member of the type, 'IdVisita', does not have a corresponding column in the data reader with the same name.

c#
Martin Hope
Huntzberger
Asked: 2020-12-05 11:36:04 +0800 CST
  • 4

I have the following query, which compares data from one table to another. Now it turns out that query A may not return records, so in the WHERE V.Week between A.Week and S.Week if A.Week does not contain anything, I need to put the number 27. Any ideas? Thanks greetings

IdUser  Codigo  Cantidad
112 02158   225
112 02422   25
112 03173   80
112 03353   550
112 03739   701

The following is my code:

    select V.IdUser, V.Codigo, sum(V.Cantidad) as Cantidad

    FROM (select max(S.Semana) as Semana, V.IdUser, V.Codigo from SVisitas V

    left join Calendario S ON V.Fecha between S.Inicio and S.Fin 

    group by V.IdUser, V.Codigo)A 

    left join (select * from(select IdUser,Codigo,Temporada,SUM(Cantidad) 
as Cantidad,Semana from SCantidadesP group by IdUser,Codigo,Temporada,Cantidad,Semana)V
 where V.Cantidad <> 0)V on A.IdUser=V.IdUser and A.Codigo=V.Codigo 

    left join (Select * from Calendario where Getdate() between Inicio and
 Fin)S on V.Temporada=S.Temporada WHERE V.Semana between A.Semana and 
S.Semana 
    group by V.IdUser,V.Codigo

these are my boards

SVisitas 
IdUser int
Codigo varchar(5)
Fecha datetime

Calendario 
Semana int
Inicio datetime
Fin datetime
Temporada int

SCantidadesP
IdUser int
Codigo varchar(5)
Cantidad int
Semana int
Temporada int

Here I leave an example of the data that my tables store, what I need is to see all the records of my SCantidadesP table even if the codes are not in the SVisitas table

SVisitas 
IdUser Codigo   Fecha
112    02158    2019-11-12
112   02422    2019-12-03

Calendario 
Temporada Semana    Inicio       Fin
1920          45    2019-11-04   2019-11-10  
1920          46    2019-11-11   2019-11-17  
1920          47    2019-11-18   2019-11-24  
1920          48    2019-11-25   2019-12-01  
1920          49    2019-12-02   2019-12-08  
1920          50    2019-12-09   2019-12-15  
1920          51    2019-12-16   2019-12-22  
1920          52    2019-12-23   2019-12-29  

SCantidadesP
IdUser Codigo Cantidad Semana Temporada 
112    02158   234       50    1920
112    02458   1000      45    1920
112    02565   654       45    1920
112    02157   287       51    1920
112    02159   098       49    1920
sql-server
Martin Hope
Huntzberger
Asked: 2020-09-11 08:43:54 +0800 CST
  • 2

I have an HTML table in ASP.NET MVC that displays the data from the Model MyModel in an HTML table. Now what I need is for the Codigo_User and Codigo_Campo columns (which store codes) to show me the description of those codes, which are in other tables MyTablaCampos and MyTablaUsers Here I leave the definition of my models: MyModel 

        public partial class MyModel
        {
            public int Id { get; set; }
            public string Codigo_User { get; set; }
            [DisplayFormat(DataFormatString = "{0:dd/MM/yyyy}", ApplyFormatInEditMode = true)]
            public Nullable<System.DateTime> Fecha_solicitud { get; set; }
            public Nullable<int> Codigo_Campo { get; set; }
            public string Ubicacion { get; set; }       
            public MyTablaCampos Campos { get; set; }
            public MyTablaUsers Users { get; set; }
        }

    namespace MyProyect.Models
    {
        using System;
        using System.Collections.Generic;
        
        public partial class MyTablaUsers 
        {
            public string Codigo_User { get; set; }
            public string Nombre { get; set; }
            public string Contacto { get; set; }
            public string RFC { get; set; }
        }
    }      

    namespace MyProyect.Models
    {
        using System;
        using System.Collections.Generic;
        
        public partial class MyTablaCampos 
        {
            public short Cod_Empresa { get; set; }
            public string Codigo_User { get; set; }
            public short Codigo_Campo { get; set; }
            public string Descripcion { get; set; }
            public short Tipo { get; set; }
            public short Producto { get; set; }
          }
    }

This is the structure of my HTML table, in the columns where I want the names to appear, nothing comes out, so I don't know if there is another solution. Thanks.

@model IEnumerable<Inocuidad.Models.MyModel>

<div class="col-sm-12 table-responsive table-condensed table-sm" style="font-size:small">
<table class="table table-hover" id="dataTableCreditos">
  @if (Model != null)
  {
  <thead class="thead-light">
  <tr>
  <th>Codigo_User</th>
  <th>Usuario</th>
  <th>Codigo_Campo</th>
  <th>Campo</th>
  <th>Fecha de solicitud</th>
  <th>Ubicacion</th>
  </tr>
  </thead>
  <tbody>
  @foreach (var item in Model)
  {
  <tr>
  <td>
  @Html.DisplayFor(modelItem => item.Codigo_User, new { id = "Codigo_User" })
  </td>
  <td>
  @Html.DisplayFor(modelItem => item.Users.Nombre)
  </td>
  <td>
  @Html.DisplayFor(modelItem => item.Codigo_Campo, new { id = "Codigo_Campo" })
  </td>
  <td>
  @Html.DisplayFor(modelItem => item.Campos.Descripcion)
  </td>
  <td>
  @Html.ValueFor(modelItem => item.Fecha_solicitud)
  </td>
  <td>
  @Html.DisplayFor(modelItem => item.Ubicacion)
  </td>
 </tr>
}
</tbody>
}
</table>
</div>

public ActionResult SetSolicitud()
{
 var item = from s in bd.MyModel select s;
 return View(item.ToList());
}

Expected result

enter image description here

c#
Martin Hope
Huntzberger
Asked: 2020-08-10 11:14:20 +0800 CST
  • 2

I have a query in which I fill a List with the values ​​of a column called Quantity, assuming that the values ​​of the list are the following:

Position= P value= v

p    v
[0] 41
[1] 42
[2] 43
[3] 44
[4] 45
[5] 46
[6] 47
[7] 9
[8] 10
[9] 11
[10] 12

And I have a variable value="45", and we see that in the list there is a value "45" and that its index is [4], so what I want now is to show the values ​​of the list starting at position 4. Here my code:

     string sql = "select * from MyTabla";
     SqlCommand cm = new SqlCommand(sql, con);
     SqlDataReader reader = cm.ExecuteReader();
     while (reader.Read())
       {
   array.Add(Convert.ToString(reader["Cantidad"]));
       }
       string valor= "45";
       if (array.Contains(valor))
       {
       int indice = array.IndexOf(valor);
       }
       foreach (string item in array)
       {
       //imprimir los valores del array apartir del valor de la variable indice
       }

c#
Martin Hope
Huntzberger
Asked: 2020-08-08 09:32:38 +0800 CST
  • 2

I have a query in SQL Server in which I need it to show me only the COLUMNS that do not have 0

SELECT Codigo, Campo, Sector, SUM(Isnull([1],0)) AS [1], SUM(Isnull([2],0)) AS [2], SUM(Isnull([3],0)) AS [3], SUM(Isnull([4],0)) AS [4], SUM(Isnull([5],0)) AS [5], SUM(Isnull([6],0)) AS [6], SUM(Isnull([7],0)) AS [7], SUM(Isnull([8],0)) AS [8], SUM(Isnull([9],0)) AS [9], SUM(Isnull([10],0)) AS [10], SUM(Isnull([11],0)) AS [11]
FROM MyTabla 
WHERE V.Codigo=00173 and V.Campo=1 and V.Sector=2 
GROUP BY Codigo, Campo, Sector, [1], [2], [3], [4], [5], [6], [7], [8], [9], [10], [11]

which gives me the following result

  Codigo    Campo   Sector  1   2   3   4   5   6   7   8   9   10  11      
  00173    1      2     0   0   0   0   0   0   0   27  64  15  17

The problem is that if I add (for example) to the where [1]<>0...etc, it doesn't show me any results from the row anymore.

But what I need is this:

 Codigo Campo   Sector  8     9   10    11      
 00173      1      2    27    64      15    17

mytable

Id int (pk)
Codigo varchar
Campo int 
Sector int
1 float
2 float
3 float
4 float
5 float
6 float
7 float
8 float
9 float
10 float
11 float
sql
Martin Hope
Huntzberger
Asked: 2020-08-01 09:27:47 +0800 CST
  • 3
Codigo varchar
Cantidad float
Cantidad2 float
Cantidad3 float

I have a table in SQL Server which gives me the following result

Codigo Cantidad Cantidad2 Cantidad3
00428     0         0       32

Now I need to add 1 to the float columns but that they are different from 0, this is my query but even if they have a value of 0 if they add the number

update SIPGProyeccion set Cantidad=(Cantidad+1),Cantidad= 
                          (Cantidad2+1),Cantidad3=(Cantidad3+1)
where Codigo= '00428' 
and Cantidad<>0 
and Cantidad2 <>0 
and Cantidad3<>0
sql-server
Martin Hope
Huntzberger
Asked: 2020-07-20 11:12:29 +0800 CST
  • 6

I have the following Gridview, in which the user can edit the columns, but when editing the table the columns change their size, my question is how to avoid that. Thank you

enter image description here

enter image description here

<Columns>
<asp:TemplateField HeaderText="27" SortExpression="27">
<EditItemTemplate>
<asp:TextBox ID="L27" runat="server" Text='<%# Eval("27") %>'></asp:TextBox>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="Label27" runat="server" Text='<%# Bind("27") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>

<asp:TemplateField HeaderText="28" SortExpression="28">
<EditItemTemplate>
<asp:TextBox ID="L28" runat="server" Text='<%# Eval("28") %>'></asp:TextBox>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="Label28" runat="server" Text='<%# Bind("28") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
...etc
</Columns>

asp.net
Martin Hope
Huntzberger
Asked: 2020-07-06 11:07:48 +0800 CST
  • 4

I have a form in an ASP.NET MVC project, in which when writing a code in an input and at the time of writing it, it should look for that code in a database table and fill a dropdownlist, but the dropdownlist does not fill Here my code:

 //Lista de campos
public JsonResult GetCamposList(string Codigo)
{
bd.Configuration.ProxyCreationEnabled = false;
List<TblCampos> ListCampos = bd.TblCampos.Where(x => x.Codigo == Codigo).ToList();
return Json(ListCampos, JsonRequestBehavior.AllowGet);
}

<script type="text/javascript">
 $(document).ready(function () {
 $("#Codigo").change(function () {
 $.get("Solicitud/GetCamposList", { Codigo: $("#Codigo").val() }, function (data) {
 $("#Codigo").empty();
 $.each(data, function (index, row) {
 $("#Codigo").append("<option value='" + row.Cod_Campo + "'>'"+row.Descripcion+"'</option>")
 });
 });
 });
 });
</script>

<div class="form-group">
<div class="m-0 font-weight-bold text-primary subtitulo">Codigo:</div>
<input type="text" class="form-control" id="Codigo" name="Codigo" maxlength="5" minlength="5" required="">           @Html.ValidationMessageFor(model => model.Codigo, "", new { @class = "text-danger" })
</div>

<div class="form-group">
<div class="m-0 font-weight-bold text-primary subtitulo">Campo:</div>
<div class="col-md-5">
@Html.DropDownListFor(model => model.Cod_Campo, new SelectList(" "), "--Seleccione un campo--",new { @class="form-control"})
</div>
</div>

Model 

 public partial class ProdMuestreo
 {
 public int Id { get; set; }
 public string Codigo { get; set; }
 public Nullable<int> Cod_Campo { get; set; }
 public string Ubicacion { get; set; }
 public string Telefono { get; set; }
 public List<TblCampos> Campos { get; set; }
 }

//ListCampos
public partial class TblCampos
{
public short Cod_Empresa { get; set; }
public string Codigo { get; set; }
public short Cod_Campo { get; set; }
public string Descripcion { get; set; }
}

data example 

Tabla ProdMuestreo 
 Id 0
 Codigo 00050
 Cod_Campo 1
 Ubicacion Mexico
 Telefono 55555555

Tabla Campos
Cod_Empresa 1
Codigo 00050
Cod_Campo 1
Descripcion Los Girasoles

asp.net-mvc-5
Martin Hope
Huntzberger
Asked: 2020-04-25 09:09:15 +0800 CST
  • 4

I have a datetimepicker but it comes out by default in English, I want to know if there is a way to change it to Spanish.

jQuery(function($) {
  $.datetimepicker.regional['es'] = {
    closeText: 'Cerrar',
    prevText: '&#x3c;Ant',
    nextText: 'Sig&#x3e;',
    currentText: 'Hoy',
    monthNames: ['Enero', 'Febrero', 'Marzo', 'Abril', 'Mayo', 'Junio',
      'Julio', 'Agosto', 'Septiembre', 'Octubre', 'Noviembre', 'Diciembre'
    ],
    monthNamesShort: ['Ene', 'Feb', 'Mar', 'Abr', 'May', 'Jun',
      'Jul', 'Ago', 'Sep', 'Oct', 'Nov', 'Dic'
    ],
    dayNames: ['Domingo', 'Lunes', 'Martes', 'Mi&eacute;rcoles', 'Jueves', 'Viernes', 'S&aacute;bado'],
    dayNamesShort: ['Dom', 'Lun', 'Mar', 'Mi&eacute;', 'Juv', 'Vie', 'S&aacute;b'],
    dayNamesMin: ['Do', 'Lu', 'Ma', 'Mi', 'Ju', 'Vi', 'S&aacute;'],
    weekHeader: 'Sm',
    firstDay: 1,
    isRTL: false,
    showMonthAfterYear: false,
    yearSuffix: ''
  };
  $.datetimepicker.setDefaults($.datetimepicker.regional['es']);
});

$(document).ready(function() {
  $(".fecha").datetimepicker({
    format: 'Y-MM-D',
  });
});
<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.1.0/jquery.min.js"></script>
<script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/bootstrap-datepicker/1.6.4/js/bootstrap-datepicker.min.js"></script>
<script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/bootstrap-datepicker/1.6.4/locales/bootstrap-datepicker.es.min.js" charset="UTF-8"></script>
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/bootstrap-datepicker/1.6.4/css/bootstrap-datepicker3.css" />
<link rel="stylesheet" href="https://netdna.bootstrapcdn.com/bootstrap/3.0.3/css/bootstrap.min.css" />
<input class="form-control" id="fecha" name="fecha" placeholder="fecha -- " type="text" />

enter image description here

This error appears in the console:

jQuery.Deferred exception: Cannot read property 'regional' of undefined TypeError: Cannot read property 'regional' of undefined

javascript
Martin Hope
Huntzberger
Asked: 2020-01-11 11:17:49 +0800 CST
  • 3

I have two databases and in each one two tables from which I need to add a field, but unified.

I did the following querybut it separates the results of each table and I need both:

Select sum(Cantidades) as Entregado 
From BD1..Facturas

Where Codigo ='00050'

Union All

Select sum(Cantidades) as Entregado 
From BD2..FacturasA

Where Codigo ='00050'

Result

Delivered

  • 5773
  • 90

Expected result

Delivered: 5863

sql-server
Martin Hope
Huntzberger
Asked: 2020-01-08 07:24:18 +0800 CST
  • 3

I have these queries but they give me the data in English and I need it in Spanish, is there any way to do that? Thank you

declare @Fecha date
SET @Fecha = GetDate() 
go

DATENAME(day, @Fecha) as Dia, 
DATENAME(weekday,@Fecha) as DiaSemana,  
DATENAME(month, @Fecha) as Mes, 
DATENAME(YEAR, @Fecha) as Año,

Dia DiaSemana  Mes     Año
7   Monday    January  2019

And I need the day and month to be in Spanish

sql-server