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