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)
{
}
}
