public static void MysqlConn(ConnectionNode aa)
{
MySqlConnection conn = new MySqlConnection(aa.conn_str.ToString());
try
{
conn.Open();
ReadCfg.mail_message += "\n\n * * * " + aa.label + "\nConnection opened";
dbProceed(conn, aa, 1);
conn.Close();
ReadCfg.mail_message += "\nConnection closed ";//conn_str.ToString()
}
catch (Exception ex)
{
ReadCfg.error_flag = true;
ReadCfg.mail_message += "\n\n* * * " + aa.label + "connection Exception error:\n " + ex.ToString() + "\n" + aa.conn_str.ToString() + "\n * * *\n";
}
}
public static void dbProceed(MySqlConnection cn, ConnectionNode c, int qtype)
{
MySqlCommand cmd;
MySqlDataReader myReader;
try
{
//****************************************************************************************
//
// JOOMSOPPING
//
//****************************************************************************************
if (c.label == "ReformaUA")
{
////////////////////////////////////////////
// --------- FIll ORDER HEAD DATA ------ //
cmd = new MySqlCommand(c.query_01, cn);
myReader = cmd.ExecuteReader();
if (myReader.HasRows)
{
while (myReader.Read())
{
var ord = new Order
{
order_id = myReader.GetString(0),
num = myReader.GetString(1),
date = myReader.GetString(21),
email = myReader.GetString(43),
name = myReader.GetString(60) + " " + myReader.GetString(61),
firm = myReader.GetString(38),
phone = myReader.GetString(72),
paytype = myReader.GetString(8),
summ = myReader.GetString(3),
discount = myReader.GetString(9),
shopsite = myReader.GetString(88),
valute = myReader.GetString(17),
codepage = c.codepage,
order_rows = new List <Order_row>()
};
if (c.orders != null)
{
c.orders.Add(ord);
}
}
myReader.Close();
//--------- END FIll ORDER HEAD DATA ------ //
/////////////////////////////////////////////
// ---------- FIll ORDER TABLE DATA ------- //
foreach (var ee in c.orders)
{
cmd.CommandText = c.query_02 + ee.order_id;
myReader = cmd.ExecuteReader();
if (myReader.HasRows)
{
while (myReader.Read())
{
var ord_list = new Order_row
{
art = myReader.GetString(3),
name = myReader.GetString(4),
qtty = myReader.GetString(5),
sum = myReader.GetString(6)
};
if (ee.order_rows != null)
{
ee.order_rows.Add(ord_list);
}
// Console.WriteLine("\n--- ---\n" + ord_list.art + ";" + ord_list.id + ";" + ord_list.name + ";" + ord_list.qtty + ";" + ord_list.sum);
}
}
myReader.Close();
}
// --------- END FIll ORDER TABLE DATA ------ //
////////////////////////////////////////////////
ReadCfg.mail_message += "\n orders written to list";
}
else
{
Console.WriteLine(" no orders");
ReadCfg.mail_message += "\n no orders now";
}
}
//****************************************************************************************
//
// OPENCART NFU-RU
//
//****************************************************************************************
else if (c.label == "NfuRuOC")
{
////////////////////////////////////////////
// --------- FIll ORDER HEAD DATA ------ //
//Console.WriteLine("\n\n\n {0}\n\n\n ", c.query_01);
//Console.WriteLine("\n\n\n {0}\n\n\n ", c.query_02);
//Console.ReadLine();
cmd = new MySqlCommand(c.query_01, cn);
myReader = cmd.ExecuteReader();
if (myReader.HasRows)
{
while (myReader.Read())
{
var ord = new Order
{
order_id = myReader.GetString(0),
num = myReader.GetString(1),
date = myReader.GetString(2),
email = myReader.GetString(3),
name = myReader.GetString(4),
firm = myReader.GetString(5),
phone = myReader.GetString(6),
paytype = myReader.GetString(7),
summ = myReader.GetString(8),
discount = myReader.GetString(9),
shopsite = myReader.GetString(10),
valute = myReader.GetString(11),
codepage = c.codepage,
order_rows = new List <Order_row>()
};
if (c.orders != null)
{
c.orders.Add(ord);
}
}
myReader.Close();
//--------- END FIll ORDER HEAD DATA ------ //
/////////////////////////////////////////////
// ---------- FIll ORDER TABLE DATA ------- //
foreach (var ee in c.orders)
{
cmd.CommandText = c.query_02 + ee.order_id;
myReader = cmd.ExecuteReader();
if (myReader.HasRows)
{
while (myReader.Read())
{
var ord_list = new Order_row
{
art = myReader.GetString(0),
name = myReader.GetString(1),
qtty = myReader.GetString(2),
sum = myReader.GetString(3)
};
if (ee.order_rows != null)
{
ee.order_rows.Add(ord_list);
}
}
}
myReader.Close();
}
// --------- END FIll ORDER TABLE DATA ------ //
////////////////////////////////////////////////
ReadCfg.mail_message += "\n orders written to list";
}
else
{
Console.WriteLine(" no orders");
ReadCfg.mail_message += "\n no orders now";
}
}
//****************************************************************************************
//
// SHOPPER.PL
//
//****************************************************************************************
else if (c.label == "ReformaPl" || c.label == "ReformaCom")
{
////////////////////////////////////////////
// --------- FIll ORDER HEAD DATA ------ //
cmd = new MySqlCommand(c.query_01, cn);
myReader = cmd.ExecuteReader();
if (myReader.HasRows)
{
while (myReader.Read())
{
var ord = new Order
{
order_id = myReader.GetString(0),
num = myReader.GetString(0),
date = myReader.GetString(1),
email = myReader.GetString(2),
name = myReader.GetString(3),
firm = myReader.GetString(4),
phone = myReader.GetString(5),
paytype = myReader.GetString(6),
summ = myReader.GetString(7),
discount = myReader.GetString(8),
shopsite = myReader.GetString(9),
valute = myReader.GetString(10),
codepage = c.codepage,
order_rows = new List <Order_row>()
};
if (c.orders != null)
{
c.orders.Add(ord);
}
}
myReader.Close();
//--------- END FIll ORDER HEAD DATA ------ //
/////////////////////////////////////////////
// ---------- FIll ORDER TABLE DATA ------- //
foreach (var ee in c.orders)
{
cmd.CommandText = c.query_02 + ee.order_id;
myReader = cmd.ExecuteReader();
if (myReader.HasRows)
{
while (myReader.Read())
{
var ord_list = new Order_row
{
art = myReader.GetString(0),
name = myReader.GetString(1),
qtty = myReader.GetString(2),
sum = myReader.GetString(3)
};
if (ee.order_rows != null)
{
ee.order_rows.Add(ord_list);
}
}
}
myReader.Close();
}
// --------- END FIll ORDER TABLE DATA ------ //
////////////////////////////////////////////////
ReadCfg.mail_message += "\n orders written to list";
}
else
{
Console.WriteLine(" no orders");
ReadCfg.mail_message += "\n no orders now";
}
}
//****************************************************************************************
//
// PHPSHOP
//
//****************************************************************************************
else if (c.label == "NfuRu" || c.label == "NfuUa")
{
////////////////////////////////////////////
// --------- FIll DATA ------ //
cmd = new MySqlCommand(c.query_01, cn);
myReader = cmd.ExecuteReader();
if (myReader.HasRows)
{
while (myReader.Read())
{
var ord = new Order
{
order_id = myReader.GetString(0),
date = myReader.GetString(1),
num = myReader.GetString(2),
csv_text = myReader.GetString(3),
codepage = c.codepage,
dtDateTime = new DateTime(1970, 1, 1, 0, 0, 0, 0, System.DateTimeKind.Utc),
order_rows = new List <Order_row>()
};
if (c.orders != null)
{
ord.dtDateTime = ord.dtDateTime.AddSeconds(Double.Parse(ord.date)).ToLocalTime();
ord.date = ord.dtDateTime.ToString();
c.orders.Add(ord);
}
}
myReader.Close();
// --------- END FIll DATA ------ //
///////////////////////////////////////////////
foreach (Order s in c.orders)
{
List <Dictionary <string, string> > dic_p = new List <Dictionary <string, string> >();
List <Dictionary <string, string> > dic_c = new List <Dictionary <string, string> >();
dic_c = SerializerAddon.DicList("cart", s.csv_text);
dic_p = SerializerAddon.DicList("person", s.csv_text);
foreach (Dictionary <string, string> dicp in dic_p)
{
s.email = dicp["mail"].ToString();
s.name = dicp["name_person"].ToString();
s.firm = dicp["org_name"].ToString();
s.phone = dicp["tel_name"].ToString();
s.paytype = dicp["order_metod"].ToString();
s.summ = "0";
s.discount = "unk";
s.shopsite = c.label;
s.valute = "unk";
foreach (Dictionary <string, string> dicc in dic_c)
{
var ord_list = new Order_row
{
art = dicc["uid"].ToString(),
name = dicc["name"].ToString(),
qtty = dicc["num"].ToString(),
sum = dicc["price"].ToString()
};
if (s.order_rows != null)
{
s.order_rows.Add(ord_list);
}
}
}
}
ReadCfg.mail_message += "\n orders written to list";
}
else
{
Console.WriteLine(" no orders");
ReadCfg.mail_message += "\n no orders now";
}
}// ----------------- END NFU.RU --------------------- //
////////////////////////////////////////////////////////
// ------ CREATE CSV TEXT ------- //
foreach (Order ss in c.orders)
{
ss.order_file_name = ffn_return(ReadCfg.OutPath, ss.shopsite + "_" + ss.num + "." + ReadCfg.FileType);
// ReadCfg.mess(ss.order_file_name);
ss.csv_text = "N Зак.;Дата;e-mail;Имя;Фирма;тел.;оплата;сумма;скидка;Сайт;Валюта\n"
+ ss.num + ";" + ss.date + ";" + ss.email + ";" + ss.name + ";" + ss.firm + ";" + ss.phone
+ ";" + ss.paytype + ";" + ss.summ + ";" + ss.discount + ";" + ss.shopsite + ";" + ss.valute + "\n"
// + "Валюта;Курс;;;;;;;\n"
// + ss.valute + ";1\n"
// + "Начало заказанных товаров;;;;;;;;\n"
+ "id;Арт.;Наименование;Кол.;Сумма;;;;;;\n";
if (ss.order_rows != null)
{
int i = 1;
foreach (Order_row dd in ss.order_rows)
{
ss.csv_text += i.ToString() + ";" + dd.art + ";" + dd.name + ";" + dd.qtty + ";" + dd.sum + ";;;;;;\n";
i++;
}
}
}
// ---- END CREATE CSV TEXT ----- //
////////////////////////////////////
} // end try
catch (MySqlException ex)
{
ReadCfg.error_flag = true;
// Console.WriteLine(("").PadRight(68, '-'));
// Console.WriteLine("Exception error:\n {0}", ex.ToString());
// Console.WriteLine(("").PadRight(68, '-'));
ReadCfg.mail_message += "* * * \n DB Exception error:\n " + ex.ToString() + "\n" + c.query_01 + "\n" + c.query_02 + "\n * * *\n";
}
}
