public static Dictionary <string, string> PolaczZBazaLinkZamowienieKlient()
{
//set the connection string
string connString = conn_string;
//variables to store the query results
try
{
//sql connection object
using (SqlConnection conn = new SqlConnection(connString))
{
//define the SqlCommand object
SqlCommand cmd = new SqlCommand(query_get_orders, conn);
//open connection
conn.Open();
//execute the SQLCommand
SqlDataReader dr = cmd.ExecuteReader();
// Console.WriteLine(Environment.NewLine + "Retrieving data from database...LinkZamowienieKlient" + Environment.NewLine);
// Console.WriteLine("Retrieved records:");
string ZamowienieIdHashKey, KlientIdHashKey, mail, RecordSource;
int ETL_RunId, ServerId, Id, id_klienta;
Dictionary <string, string> temp = new Dictionary <string, string>();
//check if there are records
if (dr.HasRows)
{
while (dr.Read())
{
ZamowienieIdHashKey = dr.GetString(1);
KlientIdHashKey = dr.GetString(2);
ETL_RunId = dr.GetInt32(3);
RecordSource = dr.GetString(4);
ServerId = dr.GetInt32(5);
Id = dr.GetInt32(6);
id_klienta = dr.GetInt32(7);
mail = dr.GetString(8);
Dictionary <string, string> tempin = new Dictionary <string, string>();
tempin["ZamowienieKlientHashKey"] = ZamowienieIdHashKey;
tempin["KlientIdHashKey"] = KlientIdHashKey;
tempin["ETL_RunId"] = ETL_RunId.ToString();
tempin["RecordSource"] = RecordSource;
tempin["ServerId"] = ServerId.ToString();
tempin["Id"] = Id.ToString();
tempin["id_klienta"] = id_klienta.ToString();
tempin["mail"] = mail;
temp[ZamowienieIdHashKey] = KlientIdHashKey;
}
}
else
{
Console.WriteLine("No data found.");
}
//close data reader
dr.Close();
//close connection
conn.Close();
return(temp);
}
}
catch (Exception ex)
{
//display error message
Console.WriteLine("Exception: " + ex.Message);
}
return(new Dictionary <string, string>());
}
public static Dictionary <string, Dictionary <string, string> > PolaczZBazaSatZamowienieKlientDaneFirmy()
{
//set the connection string
string connString = conn_string;
try
{
//sql connection object
using (SqlConnection conn = new SqlConnection(connString))
{
//define the SqlCommand object
SqlCommand cmd = new SqlCommand(query_zamowienie_klient_dane_firmy, conn);
//open connection
conn.Open();
//execute the SQLCommand
SqlDataReader dr = cmd.ExecuteReader();
// Console.WriteLine(Environment.NewLine + "Retrieving data from database...SatZamowienieKlientDaneFirmy" + Environment.NewLine);
// Console.WriteLine("Retrieved records:");
string ZamowienieIdHashKey, RecordSource, nip, firma_nazwa, firma_imie, firma_nazwisko, firma_adres, firma_adres2, firma_kod, firma_miasto, firma_kraj, firma_telefon, firma_email, ZamowienieKlientDaneFirmyHashDiff;
int ETL_RunId;
Dictionary <string, Dictionary <string, string> > temp = new Dictionary <string, Dictionary <string, string> >();
//check if there are records
if (dr.HasRows)
{
while (dr.Read())
{
ZamowienieIdHashKey = dr[0] as string ?? default(string);;
ETL_RunId = dr.GetInt32(1);
RecordSource = dr[4] as string ?? default(string);
nip = dr[5] as string ?? default(string);
firma_nazwa = dr[6] as string ?? default(string);
firma_imie = dr[7] as string ?? default(string);
firma_nazwisko = dr[8] as string ?? default(string);
firma_adres = dr[9] as string ?? default(string);
firma_adres2 = dr[10] as string ?? default(string);
firma_kod = dr[11] as string ?? default(string);
firma_miasto = dr[12] as string ?? default(string);
firma_kraj = dr[13] as string ?? default(string);
firma_telefon = dr[14] as string ?? default(string);
firma_email = dr[15] as string ?? default(string);
ZamowienieKlientDaneFirmyHashDiff = dr[16] as string ?? default(string);
Dictionary <string, string> tempin = new Dictionary <string, string>();
tempin["ETL_RunId"] = ETL_RunId.ToString();
tempin["RecordSource"] = RecordSource;
tempin["NIP"] = nip;
tempin["firma_nazwa"] = firma_nazwa;
tempin["firma_imie"] = firma_imie;
tempin["firma_nazwisko"] = firma_nazwisko;
tempin["firma_adres"] = firma_adres;
tempin["firma_adres2"] = firma_adres2;
tempin["firma_kod"] = firma_kod;
tempin["firma_miasto"] = firma_miasto;
tempin["firma_kraj"] = firma_kraj;
tempin["firma_telefon"] = firma_telefon;
tempin["firma_email"] = firma_email;
tempin["ZamowienieKlientDaneFirmyHashDiff"] = ZamowienieKlientDaneFirmyHashDiff;
temp[ZamowienieIdHashKey] = tempin;
}
}
else
{
Console.WriteLine("No data found.");
}
//close data reader
dr.Close();
//close connection
conn.Close();
return(temp);
}
}
catch (Exception ex)
{
//display error message
Console.WriteLine("Exception: " + ex.Message);
}
return(new Dictionary <string, Dictionary <string, string> >());
}
public static Dictionary <string, Dictionary <string, string> > PolaczZBazaSatZamowienieKlientAdres()
{
//set the connection string
string connString = conn_string;
try
{
//sql connection object
using (SqlConnection conn = new SqlConnection(connString))
{
//define the SqlCommand object
SqlCommand cmd = new SqlCommand(query_adresy, conn);
//open connection
conn.Open();
//execute the SQLCommand
SqlDataReader dr = cmd.ExecuteReader();
// Console.WriteLine(Environment.NewLine + "Retrieving data from database...ZamowienieKlientAdres" + Environment.NewLine);
// Console.WriteLine("Retrieved records:");
string ZamowienieIdHashKey, RecordSource, adres, adres2, kod, miasto, kraj, imie, nazwisko, firma, ZamowienieKlientAdresHashDiff;
int ETL_RunId;
Dictionary <string, Dictionary <string, string> > temp = new Dictionary <string, Dictionary <string, string> >();
//check if there are records
if (dr.HasRows)
{
while (dr.Read())
{
ZamowienieIdHashKey = dr[0] as string ?? default(string);
ETL_RunId = dr.GetInt32(1);
RecordSource = dr[4] as string ?? default(string);
adres = dr[5] as string ?? default(string);
adres2 = dr[6] as string ?? default(string);
kod = dr[7] as string ?? default(string);
miasto = dr[8] as string ?? default(string);
kraj = dr[9] as string ?? default(string);
imie = dr[10] as string ?? default(string);
nazwisko = dr[11] as string ?? default(string);
firma = dr[12] as string ?? default(string);
ZamowienieKlientAdresHashDiff = dr.GetString(13);
Dictionary <string, string> tempin = new Dictionary <string, string>
{
["ETL_RunId"] = ETL_RunId.ToString(),
["RecordSource"] = RecordSource,
["adres"] = adres,
["adres2"] = adres2,
["kod"] = kod,
["miasto"] = miasto,
["kraj"] = kraj,
["imie"] = imie,
["nazwisko"] = nazwisko,
["firma"] = firma,
["ZamowienieKlientAdresHashDiff"] = ZamowienieKlientAdresHashDiff
};
temp[ZamowienieIdHashKey] = tempin;
}
}
else
{
Console.WriteLine("No data found.");
}
//close data reader
dr.Close();
//close connection
conn.Close();
return(temp);
}
}
catch (Exception ex)
{
//display error message
Console.WriteLine("Exception: " + ex.Message);
}
return(new Dictionary <string, Dictionary <string, string> >());
}
public static Dictionary <string, Dictionary <string, string> > PolaczZBazaSatPozycja()
{
//set the connection string
string connString = conn_string;
try
{
//sql connection object
using (SqlConnection conn = new SqlConnection(connString))
{
//define the SqlCommand object
SqlCommand cmd = new SqlCommand(query_pozycja, conn);
//open connection
conn.Open();
//execute the SQLCommand
SqlDataReader dr = cmd.ExecuteReader();
// Console.WriteLine(Environment.NewLine + "Retrieving data from database...SatPozycja" + Environment.NewLine);
// Console.WriteLine("Retrieved records:");
string PozycjaIdHashKey, tytul, RecordSource, cena, vat, cena_netto, PozycjaHashDiff;
int liczba, ETL_RunId;
decimal wartosc_vat;
Dictionary <string, Dictionary <string, string> > temp = new Dictionary <string, Dictionary <string, string> >();
//check if there are records
if (dr.HasRows)
{
while (dr.Read())
{
PozycjaIdHashKey = dr[0] as string ?? default(string);
ETL_RunId = dr.GetInt32(1) as int? ?? default(int);
RecordSource = dr[4] as string ?? default(string);
liczba = dr.GetInt32(5) as int? ?? default(int);
tytul = dr[6] as string ?? default(string);
cena = dr[7] as string ?? default(string);
vat = dr[8] as string ?? default(string);
cena_netto = dr[9] as string ?? default(string);
PozycjaHashDiff = dr[10] as string ?? default(string);
wartosc_vat = dr.GetDecimal(11) as decimal? ?? default(decimal);
Dictionary <string, string> tempin = new Dictionary <string, string>();
tempin["ETL_RunId"] = ETL_RunId.ToString();
tempin["RecordSource"] = RecordSource;
tempin["Liczba"] = liczba.ToString();
tempin["Tytul"] = tytul;
tempin["Cena"] = cena;
tempin["VAT"] = vat;
tempin["Cena_Netto"] = cena_netto;
tempin["PozycjaHashDiff"] = PozycjaHashDiff;
tempin["Wartosc_vat"] = wartosc_vat.ToString();
temp[PozycjaIdHashKey] = tempin;
}
}
else
{
Console.WriteLine("No data found.");
}
//close data reader
dr.Close();
//close connection
conn.Close();
return(temp);
}
}
catch (Exception ex)
{
//display error message
Console.WriteLine("Exception: " + ex.Message);
}
return(null);
}
