public void Atualizar()
        {
            try
            {
                endereco.Atualizar();

                var cmd = @"UPDATE clinica SET
								id_endereco		= @id_endereco,
								razao_social	= @razao_social,
								nome_fantasia	= @nome_fantasia,
								cnpj			= @cnpj,
								ie				= @ie,
								ddd_tel			= @ddd_tel,
								telefone		= @telefone,
								ddd_cel			= @ddd_cel,
								celular			= @celular,
								email			= @email,
								logo_clinica	= @logo_clinica,
								site			= @site"                                        ;

                Conexao.AbrirConexao();
                Conexao.Cmd = new SqlCommand(cmd, Conexao.ConexaoSQL);

                Conexao.Cmd.Parameters.AddWithValue("id_endereco", endereco.id);
                Conexao.Cmd.Parameters.AddWithValue("razao_social", razaoSocial);
                Conexao.Cmd.Parameters.AddWithValue("nome_fantasia", nomeFantasia);
                Conexao.Cmd.Parameters.AddWithValue("cnpj", cnpj);
                Conexao.Cmd.Parameters.AddWithValue("ie", ie);

                Conexao.Cmd.Parameters.AddWithValue("ddd_tel", dddTel);
                Conexao.Cmd.Parameters.AddWithValue("telefone", telefone);
                Conexao.Cmd.Parameters.AddWithValue("ddd_cel", dddCel);
                Conexao.Cmd.Parameters.AddWithValue("celular", celular);
                Conexao.Cmd.Parameters.AddWithValue("email", email);
                Conexao.Cmd.Parameters.AddWithValue("site", site);

                Conexao.Cmd.Parameters.AddWithValue("logo_clinica", logo != null ? ImagemUtil.ImageParaByte(logo) : SqlBinary.Null);

                Conexao.Cmd.ExecuteNonQuery();
            }
            catch (Exception ex)
            {
                Excecao.Mostrar(ex);
            }
            finally
            {
                Conexao.FecharConexao();
            }
        }
        public void Cadastrar()
        {
            try
            {
                endereco.Cadastrar();

                var cmd = @"INSERT INTO clinica
	                               (id_endereco,
                                    razao_social,
	                                nome_fantasia,
	                                cnpj,
	                                ie,
	                                ddd_tel,
	                                telefone,
	                                ddd_cel,
	                                celular,
	                                email,
	                                logo_clinica,
	                                site)
                           OUTPUT inserted.id_clinica
                           VALUES
	                               (@id_endereco,
                                    @razao_social,
	                                @nome_fantasia,
	                                @cnpj,
	                                @ie,
	                                @ddd_tel,
	                                @telefone,
	                                @ddd_cel,
	                                @celular,
	                                @email,
	                                @logo_clinica,
	                                @site)"    ;

                Conexao.AbrirConexao();
                Conexao.Cmd = new SqlCommand(cmd, Conexao.ConexaoSQL);

                Conexao.Cmd.Parameters.AddWithValue("id_endereco", endereco.id);
                Conexao.Cmd.Parameters.AddWithValue("razao_social", razaoSocial);
                Conexao.Cmd.Parameters.AddWithValue("nome_fantasia", nomeFantasia);
                Conexao.Cmd.Parameters.AddWithValue("cnpj", cnpj);
                Conexao.Cmd.Parameters.AddWithValue("ie", ie);

                Conexao.Cmd.Parameters.AddWithValue("ddd_tel", dddTel);
                Conexao.Cmd.Parameters.AddWithValue("telefone", telefone);
                Conexao.Cmd.Parameters.AddWithValue("ddd_cel", dddCel);
                Conexao.Cmd.Parameters.AddWithValue("celular", celular);
                Conexao.Cmd.Parameters.AddWithValue("email", email);
                Conexao.Cmd.Parameters.AddWithValue("site", site);

                Conexao.Cmd.Parameters.AddWithValue("logo_clinica", logo != null ? ImagemUtil.ImageParaByte(logo) : SqlBinary.Null);

                id = (int)Conexao.Cmd.ExecuteScalar();
            }
            catch (Exception ex)
            {
                Excecao.Mostrar(ex);
            }
            finally
            {
                Conexao.FecharConexao();
            }
        }