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