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