Pedro Ávila's questions

I work with C# I have the need to convert a list to a multidimensional array

What they send me on the list is the following

int[,] matriz = new int[,] { { 1, 2, 2 }, { 3, 4, 3 }, { 5, 6, 1 } };

But they are sending it as follows

List<List<int>> arr

I need to convert that list to a multidimensional array so that it looks like this

int[,] matriz = new int[,] { { 1, 2, 2 }, { 3, 4, 3 }, { 5, 6, 1 } };

How to convert that list to Array?

What happens is that I solved an exercise in the way that it is a multidimensional array but when it comes to implementing the code I am surprised that it is a list

int sumaDiagonalI = 0;
        int sumaDiaganalD = 0;

        int[,] matriz = new int[,] { { 1, 2, 2 }, { 3, 4, 3 }, { 5, 6, 1 } };

        int cantFilas = matriz.GetLength(0);
        int cantColumnas = matriz.GetLength(1);

        if (cantFilas != cantColumnas)
        {
            Console.WriteLine("No es una matriz cuadrada");
            return;
        }

        var indiceMáximo = Math.Min(cantFilas, cantColumnas);
        for (var i = 0; i < indiceMáximo; i++)
        {
            sumaDiagonalI += matriz[i, i];
        }

        int j = 0;
        for (int i = 0; i < cantFilas; i++)
        {
            j = ((cantFilas - 1) - i);
            sumaDiaganalD += matriz[i, j];
        }

In this algorithm I add the left and right diagonals

I work with C#, Windows Forms I need to implement in the KeyDow event of the form the following combination of key Alt + C I have tried but I have not been able to achieve it.

if (e.KeyCode == e.Alt && Keys.C )

It is not the way, how can I solve it?

I have an array which I want to add its elements but with the algorithm that I have it gives me an error.

var numeros = [1, 2, 3, 4, 5], suma = 0;
    forEach (numeros, function(numero){
        suma += numero;
    });
    console.log(suma);

Error: Uncaught ReferenceError: forEach is not defined

What is the correct way to do it?

And how would it be doing a For

for(var i = 0; i <= numeros.length; i++){
        numero = numeros[i];
        suma += numero;
    }

To compare both methods.

I have a detail Catalogothat is called ProductoCatalogoin which I enter the products that are going to be sold, but there are products that have their specifications, as in the case of clothing they have: Size and Color, that is registered in a Specifications master that has the following structure: Header = table Especificacionesand Detail = Table Opcionesin Especificaciones va Color and in Opcionesva Red, Blue, Yellow, etc. The same happens for sizes.

This is the structure of the tables involved to get the information I want.

The information I want to obtain is the following:

• ProductCatalogId
• Product name
• Sale price
• Size
• Color

This is what I expect as a result:

1 CAMISETA FERRARI 12.00 TALLA LETRA S COLOR ROJO
1 CAMISETA FERRARI 12.00 TALLA LETRA S COLOR AZUL

For that I have elaborated the following query in which I apply a filter by the name of the product. As I told you, I have a master specification that is why in OptionName I get the sizes and colors.

SELECT PC.ProductoCatalogoId, PC.ProductoId, P.Nombre, PC.PrecioVenta, 

EP.EspecificacionId, E.Nombre, EC.OpcionId, 
O.NombreOpcion
FROM ProductoCatalogos AS PC
JOIN Productos AS P ON P.ProductoId = PC.ProductoId
JOIN EspecificacionProductos AS EP ON EP.ProductoId = P.ProductoId
JOIN Especificaciones AS E ON E.EspecificacionId = EP.EspecificacionId
JOIN EspecificacionCatalogos AS EC ON EC.EspecificacionProductoId = EP.EspecificacionProductoId
JOIN Opciones AS O ON O.OpcionId = EC.OpcionId
WHERE P.Nombre LIKE '%FERR%'

Which gives me the following data.

I need to separate the sizes and the colors for that I have improvised with PIVOT, with which it has been possible to put the colors in the Color column which was separated with PIVOT, but it has not worked with Size.

WITH Pruebas(ProductoCatalogoId, ProductoId, NombreProducto, PrecioVenta, 

EspecificacionId, Nombre, OpcionId, NombreOpcion) AS
    (SELECT PC.ProductoCatalogoId, PC.ProductoId, P.Nombre, PC.PrecioVenta, EP.EspecificacionId, E.Nombre, EC.OpcionId, 
O.NombreOpcion
FROM ProductoCatalogos AS PC
JOIN Productos AS P ON P.ProductoId = PC.ProductoId
JOIN EspecificacionProductos AS EP ON EP.ProductoId = P.ProductoId
JOIN Especificaciones AS E ON E.EspecificacionId = EP.EspecificacionId
JOIN EspecificacionCatalogos AS EC ON EC.EspecificacionProductoId = EP.EspecificacionProductoId
JOIN Opciones AS O ON O.OpcionId = EC.OpcionId
WHERE P.Nombre LIKE '%FERR%')
SELECT * FROM PRUEBAS
PIVOT(MAX(NombreOpcion) FOR Nombre IN ([TALLA LETRA], [COLOR])) PVT

It gives me the following information.

trying on pants

I don't know if it's the right way or if there is another way to get what I need. Credentials to connect to the database.

Server: den1.mssql4.gear.host User: business Pass: Ga33-47L1YC!

Thanks in advance. Cheers!

I work with SQL Server 2014 I have the need to obtain data from two tables for that I can do a INNER JOINdetail is that when I do this query.

I need to use EspecificacionIdto be able to do another INNER JOINin my Options table.

But the issue is that I must take the values ​​that I have EspecificacionIdin that query, it has two Specifications, the taking is dynamically, that means that I must use both in this case, but going through and taking the values ​​and then go to the Options table. How can I do it? .

My idea would be to go through the result of the returned query through a foreach or for and take the data from SpecificationId to save it in an array and with those results do INNER JOINall that in the Options table in SQL Server.

Cheers!

I work in a Windows Forms app in which I have a DataGridView control in which one of its columns is of type Combobox, I can populate the ComboBox with data without any problem.

The problem I have is that I need the first element that contains the Combobox to be selected, in this case <<Seleccione>>I have not been able to get it at first sight, nothing is seen in the ComboBox until I click to be able to display the ComboBox and be able to select the items .

This way I load the ComboBox

public IEnumerable<UniversalExtend> SelectList(Expression<Func<UnidadMedida, UniversalExtend>> source)
    {
        return _unidadMedidaRepository.SelectList(source);
    }

    public IEnumerable<UniversalExtend> ListaUnidadMedidas
        (Expression<Func<UnidadMedida, UniversalExtend>> source)
    {
        var listaItem = SelectList(source).ToList();
        listaItem.Insert(0, new UniversalExtend() { Id = -1, Descripcion = "<<<Seleccione>>>" });
        return listaItem;
    }

Persistence

public IEnumerable<UniversalExtend> SelectList(Expression<Func<T, UniversalExtend>> source)
    {
        using (var context = new BusinessContext())
        {
            var result = context.Set<T>().AsNoTracking()
                .Select(source).ToList();
            return result;
        }
    }

Binding the data to the ComboBox

dataGridView1.AutoGenerateColumns = false;
        DataGridViewComboBoxColumn cboColMedida = dataGridView1.Columns["colCombo"] as DataGridViewComboBoxColumn;
        cboColMedida.DataSource =
            _saUnidadMedida.ListaUnidadMedidas(
                x => new UniversalExtend() {Id = x.UnidadMedidaId, Descripcion = x.Abreviacion}).ToList();
        cboColMedida.DisplayMember = "Descripcion";
        cboColMedida.ValueMember = "Id";

This is how it is shown when the cbo is already loaded with data.

I work with ASP.NET MVC, I am using the DataTable.net library

I am bringing data from the database through a JsonResult that returns the information in plain text.

Method

// GET: Cliente
    public ActionResult Index()
    {
        List<Cliente> _cliente = clienteService.GetAll().ToList();
        config = new MapperConfiguration(cfg => cfg.CreateMap<Cliente, ClienteViewModel>());
        List<ClienteViewModel> list = config.CreateMapper().Map<List<ClienteViewModel>>(_cliente);
        return Json(list, JsonRequestBehavior.AllowGet);
    }

from the HTML

<script type="text/javascript" language="javascript">
$(document).ready(function() {
    $("#clientes").DataTable({
        paging: true,
        searching: true,
        bProcessing: true,
        "ajax": {
            "url": "Cliente/Index",
            "columns": [
                { "data": "ClienteId" },
                { "data": "RazonSocial" },
                { "data": "NumeroDocumento" },
                { "data": "Direccion" },
                { "data": "Fijo" },
                { "data": "Email" },
                { "data": "Estado" }
            ],
            "dataType": "json"
        },
        "language": {
            "sProcessing": "Procesando...",
            "sLengthMenu": "Mostrar _MENU_ registros",
            "sZeroRecords": "No se encontraron resultados",
            "sEmptyTable": "Ningún dato disponible en esta tabla",
            "sInfo": "Mostrando registros del _START_ al _END_ de un total de _TOTAL_ registros",
            "sInfoEmpty": "Mostrando registros del 0 al 0 de un total de 0 registros",
            "sInfoFiltered": "(filtrado de un total de _MAX_ registros)",
            "sInfoPostFix": "",
            "sSearch": "Buscar:",
            "sUrl": "",
            "sInfoThousands": ",",
            "sLoadingRecords": "Cargando...",
            "oPaginate": {
                "sFirst": "Primero",
                "sLast": "Último",
                "sNext": "Siguiente",
                "sPrevious": "Anterior"
            },
            "oAria": {
                "sSortAscending": ": Activar para ordenar la columna de manera ascendente",
                "sSortDescending": ": Activar para ordenar la columna de manera descendente"
            }
        }
    });
});

The problem is that it shows me a page with the following information

I think the issue is to leave the Index as ActionResult and create a JsonResult method that loads the table.

Updating as I have my methods. Controller

 // GET: Cliente
    public ActionResult Index()
    {
        return View();
    }

    public JsonResult ListaClientes()
    {
        List<Cliente> _cliente = clienteService.GetAll().ToList();
        config = new MapperConfiguration(cfg => cfg.CreateMap<Cliente, ClienteViewModel>());
        List<ClienteViewModel> list = config.CreateMapper().Map<List<ClienteViewModel>>(_cliente);
        return Json(list, JsonRequestBehavior.AllowGet);
    }

HTML

<script type="text/javascript" language="javascript">
$(document).ready(function() {
    $("#clientes").DataTable({
        //paging: true,
        //searching: true,
        //bProcessing: true,
        "ajax": {
            "url": "@Url.Action("ListaClientes")",
            "dataSrc": '',
            "type": "GET",
            "columns": [
                { "data": "ClienteId" },
                { "data": "RazonSocial" },
                { "data": "NumeroDocumento" },
                { "data": "Direccion" },
                { "data": "Fijo" },
                { "data": "Email" },
                { "data": "Estado" }
            ],
            //"dataType": "json"
        },
        "language": {
            "sProcessing": "Procesando...",
            "sLengthMenu": "Mostrar _MENU_ registros",
            "sZeroRecords": "No se encontraron resultados",
            "sEmptyTable": "Ningún dato disponible en esta tabla",
            "sInfo": "Mostrando registros del _START_ al _END_ de un total de _TOTAL_ registros",
            "sInfoEmpty": "Mostrando registros del 0 al 0 de un total de 0 registros",
            "sInfoFiltered": "(filtrado de un total de _MAX_ registros)",
            "sInfoPostFix": "",
            "sSearch": "Buscar:",
            "sUrl": "",
            "sInfoThousands": ",",
            "sLoadingRecords": "Cargando...",
            "oPaginate": {
                "sFirst": "Primero",
                "sLast": "Último",
                "sNext": "Siguiente",
                "sPrevious": "Anterior"
            },
            "oAria": {
                "sSortAscending": ": Activar para ordenar la columna de manera ascendente",
                "sSortDescending": ": Activar para ordenar la columna de manera descendente"
            }
        }
    });
});

Error DataTables warning: table id=customers - Requested unknown parameter '0' for row 0, column 0. For more information about this error, please see

I am working on a WPF desktop application, Windows 10, Visual Studio 2015.

In which when I go to the location of the video it plays, I have the following code.

XAML:

<Window x:Class="ReconocimientoVoz.MainWindow"
    xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
    xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
    xmlns:d="http://schemas.microsoft.com/expression/blend/2008"
    xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006"
    xmlns:local="clr-namespace:ReconocimientoVoz"
    mc:Ignorable="d"
    Title="MainWindow" Height="350" Width="525">
<Grid>
    <Grid.ColumnDefinitions>
        <ColumnDefinition Width="28*"/>
        <ColumnDefinition Width="19*"/>
    </Grid.ColumnDefinitions>
    <Rectangle x:Name="rectColor" Fill="#FFF4F4F5" HorizontalAlignment="Left" Height="100" Margin="55,46,0,0" Stroke="Black" VerticalAlignment="Top" Width="100"/>
    <Label x:Name="lblColor" Content="lblColor" HorizontalAlignment="Left" Margin="144,234,0,0" VerticalAlignment="Top" Width="179" Grid.ColumnSpan="2"/>
    <Button x:Name="btnEscuchar" Content="Escuchar" HorizontalAlignment="Left" Margin="62,234,0,0" VerticalAlignment="Top" Width="75" Grid.Column="1" Click="btnEscuchar_Click"/>
    <Label x:Name="label" Content="Color:" HorizontalAlignment="Left" Margin="98,234,0,0" VerticalAlignment="Top"/>
    <MediaElement x:Name="mediaPlayer" Grid.Column="1" HorizontalAlignment="Left" Height="161" 
                  Margin="0,35,0,0" VerticalAlignment="Top" Width="200" LoadedBehavior="Play"/>

</Grid>

In Mediaelement configure LoadedBehavior in Play so that supposedly when giving the video path it can be displayed in the control.

C#

private void btnEscuchar_Click(object sender, RoutedEventArgs e)
    {
        lblColor.Content = string.Empty;
        try
        {
            escucha.SetInputToDefaultAudioDevice();
            escucha.LoadGrammar(new DictationGrammar());
            //escucha.SpeechRecognized += new EventHandler<SpeechRecognizedEventArgs>(lector);
            escucha.SpeechRecognized += Escucha_SpeechRecognized;
            escucha.SetInputToDefaultAudioDevice();
            escucha.RecognizeAsync(RecognizeMode.Multiple);
        }
        catch (InvalidOperationException ex)
        {
            MessageBox.Show(ex.Message, "Aviso");
        }
    }

    private void Escucha_SpeechRecognized(object sender, SpeechRecognizedEventArgs e)
    {
        foreach (var palabra in e.Result.Words)
        {
            lblColor.Content = palabra.Text;
            if (palabra.Text == "rojo")
            {
                rectColor.Fill = new SolidColorBrush(Colors.Red);
            }
            else if (palabra.Text == "azul")
            {
                rectColor.Fill = new SolidColorBrush(Colors.Blue);
            }
            else if (palabra.Text == "amarillo")
            {
                rectColor.Fill = new SolidColorBrush(Colors.Yellow);
                mediaPlayer.Source = new Uri(@"D:\PruebasCSharp\ReconocimientoVoz\Video\hola.wmv");                  
            }

            else if (palabra.Text == "hola")
            {
                mediaPlayer.Source = new Uri(@"D:\PruebasCSharp\ReconocimientoVoz\Video\hola.wmv");
                //mediaPlayer.Play();
            }
        }
    }

When the condition is met it calls the video path but nothing is played in the MediaElement control.

I don't know what could be happening, it doesn't play anything? Do I need any extra configuration to the control or the form? I hope you can help me in advance thanks.

NOTE: I have carried out simple tests in which only the XAML is programmed and I have not been able to reproduce anything, that is why I think that some configuration must be missing both in the control or in the window (form). I can only hear the audio of the video but it does not show the images.

I am trying to persist against a MySql database using the Entity Framework the Code-First approach, I use in EF6 It does not give me an error, the problem is that it does not create the database or the table or add the records that I persist.

I show implementation code.

app.config

<configuration>


<configSections>
    <!-- For more information on Entity Framework configuration, visit http://go.microsoft.com/fwlink/?LinkID=237468 -->
    <section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false" />
  </configSections>
  <startup>
    <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.5.2" />
  </startup>
  <connectionStrings>
    <add name="DemoContext" providerName="MySql.Data.MySqlClient" connectionString="server=localhost;port=3306;database=demozmarket;uid=root;password=123456" />
  </connectionStrings>
  <entityFramework codeConfigurationType="DemoMySqlEntityFramework.MySqlEFConfiguration, DemoMySqlEntityFramework">
    <defaultConnectionFactory type="System.Data.Entity.Infrastructure.LocalDbConnectionFactory, EntityFramework" >
      <parameters>
        <parameter value="mssqllocaldb" />
      </parameters>
    </defaultConnectionFactory>
    <providers>
      <!--<provider invariantName="System.Data.SqlClient" type="System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer" />-->
      <provider invariantName="MySql.Data.MySqlClient"
              type="MySql.Data.MySqlClient.MySqlProviderServices, MySql.Data.Entity.EF6, Version=6.9.9.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d" />
    </providers>
  </entityFramework>
<system.data>
    <DbProviderFactories>
      <remove invariant="MySql.Data.MySqlClient" />
      <add name="MySQL Data Provider" 
           invariant="MySql.Data.MySqlClient" description=".Net Framework Data Provider for MySQL" type="MySql.Data.MySqlClient.MySqlClientFactory, MySql.Data, Version=6.9.9.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d" />
    </DbProviderFactories>
  </system.data>
</configuration>

Maps(Fluent Api)

namespace DemoMySqlEntityFramework.Data.Modelo.Maps
{
    public class ClienteMap : EntityTypeConfiguration<Cliente>
    {
        public ClienteMap()
        {
            ToTable("Clientes");
            HasKey(c => c.ClienteId);
            Property(c => c.ClienteId).HasDatabaseGeneratedOption(DatabaseGeneratedOption.Identity).HasColumnOrder(0);
            Property(c => c.RazonSocial).IsRequired().HasColumnType("varchar").HasMaxLength(100).HasColumnOrder(1);
            Property(c => c.Direccion).HasColumnType("varchar").HasMaxLength(100).HasColumnOrder(2);
            Property(c => c.Fecha).HasColumnOrder(3);
        }
    }
}

DbContext class

namespace DemoMySqlEntityFramework.Data.Modelo
{

    public class DemoContext : DbContext
    {
        public DemoContext() : base("DemoZMarket")
        {
            Configuration.LazyLoadingEnabled = false;
            Configuration.ProxyCreationEnabled = false;
        }

        public DbSet<Cliente> Clientes { get; set; }

        protected override void OnModelCreating(DbModelBuilder modelBuilder)
        {
            modelBuilder.Configurations.Add(new ClienteMap());
            base.OnModelCreating(modelBuilder);
            //modelBuilder.Entity<HistoryRow>().Property(h => h.MigrationId).HasMaxLength(100).IsRequired();
            //modelBuilder.Entity<HistoryRow>().Property(h => h.ContextKey).HasMaxLength(200).IsRequired();
        }
    }
}

Entities

public class Cliente
{
    public int ClienteId { get; set; }
    public string RazonSocial { get; set; }
    public string Direccion { get; set; }
    public DateTime? Fecha { get; set; }
}

repository

public class ClienteReposotory
{
    public void Create(Cliente entity)
    {
        using (var context = new DemoContext())
        {
            context.Clientes.Add(entity);
            context.SaveChanges();
        }
    }
}

I send you data

public partial class Form1 : Form
{
    private readonly ClienteReposotory _clienteReposotory = new ClienteReposotory();
    public Form1()
    {
        InitializeComponent();
    }

    private void Form1_Load(object sender, EventArgs e)
    {
        var cliente = new Cliente()
        {
            RazonSocial = "COMERCIAL PEPITO",
            Direccion = "MI CASA",
            Fecha = new DateTime(1976, 08, 10)
        };

        _clienteReposotory.Create(cliente);

    }
}

It gives me this error when I put in the console Enable-Migrations or any other migrations command.

PM> Enable-Migrations -ContextTypeName  "DemoContext" -

EnableAutomaticMigrations
Checking if the context targets an existing database...
System.NullReferenceException: Referencia a objeto no establecida como instancia de un objeto.
   en MySql.Data.MySqlClient.MySqlProviderServices.GetDbProviderManifestToken(DbConnection connection)
   en System.Data.Entity.Core.Common.DbProviderServices.GetProviderManifestToken(DbConnection connection)
   en MySql.Data.Entity.MySqlManifestTokenResolver.ResolveManifestToken(DbConnection connection)
   en System.Data.Entity.Utilities.DbConnectionExtensions.GetProviderInfo(DbConnection connection, DbProviderManifest& providerManifest)
   en System.Data.Entity.DbModelBuilder.Build(DbConnection providerConnection)
   en System.Data.Entity.Internal.LazyInternalContext.CreateModel(LazyInternalContext internalContext)
   en System.Data.Entity.Internal.RetryLazy`2.GetValue(TInput input)
   en System.Data.Entity.Internal.LazyInternalContext.InitializeContext()
   en System.Data.Entity.Internal.LazyInternalContext.get_ModelBeingInitialized()
   en System.Data.Entity.Infrastructure.EdmxWriter.WriteEdmx(DbContext context, XmlWriter writer)
   en System.Data.Entity.Utilities.DbContextExtensions.<>c__DisplayClass1.<GetModel>b__0(XmlWriter w)
   en System.Data.Entity.Utilities.DbContextExtensions.GetModel(Action`1 writeXml)
   en System.Data.Entity.Utilities.DbContextExtensions.GetModel(DbContext context)
   en System.Data.Entity.Migrations.DbMigrator..ctor(DbMigrationsConfiguration configuration, DbContext usersContext, DatabaseExistenceState existenceState, Boolean calledByCreateDatabase)
   en System.Data.Entity.Migrations.DbMigrator..ctor(DbMigrationsConfiguration configuration)
   en System.Data.Entity.Migrations.Design.MigrationScaffolder..ctor(DbMigrationsConfiguration migrationsConfiguration)
   en System.Data.Entity.Migrations.Design.ToolingFacade.ScaffoldRunner.Run()
   en System.AppDomain.DoCallBack(CrossAppDomainDelegate callBackDelegate)
   en System.AppDomain.DoCallBack(CrossAppDomainDelegate callBackDelegate)
   en System.Data.Entity.Migrations.Design.ToolingFacade.Run(BaseRunner runner)
   en System.Data.Entity.Migrations.Design.ToolingFacade.ScaffoldInitialCreate(String language, String rootNamespace)
   en System.Data.Entity.Migrations.EnableMigrationsCommand.<>c__DisplayClass2.<.ctor>b__0()
   en System.Data.Entity.Migrations.MigrationsDomainCommand.Execute(Action 

command)

**`Referencia a objeto no establecida como instancia de un objeto.`**

I work on a Windows Forms, C#, IoC ninject application. As the question says, get data from a grandchild form to the parent (from the parent a child form is called and this calls another form) and from the latter the data is taken and passed to the parent.

This is easy to solve using global variables, but it is bad programming practice.

What I was able to do is implement events under a Singleton pattern following this link to pass data between forms

Events

public static class CompleteEvent
{
    public delegate void CompleteHandler(CompleteEventArgs arg);
    public static event CompleteHandler Complete;
    public static event CompleteHandler PasarDosVariables;

    public static void RaiseEvent() { }
    public static void RaiseEvent(string strValor)
    {
        //if (Complete != null)
        //    Complete(new CompleteEventArgs());
        Complete?.Invoke(new CompleteEventArgs(strValor));
    }

    public static void RaiseEvent(int codigo, string valor)
    {
        PasarDosVariables?.Invoke(new CompleteEventArgs(codigo, valor));
    }
}

public class CompleteEventArgs : EventArgs
{
    public CompleteEventArgs() { }
    public CompleteEventArgs(string strValor)
    {
        StrValor = strValor;
    }

    public CompleteEventArgs(int codigo, string valor)
    {
        this.Codigo = codigo;
        this.StrValor = valor;
    }

    public int Codigo { get; set; }
    public string StrValor { get; set; }
}

CollectData

public class RecolectarDatos
{
    private static RecolectarDatos _datos;
    private RecolectarDatos()
    {

    }

    public static RecolectarDatos Instance()
    {
        //if (_controles == null)
        //    _controles = new ActivarControles();
        //return _controles;
        return _datos ?? (_datos = new RecolectarDatos());
    }

    public int Codigo { get; set; }
    public string StrValor { get; set; }
}

My code that gives me problems when I use the event CompleteEvent.PasarDosVariablesmore than once.

private void btnBuscarColor_Click(object sender, EventArgs e)
    {
        var argNombreEntidad = new ConstructorArgument("nombreEntidad", StrColour.NameEntity);
        var argT = new ConstructorArgument("t", EnumAsignacionTablas.Colour);
        var frm = CompositionRoot.Resolve<FrmInputBox>(argNombreEntidad, argT);
        CompleteEvent.PasarDosVariables -= CompleteEvent_PasarDosVariables;
        CompleteEvent.PasarDosVariables += CompleteEvent_PasarDosVariables;    
        frm.ShowDialog();
    }

    private void CompleteEvent_PasarDosVariables(CompleteEventArgs arg)
    {
        try
        {
            if (vBool)
            {
                if (arg.Codigo != 0 && !string.IsNullOrEmpty(arg.StrValor))
                {
                    if (DetalleItemColour.Count != 1)
                    {
                        var entity = new Colour()
                        {
                            ColourId = arg.Codigo,
                            Nombre = arg.StrValor
                        };
                        _detalleColour.Add(entity);
                        dgvColor.AutoGenerateColumns = false;
                        dgvColor.DataSource = DetalleItemColour;
                        CompleteEvent.RaiseEvent();
                        arg.Codigo = 0;
                        arg.StrValor = String.Empty;
                    }
                    else
                    {
                        MessageBoxEx.EnableGlass = false;
                        MessageBoxEx.Show(this, "Solo se permite un solo Color", StrColour.NameEntity,
                            MessageBoxButtons.OK, MessageBoxIcon.Information);
                        vBool = false;
                        arg.Codigo = 0;
                        arg.StrValor = String.Empty;
                    }
                }
            }
        }
        catch (Exception e)
        {
            MessageBoxEx.Show(this, $"Error:{e.Message}", "Error Inesperado", MessageBoxButtons.OK,
                MessageBoxIcon.Error);
        }
    }

private void txtMarca_KeyDown(object sender, KeyEventArgs e)
    {
        if (e.KeyCode == Keys.F3)
        {
            var argNombreEntidad = new ConstructorArgument("nombreEntidad", StrMarca.NameEntity);
            var argT = new ConstructorArgument("t", EnumAsignacionTablas.Marca);
            var frm = CompositionRoot.Resolve<FrmInputBox>(argNombreEntidad, argT);
            CompleteEvent.PasarDosVariables -= CompleteEvent_PasarDosVariables1;
            CompleteEvent.PasarDosVariables += CompleteEvent_PasarDosVariables1;
            frm.ShowDialog();
        }
    }

    private void CompleteEvent_PasarDosVariables1(CompleteEventArgs arg)
    {
        if (arg.Codigo != 0 && !string.IsNullOrEmpty(arg.StrValor))
        {
            txtMarcaId.Text = Convert.ToString(arg.Codigo);
            txtMarca.Text = arg.StrValor;
            CompleteEvent.RaiseEvent();
            arg.Codigo = 0;
            arg.StrValor = string.Empty;
        }
    }

The problem is that when I use an event, the other event is activated and messes up the data.

I work with ASP.NET MVC 5 I cannot show a popup modal form when I call it from a floating button it is shown and automatically closes the popup modal view is only seen for seconds. I show code.

HTML

<div class="contenedor">
            <button class="botonF1">
                <span>+</span>
            </button>
            <button class="btn botonF2">
                <span>+</span>
            </button>
            <button class="btn botonF3">
                <span>+</span>
            </button>
            <button class="btn botonF4">
                <span>+</span>
            </button>
            <button class="btn botonF5" onclick="llamarVistaParcial();" data-toggle="modal" data-target="#myModal">
                <span>+</span>
            </button>
        </div>

MODAL from Index

div id="myModal" class="modal fade in">
    <div class="modal-content" >
        <div class="modal-header" style="background-color: #337ab7;border-color:#2e6da4;color:#fff;">
            <button type="button" class="close" data-dismiss="modal">&times;</button>
            <h5 class="modal-title" >Proveedor</h5>
        </div>
        <div class="modal-body">
            <div id="resultado"></div>
        </div>
    </div>

CSS

*{


 margin:0;

    }
header{
  height:170px;
  color:#FFF;
  font-size:20px;
  font-family:Sans-serif;
  background:#009688;
  padding-top:30px;
  padding-left:50px;
}
.contenedor{
  width:90px;
  height:240px;
  position:absolute;
  right:0px;
  bottom:0px;
}
.botonF1{
  width:60px;
  height:60px;
  border-radius:100%;
  background:#F44336;
  right:0;
  bottom:0;
  position:absolute;
  margin-right:16px;
  margin-bottom:16px;
  border:none;
  outline:none;
  color:#FFF;
  font-size:36px;
  box-shadow: 0 3px 6px rgba(0,0,0,0.16), 0 3px 6px rgba(0,0,0,0.23);
  transition:.3s;  
}
span{
  transition:.5s;  
}
.botonF1:hover span{
  transform:rotate(360deg);
}
.botonF1:active{
  transform:scale(1.1);
}
.btn{
  width:40px;
  height:40px;
  border-radius:100%;
  border:none;
  color:#FFF;
  box-shadow: 0 3px 6px rgba(0,0,0,0.16), 0 3px 6px rgba(0,0,0,0.23);
  font-size:28px;
  outline:none;
  position:absolute;
  right:0;
  bottom:0;
  margin-right:26px;
  transform:scale(0);

    }
.botonF2{
  background:#2196F3;
  margin-bottom:85px;
  transition:0.5s;
}
.botonF3{
  background:#673AB7;
  margin-bottom:130px;
  transition:0.7s;
}
.botonF4{
  background:#009688;
  margin-bottom:175px;
  transition:0.9s;
}
.botonF5{
  background:#FF5722;
  margin-bottom:220px;
  transition:0.99s;
}
.animacionVer{
  transform:scale(1);
}

JS

$(document).ready(function () {
$('.botonF1').hover(function () {
    $('.btn').addClass('animacionVer');
})
$('.contenedor').mouseleave(function () {
    $('.btn').removeClass('animacionVer');
})
});

JS POPUP

<script>
            function llamarVistaParcial() {
                var laURLDeLaVista = '@Url.Action("CreatePV", "Proveedor")';
                $.ajax({
                    cache: false,
                    async: true,
                    type: "GET",
                    url: laURLDeLaVista,
                    data: {},
                    success: function (response) {
                        //$('#resultado').html('');
                        $('#resultado').html(response);
                    }
                });
                $("#myModal").modal('show');
            };
        </script>

What am I doing wrong?

I am working with ASP.NET MVC, I am creating my views from scratch to pure html, creating an empty view creates this for me.

@{
ViewBag.Title = "Proveedor";
}

<h2>Proveedor</h2>

But when creating html code I do this

   @{
    ViewBag.Title = "Proveedor";
}

<html xmlns="http://www.w3.org/1999/xhtml">
<head>
    <title></title>
</head>
<body>
    <h2>Proveedor</h2>

</body>
</html>

I would like to know if the part of the ViewBag goes outside the html or goes inside and if it goes inside, in which part does it go?

DDD ( Domain Driven Design ), is a set of patterns, principles and practices that help us solve and understand business problems (Domain) in the design of object-oriented systems. DDD is a very broad topic.

I have been using the N - Layers architecture from Windows Forms but in ASP.NET MVC I have a doubt since I am a beginner working on web systems.

Let's focus on the DDD architecture.

Let's go straight to the problem I have. Starting from the domain entities are objects that have an identity and are important within the business logic of our application, but they do not have to be known directly by other layers of the application.

This is the structure of my project.

I am using DTOs or Data Transfer Objects are classes whose main objective is to simplify the objects that are going to be exchanged between processes.

In the Application Layer , in which I have two projects: Application Services and Adapters .

• Adapters: This is where I have implemented my DTOs.
• Application Services: It is in this layer where I implement the application methods, since my Presentation Layer is ignorant of the Domain Layer and vice versa. Returning to the subject, it is in this layer where I do the magic that the Domain Entities become DTOs through AutoMapper.

Domain Entities.

public class Proveedor
{
    public int ProveedorId { get; set; }
    public string RazonSocial { get; set; }
    public string Direccion { get; set; }
}

DTO's

public class ProveedorDto
{
    [Key]
    public int ProveedorId { get; set; }

    [Display(Name = "Razón Social")]
    public string RazonSocial { get; set; }

    [Display(Name = "Dirección")]
    public string Direccion { get; set; }
}

Applying AutoMapper in Application Services.

public IEnumerable<ProveedorDto> GetAll()
    {
        IEnumerable<Proveedor> _proveedor = _sdProveedor.GetAll();
        config = new MapperConfiguration(cfg => cfg.CreateMap<Proveedor, ProveedorDto>());
        IEnumerable<ProveedorDto> listDto = config.CreateMapper().Map<IEnumerable<ProveedorDto>>(_proveedor);
        return listDto;
    }

In this way, my Domain Entities do not reach the Presentation Layer and the DTOs that are in the Adapters Layer are used as the Models of the MVC design pattern.

• Should I create the Models in the Presentation Layer, do I have to stick to the letter that the Models are implemented in that layer, as MVC says?
• How should I implement that part that I have explained, using good practices so that my architecture is neat?

When executing the following statement, the error occurs: Unabled to convert Date/time. I try to display the information that this query brings in a DataGridView.

SELECT codigo, nombre, marca, precio, CONVERT(fechaexpira, DATE)
FROM productos

How can I initialize an empty string whose value is "" but in this line of code:

Presenter.OnRazonSocialChanged(txtRazonSocial.Text);

I had solved it in the constructor of the Presenter in the following way:

public ProveedorPresenter(Proveedor model, ProveedorView view)
    {
        _model = model;
        _view = view;


        _model.RazonSocial = "";
        _model.DocumentoIdentidad = "";
        _model.Direccion = "";
        _model.Fijo = "";
        _model.Celular = "";
        _model.Representante = "";
        _model.Email = "";

        _view.Presenter = this;
    }

Without initializing the variables as empty, it gives me the following error:

As you will see I depend on the TextChanged event, what would be the solution?

Thank you all for answering, I promise to improve the quality of my questions and spend more time preparing them. Thanks to all of you I managed to solve it this way.

Create a method in the Presenter called Initialize Model

public void InicializarNodelo()
    {
        _model.RazonSocial = string.Empty;
        _model.DocumentoIdentidad = string.Empty;
        _model.Direccion = string.Empty;
        _model.Fijo = string.Empty;
        _model.Celular = string.Empty;
        _model.Representante = string.Empty;
        _model.Email = string.Empty;
    }

And I call it in the load of my View(form)

private void ProveedorView_Load(object sender, EventArgs e)
    {
        Presenter.InicializarNodelo();
    }

I am designing a business that deals with the sale of clothing in which I have to show a stock of clothing such as Model (pants, shorts, polo shirt), Color, Size and Quantity.

I have the following business entities:

• Product
• Size
• Colors
• ProductTalla: This entity allows me a many to many relationship with Product
• ProductColor: This entity allows me a many to many relationship with Product

So far I have already defined that a product has certain sizes and certain colors.

Now when I make the entry to the Warehouse I have to register by model, size, color and quantity example: Pioneer pants, size 30, blue color, quantity 15 ......

I have created the following business entities:

• Warehouse
• WarehouseDetail: In which it is related to Warehouse, Size, Color.

Create this entity because that's how I can when registering an entry to the Warehouse: Pioner pants, size 30, blue color, quantity 15...

1. What do you think about the WarehouseDetail entity and its relationships with Size and Color?
2. Do I need an Inventory entity that is related to Warehouse in order to know the stock?
3. Do Warehouse and Inventory record inputs and outputs?

But the Warehouse registers inputs to the Warehouse of a supposed purchase from Suppliers and registers outputs to other warehouses if it is a main warehouse or it can also be a single warehouse.

Inventory records expenses for each sale.

What is the responsibility of the Warehouse and Inventory entity?

I have a messaging class, in which I validate if any required field is empty or business rules which information by a string variable reaches the presentation.

public class Mensajeria
{
    Resto de código
}

My question is by implementing CustomException I can do the same and if the answer is yes how would the message get to the presentation layer having to go through the ApplicationService layer.

Hello, I am working with Entity Framework Code First, the environment is desktop (Windows Forms) and my query is the following.

I need to load a DataGridView with only two properties, id and description, can this select be done with linq?

The idea is to load only those two properties of the entity, not to bring me the entire entity. how can it be done via linq, using IEnumerable to fetch a list?

public IEnumerable<Proveedor> GetProveedor()
{
    //TO DO....
}

It's just a query that with what Leandro offers me is already solved, I just wanted to avoid creating an Extended Provider class where I put my ProviderId, Social Reason properties With this I would be able to solve that the rest of the columns are not brought to the DGV

I have some doubts that I would like to clarify, I have had bosses who have never wanted to work with ID Identity that is created by the same database manager, for the following reason that the correlative is lost. In my opinion the ID is not shown to the client so I should worry about showing it or it cannot be hidden.

There are developers who prefer to create their own ID giving the field size as 0001, 000001, etc.

Which of the two ways is a good programming practice? Create your own string type IDs with the size you want, is it from the time of the dinosaurs?

I am curious and I want to get rid of the doubt, in which cases a variable is declared in the following way:

public short? Secuendia {get; set;}

What does the question mark mean and in which cases the data type is accompanied by a character?