public static XmlDocument CreateXmlDocument()
{
var xmlDoc = new XmlDocument();
try
{
using (var sqlConnection = SqlDBUtil.GetConnection())
{
sqlConnection.Open();
var sqlcmd = new SqlCommand("[maint].[__UpdateManagers]", sqlConnection);
sqlcmd.CommandTimeout = 240;
sqlcmd.CommandType = System.Data.CommandType.StoredProcedure;
Logger.LogEvent(" Executing stored procedure...");
using (XmlReader reader = sqlcmd.ExecuteXmlReader())
{
while (reader.Read())
{
xmlDoc.Load(reader);
}
xmlDoc.Save(file);
XmlDeclaration xmldecl;
xmldecl = xmlDoc.CreateXmlDeclaration("1.0", "UTF-8", null);
XmlElement root = xmlDoc.DocumentElement;
xmlDoc.InsertBefore(xmldecl, root);
Logger.LogEvent(" File created!");
Logger.Log.Append(DateUtility.getTime() + " Path: " + file + "\r\n");
}
Logger.LogEvent(" Finished executing sp on server!");
Logger.WriteLogToFile();
}
return(xmlDoc);
}
catch (SqlException sqlEx)
{
EmailUtility.SendEmail("ORMIS DB/SQL EXCEPTION: " + "\r\n" + sqlEx.Message, "Import Failed!");
Logger.LogException(sqlEx.Message);
Logger.WriteLogToFile();
throw;
}
catch (Exception ex)
{
EmailUtility.SendEmail("Other ORMIS DB/SQL EXCEPTION while executing stored procedure: " + "\r\n" + ex.Message, "Import Failed!");
Logger.LogException(ex.Message);
Logger.WriteLogToFile();
throw;
}
}
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;
}
}
