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 Table ConfigSource(Replica replica)
        {
            MysqlDatabaseDA sqlDatabaseAccess = new MysqlDatabaseDA(replica.StrSourceUser, replica.StrSourcePassword, replica.StrSourceIPAddress, replica.IntSourcePort.ToString(), replica.StrSourceDatabase);
            sqlDatabaseAccess.CreateReplicaLogs();
            Table table = sqlDatabaseAccess.getTableStructure(replica.StrSourceDatabase, replica.StrSourceTable);

            sqlDatabaseAccess.CreateTriggerDelete(table);
            sqlDatabaseAccess.CreateTriggerInsert(table);
            sqlDatabaseAccess.CreateTriggerUpdate(table);
            return table;
        }
 public ReplicaView(Replica replica)
 {
     //IdReplica = replica.IntIdReplica;
     //IdSourceEngine = replica.IntIdSourceEngine;
     SourceEngine = replica.StrSourceEngine;
     SourceIPAddress = replica.StrSourceIPAddress;
     SourcePort = replica.IntSourcePort;
     SourceUser = replica.StrSourceUser;
     SourcePassword = replica.StrSourcePassword;
     SourceDatabase = replica.StrSourceDatabase;
     SourceTable = replica.StrSourceTable;
     //IdTerminalEngine = replica.IntIdTerminalEngine;
     TerminalEngine = replica.StrTerminalEngine;
     TerminalIPAddress = replica.StrTerminalIPAddress;
     TerminalPort = replica.IntTerminalPort;
     TerminalUser = replica.StrTerminalUser;
     TerminalPassword = replica.StrTerminalPassword;
     TerminalDatabase = replica.StrTerminalDatabase;
     Enable = replica.BoolEnable;
     Created =replica.StrCreated;
     LastCheckOnSource = replica.StrLastCheckOnSource;
     LastCheckOnTerminal = replica.StrLastCheckOnTerminal;
 }
 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<ReplicaLog> GetReplicaLogsTerminalUnsynchronized(Replica replica)
 {
     SqlDatabaseDA sqlDatabaseAccess = new SqlDatabaseDA(replica.StrTerminalUser, replica.StrTerminalPassword, replica.StrTerminalIPAddress, replica.IntTerminalPort.ToString(), replica.StrTerminalDatabase);
     return sqlDatabaseAccess.GetReplicaLogsUnsynchronized(replica.StrSourceTable);
 }
 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);
 }
示例#10
0
        public Boolean Insert(Replica newReplica)
        {
            string strQuery = string.Empty;
            Boolean result = false;

            try
            {
                this.OpenConnection();

                strQuery = "InsertReplica";
                SqlCommand cmdComando = new SqlCommand(strQuery, this._oConnection);
                cmdComando.CommandType = CommandType.StoredProcedure;

                cmdComando.Parameters.AddWithValue("@intIdSourceEngine", newReplica.IntIdSourceEngine);
                cmdComando.Parameters.AddWithValue("@strSourceIPAddress", newReplica.StrSourceIPAddress);
                cmdComando.Parameters.AddWithValue("@intSourcePort", newReplica.IntSourcePort);
                cmdComando.Parameters.AddWithValue("@strSourceUser", newReplica.StrSourceUser);
                cmdComando.Parameters.AddWithValue("@strSourcePassword", newReplica.StrSourcePassword);
                cmdComando.Parameters.AddWithValue("@strSourceDatabase", newReplica.StrSourceDatabase);
                cmdComando.Parameters.AddWithValue("@strSourceTable", newReplica.StrSourceTable);
                cmdComando.Parameters.AddWithValue("@intIdTerminalEngine", newReplica.IntIdTerminalEngine);
                cmdComando.Parameters.AddWithValue("@strTerminalIPAddress", newReplica.StrTerminalIPAddress);
                cmdComando.Parameters.AddWithValue("@intTerminalPort", newReplica.IntTerminalPort);
                cmdComando.Parameters.AddWithValue("@strTerminalUser", newReplica.StrTerminalUser);
                cmdComando.Parameters.AddWithValue("@strTerminalPassword", newReplica.StrTerminalPassword);
                cmdComando.Parameters.AddWithValue("@strTerminalDatabase", newReplica.StrTerminalDatabase);

                cmdComando.Parameters.Add("@intResult", SqlDbType.Int).Direction = ParameterDirection.Output;

                cmdComando.ExecuteScalar();

                int intResultado = Int32.Parse(cmdComando.Parameters["@intResult"].Value.ToString());

                if (intResultado == 0)
                    result = true;
            }
            catch (Exception ex)
            {
                this._oLogErrors.GuardarLog(IConstantes.TIPOCAPA.ACCESODATOS, this.GetType().ToString(), MethodInfo.GetCurrentMethod().Name, ex.Message, strQuery);
            }
            finally {

                this.CloseConnection();

            }
            return result;
        }
示例#11
0
        /// <summary>
        /// This is the DA for accessing the Replica table
        /// Date: 9/4/2014
        /// Created By: Juan Pablo Arias Mora
        /// </summary>
        /// <returns>A list of all the Replicas on the table, List<Replica></returns>
        public List<Replica> GetAllReplicas()
        {
            Replica oReplica = new Replica();
            List<Replica> listResult = new List<Replica>();
            string strQuery = string.Empty;
            SqlDataReader dtrResult = null;
            DataTable dtResult = new DataTable();

            try
            {
                this.OpenConnection();

                strQuery = "GetAllReplicas";
                SqlCommand cmdComando = new SqlCommand(strQuery, this._oConnection);
                cmdComando.CommandType = CommandType.StoredProcedure;

                cmdComando.Parameters.Add("@intResult", SqlDbType.Int).Direction = ParameterDirection.Output;

                dtrResult = cmdComando.ExecuteReader();

                //Load the Results on the DataTable
                dtResult.Load(dtrResult);

                foreach (DataRow dtrFila in dtResult.Rows)
                {
                    oReplica = new Replica();
                    oReplica.IntIdReplica = Convert.ToInt32(dtrFila["idReplica"].ToString());
                    oReplica.StrSourceEngine = dtrFila["SourceEngine"].ToString();
                    oReplica.IntIdSourceEngine = Convert.ToInt32(dtrFila["IdSourceEngine"].ToString());
                    oReplica.StrTerminalEngine =  dtrFila["TerminalEngine"].ToString();
                    oReplica.IntIdTerminalEngine = Convert.ToInt32(dtrFila["IdTerminalEngine"].ToString());
                    oReplica.StrSourceIPAddress = dtrFila["SourceIPAddress"].ToString();
                    oReplica.IntSourcePort = Convert.ToInt32(dtrFila["SourcePort"].ToString());
                    oReplica.StrSourceUser = dtrFila["SourceUser"].ToString();
                    oReplica.StrSourcePassword = dtrFila["SourcePassword"].ToString();
                    oReplica.StrSourceDatabase = dtrFila["SourceDatabase"].ToString();
                    oReplica.StrSourceTable = dtrFila["SourceTable"].ToString();
                    oReplica.StrTerminalIPAddress = dtrFila["TerminalIPAddress"].ToString();
                    oReplica.IntTerminalPort = Convert.ToInt32(dtrFila["TerminalPort"].ToString());
                    oReplica.StrTerminalUser =  dtrFila["TerminalUser"].ToString();
                    oReplica.StrTerminalPassword = dtrFila["TerminalPassword"].ToString();
                    oReplica.StrTerminalDatabase = dtrFila["TerminalDatabase"].ToString();
                    oReplica.BoolEnable = Convert.ToBoolean(dtrFila["Enable"].ToString());
                    oReplica.StrCreated = dtrFila["Created"].ToString();

                    object value = dtrFila["LastCheckOnSource"];
                    if (value != DBNull.Value)
                    {
                        oReplica.StrLastCheckOnSource = dtrFila["LastCheckOnSource"].ToString();
                    }

                    value = dtrFila["LastCheckOnTerminal"];
                    if (value != DBNull.Value)
                    {
                        oReplica.StrLastCheckOnSource = dtrFila["LastCheckOnTerminal"].ToString();
                    }

                    listResult.Add(oReplica);
                }
            }
            catch (Exception ex)
            {
                this._oLogErrors.GuardarLog(IConstantes.TIPOCAPA.ACCESODATOS, this.GetType().ToString(), MethodInfo.GetCurrentMethod().Name, ex.Message, strQuery);
            }
            finally{
                this.CloseConnection();
            }
            return listResult;
        }
 public Boolean TableSyncSource(Replica replica, ReplicaLog replicaLog)
 {
     MysqlDatabaseDA sqlDatabaseAccess = new MysqlDatabaseDA(replica.StrSourceUser, replica.StrSourcePassword, replica.StrSourceIPAddress, replica.IntSourcePort.ToString(), replica.StrSourceDatabase);
     return sqlDatabaseAccess.TableSync(replica.StrSourceTable, replicaLog.StrReplicaTransaction);
 }
 public List<ReplicaLog> GetReplicaLogsSourceUnsynchronized(Replica replica)
 {
     MysqlDatabaseDA sqlDatabaseAccess = new MysqlDatabaseDA(replica.StrSourceUser, replica.StrSourcePassword, replica.StrSourceIPAddress, replica.IntSourcePort.ToString(), replica.StrSourceDatabase);
     return sqlDatabaseAccess.GetReplicaLogsUnsynchronized(replica.StrSourceTable);
 }
示例#14
0
        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);
                    }
                }
            }
        }
示例#15
0
 /// <summary>
 /// This method insert on ReplicaManager Database
 /// </summary>
 /// <param name="replica"></param>
 public void InsertReplica(Replica replica)
 {
     ReplicaDA replicaDA = new ReplicaDA();
     replicaDA.Insert(replica);
 }
示例#16
0
        /// <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);
            }
        }