public void ExcluirVisita(Visita Visita)
 {
     Connection.Open();
     SqlCommand Comando = new SqlCommand("");
     Connection.Close();
 }
 public void InserirVisita(Visita Visita)
 {
     Connection.Open();
     SqlCommand Comando = new SqlCommand("INSERT INTO VISITA VALUES ");
     Connection.Close();
 }
        public List<Visita> SelecionarTodosVisita()
        {
            List<Visita> Visitas = new List<Visita>();
            IDbCommand Comando = Connection.CreateCommand();
            Comando.CommandText = "SELECT * FROM VISITAS";
            Connection.Open();
            IDataReader leitor = Comando.ExecuteReader();

            while (leitor.Read())
            {
                Visita visita = new Visita();

                visita.Codigo = Convert.ToInt32(leitor.GetValue(0));
                visita.Comentarios = Convert.ToString(leitor.GetValue(9));

                Visitas.Add(visita);
            }
            Connection.Close();
            return Visitas;
        }
 public void InserirVisita(Visita Visita)
 {
     Banco.InserirVisita(Visita);
 }