public IList <Medicos> BuscaPorNome(string nome) { SqlCommand comando = new SqlCommand(); comando.CommandType = System.Data.CommandType.Text; comando.CommandText = "Select * from Medicos where NOME like @NOME"; comando.Parameters.AddWithValue("@NOME", "%" + nome + "%"); SqlDataReader dr = Conexao.Selecionar(comando); IList <Medicos> medicos = new List <Medicos>(); if (dr.HasRows) { while (dr.Read()) { Medicos medico = new Model.Medicos(); medico.nome = (string)dr["NOME"]; medico.crm = (int)dr["CPF"]; medico.espec = (string)dr["ESPEC"]; medico.coments = (string)dr["COMENTS"]; medico.senha = (string)dr["SENHA"]; medico.cli.cnpj = (int)dr["CNPJ_CLI"]; medicos.Add(medico); } } else { medicos = null; } return(medicos); }
public Medicos BuscarPorCRM(int crm) { SqlCommand comando = new SqlCommand(); comando.CommandType = System.Data.CommandType.Text; comando.CommandText = "Select * from Medicos Where CRM=@CRM"; comando.Parameters.AddWithValue("@CRM", crm); SqlDataReader dr = Conexao.Selecionar(comando); Medicos medico = new Model.Medicos(); if (dr.HasRows) { dr.Read(); medico.nome = (string)dr["NOME"]; medico.crm = (int)dr["CPF"]; medico.espec = (string)dr["ESPEC"]; medico.coments = (string)dr["COMENTS"]; medico.senha = (string)dr["SENHA"]; medico.cli.cnpj = (int)dr["CNPJ_CLI"]; } else { medico = null; } return(medico); }