public void ConfigTerminal(Replica replica, Table table, List<Insert> valuesToInsert) { SqlDatabaseDA sqlDatabaseAccess = new SqlDatabaseDA(replica.StrTerminalUser, replica.StrTerminalPassword, replica.StrTerminalIPAddress, replica.IntTerminalPort.ToString(), replica.StrTerminalDatabase); sqlDatabaseAccess.CreateReplicaLogs(); sqlDatabaseAccess.createTable(table); sqlDatabaseAccess.ExecuteMultipleInsert(valuesToInsert); sqlDatabaseAccess.CreateTrigger(table); }
public Table ConfigSource(Replica replica) { SqlDatabaseDA sqlDatabaseAccess = new SqlDatabaseDA(replica.StrSourceUser, replica.StrSourcePassword, replica.StrSourceIPAddress, replica.IntSourcePort.ToString(), replica.StrSourceDatabase); sqlDatabaseAccess.CreateReplicaLogs(); //GEtTabe Table table = sqlDatabaseAccess.getTableStructure(replica.StrSourceDatabase, replica.StrSourceTable); //valuesToInsert = sqlDatabaseAccess.GetCurrentRows(table); sqlDatabaseAccess.CreateTrigger(table); return table; }
public Boolean TableSyncTerminal(Replica replica, ReplicaLog replicaLog) { SqlDatabaseDA sqlDatabaseAccess = new SqlDatabaseDA(replica.StrTerminalUser, replica.StrTerminalPassword, replica.StrTerminalIPAddress, replica.IntTerminalPort.ToString(), replica.StrTerminalDatabase); return sqlDatabaseAccess.TableSync(replica.StrSourceTable, replicaLog.StrReplicaTransaction); }
public Boolean SetReplicaTerminalLogSync(Replica replica, ReplicaLog oreplicaLog) { SqlDatabaseDA sqlDatabaseAccess = new SqlDatabaseDA(replica.StrTerminalUser, replica.StrTerminalPassword, replica.StrTerminalIPAddress, replica.IntTerminalPort.ToString(), replica.StrTerminalDatabase); return sqlDatabaseAccess.SetReplicaLogSync(oreplicaLog); }
public Boolean SetReplicaSourceLogSync(Replica replica,ReplicaLog oreplicaLog) { SqlDatabaseDA sqlDatabaseAccess = new SqlDatabaseDA(replica.StrSourceUser, replica.StrSourcePassword, replica.StrSourceIPAddress, replica.IntSourcePort.ToString(), replica.StrSourceDatabase); return sqlDatabaseAccess.SetReplicaLogSync(oreplicaLog); }
public List<Table> GetTables(string user, string password, string server, string port, string database) { SqlDatabaseDA sqlDatabaseDA = new SqlDatabaseDA(user, password, server, port, database); return sqlDatabaseDA.GetAllTables(database); }
public List<ReplicaLog> GetReplicaLogsTerminalUnsynchronized(Replica replica) { SqlDatabaseDA sqlDatabaseAccess = new SqlDatabaseDA(replica.StrTerminalUser, replica.StrTerminalPassword, replica.StrTerminalIPAddress, replica.IntTerminalPort.ToString(), replica.StrTerminalDatabase); return sqlDatabaseAccess.GetReplicaLogsUnsynchronized(replica.StrSourceTable); }
/// <summary> /// Sql Method to obtain Tables on DB /// </summary> /// <param name="user"></param> /// <param name="password"></param> /// <param name="server"></param> /// <param name="port"></param> /// <returns></returns> public List<Database> GetDatabases(string user, string password, string server, string port) { SqlDatabaseDA sqlDatabaseDA = new SqlDatabaseDA(user, password, server, port); return sqlDatabaseDA.GetAllDatabases(); }
public List<Insert> GetConfigValues(Replica replica, Table table) { SqlDatabaseDA sqlDatabaseAccess = new SqlDatabaseDA(replica.StrSourceUser, replica.StrSourcePassword, replica.StrSourceIPAddress, replica.IntSourcePort.ToString(), replica.StrSourceDatabase); return sqlDatabaseAccess.GetCurrentRows(table); }