public Hospital Buscar(Guid Id)
{
Hospital hospital = null;
using (SqlConnection con = new SqlConnection(connectionString))
{
string sqlQuery = "SELECT * FROM Hospital WHERE Id= " + "@Id";
SqlCommand cmd = new SqlCommand(sqlQuery, con);
cmd.Parameters.AddWithValue("@Id", Id);
con.Open();
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
hospital = new Hospital();
hospital.Id = new Guid(rdr["Id"].ToString());
hospital.Nome = rdr["Nome"].ToString();
hospital.Email = rdr["Email"].ToString();
hospital.Endereco = rdr["Endereco"].ToString();
hospital.Contato = rdr["Contato"].ToString();
}
if (hospital != null)
{
Repositorio.Repositorios.MarcacaoRepositorio repMarcacao = new MarcacaoRepositorio();
hospital.Marcacoes = repMarcacao.ListarPorHospital(hospital.Id);
}
}
return(hospital);
}
public Paciente Buscar(Guid Id)
{
Paciente paciente = null;
using (SqlConnection con = new SqlConnection(connectionString))
{
string sqlQuery = "SELECT * FROM Paciente WHERE Id= " + "@Id";
SqlCommand cmd = new SqlCommand(sqlQuery, con);
cmd.Parameters.AddWithValue("@Id", Id);
con.Open();
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
paciente = new Paciente();
paciente.Id = new Guid(rdr["Id"].ToString());
paciente.Nome = rdr["Nome"].ToString();
paciente.SobreNome = rdr["SobreNome"].ToString();
paciente.Password = rdr["Password"].ToString();
paciente.Email = rdr["Email"].ToString();
paciente.EhAdministrador = Convert.ToBoolean(rdr["EhAdministrador"].ToString());
paciente.Contato = rdr["Contato"].ToString();
}
if (paciente != null)
{
Repositorio.Repositorios.MarcacaoRepositorio repMarcacao = new MarcacaoRepositorio();
paciente.Marcacoes = repMarcacao.ListarPorPaciente(paciente.Id);
}
}
return(paciente);
}
