// METÓDO PARA ALTERAR MANUTENÇÃO public void Alterar(clsAdicionarManutencaoDto Manutencao) { try { _conexao = Conexao.ObterConexao(); _comandoSql = new SqlCommand(); _comandoSql.Connection = _conexao; _comandoSql.CommandText = "UPDATE tblmanutencao " + " SET idpeca = " + Manutencao.idPeca + ", " + " placa = '" + Manutencao.Placa + "', " + " problemas = '" + Manutencao.Problemas + "', " + " datamanu = " + Manutencao.DatadeManu + ", " + " tipodemanu = " + Manutencao.TipoManutencao + ", " + "WHERE odsmanutencao = " + Manutencao.ODS; _comandoSql.ExecuteNonQuery(); Conexao.fecharConexao(_conexao); } catch (Exception) { throw; } }
public List <clsAdicionarManutencaoDto> obterdadosCombo() { List <clsAdicionarManutencaoDto> manuntencaoDts = new List <clsAdicionarManutencaoDto>(); _conexao = Conexao.ObterConexao(); _comandoSql = new SqlCommand(); _comandoSql.Connection = _conexao; _comandoSql.CommandText = ("select odsmanutencao, idpeca, placa, problemas, datamanu, tipodemanu " + " from tblmanutencao "); _readersql = _comandoSql.ExecuteReader(); while (_readersql.Read()) { clsAdicionarManutencaoDto manutencaoDto = new clsAdicionarManutencaoDto(); manutencaoDto.ODS = Convert.ToInt32(_readersql["odsmanutencao"].ToString()); manutencaoDto.idPeca = Convert.ToInt32(_readersql["idpeca"].ToString()); manutencaoDto.Placa = (_readersql["placa"].ToString()); manutencaoDto.Problemas = (_readersql["problemas"].ToString()); manutencaoDto.DatadeManu = Convert.ToDateTime(_readersql["datamanu"].ToString()); manutencaoDto.TipoManutencao = (_readersql["tipodemanu"].ToString()); manuntencaoDts.Add(manutencaoDto); } _readersql.Close(); Conexao.fecharConexao(_conexao); return(manuntencaoDts); }
public Adcionar_Manutenção() { InitializeComponent(); /* Instanciação dos * objetos privados */ _manutencaoDto = new clsAdicionarManutencaoDto(); _manutencaoBll = new clsAdicionarManutencaBll(); }
public List <clsAdicionarManutencaoDto> obterDados(int tipo, String filtro) { List <clsAdicionarManutencaoDto> manuntencaoDts = new List <clsAdicionarManutencaoDto>(); try { _conexao = Conexao.ObterConexao(); _comandoSql = new SqlCommand(); _comandoSql.Connection = _conexao; if (tipo == 0) { _comandoSql.CommandText = ("select odsmanutencao, idpeca, placa, problemas, datamanu, tipodemanu " + " from tblmanutencao "); } else if (tipo == 1) { _comandoSql.CommandText = ("select odsmanutencao, idpeca, placa, problemas, datamanu, tipodemanu " + " from tblmanutencao " + " where odsmanutencao like '%" + filtro + "%'"); } _readersql = _comandoSql.ExecuteReader(); while (_readersql.Read()) { clsAdicionarManutencaoDto manutencaoDto = new clsAdicionarManutencaoDto(); manutencaoDto.ODS = Convert.ToInt32(_readersql["odsmanutencao"].ToString()); manutencaoDto.idPeca = Convert.ToInt32(_readersql["idpeca"].ToString()); manutencaoDto.Placa = (_readersql["placa"].ToString()); manutencaoDto.Problemas = (_readersql["problemas"].ToString()); manutencaoDto.DatadeManu = Convert.ToDateTime(_readersql["datamanu"].ToString()); manutencaoDto.TipoManutencao = (_readersql["tipodemanu"].ToString()); manuntencaoDts.Add(manutencaoDto); } _readersql.Close(); Conexao.fecharConexao(_conexao); return(manuntencaoDts); } catch (Exception) { return(null); throw; } }
public void Alterar(clsAdicionarManutencaoDto Manutencao) { _manutencaoDal = new clsAdicionarManutencaoDal(); try { if (Manutencao.idPeca.ToString() != "" || Manutencao.Placa.ToString() != "" || Manutencao.Problemas.ToUpper() != "" || Manutencao.DatadeManu.ToString() != "" || Manutencao.TipoManutencao.ToUpper() != "") { _manutencaoDal.Alterar(Manutencao); } else { throw new Exception("PREENCHIMENTO INCORRETO"); } } catch (Exception) { throw; } }
// METÓDO PARA INSERIR MANUTENÇÃO public void Inserir(clsAdicionarManutencaoDto manutencaoDto) { try { manutencaoDto.ODS = obterProximocodigo(); _conexao = Conexao.ObterConexao(); _comandoSql = new SqlCommand(); _comandoSql.Connection = _conexao; _comandoSql.CommandText = "INSERT INTO tblmanutencao (odsmanutencao, idpeca, placa, problemas, datamanu, tipodemanu) " + "VALUES " + "(" + manutencaoDto.ODS + "," + manutencaoDto.idPeca + ",'" + manutencaoDto.Placa + "','" + manutencaoDto.Problemas + "','" + manutencaoDto.DatadeManu + "','" + manutencaoDto.TipoManutencao + "')"; _comandoSql.ExecuteNonQuery(); Conexao.fecharConexao(_conexao); } catch (Exception) { throw; } }