public void importarOFX() { Microsoft.Win32.OpenFileDialog dlg = new Microsoft.Win32.OpenFileDialog(); dlg.DefaultExt = ".ofx"; dlg.Filter = "Arquivo OFX (.ofx)|*.ofx"; Nullable <bool> result = dlg.ShowDialog(); if (result == true) { try { FileStream ofxFile = new FileStream(dlg.FileName, FileMode.Open, FileAccess.Read); OFXImport ofxImport = new OFXImport(); OFXContaDTO ofxConta = ofxImport.import(dlg.FileName); List <ExtratoContaBancoDTO> listaExtratoAux = new List <ExtratoContaBancoDTO>(); foreach (OFXTransacaoDTO trans in ofxConta.transacoes) { ExtratoContaBancoDTO extrato = new ExtratoContaBancoDTO(); extrato.idContaCaixa = contaCaixaSelected.id; DateTime data = converterData(trans.data); extrato.dataBalancete = data; extrato.dataMovimento = data; extrato.mes = data.Month.ToString("00"); extrato.ano = data.Year.ToString(); extrato.historico = trans.historico; extrato.documento = trans.numero; extrato.valor = decimal.Parse(trans.valor.Replace(".", ",")); listaExtratoAux.Add(extrato); } using (ConciliacaoServiceClient conciliacaoService = new ConciliacaoServiceClient()) { conciliacaoService.saveUpdateListaExtrato(listaExtratoAux); this.atualizarListaExtrato(); } } catch (Exception ex) { throw ex; } } }