I was looking at code in the dark places of the internet when I came across the following way to use blocks on a switch.

input = -1;
switch(input){
  case 1: case -1:
    console.log("1 o -1");
    break;
   default:
    console.log("Default")
    break;
}

I've never seen this way of using a caseand it occurred to me that replacing the two cases with an operator ORof the following form might work.

input = -1;
switch(input){
  case 1 || -1:
    console.log("1 o -1");
    break;
   default:
    console.log("Default")
    break;
}

I understand that if the input is 1or -1, it should return true and enter the first block, but if it is -1, it jumps to the default block.

Why is this behavior and why is it not correct?

How can I assign a variable without referencing it in typescript?

let miObjeto:Object = res; //Respuesta de función de API que me devuelve un objeto cualquiera.
miObjeto.cantidad = 2;
let auxObjeto:Object = miObjeto;
miObjeto.cantidad = 5;
console.log(auxObjeto.cantidad) // Devuelve 5 referenciando el cambio de miObjeto en vez de 2.

I'm trying to omit an attribute with ngIf, or something similar in Angular:

<input type="text" maxlength="5" class="form-control-mat"
    *ngIf="recomendacion!=undefined" [placeholder]="recomendacion" >

This is what I have right now, but instead of omitting the attribute placeholder, it skips the entire element.

Is it possible to apply something similar that works on attributes?

I'm just starting to use git to save my projects to the cloud and wanted to know how I can do a pull after I've made some changes I didn't want to make.

I was modifying a file and I messed it up, I wanted to get the old version from github but when I do git pullit it tells me alredy up to date , if I do git statusit tells me your branch is ahead of master by 1 commit .

How can I get the files from the remote repository even if they are old?

I am trying to convert a string from String to DateTime but it gives me the following error:

System.FormatException: 'The string represents a DateTime not supported in the System.Globalization.GregorianCalendar calendar.'

This is what I'm trying

List<DateTime> fechas = new List<DateTime>();
fechas.Add(DateTime.ParseExact(strings[i], "yyyyMMddmmHHss", CultureInfo.InvariantCulture)); 

The type of value I pass to it is something like this: "20190601083158".

I have raised this issue a few times on the site chat but I feel there is a lot of diversity of opinion and it seemed appropriate to post a question on the site.

Starting from the base of the four pillars of OOP

• Abstraction
• encapsulation
• Inheritance
• Polymorphism

I believe that what is called OOP in C# does not have attribute encapsulation.

Encapsulating an attribute, from what I've studied, means leaving the attributes in question as private.

This leads me to think that something that is not is usually called object-oriented programming.

From what I've always seen, to define a class attribute in c# is done as

public int number { get; set; };

By doing this you are ignoring one of the fundamental pillars of OOP, which is variable encapsulation.

Wouldn't it be more correct to call it property-oriented programming, or something like that? Since the attributes are not privatized and they are accessible from any class, even if they are modifiable or not.

I'm trying to make a script that changes the background color of messages that include certain words ,

var palabras = ["Test1","Test2","Test3"];
var mirador = new MutationObserver(async (records, _) => {
    Tratar();
})
mirador.observe($('#content')[0], { childList: true, subtree: true });
function Tratar(){
    var content =  $(this).parent();

for(var i=0;i<palabras.length;i++){
    if(content.indexOf(palabras[i])>=0){
        content.backgroundColor("#4287f5");
    }
}
}

The idea is to apply this to the StackExchange chat, I'm using this room to test it, but it gives me that I'm doing something wrong when doing the.Observe()

Uncaught TypeError: Failed to execute 'observe' on 'MutationObserver': parameter 1 is not of type 'Node'. at :7:9

I don't have much idea of ​​web development and I was using this script as a base that allows you to hide pics from stackexchange chat: https://stackapps.com/questions/8211/minimize-pics-in-chat

I am trying to update a LinearLayout from a class outside the activity and doing so gives me the following:exception

Android.Util.AndroidRuntimeException:"Only the original thread that created a view hierarchy can touch its views."

This is what I have:

The first thing I do is launch a thread that every few seconds will check that I have a connection to the server.

protected override void OnCreate(Bundle savedInstanceState)
{
    base.OnCreate(savedInstanceState);
    SetContentView(Resource.Layout.activity_main);
    this.RequestedOrientation = Android.Content.PM.ScreenOrientation.Portrait;
    context = this;

    Task.Run( () => ComprobarConexion());
}

This is the method I use:

protected static void ComprobarEstado()
{
    while(true){
        TestearConexion();
        Thread.Sleep(segundos * 1000);
    }
}

And here I check that the connection is working:

public static void TestearConexion()
{
     try{ 

         WebService.Test();

     }catch(Exception ex){ //En la realidad tengo completadas distintas excepciones.

          LayoutInflater lDesconexion = (LayoutInflater)MainActivity.context.GetSystemService(Context.LayoutInflaterService);
          View vDesconexion = lDesconexion.Inflate(Resource.Layout.layout_disconected, null, false);
          MainActivity.contenidoPrincipal.RemoveAllViews();
          MainActivity.contenidoPrincipal.AddView(vDesconexion);

     }
}

The exception I get when trying to modify MainActivity.contenidoPrincipal.

How can I show the connection failure?

I'm trying to decode a stream to bitmap so I can pass it through an imageview to play a stream.

Alternative 1:

I have based it on this StackOverflow question: How to load an ImageView by URL in Android? [closed] taking what I thought I needed, but when I run the App by calling I ca Funcion()n't show the image.

What am I doing wrong? I have taken the equivalent functions of javapara xamarin, the objects and others coincide so, I don't understand if my code or the stream is wrong or...

In my case I have tried to use several retransmissions taken from different places. Youtube, twitch, some television that broadcasts live or a local IP where I see stream through http.

private void Funcion()
{
   ImageView image = FindViewById<ImageView>(Resource.Id.vView);
   Bitmap stream = Task.Run(() => doInBackground()).Result;
   image.SetImageBitmap(stream);

}

protected Bitmap doInBackground()
{
    Bitmap stream;
    stream = BitmapFactory.DecodeStream(new Java.Net.URL("URL").OpenStream());

    return stream;
}

This is the view I use

<RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android"
    xmlns:app="http://schemas.android.com/apk/res-auto"
    xmlns:tools="http://schemas.android.com/tools"
    android:layout_width="match_parent"
    android:layout_height="match_parent"
    android:background="#000000"
    tools:showIn="@layout/activity_main">

    <ImageView
        android:layout_width="500dp"
        android:layout_height="500dp"
        android:background="#ffffff"
        android:id="@+id/vView" />
</RelativeLayout>

He OnCreate()only has the basics:

protected override void OnCreate(Bundle savedInstanceState)
{
    base.OnCreate(savedInstanceState);

    SetContentView(Resource.Layout.activity_main);

    Funcion();

}

The code has no more.

Alternative 2

Use VideoView:

VideoView video = FindViewById<VideoView>(Resource.Id.vView);


video.SetVideoURI(Android.Net.Uri.Parse("http://ip:puerto/"));
video.RequestFocus();
video.Prepared += delegate
{
   video.Start();
};

This option seems the simplest to me, but when I start I get a dialog in which it tells me: ** The video cannot be played.** And that's the end of it.

http

If I enter from the browser with http://ip:port/ and inspect the element, what I see is this:

<Body>
    <img style="-webkit-user-select: none;" src="http://ip:puerto/">
</Body> 

I am trying to align 3 elements; one ImageViewand two TextView, using for it WeightSum.

I assign WeightSum = 20and give the elements 1, 17 and 2 respectively. But instead of leaving me the full line, it seems to be putting me Weight = 1in each of the elements. This being the result.

The orange/black elements should occupy the entire width of the lines, and stay halfway.

Code

for(int i=0;i<data.Count; i++)
{
    //Líneas principales
    LinearLayout.LayoutParams lp;
    lp = new LinearLayout.LayoutParams(LinearLayout.LayoutParams.MatchParent, 125);
    oLinea = new LinearLayout(this);
    //oLinea.Orientation = Orientation.Horizontal;
    oLinea.LayoutParameters = lp;
    oLinea.WeightSum =20;

    //Reinstancio los parametros, 0 para que tenga en cuenta el peso y 125 para la altura
    lp = new LinearLayout.LayoutParams(0, 125);

    //ImageView
    ImageView iEstado = new ImageView(this);;
    lp.Weight = 1;
    iEstado.LayoutParameters = lp; 
    iEstado.SetScaleType(ImageView.ScaleType.FitCenter);

    //TextView1
    TextView tDescripcionGrupo = new TextView(this);
    tDescripcionGrupo.Text = data[i].toString();//Esto es irrelevante
    lp.Weight = 17;
    tDescripcionGrupo.LayoutParameters = lp;

    //TextView2
    TextView tEstado = new TextView(this);
    tEstado.Text = ""; //El String también es irrelevante.
    lp.Weight = 2;
    tEstado.LayoutParameters = lp; 

    //se añaden las listas a la línea
    oLinea.AddView(iEstado);
    oLinea.AddView(tDescripcionGrupo);
    oLinea.AddView(tEstado);

    //Se añaden las líneas a la layout activa.
    activeLayout.AddView(oLinea);      
}

I imagine that I have something wrong with the weights, or with some line parameter, but I've been trying for a long time and I still don't fully understand what needs to be done to make it Weightwork correctly.

I've been developing in , for a little over a month Xamarin, and despite having studied Android, until now I haven't had the opportunity, or rather, the need to use LayoutInflater.

I recently had a problem using, or abusing this feature. Solved in this question: Textview is not added to my layout , the problem came from using the LayoutInflater when it shouldn't.

I have read the documentation and it says that it instantiates an xml layout to its viewcorresponding . Which leads me to think that when I "inflate" a layout I am creating an empty layout from that XML.

In this article they compare a Layoutinflaterwith a beach inflator, I understand the metaphor that inside it goes XMLlike gas and the beach ball would be the variable type vista/ Viewwhere that is loadedXML

This is so? I know it may seem simple, but there is something that squeaks me in all this.

What advantages can it have? When can it be more convenient for me to use Layoutinflatera variable to assign a FindViewById()and pass the layout directly?

Diagram: On the left are the logical steps I follow, on the right the two layouts.

Well, this is the part of the relevant code that I have in myActivityMain

bButton.Click += delegate{
    
    
    LinearLayout layout = FindViewById<LinearLayout>(Resource.Id.layout2);//En esta línea layout queda a "null"
    contenidoPrincipal.RemoveAllViews(); //Contenido principal es la ScrollView
    contenidoPrincipal.AddView(layout); //Aquí me tira Java.Lang.IllegalArgumentException

}

It has occurred to me that it could be because it MainActivityis loaded ActivityMain.axmlas a view , if so, **How ​​could I load it LinearLayoutin the ScrollView?

I have already verified that all the Id's that I call exist.

Objective:

Go changing the content of the App without changing the Toolbaror the buttons that allow you to switch between the different views.

I also leave here the actual layout that I use, hoping that you can understand what I am trying to do.

I also leave here both the StackTrace that gives me the exception and the Message.

StackTrace:

at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw () [0x0000c] in <f32579baafc1404fa37ba3ec1abdc0bd>:0 
at Java.Interop.JniEnvironment+InstanceMethods.CallVoidMethod (Java.Interop.JniObjectReference instance, Java.Interop.JniMethodInfo method, Java.Interop.JniArgumentValue* args) [0x00069] in <09bf3e262b934ffab2ba01f9fc7fd54d>:0 
at Java.Interop.JniPeerMembers+JniInstanceMethods.InvokeVirtualVoidMethod (System.String encodedMember, Java.Interop.IJavaPeerable self, Java.Interop.JniArgumentValue* parameters) [0x0002a] in <09bf3e262b934ffab2ba01f9fc7fd54d>:0 
at Android.Views.ViewGroup.AddView (Android.Views.View child) [0x00031] in <25661073a35344a89f215a4cf81af37c>:0 
at NombreApp.MainActivity.<OnCreate>b__11_0 (System.Object <p0>, System.EventArgs <p1>) [0x0001a] in C:\\Proyectos\\DirectorioApp\\NombreApp\\MainActivity.cs:71  --- End of managed Java.Lang.IllegalArgumentException stack trace ---
java.lang.IllegalArgumentException: Cannot add a null child view to a ViewGroup android.view.ViewGroup.addView(ViewGroup.java:4191)
android.view.ViewGroup.addView(ViewGroup.java:4173)
mono.android.view.View_OnClickListenerImplementor.n_onClick(Native Method)
 mono.android.view.View_OnClickListenerImplementor.onClick(View_OnClickListenerImplementor.java:30)\n\tat android.view.View.performClick(View.java:5647)\n\tat android.view.View$PerformClick.run(View.java:22465)
android.os.Handler.handleCallback(Handler.java:754)
android.os.Handler.dispatchMessage(Handler.java:95)
android.os.Looper.loop(Looper.java:163)
android.app.ActivityThread.main(ActivityThread.java:6378)
java.lang.reflect.Method.invoke(Native Method)
com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:901)
com.android.internal.os.ZygoteInit.main(ZygoteInit.java:791)

Message:

Cannot add a null child view to a ViewGroup

How can I pass a type argument IntPtrto a VideoViewin Xamarin?

I obtain a stream from a video recorder using some of the manufacturer's own libraries (Which do not have much documentation) and I cannot implement the stream to one VideoViewas I say.

I'm really not sure how I did it so I'm going to leave the code that works for me in C# in a project Windows Formsthat does work for me, and in turn put the part of what I'm trying to do in Xamarin.

C# functional code Windows Forms:

//Por aquí arriba hay configuración de direcciones ip y credenciales para el objeto. 
var info = new CHCNetSDK.LPNET_DVR_PREVIEWINFO();
info.hPlayWnd = VideoBox.Handle; //Declaro por donde se va a reproducir el Stream
CHCNetSDK.NET_DVR_RealPlay_V40(idConexion,ref info, null, User); //Inicia el Stream

VideoBoxit is(PictureBox)

Code NOT functional in Xamarin:

Attempt 1 using MediaController:

var mediaController = new MediaController();
info.hPlayWnd = mediaController.Handle;
videoView.setMediaController(mediaController);
CHCNetSDK.NET_DVR_RealPlay_V40(idConexion,ref info, null, User);
videoView.Start();

I try 2 removing MediaControlleronly withVideoView

info.hPlayWnd = videoView.Handle; 
videoView.Start();

I try 3 using ImageViewas ifPictureBox

info.hPlayWnd = imageView.Handle;
CHCNetSDK.NET_DVR_RealPlay_V40(idConexion,ref info, null, User);

As I say, it has never worked for me. It does not return any kind of exception, VideoViewit just stays black. I can ensure that the resource to which I try to connect works 100%.

Any ideas to port the code from Windows Formsto Androidor some alternative?

How can I subtract two dates in C#?

I have two variables DateTimeand I need to get the difference between them in hours.

DateTime fecharegistro = {04/05/2018 8:34:01} //obtenemos este valor de una base de datos
DateTime fechafin = DateTime.Now.Substract(fechaRegistro);

When compiling the above code I get an error saying that an object cannot be implicitly converted TimeStampto System.DateTime, when the variable is DateTime.

Let's say I have a two-dimensional array like this. This represents an excel template or whatever you want it to be.

The intention of the data table is that it resembles the excel template where I have to insert the data.

The main problem is to find the place in the two-dimensional array where I have to insert each data.

I have written the program in C# for ease, but I need a pseudocode , an algorithm to do it, an example in some other similar language...
Although the ideal would be the pseudocode or algorithm so that anyone could adapt it to X language in case that it was necessary.

(EDIT) This array represents an excel that I have to fill, obtaining SQL values.

+—————————————+———————————+
|             |   STOCK   |
+—————————————+———————————+
|  Adidas     |           |
+—————————————+———————————+
| Camisetas   |    52     |  <---- los datos de STOCK se obtienen de SQL 
+—————————————+———————————+
| Pantalones  |    37     |  <---- Lo normal es que vengan vacíos.
+—————————————+———————————+
| Zapatillas  |    15     |
+—————————————+———————————+
|   Puma      |           |
+—————————————+———————————+
| Camisetas   |    55     |
+—————————————+———————————+
| Pantalones  |    73     |
+—————————————+———————————+
|Ropa interior|    21     |
+—————————————+———————————+
|    Nike     |           |
+—————————————+———————————+
|  Zapatillas |    23     |
+—————————————+———————————+

I do a query to SQL that returns a result type

+—————————+————————————+———————+
|  Marca  |  Producto  | STOCK |
+—————————+————————————+———————+
| Adidas  |  Camiseta  |  52   |
+—————————+————————————+———————+
| Adidas  | Zapatillas |  15   |
+—————————+————————————+———————+
| Puma    | Pantalones |  57   |
+—————————+————————————+———————+
|   ...   |    ...     |  ...  |
+—————————+————————————+———————+

I put these types of results in the following way.

Class Producto(){
    public String marca;
    public String producto;
    public int stock;

    /*pongamos que a parte, aquí hay getters y setters básicos*/

}


Class Principal{

   public static void rellenarLista(){
       /*Establecemos conexion con BBDD lanzamos la consulta y tal*/          

       List<Producto> productos = new List<Producto>();

       While(datareader.Read()){
           Producto p = new Producto();
           p.marca = dr.getString(0);
           p.producto = dr.getString(1);
           p.stock = dr.getInt(2);
           productos.Add(p);
       }
   }
}

Now the thing is, List<Producto> productosI have to create a search algorithm with the following requirements: - That it locates each Stock element in its respective place in the two-dimensional array.

• Be self-sufficient:

  If one day I add a mark, it has to be able to find it and insert the data automatically.

• That you insert the data corresponding to your brand, since in the row the products have the same name

• If there was a Puma Sneakers, I would put it in Nike Sneakers, because in the two-dimensional structure, there is no record that Puma sells sneakers.

The problems I have had are:

1- Data positioning. 2- When I can locate the data in their respective places or it takes a long time or I can't locate them correctly. 3- Lack of adaptability, if you add a new brand it stops working, the algorithm is not self-sufficient so it will not take that brand into account in the future.

This is what I have tried so far.

public static void busqueda(){ //se llama busqueda pero perfectamente podría llamarse inserción
  String[,] matriz = new Matriz[num1, num2];
  int fila;      

  Boolean marcaEncontrada;

  for(int lista=0;lista<productos.Count;lista++){
     marcaEncontrada=false;
     for(int i = 0; i<matriz.getLengt(0);i++){ //X
         for(int j = 0; i<getLength(1);j++){   //Y 
              if(matriz[i,j].Contains(productos[lista].getMarca())){
                  marcaEncontrada=true;
              }

              if (excel[i, j].Contains(productos[lista].getProducto() && marcaEncontrada)){
                  fila=i;

              } 


          }
      }
   matriz[fila,1] = productos.getStock();

   }
 }

I think the code is a bit "sloppy" but I think it is understood for what I want to do.

As I have the code, it will insert the code, it always inserts me at the end, that is, if they are sneakers, regardless of the brand, it always inserts them at the end, in the Nike part , if they are pants, I always inserts them into the Puma part .

-I use the list to be able to make the comparisons and insert all the data using a single loop.

I have an automation that takes data from different data sources, the problem is that there is some decimal data that it saves me as text.

How can I do so that I do not save these numbers as text?

this is what i have now

//Variables interop para excel, xlWorksheet es la hoja de excel.

String excel[100,100]; //Array bidimensional
/*     Mapeo el excel a la matriz     */
       //Aquí habría código

/* Relleno la matriz con datos String */
       //Aquí recogería información


/*     Mapeo la matriz al excel       */ <---- aquí empieza el problema
xlWorksheet.Cells[i, j] = Convert.ToDouble(excel[fila, columna]); <-- esto es String
Range r = (Range)xlWorksheet.Cells[fila, columna];
r.NumberFormat = "#0.00";

I have also tried with

r.NumberFormat = "#0,00";

I was working with sheets in excel and I have to create and delete several of these. The problem is that, doing it as I do, I have a rather " dirty " code in my opinion and I was wondering if there is any way to make it cleaner.

            //Añadimos una hoja auxiliar que guardamos en una variable auxiliar
        Worksheet aux = null;
        try
        {
            //Añado la hoja
            aux = workbook.Worksheets.Add("DATOS AUX");//Si existe lanza argumentException

        }
        catch (ArgumentException)
        {
            aux = workbook.Worksheets["DATOS AUX"];//Igualo Aux a la hoja que se llame "DATOS AUX"
            aux.Clear(); //La vacío por si contiene algún tipo de 
        }
        try
        {
            workbook.Worksheets.Add("Hoja1");//Añado hoja si existe lanza ARgumentException
        }
        catch (ArgumentException)
        {
            var hoja1= workbook.Worksheets["Hoja1"];//Igualo hoja1 a la hoja
            hoja1.Clear(); //la vacío 
        }

I use ArgumentExceptionit because it is the exception that it gives me when the sheet that I try to create already exists and in the library that I use I do not see any method to do something likeif(Workbook.worksheet[indice].exists)...

I need exactly what I ask for, using c# to create a dynamic table in EXCEL with the format that this would do, being as similar as possible.

This program is part of a larger development, I have taken only the part of the code that refers to this and I have put a data table generated by me at the bottom , they are what is necessary to be able to recreate the example that I have.

I feel very lost and that's why I ask here, after having tried several things for days.

Apart from creating the table, you have to pass the data from SQL to Excel, but that part is not a big complication, so I do not think it is necessary to put it, since it is a previous step to achieve what I reflect below.

The few advances I have are in the code below, but still nothing works.

((With the data posted here there should be a complete minimum and verifiable example from which things can be done.))

This is what I have for now:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Microsoft.Office.Interop.Excel;
using System.Threading;
using System.IO;

namespace emcvTablasDinamicas
{
    class Program
    {
        static void Main(string[] args)
        {
            generarTabla();
        }

        public static void generarTabla()
        {

            int cError = 0;

            Boolean error;
            Application xlApp = null;
            do
            {
                error = false;
                try
                {
                    xlApp = new Microsoft.Office.Interop.Excel.Application();
                }
                catch (Exception)
                {
                    Thread.Sleep(1000);
                    error = true;
                    cError++;
                }
            } while (error && cError < 10);
            Workbook xlWorkbook;
            String excelpath = System.AppDomain.CurrentDomain.BaseDirectory + "EMCV.xlsx";




            xlWorkbook = xlApp.Workbooks.Open(excelpath);
            Worksheet xlWorksheet = xlWorkbook.Sheets[1];




//De aquí en adelante empiezan los fallos, no sé como solucionarlos o que alternativas podría usar
            //ESTA REGION NO FUNCIONA. No vale ni pa cagar, pero en los ejemplos de codeproject pone que si//
            #region "Aquí creamos la tabla dinámica"
            //Cantidad de datos en este caso son 100, normalmente esto se recibe de una Lista y hago Lista.Count
            int cantidadDeDatos = 100;
            Range pivotData = xlWorksheet.Range["N35:R" + Convert.ToString(500 + cantidadDeDatos + 1)];//Cantidad de datos +1 ya que también quiero incluir el rango de los alias. 

            //Ya a partir de aquí no sé exactamente lo que pasa, entendía que pivotDestination era donde iría la tabla.
            Range pivotDestination = xlWorksheet.Range["A1:A1", Type.Missing]; 

            PivotCache oPivotCache = (PivotCache)xlWorkbook.PivotCaches().Add(XlPivotTableSourceType.xlDatabase, pivotData);
            PivotCaches pch = xlWorkbook.PivotCaches();
            pch.Add(XlPivotTableSourceType.xlDatabase, pivotData).CreatePivotTable(xlWorksheet.Cells[1, 1], "Franjas horarias", Type.Missing, Type.Missing);
            PivotTable pvt = xlWorksheet.PivotTables("Franjas horarias") as PivotTable;

            //DEFINIR 'FILTRO DE INFORME'
            PivotField fld = ((PivotField)pvt.PivotFields("Platform"));
            fld.Orientation = XlPivotFieldOrientation.xlPageField;
            fld.set_Subtotals(1, false);

            //DEFINIR FILTROS DE FILA
            fld = ((PivotField)pvt.PivotFields("Mes"));
            fld.Orientation = XlPivotFieldOrientation.xlRowField;
            fld.set_Subtotals(1, false);

            //DEFINIR FILTROS DE FILA
            fld = ((PivotField)pvt.PivotFields("Dia"));
            fld.Orientation = XlPivotFieldOrientation.xlRowField;
            fld.set_Subtotals(1, false);

            fld = ((PivotField)pvt.PivotFields("Count"));
            fld.Orientation = XlPivotFieldOrientation.xlDataField;
            //Se supone que este método le funciona a todo dios, todo el mundo lo usa en internet pero a mi me dice
            //'_Worksheet.PivotTables(object)' es un método, que no es válida en el contexto indicado.

            #endregion



            xlWorkbook.Save();
            xlWorkbook.Close();
            xlApp.Quit();

        }




    }
}

This is the process that is normally done:

1- Select the data in Excel

2- hit pivot table

3- Position the column names in each place

Then we do this so that the pivot table is created for us.

I've been looking for similar things on the internet but I haven't found any examples that work for me, or that I can use, or anything.

Any way to adapt the data to the format?

In the end what I have to stay is something like this

I ADD HERE DATA THAT CAN BE PASSED TO EXCEL IN CASE SOMEONE WANTS TO TRY THE PROGRAM.

+-----+--------+-----+-----+------+-------+
|     |   A    |  B  |  C  |  D   |   E   |
+-----+--------+-----+-----+------+-------+
|   1 | Alias  | Mes | Dia | Hora | Count |
|   2 | Alias1 | 1   | 2   | 8    | 6     |
|   3 | Alias2 | 3   | 2   | 9    | 28    |
|   4 | Alias1 | 1   | 2   | 10   | 36    |
|   5 | Alias2 | 1   | 2   | 11   | 41    |
|   6 | Alias2 | 1   | 2   | 12   | 31    |
|   7 | Alias1 | 2   | 2   | 13   | 23    |
|   8 | Alias1 | 2   | 2   | 14   | 10    |
|   9 | Alias2 | 2   | 2   | 15   | 12    |
|  10 | Alias2 | 2   | 2   | 16   | 24    |
|  11 | Alias1 | 1   | 2   | 17   | 11    |
|  12 | Alias2 | 1   | 2   | 18   | 17    |
|  13 | Alias2 | 1   | 2   | 19   | 4     |
|  14 | Alias1 | 1   | 2   | 20   | 3     |
|  15 | Alias2 | 1   | 2   | 21   | 1     |
|  16 | Alias1 | 2   | 3   | 8    | 7     |
|  17 | Alias1 | 2   | 3   | 9    | 23    |
|  18 | Alias2 | 2   | 3   | 10   | 44    |
|  19 | Alias1 | 2   | 3   | 11   | 42    |
|  20 | Alias2 | 1   | 3   | 12   | 41    |
|  21 | Alias1 | 1   | 3   | 13   | 26    |
|  22 | Alias2 | 1   | 3   | 14   | 6     |
|  23 | Alias1 | 1   | 3   | 15   | 4     |
|  24 | Alias1 | 1   | 3   | 16   | 10    |
|  25 | Alias1 | 3   | 3   | 17   | 22    |
|  26 | Alias1 | 1   | 3   | 18   | 8     |
|  27 | Alias2 | 3   | 3   | 19   | 5     |
|  28 | Alias1 | 1   | 3   | 20   | 7     |
|  29 | Alias2 | 1   | 3   | 21   | 2     |
|  30 | Alias1 | 1   | 4   | 8    | 6     |
|  31 | Alias2 | 1   | 4   | 9    | 24    |
|  32 | Alias1 | 1   | 4   | 10   | 29    |
|  33 | Alias2 | 2   | 4   | 11   | 26    |
|  34 | Alias2 | 2   | 4   | 12   | 18    |
|  35 | Alias1 | 2   | 4   | 13   | 16    |
|  36 | Alias1 | 2   | 4   | 14   | 10    |
|  37 | Alias1 | 2   | 4   | 15   | 12    |
|  38 | Alias1 | 2   | 4   | 16   | 13    |
|  39 | Alias2 | 1   | 4   | 17   | 20    |
|  40 | Alias1 | 1   | 4   | 18   | 13    |
|  41 | Alias2 | 1   | 4   | 19   | 6     |
|  42 | Alias2 | 1   | 4   | 20   | 4     |
|  43 | Alias1 | 1   | 4   | 21   | 2     |
|  44 | Alias2 | 1   | 5   | 8    | 7     |
|  45 | Alias1 | 1   | 5   | 9    | 21    |
|  46 | Alias1 | 3   | 5   | 10   | 34    |
|  47 | Alias1 | 3   | 5   | 11   | 37    |
|  48 | Alias2 | 3   | 5   | 12   | 15    |
|  49 | Alias1 | 3   | 5   | 13   | 17    |
|  50 | Alias2 | 3   | 5   | 14   | 15    |
|  51 | Alias2 | 1   | 5   | 15   | 9     |
|  52 | Alias2 | 1   | 5   | 16   | 9     |
|  53 | Alias1 | 1   | 5   | 17   | 9     |
|  54 | Alias2 | 1   | 5   | 18   | 3     |
|  55 | Alias1 | 1   | 5   | 19   | 2     |
|  56 | Alias1 | 1   | 5   | 20   | 3     |
|  57 | Alias1 | 1   | 5   | 21   | 2     |
|  58 | Alias1 | 2   | 6   | 14   | 1     |
|  59 | Alias2 | 3   | 8   | 8    | 29    |
|  60 | Alias2 | 3   | 8   | 9    | 42    |
|  61 | Alias2 | 3   | 8   | 10   | 51    |
|  62 | Alias2 | 2   | 8   | 11   | 48    |
|  63 | Alias2 | 2   | 8   | 12   | 47    |
|  64 | Alias1 | 2   | 8   | 13   | 47    |
|  65 | Alias1 | 2   | 8   | 14   | 16    |
|  66 | Alias2 | 1   | 8   | 15   | 8     |
|  67 | Alias1 | 1   | 8   | 16   | 23    |
|  68 | Alias1 | 1   | 8   | 17   | 26    |
|  69 | Alias1 | 1   | 8   | 18   | 23    |
|  70 | Alias1 | 2   | 8   | 19   | 11    |
|  71 | Alias2 | 2   | 8   | 20   | 4     |
|  72 | Alias1 | 2   | 8   | 21   | 1     |
|  73 | Alias1 | 2   | 9   | 8    | 15    |
|  74 | Alias2 | 3   | 9   | 9    | 33    |
|  75 | Alias1 | 3   | 9   | 10   | 48    |
|  76 | Alias1 | 3   | 9   | 11   | 43    |
|  77 | Alias2 | 2   | 9   | 12   | 48    |
|  78 | Alias1 | 3   | 9   | 13   | 29    |
|  79 | Alias1 | 1   | 9   | 14   | 14    |
|  80 | Alias1 | 1   | 9   | 15   | 8     |
|  81 | Alias1 | 1   | 9   | 16   | 24    |
|  82 | Alias2 | 1   | 9   | 17   | 21    |
|  83 | Alias1 | 3   | 9   | 18   | 17    |
|  84 | Alias1 | 2   | 9   | 19   | 9     |
|  85 | Alias1 | 1   | 9   | 20   | 6     |
|  86 | Alias1 | 2   | 9   | 21   | 2     |
|  87 | Alias2 | 2   | 10  | 8    | 10    |
|  88 | Alias2 | 2   | 10  | 9    | 40    |
|  89 | Alias2 | 1   | 10  | 10   | 61    |
|  90 | Alias1 | 2   | 10  | 11   | 35    |
|  91 | Alias1 | 3   | 10  | 12   | 27    |
|  92 | Alias2 | 1   | 10  | 13   | 25    |
|  93 | Alias2 | 2   | 10  | 14   | 14    |
|  94 | Alias1 | 1   | 10  | 15   | 28    |
|  95 | Alias1 | 1   | 10  | 16   | 19    |
|  96 | Alias2 | 3   | 10  | 17   | 26    |
|  97 | Alias1 | 3   | 10  | 18   | 12    |
|  98 | Alias2 | 3   | 10  | 19   | 6     |
|  99 | Alias1 | 3   | 10  | 20   | 1     |
| 100 | Alias1 | 3   | 10  | 21   | 5     |
+-----+--------+-----+-----+------+-------+

I am in an android class project and I have almost finished it but I need to pass some variables from one activity to another, it gives me NullPointerException and searching I have not found anything.

logcat

Caused by: java.lang.NullPointerException: Attempt to invoke virtual method 'android.os.Bundle android.content.Intent.getExtras()' on a null object reference at com.group3.cebancburger.AddBurger.(AddBurger.java:31 )

The attempt that I do in class.

MainActivity:

(The views)

nomb = (EditText)findViewById(R.id.nombre);
dire = (EditText)findViewById(R.id.direccion);
tele = (EditText)findViewById(R.id.telefono);
email = (EditText)findViewById(R.id.email);

(try)

intent = new Intent(DatosCliente.this, AnadirHamburguesa. 
intent.putExtra("nombre", nomb.getText().toString());
intent.putExtra("direccion", dire.getText().toString());
intent.putExtra("telefono", tele.getText().toString());
intent.putExtra("email", email.getText().toString());
startActivity(intent);

AddBurger(the getIntent)

Bundle extras = getIntent().getExtras();
String nom = extras.getString("nombre");
String dire = extras.getString("direccion");
String tele = extras.getString("telefono");
String email = extras.getString("email");

I have the following problem, I have to make a program that checks if X things are active, querying a database and displaying them in a form.

It's something like this more or less.

Note: I omit some parts of the code since I think they are not necessary for the understanding of the code or the resolution of the problem.

 _____________________________________
|_____________________________________|
|  Algo       |  Estado = activo      |
| Otra cosa   |  Estado = Pausado     |
| Y algo      |  Estado = Suspendido  |
|____ ______ ____________ ____________|                                  

The thing is that I want to control what appears in this form, the states, from a thread that is in a different class, that is, the program will do more things apart from this and I am interested in dividing it by classes and others.

The problem arises when I have to access it from the thread, which itself is a static method. This is the idea I had, I attach an example of the two classes.

public partial class Form1 : Form {
{    
     public Form1(){
          InitializeComponent();
     }

     private void controlItem_Click(object sender, EventArgs e){
            //Iniciamos el hilo padre.
            Thread principal = new Thread(Hilos.mainthread);
            principal.Start();
      }
}

class Hilos
    {

        static MySqlConnection conn;
        private Boolean error;


        public static void mainthread() {



            //Creamos la conexión con la BBDD
            string myConnectionString = "server=xx.xx.xx.xx;uid=xxxxx;" +
                                        "pwd=xxxxxx*;database=xxxxxx";

            //Intentamos la conexión

            conn = new MySql.Data.MySqlClient.MySqlConnection();
            conn.ConnectionString = myConnectionString;
            conn.Open();


            data=//Aquí iría una consulta MySQL

            if(data==xxxx){
              //Lo que quiero hacer es Form1.textbox1.text=Activo
              //Evento o algo para hacer que funcione

            }else if(data==yyyy){
              //Lo que quiero hacer es Form1.textbox1.text=Suspendido   
              //Evento o algo para hacer que funcione

            }else{
              //Lo que quiero hacer es Form1.textbox1.text=Pausado
              //Evento o algo para hacer que funcione

            }                

     }

}

So, once the code is exposed, what I want to know is, how can I make it so that when one of the conditions is met, an event is launched or something (I still don't know about events), in order to change the corresponding Textbox.