private void btnCadastrar_Click(object sender, EventArgs e) { Manutencao manutencao = montaManutencao(); string mensagem = new ManutencaoDAO().gravarManutencao(manutencao); MessageBox.Show(mensagem, "Info", MessageBoxButtons.OK, MessageBoxIcon.Information); this.manutencaoTableAdapter.inserirManutencao(txtDescricao.Text, mtbCpf.Text, Convert.ToDateTime(mtbDataRequisicao.Text), Convert.ToDateTime(mtbDataPrevisao.Text), cboStatus.Text, cboTipoManutencao.Text); this.manutencaoTableAdapter.Fill(this.manutencaoDataSet.Manutencao); limpaCampos(); }
private Manutencao montaManutencao() { Manutencao manutencao = new Manutencao(); manutencao.Descricao = txtDescricao.Text; manutencao.Cpf = mtbCpf.Text; manutencao.DataRequisicao = montaData(mtbDataRequisicao.Text); manutencao.PrevisaoConclusao = montaData(mtbDataPrevisao.Text); manutencao.Status = cboStatus.Text; manutencao.TipoManutencao = cboTipoManutencao.Text; return(manutencao); }
private void btnAtualizar_Click(object sender, EventArgs e) { try { string cod = txtCodManutencao.Text; Manutencao manutencao = montaManutencao(); string mensagem = new ManutencaoDAO().alterarManutencao(montaManutencao(), cod); MessageBox.Show(mensagem, "Info", MessageBoxButtons.OK, MessageBoxIcon.Information); this.manutencaoTableAdapter.editarManutencao(txtDescricao.Text, mtbCpf.Text, Convert.ToDateTime(mtbDataRequisicao.Text), Convert.ToDateTime(mtbDataPrevisao.Text), cboStatus.Text, cboTipoManutencao.Text, Convert.ToInt32(txtCodManutencao.Text)); this.manutencaoTableAdapter.Fill(this.manutencaoDataSet.Manutencao); limpaCampos(); } catch (Exception ex) { } }
}//fim cadastrar public string alterarManutencao(Manutencao manutencao, string codManutencao) { string sql; int retorno; string resp = ""; try { SqlConnection conexao = Conecta.getConexao(); sql = "UPDATE Manutencao SET descricao=@descricao, cpf=@cpf, datarequisicao=@datarequisicao, previsaoconclusao=@previsaoconclusao, status=@status, tipomanutencao=@tipomanutencao WHERE codmanutencao=@codmanutencao"; SqlCommand cmd = conexao.CreateCommand(); cmd.CommandText = sql; cmd.Parameters.AddWithValue("@descricao", manutencao.Descricao); cmd.Parameters.AddWithValue("@cpf", manutencao.Cpf); cmd.Parameters.AddWithValue("@datarequisicao", manutencao.DataRequisicao); cmd.Parameters.AddWithValue("@previsaoconclusao", manutencao.PrevisaoConclusao); cmd.Parameters.AddWithValue("@status", manutencao.Status); cmd.Parameters.AddWithValue("@tipomanutencao", manutencao.TipoManutencao); cmd.Parameters.AddWithValue("@codmanutencao", codManutencao); retorno = cmd.ExecuteNonQuery(); if (retorno > 0) { resp = "Cadastro alterado"; } else { resp = "Falha ao alterar"; } cmd.Dispose(); conexao.Dispose(); } catch (SqlException ex) { resp = "Erro" + ex.ToString(); } return(resp); }//fim alterarManutencao
public string gravarManutencao(Manutencao manutencao) { string sql; int retorno; string resp = ""; try { SqlConnection conexao = Conecta.getConexao(); sql = "INSERT INTO Manutencao (descricao, cpf, dataRequisicao, previsaoconclusao, status, tipomanutencao) VALUES (@descricao, @cpf, @dataRequisicao, @previsaoconclusao, @status, @tipomanutencao)"; SqlCommand cmd = conexao.CreateCommand(); cmd.CommandText = sql; cmd.Parameters.AddWithValue("@descricao", manutencao.Descricao); cmd.Parameters.AddWithValue("@cpf", manutencao.Cpf); cmd.Parameters.AddWithValue("@datarequisicao", manutencao.DataRequisicao); cmd.Parameters.AddWithValue("@previsaoconclusao", manutencao.PrevisaoConclusao); cmd.Parameters.AddWithValue("@status", manutencao.Status); cmd.Parameters.AddWithValue("@tipomanutencao", manutencao.TipoManutencao); retorno = cmd.ExecuteNonQuery(); if (retorno > 0) { resp = "Cadastro efetuado"; } else { resp = "Falha ao cadastrar"; } cmd.Dispose(); conexao.Dispose(); } catch (SqlException ex) { resp = "Erro" + ex.ToString(); } return(resp); }//fim cadastrar