Form For Restoring FIrebird Database (Gbk file)

PHOTO

Mon Aug 22 2022 11:51:50 GMT+0000 (UTC)

Saved by @HristoT #c#

// Download Firebird 3_0 Server:
// https://firebirdsql.org/en/firebird-3-0-0/

public void ShowRestoreFirebirdDatabase()
        {
            using (var form = new XF_RestoreFirebirdDatabase())
            {
                form.Text = "Възстановяване на Firebird база (Gbk файл)";
                form.StartPosition = FormStartPosition.CenterScreen;
                form.FileName.ReadOnly = true;
                form.Log.ReadOnly = true;
                form.RestorePath.ReadOnly = true;

                form.btnAddToSettings.Enabled = false;

                var arguments = "-R -USER 'SYSDBA' -PAS 'masterkey' ";

                var filePath = string.Empty;
                form.btnChooseFirebirdDatabase.Click += (s, e) =>
                {
                    using (var dlg = new OpenFileDialog())
                    {
                        dlg.Title = "Изберете файл";
                        dlg.InitialDirectory = "d:\\";

                        dlg.Filter = "Firebird|*.Gbk";
                        dlg.Multiselect = false;

                        if (dlg.ShowDialog() == DialogResult.OK)
                        {
                            filePath = dlg.FileName;
                            form.FileName.Text = filePath;
                            arguments += filePath + " ";
                        }
                    }
                };

                var restorePath = string.Empty;
                form.btnChooseRestoreFolder.Click += (s, e) =>
                {
                    using (var dlg = new FolderBrowserDialog())
                    {
                        if (dlg.ShowDialog() == DialogResult.OK)
                        {
                            restorePath = dlg.SelectedPath;
                            form.RestorePath.Text = restorePath;
                        }
                    }
                };

                Process process = null;
                form.btnRestoreDatabase.Click += async (s, e) =>
                {
                    if (string.IsNullOrWhiteSpace(filePath))
                    {
                        MessageBox.Show("Няма посочена база за ресторване.", "Грешка!", MessageBoxButtons.OK, MessageBoxIcon.Error);
                        return;
                    }
                    if (string.IsNullOrWhiteSpace(form.DatabaseName.Text))
                    {
                        MessageBox.Show("Няма зададено име на база.", "Грешка!", MessageBoxButtons.OK, MessageBoxIcon.Error);
                        return;
                    }

                    var stopwatch = new Stopwatch();
                    stopwatch.Start();
                    EnableForm(false);

                    restorePath = string.Empty;
                    if (string.IsNullOrWhiteSpace(form.RestorePath.Text))
                    {
                        restorePath = Path.Combine(Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location), "databases", form.DatabaseName.Text + ".GDB");
                    }
                    else
                    {
                        restorePath = Path.Combine(form.RestorePath.Text, form.DatabaseName.Text + ".GDB");
                    }

                    arguments += restorePath;

                    process = new Process()
                    {
                        StartInfo = new ProcessStartInfo(GlobMigration.GbakExe, arguments)
                        {
                            CreateNoWindow = true,
                            WindowStyle = ProcessWindowStyle.Hidden,
                        },
                    };

                    process.Start();
                    Thread.Sleep(1000);

                    CancellationTokenSource src = new CancellationTokenSource();
                    CancellationToken ct = src.Token;
                    await Task.Factory.StartNew(() =>
                    {
                        if (ct.IsCancellationRequested)
                        {
                            return;
                        }

                        while (!process.HasExited)
                        {
                            var fileInfo = new FileInfo(restorePath);
                            var fileSize = BytesToString(fileInfo.Length);
                            Log(fileSize);

                            Thread.Sleep(3000);
                        }
                    }, ct);

                    if (!File.Exists(restorePath))
                    {
                        MessageBox.Show("Базата не може да се възстанови. Проверете отново файла, който е изтеглен и пътя до него.");
                        EnableForm(true);
                        return;
                    }

                    var logMessage = $"Приключи възстановяването: {stopwatch.Elapsed.TotalMinutes:F0} минути, {stopwatch.Elapsed.TotalSeconds:F0} секунди";
                    Log(logMessage);
                    Log($"Записана база в: {restorePath}");

                    arguments = "-R -USER 'SYSDBA' -PAS 'masterkey' ";

                    EnableForm(true);
                    form.btnAddToSettings.Enabled = true;
                };

                form.FormClosing += (s, e) =>
                {
                    if (process != null && !process.HasExited)
                    {
                        process.Kill();
                    }
                };

                form.btnOpenDatabaseFolder.Click += (s, e) =>
                {
                    Process.Start(GlobMigration.DatabasesFolderPath);
                };

                form.btnClose.Click += (s, e) =>
                {
                    form.Close();
                };

                form.btnAddToSettings.Click += (s, e) =>
                {
                    if (!File.Exists(restorePath))
                    {
                        MessageBox.Show("Не съществува база, която да се закачи.", "Грешка!", MessageBoxButtons.OK, MessageBoxIcon.Error);
                        return;
                    }

                    AddFirebirdDatabaseToSettings(restorePath);

                    MessageBox.Show("Успешно закачена база за настройките.");
                };

                void Log(string msg)
                {
                    if (form.IsDisposed)
                    {
                        return;
                    }

                    form.BeginInvoke((MethodInvoker)delegate ()
                    {
                        form.Log.AppendText($"[{DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss", CultureInfo.InvariantCulture)}] {msg}" + Environment.NewLine);
                        form.Log.ScrollToCaret();
                    });
                }

                string BytesToString(long byteCount)
                {
                    string[] suf = { "B", "KB", "MB", "GB", "TB", "PB", "EB" }; //Longs run out around EB
                    if (byteCount == 0)
                    {
                        return "0" + suf[0];
                    }

                    long bytes = Math.Abs(byteCount);
                    int place = Convert.ToInt32(Math.Floor(Math.Log(bytes, 1024)));
                    double num = Math.Round(bytes / Math.Pow(1024, place), 1);
                    return (Math.Sign(byteCount) * num).ToString() + " " + suf[place];
                }

                void EnableForm(bool enable)
                {
                    if (form.IsDisposed)
                    {
                        return;
                    }

                    form.BeginInvoke((MethodInvoker)delegate ()
                    {
                        form.btnChooseFirebirdDatabase.Enabled = enable;
                        form.btnRestoreDatabase.Enabled = enable;
                        form.btnAddToSettings.Enabled = enable;
                        form.btnChooseRestoreFolder.Enabled = enable;
                    });
                }

                form.ShowDialog();
            }
        }

Save snippets that work from anywhere online with our extensions

Available in the Chrome Web Store

Get Firefox Add-on

Get VS Code extension

Comments

More like this

DevExpress Forms

@HristoT

Open File Dialog Window (Прозорец за избор на файл) Start Task With CancellationToken Invoke Form Control With Coloring Option Form For Restoring FIrebird Database (Gbk file) Form For Finding Database Table By Row Value Class For Generating Form Outside The Code Behind Of Windows Forms Lock Form UI While Doing Some Work Behind WinForms/DevExpress Message Boxes Handle EditValueChanging Of WinForms/DevExpress Control Get Grid Row When Clicked And Refresh It Get Grid Datasource As List Of Some Type Get Only The Changed Grid View Rows Export Class To Excel

#blazor #c# #html

[SOLVED] - Blazor onchange event with select dropdown

@inject HttpClient httpClient

@if (States != null)
{

<select id="SearchStateId" name="stateId" @onchange="DoStuff" class="form-control1">
    <option>@InitialText</option>
    @foreach (var state in States)
    {
        <option value="@state.Name">@state.Name</option>
    }
</select>
}


@code {
[Parameter] public string InitialText { get; set; } = "Select State";
private KeyValue[] States;
private string selectedString { get; set; }
protected override async Task OnInitializedAsync()
{
    States = await httpClient.GetJsonAsync<KeyValue[]>("/sample-data/State.json");
}

private void DoStuff(ChangeEventArgs e)
{
    selectedString = e.Value.ToString();
    Console.WriteLine("It is definitely: " + selectedString);
}

public class KeyValue
{
    public int Id { get; set; }

    public string Name { get; set; }
}
}

I want Input text file in sap using c#

   foreach (string line in lines)
            {
                string[] a = line.Split('|');
                oDocumentSQ.DocNum = Convert.ToInt32(a[0]);
                oDocumentSQ.CardCode = a[1];
                oDocumentSQ.NumAtCard = a[2];
                oDocumentSQ.DocDate = Convert.ToDateTime(a[3]);

                oDocumentSQ.Lines.ItemCode = a[4];
                oDocumentSQ.Lines.UnitPrice = Convert.ToDouble(a[5]);
                oDocumentSQ.Lines.Quantity = Convert.ToInt32(a[6]);
                oDocumentSQ.Lines.VatGroup = a[7];
                oDocumentSQ.Lines.Add();             
            }

#C# #c# #array #dictionary

How to clear item not input when count frequency use Dictionary C#

for (int i = 0; i < n; i++)
{
    if (valCount.ContainsKey(x))
        valCount[x]++;
    else
        valCount[x] = 1;
}

NuGet Gallery | DocumentFormat.OpenXml 2.11.0

Install-Package DocumentFormat.OpenXml -Version 2.11.0

How to initialize a dictionary with a collection initializer - C# Programming Guide | Microsoft Docs

public class HowToDictionaryInitializer
{
    class StudentName
    {
        public string FirstName { get; set; }
        public string LastName { get; set; }
        public int ID { get; set; }
    }

    public static void Main()
    {
        var students = new Dictionary<int, StudentName>()
        {
            { 111, new StudentName { FirstName="Sachin", LastName="Karnik", ID=211 } },
            { 112, new StudentName { FirstName="Dina", LastName="Salimzianova", ID=317 } },
            { 113, new StudentName { FirstName="Andy", LastName="Ruth", ID=198 } }
        };

        foreach(var index in Enumerable.Range(111, 3))
        {
            Console.WriteLine($"Student {index} is {students[index].FirstName} {students[index].LastName}");
        }
        Console.WriteLine();		

        var students2 = new Dictionary<int, StudentName>()
        {
            [111] = new StudentName { FirstName="Sachin", LastName="Karnik", ID=211 },
            [112] = new StudentName { FirstName="Dina", LastName="Salimzianova", ID=317 } ,
            [113] = new StudentName { FirstName="Andy", LastName="Ruth", ID=198 }
        };

        foreach (var index in Enumerable.Range(111, 3))
        {
            Console.WriteLine($"Student {index} is {students2[index].FirstName} {students2[index].LastName}");
        }
    }
}

public int Id { get; set; }

        [Required]
        public string Klant { get; set; }

        [DataType(DataType.EmailAddress)]
        public string Email { get; set; }

        [DataType(DataType.PhoneNumber)]
        public string Telefoonnummer { get; set; }

        [Required]
        public int Aantalpersonen { get; set; }

        [Required]
        [DataType(DataType.Date)]
        public DateTime Datum { get; set; }

        [Required]
        [DataType(DataType.Time)]
        public DateTime Begintijd { get; set; }

        [Required]
        [DataType(DataType.Time)]
        public DateTime Eindtijd { get; set; }

        [DataType(DataType.MultilineText)]
        public string Opmerkingen { get; set; }
        public string Medewerker { get; set; }
        public DateTime AanmaakDatum { get; set; }

using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;

namespace GoodTimes.Models
{
    public class Bon
    {
        public int Id { get; set; }
        public int Tafelnr { get; set; }
        public DateTime Bezoek { get; set; }
        public string Medewerker { get; set; }
        public int Bonnummer { get; set; }

        public List<BonRegel> BonRegels { get; set; }

        public List<Bestelling> Bestellings { get; set; }
    }
}

Class Reserveren

using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.Linq;
using System.Threading.Tasks;

namespace GoodTimes.Models
{
    public class Reserveren
    {
        public int Id { get; set; }

        [Required]
        public string Klant { get; set; }

        [DataType(DataType.EmailAddress)]
        public string Email { get; set; }

        [DataType(DataType.PhoneNumber)]
        public string Telefoonnummer { get; set; }

        [Required]
        public int Aantalpersonen { get; set; }

        [Required]
        [DataType(DataType.Date)]
        public DateTime Datum { get; set; }

        [Required]
        [DataType(DataType.Time)]
        public DateTime Begintijd { get; set; }

        [Required]
        [DataType(DataType.Time)]
        public DateTime Eindtijd { get; set; }

        [DataType(DataType.MultilineText)]
        public string Opmerkingen { get; set; }
        public string Medewerker { get; set; }
        public DateTime AanmaakDatum { get; set; }
    }
}

ApplicationDbContext

using System;
using System.Collections.Generic;
using System.Text;
using Microsoft.AspNetCore.Identity.EntityFrameworkCore;
using Microsoft.EntityFrameworkCore;
using GoodTimes.Models;

namespace GoodTimes.Data
{
    public class ApplicationDbContext : IdentityDbContext
    {
        public ApplicationDbContext(DbContextOptions<ApplicationDbContext> options)
            : base(options)
        {
        }
        public DbSet<GoodTimes.Models.Reserveren> Reserveren { get; set; }
        public DbSet<GoodTimes.Models.Menukaart> Menukaart { get; set; }
        public DbSet<GoodTimes.Models.Categorie> Categorie { get; set; }
        public DbSet<GoodTimes.Models.Product> Product { get; set; }

        protected override void OnModelCreating(ModelBuilder builder)
        {
            base.OnModelCreating(builder);
            builder.Entity<Menukaart>().HasData(
                new Menukaart
                {
                    Id = 1,
                    Naam = "Lunchkaart"
                },
                new Menukaart
                {
                    Id = 2,
                    Naam = "Dinerkaart"
                },
                new Menukaart
                {
                    Id = 3,
                    Naam = "Drankenkaart"
                }
            );
        }

        public DbSet<GoodTimes.Models.Bestelling> Bestelling { get; set; }

        //public DbSet<GoodTimes.Models.Bon> Bon { get; set; }

        //public DbSet<GoodTimes.Models.BonRegel> BonRegel { get; set; }
    }
}

using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.Linq;
using System.Threading.Tasks;

namespace GoodTimes.Models
{
    public class Bestelling
    {
        public int Id { get; set; }
        public int Tafelnummer { get; set; }
        public int Aantal { get; set; }
        [DataType(DataType.MultilineText)]
        public string Opmerkingen { get; set; }
        public string Medewerker { get; set; }
        public DateTime Plaatsing { get; set; }
        public bool IsGereed { get; set; }

        //public List<BonRegel> BonRegels { get; set; }

        //public int BonId { get; set; }
        //public Bon Bon { get; set; }
    }
}

using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.Linq;
using System.Threading.Tasks;

namespace GoodTimes.Models
{
    public class Categorie
    {
        public int Id { get; set; }
        [Required]
        public string Naam { get; set; }
        public int Volgorde { get; set; }

        public int MenukaartId { get; set; }
        public Menukaart Menukaart { get; set; }

        public List<Product> products { get; set; }
    }
}

using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.Linq;
using System.Threading.Tasks;

namespace GoodTimes.Models
{
    public class Product
    {
        public int Id { get; set; }
        [Required]
        public string Naam { get; set; }
        [Required]
        [DataType(DataType.MultilineText)]
        public string Omschrijving { get; set; }
        [Required]
        public double Prijs { get; set; }
        public int Volgorde { get; set; }

        public int CategorieId { get; set; }
        public Categorie categorie { get; set; }
    }
}

#c# #loops #for

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
namespace StarPattern
{
class Program
{
static void Main(string[] args)
{
int x, y, z;
for (x =6; x >= 1; x--)
{
for (y = 1; y < x; y++)
{
Console.Write(" ");
}
for (z = 6; z >= x; z--)
{
Console.Write("*");
}
Console.WriteLine();
}
Console.ReadLine();
}
}
}

suite fibonacci C#

var fibonacciNumbers = new List<int> {1, 1};

while (fibonacciNumbers.Count < 20)
{
    var previous = fibonacciNumbers[fibonacciNumbers.Count - 1];
    var previous2 = fibonacciNumbers[fibonacciNumbers.Count - 2];

    fibonacciNumbers.Add(previous + previous2);
}
foreach(var item in fibonacciNumbers)
    Console.WriteLine(item);

EnemySpawner.cs

using System.Collections.Generic;
using UnityEngine;
using UnityEngine.AI;

public class Spawner : MonoBehaviour
{
    public Enemy enemy;
    private List<Enemy> enemies;
    
    [Range (0,100)]
    public int numberOfEnemies = 25;
    private float range = 70.0f;
    
    void Start()
    {
        enemies = new List<Enemy>(); // init as type
        for (int index = 0; index < numberOfEnemies; index++)
        {
            Enemy spawned = Instantiate(enemy, RandomNavmeshLocation(range), Quaternion.identity) as Enemy;
            enemies.Add(spawned);
        }
    }
    
    public Vector3 RandomNavmeshLocation(float radius)
    {
        Vector3 randomDirection = Random.insideUnitSphere * radius;
        randomDirection += transform.position;
        NavMeshHit hit;
        Vector3 finalPosition = Vector3.zero;
        if (NavMesh.SamplePosition(randomDirection, out hit, radius, 1))
        {
            finalPosition = hit.position;
        }
        return finalPosition;
    }
}

Browse more snippets >>