public void alterar()
{
if (tabela.SelectedRows.Count == 1)
{
Cliente cli = new Cliente();
Endereco end = new Endereco();
cli.id_cliente = Convert.ToInt32(tabela.CurrentRow.Cells[0].Value.ToString());
end.id_endereco = Convert.ToInt32(tabela.CurrentRow.Cells[1].Value.ToString());
cli.nome = tabela.CurrentRow.Cells[2].Value.ToString();
cli.cpf = tabela.CurrentRow.Cells[3].Value.ToString();
cli.rg = tabela.CurrentRow.Cells[4].Value.ToString();
string data = tabela.CurrentRow.Cells[5].Value.ToString();
cli.data = DateTime.Parse(data);
cli.genero = tabela.CurrentRow.Cells[6].Value.ToString();
cli.email = tabela.CurrentRow.Cells[7].Value.ToString();
cli.telefone = tabela.CurrentRow.Cells[8].Value.ToString();
cli.celular = tabela.CurrentRow.Cells[9].Value.ToString();
end.rua = tabela.CurrentRow.Cells[10].Value.ToString();
end.bairro = tabela.CurrentRow.Cells[11].Value.ToString();
end.numero = Convert.ToInt32(tabela.CurrentRow.Cells[12].Value.ToString());
end.cidade = tabela.CurrentRow.Cells[13].Value.ToString();
end.complemento = tabela.CurrentRow.Cells[14].Value.ToString();
end.cep = tabela.CurrentRow.Cells[15].Value.ToString();
end.uf = tabela.CurrentRow.Cells[16].Value.ToString();
cli.endereco = end;
FrmCadClienteConstrucao cad = new FrmCadClienteConstrucao(this, cli);
cad.Show();
}
}
public FrmCadClienteConstrucao(FrmConsultaClienteConstrucao consulta, Cliente cliente)
{
InitializeComponent();
init(consulta);
this.cliente = cliente;
txtcpf.Enabled = false;
txtnome.Enabled = false;
PreencherCampos();
}
public List<ParcelaReceber> geraLista()
{
string data_atual = GeraDataMysql.Gerar(DateTime.Now);
string query = "select * from parcela_receber as p inner join conta_receber as c on p.id_conta_receber = c.id_conta_receber inner join cliente as f on f.id_cliente = c.id_cliente ";
query += "inner join pessoa_fisica as j on f.id_pessoa_fisica = j.id_pessoa_fisica ";
query += "where p.data_vencimento <='" + data_atual + "' and c.status=1 and p.situacao='ABERTA'";
MySqlConnection con = new MySqlConnection(Config.Conexao);
MySqlCommand cmd = new MySqlCommand(query, con);
con.Open();
MySqlDataReader reader = cmd.ExecuteReader();
List<ParcelaReceber> lista = new List<ParcelaReceber>();
while (reader.Read())
{
ContaReceber c = new ContaReceber();
ParcelaReceber p = new ParcelaReceber();
Cliente cli = new Cliente();
cli.nome = reader["nome"].ToString();
c.data_vencimento = DateTime.Parse(reader["data_vencimento"].ToString());
c.valor_total = Convert.ToDecimal(reader["valor_total"].ToString());
c.valor_pago = Convert.ToDecimal(reader["valor_pago"].ToString());
c.situacao = "ABERTA";
c.id_conta_receber = Convert.ToInt32(reader["id_conta_receber"].ToString());
c.data_emissao = DateTime.Parse(reader["data_emissao"].ToString());
c.documento = reader["documento"].ToString();
c.entrada = Convert.ToDecimal(reader["entrada"].ToString());
p.valor = Convert.ToDecimal(reader["valor"].ToString());
p.data_vencimento = DateTime.Parse(reader["data_vencimento"].ToString());
p.conta_receber = c;
c.cliente = cli;
lista.Add(p);
}
con.Close();
return lista;
}
public static bool verifica_Contas_receber_atrazadas(FrmPrincipal principal)
{
string data_atual = GeraDataMysql.Gerar(DateTime.Now);
string query = "select * from parcela_receber as p inner join conta_receber as c on p.id_conta_receber = c.id_conta_receber inner join cliente as f on f.id_cliente = c.id_cliente ";
query += "inner join pessoa_fisica as j on f.id_pessoa_fisica = j.id_pessoa_fisica ";
query += "where p.data_vencimento <='" + data_atual + "' and c.status=1 and p.situacao='ABERTA'";
MySqlConnection con = new MySqlConnection(Config.Conexao);
MySqlCommand cmd = new MySqlCommand(query, con);
con.Open();
MySqlDataReader reader = cmd.ExecuteReader();
if (!reader.HasRows)
{
con.Close();
return false;
}
else
{
List<ParcelaReceber> lista = new List<ParcelaReceber>();
while (reader.Read())
{
ContaReceber c = new ContaReceber();
ParcelaReceber p = new ParcelaReceber();
Cliente cli = new Cliente();
cli.nome = reader["nome"].ToString();
c.data_vencimento = DateTime.Parse(reader["data_vencimento"].ToString());
c.valor_total = Convert.ToDecimal(reader["valor_total"].ToString());
c.valor_pago = Convert.ToDecimal(reader["valor_pago"].ToString());
c.situacao = "ABERTA";
c.id_conta_receber = Convert.ToInt32(reader["id_conta_receber"].ToString());
c.data_emissao = DateTime.Parse(reader["data_emissao"].ToString());
c.documento = reader["documento"].ToString();
c.entrada = Convert.ToDecimal(reader["entrada"].ToString());
p.valor = Convert.ToDecimal(reader["valor"].ToString());
p.data_vencimento = DateTime.Parse(reader["data_vencimento"].ToString());
p.conta_receber = c;
c.cliente = cli;
lista.Add(p);
}
con.Close();
FrmContasReceberAtrazadas frm = new FrmContasReceberAtrazadas(lista);
frm.MdiParent = principal;
frm.Activate();
frm.Show();
return true;
}
}
public Cliente retorna_cliente()
{
Cliente cli = new Cliente();
Endereco end = new Endereco();
cli.id_cliente = Convert.ToInt32(tabela.CurrentRow.Cells[0].Value.ToString());
end.id_endereco = Convert.ToInt32(tabela.CurrentRow.Cells[1].Value.ToString());
cli.nome = tabela.CurrentRow.Cells[2].Value.ToString();
cli.cpf = tabela.CurrentRow.Cells[3].Value.ToString();
cli.rg = tabela.CurrentRow.Cells[4].Value.ToString();
string data = tabela.CurrentRow.Cells[5].Value.ToString();
cli.data = DateTime.Parse(data);
cli.genero = tabela.CurrentRow.Cells[6].Value.ToString();
cli.email = tabela.CurrentRow.Cells[7].Value.ToString();
cli.telefone = tabela.CurrentRow.Cells[8].Value.ToString();
cli.celular = tabela.CurrentRow.Cells[9].Value.ToString();
end.rua = tabela.CurrentRow.Cells[10].Value.ToString();
end.bairro = tabela.CurrentRow.Cells[11].Value.ToString();
end.numero = Convert.ToInt32(tabela.CurrentRow.Cells[12].Value.ToString());
end.cidade = tabela.CurrentRow.Cells[13].Value.ToString();
end.complemento = tabela.CurrentRow.Cells[14].Value.ToString();
end.cep = tabela.CurrentRow.Cells[15].Value.ToString();
end.uf = tabela.CurrentRow.Cells[16].Value.ToString();
cli.endereco = end;
return cli;
}
public void seleciona_cliente(Cliente cli)
{
cliente = cli;
txtCliente.Text = cli.nome;
}
private void button2_Click(object sender, EventArgs e)
{
txtCliente.Text = "Nenhum";
cliente = null;
}
private void button2_Click(object sender, EventArgs e)
{
cliente = null;
txtCliente.Text = "";
}
public ContaReceber GerarConta()
{
ContaReceber c = new ContaReceber();
int id = Convert.ToInt32(tabela.CurrentRow.Cells[0].Value.ToString());
MySqlConnection con = new MySqlConnection(Config.Conexao);
string query = "select * from conta_receber where id_conta_receber ="+id;
MySqlCommand cmd = new MySqlCommand(query, con);
con.Open();
MySqlDataReader reader = cmd.ExecuteReader();
reader.Read();
c.id_conta_receber = id;
c.numDias = Convert.ToInt32(reader["num_dias"].ToString());
c.valor_total = Convert.ToDecimal(reader["valor_total"].ToString());
c.numParcelas = c.numDias = Convert.ToInt32(reader["num_parcelas"].ToString());
c.situacao = reader["situacao"].ToString();
c.valor_pago = Convert.ToDecimal(reader["valor_pago"].ToString());
c.data_emissao = DateTime.Parse(reader["data_emissao"].ToString());
c.data_vencimento = DateTime.Parse(reader["data_vencimento"].ToString());
c.entrada = Convert.ToDecimal(reader["entrada"].ToString());
string id_cli=reader["id_cliente"].ToString();
reader.Close();
if(id_cli.Length!=0){
query = "select * from cliente as f inner join pessoa_fisica as p on f.id_pessoa_fisica =p.id_pessoa_fisica where f.id_cliente=" + id_cli;
cmd.CommandText = query;
reader = cmd.ExecuteReader();
while (reader.Read())
{
Cliente f = new Cliente();
f.celular = reader["p.celular"].ToString();
f.cpf = reader["p.cpf"].ToString();
f.email = reader["p.email"].ToString();
f.nome = reader["p.nome"].ToString();
f.telefone = f.celular = reader["p.telefone"].ToString();
f.rg = f.celular = reader["p.rg"].ToString();
c.cliente = f;
}
}
else
c.cliente=null;
con.Close();
return c;
}