static void Main(string[] args)
{
Logger.LogWrite("MSG", "Start: " + DateTime.Now.ToString());
// Declare and defaults
int odbcCnt = 0;
int insertCnt = 0;
int importCnt = 0;
int arborCnt = 0;
#region FromSTRATIX
ODBCData objODBC = new ODBCData();
List <IPTFRA> lstIPTFRA = new List <IPTFRA>();
try
{
lstIPTFRA = objODBC.Get_IPTFRA();
}
catch (Exception ex)
{
Logger.LogWrite("EXC", ex);
Logger.LogWrite("MSG", "Return");
return;
}
#endregion
#region ToSQL
SQLData objSQL = new SQLData();
// Only work in SQL database, if records were retreived from Stratix
if (lstIPTFRA.Count != 0)
{
odbcCnt = lstIPTFRA.Count;
// Put Stratix data in lstIPTFRA into IMPORT IPTFRA table
try
{
importCnt = objSQL.Write_IPTFRA_IMPORT(lstIPTFRA);
}
catch (Exception ex)
{
Logger.LogWrite("EXC", ex);
Logger.LogWrite("MSG", "Return");
return;
}
/*
* Build a more useful arbor from the Stratix data for each job
* Build Arbor from IMPORT and into Arbor table
*/
try
{
arborCnt = objSQL.Build_Arbor();
}
catch (Exception ex)
{
Logger.LogWrite("EXC", ex);
Logger.LogWrite("MSG", "Return");
return;
}
// Call SP to put IMPORT IPTFRA table data into WIP IPTFRA table
try
{
insertCnt = objSQL.Write_IMPORT_to_IPTFRA();
}
catch (Exception ex)
{
Logger.LogWrite("EXC", ex);
Logger.LogWrite("MSG", "Return");
return;
}
Logger.LogWrite("MSG", "ODBC/IMPORT/ARBOR/INSERT=" + odbcCnt.ToString() + ":" + importCnt.ToString() + ":" + arborCnt.ToString() + ":" + insertCnt.ToString());
}
else
{
Logger.LogWrite("MSG", "No data");
}
Logger.LogWrite("MSG", "End: " + DateTime.Now.ToString());
#endregion
// Testing
//Console.WriteLine("Press key to exit");
//Console.ReadKey();
}