public void Create(Padaria padaria) { SqlCommand cmd = new SqlCommand(); cmd.Connection = connection; cmd.CommandText = @"INSERT INTO padaria VALUES(@Nome, @Endereco)"; cmd.Parameters.AddWithValue("@Nome", padaria.Nome); cmd.Parameters.AddWithValue("@Endereco", padaria.Endereco); cmd.ExecuteNonQuery(); }
public String ExisteNome(String nome) { Padaria p = new Padaria(); SqlCommand cmd = new SqlCommand(); cmd.Connection = connection; cmd.CommandText = @"SELECT * FROM Padaria WHERE (Nome = @nome)"; cmd.Parameters.AddWithValue("@nome", nome); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { p.IdPadaria = (int)reader["IdPadaria"]; p.Nome = (string)reader["Nome"]; p.Endereco = (string)reader["Endereco"]; } reader.Close(); return(p.Nome); }
public List <Padaria> Read() { List <Padaria> lista = new List <Padaria>(); SqlCommand cmd = new SqlCommand(); cmd.Connection = connection; cmd.CommandText = @"SELECT * FROM padaria"; SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Padaria p = new Padaria(); p.IdPadaria = (int)reader["IdPadaria"]; p.Nome = (string)reader["Nome"]; p.Endereco = (string)reader["Endereco"]; lista.Add(p); } return(lista); }