Example #1
0
        //salva o metodo o original
        private void executeDDL_NON_TSQL()
        {
            try
            {
                using (var cnn = createConnection())
                {
                    TaskLogStringDelegate    taskLogDelegate          = new TaskLogStringDelegate(taskLog);
                    TaskLogExceptionDelegate taskLogExceptionDelegate = new TaskLogExceptionDelegate(addPkgError);
                    TaskLogUpdateDelegate    taskLogUpdateDelegate    = new TaskLogUpdateDelegate(addPkgInfo);
                    var sqls = getQueriesSql();

                    foreach (var sql in sqls)
                    {
                        taskLog("Script file: " + sql.FileName + "\n");

                        string sqlQuery = StringUtilIts.GetStringFromBytes(sql.DataFile);

                        try
                        {
                            cnn.ExecuteNonQueryTransaction(sqlQuery, taskLogDelegate);

                            Thread.Sleep(500);
                        }

                        catch (Exception ex)
                        {
                            //dispara o delegate para add update info do erro
                            taskLogExceptionDelegate.DynamicInvoke(ex);

                            //para a porra toda
                            cancelation();
                        }
                    }
                    taskLogUpdateDelegate.DynamicInvoke();
                }
            }
            catch (OperationCanceledException oc)
            {
                StringBuilder queryLog = new StringBuilder();
                queryLog.Append("'****************************************************************************'\n");
                queryLog.Append("Failed sql statement.\n");
                queryLog.Append("'****************************************************************************'\n");
                queryLog.Append(oc.Message);

                taskLog(queryLog.ToString());
            }
        }
Example #2
0
        /// <summary>
        /// Faz a leitura dos bytes e carrega para uma lista de string
        /// </summary>
        /// <param name="pathFile"></param>Path do arquivo
        /// <returns></returns>
        public static List <string> GetDataFromBytes(byte[] bytes)
        {
            try
            {
                //pega os dados
                string result = StringUtilIts.GetStringFromBytes(bytes);
                //arquivo temporario
                var temp = Path.GetTempFileName();
                //escrever em um arquivo temporario
                FileManagerIts.WriteBytesToFile(temp, bytes);
                //transforma em uma lista
                var data = FileManagerIts.GetDataFile(temp);
                //elimina o temporario
                File.Delete(temp);

                //pega o resultado;
                return(data);
            }
            catch (Exception ex)
            {
                throw new Exception("Falha ao obter string dos bytes =>\n=>" + ex.Message);
            }
        }
Example #3
0
        private void executeDDL()
        {
            try
            {
                //eventos a serem disparados
                TaskLogStringDelegate    taskLogDelegate          = new TaskLogStringDelegate(taskLog);
                TaskLogExceptionDelegate taskLogExceptionDelegate = new TaskLogExceptionDelegate(addPkgError);
                TaskLogUpdateDelegate    taskLogUpdateDelegate    = new TaskLogUpdateDelegate(addPkgInfo);

                using (var connection = createConnection())
                {
                    var sqls = getQueriesSql();

                    connection.BeginTransaction();

                    foreach (var sql in sqls)
                    {
                        taskLog("Script file: " + sql.FileName);
                        taskLog("'============================================================================'");
                        string querySql = StringUtilIts.GetStringFromBytes(sql.DataFile);

                        try
                        {
                            StringBuilder queryLog = new StringBuilder();
                            queryLog.Append("Preparing Command: ...\n");
                            queryLog.Append("'============================================================================'\n");
                            queryLog.Append(querySql);
                            queryLog.Append("\n");
                            queryLog.Append("'============================================================================'");

                            //passa o parametro e dispara o delegate
                            taskLogDelegate.DynamicInvoke(queryLog.ToString());

                            //add comando para execução
                            connection.AddTransaction(querySql);

                            //delay para garantir a geração do log na tela
                            Thread.Sleep(100);
                        }

                        catch (Exception ex)
                        {
                            string scriptError = "Error in file: " + sql.FileName;
                            //passa o parametro e dispara o delegate
                            taskLogDelegate.DynamicInvoke(scriptError);

                            //dispara o delegate para add update info do erro
                            taskLogExceptionDelegate.DynamicInvoke(ex);

                            //delay para garantir a geração do log na tela
                            Thread.Sleep(100);

                            //para a porra toda
                            cancelation();
                        }
                    }

                    try
                    {
                        StringBuilder queryLog = new StringBuilder();

                        queryLog.Append("/****************************************************************************/\n");
                        queryLog.Append("Executing Query ...\n");
                        queryLog.Append("'****************************************************************************'\n");
                        //limpa o log builder
                        queryLog.Clear();

                        queryLog.Append("'============================================================================'\n");
                        queryLog.Append("Query executed sucessfully !\n");
                        queryLog.Append("'============================================================================'\n");

                        //delay para garantir a geração do log na tela
                        Thread.Sleep(100);

                        //passa o parametro e dispara o delegate
                        taskLogDelegate.DynamicInvoke(queryLog.ToString());

                        //efetiva transação
                        connection.CommitTransaction();

                        //se consegui chegar aqui ta tudo ok
                        taskLogUpdateDelegate.DynamicInvoke();
                    }
                    catch (Exception ex)
                    {
                        StringBuilder logScreen = new StringBuilder("Falha ao efetivar a transação.");
                        logScreen.Append("Mensagem: " + LoggerUtilIts.GetInnerException(ex));

                        //defaz todas as alterações
                        connection.RollbackTransaction();
                    }
                }
            }
            catch (OperationCanceledException oc)
            {
                StringBuilder queryLog = new StringBuilder();
                queryLog.Append("'****************************************************************************'\n");
                queryLog.Append("Failed sql statement.\n");
                queryLog.Append("'****************************************************************************'\n");
                queryLog.Append(oc.Message);

                taskLog(queryLog.ToString());
            }
        }