private void GenerateCsvMO()
{
try
{
string STAT_MO_BILING = DateTime.Now.ToString("yyyy-MM-dd");
traceManager = new TraceManager(PARAM_PATH_EXCEL + "STAT_CONTENT_MO_" + STAT_MO_BILING + ".txt");
string chaineConnexion = CONNECTION_STRING_POSTGRESQL;
NpgsqlConnection npgsqlConnection = new NpgsqlConnection(chaineConnexion);
npgsqlConnection.Open();
DataTable dataTable = new DataTable();
string requete = requeteSmsContent_MO_Postrgres;
/*dataTable.Columns.Add("id_sms_mo", typeof(String));
* dataTable.Columns.Add("sms", typeof(String));
* dataTable.Columns.Add("msisdn", typeof(String));
* dataTable.Columns.Add("shortcode", typeof(String));
* dataTable.Columns.Add("codser", typeof(String));
* dataTable.Columns.Add("status", typeof(String));
* dataTable.Columns.Add("entry_date", typeof(String));
* dataTable.Columns.Add("login", typeof(String));
* dataTable.Columns.Add("sysid", typeof(String));
* dataTable.Columns.Add("length", typeof(String));
*/
NpgsqlCommand npgsqlCommand = new NpgsqlCommand(requete, npgsqlConnection);
NpgsqlDataReader dr = npgsqlCommand.ExecuteReader();
Console.WriteLine("CORPORATE;Code Service;MSISDN;MESSAGE;Date réception;Short Code;Status;SYS_ID;Reference");
traceManager.WriteCSV("CORPORATE;Code Service;MSISDN;MESSAGE;Date réception;Short Code;Status;SYS_ID;Reference");
while (dr.Read())
{
Console.WriteLine(dr[0].ToString() + ";" + dr[1].ToString() + ";" + dr[2].ToString() + ";" + dr[3].ToString() + ";" + dr[4].ToString() + ";" + dr[5].ToString() + ";" +
GetStatut(dr[6].ToString()) + ";" + dr[7].ToString() + ";" + dr[8].ToString() + ";");
traceManager.WriteCSV(dr[0].ToString() + ";" + dr[1].ToString() + ";" + dr[2].ToString() + ";" + dr[3].ToString() + ";" + dr[4].ToString() + ";" + dr[5].ToString() + ";" +
GetStatut(dr[6].ToString()) + ";" + dr[7].ToString() + ";" + dr[8].ToString() + ";");
}
dr.Close();
npgsqlConnection.Close();
// Excel.ExcelUtlity obj = new Excel.ExcelUtlity();
// string title = "STAT RESELLER_POSTGRESQL";
// string fileName = "Bulk_POSTGRESQL_R" + ".csv";
// obj.WriteDataTableToExcel(dataTable, title, PARAM_PATH_EXCEL + fileName, "");
}
catch (Exception ex)
{
throw ex;
}
}
private void GenerateCsvMTBiling()
{
try
{
string STAT_MT_BILING = DateTime.Now.ToString("yyyy-MM-dd");
traceManager = new TraceManager(PARAM_PATH_EXCEL + "STAT_CONTENT_MT_BILING_" + STAT_MT_BILING + ".txt");
string chaineConnexion = CONNECTION_STRING_POSTGRESQL;
int day = 0;
NpgsqlConnection npgsqlConnection;
npgsqlConnection = new NpgsqlConnection(chaineConnexion);
npgsqlConnection.Open();
while (day < 32)
{
Console.WriteLine("********** DAY : " + day.ToString());
int tentative = 0;
while (npgsqlConnection.State != ConnectionState.Open && tentative < 3)
{
System.Threading.Thread.Sleep(2000);
npgsqlConnection = new NpgsqlConnection(chaineConnexion);
npgsqlConnection.Open();
}
DataTable dataTable = new DataTable();
string requete = requeteSmsContent_MT_Postrgres.Replace("[[NBR_DAY]]", day.ToString());
NpgsqlCommand npgsqlCommand = new NpgsqlCommand(requete, npgsqlConnection);
NpgsqlDataReader dr = npgsqlCommand.ExecuteReader();
Console.WriteLine("CORPORATE;Code Service;sysid;sms;msisdn;sender;Status;entry_date;ack_message_id;ack_type;ack_entry_date;Reference");
traceManager.WriteCSV("CORPORATE;Code Service;sysid;sms;msisdn;sender;Status;entry_date;ack_message_id;ack_type;ack_entry_date;Reference;");
while (dr.Read())
{
Console.WriteLine(dr[0].ToString() + ";" + dr[1].ToString() + ";" + dr[2].ToString() + ";" + dr[3].ToString() + ";" + dr[4].ToString() + ";" + dr[5].ToString() + ";" +
GetStatut(dr[6].ToString()) + ";" + dr[7].ToString() + ";" + dr[8].ToString() + ";" + dr[9].ToString() + ";" + dr[10].ToString() + ";" + dr[11].ToString() + ";");
traceManager.WriteCSV(dr[0].ToString() + ";" + dr[1].ToString() + ";" + dr[2].ToString() + ";" + dr[3].ToString() + ";" + dr[4].ToString() + ";" + dr[5].ToString() + ";" +
GetStatut(dr[6].ToString()) + ";" + dr[7].ToString() + ";" + dr[8].ToString() + ";" + dr[9].ToString() + ";" + dr[10].ToString() + ";" + dr[11].ToString() + ";");
System.Threading.Thread.Sleep(20);
}
dr.Close();
day++;
System.Threading.Thread.Sleep(2000);
}
npgsqlConnection.Close();
npgsqlConnection.Dispose();
// Excel.ExcelUtlity obj = new Excel.ExcelUtlity();
// string title = "STAT RESELLER_POSTGRESQL";
// string fileName = "Bulk_POSTGRESQL_R" + ".csv";
// obj.WriteDataTableToExcel(dataTable, title, PARAM_PATH_EXCEL + fileName, "");
}
catch (Exception ex)
{
throw ex;
}
}