// METÓDO PARA ALTERAR PEÇAS public void Alterar(clsPecasDto Pecas) { try { _conexao = Conexao.ObterConexao(); _comandoSql = new SqlCommand(); _comandoSql.Connection = _conexao; _comandoSql.CommandText = "UPDATE tblmultas " + " SET marca = '" + Pecas.Marca + "', " + " valorpeca = '" + Pecas.Valor + "', " + " peca = '" + Pecas.Pecas + "', " + " pecaobs = '" + Pecas.OBS + "', " + "WHERE idpeca = " + Pecas.Peca; _comandoSql.ExecuteNonQuery(); Conexao.fecharConexao(_conexao); } catch (Exception) { throw; } }
public List <clsPecasDto> obterdados() { List <clsPecasDto> pecasDts = new List <clsPecasDto>(); _conexao = Conexao.ObterConexao(); _comandoSql = new SqlCommand(); _comandoSql.Connection = _conexao; _comandoSql.CommandText = ("select idpeca, valorpeca, marca, peca, pecaobs " + " from tblpeca "); _readersql = _comandoSql.ExecuteReader(); while (_readersql.Read()) { clsPecasDto pecaDto = new clsPecasDto(); pecaDto.Peca = Convert.ToInt32(_readersql["idpeca"].ToString()); pecaDto.Valor = Convert.ToInt32(_readersql["valorpeca"].ToString()); pecaDto.Marca = (_readersql["marca"].ToString()); pecaDto.Pecas = (_readersql["peca"].ToString()); pecaDto.OBS = (_readersql["pecaobs"].ToString()); pecasDts.Add(pecaDto); } _readersql.Close(); Conexao.fecharConexao(_conexao); return(pecasDts); }
public List <clsPecasDto> obterDados(int tipo, String filtro) { List <clsPecasDto> pecasDts = new List <clsPecasDto>(); try { _conexao = Conexao.ObterConexao(); _comandoSql = new SqlCommand(); _comandoSql.Connection = _conexao; if (tipo == 0) { _comandoSql.CommandText = ("select idpeca, valorpeca, marca, peca, pecaobs " + " from tblpeca "); } else if (tipo == 1) { _comandoSql.CommandText = ("select idpeca, valorpeca, marca, peca, pecaobs " + " from tblpeca " + " where idpeca like '%" + filtro + "%'"); } _readersql = _comandoSql.ExecuteReader(); while (_readersql.Read()) { clsPecasDto pecaDto = new clsPecasDto(); pecaDto.Peca = Convert.ToInt32(_readersql["idpeca"].ToString()); pecaDto.Valor = Convert.ToDecimal(_readersql["valorpeca"].ToString()); pecaDto.Marca = (_readersql["marca"].ToString()); pecaDto.Pecas = (_readersql["peca"].ToString()); pecaDto.OBS = (_readersql["pecaobs"].ToString()); pecasDts.Add(pecaDto); } _readersql.Close(); Conexao.fecharConexao(_conexao); return(pecasDts); } catch (Exception) { return(null); throw; } }
public void Alterar(clsPecasDto Peca) { _pecaDal = new clsPecasDal(); try { if (Peca.Marca.ToUpper() != "" || Peca.Pecas.ToUpper() != "" || Peca.Valor.ToString() != "" || Peca.OBS.ToUpper() != "") { _pecaDal.Alterar(Peca); } else { throw new Exception("PREENCHIMENTO INCORRETO"); } } catch (Exception) { throw; } }
// METÓDO PARA INSERIR PEÇAS public void Inserir(clsPecasDto pecasDto) { try { pecasDto.Peca = obterProximocodigo(); _conexao = Conexao.ObterConexao(); _comandoSql = new SqlCommand(); _comandoSql.Connection = _conexao; _comandoSql.CommandText = "INSERT INTO tblpeca (idpeca, valorpeca, marca, peca, pecaobs) " + "VALUES " + "(" + pecasDto.Peca + ",'" + pecasDto.Valor + "','" + pecasDto.Marca + "','" + pecasDto.Pecas + "','" + pecasDto.OBS + "')"; _comandoSql.ExecuteNonQuery(); Conexao.fecharConexao(_conexao); } catch (Exception) { throw; } }