public IList <Consultas> BuscaPorCPF(int cpf)
{
SqlCommand comando = new SqlCommand();
comando.CommandType = System.Data.CommandType.Text;
comando.CommandText = "Select * from Consultas where CPF_P=@CPF_P";
comando.Parameters.AddWithValue("@CPF", cpf);
SqlDataReader dr = Conexao.Selecionar(comando);
IList <Consultas> consultas = new List <Consultas>();
if (dr.HasRows)
{
while (dr.Read())
{
Consultas consulta = new Model.Consultas();
consulta.id = (int)dr["ID"];
consulta.hr_inicio = (DateTime)dr["HRA_INICIO"];
consulta.hr_fim = (DateTime)dr["FIM"];
consulta.coments = (string)dr["COMENTS"];
consulta.med.crm = (int)dr["CRM_M"];
consulta.pac.cpf = (int)dr["CPF_P"];
consultas.Add(consulta);
}
}
else
{
consultas = null;
}
return(consultas);
}
public Consultas BuscarPorID(int id)
{
SqlCommand comando = new SqlCommand();
comando.CommandType = System.Data.CommandType.Text;
comando.CommandText = "Select * from Pacientes Where ID=@ID";
comando.Parameters.AddWithValue("@ID", id);
SqlDataReader dr = Conexao.Selecionar(comando);
Consultas consulta = new Model.Consultas();
if (dr.HasRows)
{
dr.Read();
consulta.id = (int)dr["ID"];
consulta.hr_inicio = (DateTime)dr["HRA_INICIO"];
consulta.hr_fim = (DateTime)dr["FIM"];
consulta.coments = (string)dr["COMENTS"];
consulta.med.crm = (int)dr["CRM_M"];
consulta.pac.cpf = (int)dr["CPF_P"];
}
else
{
consulta = null;
}
return(consulta);
}
