Efrain Mejias C's questions

I have a table that has a DATETIMEname type field AppointmentDatewhere it saves data with format 2022-07-27 21:32:54.420 and another field of TIMEname type EndHourand saves data with format 13:00:00.0000000.

So you needed a query to update the records where the date is Less than or Equal to field AppointmenDateand Greater than field EndHour.

I implemented this code, but it's not working for me, because what I needed was for it to compare AppointmentDateonly the date part against the field and EndHouronly the time part against the field. (I thought that only comparing AppointmentDate against the current date would do it but it doesn't work, you should also include the comparison against EndHour but I don't know how to do it)

UPDATE ScheduledVirtualAppointments SET  IdState = @idStateDone , DateUpdate = GETDATE(), IdUserUpdate = 1
WHERE AppointmentDate < GETDATE() AND 
IdState NOT IN (@idStateDone,@idStateRejection,@idStateCancellation,@idStateQuizAnswers)

How can i fix this?

I have an HTML table and needed to create a function that loops through it and gets the values ​​of the cells in each row.

Each cell contains its respective ID.

My HTML code:

<table id="tablaLineas" class="display compact dt-center table table-striped table-light" style="width:100%">
                <thead class="thead-dark">
                    <tr>
                        <th style="display:none;">Nº</th>
                        <th>Article</th>
                        <th>Unit</th>
                        <th>Description</th>
                        <th>Amount</th>
                        <th>Price</th>
                        <th>Subtotal</th>
                        <th></th>
                    </tr>
                </thead>
                <tbody>
                    <tr>
                    </tr><tr id="r0">
                  <td style="display:none;"> 0 </td>
                  <td id="r10"> TV </td>
                  <td id="r20"> UNIT </td>
                  <td id="r30"> Descripcion TV </td>
                  <td id="r40"> 23 </td>
                  <td id="r50"> 2 </td>
                  <td id="r60"> 46 </td>
                  <td><a href="javascript:void(0)" class="btn btn-sm btn-danger" onclick="RemoveLinea(0)"><small><i class="mdi mdi-delete-forever"></i></small></a></td>
                  </tr><tr id="r1">
                  <td style="display:none;"> 1 </td>
                  <td id="r11"> Laptop </td>
                  <td id="r21"> UNIT </td>
                  <td id="r31"> Descripcion laptop </td>
                  <td id="r41"> 10 </td>
                  <td id="r51"> 5 </td>
                  <td id="r61"> 50 </td>
                  <td><a href="javascript:void(0)" class="btn btn-sm btn-danger" onclick="RemoveLinea(1)"><small><i class="mdi mdi-delete-forever"></i></small></a></td>
                  </tr><tr id="r2">
                  <td style="display:none;"> 2 </td>
                  <td id="r12"> Telefono </td>
                  <td id="r22"> UNIT </td>
                  <td id="r32"> Descripcion laptop </td>
                  <td id="r42"> 3 </td>
                  <td id="r52"> 20 </td>
                  <td id="r62"> 60 </td>
                  <td><a href="javascript:void(0)" class="btn btn-sm btn-danger" onclick="RemoveLinea(2)"><small><i class="mdi mdi-delete-forever"></i></small></a></td>
                  </tr><tr id="r3">
                  <td style="display:none;"> 3 </td>
                  <td id="r13"> Memoria </td>
                  <td id="r23"> UNIT </td>
                  <td id="r33"> Descripcion Memora </td>
                  <td id="r43"> 15 </td>
                  <td id="r53"> 3 </td>
                  <td id="r63"> 45 </td>
                  <td><a href="javascript:void(0)" class="btn btn-sm btn-danger" onclick="RemoveLinea(3)"><small><i class="mdi mdi-delete-forever"></i></small></a></td>
                  </tr>
                </tbody>
            </table>

What does this code do?

I have googled, but I don't quite understand what it does and how it works?

 public void EntryCtrlFactura (RNFactura factura)
    {
     Entities db = new Entities();
                    ctrlFactura ctrlFactura = new ctrlFactura()
                    {
                        Id = factura.Id,
                        ProveedorId = factura.ProveedorId,
                        EstatusId = factura.EstatusId,
                        SNDistribuido = factura.SNDistribuido,
                        Referencia = factura.Referencia,
                        Importe = factura.Importe,
                        Impuesto = factura.Impuesto,
                        FechaRegistro = factura.FechaRegistro,
                        UsuarioReg = factura.UsuarioReg,
                        FechaEnvio = factura.FechaEnvio,
                        UsuarioEnv = factura.UsuarioEnv,
                        Observaciones = factura.Observaciones,
                        Concepto = factura.Concepto,
                        CveEmpresa = factura.CveEmpresa,
                        CveBodega = factura.CveBodega,
                        OcId = factura.OcId
                    };
                    using (var ctx = new Entities())
                    {
                        if (ctrlFactura.OcId == 0)
                        {
                            ctx.Entry(ctrlFactura).State = EntityState.Added;
                        }
                        else
                        {
                            ctx.Entry(ctrlFactura).State = EntityState.Modified;
    
                        }
                        ctx.SaveChanges();
                    }
    
                }
    }

I am developing an application where I get XML formatted strings so I have to serialize each string in its respective class.

What I want is to create a single method in which I can serialize these xml-formatted strings into their respective object class, obviously passing as a parameter the type of the class to serialize into.

My code:

public Invoice XML(string xml, out string Error)
    {
        Invoice comprobante = new Invoice();

        Error = "";
        try
        {
            XmlSerializer serializer = new XmlSerializer(typeof(Invoice));
            StringReader sXML = new StringReader(xml);
            comprobante = (Invoice)serializer.Deserialize(sXML);

        }
        catch (Exception ex)
        {
            Error = "Error en la Serialización" + ex.Message;
            comprobante = new Invoice();
        }
        return comprobante;

    }

I have this method to convert an image to a base 64 string and then assign it from JQuery to an image type tag... but I realized that it is only encoding the path of the image, when I decode I get something like this:

ClientApp/dist/assets/ProfileImageGirls/Avatar_56106a30-ce82-452e-9bfc-3861a1fc9069.JPG

How can I solve it?

Method:

   public string CodeBase64(string path)
        {
            string cadenaBase64 = string.Empty;
            using (Image image = Image.FromFile(path))
            {
                using (MemoryStream m = new MemoryStream())
                {
                    image.Save(m, image.RawFormat);
                    byte[] imageBytes = m.ToArray();
                    cadenaBase64 = Convert.ToBase64String(imageBytes);
                }
            }

            return cadenaBase64;
        }

How can I make this split that shows three buttons inline responsive (without using bootstrap)?

The problem is that when changing the screen resolution the buttons are not aligned

HTML code:

  <div aling="center" style="width:100%;">
        <div class="row" aling="center" style="display:inline;text-align:center; margin-left:25%">
            <button class="mainForm__total2" type="button" id="startWebCheckout2" tabindex="7"><b>Pagar con  Paypal</b></button>
            <button class="mainForm__total2" type="button" id="startWebCheckout" tabindex="8"><b>Pagar con otro medio de pago</b></button>
            <button class="mainForm__total2" type="button" id="startWebCheckout3" tabindex="9"><b>Pagar con  Pse</b></button>
        </div>
    </div>

CSS:

.mainForm__total2 {
    width: auto;
    background: #00BEFF;
    border: 1px solid #00BEFF;
    border-radius: 5px;
    color: #fff;
    margin: 30px auto;
    padding: 10px 20px;
    text-align: center;
    font-size: 25px;
    font-weight: 700;
    transition: .3s;
    display: inline;
}

    .mainForm__total2:hover {
        background: #fff;
        color: #00BEFF
    }

I am reading an Excel file in the following way and it works for me, but I always get this dialog that tells me if I want to save changes.

What can I do so that it does not appear?

C# code:

public List<Person> LeerArchivo(string pathArchivo , IEngineTool Tool)
        {
            Person p = new Person();
            List<Person> lp = new List<Person>();
            Excel.Application xlApp = new Excel.Application();
            Excel.Workbook xlWorkbook = xlApp.Workbooks.Open(pathArchivo);
            Excel._Worksheet xlWorksheet = xlWorkbook.Sheets[1];
            Excel.Range xlRange = xlWorksheet.UsedRange;
            int rowCount = xlRange.Rows.Count;
            int colCount = xlRange.Columns.Count;
            string strValue = string.Empty;

            for (int fila  = 2; fila <= rowCount; fila++)
            {
                for (int columna = 1; columna <= colCount; columna++)
                {
                    if (xlRange.Cells[fila, columna] != null && xlRange.Cells[fila, columna].Value != null)
                        strValue = strValue + xlRange.Cells[fila, columna].Value.ToString()  + "#" ;
                    else
                        strValue = strValue + "NO_DEFINIDO" + "#";
                }
                p=SetPerson(strValue);
                strValue = string.Empty;
            }

            GC.Collect();
            GC.WaitForPendingFinalizers();
            Marshal.ReleaseComObject(xlRange);
            Marshal.ReleaseComObject(xlWorksheet);
            xlWorkbook.Close();
            Marshal.ReleaseComObject(xlWorkbook);
            xlApp.Quit();
            Marshal.ReleaseComObject(xlApp);

            return lp;
        }

Dialog I need to remove:

I need to get the ID of the element when the TextBox gets focus and print it to the console . How can I do this? , I wrote some code but it always prints txt00

I have this in the HTML:

    <asp:TextBox ID="txt00" class="cTxt" runat="server"></asp:TextBox>        
 <asp:TextBox ID="txt01" class="cTxt" runat="server></asp:TextBox>
    <asp:TextBox ID="txt02" class="cTxt" runat="server"></asp:TextBox>

JQuery code:

 $('.cTxt').focus(function () {
            var id = $('.cTxt').attr('ID');
            console.log(id);
        });

I develop a web application and it needed to use push notifications, within the application and I am using Firebase for it… I can already use several of the functionalities.

Now you needed to retrieve records from the db.

This is how it sent the payload of the message

function SendNotify() {
    const txt = document.getElementById('msj');
    var notificationMessage = txt.value;

    if (!notificationMessage) return false;

    database.ref('/notifications')
        .push({
            user: auth.currentUser.displayName,
            message: notificationMessage,
            userProfileImg: auth.currentUser.photoURL,
            date: date
        })
        .then(() => {
            document.getElementById('msj').value = '';
        })
        .catch(() => {
            console.log("error enviando");
        });

    txt.value = '';   
}

and in the FireBase DB it looks like this:

I'm trying to try to take data from here and concatenate it to another message

I wrote this and it works but the DB fields arrive as undefined:

'use strict';
const functions = require('firebase-functions');
const admin = require('firebase-admin');
admin.initializeApp();

exports.Notifications = functions.database.ref('/notifications/{notificationId}')
    .onWrite(async (change, context) => {
        const user = context.params.user;
        const message = context.params.message;
        const userProfileImg = context.params.userProfileImg;
        const date = context.params.date;

        // Notification details.
        const payload = {
            notification: {
                title: `Test SocialWifi de: ${user}`,
                body: `Hoy: ${date} , Nuevo Mensaje  ${message}`,
                icons: `${userProfileImg}`,
                click_action: 'https://sudokudetodos.com'
            }
        };

        console.info(payload);

    });

I need to align the height of a button and a text box... How can I do it?

.round {
        background-color: transparent;
        width: auto;
        height: auto;
        margin: 0 auto 15px auto;
        padding: 5px;
        border: 1px solid silver;
        -moz-border-radius: 8px;
        -webkit-border-radius: 8px;
        border-radius: 8px;
        display: inline-block;
    }

<div class="pull-right">
    <form method="GET">
        <div style="display: inline-block ;">
            <input type="search" id="contractNumber" name="contractNumber" placeholder="Contract Number" class="round" />
            <input type="image" src="~/images/Lupa.jpg" width="30" height="30" />
        </div>
    </form>
</div>

Now it looks like this, the text box and the image of the magnifying glass should be at the same height...

On my server I do this:

 [HttpGet]
        public string GetSeleccionarTodasFilasTabla(string NombreTabla, string Version)
        {
            string resultado = string.Empty;
            Engine.EngineDb FuncionDb = new Engine.EngineDb();          
            int permiso = FuncionDb.PermisoSync(Version);
            if (permiso < 1)
            {
                return resultado = Engine.EngineData.SyncNoPermitida;
            }
            DataTable dt = new DataTable();
            dt = FuncionDb.SeleccionarTodasFilasTabla(NombreTabla);
            if (dt.Rows.Count != 0)
            {
                resultado = JsonConvert.SerializeObject(dt, Formatting.Indented);
            }
            else
            {
                resultado = Engine.EngineData.NoHayFilas;
            }
            return resultado;
        }

It returns a string like this

"[\r\n  {\r\n  \"IdAbono\": 1,\r\n    \"Nombre\": \"No abona\"\r\n  },
\r\n  {\r\n    \"IdAbono\": 2,\r\n    \"Nombre\": \"Abono orgánico\"\r\n  },
\r\n  {\r\n    \"IdAbono\": 3,\r\n    \"Nombre\": \"Fertilizante químico\"\r\n  },
\r\n  {\r\n    \"IdAbono\": 4,\r\n    \"Nombre\": \"Combinación\"\r\n  }\r\n]"

In my application I have this:

private void ClientGetTablaAbono(string RequestURI)
        {
            string resultado = string.Empty;
            HttpClient client = new HttpClient();
            client.BaseAddress = new Uri("http://localhost:52143/");
            client.DefaultRequestHeaders.Accept.Clear();
            client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
            HttpResponseMessage response = new HttpResponseMessage();
            response = client.GetAsync(RequestURI).Result;
            if (response.IsSuccessStatusCode)
            {
                resultado = response.Content.ReadAsStringAsync().Result;
                List<Abono> TAbono = new List<Abono>();

                //AQUI EL ERROR
                TAbono = JsonConvert.DeserializeObject<List<Abono>>(resultado);
            }
            else
            {
                resultado = response.IsSuccessStatusCode.ToString();
                richTextBox1.Text = resultado;
            }
        }

My Subscription Class is this:

  public class Abono
        {
            public int IdAbono { get; set; }

            public string Nombre { get; set; }
        }

MISTAKE

Newtonsoft.Json.JsonSerializationException: 'Error converting value "[
  {
    "IdAbono": 1,
    "Nombre": "No abona"
  },
  {
    "IdAbono": 2,
    "Nombre": "Abono orgánico"
  },
  {
    "IdAbono": 3,
    "Nombre": "Fertilizante químico"
  },
  {
    "IdAbono": 4,
    "Nombre": "Combinación"
  }
]" to type 'System.Collections.Generic.List`1[ApiRestConsumer.Form2+Abono]'. Path '', line 1, position 308.'

ArgumentException: Could not cast or convert from System.String to System.Collections.Generic.List`1[ApiRestConsumer.Form2+Abono].

To get the value of an element in XML document, I write something like this:

XmlNodeList nodo = documentoXml.GetElementsByTagName("Fecha");

This returns me a list of the elements with the specified name, and I can access their values ​​by their position in the list. For example:

string Fecha = nodo[0].InnerXml;

But if the element has children like the Detail element, how can I get their values? for instance:

 <?xml version="1.0" encoding="UTF-8"?>
-<FacturaElectronica xmlns="https://tribunet.hacienda.go.cr/docs/esquemas/2017/v4.2/facturaElectronica" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

<Clave>50628031800310140886100100001010000000003145592145</Clave>
<NumeroConsecutivo>00100001010000000003</NumeroConsecutivo>
<FechaEmision>2018-03-28T08:00:24-04:00</FechaEmision>

-<Emisor>
 <Nombre>NEOTECNOLOGIAS SA</Nombre>
-<Identificacion>
  <Tipo>02</Tipo>
  <Numero>3101408861</Numero>
</Identificacion>
<NombreComercial>NEOTECNOLOGIAS SA</NombreComercial>

-<Ubicacion>
  <Provincia>1</Provincia>
  <Canton>02</Canton>
  <Distrito>01</Distrito>
 <Barrio>01</Barrio>
  <OtrasSenas>CENTRO CORPORATIVO PLAZA ROBLE EDIFICIO LAS TERRAZAS 5TO   PISO</OtrasSenas>
</Ubicacion>

-<Telefono>
  <CodigoPais>506</CodigoPais>
  <NumTelefono>40701540</NumTelefono>
</Telefono>

-<Fax>
  <CodigoPais>506</CodigoPais>
  <NumTelefono>40701540</NumTelefono>
</Fax>
 <CorreoElectronico>[email protected]</CorreoElectronico>
</Emisor>

-<Receptor>
 <Nombre>Dental Care</Nombre>
-<Identificacion>
  <Tipo>02</Tipo>
  <Numero>3001123208</Numero>
</Identificacion>

<NombreComercial>Dental Care</NombreComercial>

-<Ubicacion>
  <Provincia>1</Provincia>
  <Canton>01</Canton>
  <Distrito>01</Distrito>
  <Barrio>01</Barrio>
  <OtrasSenas>Amon</OtrasSenas>
</Ubicacion>

-<Telefono>
  <CodigoPais>506</CodigoPais
  <NumTelefono>40701590</NumTelefono>
</Telefono>

-<Fax>
   <CodigoPais>506</CodigoPais>
   <NumTelefono>40701590</NumTelefono>
</Fax>
   <CorreoElectronico>[email protected]</CorreoElectronico>
</Receptor>
    </FacturaElectronica>

How can I get the values ​​of Number and Reference children of the Detail node?

I develop an application where I digitally sign an XML document, but I don't know how to add the Prefix (xs) to the nodes that the signature generates.

<xs:CanonicalizationMethod Algorithm="http://www.w3.org/2001/10/xml-exc-c14n#"/> 

My code:

 private string  FirmaXadesEPES(XmlDocument xmlDoc, X509Certificate2 certificate,string path)
    {
        error = string.Empty;
        idFirma = IdSignature();
        SignedXml signedXml = new SignedXml(xmlDoc);
        string URI = "http://uri.etsi.org/01903/v1.3.2#";
        try
        {
            signedXml.Signature.Id = "Id-" + idFirma;
            signedXml.SignedInfo.CanonicalizationMethod = SignedXml.XmlDsigExcC14NTransformUrl;
            signedXml.SignedInfo.SignatureMethod = "http://www.w3.org/2001/04/xmldsig-more#rsa-sha256";
            signedXml.SigningKey = certificate.PrivateKey;
            KeyInfo keyInfo = new KeyInfo();
            KeyInfoX509Data keyInfoX509Data = new KeyInfoX509Data(certificate, X509IncludeOption.ExcludeRoot);
            keyInfo.AddClause(keyInfoX509Data);
            signedXml.KeyInfo = keyInfo;
            //Reference 1
            Reference reference = new Reference();
            reference.Id = "r-id-" + idFirma;
            reference.Type = "";
            reference.Uri = "";
            XmlDsigXPathTransform XPathTransform = CreateXPathTransform("//. | //@* | //namespace::*", xmlDoc);
            reference.AddTransform(XPathTransform);
            reference.DigestMethod = "http://www.w3.org/2001/04/xmlenc#sha256";
            reference.AddTransform(new XmlDsigExcC14NTransform());
            signedXml.AddReference(reference);
            //Reference 2
            Reference reference2 = new Reference();
            reference2.Type = "http://uri.etsi.org/01903#SignedProperties";
            reference2.Uri = "";
            reference2.DigestMethod = "http://www.w3.org/2001/04/xmlenc#sha256";
            reference2.AddTransform(new XmlDsigExcC14NTransform());
            signedXml.AddReference(reference2);
            signedXml.ComputeSignature();

            XmlElement xmlDigitalSignature = signedXml.GetXml();
            xmlDoc.DocumentElement.AppendChild(xmlDoc.ImportNode(xmlDigitalSignature, true));
            bool checkSign = signedXml.CheckSignature();

        } catch (Exception ex) { error = ex.ToString(); }

        xmlDoc.Save(path);
        return error;
    }

Generated Signature:

<Signature xmlns="http://www.w3.org/2000/09/xmldsig#" Id="Id-37d3fd17-b0f9-48f0-add9-75a52bb9e83c-59880">
  <SignedInfo>
    <CanonicalizationMethod Algorithm="http://www.w3.org/2001/10/xml-exc-c14n#"/>
    <SignatureMethod Algorithm="http://www.w3.org/2001/04/xmldsig-more#rsa-sha256"/>
    <Reference Id="r-id-37d3fd17-b0f9-48f0-add9-75a52bb9e83c-59880" URI="">
      <Transforms>
        <Transform Algorithm="http://www.w3.org/TR/1999/REC-xpath-19991116">
          <XPath>//. | //@* | //namespace::*</XPath>
        </Transform>
        <Transform Algorithm="http://www.w3.org/2001/10/xml-exc-c14n#"/>
      </Transforms>
      <DigestMethod Algorithm="http://www.w3.org/2001/04/xmlenc#sha256"/>
      <DigestValue>HiOIkatoMGOfHDeUaCFmeWGrYOhHtkItSfRwvc/z5Vo=</DigestValue>
    </Reference>
    <Reference URI="" Type="http://uri.etsi.org/01903#SignedProperties">
      <Transforms>
        <Transform Algorithm="http://www.w3.org/2001/10/xml-exc-c14n#"/>
      </Transforms>
      <DigestMethod Algorithm="http://www.w3.org/2001/04/xmlenc#sha256"/>
      <DigestValue>HiOIkatoMGOfHDeUaCFmeWGrYOhHtkItSfRwvc/z5Vo=</DigestValue>
    </Reference>
  </SignedInfo>
  <SignatureValue>P3ElvXAHH1gXbcmiYCyl2OERHeeKOwOER7MFcBHRaYc47rhPmJQl99kiCo4kvXTEEonRVcNYe6jLSFy8bmXxlrLmQ4O5ju/7IOtZqPIcJpOvGQjKlCFw/o3lczynSuSR1sIGWiKe33wV4rahfc5N5dO8PVMSTAz2GgCrDFrVSAg7i4VmAyWoS45qrtgLwh+tIaX8Oc6zSwsiMbJUZ+k9GYFiO9FERoB5ww3AJenylL8wDo4wmGvaBuBjDU0+mgZyeutkgHA7Xge3MQ0QuuGm4FRtYR4itqGq1rnilHmhOxtvqyeNdipg5WKKhuQM55m2eQbdjVFPzC9nJTpIoW7X5g==</SignatureValue>
  <KeyInfo>
    <X509Data>
      <X509Certificate>MIIFajCCA1KgAwIBAgIGAV66vzIOMA0GCSqGSIb3DQEBCwUAMG4xCzAJBgNVBAYTAkNSMSkwJwYDVQQKDCBNSU5JU1RFUklPIERFIEhBQ0lFTkRBIC0gU0FOREJPWDEMMAoGA1UECwwDREdUMSYwJAYDVQQDDB1DQSBQRVJTT05BIEpVUklESUNBIC0gU0FOREJPWDAeFw0xNzA5MjUyMDM0MDVaFw0xOTA5MjUyMDM0MDVaMIGwMRkwFwYDVQQFExBDUEotMy0xMDEtNDA4ODYxMQkwBwYDVQQEDAAxKDAmBgNVBCoMH05FT1RFQ05PTE9HSUFTIFNPQ0lFREFEIEFOT05JTUExCzAJBgNVBAYTAkNSMRkwFwYDVQQKDBBQRVJTT05BIEpVUklESUNBMQwwCgYDVQQLDANDUEoxKDAmBgNVBAMMH05FT1RFQ05PTE9HSUFTIFNPQ0lFREFEIEFOT05JTUEwggEiMA0GCSqGSIb3DQEBAQUAA4IBDwAwggEKAoIBAQCqD5YGQLbE+vIdOUUVzNhTyJTyOPNv8FdnhOCQZD17onBQvP3KDhvOrkk86rPm9guDNeaSr6MyBWEKXLRUSgmePnO79wk/qT1YCX7eAb/tF85t9XSPofF9rjD4Nga2hR7eAYafMkY9gRZks3fUeYlqdhMtA0vkP+n0hlw/M2r8W1TV0dLbPME7suBEDkfS8VUnGG41u28yoZDpAfTe7Iudq5XZwCl8pAjCxM12h7ZhuhzOGCKU9G/zgLIsjF9MJRiPFHxhkcvaTkxXhqeznktqz7UxCZoAiswR3BmSw5UwrqX5aXdyPfOxYAlk4DxqT9xrZPq11OyMBHz5pltwILf1AgMBAAGjgcowgccwHwYDVR0jBBgwFoAUrChF+C+dSF8sHwCQ6zLFowdTgOEwHQYDVR0OBBYEFPFIA1BcM2QpB4RDynluWcys9YVMMAsGA1UdDwQEAwIGwDATBgNVHSUEDDAKBggrBgEFBQcDBDBjBggrBgEFBQcBAQRXMFUwUwYIKwYBBQUHMAKGR2h0dHBzOi8vcGtpLmNvbXByb2JhbnRlc2VsZWN0cm9uaWNvcy5nby5jci9zdGFnL2ludGVybWVkaWF0ZS1wai1wZW0uY3J0MA0GCSqGSIb3DQEBCwUAA4ICAQCq4i1kFGw2ZFDOwpYYEsi2NgoJK+Qxh0M0C9JLTRpzMLxVs6uCnVLfOzvIgAUwSy7RQB6RPXObLaXyH3noMz6XCLmYaMsk3qn53XAL+dVWLq9he7GUb266mjXeqc2/O0jDoYW5cHQZB/uopRFTJFLKYR1TsAr4myy6y2vURSdVQREIffPfXTdzT1dyZGv9qrnZ96q+leJ1XjOFyDVRwNWfy3gwd8ELxIjvTCZY2ww/1E9M1fBPicfyC3bmF5IVGFcqwf0DiIdouLsyxDwddN63I04nmWl0PkDd1oKU4Dx7jBBgl89yQRSYc1YLPw9EADq7LIJl5zBOdSwqYKWk0URzw9VCVuC9SDfEHeutOvV4LlZBupxpyRgWKQ93YoI4bccbweA35DpKIOhIciKDyZ4M9MoA0VycKOM3VjA1Zf7RQmwQ4N6cdryfhlf/MKhbdQr9Dekga7PsAcZ+TXCjv4jwvLpwhMZYRnqgHHh0gpkbCjXjlLPBb66wGBGvm4HzILYPQecbExEXPCdEVv2e4nW//mkFV+lGmvrcCTvNfUHonZpyzdEuXh5hx+YtJltqvNAlJ67YJh8pJkJyQx89RK0N8i6+lydYELBC8BwNXewqwAb+ojsysI1x4Oqes3pShIr3F6SFszwBJlcMCl8HRwvXIgGxKU102QZSREQKqNNXZQ==</X509Certificate>
      <X509Certificate>MIIGPDCCBCSgAwIBAgIEWKUUADANBgkqhkiG9w0BAQ0FADB5MQswCQYDVQQGEwJDUjEpMCcGA1UECgwgTUlOSVNURVJJTyBERSBIQUNJRU5EQSAtIFNBTkRCT1gxDDAKBgNVBAsMA0RHVDExMC8GA1UEAwwoQ0EgUkFJWiBNSU5JU1RFUklPIERFIEhBQ0lFTkRBIC0gU0FOREJPWDAeFw0xNzAyMTYwMjU0MDhaFw0zMjAyMTYwMjU0MDhaMG4xCzAJBgNVBAYTAkNSMSkwJwYDVQQKDCBNSU5JU1RFUklPIERFIEhBQ0lFTkRBIC0gU0FOREJPWDEMMAoGA1UECwwDREdUMSYwJAYDVQQDDB1DQSBQRVJTT05BIEpVUklESUNBIC0gU0FOREJPWDCCAiIwDQYJKoZIhvcNAQEBBQADggIPADCCAgoCggIBAL0juVK2X273h0mhsTHfTZJT92OHHZ/V0TxYk/MdlBfzR/vHBl8Unn6OPf36byrU7+y227N4tZBJfoJ+PRft+wZN4HKfABysHw3deR3fCeetcxuKVXboMQXqzQ/v8+gvWbk10Vh/5Ar/PfyaArNZL3WV6b7eZuQoZYh7310zrH4gW5c/oVSWzGfESskAwOb4PS5R196PpVA12axALp0SgZYzV551C44RRmo219XJdalEo1j3dOd/Moy34Yu7sIRNh5pIFhde7WsDQet/jjvbeFaTB2V+a5H4fWv4bbKQ3UiohDYwiGEwSjcFDlSk5WTpAuE8rRRKpmpBsVpK30vtsV0IbEPG2E1CLqHm2Qt5+FGevngFp7JSZw3WGSYsUMZwC15MBwG8SVdKaovnfEoCiT0BSn17ZkwocegZZEgJEmyxe1Qf+fiKPt6S8gVstDwNyY0o4SITAX9HKa/kVkm1E77zWmDUp4wfOCdVXJB6FaPcAO7oPfkB2qqbF6j6C0PTFOr2iV+jWfNQ6+018rVxbG2QY8uM9qz2ZQ838qA4w+xsVMosLOqVhF+t0VpYhxFYKCIXqZb+GB4iKFEgdSlo7pdVz/IXYLOTIxayLSbOStet64ixPSwq59UvhVcCS94riGc/lJj9c/iVCHCTyIz+ntCT6iewZQRQRUAPlQhBbk8HAgMBAAGjgdYwgdMwEgYDVR0TAQH/BAgwBgEB/wIBADCBkAYDVR0jBIGIMIGFoX2kezB5MQswCQYDVQQGEwJDUjEpMCcGA1UECgwgTUlOSVNURVJJTyBERSBIQUNJRU5EQSAtIFNBTkRCT1gxDDAKBgNVBAsMA0RHVDExMC8GA1UEAwwoQ0EgUkFJWiBNSU5JU1RFUklPIERFIEhBQ0lFTkRBIC0gU0FOREJPWIIEWKUQdDAdBgNVHQ4EFgQUrChF+C+dSF8sHwCQ6zLFowdTgOEwCwYDVR0PBAQDAgGGMA0GCSqGSIb3DQEBDQUAA4ICAQBrSW828HiLsXmxShXL29gmmOQ0LPwTlqQuD5HRD6ay2SjqxixIdLiImqddfRzSt6SXU0RsQzgEnX2/iREfIdDz0jAH2qgDNu/Z5dCqRGQ3ap/czvrpGMdC3ungvU5keRRRNRTkhhnwsRKo/Kz4FoBrPitJ0INxqy0zLLRo4/AKVQOUa2N0GmhV5t5l9RbJlnlhaEvlbI/swqRlYahgIDooKh2IYhhpX0G0YQsOZ4ZCSlfAomJUnvryVonziOvdHSDFCuVzqokg/EUMJk7RMrZ1M9OTc/6t7Io3n9Se5OWgH1H8k5bcwdG3xeJTRDtEyJQahyk6fXzo3YikhhqubngzNGzrD65t4H/g58stYUJf5mNPoJdgJIjPzbF00l2hkjNneB+gGnWRCfQnFOYDU5WmCjrepX+RIG1BwEuVa113lc3OFPBcNFOY5z2BSJKGQanAJPsFLLGU4foXXdv+cVAN7gKvXFl9kKGShdI07Dfmz2gY0f+L7795ZB8SAhyXgCd/jZH3Fz4ciLrxXnV4/hg7jjZ5dBwH7mFH/6ZD44sMtCC1SVL1mPvWagXlc+DWADdTaHfJCWITWCcQGQAgXeoqqVe7sCwGen07sKvhnt+VOusTmGhg2eOp/wZ37R4ILeGsvhSOB5kHRZnGqUrfPXlkFMgmgbsDSU5frxz49FtvYA==</X509Certificate>
    </X509Data>
  </KeyInfo>
</Signature>

I develop an application where I sign an XML document, in the following way, but I have to add the signature policy (Certificate provided by the company) and I don't know how to do it. This is how I sign the XML document:

public string  CreateCspParameters (string path)
        {
            error = "true";
            try
            {
                CspParameters cspParams = new CspParameters();
                cspParams.KeyContainerName = "XML_DSIG_RSA_KEY";
                RSACryptoServiceProvider rsaKey = new RSACryptoServiceProvider(cspParams);
                XmlDocument xmlDoc = new XmlDocument();
                xmlDoc.PreserveWhitespace = true;
                xmlDoc.Load(path);
                SignXml(xmlDoc, rsaKey);
                xmlDoc.Save(path);
            }
            catch (Exception ex) { error = ex.ToString(); }
            return error;
        }

        public void SignXml(XmlDocument xmlDoc, RSA Key)
        {
            if (xmlDoc == null)
                throw new ArgumentException("xmlDoc");
            if (Key == null)
                throw new ArgumentException("Key");

            SignedXml signedXml = new SignedXml(xmlDoc);
            signedXml.SigningKey = Key;
            Reference reference = new Reference();
            reference.Uri = "";
            XmlDsigEnvelopedSignatureTransform env = new XmlDsigEnvelopedSignatureTransform();
            reference.AddTransform(env);
            signedXml.AddReference(reference);
            signedXml.ComputeSignature();
            XmlElement xmlDigitalSignature = signedXml.GetXml();
            xmlDoc.DocumentElement.AppendChild(xmlDoc.ImportNode(xmlDigitalSignature, true));

        }

This way I can choose the certificate provided by the company but I don't know how to add it to the previous SignXml() method to complete the Xade-Epes

 public  X509Certificate2Collection ElejirCertificado()
        {

            X509Store store = new X509Store(StoreLocation.CurrentUser);
            store.Open(OpenFlags.ReadOnly | OpenFlags.OpenExistingOnly);

            X509Certificate2Collection certificates = store.Certificates;
            X509Certificate2Collection foundCertificates = certificates.Find(X509FindType.FindByTimeValid, DateTime.Now, false);
            X509Certificate2Collection selectedCertificates = X509Certificate2UI.SelectFromCollection(foundCertificates,
                "Selecciona un certificado.",
                "Selecciona un certificado de la siguiente lista:",
                X509SelectionFlag.SingleSelection);

            return selectedCertificates;
        }

When a textBox takes the focus a blinking bar appears... How can I make it not appear?

I need to insert an Amount in a text field ... when I leave that field, I must calculate the tax on that amount (tax = amount * 0.12) also the total ( total = amount + tax) and set these values ​​in other fields of text automatically.

HTML code

<input type="text" id="Monto" name="Monto" placeholder="Monto" onchange="CalculoIva()" required />
<input type="text" id="Iva" name="Iva" placeholder="Iva"  required />
<input type="text" id="Total" name="Total" placeholder="Total"  required />

I'm trying this but it doesn't work

 <script lang="javascript" type="text/javascript">
       var monto = 0;
       onchange = CalculoIva();
       function CalculoIva() {
           monto = document.getElementById('Monto').innerText ;
           var iva = parseFloat(monto) * 0.12;
           var total = parseFloat(monto) + parseFloat(iva);
           document.getElementById("Iva").innerHTML = iva.toString();
           document.getElementById("Total").innerHTML = total.toString();
       }
   </script> 

How can I create an Alert in JavaScript that is seen for 2 seconds and then closes automatically (only) without the user clicking accept?

I want to know how I can capture the event where the user tries to close the page.

Example: When we write an email and we have not sent it and we try to close that window, then it sends you a message asking you to confirm that you are going to leave the page.

The main idea of ​​creating this function is not to use vertical scrolling, and from a click event of a button or other control to execute said function and navigate to a label <div>or a <a> specific label that is on the same page.

I develop an ASP.NET WebForms application and I need that if the user has been authenticated in the browser with a Google account, they can access the page, otherwise not.