public ActionResult BuscaTEF(TransacaoRedeViewModel model) { if (model.filtro_rede.GetValueOrDefault(0) == 0) { model.filtro_nm_rede = ""; } ViewBag.tp_data = Models.DataTypes.getDataTypes(); ViewBag.tp_cartao = Models.CartaoTypes.getCartaoTypes(); var listar = new TransacaoRedeViewModel { filtro_rede = model.filtro_rede, filtro_nm_rede = model.filtro_nm_rede, tp_situacao = model.tp_situacao, TransacaoArquivos = _restRelatorio.TransacaoRedeListar(0, model.tp_cartao, 0, model.DataInicio ?? DateTime.MinValue, model.DataFinal ?? DateTime.MaxValue, model.resumo, "0") ?? new List <ConciliacaoTransacaoRede>(), DataInicio = model.DataInicio ?? DateTime.MinValue, DataFinal = model.DataFinal ?? DateTime.MaxValue, tp_data = model.tp_data, tp_cartao = model.tp_cartao }; var conta = new BaseID(); foreach (var item in listar.TransacaoArquivos) { var status = TEFDAL.GetStatusTEF(conta.IdConta, item.is_numero_cv); item.is_codigo_tef = status.CodigoTEF; item.is_nsu_tef = status.NSUTEF; item.is_nsu_rede = status.NSUREDE; } return(View("RelatoriosTransacoesRede", listar)); }
public ActionResult RelatoriosTransacoesRede(TransacaoRedeViewModel model) { if (model.filtro_rede.GetValueOrDefault(0) == 0) { model.filtro_nm_rede = ""; } ViewBag.tp_data = Models.DataTypes.getDataTypes(); ViewBag.tp_cartao = Models.CartaoTypes.getCartaoTypes(); var listar = new TransacaoRedeViewModel { filtro_rede = model.filtro_rede, filtro_nm_rede = model.filtro_nm_rede, tp_situacao = model.tp_situacao, TransacaoArquivos = _restRelatorio.TransacaoRedeListar(0, model.tp_cartao, 0, model.DataInicio ?? DateTime.MinValue, model.DataFinal ?? DateTime.MaxValue, model.resumo, "0") ?? new List <ConciliacaoTransacaoRede>(), DataInicio = model.DataInicio ?? DateTime.MinValue, DataFinal = model.DataFinal ?? DateTime.MaxValue, tp_data = model.tp_data, tp_cartao = model.tp_cartao, resumo = model.resumo }; return(View("RelatoriosTransacoesRede", listar)); }
public ActionResult BuscaTEF() { ViewBag.tp_cartao = Models.CartaoTypes.getCartaoTypes(3); var listar = new TransacaoRedeViewModel { tp_situacao = 2, TransacaoArquivos = new List <ConciliacaoTransacaoRede>(), DataInicio = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1), DataFinal = DateTime.Now.Date, tp_data = 0, /// emissao tp_cartao = 3 }; ViewBag.tp_data = Models.DataTypes.getDataTypes(); ViewBag.Disabled = "disabled"; return(View("RelatoriosTransacoesRede", listar)); }
// GET: Relatorios public ActionResult RelatoriosTransacoesRede(string data, string debitocredito) { var datainicio = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1); var datafinal = DateTime.Now.Date; var tp_cartao = 3; var transacaoarquivos = new List <ConciliacaoTransacaoRede>(); if (!String.IsNullOrEmpty(data)) { datainicio = DateTime.ParseExact(data.Substring(4, 4) + "-" + data.Substring(2, 2) + "-" + data.Substring(0, 2), "yyyy-MM-dd", CultureInfo.InvariantCulture); datafinal = datainicio; } if (!String.IsNullOrEmpty(debitocredito)) { tp_cartao = 3; transacaoarquivos = _restRelatorio.TransacaoRedeListar(0, tp_cartao, 1, datainicio, datafinal, "0", "0") ?? new List <ConciliacaoTransacaoRede>(); } ViewBag.tp_cartao = Models.CartaoTypes.getCartaoTypes(tp_cartao); var listar = new TransacaoRedeViewModel { tp_situacao = 2, TransacaoArquivos = transacaoarquivos, DataInicio = datainicio, DataFinal = datafinal, tp_data = 0, /// emissao tp_cartao = tp_cartao, resumo = "0" }; ViewBag.Disabled = "disabled"; ViewBag.tp_data = Models.DataTypes.getDataTypes(); return(View("RelatoriosTransacoesRede", listar)); }
public FileResult BuscaTEFXML(FormCollection frm) { var stream = new MemoryStream(); try { DateTime datainicio = DateTime.ParseExact(frm["DataInicio"].ToString(), "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture); DateTime datafinal = DateTime.ParseExact(frm["DataFinal"].ToString(), "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture); var listar = new TransacaoRedeViewModel { TransacaoArquivos = _restRelatorio.TransacaoRedeListar(0, Convert.ToInt32(frm["tp_cartao"]), 0, datainicio, datafinal, frm["resumo"], "0") ?? new List <ConciliacaoTransacaoRede>(), DataInicio = datainicio, DataFinal = datafinal, tp_data = Convert.ToInt32(frm["tp_data"]), tp_cartao = Convert.ToInt32(frm["tp_cartao"]), resumo = frm["resumo"] }; var conta = new BaseID(); foreach (var item in listar.TransacaoArquivos) { var status = TEFDAL.GetStatusTEF(conta.IdConta, item.is_numero_cv); item.is_codigo_tef = status.CodigoTEF; item.is_nsu_tef = status.NSUTEF; item.is_nsu_rede = status.NSUREDE; } var objs = new List <ConciliacaoTransacaoRede>(); var doc = new XmlDocument(); var serializer = new XmlSerializer(objs.GetType()); serializer.Serialize(stream, listar.TransacaoArquivos); stream.Position = 0; doc.Load(stream); string FileBankPhysicalFolder = Server.MapPath("~/XMLS/"); string Name = ("RelatorioTrancacoes_" + DateTime.Now.Date.ToString().Substring(0, 10).Replace("/", "") + "_" + DateTime.Now.ToString().Substring(11, 8).Replace(":", "") + ".xml").Replace(" ", "_"); string FileBankPath = FileBankPhysicalFolder + Name; if (!System.IO.File.Exists(FileBankPath)) { System.IO.File.Create(FileBankPath).Close(); } string Content = doc.InnerXml; System.IO.File.WriteAllText(FileBankPath, Content); FileInfo file = new FileInfo(FileBankPath); //path: directory of file; fich: name of file with spaces Response.Clear(); Response.AddHeader("Content-Disposition", string.Format("attachment; filename={0}", file.Name)); Response.ContentType = "application/octet-stream"; Response.AddHeader("Content-Length", file.Length.ToString()); Response.Flush(); Response.WriteFile(FileBankPath); Response.End(); return(File(FileBankPath, System.Net.Mime.MediaTypeNames.Application.Octet, Path.GetFileName(FileBankPath))); } catch (Exception e) { DALErro.Gravar(e.Message + " / " + e.StackTrace); throw e; } finally { stream.Close(); stream.Dispose(); } }