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 bool GravarRegistrosTEFData(int idconta, string data)
{
List <BancoTEF> ConexaoTEF = DAL.ListarObjetos <BancoTEF>();
foreach (var item in ConexaoTEF)
{
var ddata = DateTime.Parse(data); // DAL.GetDate(string.Format("select cast(coalesce(max(data_atual) ,'1900-01-01') as date) as maior_data from cadastro_transacoes_tef where id_conta = {0} and UPPER(estabelecimento) like UPPER('{1}%') ", item.IdConta, item.identificacao_tef));
TransacoesTEF TransacaoTEF = TEFDAL.TransacaoIncluir(Convert.ToInt64(idconta), ddata.Ticks, ddata.Ticks, item);
}
return(true);
}
public bool GravarRegistrosAbdias()
{
var data_ini = Convert.ToDateTime("2017-09-01");
var data_fim = Convert.ToDateTime("2018-09-17");
BancoTEF model = new BancoTEF();
model.identificacao_tef = "VarejaoAbdias";
model.usuario_banco = "vspague_suporte";
model.ip_banco = "172.31.255.28";
model.porta_banco = "1521";
model.senha_banco = "@s0t3cht1";
model.IdConta = 118;
TransacoesTEF TransacaoTEF = TEFDAL.TransacaoIncluir(118, data_ini.Ticks, data_fim.Ticks, model);
return(true);
}
public bool GravarRegistrosEletricaCapit()
{
var data_ini = Convert.ToDateTime("2017-09-06");
var data_fim = Convert.ToDateTime("2017-09-17");
BancoTEF model = new BancoTEF();
model.identificacao_tef = "EletricaCapit";
model.usuario_banco = "vspague_suporte";
model.ip_banco = "172.31.255.38";
model.porta_banco = "1521";
model.senha_banco = "@s0t3cht1";
model.IdConta = 9;
TransacoesTEF TransacaoTEF = TEFDAL.TransacaoIncluir(9, data_ini.Ticks, data_fim.Ticks, model);
return(true);
}
public List <TransacaoTEFListar> TransacaoTEFListar(long idconta, string rede, long tpsituacao,
long tpdata, long datainicio, long datafinal, string valor, string estabelecimento, string administrador, string resumo = "0", string loja = "0", string tp_transacao = "0", string tp_operacao = "0")
{
var tef = TEFDAL.TransacaoTEFListar(idconta, rede, 0, 0, datainicio, datafinal, Convert.ToDecimal(valor), estabelecimento ?? "-111", administrador ?? "-111", resumo, loja, tp_transacao, tp_operacao);
return(tef);
/*
*
* string filtro = String.Format("id_conta={0}", idconta);
* if (idrede != 0)
* {
* filtro = filtro +
* String.Format(
* " and ds_rede=(select ds_rede from cadastro_rede where id_rede={0} and id_conta={1})",
* idrede, idconta);
* }
*
* if (tpsituacao == 0)
* {
* filtro = filtro +
* " and coalesce((select 1 from conciliador_tef t where t.ds_rede = a.ds_rede and t.dt_transacao = a.dt_transacao and t.nsu_rede = a.nsu_rede),0) = 1";
* }
* else if (tpsituacao == 1)
* {
* filtro = filtro +
* " and coalesce((select 1 from conciliador_tef t where t.ds_rede = a.ds_rede and t.dt_transacao = a.dt_transacao and t.nsu_rede = a.nsu_rede),0) = 0";
* }
*
* filtro = filtro +
* String.Format(" and {0} between '{1}' and '{2}' ",
* tpdata.Equals(0) ? "dt_transacao" : "dt_transacao",
* new DateTime(datainicio).ToString("yyyy-MM-dd"),
* new DateTime(datafinal).ToString("yyyy-MM-dd"));
*
* DAL.ListarObjetos<TransacaoTEF>(filtro,
* String.Format(" 6 {0} desc ", tpdata.Equals(0) ? ",dt_transacao" : ",dt_transacao")); */
}
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();
}
}
public List <TransacaoTEFTpTransacao> GetTipoTransacoes(long idconta)
{
var tef = TEFDAL.GetTipoTransacoes(idconta);
return(tef);
}
public List <TransacaoTEFLojas> GetLojas(long idconta)
{
var tef = TEFDAL.GetLojas(idconta);
return(tef);
}
