public void Convert(DBHelper source, DBHelper target)
{
using (MD47.DataContext dataContext47 = new MD47.DataContext(string.Empty))
{
// Initialize metadata
MD47.DataContext.Current = dataContext47;
MD47.DataContext.Current.SqlContext.CommandTimeout = _commandTimeout;
SqlTransaction previous45Transaction = MD45.MetaDataContext.Current.Transaction;
SqlTransaction previous47Transaction = MD47.DataContext.Current.SqlContext.Transaction;
//SqlTransaction previousDatabaseTransaction = Mediachase.IBN.Database.DbContext.Current.Transaction;
using (DBTransaction tranSource = source.BeginTransaction())
using (DBTransaction tran = target.BeginTransaction())
{
DBHelper2.Init(source);
MD45.MetaDataContext.Current.Transaction = tranSource.SqlTran;
MD47.DataContext.Current.SqlContext.Transaction = tran.SqlTran;
//Mediachase.IBN.Database.DbContext.Current.Transaction = tran.SqlTran;
try
{
Dictionary <int, OrganizationEntity> organizationsById = new Dictionary <int, OrganizationEntity>();
Dictionary <int, ContactEntity> contactsById = new Dictionary <int, ContactEntity>();
ConvertOrganizations(organizationsById);
string companyLocale = (string)target.RunTextScalar("SELECT [Locale] FROM [LANGUAGES] WHERE [IsDefault]=1");
ConvertContacts(companyLocale, organizationsById, contactsById);
UpdateObjects(target, organizationsById, contactsById);
//Update email boxes
UpdateXmlInDatabase(target, organizationsById, contactsById, new ProcessXmlDelegate(UpdateEmailBoxes), "EMailRouterPop3Box", "EMailRouterPop3BoxId", "Settings");
// Update reports
UpdateXmlInDatabase(target, organizationsById, contactsById, new ProcessXmlDelegate(UpdateReports), "Report", "ReportId", "IBNReportTemplate");
tran.Commit();
}
finally
{
MD45.MetaDataContext.Current.Transaction = previous45Transaction;
MD47.DataContext.Current.SqlContext.Transaction = previous47Transaction;
//Mediachase.IBN.Database.DbContext.Current.Transaction = previousDatabaseTransaction;
}
}
}
}
static void Update()
{
LogFile.WriteMessageFormat("*** Updating Mediachase {0} ***", IbnConst.ProductName);
//GlobalContext.Current = new GlobalContext(Settings.InstallDirWeb + @"portal\Apps");
DBHelper2.Init(new DBHelper(string.Format(CultureInfo.InvariantCulture, "Data source={0};Initial catalog=master;User Id={1};Password={2};Connection Timeout=36000", Settings.SqlServer, Settings.SqlUser, Settings.SqlPassword)));
DBHelper2.DBHelper.CommandTimeout = CommandTimeout;
IConfigurator configurator = Configurator.Create();
IIisManager oldIisManager = IisManager.Create(Settings.InstallDirWeb);
bool x64 = oldIisManager.Is64Bit();
// Get copmanies
CompanyInfo[] oldCompanies = CompanyInfo.ListCompanies(DBHelper2.DBHelper);
bool isAsp = (oldCompanies.Length > 1);
List <string> newCompanies = ListNewCompanies(configurator);
bool firstLaunch = (newCompanies == null);
List <CompanyInfo> companies = new List <CompanyInfo>();
if (firstLaunch)
{
companies.AddRange(oldCompanies);
}
else
{
foreach (CompanyInfo oldCompany in oldCompanies)
{
if (!newCompanies.Contains(oldCompany.Host))
{
companies.Add(oldCompany);
}
}
}
string newAspPath = Path.Combine(Settings.InstallDir, "Asp");
string codePath = Path.Combine(Settings.InstallDir, "Code");
string sourcePath = Path.Combine(codePath, "_Source");
string newWebPath = Path.Combine(sourcePath, "Web");
try
{
// Stop old web site
oldIisManager.StopSite(Settings.SiteId);
// Stop old services
if (firstLaunch)
{
StopService("AlertService" + IbnConst.VersionMajorMinor, false);
StopService("McOleDBService" + IbnConst.VersionMajorMinor, false);
StopService("ScheduleService" + IbnConst.VersionMajorMinor, false);
// Unregister old components
RegisterComponents(false, GetOldComponents());
// Unregister old IM Server
RegisterIMServer(false, Settings.InstallDirWeb, x64);
// TODO: ? Delete ISAPI extension
// TODO: ? Delete portal application pool
// TODO: ? Delete IM application pool
// Copy old files to new location: InstallPath\Code\_Source
LogFile.WriteLine("Copying old files to new location...");
CopyDirectory(Path.Combine(Settings.InstallDir, @"Web\Asp"), newAspPath);
CopyDirectory(Settings.InstallDir, sourcePath, "Tools");
CopyDirectory(Settings.InstallDir, sourcePath, @"Web\Download");
CopyDirectory(Settings.InstallDir, sourcePath, @"Web\instmsg");
CopyDirectory(Settings.InstallDir, sourcePath, @"Web\instmsg64");
CopyDirectory(Settings.InstallDir, sourcePath, @"Web\Portal");
LogWriteOk();
// Delete error logs
Directory.Delete(Path.Combine(sourcePath, @"Web\Portal\Admin\Log\Error"), true);
// Update files
UpdateFiles();
// Register new components
RegisterComponents(true, GetNewComponents());
// Register new IM Server
RegisterIMServer(true, newWebPath, x64);
// Start new services
StartNewServices();
}
firstLaunch = false;
Pause("Restore clean databases.");
for (int i = 0; i < companies.Count; i++)
{
CompanyInfo company = companies[i];
LogFile.WriteMessageFormat("* Converting company {0} of {1}: '{2}' *", i + 1, companies.Count, company.Host);
try
{
ConvertCompany(configurator, isAsp, company);
// Delete binding from old web site
try
{
if (isAsp)
{
oldIisManager.DeleteBinding(Settings.SiteId, company.Host);
}
}
catch
{
}
LogFile.WriteLine("* OK *");
}
catch (Exception ex)
{
LogFile.WriteLine("* Failed *");
LogFile.WriteLine("");
if (isAsp)
{
LogFile.WriteLine(ex.ToString());
}
else
{
throw;
}
}
}
Settings.SaveVersion();
Pause("Backup databases.");
LogFile.WriteLine("*** OK ***");
}
catch (Exception ex)
{
LogFile.WriteLine("*** Failed ***");
LogFile.WriteLine("");
LogFile.WriteLine(ex.ToString());
LogFile.WriteLine("");
LogFile.WriteLine("Rollback started");
#region Undo changes
try
{
if (!isAsp || firstLaunch)
{
// Unregister new components
try
{
RegisterComponents(false, GetNewComponents());
}
catch
{
}
// Unregister new IM server
try
{
RegisterIMServer(false, newWebPath, x64);
}
catch
{
}
// Recover files
try
{
RecoverFiles();
}
catch
{
}
// Delete [InstallDir]\Code
try
{
Directory.Delete(codePath, true);
}
catch
{
}
// Delete [InstallDir]\Asp
try
{
Directory.Delete(newAspPath, true);
}
catch
{
}
// Register old components
try
{
RegisterComponents(true, GetOldComponents());
}
catch
{
}
// Register old IM Server
try
{
RegisterIMServer(true, Settings.InstallDirWeb, x64);
}
catch
{
}
// Start old services
try
{
StartOldServices();
}
catch
{
}
}
// Start old web site
try
{
oldIisManager.StartSite(Settings.SiteId);
}
catch
{
}
}
catch
{
}
#endregion
LogFile.WriteLine("Rollback finished");
throw;
}
finally
{
LogFile.WriteLine("");
// Delete backup files
DeleteBackupFiles();
}
}
static void Esegui(string[] args)
{
///
//imposto il punto come separatore dei decimali, per accontentare Sql server (cyber plan frontiera)
///
System.Globalization.CultureInfo customCulture = (System.Globalization.CultureInfo)System.Threading.Thread.CurrentThread.CurrentCulture.Clone();
customCulture.NumberFormat.NumberDecimalSeparator = ".";
System.Threading.Thread.CurrentThread.CurrentCulture = customCulture;
///
///
_logger.Info("START - argomenti: " + string.Join(" ", args) + " ------------------");
#if !DEBUG
try
{
#endif
bool help = false;
bool _mode_all = false;
bool _delete = false;
//_logger.Info("START at " + DateTime.Now.ToString() + " ----------------argomenti: " + string.Join(" ", args) + " ------------------");
//_logger.Info("START - argomenti: " + string.Join(" ", args) + " ------------------");
if (args[0].ToUpper() == "INIT_CYB")
{
CYBER_qry.Init();
return;
}
else if (args[0].ToUpper() == "START")
{
// Invio una mail di avviso INIZIO caricamento dati in frontiera Cyb"
Utils.SendMail_StatusMsg(Settings.GetSettings(), "Starting load data into Cyberplan", "STARTING LOAD DATA INTO CYBERPLAN from " + args[1].ToUpper(), "START UPLOADING");
CYBER_qry.SetStatus("Running");
return;
}
else if (args[0].ToUpper() == "STOP")
{
// Invio una mail di avviso FINE caricamento dati in frontiera Cyb"
Utils.SendMail_StatusMsg(Settings.GetSettings(), "End load data into Cyberplan", "END LOAD DATA INTO CYBERPLAN from " + args[1].ToUpper(), "UPLOAD COMPLETED");
CYBER_qry.SetStatus("Completed");
return;
}
else if (args[0].ToUpper() == "FINALCHECK")
{
CYBER_qry.FinalCheck(args[1].ToUpper().Trim());
return;
}
else if (args[0].ToUpper() == "X3WS")
{
help = true;
if (args.Length == 4)
{
string dossier = args[1];
if (dossier == "SAURO" || dossier == "SAURODEV" || dossier == "SAUROTEST" || dossier == "SAUROINT")
{
string tmparg = args[2];
string tmpcreaopr = args[3];
if (tmparg == "MRP" && (tmpcreaopr == "CREAOPR=no" || tmpcreaopr == "CREAOPR=si"))
{
tmpcreaopr = tmpcreaopr.Replace("CREAOPR=", "");
bool creaopr = (tmpcreaopr.ToLower() == "si" ? true : false);
Export exp = new Export();
exp.ExportAllTaskNumber(dossier, creaopr);
// non ha senso. il trigger importa sempre tutti i file che trova. Va gestito la creazione del file di export per as400
//if (creaopr == true)
//{
// // se creo il file OPR x importazione in As400 allora lancio anche il trigger per l'elaborazione del file da AS400
// AS400HelperTrigger AS400Trg = new AS400HelperTrigger("S2TESTMRP");
// AS400Trg.ExecuteTrigger();
//}
return;
}
}
}
}
else if (args[0].ToUpper() == "OPRAS400")
{
OrdiniAcq_OPR_As400_FIRSTIMPORT.GetFileImport_YMFG_Sage();
}
else if (args[0].ToUpper() == "TRG")
{
AS400HelperTrigger AS400Trg = new AS400HelperTrigger("S2TESTMRP");
AS400Trg.ExecuteTrigger();
}
if (args.Length < 4 || help == true)
{
_logger.Info("\n\n\nSintassi:\n" +
"SyncCyberPlan DOSSIER LIBRERIAAS400 DELETE|ALLTIME|LAST=N OGG [COD=CODICELIKE]\n\n" + //parametri opzionali alla fine
"Comandi disponibili: \n" +
"DELETE per azzerare la tabella di frontiera di CyberPlane \n" +
" (per gli oggetti XXX-YYY le prime lettere XXX identificano la tabella)\n" +
"ALLTIME per ottenere tutti i valori\n" +
"LAST=N per ottenere solo i valori degli ultimi N giorni\n" +
"OGG= \n" +
" BPR terzi da sage a cyb\n" +
" POH-ODM ordini di acquisto da sage a cyb\n" +
//" POH-OFA ordini di acquisto da sage a cyb\n" +
" ITM articolo da sage a cyb\n" +
" MAC macchine da sage a cyb\n" +
" ATT attrezzature da sage a cyb\n" +
" CIC cicli da ITM da sage a cyb\n" +
"\n" +
" POH-OPR ordini di produzione da as400 a cyb\n" +
" SOH ordini di vendita da as400 a cyb\n" +
" LOC locazioni magazzini da as400 a cyb\n" +
" GIAC giacenze magazzino PQM00PF da as400 a cyb\n" +
" GIAC-ALL giacenze allocate ORR00PF da as400 a cyb\n" +
" DISBAS distinta base SPR00PF da as400 a cyb\n" +
" DEM Fabbisogni OPR in corso MFC00PF da as400 a cyb\n" +
"COD = WP% per ottenere un filtro sui codici\n" +
"\n" +
"SyncCyberPlan START prima di iniziare sync tabelle CyberPlan\n" +
"SyncCyberPlan STOP alla fine del sync tabelle CyberPlan\n" +
"SyncCyberPlan INIT_CYB per inizializzare tabelle CyberPlan\n" +
"SyncCyberPlan FINALCHECK per far partire i controlli finali (solo in effettivo)\n\n" +
"SyncCyberPlan X3WS DOSSIER [MRP|] CREAOPR=si/no per chiamate ai WebService di X3 \n" +
" MRP scatena import da CyberPlan verso X3" +
" CREAOPR=si/no con 'si' crea gli OPR che arrivano da as400 ma non esistono in Sage (per l'avvio) \n\n" +
"SyncCyberPlan TRG DOSSIER attiva il trigger di importazione OPR da Sage \n\n" +
"OPRAS400 per ottenere il file per l'import INIZIALE da As400, mette il file in YSAURO\\IMPEXP \n" +
" solo da dati in effettivo (crea un file)"
);
}
else
{
int indexargs = 0;
string codicelike = "";
string oggetto = "";
string nomefile = "";
///////////////////ARG index 0-1
string dossier = args[indexargs].ToUpper();
indexargs++;
string libreriaas400 = args[indexargs].ToUpper();
///////////////////ARG index 2
indexargs++;
string _cur_arg = args[indexargs].ToUpper();
string nomefileTMP = "SyncCyberPlan_" + _cur_arg + "_" + System.DateTime.Now.ToString("yyyyMMddHHmmss") + ".txt";
nomefileTMP = nomefileTMP.Replace("=", "");
if (_cur_arg == "DELETE")
{
_logger.Debug(_cur_arg);
_delete = true;
}
else if (_cur_arg == "ALLTIME")
{
_logger.Debug(_cur_arg);
_mode_all = true;
}
else if (_cur_arg.StartsWith("LAST="))
{
_logger.Debug(_cur_arg);
_mode_all = false;
if (!SetLASTDAYS(_cur_arg.Replace("LAST=", "")))
{
_logger.Error("parametro LAST non corretto");
return;
}
}
else
{
_logger.Error("comando con parametri errati: " + string.Join(" ", args));
return;
}
indexargs++;
oggetto = args[indexargs].ToUpper();
if (oggetto == "ITM" ||
oggetto == "LOC" ||
oggetto == "MAC" ||
oggetto == "ATT" ||
oggetto == "CIC" ||
oggetto == "BPR" ||
oggetto == "SOH" ||
oggetto == "POH-ODM"
//|| oggetto == "POH-OFA"
|| oggetto == "OPR" ||
oggetto == "GIAC" ||
oggetto == "DISBAS" ||
oggetto == "DEM"
)
{
}
else
{
_logger.Error("comando con parametro oggetto errato: " + string.Join(" ", args));
return;
}
///////////////////ARG index >=N parametri opzionali
indexargs++;
for (; indexargs < args.Length; indexargs++)
{
_cur_arg = args[indexargs].ToUpper();
if (_cur_arg.StartsWith("COD=") && codicelike == "")
{
codicelike = _cur_arg.Substring(_cur_arg.IndexOf('=') + 1);
//_logger.Info("codice like = " + codicelike);
}
else if (nomefile == "")
{
_cur_arg = args[indexargs];//per non avere il ToUpper
nomefile = _cur_arg;
}
else
{
_logger.Error("Parametri errati");
return;
}
}
if (nomefile == "")
{
nomefile = nomefileTMP;
}
_logger.Debug(System.Reflection.MethodBase.GetCurrentMethod().Name + " nome file = " + nomefile);
///////////////////FINE ARG
///////////////////FINE ARG
///////////////////FINE ARG
DBHelper2 as400 = DBHelper2.getAs400DBHelper(libreriaas400);
DBHelper2 sage = DBHelper2.getSageDBHelper(dossier);
DBHelper2 cyber = DBHelper2.getCyberDBHelper();
//SageTable_Manager sm = new SageTable_Manager(dossier);
//As400Table_Manager am = new As400Table_Manager();
switch (oggetto)
{
//da sage
case "ITM":
sage.WriteToCyberPlan <Articolo>(_mode_all, codicelike, "", _delete, "");
//aggiunto vista FAMPEX sm.WriteToCyberPlan<Articolo_Caratteristiche>(_mode_all, codicelike, "", _delete, "");
break;
case "CIC":
//ho aggiunto questo if per timore che quelli di CyberPlan non svuotino le tabelle
//sm.WriteToCyberPlan<Cicli_Routing_Header>(_mode_all, codicelike, "", _delete, "");
if (_delete)
{
DBHelper2.EseguiSuDBCyberPlan(ref cyber, "DELETE FROM [CyberPlanFrontiera].[dbo].[CYB_STD_OPERATION] where 1=1 ");
}
//sm.WriteToCyberPlan<Std_Operation>(_mode_all, codicelike, "", _delete, "");
sage.WriteToCyberPlan <Std_Op_Machine>(_mode_all, codicelike, "", _delete, "");
//sm.WriteToCyberPlan<Std_Op_Machine_ASSE>(_mode_all, codicelike, "", _delete, "");
sage.WriteToCyberPlan <Item_Routing>(_mode_all, codicelike, "", _delete, "");
//sm.WriteToCyberPlan<Item_Routing_ASSE>(_mode_all, codicelike, "", _delete, "");
//sm.WriteToCyberPlan<Item_Routing_PLAS>(_mode_all, codicelike, "", _delete, "");
break;
case "BPR": sage.WriteToCyberPlan <Terzo>(_mode_all, codicelike, "", _delete, ""); break;
case "POH-ODM": sage.WriteToCyberPlan <OrdiniAcq_ODM>(_mode_all, codicelike, "", _delete, ""); break;
//case "POH-OFA": sm.WriteToCyberPlan<OrdiniAcq_OFA>(_mode_all, codicelike, "", _delete, ""); break;
case "MAC": sage.WriteToCyberPlan <Macchina>(_mode_all, codicelike, "", _delete, ""); break;
case "ATT": //sm.WriteToCyberPlan<Attrezzature_ASSE>(_mode_all, codicelike, "", _delete, "");
sage.WriteToCyberPlan <Attrezzature>(_mode_all, codicelike, "", _delete, "");
sage.WriteToCyberPlan <Attrezzature_ConfigPlas>(_mode_all, codicelike, "", _delete, "");
break;
case "DISBAS": sage.WriteToCyberPlan <DistintaBase>(_mode_all, codicelike, "", _delete, ""); break;
case "SOH": sage.WriteToCyberPlan <OrdiniVen>(_mode_all, codicelike, "", _delete, ""); break;
//da as400
case "LOC": as400.WriteToCyberPlan <Locazione>(_mode_all, codicelike, "", _delete, ""); break;
//case "SOH": as400.WriteToCyberPlan<OrdiniVen_as400>(_mode_all, codicelike, "", _delete, ""); break;
case "OPR":
as400.WriteToCyberPlan <OrdiniAcq_OPR_As400>(_mode_all, codicelike, "", _delete, "");
//Operazioni: OPR da AS400
as400.WriteToCyberPlan <Operations_As400>(_mode_all, codicelike, "", _delete, "");
break;
case "OPRX3":
sage.WriteToCyberPlan <OrdiniAcq_OPR>(_mode_all, codicelike, "", _delete, "");
//Operazioni: OPR da DA SAGE
sage.WriteToCyberPlan <Operations>(_mode_all, codicelike, "", _delete, "");
break;
case "GIAC":
as400.WriteToCyberPlan <Giacenze_ORR00PF>(_mode_all, codicelike, "", _delete, "");
as400.WriteToCyberPlan <Giacenze_PQM00PF>(_mode_all, codicelike, "", _delete, ""); //interne
as400.WriteToCyberPlan <Giacenze_PQM00PF_esterne>(_mode_all, codicelike, "", _delete, "");
break;
//case "DISBAS": as400.WriteToCyberPlan<DistintaBase_As400>(_mode_all, codicelike, "", _delete, ""); break;
case "DEM": as400.WriteToCyberPlan <Demand_OPR_righe_As400>(_mode_all, codicelike, "", _delete, ""); break;
//case "DEM": sage.WriteToCyberPlan<Demand_OPR_righe>(_mode_all, codicelike, "", _delete, ""); break;
default: _logger.Error(_cur_arg + ": tipo articolo non previsto"); return;
}
}
//_logger.Info("END at " + DateTime.Now.ToString() + " ----------------");
#if !DEBUG
}
catch (Exception ex)
{
_logger.Error(string.Join(" ", args) + "\n" + ex.ToString());
Utils.SendMail_IT(Settings.GetSettings(), string.Join(" ", args) + "\n\n\n" + ex.ToString(), true);
}
#endif
_logger.Info("END ---------------------------------");
}
