public void novaJustificativa(advertenciaDTO dtovar)
{
try
{
conexao = new MySqlConnection(conexao_sql);
MySqlCommand sql = new MySqlCommand("update advertencia set justificativa = @Justificativa,nometec = @Tecnico where idAdv = @IdAdv")
{
Connection = conexao
};
sql.Parameters.Add("@Justificativa", MySqlDbType.VarChar).Value = dtovar.justificativa;
sql.Parameters.Add("@Tecnico", MySqlDbType.VarChar).Value = dtovar.nomeTec;
sql.Parameters.Add("@IdAdv", MySqlDbType.Int32).Value = dtovar.idAdv;
conexao.Open();
sql.ExecuteNonQuery();
}
catch (Exception ex)
{
throw ex;
}
finally
{
conexao.Close();
}
}
public void novaAdvertencia(advertenciaDTO dtovar)
{
try
{
conexao = new MySqlConnection(conexao_sql);
MySqlCommand sql = new MySqlCommand("insert into advertencia(idprob,advertencia) values(@IdProblema,@Advertencia)")
{
Connection = conexao
};
sql.Parameters.Add("@IdProblema", MySqlDbType.Int32).Value = dtovar.idProb;
sql.Parameters.Add("@Advertencia", MySqlDbType.VarChar).Value = dtovar.advertencia;
conexao.Open();
sql.ExecuteNonQuery();
}
catch (Exception ex)
{
throw ex;
}
finally
{
conexao.Close();
}
}
public void novaJustificativa(advertenciaDTO dtovar)
{
try
{
dal.novaJustificativa(dtovar);
}
catch (Exception ex)
{
throw ex;
}
}
public List <advertenciaDTO> notificacaAdv(advertenciaDTO dtovar)
{
try
{
return(new advertenciaDAL().notificaAviso(dtovar));
}
catch (Exception erro)
{
throw erro;
}
}
public List <advertenciaDTO> carregaTudoPraJustificar()
{
try
{
conexao = new MySqlConnection(conexao_sql);
MySqlCommand comando = new MySqlCommand();
comando.CommandType = System.Data.CommandType.Text;
comando.CommandText = "SELECT * FROM problema INNER JOIN ADVERTENCIA ON ADVERTENCIA.idprob = problema.idprob";
comando.Connection = conexao;
List <advertenciaDTO> listAdvertenciaDto = new List <advertenciaDTO>();
conexao.Open();
MySqlDataReader dr = comando.ExecuteReader();
if (dr.HasRows == true)
{
while (dr.Read())
{
advertenciaDTO dtovar = new advertenciaDTO();
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.idAdv = Convert.ToInt32(dr["idAdv"]);
dtovar.justificado = Convert.ToString(dr["justificado"]);
dtovar.justificativa = Convert.ToString(dr["justificativa"]);
listAdvertenciaDto.Add(dtovar);
}
}
return(listAdvertenciaDto);
}
catch (Exception erro)
{
throw erro;
}
}
public List <advertenciaDTO> notificaAviso(advertenciaDTO dtovar)
{
try
{
conexao = new MySqlConnection(conexao_sql);
MySqlCommand comando = new MySqlCommand();
comando.CommandType = System.Data.CommandType.Text;
comando.CommandText = "SELECT COUNT(*) FROM advertencia";
comando.Connection = conexao;
List <advertenciaDTO> listAdvDto = new List <advertenciaDTO>();
conexao.Open();
MySqlDataReader dr = comando.ExecuteReader();
if (dr.HasRows == true)
{
while (dr.Read())
{
dtovar.noti = Convert.ToInt32(dr["COUNT(*)"]);
listAdvDto.Add(dtovar);
}
}
return(listAdvDto);
}
catch (Exception erro)
{
throw erro;
}
finally
{
conexao.Close();
}
}