Juan Manuel Palacios's questions

I am working with a JSON file that comes with a specific structure, which when doing the deserialization process returns some of the values ​​to null.

The source file that I am processing is the following:

{
"t":"i",
"v":
[
    {
        "id":604618,
        "url":"http://wsplus.navego360.com/images/services/215/37480914/604618.jpg",
        "last_log":
        {
            "t":"n",
            "dt":"2018-08-16T19:03:47.962Z",
            "c_lat":-12.014695,
            "c_lon":-76.93001
        }
    },
    {
        "id":604619,
        "url":"http://wsplus.navego360.com/images/services/215/37480914/604619.jpg",
        "last_log":
        {
            "t":"n",
            "dt":"2018-08-16T19:03:55.667Z",
            "c_lat":-12.014695,
            "c_lon":-76.93001
        }
    }
],
"st":"p"
}

This file can return several URLs with different photos, which I must be able to retrieve, regardless of whether it is just one URL or several.

The structure in C# that will receive the values ​​is as follows:

public class ListaFotos
{
    public string t { get; set; }
    public List<FotoURL> fotos { get; set; }
    public string st { get; set; }
}

public class FotoURL
{
    public string id { get; set; }
    public string url { get; set; }
    public IDictionary<string, string> last_log { get; set; }
}

To convert to C# I am using the following line of code:

JsonConvert.DeserializeObject<DatosRetorno.ListaFotos>(jsonFotos);

The values ​​that I am not receiving are those that are inside the list List<FotoURL>, which corresponds to the "v" section of the JSON file, which is precisely the most important part, since the images that I must retrieve are located there.

I am trying to create a JSON file to be injected through a WebService to a third party service, which will fill data in a dynamic form.

The issue is that the structure that I must respect, according to the provider's specifications, to give an example since the model has a greater number of values ​​to transmit, is the following:

{ "f": "546",
  "efs": { "1":"Ubicación",
           "2":"Categoría",
           "3":"Contacto",
           "4":"Celular" } }

I've gone through several reference articles, but when creating the class I need I can't use numbers as labels/markers (if they are called that) and so I'm forced to use the following:

    public class form_addsModel
    {
       public string f { get; set; }
       public efsModel efs { get; set; }
    }

    public class efsModel
    {
        public string _1 { get; set; }
        public string _2 { get; set; }
        public string _3 { get; set; }
        public string _4 { get; set; }
    }

The expected result is not the right one, and the truth is that I don't know how feasible it is to build a JSON with those characteristics and restrictions set by the provider.

I am currently working in C# with Visual Studio 2012.

I'm putting together a small project where I'm displaying some records in DataGrida form designed in XAML, but I can't find the property that allows me to do this job.

My code so far is as follows:

<DataGrid x:Name="grdUnidadesMedida" HorizontalAlignment="Stretch" Margin="10,40" VerticalAlignment="Stretch" Height="Auto" Width="Auto">
    <DataGrid.Columns>
        <DataGridTextColumn x:Name="_codigoUnidadMedida" Binding="{Binding UnidadCodigo}" Header="Código Unidad de Medida" />              
        <DataGridTextColumn x:Name="_descripcionUniddMedida" Binding="{Binding Descripcion}" Header="Descripción Unidad de Medida"/>
        <DataGridTextColumn x:Name="_estadoUnidadMedida" Binding="{Binding Estado}" Header="Estado" />
        </DataGridTextColumn>
    </DataGrid.Columns>
</DataGrid>

The project is all done in C#, but I don't think it affects this part of the form design.

Since I have not found major references to this topic or a guide to good practices, I have not been able to form an opinion.

I am just entering the MVVM world with WPF and I see that there are several references where it is mentioned that within an MVVM project the three standard folders Model, View and ViewModel must exist, however I wanted to know if it is good practice to combine that standard with the form layered programming, that is, create a project for data access, another for business logic and in a third have MVVM with their respective folders.

My question is, is it good practice to combine the MVVM standard with layered programming?

The project that I am putting together is going to be all in C#.

I am reviewing an example project using MVVM and Store Procedures for DB access in SQL Server. I wanted to know if there is a maximum number of fields that can be passed to a Store Procedure from C#.

In the example they put 6 fields, but if I have a table with 30 or 40 fields (invoice, reference guide), considering that the vast majority are entered by the user, is there a better way to send them to the table?

This is the example line of code.

dc.AddProduct(p.CategoryName, p.ModelNumber, p.ModelName, p.UnitCost, p.Description, ref newProductId);

I'm trying to validate the content of a cell inside a DataGridView when the CellValidated event is fired and I've seen different ways to deal with the problem, but I can't get around the Null error when running the application.

The error I get is NullReferenceException was Unhandledand that the reference is not set to an instance of an object. This error happens when I leave the cell blank to move to another cell, that If's when it drops. It should be noted that I am using the Gridfor a direct entry.

What I'm thinking of including is a try..catchto bypass the problem, but I think that's not the best option.

The code of the event that I am using is the following:

private void dgvProductosPropios_CellValidated(object sender, DataGridViewCellEventArgs e)
{
    if (dgvProductosPropios.Columns[e.ColumnIndex].Name == "_marcaCodigo")
    {
        if (dgvProductosPropios.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString() == String.Empty) 
            cMarca = dgvProductosPropios.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString();
        else
            cMarca = "";
    }
}

I am having problems with the response time of the queries that I am executing with SQL Server.

Researching I found that a good practice is to create indexes associated with the fields within a table or a view.

What is the best way to create these indexes? Is it convenient to make an index for each field or to make an index for several fields?

Good afternoon sirs,

Is there a way to be able to detect when a user has pressed the key ImpPnt?

What I'm wanting to implement is being able to detect when a user has pressed the key ImpPntor PrntScrnfrom any control within any form that is within a module and/or application.

The application where I need to implement this has several projects, some of them are developed entirely in VB and others in C#.

Sincerely, Juan Manuel

I always have problems with dates when I want to pass them as a parameter to a SQL statement, I try to use a previous variable, a Convertor a Castbut I can never find the correct way.

I have the following statement in C# where I am building an Update statement and I am sending 3 parameters, of which two are numeric values ​​and the last one is the date in question.

UpdateStatement = "UPDATE Productos SET PrecioUnitario = " + nPrecioUnitario.ToString() + ", FactorVenta = " + nFactorVenta.ToString() + ", PrecioUnitarioFecha = CONVERT(DateTime,'" + dFecha.ToString() + "',103) WHERE ProductoId = " + nProductoId;

The error I get is the following:

Conversion failed when converting datetime from character string.

It is not a format issue because we are May 18 and the date is coming 05/18/2016 12:00:00. First I tried to leave it unconverted, then I put it in quotes and added Convert and I don't know at the end if there is any correct way to get a date to pass directly and without these problems.

Any ideas?

I am trying to use the mouse as little as possible and for this I need to know if there is any way to be able to change control when pressing the key Enter.

The idea I have is that if I'm on a form with several controls, I'm mostly using controls of type TextBoxbut I could have DateTimePickersor ComboBox; that when pressing Enterskip to the next control, using the order that is given to them when creating them in the form with the property TabIndex.

private void txtOrdenServicio_KeyPress(object sender, KeyPressEventArgs e)
    {
        if (e.KeyChar == (char)13)
        {
            Cargar_OrdenesServicio();
            txtRazonTrabajo.Focus();
        }
    }

With the previous code I have put it in one of the events KeyPressbut if I have 10 I TextBoxwould have to place the control that follows manually. I am working with Windows Form.

Is there any way to achieve this jump?

I am creating a new query ( query ) to obtain the sum of the amounts of entry and exit of a warehouse. The first thing I have done is formulate a query that allows me to separate the inputs from the outputs by placing a sign -in front of the amount when it is input, I have done that with a case when:

select productoid, descripcion, codigodelproveedor, marcacodigo, modelo, codigopropio, 
       case tipooperacion when 'S' then cantidad when 'I' then cantidad * -1 end as cantidad 
from ViewParteDeAlmacenProductosDescriptivo

Now what I need is to do a sumwith the result of casebut I am getting the following error:

Msg 195, Level 15, State 10, Line 2 'sum' is not a recognized built-in function name.

This is the new query:

select productoid, descripcion, codigodelproveedor, marcacodigo, modelo, codigopropio, 
       sum(case tipooperacion when 'S' then cantidad when 'I' then cantidad * -1 end as cantidad) as cantidad 
from ViewParteDeAlmacenProductosDescriptivo 
group by productoid, descripcion, codigodelproveedor, marcacodigo, modelo, codigopropio

Any ideas?

I am working on filling in the fields of a form and I have one ComboBoxthat refers to the sales staff and I have the associated event SelectedIndexChangedthat triggers a search after changing the value. What I want is to prevent that event from being triggered, because when doing the Loadform in a first load I get an error when trying to do the associated search, since it ComboBoxdoes not yet have a valid value. Thank you very much.

I am using a TabControlwithin a form designed in C#, it TabControlhas two Tabs and I need to be able to hide one and/or show it depending on a state that arrives as a parameter from another form. I can't find a property of type Visibleor in any case Enabled.

Is there a way to hide a tab inside a TabControl or at least disable it?

Thank you very much

I am bringing several records from a database to a database datatableand I have 4 fields that are of type date. At least one of them could bring a value NULLand when linking the field with a control datetimepickerit gives me an error not finding a valid value.

How could I pre-validate the field before assigning it to the control? I have tried comparing the valuefield with NULLbut it has not worked.

if (campoFecha != null)

The Date field already has the value fetched by it datatableand has been declared asdatetime

I have the need to search for a text type value but I don't know in which table it could be stored, so I would like to know if there is any way to search in all the existing structures within the same SQL database.

Suddenly a command could exist or a store procedure could be created that can do this type of work in a general way.

I'm putting together a statement INSERTin SQL with values ​​stored in variables that come from a CURSORthat I'm looping through. At the time of executing the instruction INSERTI am getting an invalid identifier error.

The code I'm working on is the following and it's inside a repeating loop that gets data from a cursor:

IF (@Estado = 'V')
    SET @NuevoEstado = 'ACT'
ELSE
    SET @NuevoEstado = 'ANU'

SET @ClienteId = (
        SELECT ClienteId
        FROM QueryClientesDescriptivo
        WHERE CodigoContribuyente = @RUC
            AND Estado = 'ACT'
        )
SET @MovimientoInventarioId = @MovimientoInventarioId + 1
SET @Query = 'INSERT INTO [COMPU90].[SIV3].[dbo].MovimientosInventario (CompaniaId, MovimientoInventarioId, TipoMovimientoInventarioId, Fecha, Glosa, AlmacenId, PersonaId, Estado, OrigenId, Migracion) ' + 'VALUES (' + CHAR(39) + '10043' + CHAR(39) + ',' + CHAR(39) + CONVERT(VARCHAR, @MovimientoInventarioId) + CHAR(39) + ',' + CHAR(39) + 'SVEN' + CHAR(39) + ',' + CHAR(39) + CONVERT(VARCHAR, @Fecha, 101) + CHAR(39) + ',' + CHAR(39) + '' + CHAR(39) + ',' + CHAR(39) + '2' + CHAR(39) + ',' + CHAR(39) + CONVERT(VARCHAR, @ClienteId) + CHAR(39) + ',' + CHAR(39) + @NuevoEstado + CHAR(39) + ',' + CHAR(39) + '0' + CHAR(39) + ',' + CHAR(39) + '0' + CHAR(39) + ')'

EXEC @Query

The error message I get is the following:

The name 'INSERT INTO [COMPU90].[SIV3].[dbo].MovementsInventory (CompanyId, MovementInventoryId, TypeMovementInventoryId, Date, Gloss, WarehouseId, PersonId, Status, OriginId, Migration) VALUES ('10043','141907',' SVEN','01/04/2016','','2','253624','ANU','0','0')' is not a valid identifier.

I have tried changing the format of the date, the way in which to pass the parameters but no way frees me from that error, however, when executing it directly it works without giving me errors.

Good afternoon, I am trying to insert records from a Cursor into a table in SQL but building the Insert statement in a text type variable.

Within the values ​​I have an integer type field, several texts and a date, apparently I am having some complications in the assembly, suddenly they can shed some light on it.

What I want to build is something like this:

set @queryTexto = 'Insert into <<tabla>> (<<lista de campos>>) 
    Values (@campoNumerico, @campo1, @campo2, @campo3, ''ACT'', @campoFecha)'
exec @queryTexto

I have seen in some examples that you have to convert values, I have also seen the use of CHAR(39). What recommendations could you give me? Thank you very much.

Is there any possibility to attach PDF files or any type of file to a DB record in SQL Server 2008 R2 from a C# application made with VS 2012.