private static IMPRGRIDEntity FillEntityObject(ref FbDataReader DataReader)
{
IMPRGRIDEntity entity = new IMPRGRIDEntity();
FirebirdGetDbData getData = new FirebirdGetDbData();
entity.IDIMPRGRID = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDIMPRGRID"));
entity.NOMETELA = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOMETELA"));
entity.NOMEGRID = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOMEGRID"));
entity.CAMPOSSELECIONADOS = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("CAMPOSSELECIONADOS"));
entity.FLAGAJUSTA = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("FLAGAJUSTA"));
entity.FLAGMODOPAISAGEM = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("FLAGMODOPAISAGEM"));
entity.FLAGEXIBIRDATA = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("FLAGEXIBIRDATA"));
entity.IDFUNCIONARIO = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDFUNCIONARIO"));
return(entity);
}
public IMPRGRIDEntity Read(int IDIMPRGRID)
{
FbDataReader reader = null;
try
{
//Verificando a existência de um transação aberta
if (dbTransaction != null)
{
if (dbCnn.State == ConnectionState.Closed)
{
dbCnn.Open();
}
dbCommand = new FbCommand("Rea_IMPRGRID", dbCnn);
dbCommand.Transaction = ((FbTransaction)(dbTransaction));
}
else
{
if (dbCnn == null)
{
dbCnn = ((FbConnection)GetConnectionDB());
}
if (dbCnn.State == ConnectionState.Closed)
{
dbCnn.Open();
}
dbCommand = new FbCommand("Rea_IMPRGRID", dbCnn);
dbCommand.Transaction = dbCnn.BeginTransaction(IsolationLevel.ReadCommitted);
}
dbCommand.CommandType = CommandType.StoredProcedure;
dbCommand.Parameters.AddWithValue("@IDIMPRGRID", IDIMPRGRID); //PrimaryKey
reader = dbCommand.ExecuteReader();
IMPRGRIDEntity entity = null;
if (reader.HasRows)
{
while (reader.Read())
{
entity = FillEntityObject(ref reader);
}
}
// Deleta reader
if (reader != null)
{
reader.Close();
reader.Dispose();
}
// Fecha conexão
if (dbTransaction == null)
{
dbCommand.Transaction.Commit();
if (dbCnn.State == ConnectionState.Open)
{
dbCnn.Close();
}
}
return(entity);
}
catch (Exception ex)
{
// Deleta reader
if (reader != null)
{
reader.Close();
reader.Dispose();
}
if (dbTransaction != null)
{
this.RollbackTransaction();
}
else
{
if (dbCommand.Transaction != null)
{
dbCommand.Transaction.Rollback();
}
if (dbCnn.State == ConnectionState.Open)
{
dbCnn.Close();
}
}
throw ex;
}
}
public int Save(IMPRGRIDEntity Entity)
{
int result = 0;
try
{
//Verificando a existência de um transação aberta
if (dbTransaction != null)
{
if (dbCnn.State == ConnectionState.Closed)
{
dbCnn.Open();
}
dbCommand = new FbCommand("Sav_IMPRGRID", dbCnn);
dbCommand.Transaction = ((FbTransaction)(dbTransaction));
}
else
{
if (dbCnn == null)
{
dbCnn = ((FbConnection)GetConnectionDB());
}
if (dbCnn.State == ConnectionState.Closed)
{
dbCnn.Open();
}
dbCommand = new FbCommand("Sav_IMPRGRID", dbCnn);
dbCommand.Transaction = dbCnn.BeginTransaction(IsolationLevel.ReadCommitted);
}
dbCommand.CommandType = CommandType.StoredProcedure;
if (Entity.IDIMPRGRID != -1)
{
dbCommand.Parameters.AddWithValue("@IDIMPRGRID", Entity.IDIMPRGRID); //PrimaryKey
}
else
{
dbCommand.Parameters.AddWithValue("@IDIMPRGRID", DBNull.Value); //PrimaryKey
}
dbCommand.Parameters.AddWithValue("@NOMETELA", Entity.NOMETELA); //Coluna
dbCommand.Parameters.AddWithValue("@NOMEGRID", Entity.NOMEGRID); //Coluna
dbCommand.Parameters.AddWithValue("@CAMPOSSELECIONADOS", Entity.CAMPOSSELECIONADOS); //Coluna
dbCommand.Parameters.AddWithValue("@FLAGAJUSTA", Entity.FLAGAJUSTA); //Coluna
dbCommand.Parameters.AddWithValue("@FLAGMODOPAISAGEM", Entity.FLAGMODOPAISAGEM); //Coluna
dbCommand.Parameters.AddWithValue("@FLAGEXIBIRDATA", Entity.FLAGEXIBIRDATA); //Coluna
dbCommand.Parameters.AddWithValue("@IDFUNCIONARIO", Entity.IDFUNCIONARIO); //Coluna
//Retorno da Procedure
FbParameter returnValue;
returnValue = dbCommand.CreateParameter();
dbCommand.Parameters["@IDIMPRGRID"].Direction = ParameterDirection.InputOutput;
//Executando consulta
dbCommand.ExecuteNonQuery();
result = int.Parse(dbCommand.Parameters["@IDIMPRGRID"].Value.ToString());
if (dbTransaction == null)
{
dbCommand.Transaction.Commit();
dbCnn.Close();
}
}
catch (Exception ex)
{
if (dbTransaction != null)
{
this.RollbackTransaction();
}
else
{
if (dbCommand.Transaction != null)
{
dbCommand.Transaction.Rollback();
}
if (dbCnn.State == ConnectionState.Open)
{
dbCnn.Close();
}
}
throw ex;
}
return(result);
}
private void SalveConfig(string Nometela, string NomeGrid)
{
try
{
IMPRGRIDEntity IMPRIGtY = new IMPRGRIDEntity();
//Update
if (IMPRGRIDColl.Count > 0)
{
IMPRIGtY = IMPRGRIDP.Read(IMPRGRIDColl[0].IDIMPRGRID);
IMPRIGtY.NOMEGRID = NomeGridSelec;
IMPRIGtY.NOMETELA = NometelaSelec;
IMPRIGtY.FLAGAJUSTA = ctlPrintToFitPageWidthCHK.Checked ? "S" : "N";
IMPRIGtY.FLAGEXIBIRDATA = chkData.Checked ? "S" : "N";
IMPRIGtY.FLAGMODOPAISAGEM = chkPaisagem.Checked ? "S" : "N";
IMPRIGtY.CAMPOSSELECIONADOS = string.Empty;
//Busca Cod Funcionario logado
IMPRIGtY.IDFUNCIONARIO = Convert.ToInt32(USUARIOP.Read(FrmLogin._IdUsuario).IDFUNCIONARIO);
//Salvar os campos
for (int i = 0; i < ctlColumnsToPrintCHKLBX.Items.Count; i++)
{
if (ctlColumnsToPrintCHKLBX.GetItemChecked(i))
{
IMPRIGtY.CAMPOSSELECIONADOS += ctlColumnsToPrintCHKLBX.Items[i].ToString() + ",";
}
}
//remove a virgula no final
IMPRIGtY.CAMPOSSELECIONADOS = IMPRIGtY.CAMPOSSELECIONADOS.Remove(IMPRIGtY.CAMPOSSELECIONADOS.Length - 1, 1);
IMPRGRIDP.Save(IMPRIGtY);
}
else //Insert
{
IMPRIGtY.IDIMPRGRID = -1;
IMPRIGtY.NOMEGRID = NomeGridSelec;
IMPRIGtY.NOMETELA = NometelaSelec;
IMPRIGtY.FLAGAJUSTA = ctlPrintToFitPageWidthCHK.Checked ? "S" : "N";
IMPRIGtY.FLAGEXIBIRDATA = chkData.Checked ? "S" : "N";
IMPRIGtY.FLAGMODOPAISAGEM = chkPaisagem.Checked ? "S" : "N";
IMPRIGtY.CAMPOSSELECIONADOS = string.Empty;
//Busca Cod Funcionario logado
IMPRIGtY.IDFUNCIONARIO = Convert.ToInt32(USUARIOP.Read(FrmLogin._IdUsuario).IDFUNCIONARIO);
//Salvar os campos
for (int i = 0; i < ctlColumnsToPrintCHKLBX.Items.Count; i++)
{
if (ctlColumnsToPrintCHKLBX.GetItemChecked(i))
{
IMPRIGtY.CAMPOSSELECIONADOS += ctlColumnsToPrintCHKLBX.Items[i].ToString() + ",";
}
}
//remove a virgula no final
IMPRIGtY.CAMPOSSELECIONADOS = IMPRIGtY.CAMPOSSELECIONADOS.Remove(IMPRIGtY.CAMPOSSELECIONADOS.Length - 1, 1);
IMPRGRIDP.Save(IMPRIGtY);
}
}
catch (Exception)
{
MessageBox.Show(ConfigMessage.Default.MsgSaveErro);
}
}
