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;
}
}
}
