static void Main(string[] args)
{
try
{
var q = new SqlConnectionStringBuilder()
{
DataSource = @"tcp:192.168.0.134, 1444",
InitialCatalog = @"SCME_ResultsDB",
IntegratedSecurity = false,
UserID = "sa",
Password = "******",
ConnectTimeout = 15
};
var mssqlDbService = new MSSQLDbService(new SqlConnection(q.ToString()));
var msSqlDbServiceProxy = new DatabaseProxy("SCME.CentralDatabase");
var centralProfiles = msSqlDbServiceProxy.GetProfilesDeepByMmeCode("MME007");
var centralProfiles1 = msSqlDbServiceProxy.GetProfilesDeepByMmeCode("MME007");
foreach (var i in centralProfiles1)
{
i.Version++;
i.Timestamp = DateTime.Now;
i.Key = Guid.NewGuid();
i.Id = 0;
}
var w = centralProfiles.Zip(centralProfiles1, (m, n) => new { oldP = m, newP = n }).ToList();
int qwe = 0;
foreach (var i in w)
{
mssqlDbService.InsertUpdateProfile(i.oldP, i.newP, "MME007");
qwe++;
}
}
catch (Exception ex)
{
File.WriteAllText("error.txt", ex.ToString());
}
}
static void Main(string[] args)
{
string mmeCode = "MME013";
SQLiteDbService q = new SQLiteDbService(new SQLiteConnection(new SQLiteConnectionStringBuilder()
{
DataSource = "SCME_ResultsDB_Local.sqlite",
DefaultTimeout = 15,
SyncMode = SynchronizationModes.Full,
JournalMode = SQLiteJournalModeEnum.Truncate,
FailIfMissing = true
}.ToString()));
var w = new MSSQLDbService(new SqlConnection(new SqlConnectionStringBuilder()
{
DataSource = @"tcp:192.168.0.134, 1444",
InitialCatalog = "SCME_ResultsDB",
IntegratedSecurity = false,
ConnectTimeout = 15,
UserID = "sa",
Password = "******"
}.ToString()));
if (w.GetMmeCodes().Count(m => m.Key == mmeCode) == 0)
{
w.InsertMmeCode(mmeCode);
}
var e = q.GetProfilesDeepByMmeCode(mmeCode);
foreach (var i in e)
{
w.InsertUpdateProfile(null, i, mmeCode);
}
e = null;
}
internal static void StartService()
{
Journal = new LogJournal();
try
{
var path = String.Format(Settings.Default.LogPathTemplate,
DateTime.Now.ToString(CultureInfo.CurrentCulture).Replace('/', '_').Replace(':', '_'));
if (!Path.IsPathRooted(path))
{
path = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, path);
}
Journal.Open(path, true, true);
}
catch (Exception ex)
{
LogCriticalErrorMessage(ex);
return;
}
// try
// {
// SQLDatabaseService dbForMigration = new SQLDatabaseService(SQLCentralDatabaseService.GetConnectionStringFromSettings(Settings.Default));
// dbForMigration.Open();
// dbForMigration.Migrate();
// dbForMigration.Close();
// }
// catch (Exception ex)
// {
// Journal.AppendLog("Central DB SQL SERVER migration", LogJournalMessageType.Error, String.Format("Migrate database error: {0}", ex.Message));
// return;
// }
try
{
var service = new SQLCentralDatabaseService(Settings.Default);
ms_ServiceHost = new ServiceHost(service);
var behaviour = ms_ServiceHost.Description.Behaviors.Find <ServiceBehaviorAttribute>();
behaviour.InstanceContextMode = InstanceContextMode.Single;
ms_ServiceHost.Open();
}
catch (Exception ex)
{
Journal.AppendLog("SystemHost", LogJournalMessageType.Error,
$"Error starting database service: {ex.Message}");
return;
}
try
{
MSSQLDbService mssqlDbService;
_databaseServiceHost = new ServiceHost(mssqlDbService = new MSSQLDbService(new SqlConnection(new SqlConnectionStringBuilder()
{
DataSource = Settings.Default.DbPath,
InitialCatalog = Settings.Default.DBName,
IntegratedSecurity = Settings.Default.DBIntegratedSecurity,
UserID = Settings.Default.DBUser,
Password = Settings.Default.DBPassword,
ConnectTimeout = 5
}.ToString()), false));
var behaviour = _databaseServiceHost.Description.Behaviors.Find <ServiceBehaviorAttribute>();
behaviour.InstanceContextMode = InstanceContextMode.Single;
mssqlDbService.Migrate();
_databaseServiceHost.Open();
}
catch (Exception ex)
{
Journal.AppendLog("SystemHost", LogJournalMessageType.Error,
$"Error starting database service: {ex?.InnerException?.ToString() ?? ex.ToString()}");
return;
}
Journal.AppendLog("SystemHost", LogJournalMessageType.Info,
$"SCME database service started on {_databaseServiceHost.BaseAddresses.FirstOrDefault()}");
}
