From 1f4e14b2e973ee7de337fd4866d9a5ceff5cb6d1 Mon Sep 17 00:00:00 2001
From: Lucas Faria Mendes <lucas.fariamo08@gmail.com>
Date: Mon, 30 Mar 2026 10:38:18 -0300
Subject: chore: location

---
 Gestor.Application/Helpers/ConnectionHelper.cs | 521 -------------------------
 1 file changed, 521 deletions(-)
 delete mode 100644 Gestor.Application/Helpers/ConnectionHelper.cs

(limited to 'Gestor.Application/Helpers/ConnectionHelper.cs')

diff --git a/Gestor.Application/Helpers/ConnectionHelper.cs b/Gestor.Application/Helpers/ConnectionHelper.cs
deleted file mode 100644
index 1b364ca..0000000
--- a/Gestor.Application/Helpers/ConnectionHelper.cs
+++ /dev/null
@@ -1,521 +0,0 @@
-using Agger.Registro;
-using Gestor.Application.Migration;
-using Gestor.Common.Exceptions;
-using Gestor.Model.API;
-using System;
-using System.Collections.Generic;
-using System.Data.SqlClient;
-using System.Diagnostics;
-using System.IO;
-using System.Net;
-using System.Net.Http;
-using System.Net.Http.Headers;
-using System.Runtime.CompilerServices;
-using System.Threading;
-using System.Threading.Tasks;
-
-namespace Gestor.Application.Helpers
-{
-	public class ConnectionHelper
-	{
-		public static bool BancoAtualizado
-		{
-			get;
-			set;
-		}
-
-		public ConnectionHelper()
-		{
-		}
-
-		public async Task<string> AtualizarBanco()
-		{
-			string str;
-			bool flag = await (new Migrator()).Execute();
-			ConnectionHelper.BancoAtualizado = flag;
-			if (flag)
-			{
-				str = null;
-			}
-			else
-			{
-				str = "HOUVE UM PROBLEMA AO ATUALIZAR O BANCO DE DADOS.";
-			}
-			return str;
-		}
-
-		public bool BDConvertido()
-		{
-			bool flag;
-			try
-			{
-				using (SqlConnection sqlConnection = new SqlConnection(Gestor.Application.Helpers.Connection.GetConnection(false)))
-				{
-					sqlConnection.Open();
-					using (SqlCommand sqlCommand = sqlConnection.CreateCommand())
-					{
-						sqlCommand.CommandText = "SELECT OBJECT_ID('dbo.AtualizacaoDados', 'U')";
-						if (sqlCommand.ExecuteScalar() == DBNull.Value)
-						{
-							flag = true;
-							return flag;
-						}
-					}
-					using (SqlCommand sqlCommand1 = sqlConnection.CreateCommand())
-					{
-						sqlCommand1.CommandText = "SELECT COUNT(IdArquivo) FROM AtualizacaoDados";
-						flag = (int)sqlCommand1.ExecuteScalar() == 0;
-					}
-				}
-			}
-			catch
-			{
-				return true;
-			}
-			return flag;
-		}
-
-		public static async Task<string> CheckDatabase()
-		{
-			string message;
-			string str;
-			try
-			{
-				bool flag = await ConnectionHelper.DatabaseExists();
-				bool flag1 = await ConnectionHelper.LoginExists();
-				bool flag2 = await ConnectionHelper.UserExists();
-				bool flag3 = false;
-				if (!(flag & flag1 & flag2))
-				{
-					if (!flag)
-					{
-						flag = await ConnectionHelper.CreateDatabase();
-					}
-					if (flag)
-					{
-						if (!flag1)
-						{
-							bool flag4 = await ConnectionHelper.CreateLogin();
-							bool flag5 = flag4;
-							flag3 = flag4;
-							flag1 = flag5;
-						}
-						if (flag1)
-						{
-							if (!flag2)
-							{
-								flag2 = await ConnectionHelper.CreateUser();
-							}
-							if (flag3)
-							{
-								int num = 10;
-								while (num > 1)
-								{
-									try
-									{
-										using (SqlConnection sqlConnection = new SqlConnection(Gestor.Application.Helpers.Connection.GetConnection(true)))
-										{
-											sqlConnection.Open();
-											break;
-										}
-									}
-									catch
-									{
-										Thread.Sleep(10000);
-										num--;
-									}
-								}
-							}
-							if (!flag2)
-							{
-								str = "ERRO AO CRIAR USUÁRIO";
-							}
-							else
-							{
-								str = null;
-							}
-							message = str;
-						}
-						else
-						{
-							message = "ERRO AO CRIAR LOGIN";
-						}
-					}
-					else
-					{
-						message = "ERRO AO CRIAR BANCO DE DADOS";
-					}
-				}
-				else
-				{
-					message = null;
-				}
-			}
-			catch (ValidationException validationException)
-			{
-				message = validationException.Message;
-			}
-			catch (Exception exception)
-			{
-				message = "ERRO AO CRIAR BANCO DE DADOS";
-			}
-			return message;
-		}
-
-		private static async Task<bool> CreateDatabase()
-		{
-			bool flag;
-			bool i;
-			string str = Uri.EscapeDataString(ApplicationHelper.NumeroSerial);
-			if (await ConnectionHelper.Post(string.Concat("Data/CreateData?token=", str)) != "ERRO INTERNO")
-			{
-				int num = 0;
-				for (i = false; num < 24 && !i; i = await ConnectionHelper.DatabaseExists())
-				{
-					await Task.Delay(5000);
-					num++;
-				}
-				flag = i;
-			}
-			else
-			{
-				flag = false;
-			}
-			return flag;
-		}
-
-		private static async Task<bool> CreateLogin()
-		{
-			bool flag;
-			bool i;
-			if (await ConnectionHelper.Post("Data/CreateLogin") != "ERRO INTERNO")
-			{
-				int num = 0;
-				for (i = false; num < 24 && !i; i = await ConnectionHelper.Get("Data/ServerLoginExists", true) == null)
-				{
-					await Task.Delay(5000);
-					num++;
-				}
-				flag = i;
-			}
-			else
-			{
-				flag = false;
-			}
-			return flag;
-		}
-
-		private static async Task<bool> CreateUser()
-		{
-			bool flag;
-			bool i;
-			if (await ConnectionHelper.Post("Data/CreateUser") != "ERRO INTERNO")
-			{
-				int num = 0;
-				for (i = false; num < 24 && !i; i = await ConnectionHelper.Get("Data/UserExists", true) == null)
-				{
-					await Task.Delay(5000);
-					num++;
-				}
-				flag = i;
-			}
-			else
-			{
-				flag = false;
-			}
-			return flag;
-		}
-
-		private static async Task<bool> DatabaseExists()
-		{
-			return await ConnectionHelper.Get("Data/DataExists", true) == null;
-		}
-
-		private static async Task<string> DatabaseTest()
-		{
-			return await ConnectionHelper.Get("Data/Verify", true);
-		}
-
-		public bool ExisteEmpresa()
-		{
-			bool flag;
-			try
-			{
-				using (SqlConnection sqlConnection = new SqlConnection(Gestor.Application.Helpers.Connection.GetConnection(false)))
-				{
-					sqlConnection.Open();
-					using (SqlCommand sqlCommand = sqlConnection.CreateCommand())
-					{
-						sqlCommand.CommandText = "SELECT OBJECT_ID (N'empresa', N'U')";
-						if (sqlCommand.ExecuteScalar() == DBNull.Value)
-						{
-							flag = false;
-							return flag;
-						}
-					}
-					using (SqlCommand sqlCommand1 = sqlConnection.CreateCommand())
-					{
-						sqlCommand1.CommandText = "SELECT COUNT(idempresa) FROM empresa WHERE idempresa = 1";
-						flag = (int)sqlCommand1.ExecuteScalar() > 0;
-					}
-				}
-			}
-			catch
-			{
-				return true;
-			}
-			return flag;
-		}
-
-		private static async Task<string> Get(string command, bool autorizar = true)
-		{
-			string str;
-			Uri uri = new Uri(Address.GestorApi(), command);
-			HttpClient httpClient = new HttpClient();
-			httpClient.set_Timeout(new TimeSpan(0, 2, 0));
-			HttpClient httpClient1 = httpClient;
-			if (autorizar)
-			{
-				httpClient1.get_DefaultRequestHeaders().set_Authorization(new AuthenticationHeaderValue("Token", Gestor.Application.Helpers.Connection.BasicKey()));
-			}
-			ServicePointManager.SecurityProtocol = SecurityProtocolType.Tls | SecurityProtocolType.Tls11 | SecurityProtocolType.Tls12;
-			try
-			{
-				ConfiguredTaskAwaitable<HttpResponseMessage> configuredTaskAwaitable = httpClient1.GetAsync(uri).ConfigureAwait(false);
-				HttpResponseMessage httpResponseMessage = await configuredTaskAwaitable;
-				if (httpResponseMessage.get_StatusCode() == HttpStatusCode.OK)
-				{
-					str = null;
-				}
-				else
-				{
-					str = await httpResponseMessage.get_Content().ReadAsStringAsync();
-				}
-			}
-			catch (Exception exception)
-			{
-				str = "ERRO INTERNO";
-			}
-			return str;
-		}
-
-		internal static async Task<bool> HasLogin(string connectionString)
-		{
-			bool flag1 = await Task.Run<bool>(() => {
-				bool flag;
-				List<Exception> exceptions = new List<Exception>();
-				try
-				{
-					using (SqlConnection sqlConnection = new SqlConnection(connectionString))
-					{
-						sqlConnection.Open();
-						using (SqlCommand sqlCommand = sqlConnection.CreateCommand())
-						{
-							sqlCommand.CommandText = "SELECT 1 FROM [dbo].[usuario] WHERE [removido] IS NULL OR [removido] = '0'";
-							SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();
-							if (sqlDataReader.HasRows)
-							{
-								sqlDataReader.Close();
-								sqlCommand.CommandText = "SELECT 1 FROM [dbo].[empresa] WHERE [idempresa] = 1";
-								sqlDataReader = sqlCommand.ExecuteReader();
-								if (sqlDataReader.HasRows)
-								{
-									sqlDataReader.Close();
-									sqlCommand.CommandText = "SELECT 1 FROM [dbo].[vendedor] WHERE [corretora] = '1'";
-									sqlDataReader = sqlCommand.ExecuteReader();
-									if (sqlDataReader.HasRows)
-									{
-										sqlDataReader.Close();
-										flag = true;
-									}
-									else
-									{
-										flag = false;
-									}
-								}
-								else
-								{
-									flag = false;
-								}
-							}
-							else
-							{
-								flag = false;
-							}
-						}
-					}
-				}
-				catch (Exception exception)
-				{
-					exceptions.Add(exception);
-					return exceptions.Count == 0;
-				}
-				return flag;
-			});
-			return flag1;
-		}
-
-		private static async Task<bool> LoginExists()
-		{
-			return await ConnectionHelper.Get("Data/ServerLoginExists", true) == null;
-		}
-
-		private static async Task<string> Post(string command)
-		{
-			string str;
-			Uri uri = new Uri(Address.GestorApi(), command);
-			HttpClient httpClient = new HttpClient();
-			httpClient.get_DefaultRequestHeaders().set_Authorization(new AuthenticationHeaderValue("Token", Gestor.Application.Helpers.Connection.BasicKey()));
-			ServicePointManager.SecurityProtocol = SecurityProtocolType.Tls | SecurityProtocolType.Tls11 | SecurityProtocolType.Tls12;
-			try
-			{
-				HttpResponseMessage httpResponseMessage = await httpClient.PostAsync(uri, null);
-				if (httpResponseMessage.get_StatusCode() == HttpStatusCode.OK)
-				{
-					str = null;
-				}
-				else
-				{
-					str = await httpResponseMessage.get_Content().ReadAsStringAsync();
-				}
-			}
-			catch (Exception exception)
-			{
-				str = "ERRO INTERNO";
-			}
-			return str;
-		}
-
-		public async Task<Tuple<bool, bool>> PrimeiroAcesso()
-		{
-			Tuple<bool, bool> tuple;
-			Tuple<bool, bool> tuple1;
-			string connection = Gestor.Application.Helpers.Connection.GetConnection(false);
-			if (!await ConnectionHelper.TryConnect(connection, 1))
-			{
-				if (await ConnectionHelper.DatabaseExists())
-				{
-					bool flag = !await ConnectionHelper.LoginExists();
-					if (flag)
-					{
-						flag = !await ConnectionHelper.CreateLogin();
-					}
-					if (!flag)
-					{
-						flag = !await ConnectionHelper.UserExists();
-						if (flag)
-						{
-							flag = !await ConnectionHelper.CreateUser();
-						}
-						if (flag)
-						{
-							tuple = new Tuple<bool, bool>(false, false);
-							connection = null;
-							return tuple;
-						}
-					}
-					else
-					{
-						tuple = new Tuple<bool, bool>(false, false);
-						connection = null;
-						return tuple;
-					}
-				}
-				else
-				{
-					tuple = new Tuple<bool, bool>(false, false);
-					connection = null;
-					return tuple;
-				}
-			}
-			tuple1 = (!await ConnectionHelper.HasLogin(connection) ? new Tuple<bool, bool>(true, false) : new Tuple<bool, bool>(true, true));
-			tuple = tuple1;
-			connection = null;
-			return tuple;
-		}
-
-		internal static async Task<bool> TryConnect(string connectionString, int retryCount = 1)
-		{
-			bool flag1 = await Task.Run<bool>(() => {
-				bool flag;
-				List<Exception> exceptions = new List<Exception>();
-				int num = 0;
-			Label1:
-				while (num < retryCount)
-				{
-					try
-					{
-						using (SqlConnection sqlConnection = new SqlConnection(string.Concat(connectionString, "Connection Timeout=5")))
-						{
-							sqlConnection.Open();
-						}
-						flag = true;
-					}
-					catch (Exception exception)
-					{
-						exceptions.Add(exception);
-						goto Label0;
-					}
-					return flag;
-				}
-				return exceptions.Count == 0;
-			Label0:
-				num++;
-				goto Label1;
-			});
-			return flag1;
-		}
-
-		private static async Task<bool> UserExists()
-		{
-			return await ConnectionHelper.Get("Data/UserExists", true) == null;
-		}
-
-		public async Task<string> VerifyConnection()
-		{
-			string str;
-			try
-			{
-				if (!await ConnectionHelper.TryConnect(Gestor.Application.Helpers.Connection.GetConnection(false), 1))
-				{
-					string str1 = await ConnectionHelper.DatabaseTest();
-					if (str1 == null)
-					{
-						string str2 = string.Concat(Gestor.Application.Helpers.Connection.ConnectionAddress.get_Catalog(), ".cfg");
-						string str3 = string.Concat(AppDomain.CurrentDomain.BaseDirectory, "Data_", str2);
-						string str4 = string.Concat(AppDomain.CurrentDomain.BaseDirectory, "Files_", str2);
-						string str5 = string.Concat(AppDomain.CurrentDomain.BaseDirectory, "Sign_", str2);
-						if (File.Exists(str3))
-						{
-							File.Delete(str3);
-						}
-						if (File.Exists(str4))
-						{
-							File.Delete(str4);
-						}
-						if (File.Exists(str5))
-						{
-							File.Delete(str5);
-						}
-						string str6 = await ConnectionHelper.CheckDatabase();
-						await Task.Delay(2000);
-						str = str6;
-					}
-					else
-					{
-						str = str1;
-					}
-				}
-				else
-				{
-					str = null;
-				}
-			}
-			catch (Exception exception)
-			{
-				str = "ERRO AO CONECTAR NO BANCO DE DADOS DA CORRETORA";
-			}
-			return str;
-		}
-	}
-}
\ No newline at end of file
-- 
cgit v1.2.3