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; }