public string CadastroNovoContaFiado(DadosCliente Cliente)
{
using (var connection = GetConnection())
{
connection.Open();
string rpta = "";
try
{
command.Connection = connection;
command.CommandText = "CadastroCliente";
command.CommandType = CommandType.StoredProcedure;
SqlParameter parId = new SqlParameter();
parId.ParameterName = "@id_cliente";
parId.Value = Cliente.IdCliente;
parId.SqlDbType = SqlDbType.Int;
parId.Direction = ParameterDirection.Output;
command.Parameters.Add(parId);
command.Parameters.AddWithValue("@nome", Cliente.Nome);
command.Parameters.AddWithValue("@sobre_nome", Cliente.SobreNome);
command.Parameters.AddWithValue("@cpf", Cliente.CPF);
command.Parameters.AddWithValue("@fone", Cliente.Fone);
command.Parameters.AddWithValue("@email", Cliente.Email);
command.Parameters.AddWithValue("@cep", Cliente.CEP);
command.Parameters.AddWithValue("@endereco", Cliente.Endereco);
command.Parameters.AddWithValue("@bairro", Cliente.Bairro);
command.Parameters.AddWithValue("@cidade", Cliente.Cidade);
command.Parameters.AddWithValue("@uf", Cliente.UF);
command.Parameters.AddWithValue("@observacao", Cliente.Observacao);
//
command.Parameters.AddWithValue("@id_pedido", Cliente.IdPedido);
command.Parameters.AddWithValue("@saldo_devedor", Cliente.SaldoDevedor);
rpta = command.ExecuteNonQuery() == 2 ? "OK" : "Erro ao cadastrar cliente";
}
catch (Exception ex)
{
rpta = ex.Message;
}
return(rpta);
}
}
//cadastro apenas do CPF para nota fiscal
public string CadastroCpf(DadosCliente CPF)
{
using (var connection = GetConnection())
{
connection.Open();
string rpta = "";
try
{
command.Connection = connection;
command.CommandText = "insert into tb_cliente (nome, sobre_nome, cpf, fone, email, cep, endereco, bairro, cidade, uf, observacao) values ('', '', @cpf, '', '', '', '', '', '', '', '')";
command.CommandType = CommandType.Text;
command.Parameters.AddWithValue("@cpf", CPF.CPF);
rpta = command.ExecuteNonQuery() == 1 ? "OK" : "Erro ao cadastrar CPF";
}
catch (Exception ex)
{
rpta = ex.Message;
}
return(rpta);
}
}
public bool ValidarCadastro(DadosCliente Valida)
{
using (var connection = GetConnection())
{
connection.Open();
try
{
command.Connection = connection;
command.CommandText = "SELECT * FROM tb_cliente where cpf=@cpf";
command.CommandType = CommandType.Text;
command.Parameters.AddWithValue("@cpf", Valida.CPF);
var result = command.ExecuteScalar();
if (result != null)
{
return(true);
}
}
catch (Exception ex)
{
}
return(false);
}
}
