diff options
| author | Lucas Faria Mendes <lucas.fariamo08@gmail.com> | 2026-03-30 13:38:18 +0000 |
|---|---|---|
| committer | Lucas Faria Mendes <lucas.fariamo08@gmail.com> | 2026-03-30 13:38:18 +0000 |
| commit | 1f4e14b2e973ee7de337fd4866d9a5ceff5cb6d1 (patch) | |
| tree | e1c3b20ea08f0cf71122a1e73f0d395f8fd83874 /Codemerx/Gestor.Infrastructure/Gestor.Infrastructure.Helpers/Funcoes.cs | |
| parent | 674ca83ba9243a9e95a7568c797668dab6aee26a (diff) | |
| download | gestor-1f4e14b2e973ee7de337fd4866d9a5ceff5cb6d1.tar.gz gestor-1f4e14b2e973ee7de337fd4866d9a5ceff5cb6d1.zip | |
chore: location
Diffstat (limited to 'Codemerx/Gestor.Infrastructure/Gestor.Infrastructure.Helpers/Funcoes.cs')
| -rw-r--r-- | Codemerx/Gestor.Infrastructure/Gestor.Infrastructure.Helpers/Funcoes.cs | 1403 |
1 files changed, 1403 insertions, 0 deletions
diff --git a/Codemerx/Gestor.Infrastructure/Gestor.Infrastructure.Helpers/Funcoes.cs b/Codemerx/Gestor.Infrastructure/Gestor.Infrastructure.Helpers/Funcoes.cs new file mode 100644 index 0000000..d3fdcde --- /dev/null +++ b/Codemerx/Gestor.Infrastructure/Gestor.Infrastructure.Helpers/Funcoes.cs @@ -0,0 +1,1403 @@ +using Gestor.Infrastructure.UnitOfWork.Generic;
+using Gestor.Model.Common;
+using Gestor.Model.Domain.Relatorios;
+using Gestor.Model.Validation;
+using Microsoft.CSharp.RuntimeBinder;
+using NHibernate;
+using NHibernate.Connection;
+using NHibernate.Impl;
+using NHibernate.Util;
+using System;
+using System.Collections.Generic;
+using System.Data;
+using System.Data.Common;
+using System.Data.SqlClient;
+using System.Diagnostics;
+using System.Linq;
+using System.Linq.Expressions;
+using System.Net;
+using System.Net.Sockets;
+using System.Reflection;
+using System.Runtime.CompilerServices;
+
+namespace Gestor.Infrastructure.Helpers
+{
+ internal static class Funcoes
+ {
+ public static System.Diagnostics.Stopwatch Stopwatch;
+
+ public static DateTime? StartTime;
+
+ private static Dictionary<Type, SqlDbType> TypeMap
+ {
+ get;
+ }
+
+ static Funcoes()
+ {
+ Dictionary<Type, SqlDbType> types = new Dictionary<Type, SqlDbType>();
+ types[typeof(string)] = SqlDbType.NVarChar;
+ types[typeof(char[])] = SqlDbType.NVarChar;
+ types[typeof(byte)] = SqlDbType.TinyInt;
+ types[typeof(short)] = SqlDbType.SmallInt;
+ types[typeof(int)] = SqlDbType.Int;
+ types[typeof(long)] = SqlDbType.BigInt;
+ types[typeof(long)] = SqlDbType.BigInt;
+ types[typeof(byte[])] = SqlDbType.Image;
+ types[typeof(bool)] = SqlDbType.Bit;
+ types[typeof(DateTime)] = SqlDbType.DateTime2;
+ types[typeof(DateTimeOffset)] = SqlDbType.DateTimeOffset;
+ types[typeof(decimal)] = SqlDbType.Money;
+ types[typeof(float)] = SqlDbType.Real;
+ types[typeof(double)] = SqlDbType.Float;
+ types[typeof(TimeSpan)] = SqlDbType.Time;
+ Gestor.Infrastructure.Helpers.Funcoes.TypeMap = types;
+ }
+
+ public static T Campo<T>(this DataRow row, string field)
+ {
+ string name;
+ bool isEnum;
+ string str;
+ object obj = row.Obj(field);
+ if (!typeof(T).IsNullable())
+ {
+ if (typeof(T).IsEnum)
+ {
+ if (obj == null)
+ {
+ return (T)typeof(T).GetEnumValues().First();
+ }
+ return (T)Enum.Parse(typeof(T), obj.ToString());
+ }
+ name = typeof(T).Name;
+ if (name == "String")
+ {
+ if (obj == null)
+ {
+ return (T)"";
+ }
+ return (T)obj.ToString();
+ }
+ if (name == "DateTime")
+ {
+ if (obj == null)
+ {
+ return (T)(object)DateTime.MinValue;
+ }
+ return (T)(object)DateTime.Parse(obj.ToString());
+ }
+ if (name == "Decimal")
+ {
+ if (obj == null)
+ {
+ return (T)(object)0;
+ }
+ return (T)(object)decimal.Parse(obj.ToString());
+ }
+ if (name == "Int64")
+ {
+ if (obj == null)
+ {
+ return (T)(object)0;
+ }
+ return (T)(object)long.Parse(obj.ToString());
+ }
+ if (name != "Int")
+ {
+ return (T)null;
+ }
+ if (obj == null)
+ {
+ return (T)(object)0;
+ }
+ return (T)(object)int.Parse(obj.ToString());
+ }
+ Type underlyingType = Nullable.GetUnderlyingType(typeof(T));
+ if (underlyingType != null)
+ {
+ isEnum = underlyingType.IsEnum;
+ }
+ else
+ {
+ isEnum = false;
+ }
+ if (isEnum)
+ {
+ if (obj == null)
+ {
+ return (T)null;
+ }
+ return (T)Enum.Parse(typeof(T), obj.ToString());
+ }
+ Type type = Nullable.GetUnderlyingType(typeof(T));
+ if (type != null)
+ {
+ str = type.Name;
+ }
+ else
+ {
+ str = null;
+ }
+ name = str;
+ if (name == "String")
+ {
+ if (obj == null)
+ {
+ return (T)null;
+ }
+ return (T)obj.ToString();
+ }
+ if (name == "DateTime")
+ {
+ if (obj == null)
+ {
+ return (T)null;
+ }
+ return (T)(object)DateTime.Parse(obj.ToString());
+ }
+ if (name == "Decimal")
+ {
+ if (obj == null)
+ {
+ return (T)null;
+ }
+ return (T)(object)decimal.Parse(obj.ToString());
+ }
+ if (name == "Int64")
+ {
+ if (obj == null)
+ {
+ return (T)null;
+ }
+ return (T)(object)long.Parse(obj.ToString());
+ }
+ if (name != "Int")
+ {
+ return (T)null;
+ }
+ if (obj == null)
+ {
+ return (T)null;
+ }
+ return (T)(object)int.Parse(obj.ToString());
+ }
+
+ public static TipoTela? Convert(this string form)
+ {
+ TipoTela tipoTela;
+ TipoTela? nullable;
+ char chr;
+ if (string.IsNullOrWhiteSpace(form))
+ {
+ nullable = null;
+ return nullable;
+ }
+ if (form.Contains("View") || form.Contains("Renovacao"))
+ {
+ nullable = null;
+ return nullable;
+ }
+ string lower = form.ToLower();
+ if (lower != null)
+ {
+ switch (lower.Length)
+ {
+ case 7:
+ {
+ chr = lower[3];
+ if (chr == 'N')
+ {
+ if (lower == "frmNota")
+ {
+ return new TipoTela?(TipoTela.NotaFiscal);
+ }
+ tipoTela = ((TipoTela[])Enum.GetValues(typeof(TipoTela))).ToList<TipoTela>().FirstOrDefault<TipoTela>((TipoTela x) => form.ToLower().Contains(x.ToString().ToLower()));
+ if (tipoTela != TipoTela.Todas)
+ {
+ return new TipoTela?(tipoTela);
+ }
+ nullable = null;
+ return nullable;
+ }
+ else if (chr == 'a')
+ {
+ if (lower == "frmauto")
+ {
+ break;
+ }
+ tipoTela = ((TipoTela[])Enum.GetValues(typeof(TipoTela))).ToList<TipoTela>().FirstOrDefault<TipoTela>((TipoTela x) => form.ToLower().Contains(x.ToString().ToLower()));
+ if (tipoTela != TipoTela.Todas)
+ {
+ return new TipoTela?(tipoTela);
+ }
+ nullable = null;
+ return nullable;
+ }
+ else
+ {
+ tipoTela = ((TipoTela[])Enum.GetValues(typeof(TipoTela))).ToList<TipoTela>().FirstOrDefault<TipoTela>((TipoTela x) => form.ToLower().Contains(x.ToString().ToLower()));
+ if (tipoTela != TipoTela.Todas)
+ {
+ return new TipoTela?(tipoTela);
+ }
+ nullable = null;
+ return nullable;
+ }
+ }
+ case 8:
+ case 9:
+ case 11:
+ case 15:
+ case 16:
+ case 19:
+ case 20:
+ {
+ tipoTela = ((TipoTela[])Enum.GetValues(typeof(TipoTela))).ToList<TipoTela>().FirstOrDefault<TipoTela>((TipoTela x) => form.ToLower().Contains(x.ToString().ToLower()));
+ if (tipoTela != TipoTela.Todas)
+ {
+ return new TipoTela?(tipoTela);
+ }
+ nullable = null;
+ return nullable;
+ }
+ case 10:
+ {
+ chr = lower[3];
+ if (chr == 'e')
+ {
+ if (lower == "frmendosso")
+ {
+ return new TipoTela?(TipoTela.Apolice);
+ }
+ tipoTela = ((TipoTela[])Enum.GetValues(typeof(TipoTela))).ToList<TipoTela>().FirstOrDefault<TipoTela>((TipoTela x) => form.ToLower().Contains(x.ToString().ToLower()));
+ if (tipoTela != TipoTela.Todas)
+ {
+ return new TipoTela?(tipoTela);
+ }
+ nullable = null;
+ return nullable;
+ }
+ else if (chr == 'i')
+ {
+ if (lower == "frmitemman")
+ {
+ break;
+ }
+ tipoTela = ((TipoTela[])Enum.GetValues(typeof(TipoTela))).ToList<TipoTela>().FirstOrDefault<TipoTela>((TipoTela x) => form.ToLower().Contains(x.ToString().ToLower()));
+ if (tipoTela != TipoTela.Todas)
+ {
+ return new TipoTela?(tipoTela);
+ }
+ nullable = null;
+ return nullable;
+ }
+ else if (chr == 'p')
+ {
+ if (lower == "frmparcela")
+ {
+ return new TipoTela?(TipoTela.Parcela);
+ }
+ tipoTela = ((TipoTela[])Enum.GetValues(typeof(TipoTela))).ToList<TipoTela>().FirstOrDefault<TipoTela>((TipoTela x) => form.ToLower().Contains(x.ToString().ToLower()));
+ if (tipoTela != TipoTela.Todas)
+ {
+ return new TipoTela?(tipoTela);
+ }
+ nullable = null;
+ return nullable;
+ }
+ else
+ {
+ tipoTela = ((TipoTela[])Enum.GetValues(typeof(TipoTela))).ToList<TipoTela>().FirstOrDefault<TipoTela>((TipoTela x) => form.ToLower().Contains(x.ToString().ToLower()));
+ if (tipoTela != TipoTela.Todas)
+ {
+ return new TipoTela?(tipoTela);
+ }
+ nullable = null;
+ return nullable;
+ }
+ }
+ case 12:
+ {
+ chr = lower[3];
+ if (chr == 'r')
+ {
+ if (lower == "frmrenovacao")
+ {
+ return new TipoTela?(TipoTela.Apolice);
+ }
+ tipoTela = ((TipoTela[])Enum.GetValues(typeof(TipoTela))).ToList<TipoTela>().FirstOrDefault<TipoTela>((TipoTela x) => form.ToLower().Contains(x.ToString().ToLower()));
+ if (tipoTela != TipoTela.Todas)
+ {
+ return new TipoTela?(tipoTela);
+ }
+ nullable = null;
+ return nullable;
+ }
+ else if (chr == 'v')
+ {
+ if (lower == "frmvidagrupo")
+ {
+ break;
+ }
+ tipoTela = ((TipoTela[])Enum.GetValues(typeof(TipoTela))).ToList<TipoTela>().FirstOrDefault<TipoTela>((TipoTela x) => form.ToLower().Contains(x.ToString().ToLower()));
+ if (tipoTela != TipoTela.Todas)
+ {
+ return new TipoTela?(tipoTela);
+ }
+ nullable = null;
+ return nullable;
+ }
+ else
+ {
+ tipoTela = ((TipoTela[])Enum.GetValues(typeof(TipoTela))).ToList<TipoTela>().FirstOrDefault<TipoTela>((TipoTela x) => form.ToLower().Contains(x.ToString().ToLower()));
+ if (tipoTela != TipoTela.Todas)
+ {
+ return new TipoTela?(tipoTela);
+ }
+ nullable = null;
+ return nullable;
+ }
+ }
+ case 13:
+ {
+ chr = lower[3];
+ if (chr == 'c')
+ {
+ if (lower == "frmcriticapdf")
+ {
+ return new TipoTela?(TipoTela.CriticaApolice);
+ }
+ tipoTela = ((TipoTela[])Enum.GetValues(typeof(TipoTela))).ToList<TipoTela>().FirstOrDefault<TipoTela>((TipoTela x) => form.ToLower().Contains(x.ToString().ToLower()));
+ if (tipoTela != TipoTela.Todas)
+ {
+ return new TipoTela?(tipoTela);
+ }
+ nullable = null;
+ return nullable;
+ }
+ else
+ {
+ switch (chr)
+ {
+ case 'p':
+ {
+ if (lower == "frmparcelanew")
+ {
+ return new TipoTela?(TipoTela.Parcela);
+ }
+ tipoTela = ((TipoTela[])Enum.GetValues(typeof(TipoTela))).ToList<TipoTela>().FirstOrDefault<TipoTela>((TipoTela x) => form.ToLower().Contains(x.ToString().ToLower()));
+ if (tipoTela != TipoTela.Todas)
+ {
+ return new TipoTela?(tipoTela);
+ }
+ nullable = null;
+ return nullable;
+ }
+ case 'q':
+ case 's':
+ {
+ tipoTela = ((TipoTela[])Enum.GetValues(typeof(TipoTela))).ToList<TipoTela>().FirstOrDefault<TipoTela>((TipoTela x) => form.ToLower().Contains(x.ToString().ToLower()));
+ if (tipoTela != TipoTela.Todas)
+ {
+ return new TipoTela?(tipoTela);
+ }
+ nullable = null;
+ return nullable;
+ }
+ case 'r':
+ {
+ if (lower == "frmresidencia")
+ {
+ return new TipoTela?(TipoTela.Item);
+ }
+ tipoTela = ((TipoTela[])Enum.GetValues(typeof(TipoTela))).ToList<TipoTela>().FirstOrDefault<TipoTela>((TipoTela x) => form.ToLower().Contains(x.ToString().ToLower()));
+ if (tipoTela != TipoTela.Todas)
+ {
+ return new TipoTela?(tipoTela);
+ }
+ nullable = null;
+ return nullable;
+ }
+ case 't':
+ {
+ if (lower == "frmtransporte")
+ {
+ return new TipoTela?(TipoTela.Item);
+ }
+ tipoTela = ((TipoTela[])Enum.GetValues(typeof(TipoTela))).ToList<TipoTela>().FirstOrDefault<TipoTela>((TipoTela x) => form.ToLower().Contains(x.ToString().ToLower()));
+ if (tipoTela != TipoTela.Todas)
+ {
+ return new TipoTela?(tipoTela);
+ }
+ nullable = null;
+ return nullable;
+ }
+ default:
+ {
+ tipoTela = ((TipoTela[])Enum.GetValues(typeof(TipoTela))).ToList<TipoTela>().FirstOrDefault<TipoTela>((TipoTela x) => form.ToLower().Contains(x.ToString().ToLower()));
+ if (tipoTela != TipoTela.Todas)
+ {
+ return new TipoTela?(tipoTela);
+ }
+ nullable = null;
+ return nullable;
+ }
+ }
+ }
+ break;
+ }
+ case 14:
+ {
+ chr = lower[3];
+ if (chr == 'a')
+ {
+ if (lower == "frmaeronautico")
+ {
+ break;
+ }
+ tipoTela = ((TipoTela[])Enum.GetValues(typeof(TipoTela))).ToList<TipoTela>().FirstOrDefault<TipoTela>((TipoTela x) => form.ToLower().Contains(x.ToString().ToLower()));
+ if (tipoTela != TipoTela.Todas)
+ {
+ return new TipoTela?(tipoTela);
+ }
+ nullable = null;
+ return nullable;
+ }
+ else if (chr == 'e')
+ {
+ if (lower == "frmeducacional")
+ {
+ break;
+ }
+ tipoTela = ((TipoTela[])Enum.GetValues(typeof(TipoTela))).ToList<TipoTela>().FirstOrDefault<TipoTela>((TipoTela x) => form.ToLower().Contains(x.ToString().ToLower()));
+ if (tipoTela != TipoTela.Todas)
+ {
+ return new TipoTela?(tipoTela);
+ }
+ nullable = null;
+ return nullable;
+ }
+ else
+ {
+ tipoTela = ((TipoTela[])Enum.GetValues(typeof(TipoTela))).ToList<TipoTela>().FirstOrDefault<TipoTela>((TipoTela x) => form.ToLower().Contains(x.ToString().ToLower()));
+ if (tipoTela != TipoTela.Todas)
+ {
+ return new TipoTela?(tipoTela);
+ }
+ nullable = null;
+ return nullable;
+ }
+ }
+ case 17:
+ {
+ chr = lower[3];
+ if (chr == 'm')
+ {
+ if (lower == "frmmanutpagamento")
+ {
+ return new TipoTela?(TipoTela.ManutencaoPagamentos);
+ }
+ tipoTela = ((TipoTela[])Enum.GetValues(typeof(TipoTela))).ToList<TipoTela>().FirstOrDefault<TipoTela>((TipoTela x) => form.ToLower().Contains(x.ToString().ToLower()));
+ if (tipoTela != TipoTela.Todas)
+ {
+ return new TipoTela?(tipoTela);
+ }
+ nullable = null;
+ return nullable;
+ }
+ else if (chr == 'r')
+ {
+ if (lower == "frmriscosdiversos")
+ {
+ break;
+ }
+ tipoTela = ((TipoTela[])Enum.GetValues(typeof(TipoTela))).ToList<TipoTela>().FirstOrDefault<TipoTela>((TipoTela x) => form.ToLower().Contains(x.ToString().ToLower()));
+ if (tipoTela != TipoTela.Todas)
+ {
+ return new TipoTela?(tipoTela);
+ }
+ nullable = null;
+ return nullable;
+ }
+ else if (chr == 'v')
+ {
+ if (lower == "frmvidaindividual")
+ {
+ break;
+ }
+ tipoTela = ((TipoTela[])Enum.GetValues(typeof(TipoTela))).ToList<TipoTela>().FirstOrDefault<TipoTela>((TipoTela x) => form.ToLower().Contains(x.ToString().ToLower()));
+ if (tipoTela != TipoTela.Todas)
+ {
+ return new TipoTela?(tipoTela);
+ }
+ nullable = null;
+ return nullable;
+ }
+ else
+ {
+ tipoTela = ((TipoTela[])Enum.GetValues(typeof(TipoTela))).ToList<TipoTela>().FirstOrDefault<TipoTela>((TipoTela x) => form.ToLower().Contains(x.ToString().ToLower()));
+ if (tipoTela != TipoTela.Todas)
+ {
+ return new TipoTela?(tipoTela);
+ }
+ nullable = null;
+ return nullable;
+ }
+ }
+ case 18:
+ {
+ if (lower == "frmparcelascritica")
+ {
+ return new TipoTela?(TipoTela.Parcela);
+ }
+ tipoTela = ((TipoTela[])Enum.GetValues(typeof(TipoTela))).ToList<TipoTela>().FirstOrDefault<TipoTela>((TipoTela x) => form.ToLower().Contains(x.ToString().ToLower()));
+ if (tipoTela != TipoTela.Todas)
+ {
+ return new TipoTela?(tipoTela);
+ }
+ nullable = null;
+ return nullable;
+ }
+ case 21:
+ {
+ if (lower == "frmredirecionacritica")
+ {
+ return new TipoTela?(TipoTela.CriticaApolice);
+ }
+ tipoTela = ((TipoTela[])Enum.GetValues(typeof(TipoTela))).ToList<TipoTela>().FirstOrDefault<TipoTela>((TipoTela x) => form.ToLower().Contains(x.ToString().ToLower()));
+ if (tipoTela != TipoTela.Todas)
+ {
+ return new TipoTela?(tipoTela);
+ }
+ nullable = null;
+ return nullable;
+ }
+ default:
+ {
+ tipoTela = ((TipoTela[])Enum.GetValues(typeof(TipoTela))).ToList<TipoTela>().FirstOrDefault<TipoTela>((TipoTela x) => form.ToLower().Contains(x.ToString().ToLower()));
+ if (tipoTela != TipoTela.Todas)
+ {
+ return new TipoTela?(tipoTela);
+ }
+ nullable = null;
+ return nullable;
+ }
+ }
+ return new TipoTela?(TipoTela.Item);
+ }
+ tipoTela = ((TipoTela[])Enum.GetValues(typeof(TipoTela))).ToList<TipoTela>().FirstOrDefault<TipoTela>((TipoTela x) => form.ToLower().Contains(x.ToString().ToLower()));
+ if (tipoTela != TipoTela.Todas)
+ {
+ return new TipoTela?(tipoTela);
+ }
+ nullable = null;
+ return nullable;
+ }
+
+ public static Relatorio? ConvertRelatorio(this string form)
+ {
+ Relatorio? nullable;
+ char chr;
+ if (string.IsNullOrWhiteSpace(form))
+ {
+ nullable = null;
+ return nullable;
+ }
+ if (form != null)
+ {
+ int length = form.Length;
+ switch (length)
+ {
+ case 9:
+ {
+ if (form == "Renovacao")
+ {
+ break;
+ }
+ nullable = null;
+ return nullable;
+ }
+ case 10:
+ case 13:
+ case 16:
+ {
+ nullable = null;
+ return nullable;
+ }
+ case 11:
+ {
+ chr = form[3];
+ if (chr == 'M')
+ {
+ if (form == "frmMetaView")
+ {
+ return new Relatorio?(Relatorio.MetaSeguradora);
+ }
+ nullable = null;
+ return nullable;
+ }
+ else if (chr == 'N')
+ {
+ if (form == "frmNotaView")
+ {
+ return new Relatorio?(Relatorio.NotaFiscal);
+ }
+ nullable = null;
+ return nullable;
+ }
+ else
+ {
+ nullable = null;
+ return nullable;
+ }
+ }
+ case 12:
+ {
+ if (form == "frmRenovacao")
+ {
+ break;
+ }
+ nullable = null;
+ return nullable;
+ }
+ case 14:
+ {
+ chr = form[3];
+ if (chr == 'C')
+ {
+ if (form == "frmClienteView")
+ {
+ return new Relatorio?(Relatorio.Cliente);
+ }
+ nullable = null;
+ return nullable;
+ }
+ else if (chr == 'E')
+ {
+ if (form == "frmExtratoView")
+ {
+ return new Relatorio?(Relatorio.ExtratosBaixados);
+ }
+ nullable = null;
+ return nullable;
+ }
+ else
+ {
+ nullable = null;
+ return nullable;
+ }
+ }
+ case 15:
+ {
+ chr = form[3];
+ if (chr == 'C')
+ {
+ if (form == "frmComissaoView")
+ {
+ return new Relatorio?(Relatorio.Comissao);
+ }
+ nullable = null;
+ return nullable;
+ }
+ else if (chr == 'P')
+ {
+ if (form == "frmProducaoView")
+ {
+ return new Relatorio?(Relatorio.Producao);
+ }
+ nullable = null;
+ return nullable;
+ }
+ else if (chr == 'S')
+ {
+ if (form == "frmSinistroView")
+ {
+ return new Relatorio?(Relatorio.Sinistro);
+ }
+ nullable = null;
+ return nullable;
+ }
+ else
+ {
+ nullable = null;
+ return nullable;
+ }
+ }
+ case 17:
+ {
+ chr = form[3];
+ if (chr == 'F')
+ {
+ if (form == "frmFechamentoView")
+ {
+ return new Relatorio?(Relatorio.Fechamento);
+ }
+ nullable = null;
+ return nullable;
+ }
+ else if (chr == 'U')
+ {
+ if (form == "frmUtilizacaoView")
+ {
+ return new Relatorio?(Relatorio.LogsUtilizacao);
+ }
+ nullable = null;
+ return nullable;
+ }
+ else
+ {
+ nullable = null;
+ return nullable;
+ }
+ }
+ default:
+ {
+ if (length == 23)
+ {
+ if (form == "frmAgendaVencimentoView")
+ {
+ return new Relatorio?(Relatorio.Renovacao);
+ }
+ nullable = null;
+ return nullable;
+ }
+ else
+ {
+ nullable = null;
+ return nullable;
+ }
+ }
+ }
+ return new Relatorio?(Relatorio.Renovacao);
+ }
+ nullable = null;
+ return nullable;
+ }
+
+ public static SqlQueryCondition CreateParameters(this List<Condicao> keyValues, int indexStart = 0)
+ {
+ if (keyValues == null)
+ {
+ return null;
+ }
+ List<SqlParameter> sqlParameters = new List<SqlParameter>();
+ List<string> strs2 = new List<string>();
+ int num = indexStart;
+ (
+ from x in keyValues
+ orderby x.Grupo
+ group x by x.Grupo).ForEach<IGrouping<int, Condicao>>((IGrouping<int, Condicao> g) => {
+ List<string> strs1 = new List<string>();
+ g.ForEach<Condicao>((Condicao x) => {
+ string str = string.Concat(x.Campo, " ");
+ List<string> strs = new List<string>();
+ if (x.Valores != null)
+ {
+ List<object> valores = x.Valores;
+ if (valores != null)
+ {
+ valores.ForEach((object v) => {
+ SqlParameter sqlParameter;
+ SqlParameter sqlParameter1;
+ if (Gestor.Infrastructure.Helpers.Funcoes.u003cu003eo__15.u003cu003ep__0 == null)
+ {
+ Gestor.Infrastructure.Helpers.Funcoes.u003cu003eo__15.u003cu003ep__0 = CallSite<Func<CallSite, object, object>>.Create(Microsoft.CSharp.RuntimeBinder.Binder.InvokeMember(CSharpBinderFlags.None, "GetType", null, typeof(Gestor.Infrastructure.Helpers.Funcoes), (IEnumerable<CSharpArgumentInfo>)(new CSharpArgumentInfo[] { CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.None, null) })));
+ }
+ object target = Gestor.Infrastructure.Helpers.Funcoes.u003cu003eo__15.u003cu003ep__0.Target(Gestor.Infrastructure.Helpers.Funcoes.u003cu003eo__15.u003cu003ep__0, v);
+ if (Gestor.Infrastructure.Helpers.Funcoes.u003cu003eo__15.u003cu003ep__2 == null)
+ {
+ Gestor.Infrastructure.Helpers.Funcoes.u003cu003eo__15.u003cu003ep__2 = CallSite<Func<CallSite, object, bool>>.Create(Microsoft.CSharp.RuntimeBinder.Binder.UnaryOperation(CSharpBinderFlags.None, ExpressionType.IsTrue, typeof(Gestor.Infrastructure.Helpers.Funcoes), (IEnumerable<CSharpArgumentInfo>)(new CSharpArgumentInfo[] { CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.None, null) })));
+ }
+ !0 _u00210 = Gestor.Infrastructure.Helpers.Funcoes.u003cu003eo__15.u003cu003ep__2.Target;
+ CallSite<Func<CallSite, object, bool>> u003cu003ep_2 = Gestor.Infrastructure.Helpers.Funcoes.u003cu003eo__15.u003cu003ep__2;
+ if (Gestor.Infrastructure.Helpers.Funcoes.u003cu003eo__15.u003cu003ep__1 == null)
+ {
+ Gestor.Infrastructure.Helpers.Funcoes.u003cu003eo__15.u003cu003ep__1 = CallSite<Func<CallSite, object, Type, object>>.Create(Microsoft.CSharp.RuntimeBinder.Binder.BinaryOperation(CSharpBinderFlags.None, ExpressionType.Equal, typeof(Gestor.Infrastructure.Helpers.Funcoes), (IEnumerable<CSharpArgumentInfo>)(new CSharpArgumentInfo[] { CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.None, null), CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.UseCompileTimeType, null) })));
+ }
+ if (_u00210(u003cu003ep_2, Gestor.Infrastructure.Helpers.Funcoes.u003cu003eo__15.u003cu003ep__1.Target(Gestor.Infrastructure.Helpers.Funcoes.u003cu003eo__15.u003cu003ep__1, target, typeof(string))))
+ {
+ sqlParameter = new SqlParameter()
+ {
+ ParameterName = string.Format("@param_{0}", num)
+ };
+ SqlParameter target1 = sqlParameter;
+ if (Gestor.Infrastructure.Helpers.Funcoes.u003cu003eo__15.u003cu003ep__4 == null)
+ {
+ Gestor.Infrastructure.Helpers.Funcoes.u003cu003eo__15.u003cu003ep__4 = CallSite<Func<CallSite, object, SqlDbType>>.Create(Microsoft.CSharp.RuntimeBinder.Binder.Convert(CSharpBinderFlags.None, typeof(SqlDbType), typeof(Gestor.Infrastructure.Helpers.Funcoes)));
+ }
+ !0 _u002101 = Gestor.Infrastructure.Helpers.Funcoes.u003cu003eo__15.u003cu003ep__4.Target;
+ CallSite<Func<CallSite, object, SqlDbType>> u003cu003ep_4 = Gestor.Infrastructure.Helpers.Funcoes.u003cu003eo__15.u003cu003ep__4;
+ if (Gestor.Infrastructure.Helpers.Funcoes.u003cu003eo__15.u003cu003ep__3 == null)
+ {
+ Gestor.Infrastructure.Helpers.Funcoes.u003cu003eo__15.u003cu003ep__3 = CallSite<Func<CallSite, Type, object, object>>.Create(Microsoft.CSharp.RuntimeBinder.Binder.InvokeMember(CSharpBinderFlags.None, "GetDbType", null, typeof(Gestor.Infrastructure.Helpers.Funcoes), (IEnumerable<CSharpArgumentInfo>)(new CSharpArgumentInfo[] { CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.UseCompileTimeType | CSharpArgumentInfoFlags.IsStaticType, null), CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.None, null) })));
+ }
+ target1.SqlDbType = _u002101(u003cu003ep_4, Gestor.Infrastructure.Helpers.Funcoes.u003cu003eo__15.u003cu003ep__3.Target(Gestor.Infrastructure.Helpers.Funcoes.u003cu003eo__15.u003cu003ep__3, typeof(Gestor.Infrastructure.Helpers.Funcoes), target));
+ sqlParameter.Size = 255;
+ sqlParameter.Value = (x.Operador == Operador.Like || x.Operador == Operador.NotLike ? string.Format("%{0}%", v) : (x.Operador == Operador.ComecaCom ? string.Format("{0}%", v) : (x.Operador == Operador.TerminaCom ? string.Format("%{0}", v) : v)));
+ sqlParameter1 = sqlParameter;
+ }
+ else
+ {
+ sqlParameter = new SqlParameter()
+ {
+ ParameterName = string.Format("@param_{0}", num)
+ };
+ SqlParameter target2 = sqlParameter;
+ if (Gestor.Infrastructure.Helpers.Funcoes.u003cu003eo__15.u003cu003ep__6 == null)
+ {
+ Gestor.Infrastructure.Helpers.Funcoes.u003cu003eo__15.u003cu003ep__6 = CallSite<Func<CallSite, object, SqlDbType>>.Create(Microsoft.CSharp.RuntimeBinder.Binder.Convert(CSharpBinderFlags.None, typeof(SqlDbType), typeof(Gestor.Infrastructure.Helpers.Funcoes)));
+ }
+ !0 _u002102 = Gestor.Infrastructure.Helpers.Funcoes.u003cu003eo__15.u003cu003ep__6.Target;
+ CallSite<Func<CallSite, object, SqlDbType>> u003cu003ep_6 = Gestor.Infrastructure.Helpers.Funcoes.u003cu003eo__15.u003cu003ep__6;
+ if (Gestor.Infrastructure.Helpers.Funcoes.u003cu003eo__15.u003cu003ep__5 == null)
+ {
+ Gestor.Infrastructure.Helpers.Funcoes.u003cu003eo__15.u003cu003ep__5 = CallSite<Func<CallSite, Type, object, object>>.Create(Microsoft.CSharp.RuntimeBinder.Binder.InvokeMember(CSharpBinderFlags.None, "GetDbType", null, typeof(Gestor.Infrastructure.Helpers.Funcoes), (IEnumerable<CSharpArgumentInfo>)(new CSharpArgumentInfo[] { CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.UseCompileTimeType | CSharpArgumentInfoFlags.IsStaticType, null), CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.None, null) })));
+ }
+ target2.SqlDbType = _u002102(u003cu003ep_6, Gestor.Infrastructure.Helpers.Funcoes.u003cu003eo__15.u003cu003ep__5.Target(Gestor.Infrastructure.Helpers.Funcoes.u003cu003eo__15.u003cu003ep__5, typeof(Gestor.Infrastructure.Helpers.Funcoes), target));
+ sqlParameter.Value = v;
+ sqlParameter1 = sqlParameter;
+ }
+ SqlParameter sqlParameter2 = sqlParameter1;
+ sqlParameters.Add(sqlParameter2);
+ int cSu0024u003cu003e8_locals1 = num;
+ num = cSu0024u003cu003e8_locals1 + 1;
+ strs.Add(sqlParameter2.ParameterName);
+ });
+ }
+ else
+ {
+ }
+ }
+ else
+ {
+ str = string.Concat(str, (x.Operador == Operador.Igual ? "IS NULL" : "IS NOT NULL"));
+ }
+ if (strs.Count == 1)
+ {
+ str = string.Concat(str, x.Operador.GetDescription(), " ");
+ str = string.Concat(str, strs.First<string>());
+ }
+ if (strs.Count > 1)
+ {
+ str = string.Concat(str, (x.Operador == Operador.Igual ? "IN" : (x.Operador == Operador.Diferente ? "NOT IN" : x.Operador.GetDescription())), " ");
+ str = string.Concat(str, "(", string.Join(",", strs), ")");
+ }
+ strs1.Add(str);
+ });
+ strs2.Add(string.Concat("(", string.Join(g.First<Condicao>().Operacao.GetDescription(), strs1), ")"));
+ });
+ return new SqlQueryCondition()
+ {
+ Condicao = string.Join(" AND ", strs2),
+ Parametros = sqlParameters
+ };
+ }
+
+ public static DataTable CriarAuxiliar(this GenericUnitOfWork _unitOfWork)
+ {
+ DataTable dataTable;
+ object connection;
+ DataTable dataTable1 = new DataTable();
+ SessionFactoryImpl sessionFactory = _unitOfWork.Session.SessionFactory as SessionFactoryImpl;
+ if (sessionFactory != null)
+ {
+ connection = sessionFactory.ConnectionProvider.GetConnection();
+ }
+ else
+ {
+ connection = null;
+ }
+ using (SqlConnection sqlConnection = connection as SqlConnection)
+ {
+ if (sqlConnection != null)
+ {
+ using (SqlCommand sqlCommand = sqlConnection.CreateCommand())
+ {
+ sqlCommand.CommandTimeout = 15000;
+ Auxiliar.CriarAuxiliar(sqlCommand, true);
+ return dataTable1;
+ }
+ }
+ else
+ {
+ dataTable = null;
+ }
+ }
+ return dataTable;
+ }
+
+ public static List<Condicao> CriarCondicao(this Filtros filtro, string referencia)
+ {
+ bool count;
+ bool flag;
+ bool count1;
+ bool flag1;
+ bool count2;
+ bool flag2;
+ bool count3;
+ bool flag3;
+ bool count4;
+ bool flag4;
+ bool count5;
+ List<Condicao> condicaos = new List<Condicao>()
+ {
+ new Condicao()
+ {
+ Campo = referencia,
+ Valores = filtro.Inicio.CriarValor<DateTime>(),
+ Operador = Operador.MaiorEIgual
+ },
+ new Condicao()
+ {
+ Campo = referencia,
+ Valores = filtro.Fim.CriarValor<DateTime>(),
+ Operador = Operador.MenorEIgual
+ }
+ };
+ List<long> seguradoras = filtro.Seguradoras;
+ if (seguradoras != null)
+ {
+ count = seguradoras.Count > 0;
+ }
+ else
+ {
+ count = false;
+ }
+ if (count)
+ {
+ condicaos.Add(new Condicao()
+ {
+ Campo = "c.idciaseg",
+ Valores = filtro.Seguradoras.CriarValor<long>()
+ });
+ }
+ List<long> ramos = filtro.Ramos;
+ if (ramos != null)
+ {
+ flag = ramos.Count > 0;
+ }
+ else
+ {
+ flag = false;
+ }
+ if (flag)
+ {
+ condicaos.Add(new Condicao()
+ {
+ Campo = "c.idramo",
+ Valores = filtro.Ramos.CriarValor<long>()
+ });
+ }
+ List<long> status = filtro.Status;
+ if (status != null)
+ {
+ count1 = status.Count > 0;
+ }
+ else
+ {
+ count1 = false;
+ }
+ if (count1)
+ {
+ condicaos.Add(new Condicao()
+ {
+ Campo = "d.situacao",
+ Valores = filtro.Status.CriarValor<long>()
+ });
+ }
+ List<long> vendedores = filtro.Vendedores;
+ if (vendedores != null)
+ {
+ flag1 = vendedores.Count > 0;
+ }
+ else
+ {
+ flag1 = false;
+ }
+ if (flag1)
+ {
+ condicaos.Add(new Condicao()
+ {
+ Campo = "vp.idvendedor",
+ Valores = filtro.Vendedores.CriarValor<long>()
+ });
+ }
+ List<long> estipulantes = filtro.Estipulantes;
+ if (estipulantes != null)
+ {
+ count2 = estipulantes.Count > 0;
+ }
+ else
+ {
+ count2 = false;
+ }
+ if (count2)
+ {
+ condicaos.Add(new Condicao()
+ {
+ Campo = "d.idestipulante",
+ Valores = filtro.Estipulantes.CriarValor<long>()
+ });
+ }
+ List<long> produtos = filtro.Produtos;
+ if (produtos != null)
+ {
+ flag2 = produtos.Count > 0;
+ }
+ else
+ {
+ flag2 = false;
+ }
+ if (flag2)
+ {
+ condicaos.Add(new Condicao()
+ {
+ Campo = "c.idproduto",
+ Valores = filtro.Produtos.CriarValor<long>()
+ });
+ }
+ List<long> negocio = filtro.Negocio;
+ if (negocio != null)
+ {
+ count3 = negocio.Count > 0;
+ }
+ else
+ {
+ count3 = false;
+ }
+ if (count3)
+ {
+ condicaos.Add(new Condicao()
+ {
+ Campo = "d.NegocioCorretora",
+ Valores = filtro.Negocio.CriarValor<long>()
+ });
+ }
+ List<long> usuarios = filtro.Usuarios;
+ if (usuarios != null)
+ {
+ flag3 = usuarios.Count > 0;
+ }
+ else
+ {
+ flag3 = false;
+ }
+ if (flag3)
+ {
+ condicaos.Add(new Condicao()
+ {
+ Campo = "IdUsuario",
+ Valores = filtro.Usuarios.CriarValor<long>()
+ });
+ }
+ List<long> telas = filtro.Telas;
+ if (telas != null)
+ {
+ count4 = telas.Count > 0;
+ }
+ else
+ {
+ count4 = false;
+ }
+ if (count4)
+ {
+ condicaos.Add(new Condicao()
+ {
+ Campo = "Tela",
+ Valores = filtro.Telas.CriarValor<long>()
+ });
+ }
+ List<long> relatorios = filtro.Relatorios;
+ if (relatorios != null)
+ {
+ flag4 = relatorios.Count > 0;
+ }
+ else
+ {
+ flag4 = false;
+ }
+ if (flag4)
+ {
+ condicaos.Add(new Condicao()
+ {
+ Campo = "Relatorio",
+ Valores = filtro.Relatorios.CriarValor<long>()
+ });
+ }
+ List<FiltroTipoParcela> parcelasEspeciais = filtro.ParcelasEspeciais;
+ if (parcelasEspeciais != null)
+ {
+ count5 = parcelasEspeciais.Count > 0;
+ }
+ else
+ {
+ count5 = false;
+ }
+ if (count5)
+ {
+ if (filtro.ParcelasEspeciais.Any<FiltroTipoParcela>((FiltroTipoParcela x) => x.Selecionado))
+ {
+ condicaos.Add(new Condicao()
+ {
+ Campo = "p.idsubtipo",
+ Valores = (
+ from x in filtro.ParcelasEspeciais
+ where x.Selecionado
+ select (int)x.Tipo).CriarValor<IEnumerable<int>>()
+ });
+ }
+ }
+ if (filtro.IdEmpresa > (long)0)
+ {
+ condicaos.Add(new Condicao()
+ {
+ Campo = "c.idempresa",
+ Valores = filtro.IdEmpresa.CriarValor<long>()
+ });
+ }
+ return condicaos;
+ }
+
+ public static List<dynamic> CriarValor<T>(this T valor)
+ {
+ return new List<object>()
+ {
+ valor
+ };
+ }
+
+ public static List<dynamic> CriarValor<T>(this List<T> lista)
+ {
+ return (
+ from in lista
+ select x).ToList<object>();
+ }
+
+ public static SqlDbType GetDbType(Type giveType)
+ {
+ giveType = Nullable.GetUnderlyingType(giveType) ?? giveType;
+ if (!Gestor.Infrastructure.Helpers.Funcoes.TypeMap.ContainsKey(giveType))
+ {
+ throw new ArgumentException(string.Concat(giveType.FullName, " is not a supported .NET class"));
+ }
+ return Gestor.Infrastructure.Helpers.Funcoes.TypeMap[giveType];
+ }
+
+ public static SqlDbType GetDbType<T>()
+ {
+ return Gestor.Infrastructure.Helpers.Funcoes.GetDbType(typeof(T));
+ }
+
+ public static DateTime GetNetworkTime()
+ {
+ DateTime value;
+ try
+ {
+ if (!Gestor.Infrastructure.Helpers.Funcoes.StartTime.HasValue)
+ {
+ byte[] numArray = new byte[48];
+ numArray[0] = 27;
+ IPEndPoint pEndPoint = new IPEndPoint(((IEnumerable<IPAddress>)Dns.GetHostEntry("time.google.com").AddressList).First<IPAddress>((IPAddress a) => a.AddressFamily == AddressFamily.InterNetwork), 123);
+ using (Socket socket = new Socket(AddressFamily.InterNetwork, SocketType.Dgram, ProtocolType.Udp))
+ {
+ socket.Connect(pEndPoint);
+ socket.ReceiveTimeout = 3000;
+ socket.Send(numArray);
+ socket.Receive(numArray);
+ socket.Close();
+ }
+ ulong num = (ulong)numArray[40] << 24 | (ulong)numArray[41] << 16 | (ulong)numArray[42] << 8 | (ulong)numArray[43];
+ ulong num1 = (ulong)numArray[44] << 24 | (ulong)numArray[45] << 16 | (ulong)numArray[46] << 8 | (ulong)numArray[47];
+ ulong num2 = num * (long)1000 + num1 * (long)1000 / 4294967296L;
+ DateTime dateTime = new DateTime(1900, 1, 1);
+ dateTime = dateTime.AddMilliseconds((double)num2);
+ Gestor.Infrastructure.Helpers.Funcoes.StartTime = new DateTime?(dateTime.ToLocalTime());
+ Gestor.Infrastructure.Helpers.Funcoes.Stopwatch = System.Diagnostics.Stopwatch.StartNew();
+ value = Gestor.Infrastructure.Helpers.Funcoes.StartTime.Value;
+ }
+ else
+ {
+ value = Gestor.Infrastructure.Helpers.Funcoes.StartTime.Value;
+ value = value.AddMilliseconds((double)Gestor.Infrastructure.Helpers.Funcoes.Stopwatch.ElapsedMilliseconds);
+ }
+ }
+ catch (Exception exception)
+ {
+ Gestor.Infrastructure.Helpers.Funcoes.StartTime = new DateTime?(DateTime.Now);
+ Gestor.Infrastructure.Helpers.Funcoes.Stopwatch = System.Diagnostics.Stopwatch.StartNew();
+ value = Gestor.Infrastructure.Helpers.Funcoes.StartTime.Value;
+ }
+ return value;
+ }
+
+ public static bool IsNull(this DataRow row, string field)
+ {
+ return row.Obj(field) == null;
+ }
+
+ public static IQueryable<T> NullSafeWhere<T>(this IQueryable<T> source, Expression<Func<T, bool>> predicate)
+ {
+ if (predicate == null)
+ {
+ return source;
+ }
+ return source.Where<T>(predicate);
+ }
+
+ public static object Obj(this DataRow row, string field)
+ {
+ return row.Field<object>(field);
+ }
+
+ public static DataTable Select(this SqlCommand sqlCommand, SqlQueryCondition sqlCondition, string command, string group = "")
+ {
+ bool count;
+ DataTable dataTable = new DataTable();
+ try
+ {
+ sqlCommand.CommandText = string.Concat(new string[] { command, " ", sqlCondition.Condicao, " ", group });
+ List<SqlParameter> parametros = sqlCondition.Parametros;
+ if (parametros != null)
+ {
+ count = parametros.Count > 0;
+ }
+ else
+ {
+ count = false;
+ }
+ if (count)
+ {
+ sqlCondition.Parametros.ForEach((SqlParameter x) => sqlCommand.Parameters.Add(x));
+ }
+ using (SqlDataAdapter sqlDataAdapter = new SqlDataAdapter())
+ {
+ sqlDataAdapter.SelectCommand = sqlCommand;
+ sqlDataAdapter.Fill(dataTable);
+ }
+ sqlCommand.Parameters.Clear();
+ }
+ catch (Exception exception)
+ {
+ sqlCommand.CommandText = string.Empty;
+ sqlCommand.Parameters.Clear();
+ throw;
+ }
+ return dataTable;
+ }
+
+ public static DataTable Select(this GenericUnitOfWork _unitOfWork, SqlQueryCondition sqlCondition, string command, string group = "")
+ {
+ DataTable dataTable;
+ object connection;
+ bool count;
+ DataTable dataTable1 = new DataTable();
+ SessionFactoryImpl sessionFactory = _unitOfWork.Session.SessionFactory as SessionFactoryImpl;
+ if (sessionFactory != null)
+ {
+ connection = sessionFactory.ConnectionProvider.GetConnection();
+ }
+ else
+ {
+ connection = null;
+ }
+ using (SqlConnection sqlConnection = connection as SqlConnection)
+ {
+ if (sqlConnection != null)
+ {
+ using (SqlCommand sqlCommand = sqlConnection.CreateCommand())
+ {
+ sqlCommand.CommandTimeout = 15000;
+ sqlCommand.CommandText = string.Concat(new string[] { command, " ", sqlCondition.Condicao, " ", group });
+ List<SqlParameter> parametros = sqlCondition.Parametros;
+ if (parametros != null)
+ {
+ count = parametros.Count > 0;
+ }
+ else
+ {
+ count = false;
+ }
+ if (count)
+ {
+ sqlCondition.Parametros.ForEach((SqlParameter x) => sqlCommand.Parameters.Add(x));
+ }
+ using (SqlDataAdapter sqlDataAdapter = new SqlDataAdapter())
+ {
+ sqlDataAdapter.SelectCommand = sqlCommand;
+ sqlDataAdapter.Fill(dataTable1);
+ return dataTable1;
+ }
+ }
+ }
+ else
+ {
+ dataTable = null;
+ }
+ }
+ return dataTable;
+ }
+
+ public static bool Update(this SqlCommand sqlCommand, SqlQueryCondition sqlCondition, string command, List<SqlParameter> parameters = null)
+ {
+ bool flag;
+ string condicao;
+ bool count;
+ if (string.IsNullOrEmpty(command))
+ {
+ return false;
+ }
+ if (sqlCondition != null)
+ {
+ condicao = sqlCondition.Condicao;
+ }
+ else
+ {
+ condicao = null;
+ }
+ if (string.IsNullOrEmpty(condicao))
+ {
+ return false;
+ }
+ if (sqlCondition.Parametros.Count == 0)
+ {
+ return false;
+ }
+ if (command.ToUpper().Contains("SELECT"))
+ {
+ return false;
+ }
+ try
+ {
+ sqlCommand.CommandText = string.Concat(command, " ", sqlCondition.Condicao);
+ List<SqlParameter> parametros = sqlCondition.Parametros;
+ if (parametros != null)
+ {
+ count = parametros.Count > 0;
+ }
+ else
+ {
+ count = false;
+ }
+ if (count)
+ {
+ sqlCondition.Parametros.ForEach((SqlParameter x) => sqlCommand.Parameters.Add(x));
+ }
+ if (parameters != null && parameters.Count > 0)
+ {
+ parameters.ForEach((SqlParameter x) => sqlCommand.Parameters.Add(x));
+ }
+ sqlCommand.ExecuteNonQuery();
+ sqlCommand.Parameters.Clear();
+ return true;
+ }
+ catch (Exception exception)
+ {
+ sqlCommand.CommandText = string.Empty;
+ sqlCommand.Parameters.Clear();
+ flag = false;
+ }
+ return flag;
+ }
+ }
+}
\ No newline at end of file |