German AT's questions

I am making a query to a table of colonies and returning them in an API in JSON format

colonias = (from c in conn.Colonias
                        where c.CodigoPostal.Codigo == cp
                        && (bool)c.AuActivo
                        select c).ToList();
return colonias;

if it is returning the colonies:

The problem is that I am including the relations that EF is obtaining from those records:

should I create objects with the results that include only the information I need? or does anyone know a cleaner method?

I am modifying an ASPX application, I need to add a combo box with a certain data dictionary. basically duplicate the way in which the other columns were defined and create a data source like the ones that were already created, in my opinion, everything is the same... When running the application the new field appears, the combo box has the correct elements , but it doesn't allow me to select an element, almost as if it had the read only property. I can't find what the difference is, what should I do to make it editable? I share image and code.

<dx:ASPxGridView ID="ASPxGridView3" runat="server" AutoGenerateColumns="False" DataSourceID="eventos_dtl_com" OnDataBound="ASPxGridView3_DataBound" OnBeforeGetCallbackResult="ASPxGridView3_BeforeGetCallbackResult" SettingsPager-PageSizeItemSettings-ShowAllItem="true" SettingsPager-PageSizeItemSettings-ShowPopupShadow="true" KeyFieldName="serie_int;folio_int;pt;clavePed" OnBatchUpdate="ASPxGridView3_BatchUpdate"  OnRowUpdated="ASPxGridView3_RowUpdated" Theme="Office2010Black" OnHtmlDataCellPrepared="ASPxGridView3_HtmlDataCellPrepared" OnInitNewRow="ASPxGridView3_InitNewRow" OnCellEditorInitialize="ASPxGridView3_CellEditorInitialize">
 <SettingsPager AlwaysShowPager="True" NumericButtonCount="5">
    <PageSizeItemSettings ShowAllItem="True"></PageSizeItemSettings>
 </SettingsPager>
 <SettingsEditing Mode="Inline" EditFormColumnCount="10" UseFormLayout="False">
    <BatchEditSettings EditMode="Row" />
 </SettingsEditing>
 <Settings ShowGroupedColumns="True" ShowGroupFooter="VisibleAlways" ShowFooter="True" ShowStatusBar="Visible" ShowTitlePanel="True" />
 <SettingsBehavior AutoExpandAllGroups="True" AllowFixedGroups="True" AllowFocusedRow="True" ConfirmDelete="True" />
 <SettingsPopup>
    <EditForm AllowResize="True" />
 </SettingsPopup>
 <SettingsText Title="Facturas a a generar" />
 <Columns>
    <dx:GridViewCommandColumn ShowInCustomizationForm="True" VisibleIndex="0" ShowEditButton="True" ShowDeleteButton="True" ShowNewButtonInHeader="True"></dx:GridViewCommandColumn>
    <dx:GridViewDataTextColumn FieldName="partida" ShowInCustomizationForm="True" VisibleIndex="1" ReadOnly="True"></dx:GridViewDataTextColumn>
    <dx:GridViewDataTextColumn FieldName="serie_int" ShowInCustomizationForm="True" VisibleIndex="2" ReadOnly="True"></dx:GridViewDataTextColumn>
    <dx:GridViewDataTextColumn FieldName="folio_int" ShowInCustomizationForm="True" VisibleIndex="3" ReadOnly="True"></dx:GridViewDataTextColumn>
    <dx:GridViewDataTextColumn FieldName="pt" ShowInCustomizationForm="True" VisibleIndex="4" Width="150px"></dx:GridViewDataTextColumn>
    <dx:GridViewDataTextColumn FieldName="ptDesc" ShowInCustomizationForm="True" VisibleIndex="5" Width="200px"></dx:GridViewDataTextColumn>
    <dx:GridViewDataComboBoxColumn FieldName="clavePed" ShowInCustomizationForm="True" VisibleIndex="7">
        <PropertiesComboBox>
            <Items>
                 <dx:ListEditItem Text="Return" Value="RT" />
                 <dx:ListEditItem Text="Definitive" Value="A1" />
            </Items>
        </PropertiesComboBox>
    </dx:GridViewDataComboBoxColumn>
    <dx:GridViewDataComboBoxColumn FieldName="FraccionArancelaria" VisibleIndex="8">
        <PropertiesComboBox EnableSynchronization="False" DataSourceID="ComercioFraccion" ValueField="fraccion" TextField="descr"></PropertiesComboBox>
    </dx:GridViewDataComboBoxColumn>
    <dx:GridViewDataTextColumn FieldName="CantidadAduana" ShowInCustomizationForm="True" VisibleIndex="9" UnboundType="Decimal">                                                              
        <PropertiesTextEdit DisplayFormatString="{0:0.000}" DisplayFormatInEditMode="True"></PropertiesTextEdit>
    </dx:GridViewDataTextColumn>
    <dx:GridViewDataComboBoxColumn FieldName="UnidadAduana" VisibleIndex="10">
        <PropertiesComboBox EnableSynchronization="False" DataSourceID="ComercioUnidad" ValueField="UnidadAduana" TextField="Unidad"></PropertiesComboBox>
    </dx:GridViewDataComboBoxColumn>
    <dx:GridViewDataTextColumn FieldName="ValorUnitarioAduana" ShowInCustomizationForm="True" VisibleIndex="11">
        <PropertiesTextEdit DisplayFormatInEditMode="True" DisplayFormatString="{0:0.00}"></PropertiesTextEdit>
    </dx:GridViewDataTextColumn>
    <dx:GridViewDataTextColumn FieldName="ValorDolares" ShowInCustomizationForm="True" VisibleIndex="12" ReadOnly="True">
        <PropertiesTextEdit DisplayFormatInEditMode="True" DisplayFormatString="{0:0.00}"></PropertiesTextEdit>
    </dx:GridViewDataTextColumn>
    <dx:GridViewDataComboBoxColumn FieldName="ClaveUnidad" VisibleIndex="6">
        <PropertiesComboBox EnableSynchronization="False" DataSourceID="CfdiClaveUnidad" ValueField="clave" TextField="descr"></PropertiesComboBox>
    </dx:GridViewDataComboBoxColumn>
 </Columns>

I show the combo box displayed, and even so it does not allow selecting elements:

I am trying to create a web report in an .aspx page, the report template is a .rdlc file. When I run the app, I fill a bar chart with the same Datasource I use for the report, however my report gets stuck on loading calling the app again as if it were refreshing the page:

The code with which I fill the report is as follows:

DataTable datos = new DataTable();
            string cs = ConfigurationManager.ConnectionStrings["OCEntities"].ConnectionString;
            using (SqlConnection con = new SqlConnection(cs))
            {
                SqlCommand comm = new SqlCommand("select * from Vista_ReporteCompras ", con);
                SqlDataAdapter da = new SqlDataAdapter(comm);
                da.Fill(datos);
            }
            visor.ProcessingMode = ProcessingMode.Local;
            visor.LocalReport.ReportPath = Server.MapPath("Plantilla.rdlc");
            ReportDataSource datasource = new ReportDataSource("Datos", datos);
            visor.LocalReport.DataSources.Clear();
            visor.LocalReport.DataSources.Add(datasource);
            cargar = false;

Do you have an idea how to fix it?

I am working with Visual Studio 2017. Add a ReportViewer control to a form and it is not displayed on the form itself.

I see that the solution adds the necessary references, the control is seen in the document outline and it adds a bottom bar, I imagine to control the reports it shows, but the control itself in the form remains absent.

And tried adding the control from extensions and updates, adding Microsoft's RDLC report designer. Also from the NuGet package manager adding Microsoft.ReportingServices.ReportViewerControl.Winforms and then adding its library to the project but in both cases the result is the same, the control is not displayed.

There are already some questions created related to this, however none has a solution yet, perhaps it was necessary to be more explicit. does anyone have an idea how to fix it?

I include this image showing that the control is available in the IDE.

I include the view of elements to add in the toolbox.

I have a table with fields of PROSPECTS such as name, address, telephone etc...

One of the fields is the CURP and I want this column to contain unique data. The problem arises in that the records of prospects in this table are natural and legal persons, so not all of them have CURP, so the UNIQUE restriction does not work for me because although it accepts null values, it only accepts a null value in the entire column .

It occurs to me that I could define a condition with the CHECK constraint but I haven't found how to compare it with the other records in the table, only with the record that is entered.

Is it possible to generate this validation?

I'm trying to load images at runtime and each one is selected by a switch:

seguimiento.tareaA = new Image();
switch (rowTarea["idTareaTipo"].ToString())
                    {
                        case "f7f91a6f-24a2-1034-b505-d1f8671a4f3f"://Seguimiento
                            Uri uri = new Uri("pack://application:,,,/Resources/Seguim_Chico__0000_6_Pago_Rojo.png");
                            BitmapImage bmp = new BitmapImage(uri);
                            seguimiento.tareaA.Source = bmp;
                            break;

When running the program, it does not give errors but the images are not loaded either... I tried to debug and the only strange thing I found was an error in the Metadata when creating the BitmapImage:

How can I fix the error or make the image display?

I am developing a solution that queries PDF records from a WEB service. The result of consuming this service can be encrypted and stored as a PDF:

File.WriteAllBytes(Environment.GetFolderPath(Environment.SpecialFolder.Desktop) + "\\prueba_" + cf.id_identificador + ".pdf", Convert.FromBase64String(tRespuesta.PDFResultado));

This PDF must be sent by email, which could be done by attaching it with the same path that was saved...

But saving the file and then consulting it increases the time a lot when the number of times this process is repeated is very large.

Is there a way to directly attach the webservice result without saving the file?

MailMessage email = new MailMessage();
email.To.Add(new MailAddress(destino));
email.From = new MailAddress("[email protected]");
email.Subject = "Asunto( " + DateTime.Now.ToString("dd / MMM / yyy hh:mm:ss") + " ) ";
//email.Attachments.Add();
email.Body = "Do not reply.";
email.IsBodyHtml = false;
email.Priority = MailPriority.High;

I am creating a module to be able to generate the XML files of a CFDI. One of the points is to generate a digital stamp, I have followed the steps of different guides that describe in different languages ​​the process that you must have with the algorithms SHA-1and RSA.

In my code, I even have two processes implemented, one with the library opensslkeyand one with native C# libraries, both return the same result. The problem is that the validators tell me that the seal is malformed or invalid.

Do you have any idea why that could be? (following my code).

private string generaSello()
{
    string strSello = string.Empty;
    string strPathLlave = CFDI.Properties.Settings.Default.llave;
    string strLlavePwd = CFDI.Properties.Settings.Default.clave;
    string strCadenaOriginal = generaCadena(); // Aquí ya haber generado la cadena original

    System.Security.SecureString passwordSeguro = new System.Security.SecureString();
    passwordSeguro.Clear();

    foreach (char c in strLlavePwd.ToCharArray())
        passwordSeguro.AppendChar(c);

    byte[] llavePrivadaBytes = System.IO.File.ReadAllBytes(strPathLlave);
    RSACryptoServiceProvider rsa = opensslkey.DecodeEncryptedPrivateKeyInfo(llavePrivadaBytes, passwordSeguro);

    SHA1Managed sha = new SHA1Managed();
    UTF8Encoding encoding = new UTF8Encoding();
    byte[] bytes = encoding.GetBytes(generaCadena());
    byte[] digest = sha.ComputeHash(bytes);

    RSAPKCS1SignatureFormatter RSAFormatter = new RSAPKCS1SignatureFormatter(rsa);
    RSAFormatter.SetHashAlgorithm("SHA1");
    byte[] SignedHashValue = RSAFormatter.CreateSignature(digest);

    SHA1CryptoServiceProvider hasher = new SHA1CryptoServiceProvider();

    byte[] bytesFirmados = rsa.SignData(System.Text.Encoding.UTF8.GetBytes(strCadenaOriginal), hasher);
    strSello = Convert.ToBase64String(bytesFirmados);  // Y aquí está el sello
    string r = Convert.ToBase64String(SignedHashValue);// Y aquí está el sello 2 

    return strSello;
    //return r;
}

This is an example of the formed XML:

<?xml version="1.0" encoding="UTF-8"?>
<cfdi:Comprobante xmlns:cfdi="http://www.sat.gob.mx/cfd/3" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.sat.gob.mx/cfd/3 http://www.sat.gob.mx/sitio_internet/cfd/3/cfdv32.xsd" version="3.2" folio="0" fecha="2017-04-18T18:19:17" sello="iMTGK5FHmLpudWYIxLP99/h44JMErjg1bNLtblp/YvVAVTPMiMlwEF9Y+44wHOVeQ2u36xnl1aVVCL9T8fyUQwFRCmd9PtFWdAmSQrpHK914gomk31W+Hunrdrwj0Asewyn/wl1fVaJbeV2R0cVsdvrWJXhx3YguJPmyvrE+u7U=" formaDePago="0" noCertificado="20001000000200001428" certificado="MIIEYTCCA0mgAwIBAgIUMjAwMDEwMDAwMDAyMDAwMDE0MjgwDQYJKoZIhvcNAQEFBQAwggFcMRowGAYDVQQDDBFBLkMuIDIgZGUgcHJ1ZWJhczEvMC0GA1UECgwmU2VydmljaW8gZGUgQWRtaW5pc3RyYWNpw7NuIFRyaWJ1dGFyaWExODA2BgNVBAsML0FkbWluaXN0cmFjacOzbiBkZSBTZWd1cmlkYWQgZGUgbGEgSW5mb3JtYWNpw7NuMSkwJwYJKoZIhvcNAQkBFhphc2lzbmV0QHBydWViYXMuc2F0LmdvYi5teDEmMCQGA1UECQwdQXYuIEhpZGFsZ28gNzcsIENvbC4gR3VlcnJlcm8xDjAMBgNVBBEMBTA2MzAwMQswCQYDVQQGEwJNWDEZMBcGA1UECAwQRGlzdHJpdG8gRmVkZXJhbDESMBAGA1UEBwwJQ295b2Fjw6FuMTQwMgYJKoZIhvcNAQkCDCVSZXNwb25zYWJsZTogQXJhY2VsaSBHYW5kYXJhIEJhdXRpc3RhMB4XDTEzMDUwNzE2MDEyOVoXDTE3MDUwNzE2MDEyOVowgdsxKTAnBgNVBAMTIEFDQ0VNIFNFUlZJQ0lPUyBFTVBSRVNBUklBTEVTIFNDMSkwJwYDVQQpEyBBQ0NFTSBTRVJWSUNJT1MgRU1QUkVTQVJJQUxFUyBTQzEpMCcGA1UEChMgQUNDRU0gU0VSVklDSU9TIEVNUFJFU0FSSUFMRVMgU0MxJTAjBgNVBC0THEFBQTAxMDEwMUFBQSAvIEhFR1Q3NjEwMDM0UzIxHjAcBgNVBAUTFSAvIEhFR1Q3NjEwMDNNREZOU1IwODERMA8GA1UECxMIcHJvZHVjdG8wgZ8wDQYJKoZIhvcNAQEBBQADgY0AMIGJAoGBAKS/beUVy6E3aODaNuLd2S3PXaQre0tGxmYTeUxa55x2t/7919ttgOpKF6hPF5KvlYh4ztqQqP4yEV+HjH7yy/2d/+e7t+J61jTrbdLqT3WD0+s5fCL6JOrF4hqy//EGdfvYftdGRNrZH+dAjWWml2S/hrN9aUxraS5qqO1b7btlAgMBAAGjHTAbMAwGA1UdEwEB/wQCMAAwCwYDVR0PBAQDAgbAMA0GCSqGSIb3DQEBBQUAA4IBAQACPXAWZX2DuKiZVv35RS1WFKgT2ubUO9C+byfZapV6ZzYNOiA4KmpkqHU/bkZHqKjR+R59hoYhVdn+ClUIliZf2ChHh8s0a0vBRNJ3IHfA1akWdzocYZLXjz3m0Er31BY+uS3qWUtPsONGVDyZL6IUBBUlFoecQhP9AO39er8zIbeU2b0MMBJxCt4vbDKFvT9i3V0Puoo+kmmkf15D2rBGR+drd8H8Yg8TDGFKf2zKmRsgT7nIeou6WpfYp570WIvLJQY+fsMp334D05Up5ykYSAxUGa30RdUzA4rxN5hT+W9whWVGD88TD33Nw55uNRUcRO3ZUVHmdWRG+GjhlfsD" subTotal="1" TipoCambio="1.00" Moneda="Peso Mexicano" total="1" tipoDeComprobante="ingreso" metodoDePago="02,99" LugarExpedicion="Av. Cerro Gordo del Campestre 201 301, Las Quintas, 37125, León, León de los Aldama, Guanajuato, México" NumCtaPago="NO IDENTIFICADO">
    <cfdi:Emisor rfc="DRD091113A70" nombre="DESARROLLOS RESIDENCIALES DE LEON SA DE CV">
        <cfdi:DomicilioFiscal calle="Av. Cerro Gordo del Campestre" noExterior="201" noInterior="301" colonia="Las quintas" localidad="León de los Aldama" municipio="León" estado="Guanajuato" pais="México" codigoPostal="37125" />
        <cfdi:RegimenFiscal Regimen="PERSONA MORAL REGIMEN GENERAL" />
    </cfdi:Emisor>
    <cfdi:Receptor rfc="AAHA6301152K1" nombre="ABRAHAM ARAIZA HERNANDEZ">
        <cfdi:Domicilio calle="VIA AUREA" noExterior="440" colonia="VILLA MAGNA" municipio="SAN LUIS POTOSÍ" estado="SAN LUIS POTOSÍ" pais="MEXICO" codigoPostal="78413" />
    </cfdi:Receptor>
    <cfdi:Conceptos>
        <cfdi:Concepto cantidad="1" unidad="NO APLICA" descripcion="VENTA DE TERRENO&amp;#xA;LOTE 36 MZ 64 DE LA PRIVADA MAYORAZGO LA GAVIA DE CONFORMIDAD CON EL FIDEICOMISO DE BANCO DEL BAJIO NO. 10153-10-34 DE FECHA 24 DE ENERO DE 2011" valorUnitario="1" importe="1" />
    </cfdi:Conceptos>
    <cfdi:Impuestos />
</cfdi:Comprobante>

I have the following code:

var vistaRecibos = (from r in ctx.RECIBOSPAGO_DETALLE_GENERAL
                                  select new
                                  {
                                      r.idrecibopago,
                                  });

                var vistaAsientos = (from a in ctx.ASIENTO_CONTABLE
                                  select new
                                  {
                                      a.idrecibopago,
                                  });

                vistaRecibos = vistaRecibos.Except(vistaAsientos);

Which gives me error:

Error 71 Type arguments to method 'System.Linq.Enumerable.Except(System.Collections.Generic.IEnumerable, System.Collections.Generic.IEnumerable)' cannot be inferred from usage. Try specifying the type arguments explicitly. C:\Users\German\Desktop\SAM Administrative\Leon\SAM1\Contabilidad\frmExportarAsientosContables.cs 461 36 sammayorazgo

I have used this comparison in other solutions and it does not give me an error (even the extra comma does not cause conflicts, and if I remove it, the problem continues).

Does anyone know how to fix it?

I am trying to make a join between tables using linq where the key that joins them must be composed of two fields

var devengados = (from inten in ctx.INTENCIONES
                  join contr in ctx.CONTRATOS on inten.intencion_id equals contr.intencion_id
                  join intFin in ctx.INTENCIONES_FINANCIAMIENTO on new { inten.intencion_id, inten.orden } equals new { intFin.intencion_id, intFin.orden }
                  where contr.contrato_id == iContratoId
                  select new { inten, contr, intFin }).First();

With this structure I have an error in the join of intFin:

Error 31 The type of one of the expressions in the join clause is incorrect. Type inference failed in the call to 'Join'.

In a simple page in VB ASP.NET I get an error with the connection to SQL:

OLE DB multi-step operation generated errors. Check the OLE DB status values ​​if possible. No work was done.

I am new to the VB language, here is a sample of my code

 <%@ Page  aspcompat=true Language="vb" AutoEventWireup="false" CodeBehind="buscar.aspx.vb" Inherits="buscador_yuyin.WebForm1" %>

Seeker

Results obtained with <%=Request("Word") %>

<% 
    Dim Conexion, Tabla

    Conexion = Server.CreateObject("adodb.connection")
    Tabla = Server.CreateObject("adodb.recordset")
    Conexion.ConnectionString = "PROVIDER=SQLOLEDB;Data Source=TEST-PC\VIRTUAL;DATABASE=prueba;Integrated Security=True"
    Conexion.open()

    Dim Temp
    Temp = "Select * From busqueda('" & Request("palabra") & ")'"

    Tabla.Open(Temp, Conexion)

    If Tabla.BOF And Tabla.EOF Then
%> 
    <p><font face="Tahoma" size="2">No se ha encontrado nada con <strong><%=Request("palabra")%></strong> en la Base de Datos</font></p> 

<% 
    Else
%> 
   <div align="center"><center> 
   <table border="1" cellpadding="0" cellspacing="0" width="100%" height="74" bordercolor="#C0C0C0"> 
   <tr> 
       <td width="28%" height="19"> 
       <p align="center"><strong><font face="Tahoma" size="2">Categoria</font></strong> 
    </td> 
    <td width="28%" height="19"> 
       <p align="center"><strong><font face="Tahoma" size="2">Producto</font></strong></p> 
    </td> 
    <td width="52%" height="19"> 
       <p align="center"><strong><font face="Tahoma" size="2">Descripcion</font></strong> 
    </td> 
    <td width="19%" height="19"> 
       <p align="center"><strong><font face="Tahoma" size="2">Url</font></strong></p> 
    </td> 
   </tr> 
   <% While Not Tabla.EOF%> 
      <tr> 
       <td width="28%" bgcolor="#FFCC00" height="51"> 
          <p align="center"><font face="Tahoma" size="2"><%=Tabla.Fields("Categoria")%></font></td> 
       <td width="28%" bgcolor="#FFCC00" height="51"> 
          <p align="center"><font face="Tahoma" size="2"><%=Tabla.Fields("Nombre")%></font></td> 
       <td width="52%" bgcolor="#FFCC00" height="51"> 
          <p align="center"><font face="Tahoma" size="2"><%=Tabla.Fields("Descripcion")%></font></td> 
       <td width="19%" bgcolor="#FFCC00" height="51"> 
          <p align="center"><a href="<%=Tabla.Fields("url")%>"><font face="Tahoma" size="2">Img</font></a> 
      </tr> 
<% 
            Tabla.MoveNext
        End While
        Tabla.Close
        Conexion.Close
    End If
%> 
</table> 
</center></div> 
<p align="center"><font face="Tahoma" size="2">Busquedas</font></p> 
<p align="center"><font face="Tahoma" size="2">2002</font></p> 
<p align="center"> </p> 
</body> 

In a simple query, I have a table with the following structure:

SELECT * FROM [SAMX].[dbo].[REPORTE_ESTADO_CUENTA_GLOBAL] where intencion_id=1657 ORDER BY intencion_id,fecha

I need to fill the account column with a '0' or a '1' depending on whether the query contains an initial charge of the contract as follows: - if it does not, account must be '0' - if it does, you must check the status of that record - if status is 'C', account should still be '0' - if status is '', account should be '1', and all records thereafter, account should be '1' '

I tried using a variable, but I can't combine a SELECTvalue assignment with a data fetch.

DECLARE @var1 int;
select @var1=0;  
SELECT  @var1=(CASE tipomovimiento WHEN 'Cargo Inicial del Contrato' THEN 1 ELSE 0 END)
      ,@var1 AS cuenta,[fecha],[tipomovimiento],[abono],[cargo],[estatus],[intencion_id] FROM REPORTE_ESTADO_CUENTA_GLOBAL  where intencion_id=1657 ORDER BY intencion_id,fecha

Could you suggest me a solution?

The expected result would be like this:

I am using SQL 2008 to query using inner join:

SELECT t2.intencion_id,t2.numpago,t3.orden,t2.importe
  ,SUM([importeaplicado]) AS importeaplicado
  ,t3.intfinanciamiento_interes
  ,t1.[estatus] FROM [APLICACIONES] as t1
inner join movcargos as t2 on t1.idmovcargo=t2.idmovcargo 
inner join intenciones_financiamiento as t3 on (t2.intencion_id=t3.intencion_id and t2.numpago=t3.intFinanciamiento_pagoNumero) where t2.idtipomovimiento=1 and t1.estatus='A' GROUP BY t2.intencion_id,numpago,importe,t1.estatus,intfinanciamiento_interes,t3.orden order by intencion_id,numpago,orden desc

among the columns that this query returns, there are 3 that are repetitive series: intention_id, numpago and order but I want it to show the records of all the intention_id, all the numpago but only the highest order

How can I do this filtering?