public void CheckChangesReplica(Replica replica)
{
List<ReplicaLog> replicaLogSource = new List<ReplicaLog>();
List<ReplicaLog> replicaLogTerminal = new List<ReplicaLog>();
SqlDatabaseBL sqlDatabaseBL = new SqlDatabaseBL();
MysqlDatabaseBL mysqlDatabaseBL = new MysqlDatabaseBL();
if (replica.StrSourceEngine.Contains("SQL Server"))
{
replicaLogSource = sqlDatabaseBL.GetReplicaLogsSourceUnsynchronized(replica);
}
if (replica.StrSourceEngine.Contains("MySQL"))
{
replicaLogSource = mysqlDatabaseBL.GetReplicaLogsSourceUnsynchronized(replica);
}
if (replica.StrTerminalEngine.Contains("SQL Server"))
{
replicaLogTerminal = sqlDatabaseBL.GetReplicaLogsTerminalUnsynchronized(replica);
}
if (replica.StrTerminalEngine.Contains("MySQL"))
{
replicaLogTerminal = mysqlDatabaseBL.GetReplicaLogsTerminalUnsynchronized(replica);
}
if (replicaLogSource.Count() > 0)
{
//Sync Terminal
foreach (ReplicaLog replicaLog in replicaLogSource)
{
if (replica.StrTerminalEngine.Contains("SQL Server"))
{
sqlDatabaseBL.TableSyncTerminal(replica, replicaLog);
}
if (replica.StrTerminalEngine.Contains("MySQL"))
{
mysqlDatabaseBL.TableSyncTerminal(replica,replicaLog);
}
if (replica.StrSourceEngine.Contains("SQL Server"))
{
sqlDatabaseBL.SetReplicaSourceLogSync(replica, replicaLog);
}
if (replica.StrSourceEngine.Contains("MySQL"))
{
//mysqlDatabaseBL.TableSyncTerminal(replica,replicaLog);
mysqlDatabaseBL.SetReplicaSourceLogSync(replica, replicaLog);
}
}
}
if (replicaLogTerminal.Count() > 0)
{
//Sync Terminal
foreach (ReplicaLog replicaLog in replicaLogTerminal)
{
if (replica.StrSourceEngine.Contains("SQL Server"))
{
sqlDatabaseBL.TableSyncSource(replica, replicaLog);
//sqlDatabaseBL.SetReplicaTerminalLogSync(replica, replicaLog);
}
if (replica.StrSourceEngine.Contains("MySQL"))
{
mysqlDatabaseBL.TableSyncSource(replica, replicaLog);
//sqlDatabaseBL.SetReplicaTerminalLogSync(replica, replicaLog);
}
if (replica.StrTerminalEngine.Contains("SQL Server"))
{
sqlDatabaseBL.SetReplicaTerminalLogSync(replica, replicaLog);
}
if (replica.StrTerminalEngine.Contains("MySQL"))
{
//mysqlDatabaseBL.TableSyncTerminal(replica,replicaLog);
mysqlDatabaseBL.SetReplicaTerminalLogSync(replica, replicaLog);
}
}
}
}
/// <summary>
/// This will configure the Initial Replica requirements on the client
/// </summary>
/// <param name="replica"></param>
public void InitialReplicaClientConfig(Replica replica)
{
//Source Config
Table table = new Table();
SqlDatabaseBL sqlDatabaseBL = new SqlDatabaseBL();
MysqlDatabaseBL mysqlDatabaseBL = new MysqlDatabaseBL();
List<Insert> valuesToInsert = new List<Insert>();
if (replica.StrSourceEngine.Contains("SQL Server"))
{
table = sqlDatabaseBL.ConfigSource(replica);
valuesToInsert = sqlDatabaseBL.GetConfigValues(replica, table);
}
if (replica.StrSourceEngine.Contains("MySQL"))
{
table = mysqlDatabaseBL.ConfigSource(replica);
valuesToInsert = mysqlDatabaseBL.GetConfigValues(replica, table);
}
//Terminal Config
if (replica.StrTerminalEngine.Contains("SQL Server"))
{
sqlDatabaseBL.ConfigTerminal(replica, table, valuesToInsert);
}
if (replica.StrTerminalEngine.Contains("MySQL"))
{
mysqlDatabaseBL.ConfigTerminal(replica, table, valuesToInsert);
}
}