public static void ExtractData()
{
Logger.LogEvent("**************** STARTING MANAGER UPDATE ****************");
try
{
using (var sqlConnection = SqlDBUtil.GetConnection())
{
using (var oracleConnection = OracleDBUtil.GetConnection())
{
Logger.LogEvent(" Trying to connect to server..");
sqlConnection.Open();
Logger.LogEvent(" Connected to server");
SqlDBUtil.TruncateTable(sqlConnection);
SqlDBUtil.ExecuteInsert(sqlConnection, oracleConnection);
Logger.LogEvent(" Extract and import part is DONE!");
Logger.WriteLogToFile();
}
}
}
catch (OracleException oraEx)
{
EmailUtility.SendEmail("ORACLE EXCEPTION: " + "\r\n" + oraEx.Message, "Import Failed!");
Logger.LogException(oraEx.Message);
Logger.WriteLogToFile();
throw;
}
catch (Exception ex)
{
EmailUtility.SendEmail("Other EXCEPTION while retrieving data from Oracle db: " + "\r\n" + ex.Message, "Import Failed!");
Logger.LogException(ex.Message);
Logger.WriteLogToFile();
throw;
}
}
