public Boolean Atualiza(GridView grid)
{
using (Banco banco = new Banco())
{
try
{
banco.BeginTransaction();
banco.AddParameter("IdDossie", IdDossie);
banco.AddParameter("NomeDossie", NomeDossie);
banco.ExecuteNonQuery("UPDATE dossies SET NomeDossie = @NomeDossie WHERE IdDossie = @IdDossie");
banco.AddParameter("IdDossie", IdDossie);
banco.ExecuteNonQuery("DELETE FROM dossies_parlamentar WHERE IdDossie = @IdDossie");
InsereParlamenteres(banco, grid);
banco.CommitTransaction();
}
catch (Exception ex)
{
banco.RollBackTransaction();
return false;
}
}
return true;
}
public Boolean Insere(GridView grid)
{
using (Banco banco = new Banco())
{
try
{
banco.BeginTransaction();
banco.AddParameter("NomeDossie", NomeDossie);
banco.ExecuteNonQuery("INSERT INTO dossies (NomeDossie) VALUES (@NomeDossie)");
IdDossie = banco.LastInsertedId;
InsereParlamenteres(banco, grid);
banco.CommitTransaction();
}
catch (Exception ex)
{
banco.RollBackTransaction();
return false;
}
}
return true;
}
public Boolean Excluir()
{
using (Banco banco = new Banco())
{
try
{
banco.BeginTransaction();
banco.AddParameter("IdDossie", IdDossie);
banco.ExecuteNonQuery("DELETE FROM dossies WHERE IdDossie = @IdDossie");
banco.AddParameter("IdDossie", IdDossie);
banco.ExecuteNonQuery("DELETE FROM dossies_parlamentar WHERE IdDossie = @IdDossie");
banco.CommitTransaction();
}
catch (Exception ex)
{
banco.RollBackTransaction();
return(false);
}
}
return(true);
}
public Boolean Atualiza(GridView grid)
{
using (Banco banco = new Banco())
{
try
{
banco.BeginTransaction();
banco.AddParameter("IdDossie", IdDossie);
banco.AddParameter("NomeDossie", NomeDossie);
banco.ExecuteNonQuery("UPDATE dossies SET NomeDossie = @NomeDossie WHERE IdDossie = @IdDossie");
banco.AddParameter("IdDossie", IdDossie);
banco.ExecuteNonQuery("DELETE FROM dossies_parlamentar WHERE IdDossie = @IdDossie");
InsereParlamenteres(banco, grid);
banco.CommitTransaction();
}
catch (Exception ex)
{
banco.RollBackTransaction();
return(false);
}
}
return(true);
}
public Boolean Insere(GridView grid)
{
using (Banco banco = new Banco())
{
try
{
banco.BeginTransaction();
banco.AddParameter("NomeDossie", NomeDossie);
banco.ExecuteNonQuery("INSERT INTO dossies (NomeDossie) VALUES (@NomeDossie)");
IdDossie = banco.LastInsertedId;
InsereParlamenteres(banco, grid);
banco.CommitTransaction();
}
catch (Exception ex)
{
banco.RollBackTransaction();
return(false);
}
}
return(true);
}
public Boolean EfetivaDados()
{
using (Banco banco = new Banco())
{
try
{
banco.BeginTransaction();
CarregaDadosProcessa(banco);
NormalizaTabelas(banco);
banco.CommitTransaction();
}
catch (Exception ex)
{
banco.RollBackTransaction();
MsgErro = ex.Message;
return false;
}
}
return true;
}
public Boolean EfetivaDados()
{
using (Banco banco = new Banco())
{
try
{
banco.BeginTransaction();
CarregaDadosProcessa(banco);
NormalizaTabelas(banco);
banco.CommitTransaction();
}
catch (Exception ex)
{
banco.RollBackTransaction();
MsgErro = ex.Message;
return(false);
}
}
return(true);
}
public Boolean Excluir()
{
using (Banco banco = new Banco())
{
try
{
banco.BeginTransaction();
banco.AddParameter("IdDossie", IdDossie);
banco.ExecuteNonQuery("DELETE FROM dossies WHERE IdDossie = @IdDossie");
banco.AddParameter("IdDossie", IdDossie);
banco.ExecuteNonQuery("DELETE FROM dossies_parlamentar WHERE IdDossie = @IdDossie");
banco.CommitTransaction();
}
catch (Exception ex)
{
banco.RollBackTransaction();
return false;
}
}
return true;
}
