private void ValoresMensais(DateTime dataInicial, DateTime dataFinal) { Usuario u = (Usuario)Session["UsuarioLogado"]; Operacao o = new Operacao(); float despesas = 0; float receitas = 0; float balancoMensal = 0; //Despesas DataTable dtDespesas = new DataTable(); dtDespesas = o.VisualizarDespesas(u.id, dataInicial, dataFinal); foreach (DataRow row in dtDespesas.Rows) { foreach (DataColumn coloumn in dtDespesas.Columns) { if (coloumn.ColumnName == "valor") { float x = float.Parse(row[coloumn.ColumnName].ToString()); despesas += x; } } } //Receitas DataTable dtReceitas = new DataTable(); dtReceitas = o.VisualizarReceitas(u.id, dataInicial, dataFinal); foreach (DataRow row in dtReceitas.Rows) { foreach (DataColumn coloumn in dtReceitas.Columns) { if (coloumn.ColumnName == "valor") { float x = float.Parse(row[coloumn.ColumnName].ToString()); receitas += x; } } } //Balanço balancoMensal = receitas - despesas; //Interface txtDespesas.Text = despesas.ToString("N2"); txtReceitas.Text = receitas.ToString("N2"); txtBalanco.Text = balancoMensal.ToString("N2"); }
private void PreencherDados() { int id = Convert.ToInt32(Session["IdOperacao"]); Operacao o = new Operacao(); o = o.SelecionarporId(id); txtData.Value = o.dataHora.ToString("yyyy-MM-dd"); txtDescricao.Value = o.descricao; txtValor.Value = o.valor.ToString("N2"); cmbCategorias.Value = o.categoria; cmbContas.Value = o.conta; Session["Temp"] = o; }
protected void gvReceitas_RowCommand(object sender, GridViewCommandEventArgs e) { int index = Convert.ToInt32(e.CommandArgument.ToString()); int id = Convert.ToInt32(gvReceitas.DataKeys[index]["id"]); if (e.CommandName == "Excluir") { Operacao o = new Operacao(); bool r = o.ExcluirOperacao(id); PreencherGrid(DataInicial(), DataFinal()); } else if (e.CommandName == "Editar") { Session["IdOperacao"] = id; Response.Redirect(@"~/UsrNovaReceita.aspx"); } }
private void PreencherGrid(DateTime dataInicial, DateTime dataFinal) { Usuario u = (Usuario)Session["UsuarioLogado"]; Operacao o = new Operacao(); float totalDespesas = 0; try { gvDespesas.DataSource = o.VisualizarDespesas(u.id, dataInicial, dataFinal); gvDespesas.DataBind(); if (gvDespesas.Rows.Count >= 1) { DataTable dt = o.VisualizarDespesas(u.id, dataInicial, dataFinal); foreach (DataRow row in dt.Rows) { foreach (DataColumn coloumn in dt.Columns) { if (coloumn.ColumnName == "valor") { float x = float.Parse(row[coloumn.ColumnName].ToString()); totalDespesas += x; } } } lblTotalDespesas.Text = totalDespesas.ToString("C2"); } else { gvDespesas.EmptyDataText = "<center><p>Nenhum dado a ser exibido.</p> <p>Clique em '<b>Novo</b>' para adicionar uma transação.</p></center>"; gvDespesas.DataBind(); lblTotalDespesas.Text = "R$ 0,00"; } } catch { Session["UsuarioLogado"] = null; Response.Redirect(@"~/login.aspx"); } }
public Operacao SelecionarporId(int id) { DataBase db = new DataBase(); NpgsqlCommand cmd = new NpgsqlCommand(); Operacao o = new Operacao(); try { cmd.CommandText = "Select * from operacoes WHERE id = @id"; cmd.Parameters.AddWithValue("@id", id); cmd.Connection = db.OpenConnection(); NpgsqlDataReader reader = cmd.ExecuteReader(); if (reader.Read()) { o.id = Convert.ToInt32(reader["id"]); o.descricao = reader["descricao"].ToString(); o.dataHora = Convert.ToDateTime(reader["dataHora"].ToString()); o.categoria = reader["categoria"].ToString(); o.conta = reader["conta"].ToString(); o.valor = float.Parse(reader["valor"].ToString()); } } catch (Exception ex) { } finally { db.CloseConnection(cmd.Connection); } return(o); }
private void VisualizarExtrato(DateTime dataInicial, DateTime dataFinal) { DataTable dt = new DataTable(); Usuario u = (Usuario)Session["UsuarioLogado"]; Operacao o = new Operacao(); try { dt = o.VisualizarTudo(u.id, dataInicial, dataFinal); if (dt.Rows.Count > 0) { StringBuilder html = new StringBuilder(); html.Append("<table class='table table-sm'>"); html.Append("<thead style='background-color: #008B8B; color: white'>"); html.Append("<tr>"); html.Append("<th><center></center></th>"); html.Append("<th><center>DATA</center></th>"); html.Append("<th><center>DESCRIÇÃO</center></th>"); html.Append("<th><center>CATEGORIA</center></th>"); html.Append("<th><center>CONTA</center></th>"); html.Append("<th><center>VALOR</center></th>"); html.Append("</tr>"); html.Append("</thead>"); html.Append("<tbody>"); foreach (DataRow row in dt.Rows) { string tp = row[0].ToString(); if (tp == "receita") { html.Append("<tr class='table-success'>"); } else { html.Append("<tr class='table-danger'>"); } foreach (DataColumn coloumn in dt.Columns) { if (coloumn.ColumnName == "valor") { float x = float.Parse(row[coloumn.ColumnName].ToString()); html.Append("<td style='text-align:right; padding-right:15px'>"); html.Append(x.ToString("C2")); html.Append("</td>"); } else if (coloumn.ColumnName == "datahora") { CultureInfo cult = new CultureInfo("pt-BR"); DateTime dataFormatada = DateTime.Parse(row[coloumn.ColumnName].ToString()); string data = dataFormatada.ToString("dd/MM/yyyy", cult); html.Append("<td><center>"); html.Append(data); html.Append("</center></td>"); } else if (coloumn.ColumnName == "tipo") { if (row[coloumn.ColumnName].ToString() == "receita") { html.Append("<td class='table-success'><center>"); html.Append("<b>+</b>"); html.Append("</center></td>"); } else { html.Append("<td class='table-danger'><center>"); html.Append("<b>-</b>"); html.Append("</center></td>"); } } else { html.Append("<td><center>"); html.Append(row[coloumn.ColumnName]); html.Append("</center></td>"); } } html.Append("</tr>"); html.Append("</tbody>"); } html.Append("</table>"); tblExtrato.Text = html.ToString(); SaldoAtual(); } else { tblExtrato.Text = "<center><p>Nenhum dado a ser exibido.</p> <p>Clique em '<b>Novo</b>' para adicionar uma transação.</p></center>"; SaldoAtual(); } } catch { Session["UsuarioLogado"] = null; Response.Redirect(@"~/login.aspx"); } }
private void VisualizarReceitas(DateTime dataInicial, DateTime dataFinal) { DataTable dt = new DataTable(); Usuario u = (Usuario)Session["UsuarioLogado"]; Operacao o = new Operacao(); float totalReceitas = 0; dt = o.VisualizarReceitas(u.id, dataInicial, dataFinal); if (dt.Rows.Count > 0) { StringBuilder html = new StringBuilder(); html.Append("<table class='table table-hover'>"); html.Append("<thead style='background-color: forestgreen; color: white'>"); html.Append("<tr>"); html.Append("<th><center></center></th>"); html.Append("<th><center>Data</center></th>"); html.Append("<th><center>Descrição</center></th>"); html.Append("<th><center>Categoria</center></th>"); html.Append("<th><center>Conta</center></th>"); html.Append("<th><center>Valor</center></th>"); html.Append("</tr>"); html.Append("</thead>"); html.Append("<tbody>"); foreach (DataRow row in dt.Rows) { html.Append("<tr>"); foreach (DataColumn coloumn in dt.Columns) { if (coloumn.ColumnName == "valor") { float x = float.Parse(row[coloumn.ColumnName].ToString()); totalReceitas += x; html.Append("<td style='text-align:right; padding-right:15px'>"); html.Append(x.ToString("C2")); html.Append("</td>"); } else if (coloumn.ColumnName == "datahora") { CultureInfo cult = new CultureInfo("pt-BR"); DateTime dataFormatada = DateTime.Parse(row[coloumn.ColumnName].ToString()); string data = dataFormatada.ToString("dd/MM/yyyy", cult); html.Append("<td><center>"); html.Append(data); html.Append("</center></td>"); } else { html.Append("<td><center>"); html.Append(row[coloumn.ColumnName]); html.Append("</center></td>"); } } html.Append("</tr>"); html.Append("</tbody>"); } html.Append("</table>"); tblReceitas.Text = html.ToString(); lblTotalReceitas.Text = totalReceitas.ToString("C2"); } else { tblReceitas.Text = "<center><p>Nenhum dado a ser exibido.</p> <p>Clique em '<b>Novo</b>' para adicionar uma transação.</p></center>"; lblTotalReceitas.Text = "R$ 0,00"; } }