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