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);
}