public List <Veterinario> GetAllVeterinariosByPetTipo(int pet_tipo_id) { List <Veterinario> veterinarios_list = new List <Veterinario>(); FuncionarioBusiness funcionario_business = new FuncionarioBusiness(); VeterinarioPetTipoBusiness veterinario_pet_tipo_business = new VeterinarioPetTipoBusiness(); try { this.connection.Open(); this.command.CommandText = string.Format(@"SELECT v.id, v.id_funcionario, v.nome, v.cpf, v.identidade, v.registro, v.ultima_alteracao, v.responsavel FROM veterinario v inner join veterinario_pet_tipo vpt on vpt.id_veterinario = v.id WHERE vpt.id_pet_tipo = '{0}' ORDER BY v.nome", pet_tipo_id); MySqlDataReader reader = command.ExecuteReader(); while (reader.Read())//Enquanto existir dados no select { Veterinario veterinario = new Veterinario(); veterinario.id = (reader["id"].ToString() != null && reader["id"].ToString() != string.Empty) ? Int32.Parse(reader["id"].ToString()) : 0; veterinario.id_funcionario = (reader["id_funcionario"].ToString() != null && reader["id_funcionario"].ToString() != string.Empty) ? Int32.Parse(reader["id_funcionario"].ToString()) : 0; veterinario.nome = (reader["nome"].ToString() != null && reader["nome"].ToString() != string.Empty) ? reader["nome"].ToString() : ""; veterinario.cpf = (reader["cpf"].ToString() != null && reader["cpf"].ToString() != string.Empty) ? reader["cpf"].ToString() : ""; veterinario.identidade = (reader["identidade"].ToString() != null && reader["identidade"].ToString() != string.Empty) ? reader["identidade"].ToString() : ""; veterinario.registro = (reader["registro"].ToString() != null && reader["registro"].ToString() != string.Empty) ? reader["registro"].ToString() : ""; veterinario.ultima_alteracao = (reader["ultima_alteracao"].ToString() != null && reader["ultima_alteracao"].ToString() != string.Empty) ? DateTime.Parse(reader["ultima_alteracao"].ToString()) : new DateTime(); veterinario.responsavel = (reader["responsavel"].ToString() != null && reader["responsavel"].ToString() != string.Empty) ? reader["responsavel"].ToString() : ""; veterinario.veterinario_pet_tipo_list = veterinario_pet_tipo_business.GetVeterinarioPetTipo(veterinario.id); veterinario.funcionario = funcionario_business.GetFuncionario(veterinario.id_funcionario); veterinarios_list.Add(veterinario); } this.connection.Close(); } catch (Exception ex) { if (this.connection.State == System.Data.ConnectionState.Open) { this.connection.Close(); } } return(veterinarios_list); }
public Veterinario GetVeterinario(int veterinario_id) { Veterinario veterinario = new Veterinario(); FuncionarioBusiness funcionario_business = new FuncionarioBusiness(); VeterinarioPetTipoBusiness veterinario_pet_tipo_business = new VeterinarioPetTipoBusiness(); try { this.connection.Open(); this.command.CommandText = string.Format(@"SELECT id, id_funcionario, nome, cpf, identidade, registro, ultima_alteracao, responsavel FROM veterinario WHERE id = '{0}'", veterinario_id); MySqlDataReader reader = command.ExecuteReader(); while (reader.Read())//Enquanto existir dados no select { veterinario.id = (reader["id"].ToString() != null && reader["id"].ToString() != string.Empty) ? Int32.Parse(reader["id"].ToString()) : 0; veterinario.id_funcionario = (reader["id_funcionario"].ToString() != null && reader["id_funcionario"].ToString() != string.Empty) ? Int32.Parse(reader["id_funcionario"].ToString()) : 0; veterinario.nome = (reader["nome"].ToString() != null && reader["nome"].ToString() != string.Empty) ? reader["nome"].ToString() : ""; veterinario.cpf = (reader["cpf"].ToString() != null && reader["cpf"].ToString() != string.Empty) ? reader["cpf"].ToString() : ""; veterinario.identidade = (reader["identidade"].ToString() != null && reader["identidade"].ToString() != string.Empty) ? reader["identidade"].ToString() : ""; veterinario.registro = (reader["endereco"].ToString() != null && reader["endereco"].ToString() != string.Empty) ? reader["endereco"].ToString() : ""; veterinario.ultima_alteracao = (reader["ultima_alteracao"].ToString() != null && reader["ultima_alteracao"].ToString() != string.Empty) ? DateTime.Parse(reader["ultima_alteracao"].ToString()) : new DateTime(); veterinario.responsavel = (reader["responsavel"].ToString() != null && reader["responsavel"].ToString() != string.Empty) ? reader["responsavel"].ToString() : ""; veterinario.veterinario_pet_tipo_list = veterinario_pet_tipo_business.GetVeterinarioPetTipo(veterinario.id); veterinario.funcionario = funcionario_business.GetFuncionario(veterinario.id_funcionario); } this.connection.Close(); } catch (Exception ex) { if (this.connection.State == System.Data.ConnectionState.Open) { this.connection.Close(); } } return(veterinario); }