private void OrcamentodataGridView1_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e)
{
for (int i = 0; i < OrcamentodataGridView1.RowCount; i++)
{
SCOOP.DAO.SCOOPDataSet.Orcamento_ContratadoDataTable Dt = new SCOOP.DAO.SCOOPDataSetTableAdapters.Orcamento_ContratadoTableAdapter().GetDataBy11(Convert.ToInt32(OrcamentodataGridView1.Rows[i].Cells[1].Value));
foreach (SCOOP.DAO.SCOOPDataSet.Orcamento_ContratadoRow linha in Dt)
{
OrcamentodataGridView1.Rows[i].Cells[0].Value = linha.Sequencial.ToString();
OrcamentodataGridView1.Rows[i].Cells[5].Value = new SCOOP.DAO.SCOOPDataSetTableAdapters.EmpresaTableAdapter().ObterDescricaoEmpresa(linha.Empresa);
OrcamentodataGridView1.Rows[i].Cells[6].Value = new SCOOP.DAO.SCOOPDataSetTableAdapters.LicitadoTableAdapter().ObterDescricaoLicitacao(linha.Licitado);
OrcamentodataGridView1.Rows[i].Cells[7].Value = new SCOOP.DAO.SCOOPDataSetTableAdapters.SecretariaTableAdapter().ObterDescricaoSecretaria(linha.Secretaria);
OrcamentodataGridView1.Rows[i].Cells[8].Value = linha.Empresa;
OrcamentodataGridView1.Rows[i].Cells[9].Value = linha.Licitado;
OrcamentodataGridView1.Rows[i].Cells[10].Value = linha.Secretaria;
OrcamentodataGridView1.Rows[i].Cells[11].Value = linha.CPF_CNPJ;
OrcamentodataGridView1.Rows[i].Cells[12].Value = linha.Prazo;
OrcamentodataGridView1.Rows[i].Cells[13].Value = linha.Data_Criacao;
OrcamentodataGridView1.Rows[i].Cells[14].Value = linha.Usuario;
OrcamentodataGridView1.Rows[i].Cells[15].Value = linha.Data_alteracao;
OrcamentodataGridView1.Rows[i].Cells[16].Value = linha.OrdemServico;
OrcamentodataGridView1.Rows[i].Cells[17].Value = linha.Data_final;
}
}
}
/// <summary>
/// Estornar Orçamento Contratado
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button1_Click(object sender, EventArgs e)
{
string ExisteMedicao = "";
try
{
ExisteMedicao = new SCOOP.DAO.SCOOPDataSetTableAdapters.Orcamento_ContratadoTableAdapter().VerificarSeExisteMedicaoOrcamentoContratado(OrcamentotextBox.Text).ToString();
}
catch (Exception ex)
{
ExisteMedicao = "";
}
string erro = null;
try
{
if (ExisteMedicao == "")
{
try
{
new SCOOP.DAO.SCOOPDataSetTableAdapters.ContratoTableAdapter().Delete(new SCOOP.DAO.SCOOPDataSetTableAdapters.ContratoTableAdapter().ObterCodigoContrato(OrcamentotextBox.Text));
ContratopictureBox.Image = global::SCOOP.Properties.Resources.ok;
}
catch (Exception ex)
{
ContratopictureBox.Image = global::SCOOP.Properties.Resources.errado;
erro = "Problema ao estornar o contrato!";
}
try
{
new SCOOP.DAO.SCOOPDataSetTableAdapters.Orc_Cont_ServicoTableAdapter().Delete(OrcamentotextBox.Text);
ServicopictureBox.Image = global::SCOOP.Properties.Resources.ok;
}
catch (Exception ex)
{
ServicopictureBox.Image = global::SCOOP.Properties.Resources.errado;
erro = "\nProblema ao estornar o Serviço do orçamento contratado!";
}
try
{
new SCOOP.DAO.SCOOPDataSetTableAdapters.Dotacao_Orc_ContTableAdapter().Delete(OrcamentotextBox.Text);
}
catch (Exception ex)
{
erro = "\nProblema ao estornar as dotações do orçamento contratado.";
}
try
{
new SCOOP.DAO.SCOOPDataSetTableAdapters.Orcamento_ContratadoTableAdapter().Delete((int)new SCOOP.DAO.SCOOPDataSetTableAdapters.Orcamento_ContratadoTableAdapter().ObterSequencialOrcamentoContratado((int)new SCOOP.DAO.SCOOPDataSetTableAdapters.OrcamentoTableAdapter().ObterSequencialOrcamento(OrcamentotextBox.Text)));
OrcamentoContratadopictureBox.Image = global::SCOOP.Properties.Resources.ok;
OrdemServicopictureBox.InitialImage = global::SCOOP.Properties.Resources.ok;
}
catch (Exception ex)
{
OrcamentoContratadopictureBox.Image = global::SCOOP.Properties.Resources.errado;
OrdemServicopictureBox.InitialImage = global::SCOOP.Properties.Resources.errado;
erro = "\nProblema ao estornar no orçamento contratado!";
}
}
else
{
MessageBox.Show("Deve excluir todas as medições!");
}
}
catch (Exception ex)
{
MessageBox.Show("Erro\n" + ex.Message + erro);
}
}
