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 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 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; }
private void Gravar() { try { using (Banco banco = new Banco()) { banco.BeginTransaction(); banco.AddParameter("UserName", System.Web.HttpContext.Current.User.Identity.Name); banco.ExecuteNonQuery("DELETE FROM senador_usuario WHERE UserName = @UserName"); foreach (GridViewRow row in GridView.Rows) { if (row.RowType == DataControlRowType.DataRow) { CheckBox chkRow = (row.Cells[0].FindControl("CheckBoxSelecionar") as CheckBox); if (chkRow.Checked && chkRow.Enabled == true) { try { banco.AddParameter("UserName", System.Web.HttpContext.Current.User.Identity.Name); banco.AddParameter("CodigoParlamentar", row.Cells[3].Text); banco.ExecuteNonQuery("INSERT INTO senador_usuario (UserName, CodigoParlamentar) VALUES (@UserName, @CodigoParlamentar)"); } catch (Exception ex) { } } } } banco.CommitTransaction(); } } catch (Exception ex) { } }