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