Form For Finding Database Table By Row Value

PHOTO

Mon Aug 22 2022 11:57:34 GMT+0000 (UTC)

Saved by @HristoT #c#

public void ShowFormFindFirebirdTable(Dictionary<string, IDatabaseProvider> databases)
        {
            using (var form = new XF_FindFirebirdTable())
            {
                form.Text = "Търсене на таблица във Firebird база";
                form.StartPosition = FormStartPosition.CenterScreen;

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

                form.btnCloseFirebirdConnection.Click += (s, e) =>
                {
                    databases["FB"].CloseConnection();
                    MessageBox.Show("Успешно затворена връзка. При следваща заявка, връзката ще бъде автоматично отворена.");
                };

                form.btnSearch.Click += async (s, e) =>
                {
                    form.btnSearch.Enabled = false;
                    form.ValueToFind.Enabled = false;
                    form.btnCloseFirebirdConnection.Enabled = false;
                    form.ShouldAddNumbers.Enabled = false;

                    CancellationTokenSource src = new CancellationTokenSource();
                    CancellationToken ct = src.Token;

                    await Task.Factory.StartNew(async () =>
                    {
                        if (ct.IsCancellationRequested)
                        {
                            return;
                        }

                        var sb = new StringBuilder();
                        var searchFilter = form.ValueToFind.Text.Trim();

                        try
                        {
                            var tableColumnList = await databases["FB"].ExecuteListAsync<TableColumn>(SQL.Generic.GetAllTableColumByVarcharType);
                            var tableColumnGroup = tableColumnList
                            .GroupBy(p => p.TableName, p => p.ColumnName, (key, value) => new { TableName = key, ColumnName = value });

                            int tablesCount = tableColumnGroup.Count();
                            int currentTable = 1;

                            foreach (var tableColums in tableColumnGroup)
                            {
                                form.BeginInvoke((MethodInvoker)delegate ()
                                {
                                    form.CurrentTable.Text = $"В момента претърсвам: {tableColums.TableName}";
                                });

                                var whereBuilder = new StringBuilder("where");
                                var template = form.ShouldAddNumbers.Checked ? " cast(t.\"{0}\" as varchar(30000)) like '%{1}%' or " : " t.\"{0}\" like '%{1}%' or ";

                                foreach (var colum in tableColums.ColumnName)
                                {
                                    whereBuilder.Append(string.Format(template, colum, searchFilter));
                                }

                                var tableName = tableColums.TableName;
                                var sql = $"select count(*) from \"{tableName}\" t {whereBuilder.ToString().TrimEnd(' ', 'r', 'o')};";

                                try
                                {
                                    var obj = await databases["FB"].ExecuteScalarAsync<object>(sql);
                                    int.TryParse(obj.ToString(), out var matchCount);

                                    form.BeginInvoke((MethodInvoker)delegate ()
                                    {
                                        var percent = (int)((decimal)currentTable / tablesCount * 100);
                                        form.ProgressBar.EditValue = percent;
                                        form.Percentage.EditValue = $"{percent}%";
                                    });

                                    if (matchCount > 0)
                                    {
                                        var sqlToShow = sql.Replace("count(", " ");
                                        var index = sqlToShow.IndexOf(')');
                                        var final = sqlToShow.Remove(index, 1).Insert(index, " ");

                                        sb.AppendLine($"TABLE: {tableName}");
                                        sb.AppendLine($"Maches: {matchCount}");
                                        sb.AppendLine("SQL:");
                                        sb.AppendLine($"{final}{Environment.NewLine}");
                                        sb.AppendLine("======================================================================");
                                    }
                                }
                                catch
                                {
                                    sb.AppendLine("SQL:");
                                    sb.AppendLine($"{sql}{Environment.NewLine}");

                                    form.BeginInvoke((MethodInvoker)delegate ()
                                    {
                                        form.ProgressBar.EditValue = 0;
                                        form.Percentage.EditValue = $"0%";
                                    });

                                    throw;
                                }
                                currentTable++;
                            }
                        }
                        catch (Exception ex)
                        {
                            sb.AppendLine("=========================EXCEPTION=========================");
                            sb.AppendLine($"{ex}{Environment.NewLine}");
                        }

                        form.BeginInvoke((MethodInvoker)delegate ()
                        {
                            var log = string.IsNullOrWhiteSpace(sb.ToString()) ? "Няма намерени таблици" : sb.ToString();
                            form.Result.Text = log;
                        });

                    }, ct);

                    form.ValueToFind.Enabled = true;
                    form.btnSearch.Enabled = true;
                    form.btnCloseFirebirdConnection.Enabled = true;
                    form.ShouldAddNumbers.Enabled = true;
                };

                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

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 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; }
}
}

Unity Convert LocalSpace to WorldSpace

//You need this because ur velocity is in localSpace
//This works if you start the game at 0,0,0 rotation,
//what if you start the game at 0,180,0 rotation?  
//Then your up arrow will move you backwards.


//Get inputs
float horzInput = Input.GetAxis("Horizontal");
float vertInput = Input.GetAxis("Vertical");

//Calc Velocity
Vector3 direction = new Vector3(horzInput, 0.0f, vertInput);
Vector3 velocity = direction * _speed;

//Gravity
velocity.y -= _gravity;

//Convert localSpace velocity to worldSpace
velocity = transform.transform.TransformDirection(velocity); //<-Weimberger's way
velocity = transform.TransformDirection(velocity); //<-myWay

//Move
_controller.Move(velocity * Time.deltaTime);

Unity (C#) equivalent of SetInterval()

void Start(){ 
  StartCoroutine(SpawnObject()); 
}

IEnumerator SpawnObject(){
  while (true){
    yield return new WaitForSeconds(1.0f); // every 1 second
    Instantiate(objectToSpawn);
  }
}

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();
}
}
}

Browse more snippets >>