using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data;
using FirebirdSql.Data;
using FirebirdSql.Data.Client;
using FirebirdSql.Data.FirebirdClient;
namespace ConsoleApp4

{

    class Program

    {

        static void Main(string[] args)

        {

            string connectionString = "User=SYSDBA;Password=masterkey;Database=s-market.fdb;DataSource=srv-250;Port = 3050; Dialect = 1; Charset = WIN1251; Role =; Connection lifetime = 30; Pooling = true;MinPoolSize = 0; MaxPoolSize = 50; Packet Size = 8192; ServerType = 0;";

            string queryString = "select ost.articul, cards.name, ost.quantity, pr.price_rub from ostdaily ost " +

"left join cardscla cards on ost.articul = cards.articul " +

"join disccard pr on pr.articul = ost.articul " +

"join pricekind prk on prk.ID_PRICEKIND = pr.PRICE_KIND " +

"left join mesuriment mes on cards.mesuriment = mes.id_mesuriment " +

"where ost.place_index in (select client_index from th_classbyclient where th_classif = 69) and ost.ost_date = 'today' " +

"and FILIALINDEX_PRICEKIND = 69 and kind = 0 rows 800";

            Console.WriteLine(queryString);

            Console.ReadKey();

            using (FbConnection connectionFb = new FbConnection(connectionString))

            {

                FbCommand command = new FbCommand(queryString, connectionFb);

                command.CommandTimeout = 0;

                connectionFb.Open();

                FbDataReader reader = command.ExecuteReader();

                while (reader.Read())

                {

                    var row = reader.GetString(0);

                    Console.WriteLine(row);

                }

                reader.Close();

            }

            Console.WriteLine("end");

            Console.ReadKey();

 

        }

    }

}