public List <histDto> listarProf(histDto dtovar) { try { return(new histDal().carregaProf(dtovar)); } catch (Exception erro) { throw erro; } }
public List <histDto> carregaDataAtual() { try { conexao = new MySqlConnection(conexao_sql); MySqlCommand comando = new MySqlCommand(); comando.CommandType = System.Data.CommandType.Text; comando.CommandText = "SELECT * FROM historico LEFT JOIN ADVERTENCIA ON ADVERTENCIA.idprob = historico.idprob order by dataProb desc"; comando.Connection = conexao; List <histDto> listProbDto = new List <histDto>(); conexao.Open(); MySqlDataReader dr = comando.ExecuteReader(); while (dr.Read()) { histDto dtovar = new histDto(); dtovar.idProb = Convert.ToInt32(dr["idProb"]); dtovar.problema = Convert.ToString(dr["problema"]); dtovar.aula = Convert.ToString(dr["aula"]); dtovar.professor = Convert.ToString(dr["professor"]); dtovar.data = Convert.ToDateTime(dr["dataProb"]); dtovar.idMaquina = Convert.ToString(dr["idMaquina"]); dtovar.Check = Convert.ToString(dr["resolvido"]); dtovar.advertencia = Convert.ToString(dr["advertencia"]); dtovar.justificativa = Convert.ToString(dr["justificativa"]); listProbDto.Add(dtovar); } return(listProbDto); } catch (Exception erro) { throw erro; } finally { conexao.Close(); } }
public List <histDto> carregaId(histDto dtovar) { try { conexao = new MySqlConnection(conexao_sql); MySqlCommand comando = new MySqlCommand(); comando.CommandType = System.Data.CommandType.Text; comando.CommandText = "SELECT * FROM historico LEFT JOIN ADVERTENCIA ON ADVERTENCIA.idprob = historico.idprob WHERE CONCAT(idmaquina) LIKE '%" + dtovar.idMaquina + "%';"; comando.Connection = conexao; List <histDto> listProbDto = new List <histDto>(); conexao.Open(); MySqlDataReader dr = comando.ExecuteReader(); if (dr.HasRows == true) { while (dr.Read()) { dtovar.idProb = Convert.ToInt32(dr["idProb"]); dtovar.problema = Convert.ToString(dr["problema"]); dtovar.aula = Convert.ToString(dr["aula"]); dtovar.professor = Convert.ToString(dr["professor"]); dtovar.data = Convert.ToDateTime(dr["dataProb"]); dtovar.idMaquina = Convert.ToString(dr["idMaquina"]); dtovar.Check = Convert.ToString(dr["resolvido"]); dtovar.advertencia = Convert.ToString(dr["advertencia"]); dtovar.justificativa = Convert.ToString(dr["justificativa"]); listProbDto.Add(dtovar); } } return(listProbDto); } catch (Exception erro) { throw erro; } }