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