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";
}
}
