public Dictionary<string, object> BuscarPorId(string Id, string Connection, string StringQuery, string dbType)
        {
            RepositoryHelper repositorio = new RepositoryHelper(dbType);
            Dictionary<string, object> entidade = new Dictionary<string, object>();
            Dictionary<string, string> parameters = new Dictionary<string, string>();
            parameters.Add("@id", Id);
            DataTableReader dataReader = repositorio.ExecutaQuery(Connection, StringQuery, CommandType.Text, parameters).CreateDataReader();
            while (dataReader.Read())
            {
                int fields = dataReader.FieldCount;

                for (int i = 0; i < fields; i++)
                {

                    if (dataReader[i] == null)
                        entidade.Add(dataReader.GetName(i).ToLower(), string.Empty);
                    else
                    {
                        if (dataReader.GetName(i).ToLower().Contains("_cript"))
                            entidade.Add(dataReader.GetName(i).ToLower().Replace("_cript", ""), Sennit.Cryptography.SennitCrypt.DeCrypt(dataReader[i].ToString(), "A!09#x*&aTe$"));
                        else
                            entidade.Add(dataReader.GetName(i).ToLower(), dataReader[i]);
                    }
                }
            }

            return entidade;
        }
        private static void BuscaRegistrosLista(string Connection, string StringQuery, Dictionary<string, string> parametros, PaginadoGenerico listaPaginado, RepositoryHelper repositorio, String TipoQuery)
        {
            System.Data.CommandType CommandType = CommandType.StoredProcedure;
            if (TipoQuery == "Text" || TipoQuery == "Select")
            {
                CommandType = CommandType.Text;

                DataTableReader dataReader = repositorio.ExecutaQuery(Connection, StringQuery, CommandType, parametros).CreateDataReader();
                while (dataReader.Read())
                {
                    int fields = dataReader.FieldCount;
                    Dictionary<string, object> parametrosLista = new Dictionary<string, object>();

                    for (int i = 0; i < fields; i++)
                    {

                        if (dataReader[i] == null)
                            parametrosLista.Add(dataReader.GetName(i).ToLower(), string.Empty);
                        else
                        {
                            if (dataReader.GetName(i).ToLower().Contains("_cript"))
                                parametrosLista.Add(dataReader.GetName(i).ToLower().Replace("_cript", ""), Sennit.Cryptography.SennitCrypt.DeCrypt(dataReader[i].ToString(), "A!09#x*&aTe$"));
                            else
                                parametrosLista.Add(dataReader.GetName(i).ToLower(), dataReader[i]);
                        }
                    }
                    listaPaginado._Lista.Add(parametrosLista);

                }
            }
            else
            {
                listaPaginado._Lista = repositorio.ExecutaQueryProcedure(Connection, StringQuery, CommandType, parametros);
            }
        }
 private static void RetornaInformacoesLista(int page, int tamanhoDaPagina, string Connection, string QueryCount, Dictionary<string, string> parametros, PaginadoGenerico listaPaginado, RepositoryHelper repositorio)
 {
     DataTableReader dataReaderCount = repositorio.ExecutaQuery(Connection, QueryCount, System.Data.CommandType.Text, parametros).CreateDataReader();
     listaPaginado.PaginaAtual = page;
     while (dataReaderCount.Read())
     {
         listaPaginado.TotalDeRegistros = Convert.ToInt32(dataReaderCount[0].ToString());
         if (tamanhoDaPagina != 0)
             listaPaginado.TotalDePaginas = (listaPaginado.TotalDeRegistros / tamanhoDaPagina);
     }
     listaPaginado.TamanhoDaPagina = page;
     listaPaginado.TotalDeRegistrosDaPagina = listaPaginado._Lista.Count;
 }