public void ImportarFundos(ANBIMAFundosInfo pInfo)
{
if (pInfo.CodigoFundo == string.Empty)
{
return;
}
using (AcessaDados lAcessaDados = new AcessaDados())
{
lAcessaDados.Conexao = new Conexao();
lAcessaDados.ConnectionStringName = "PlataformaInviXX";
using (DbCommand lComm = lAcessaDados.CreateCommand(CommandType.StoredProcedure, "PRC_ANBIMA_FUNDOS_INS"))
{
lAcessaDados.AddInParameter(lComm, "@CodigoFundo", DbType.String, pInfo.CodigoFundo);
lAcessaDados.AddInParameter(lComm, "@CodigoInstituicao", DbType.String, pInfo.CodigoInstituicao);
lAcessaDados.AddInParameter(lComm, "@NomeFanatasia", DbType.String, pInfo.NomeFanatasia);
lAcessaDados.AddInParameter(lComm, "@Gestor", DbType.String, pInfo.Gestor);
lAcessaDados.AddInParameter(lComm, "@CodigoTipo", DbType.Int32, pInfo.CodigoTipo);
lAcessaDados.AddInParameter(lComm, "@DataInicial", DbType.DateTime, pInfo.DataInicial);
lAcessaDados.AddInParameter(lComm, "@DataFim", DbType.DateTime, pInfo.DataFim);
lAcessaDados.AddInParameter(lComm, "@DataInfo", DbType.DateTime, pInfo.DataInfo);
lAcessaDados.AddInParameter(lComm, "@PerfilCota", DbType.String, pInfo.PerfilCota);
lAcessaDados.AddInParameter(lComm, "@DataDiv", DbType.DateTime, pInfo.DataDiv);
lAcessaDados.AddInParameter(lComm, "@RazaoSocial", DbType.String, pInfo.RazaoSocial);
lAcessaDados.AddInParameter(lComm, "@CNPJ", DbType.String, pInfo.CNPJ);
lAcessaDados.AddInParameter(lComm, "@Aberto", DbType.String, pInfo.Aberto);
lAcessaDados.AddInParameter(lComm, "@Exclusivo", DbType.String, pInfo.Exclusivo);
lAcessaDados.AddInParameter(lComm, "@PrazoEmissaoCotas", DbType.String, pInfo.PrazoEmissaoCotas);
lAcessaDados.AddInParameter(lComm, "@PrazoConvResg", DbType.String, pInfo.PrazoConvResg);
lAcessaDados.AddInParameter(lComm, "@PrazoPagtoResg", DbType.String, pInfo.PrazoPagtoResg);
lAcessaDados.AddInParameter(lComm, "@CarenciaUniversal", DbType.Int32, pInfo.CarenciaUniversal);
lAcessaDados.AddInParameter(lComm, "@CarenciaCiclica", DbType.Int32, pInfo.CarenciaCiclica);
lAcessaDados.AddInParameter(lComm, "@CotaAbertura", DbType.String, pInfo.CotaAbertura);
lAcessaDados.AddInParameter(lComm, "@PeriodoDivulgacao", DbType.Int32, pInfo.PeriodoDivulgacao);
lAcessaDados.AddInParameter(lComm, "@DataHora", DbType.DateTime, pInfo.DataHora);
DataTable dt = lAcessaDados.ExecuteDbDataTable(lComm);
}
}
}
private ANBIMAFundosInfo RetornaFundosAnbima(string linha)
{
var lFundo = new ANBIMAFundosInfo();
try
{
string[] lCadFundoString = linha.Split('\t');
lFundo.CodigoFundo = lCadFundoString[0].Replace("\n", "");
lFundo.CodigoInstituicao = lCadFundoString[1].ToString();
lFundo.NomeFanatasia = lCadFundoString[2].ToString();
lFundo.CodigoTipo = lCadFundoString[3].DBToInt32();
lFundo.DataInicial = lCadFundoString[4].DBToDateTime();
lFundo.DataFim = lCadFundoString[5].DBToDateTime(eDateNull.Permite);
lFundo.DataInfo = lCadFundoString[6].DBToDateTime();
lFundo.PerfilCota = lCadFundoString[7].DBToString();
lFundo.DataDiv = lCadFundoString[8].DBToDateTime();
lFundo.RazaoSocial = lCadFundoString[9].ToString();
lFundo.CNPJ = lCadFundoString[10].ToString();
lFundo.Aberto = lCadFundoString[11].ToString();
lFundo.Exclusivo = lCadFundoString[12].ToString();
lFundo.PrazoEmissaoCotas = lCadFundoString[13].ToString();
lFundo.PrazoConvResg = lCadFundoString[14].ToString();
lFundo.PrazoPagtoResg = lCadFundoString[15].ToString();
lFundo.CarenciaUniversal = lCadFundoString[16].DBToInt32();
lFundo.CarenciaCiclica = lCadFundoString[17].DBToInt32();
lFundo.CotaAbertura = lCadFundoString[18].ToString();
lFundo.PeriodoDivulgacao = lCadFundoString[19].DBToInt32();
lFundo.DataHora = DateTime.Now;
}
catch (Exception ex)
{
gLogger.ErrorFormat("Erro encontrado no método RetornaFundosMes - [{0}] ", ex.StackTrace);
}
return(lFundo);
}
/// <summary>
/// Importar Fundos do banco de dados da anbima para o sql
/// </summary>
public void ImportarFundos()
{
try
{
List <ANBIMAFundosInfo> ListaFundos = null;
string lSql = "select * from fundos where datafim is null";
OdbcConnection lConexao = new OdbcConnection(ConnectionString);
OdbcCommand lCommand = new OdbcCommand(lSql, lConexao);
lConexao.Open();
OdbcDataReader lReader = lCommand.ExecuteReader(CommandBehavior.CloseConnection);
ListaFundos = new List <Lib.ANBIMA.ANBIMAFundosInfo>();
while (lReader.Read())
{
ANBIMAFundosInfo lInfo = new ANBIMAFundosInfo();
lInfo.CodigoFundo = lReader["codFundo"].ToString().PadLeft(6, '0');
lInfo.CodigoInstituicao = lReader["CodInst"].ToString();
lInfo.NomeFanatasia = lReader["fantasia"].ToString();
lInfo.Gestor = lReader["gestor"].ToString();
lInfo.CodigoTipo = Convert.ToInt32(lReader["Codtipo"].ToString());
lInfo.DataInicial = Convert.ToDateTime(lReader["DataIni"].ToString());
lInfo.DataFim = lReader["DataFim"].DBToDateTime(eDateNull.Permite);
lInfo.DataInfo = Convert.ToDateTime(lReader["DataInfo"].ToString());
lInfo.PerfilCota = lReader["perfil_cota"].ToString();
lInfo.DataDiv = Convert.ToDateTime(lReader["DataDiv"].ToString());
lInfo.RazaoSocial = lReader["razaosoc"].ToString();
lInfo.CNPJ = lReader["cnpj"].ToString();
lInfo.Aberto = lReader["aberto"].ToString();
lInfo.Exclusivo = lReader["exclusivo"].ToString();
lInfo.PrazoEmissaoCotas = lReader["prazo_emis_cotas"].ToString();
lInfo.PrazoConvResg = lReader["prazo_conv_resg"].ToString();
lInfo.PrazoPagtoResg = lReader["prazo_pgto_resg"].ToString();
lInfo.CarenciaUniversal = lReader["carencia_universal"].DBToInt32();
lInfo.CarenciaCiclica = lReader["carencia_ciclica"].DBToInt32();
lInfo.CotaAbertura = lReader["cota_abertura"].ToString();
lInfo.PeriodoDivulgacao = Convert.ToInt32(lReader["periodo_divulg"].ToString());
lInfo.DataHora = Convert.ToDateTime(lReader["DataHora"].ToString());
ListaFundos.Add(lInfo);
}
lConexao.Close();
using (AcessaDados lAcessaDados = new AcessaDados())
{
lAcessaDados.Conexao = new Conexao();
lAcessaDados.ConnectionStringName = "PlataformaInviXX";
foreach (var fundos in ListaFundos)
{
using (DbCommand lComm = lAcessaDados.CreateCommand(CommandType.StoredProcedure, "PRC_ANBIMA_FUNDOS_INS"))
{
lAcessaDados.AddInParameter(lComm, "@CodigoFundo", DbType.String, fundos.CodigoFundo);
lAcessaDados.AddInParameter(lComm, "@CodigoInstituicao", DbType.String, fundos.CodigoInstituicao);
lAcessaDados.AddInParameter(lComm, "@NomeFanatasia", DbType.String, fundos.NomeFanatasia);
lAcessaDados.AddInParameter(lComm, "@Gestor", DbType.String, fundos.Gestor);
lAcessaDados.AddInParameter(lComm, "@CodigoTipo", DbType.Int32, fundos.CodigoTipo);
lAcessaDados.AddInParameter(lComm, "@DataInicial", DbType.DateTime, fundos.DataInicial);
lAcessaDados.AddInParameter(lComm, "@DataFim", DbType.DateTime, fundos.DataFim);
lAcessaDados.AddInParameter(lComm, "@DataInfo", DbType.DateTime, fundos.DataInfo);
lAcessaDados.AddInParameter(lComm, "@PerfilCota", DbType.String, fundos.PerfilCota);
lAcessaDados.AddInParameter(lComm, "@DataDiv", DbType.DateTime, fundos.DataDiv);
lAcessaDados.AddInParameter(lComm, "@RazaoSocial", DbType.String, fundos.RazaoSocial);
lAcessaDados.AddInParameter(lComm, "@CNPJ", DbType.String, fundos.CNPJ);
lAcessaDados.AddInParameter(lComm, "@Aberto", DbType.String, fundos.Aberto);
lAcessaDados.AddInParameter(lComm, "@Exclusivo", DbType.String, fundos.Exclusivo);
lAcessaDados.AddInParameter(lComm, "@PrazoEmissaoCotas", DbType.String, fundos.PrazoEmissaoCotas);
lAcessaDados.AddInParameter(lComm, "@PrazoConvResg", DbType.String, fundos.PrazoConvResg);
lAcessaDados.AddInParameter(lComm, "@PrazoPagtoResg", DbType.String, fundos.PrazoPagtoResg);
lAcessaDados.AddInParameter(lComm, "@CarenciaUniversal", DbType.Int32, fundos.CarenciaUniversal);
lAcessaDados.AddInParameter(lComm, "@CarenciaCiclica", DbType.Int32, fundos.CarenciaCiclica);
lAcessaDados.AddInParameter(lComm, "@CotaAbertura", DbType.String, fundos.CotaAbertura);
lAcessaDados.AddInParameter(lComm, "@PeriodoDivulgacao", DbType.Int32, fundos.PeriodoDivulgacao);
lAcessaDados.AddInParameter(lComm, "@DataHora", DbType.DateTime, fundos.DataHora);
DataTable dt = lAcessaDados.ExecuteDbDataTable(lComm);
}
}
}
}
catch (Exception ex)
{
throw ex;
}
}
