public void alteraSituacao(probDto dtoVar) { MySqlConnection conexaoPro = new MySqlConnection(); try { conexaoPro = new MySqlConnection(conexao_sql); MySqlCommand sql = new MySqlCommand("alterar") { Connection = conexaoPro }; sql.CommandType = System.Data.CommandType.StoredProcedure; sql.Parameters.Add("@Vresolvido", MySqlDbType.VarChar).Value = dtoVar.Check; sql.Parameters.Add("@id", MySqlDbType.Int32).Value = dtoVar.idProb; conexaoPro.Open(); sql.ExecuteNonQuery(); } catch (Exception ex) { throw ex; } finally { conexaoPro.Close(); } }
public void cadProd(probDto dto) { MySqlConnection conexaoPro = new MySqlConnection(); try { MySqlCommand comand = new MySqlCommand("inserir"); conexaoPro.ConnectionString = conexao_sql; comand.CommandType = System.Data.CommandType.StoredProcedure; comand.Connection = conexaoPro; conexaoPro.Open(); comand.Parameters.Add("@Aaula", MySqlDbType.VarChar).Value = dto.aula; comand.Parameters.Add("@Aprofessor", MySqlDbType.VarChar).Value = dto.professor; comand.Parameters.Add("@AidMaquina", MySqlDbType.VarChar).Value = dto.idMaquina; comand.Parameters.Add("@Aproblema", MySqlDbType.VarChar).Value = dto.problema; comand.Parameters.Add("@AdataProb", MySqlDbType.DateTime).Value = System.DateTime.Now; comand.ExecuteNonQuery(); } catch (Exception ex) { throw ex; } finally { conexaoPro.Close(); } }
public void deletaProb(probDto dto) { try { dal.deletaProb(dto); } catch (Exception erro) { throw erro; } }
public void alteraProblema(probDto dtovar) { try { dal.alteraProb(dtovar); } catch (Exception erro) { throw erro; } }
public List <probDto> notificacao(probDto dtovar) { try { return(new ProblemaDal().notificaProb(dtovar)); } catch (Exception erro) { throw erro; } }
public void alteraSituacao(probDto dtoVar) { try { dal.alteraSituacao(dtoVar); } catch (Exception erro) { throw erro; } }
public void novoProb(probDto dto) { try { dal.cadProd(dto); } catch (Exception ex) { throw ex; } }
public void deletaProb(probDto dto) { try { conexao = new MySqlConnection(conexao_sql); MySqlCommand sql = new MySqlCommand("delete from problema where idProb = @id") { Connection = conexao }; sql.Parameters.Add("@id", MySqlDbType.Int32).Value = dto.idProb; conexao.Open(); sql.ExecuteNonQuery(); } catch (Exception erro) { throw erro; } }
public List <probDto> carregaTec() { try { conexao = new MySqlConnection(conexao_sql); MySqlCommand comando = new MySqlCommand(); comando.CommandType = System.Data.CommandType.Text; comando.CommandText = "select * from problema"; comando.Connection = conexao; List <probDto> listProbDto = new List <probDto>(); conexao.Open(); MySqlDataReader dr = comando.ExecuteReader(); if (dr.HasRows == true) { while (dr.Read()) { probDto dtovar = new probDto(); 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"]); listProbDto.Add(dtovar); } } return(listProbDto); } catch (Exception erro) { throw erro; } finally { conexao.Close(); } }
public void alteraProb(probDto dtovar) { try { conexao = new MySqlConnection(conexao_sql); MySqlCommand sql = new MySqlCommand("update problema set idMaquina = @idM,problema = @prob where idProb = @id") { Connection = conexao }; sql.Parameters.Add("@idM", MySqlDbType.VarChar).Value = dtovar.idMaquina; sql.Parameters.Add("@id", MySqlDbType.Int32).Value = dtovar.idProb; sql.Parameters.Add("@prob", MySqlDbType.VarChar).Value = dtovar.problema; conexao.Open(); sql.ExecuteNonQuery(); } catch (Exception erro) { throw erro; } }
public List <probDto> notificaProb(probDto dtovar) { try { conexao = new MySqlConnection(conexao_sql); MySqlCommand comando = new MySqlCommand(); comando.CommandType = System.Data.CommandType.Text; comando.CommandText = "SELECT COUNT(*) FROM problema"; comando.Connection = conexao; List <probDto> listProbDto = new List <probDto>(); conexao.Open(); MySqlDataReader dr = comando.ExecuteReader(); if (dr.HasRows == true) { while (dr.Read()) { dtovar.noti = Convert.ToInt32(dr["COUNT(*)"]); listProbDto.Add(dtovar); } } return(listProbDto); } catch (Exception erro) { throw erro; } finally { conexao.Close(); } }