public IList <Clinicas> BuscaPorNome(string nome) { SqlCommand comando = new SqlCommand(); comando.CommandType = System.Data.CommandType.Text; comando.CommandText = "Select * from Clinicas where NOME like @NOME"; comando.Parameters.AddWithValue("@NOME", "%" + nome + "%"); SqlDataReader dr = Conexao.Selecionar(comando); IList <Clinicas> clinicas = new List <Clinicas>(); if (dr.HasRows) { while (dr.Read()) { Clinicas clinica = new Model.Clinicas(); clinica.nome = (string)dr["NOME"]; clinica.cnpj = (int)dr["CNPJ"]; } } else { clinicas = null; } return(clinicas); }
public Clinicas BuscarPorCNPJ(int cnpj) { SqlCommand comando = new SqlCommand(); comando.CommandType = System.Data.CommandType.Text; comando.CommandText = "Select * from Clinicas Where CNPJ=@CNPJ"; comando.Parameters.AddWithValue("@CNPJ", cnpj); SqlDataReader dr = Conexao.Selecionar(comando); Clinicas clinicas = new Model.Clinicas(); if (dr.HasRows) { dr.Read(); clinicas.nome = (string)dr["NOME"]; clinicas.cnpj = (int)dr["CNPJ"]; } else { clinicas = null; } return(clinicas); }