Marc's questions

I am developing a function that, passing a number, formats it with the thousands separators and the decimal separators (if it has them) taking into account the cultural information of the user in question, and I have the following problem:

I have this piece of code:

public string FormatearNumero(object Num)
{
    CultureInfo Culture = new CultureInfo("en-EN", false);
    NumberStyles NStyle = NumberStyles.AllowDecimalPoint | NumberStyles.AllowThousands | NumberStyles.AllowLeadingSign;

    string Numero = Num.ToString();

    if (decimal.TryParse(Numero, NStyle, Culture, out decimal result))
    {
        if (result == 0)
            return Numero;

        Numero = result.ToString("###" + Culture.NumberFormat.NumberGroupSeparator + "###" + Culture.NumberFormat.NumberDecimalSeparator + "####", Culture);
    }
    return Numero;
}

To format the number I use the typical one .ToString("###.###,###")but in this case applying in the thousands separators the one that corresponds to it by cultural reference and the same for the decimal separator.

result.ToString("###" + Culture.NumberFormat.NumberGroupSeparator + "###" + Culture.NumberFormat.NumberDecimalSeparator + "####", Dades.Culture)

Applying this portion of code with culture en-ENI get the following results:

//Culture.NumberFormat.NumberGroupSeparator tiene el valor ','
//Culture.NumberFormat.NumberDecimalSeparator tiene el valor '.'

FormatearNumero("-98745618451.6513") --> "-98,745,618,451.6513"

Instead, when I change the cultural reference and put it, for example, es-ESthe following happens:

//Culture.NumberFormat.NumberGroupSeparator tiene el valor '.'
//Culture.NumberFormat.NumberDecimalSeparator tiene el valor ','
FormatearNumero("-98745618451,6513") --> "-98745618451,6513"

It does not apply the formats correctly for some cultures, but for others it does.

I have tried to search for information about it but I have not found anything, and on the pages of Microsoftthey do not indicate anything to take into account when applying these formats.

Could someone tell me where the problem could be?

I have a database MySQLwith the engine InnoDB, which, some tables are very large (approximately 30GB each).

When making one Backupor one Restoreof those tables from the Base de Datos, I have the problem that it takes a long time to restore the copy using Dump.

Is there any way to be able to perform the Backupsand Restoresof those tables very quickly?

NOTE:

This question is referenced from the next one, but with a different database storage engine.

I am developing a Setup for some applications and I use SelfExtractor to unzip the files and then run the program that installs and configures the application through PostExtractCommandLine.

The problem I have is that I cannot find a way to display a progress window when the files are being decompressed, the only thing I have achieved is that the list of files that are being decompressed appears, but it does not report how much remains to finish (in % or in time).

My code:

private static void createSetup(string sVersion, string sModule, string sSetupExeName, 
    string sDescription, string sPathIn, string sPathOut, 
    string PostExtractCommandLineParams, string[] sInterfaces, string sInterfaceFile, 
    string[] sLanguages, string sLanguage)
{
    CultureInfo ci = new CultureInfo("en-US");
    string nameComponentProduct = sSetupExeName.Replace(".exe", "");

    Console.WriteLine("");
    Console.WriteLine("Starting " + sModule + "-" + sSetupExeName + "-" + 
        PostExtractCommandLineParams + "-" + sLanguage);

    oFvi = FileVersionInfo.GetVersionInfo(Path.Combine(sPathIn, sSetupExeName));
    SelfExtractorSaveOptions options = new SelfExtractorSaveOptions
    {
        //AdditionalCompilerSwitches = "",
        Copyright = String.Format(oFvi.LegalCopyright, P.Year, P.Company),
        DefaultExtractDirectory = "",
        Description = oFvi.FileDescription,
        ExtractExistingFile = ExtractExistingFileAction.OverwriteSilently,
        FileVersion = new Version(P.Version),
        Flavor = SelfExtractorFlavor.ConsoleApplication,
        IconFile = "icono.ico",
        PostExtractCommandLine = (oFvi.OriginalFilename + " " +  
            PostExtractCommandLineParams).Trim(),
        ProductName = oFvi.ProductName,
        ProductVersion = oFvi.ProductVersion,
        Quiet = false,
        RemoveUnpackedFilesAfterExecute = true,
        SfxExeWindowTitle = ""
    };

    if (sLanguages != null)
    {
        string[] split = sLanguage.Split(new Char[] { '_' });
        string lang = split[0];
        string region = split[1];
        ci = new CultureInfo(lang + "-" + region);

        options.Description = String.Format(oFvi.FileDescription, P.Version, 
            ci.EnglishName);
        string sLang = sLanguage.Substring(3);
        if (sLang == "US") sLang = "EN";
        sPathOut = Path.Combine(sPathOut, "NombreApp_" + sModule + "_" + sLang + ".exe");
    }
    else
        sPathOut = Path.Combine(sPathOut, "NombreApp_" + sModule + ".exe");

    string DefaultExtractDirectory = Path.Combine(P.PathTmp, nameComponentProduct);
    if (Directory.Exists(DefaultExtractDirectory))
        System.IO.Directory.Delete(DefaultExtractDirectory, true);

    using (ZipFile zip = new ZipFile())
    {
        zip.StatusMessageTextWriter = System.Console.Out;
        zip.AddDirectory(sPathIn, "");
        if (sLanguages != null)
            zip.Comment = String.Format(oFvi.Comments, ci.EnglishName, PV.Version);
        else
            zip.Comment = String.Format(oFvi.Comments, P.Version);
        options.Description = sDescription + " " + sVersion;
        options.DefaultExtractDirectory = DefaultExtractDirectory;
        options.SfxExeWindowTitle = String.Format("Extracting {0} ...", 
            options.Description);
        zip.RemoveSelectedEntries("log/*");
        zip.RemoveSelectedEntries("*.pdb");
        if (sLanguages != null)
        {
            DefaultExtractDirectory = Path.Combine(P.PathTmp, 
                Path.Combine(nameComponentProduct, sLanguage));
            options.PostExtractCommandLine = sSetupExeName + " " + sLanguage;
            foreach (string sLanguage2 in sLanguages)
                if (sLanguage != sLanguage2)
                    zip.RemoveSelectedEntries("*pk_" + sLanguage2 + ".zip");
        }
        if (sInterfaces != null)
        {
            foreach (string sInterfaz in sInterfaces)
                if (sInterfaz != sInterfaceFile)
                    zip.RemoveSelectedEntries("*" + sInterfaz);
        }
        zip.SaveSelfExtractor(sPathOut, options);
    }
    Console.WriteLine("END.");
    Console.WriteLine("");
}

EDIT :

What has come closest to the result I'm looking for is to change the option Flavorin the SelfExtractorSaveOptions:

Flavor = SelfExtractorFlavor.ConsoleApplication: It shows me the console with the list of files that it is decompressing, but it doesn't show me times or % complete, which is what I'm looking for.

Flavor = SelfExtractorFlavor.WinFormsApplication: It shows me the user interface, with the extraction options and a button to execute the extraction, which doesn't interest me, what I want is for it to be automatic and show me the progress (since some Zips take a while to unzip and may appear to crash the app).

There is also the option Quiet, if I put it in Truethe windows are hidden, that's why I have it in False.

Good,

I am developing a program in Framework 3.5 in WPF (xaml) and the problem that occurs to me is that when I want to change the color of a line from the class code, when the grid already has the data that I want to show, I can't find the way.

XAML code:

    <ListView.View>
        <GridView>
            <GridViewColumn Header="#" DisplayMemberBinding="{Binding Path=position}" my:clsGridViewSort.PropertyName="position"></GridViewColumn>
            <GridViewColumn Header="{x:Static prop:Properties.Resources.NombreArchivo}" DisplayMemberBinding="{Binding Path=filename}" my:clsGridViewSort.PropertyName="filename" />
            <GridViewColumn Header="{x:Static prop:Properties.Resources.FechaInicio}" DisplayMemberBinding="{Binding Path=startdate}" my:clsGridViewSort.PropertyName="startdate" />
            <GridViewColumn Header="{x:Static prop:Properties.Resources.FechaFin}" DisplayMemberBinding="{Binding Path=enddate}" my:clsGridViewSort.PropertyName="enddate"/>
            <GridViewColumn Header="{x:Static prop:Properties.Resources.UltimaCopia}" DisplayMemberBinding="{Binding Path=lastbackup}" my:clsGridViewSort.PropertyName="lastbackup"/>
            <GridViewColumn Header="{x:Static prop:Properties.Resources.Estado}" DisplayMemberBinding="{Binding Path=state}" my:clsGridViewSort.PropertyName="state"/>
            <GridViewColumn Header="{x:Static prop:Properties.Resources.Periodicidad}" DisplayMemberBinding="{Binding Path=period}" my:clsGridViewSort.PropertyName="period"/>
            <GridViewColumn Header="{x:Static prop:Properties.Resources.Ruta}" DisplayMemberBinding="{Binding Path=path}" my:clsGridViewSort.PropertyName="path"/>
            <GridViewColumn Header="{x:Static prop:Properties.Resources.EspacioActual}" DisplayMemberBinding="{Binding Path=actualsize}" my:clsGridViewSort.PropertyName="actualsize"/>
        </GridView>
    </ListView.View>