public void verificar_pagamento()
{
bool cond = true;
for (int i = 0; i < tabela.RowCount; i++)
{
string val = tabela.Rows[i].Cells[3].Value.ToString();
if (!val.Equals("RECEBIDA"))
{
cond = false;
}
}
if (cond)
{
string sql = "update conta_receber set situacao='RECEBIDA' where id_conta_receber=" + conta.id_conta_receber;
MySqlConnection con = new MySqlConnection(Config.Conexao);
MySqlCommand cmd = new MySqlCommand(sql, con);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
if (form != null)
{
form.filtragem();
}
}
}
public void gravar()
{
if (validacao())
{
MySqlConnection con = new MySqlConnection(Config.Conexao);
string sql = "insert into parcela_receber(id_conta_receber,valor,data_vencimento,desconto,acrescimo,situacao) values(@a,@b,@c,@d,@e,@g)";
MySqlCommand cmd = new MySqlCommand(sql, con);
cmd.Parameters.AddWithValue("@a", conta.id_conta_receber);
cmd.Parameters.AddWithValue("@b", Convert.ToDecimal(txtvalor.Text));
cmd.Parameters.AddWithValue("@c", txtdata.Value);
cmd.Parameters.AddWithValue("@d", 0);
cmd.Parameters.AddWithValue("@e", 0);
cmd.Parameters.AddWithValue("@g", "ABERTA");
con.Open();
cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
string sit = "";
if (!conta.situacao.Equals("CANCELADA"))
{
sit = ", situacao='ABERTA'";
}
sql = "update conta_receber set valor_total=valor_total+" + Convert.ToDecimal(txtvalor.Text) + sit + " where id_conta_receber =" + conta.id_conta_receber;
cmd.CommandText = sql;
cmd.ExecuteNonQuery();
form.filtragem();
MessageBox.Show("Parcela adicionada com sucesso", "", MessageBoxButtons.OK, MessageBoxIcon.Information);
con.Close();
this.Close();
}
}
private void button4_Click(object sender, EventArgs e)
{
if (gerar)
{
DateTime venc = DateTime.Parse(tabela.Rows[tabela.RowCount - 1].Cells[2].Value.ToString());
MySqlConnection con = new MySqlConnection(Config.Conexao);
String query = "insert into conta_receber(data_emissao,num_dias,valor_total,num_parcelas,entrada,data_vencimento,situacao,documento,id_cliente,valor_pago) values(@a,@c,@d,@e,@f,@g,@h,@i,@j,@k)";
MySqlCommand cmd = new MySqlCommand(query, con);
decimal total = Convert.ToDecimal(txtvalortotal.Text);
con.Open();
cmd.Parameters.AddWithValue("@a", txtdataemissao.Value);
cmd.Parameters.AddWithValue("@c", Convert.ToInt32(txtnumdias.Text));
cmd.Parameters.AddWithValue("@d", total);
cmd.Parameters.AddWithValue("@e", Convert.ToInt32(txtnumparcelas.Value));
cmd.Parameters.AddWithValue("@f", entrada);
cmd.Parameters.AddWithValue("@g", venc);
if (entrada != total)
{
cmd.Parameters.AddWithValue("@h", "ABERTA");
}
else
{
cmd.Parameters.AddWithValue("@h", "RECEBIDA");
}
cmd.Parameters.AddWithValue("@i", txtdocumento.Text);
int?cli = null;
if (cliente != null)
{
cli = cliente.id_cliente;
}
cmd.Parameters.AddWithValue("@j", cli);
cmd.Parameters.AddWithValue("@k", entrada);
cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
cmd.CommandText = "select max(id_conta_receber) from conta_receber";
int id = Convert.ToInt32(cmd.ExecuteScalar().ToString());
cmd.CommandText = "insert into parcela_receber(id_conta_receber,valor,data_vencimento,desconto,acrescimo,situacao) values(@a,@b,@c,@d,@e,@g)";
for (int i = 0; i < tabela.RowCount; i++)
{
cmd.Parameters.AddWithValue("@a", id);
cmd.Parameters.AddWithValue("@b", Convert.ToDecimal(tabela.Rows[i].Cells[1].Value.ToString()));
cmd.Parameters.AddWithValue("@c", DateTime.Parse(tabela.Rows[i].Cells[2].Value.ToString()));
cmd.Parameters.AddWithValue("@d", 0);
cmd.Parameters.AddWithValue("@e", 0);
string situacao = tabela.Rows[i].Cells[tabela.ColumnCount - 1].Value.ToString();
cmd.Parameters.AddWithValue("@g", situacao);
cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
}
gerar = false;
tela.filtragem();
MessageBox.Show("Conta cadastrada com sucesso", "Atenção", MessageBoxButtons.OK, MessageBoxIcon.Information);
con.Close();
this.Close();
}
}