protected void BtnExtrato_Click(object sender, EventArgs e) { if (TxtAno.Text.Length != 4) { return; } GetConnection(); try { string output_st_content_block = ""; string output_vr_disp = ""; string output_vr_lim = ""; string pass = Session["pass"].ToString(); string cnpj = Session["cnpj"].ToString(); if (var_exchange.fetch_extratoWeb(cnpj + (CboMes.SelectedIndex + 1).ToString().PadLeft(2, '0') + TxtAno.Text, pass, ref output_st_content_block, ref output_vr_disp, ref output_vr_lim)) { ArrayList values = new ArrayList(); while (output_st_content_block != "") { ArrayList tmp_memory = new ArrayList(); if (var_exchange.fetch_memory(output_st_content_block, "200", ref output_st_content_block, ref tmp_memory)) { long vr_gasto = 0; for (int t = 0; t < tmp_memory.Count; ++t) { Rel_RTC rtc = new Rel_RTC(tmp_memory[t] as DataPortable); PositionData_ExtratoCartao bind = new PositionData_ExtratoCartao(); bind.nsu = rtc.get_st_nsu(); bind.cart = rtc.get_en_op_cartao(); bind.data = var_util.getDDMMYYYY_format(rtc.get_dt_trans()); bind.loja = rtc.get_st_loja(); bind.valor = new money().formatToMoney(rtc.get_vr_total()); vr_gasto += Convert.ToInt64(rtc.get_vr_total()); bind.parcela = rtc.get_st_indice_parcela() + " / " + rtc.get_st_term(); values.Add(bind); } LblTot.Text = "Total disponível: R$ " + new money().formatToMoney(output_vr_disp); if (output_vr_lim == "") { LblLim.Visible = false; } else { LblLim.Text = "Limite mensal: R$ " + new money().formatToMoney(output_vr_lim); } LblGasto.Text = "Total de gastos: R$ " + new money().formatToMoney(vr_gasto.ToString()); } } string note = var_exchange.m_Client.GetServerMessage(); var_exchange.m_Client.ExitSession(); if (note == "") { RptExtrato.DataSource = values; RptExtrato.DataBind(); } else { Session["st_error"] = note; Session["st_error_dest"] = "trans.aspx"; Response.Redirect("error.aspx", true); } } else { var_exchange.m_Client.ExitSession(); Session["st_error"] = var_exchange.m_Client.GetServerMessage(); Session["st_error_dest"] = "trans.aspx"; Response.Redirect("error.aspx", true); } } catch (System.Exception se) { if (se.Message == "Exit") { Session["st_error"] = "Esgotado tempo de espera no servidor"; Session["st_error_dest"] = "login.aspx"; Response.Redirect("error.aspx", true); } } }
public void BuscaDados(DateTime tim) { RptHist.Visible = false; GetConnection(); string st_cartao = Session["st_cartao"].ToString(); string st_senha = Session["st_senha"].ToString(); ArrayList lst = new ArrayList(); ArrayList lstEmp = new ArrayList(); DadosCartaoEdu dce = new DadosCartaoEdu(); money mon = new money(); try { if (var_exchange.web_fetch_edu_virtual(st_cartao, st_senha, var_util.ConvertDate(tim), ref dce, ref lst, ref lstEmp)) { if (dce.get_nu_vrRank() != "0") { LblAluno.Text = "#" + dce.get_nu_vrRank() + " - " + dce.get_st_aluno(); } else { LblAluno.Text = dce.get_st_aluno(); } LblDiaMov.Text = tim.ToLongDateString(); TxtVrDispVirtual.Text = mon.formatToMoney(dce.get_vr_disp_virtual()); TxtVrTotalInv.Text = mon.formatToMoney(dce.get_vr_invest_virtual()); TxtVrTotal.Text = mon.setMoneyFormat(Convert.ToInt64(dce.get_vr_disp_virtual()) + Convert.ToInt64(dce.get_vr_invest_virtual())); ArrayList values = new ArrayList(); ArrayList valuesEmp = new ArrayList(); for (int t = 0; t < lstEmp.Count; ++t) { DadosMovEmpresaVirtual dMov = new DadosMovEmpresaVirtual(lstEmp[t] as DataPortable); PositionData_FundoEmpresa bind = new PositionData_FundoEmpresa(); bind.nome = dMov.get_st_nome(); bind.acoes = dMov.get_vr_acoes(); bind.osc = dMov.get_vr_osc(); bind.vrdia = mon.formatToMoney(dMov.get_vr_dia()); bind.preco_medio = mon.formatToMoney(dMov.get_vr_preco_medio()); bind.invest = (Convert.ToInt64(dMov.get_vr_acoes()) * Convert.ToInt64(dMov.get_vr_dia())).ToString(); bind.invest = mon.formatToMoney(bind.invest); bool neg = false; if (bind.osc.IndexOf("-") >= 0) { neg = true; } bind.osc = bind.osc.Replace("-", ""); bind.osc = bind.osc.PadLeft(4, '0'); int len = bind.osc.Length; if (len == 4) { bind.osc = "0," + bind.osc; } else { bind.osc = bind.osc.Insert(len - 4, ","); } if (neg) { bind.osc = "-" + bind.osc; } bind.osc += "%"; if (bind.osc == "0,0000%") { bind.osc = "-"; } valuesEmp.Add(bind); } RptEmpresas.DataSource = valuesEmp; RptEmpresas.DataBind(); RptEmpresas.Visible = true; for (int t = 0; t < lst.Count; ++t) { DadosMovEmpresaVirtual dMov = new DadosMovEmpresaVirtual(lst[t] as DataPortable); PositionData_MovFundo bind = new PositionData_MovFundo(); bind.nome = dMov.get_st_nome(); bind.mov = dMov.get_vr_mov_fundo(); if (bind.mov.IndexOf("-") == -1) { bind.mov = "+" + bind.mov; } bind.total = dMov.get_vr_total(); values.Add(bind); } RptExtrato.DataSource = values; RptExtrato.DataBind(); RptExtrato.Visible = true; } var_exchange.m_Client.ExitSession(); } catch (System.Exception se) { if (se.Message == "Exit") { Session["st_error"] = "Esgotado tempo de espera no servidor"; Session["st_error_dest"] = "default.aspx"; Response.Redirect("error.aspx", true); } } }
protected void BtnConfirmar_Click(object sender, EventArgs e) { GetConnection(); try { string output_st_content_block = ""; ArrayList desc_status = new TipoConfirmacaoDesc().GetArray(); string pass = Session ["pass"].ToString(); string cnpj = Session ["cnpj"].ToString(); DateTime t_start = (DateTime)DtIni.SelectedDate; DateTime t_end = (DateTime)DtFim.SelectedDate; t_start = new DateTime(t_start.Year, t_start.Month, t_start.Day); if (var_exchange.fetch_consultaLojista(cnpj, var_util.GetDataBaseTimeFormat((DateTime)t_start), var_util.GetDataBaseTimeFormat((DateTime)t_end.AddHours(23).AddMinutes(59).AddSeconds(59)), pass, ref output_st_content_block)) { ArrayList values = new ArrayList(); while (output_st_content_block != "") { ArrayList tmp_memory = new ArrayList(); if (var_exchange.fetch_memory(output_st_content_block, "200", ref output_st_content_block, ref tmp_memory)) { long vr_tot = 0; for (int t = 0; t < tmp_memory.Count; ++t) { DadosConsultaTransacao dct = new DadosConsultaTransacao(tmp_memory[t] as DataPortable); PositionData_Extrato bind = new PositionData_Extrato(); bind.nsu = dct.get_st_nsu(); bind.data = var_util.getDDMMYYYY_format(dct.get_dt_transacao()); bind.valor = new money().formatToMoney(dct.get_vr_valor()); bind.cartao = dct.get_st_cartao(); bind.parcelas = dct.get_nu_parcelas(); bind.desc = desc_status[Convert.ToInt32(dct.get_tg_status())].ToString(); bind.assoc = dct.get_st_cod_empresa(); if (dct.get_tg_status() == TipoConfirmacao.Confirmada) // desfazimento { vr_tot += Convert.ToInt64(dct.get_vr_valor()); } values.Add(bind); } LblTot.Text = "Total : R$ " + new money().formatToMoney(vr_tot.ToString()); } } string note = var_exchange.m_Client.GetServerMessage(); var_exchange.m_Client.ExitSession(); if (note == "") { RptExtrato.DataSource = values; RptExtrato.DataBind(); } else { Session["st_error"] = note; Session["st_error_dest"] = "trans.aspx"; Response.Redirect("error.aspx", true); } } else { var_exchange.m_Client.ExitSession(); Session["st_error"] = var_exchange.m_Client.GetServerMessage(); Session["st_error_dest"] = "trans.aspx"; Response.Redirect("error.aspx", true); } } catch (System.Exception se) { if (se.Message == "Exit") { Session["st_error"] = "Esgotado tempo de espera no servidor"; Session["st_error_dest"] = "login.aspx"; Response.Redirect("error.aspx", true); } } }
protected void BtnConfirmar(object sender, EventArgs e) { GetConnection(); money money_helper = new money(); try { DateTime t_start = (DateTime)DtIni.SelectedDate; DateTime t_end = (DateTime)DtFim.SelectedDate; t_start = new DateTime(t_start.Year, t_start.Month, t_start.Day); string st_csv = ""; string st_total_periodo = ""; GetConnection(); if (!var_exchange.web_fetch_rel_edu_extrato(Session["st_cartao"].ToString(), var_util.DESCript(TxtSenha.Value.PadLeft(8, '*'), "12345678"), var_util.GetDataBaseTimeFormat((DateTime)t_start), var_util.GetDataBaseTimeFormat((DateTime)t_end.AddHours(23).AddMinutes(59).AddSeconds(59)), SyCrafEngine.Context.TRUE, ref st_csv, ref st_total_periodo)) { var_exchange.m_Client.ExitSession(); Session["st_error"] = var_exchange.m_Client.GetServerMessage(); Session["st_error_dest"] = "RespExt.aspx"; Response.Redirect("error.aspx", true); return; } RptExtrato.Visible = true; LblExtrato.Visible = true; LblExtrato.Text = "Extrato de atividades do cartão: " + DtIni.SelectedDate.ToShortDateString() + " até " + DtFim.SelectedDate.ToShortDateString(); ArrayList values = new ArrayList(); ArrayList desc = new TipoConfirmacaoDesc().GetArray(); ArrayList desc_op = new OperacaoCartaoDesc().GetArray(); while (st_csv != "") { ArrayList list = new ArrayList(); var_exchange.fetch_memory(st_csv, "400", ref st_csv, ref list); for (int t = 0; t < list.Count; ++t) { EduExtrato rel_line = new EduExtrato(list[t] as DataPortable); PositionData_ExtratoEdu bind = new PositionData_ExtratoEdu(); bind.nsu = rel_line.get_st_nsu(); bind.data = var_util.getDDMMYYYY_format(rel_line.get_dt_trans()); bind.valor = money_helper.formatToMoney(rel_line.get_vr_valor()); bind.loja = rel_line.get_st_loja(); bind.saldo = money_helper.formatToMoney(rel_line.get_vr_disp()); bind.fundo = money_helper.formatToMoney(rel_line.get_vr_fundo()); bind.operacao = desc_op[Convert.ToInt32(rel_line.get_en_oper())].ToString(); values.Add(bind); } } RptExtrato.DataSource = values; RptExtrato.DataBind(); var_exchange.m_Client.ExitSession(); } catch (System.Exception se) { if (se.Message == "Exit") { Session["st_error"] = "Esgotado tempo de espera no servidor"; Session["st_error_dest"] = "default.aspx"; Response.Redirect("error.aspx", true); } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { LblNome.Text = Session["nome"].ToString(); GetConnection(); try { string output_st_content_block = ""; string pass = Session["pass"].ToString(); string cnpj = Session["cnpj"].ToString(); if (var_exchange.fetch_extratoWebFuturo(cnpj, pass, ref output_st_content_block)) { ArrayList values = new ArrayList(); while (output_st_content_block != "") { ArrayList tmp_memory = new ArrayList(); if (var_exchange.fetch_memory(output_st_content_block, "200", ref output_st_content_block, ref tmp_memory)) { long vr_gasto = 0; for (int t = 0; t < tmp_memory.Count; ++t) { Rel_RTC rtc = new Rel_RTC(tmp_memory[t] as DataPortable); PositionData_ExtratoCartaoFuturo bind = new PositionData_ExtratoCartaoFuturo(); bind.loja = rtc.get_st_loja(); bind.valor = new money().formatToMoney(rtc.get_vr_total()); vr_gasto += Convert.ToInt64(rtc.get_vr_total()); bind.parcela = rtc.get_st_indice_parcela() + " / " + rtc.get_nu_parc(); values.Add(bind); } LblGasto.Text = "Total previsto: R$ " + new money().formatToMoney(vr_gasto.ToString()); } } string note = var_exchange.m_Client.GetServerMessage(); var_exchange.m_Client.ExitSession(); if (note == "") { RptExtrato.DataSource = values; RptExtrato.DataBind(); } else { Session["st_error"] = note; Session["st_error_dest"] = "trans.aspx"; Response.Redirect("error.aspx", true); } } else { var_exchange.m_Client.ExitSession(); Session["st_error"] = var_exchange.m_Client.GetServerMessage(); Session["st_error_dest"] = "trans.aspx"; Response.Redirect("error.aspx", true); } } catch (System.Exception se) { if (se.Message == "Exit") { Session["st_error"] = "Esgotado tempo de espera no servidor"; Session["st_error_dest"] = "login.aspx"; Response.Redirect("error.aspx", true); } } } }