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