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