public OperationResult newTokenFromGivenSupplierSerialNumber(string tokenParamsID, string SupplierSerialNumber, out TokenInfoCore tokenInfoCore) { IDbCommand dbCommand = null; tokenInfoCore = new TokenInfoCore(); OperationResult result; try { base.ConnectionString = DBConnectionString.ExpandSAFCore(); dbCommand = base.CreateCommand("GivenSupplierSerialNumberUpdateForNewToken", CommandType.StoredProcedure); dbCommand.Parameters.Add(base.AddParameter("@Param0", 1)); dbCommand.Parameters.Add(base.AddParameter("@Param1", 99)); dbCommand.Parameters.Add(base.AddParameter("@Param2", tokenParamsID)); dbCommand.Parameters.Add(base.AddParameter("@Param3", SupplierSerialNumber)); base.Connection.Open(); object obj = dbCommand.ExecuteScalar(); if (obj == DBNull.Value) { result = OperationResult.TokenVendorSeedNotAvaliable; } else { tokenInfoCore = this.loadTokenInfoCore(obj.ToString()); result = OperationResult.Success; } } catch (Exception ex) { LOGGER.Write(LOGGER.LogCategory.ERROR, string.Concat(new string[] { "SF.Expand.SAF.Core.TokensDAO::newTokenFromGivvenSupplierSerialNumber[", tokenParamsID, "]", Environment.NewLine, ex.ToString() }), null); result = OperationResult.Error; } finally { if (dbCommand != null) { dbCommand.Dispose(); } base.CloseConnection(); } return(result); }
public OperationResult createToken(string tokenParamsID, long movingFactor, DateTime expirationDate, string cryptoKey, string supplierSerialNumber, string internalSerialNumber, string creationLotID, string SupportCryptoData, out TokenInfoCore tokenInfoCore) { string tokenID = null; IDbCommand _cmd = null; OperationResult result; tokenInfoCore = new TokenInfoCore(); try { base.ConnectionString = DBConnectionString.ExpandSAFCore(); _cmd = base.CreateCommand("InsertNewToken", CommandType.StoredProcedure); _cmd.Parameters.Add(base.AddParameter("@tkStatus", 0)); _cmd.Parameters.Add(base.AddParameter("@tkParamsID", tokenParamsID)); _cmd.Parameters.Add(base.AddParameter("@tkMovingFactor", movingFactor)); _cmd.Parameters.Add(base.AddParameter("@tkExpirationDate", expirationDate)); _cmd.Parameters.Add(base.AddParameter("@tkCryptoKey", cryptoKey)); _cmd.Parameters.Add(base.AddParameter("@tkCreationLotID", creationLotID)); _cmd.Parameters.Add(base.AddParameter("@tkSupplierSerialNumber", supplierSerialNumber)); _cmd.Parameters.Add(base.AddParameter("@tkInternalSerialNumber", internalSerialNumber)); _cmd.Parameters.Add(base.AddParameter("@tkSupportCriptoData", SupportCryptoData)); _cmd.Parameters.Add(base.AddParameter("@tokenSubLotID", null)); base.Connection.Open(); long _hResult = long.Parse(_cmd.ExecuteScalar().ToString()); tokenID = _hResult.ToString(); tokenInfoCore = this.loadTokenInfoCore(tokenID); result = OperationResult.Success; } catch (Exception ex) { SAFLOGGER.Write(SAFLOGGER.LOGGEREventID.EXCEPTION, "SAFCORE", new string[] { "http://sfexpand.SAFCore.TokensDAO.softfinanca.com/", Assembly.GetExecutingAssembly().FullName.ToString(), ex.ToString() }); result = OperationResult.Error; } finally { if (_cmd != null) { _cmd.Dispose(); } base.CloseConnection(); } return(result); }
public object loadChallengeRequest(string tokenID) { IDbCommand _cmd = null; IDbCommand _cmdValid = null; object result; try { base.ConnectionString = DBConnectionString.ExpandSAFCore(); _cmdValid = base.CreateCommand(TokensChallengeRequestDAO.spVALID_CHALLENGE_REQUEST_BY_TOKENID, CommandType.StoredProcedure); _cmdValid.Parameters.Add(base.AddParameter("@tkID", tokenID)); base.Connection.Open(); if (1 == (int)_cmdValid.ExecuteScalar()) { _cmdValid = base.CreateCommand(TokensChallengeRequestDAO.spGET_CHALLENGE_REQUEST_BY_TOKENID, CommandType.StoredProcedure); _cmdValid.Parameters.Add(base.AddParameter("@tkID", tokenID)); result = _cmdValid.ExecuteScalar(); } else { result = null; } } catch (Exception ex) { SAFLOGGER.Write(SAFLOGGER.LOGGEREventID.EXCEPTION, "SAFCORE", new string[] { "http://sfexpand.SAFCore.TokensChallengeRequestDAO.softfinanca.com/", Assembly.GetExecutingAssembly().FullName.ToString(), ex.ToString() }); result = null; } finally { if (_cmdValid != null) { _cmdValid.Dispose(); } if (_cmd != null) { _cmd.Dispose(); } base.CloseConnection(); } return(result); }
public OperationResult loadTableWithTokensLot(LoteType loteType, string loteId, string TokenVendorID, TokenMovingFactorType tokenMovingFactorType, out DataTable dataTable) { DataSet _ds = new DataSet(); IDbCommand _cmd = null; OperationResult result; try { base.ConnectionString = DBConnectionString.ExpandSAFCore(); _cmd = base.CreateCommand((loteType == LoteType.SupplierLot) ? "TokenGetByLot" : "TokenGetBySubLot", CommandType.StoredProcedure); _cmd.Parameters.Add(base.AddParameter("@Param0", (byte)tokenMovingFactorType)); _cmd.Parameters.Add(base.AddParameter("@Param1", TokenVendorID)); _cmd.Parameters.Add(base.AddParameter("@Param2", loteId)); base.CreateDataAdapter(_cmd).Fill(_ds); dataTable = _ds.Tables[0]; result = OperationResult.Success; } catch (Exception ex) { dataTable = null; SAFLOGGER.Write(SAFLOGGER.LOGGEREventID.EXCEPTION, "SAFCORE", new string[] { "http://sfexpand.SAFCore.TokensDAO.softfinanca.com/", Assembly.GetExecutingAssembly().FullName.ToString(), ex.ToString() }); result = OperationResult.Error; } finally { if (_cmd != null) { _cmd.Dispose(); } if (_ds != null) { _ds.Dispose(); } base.CloseConnection(); } return(result); }
public TokenCryptoData loadTokenCryptoData(string tokenID) { IDataReader dataReader = null; IDbCommand dbCommand = null; TokenCryptoData result; try { base.ConnectionString = DBConnectionString.ExpandSAFCore(); dbCommand = base.CreateCommand("GetTokenByID", CommandType.StoredProcedure); dbCommand.Parameters.Add(base.AddParameter("@tkID", tokenID)); base.Connection.Open(); dataReader = dbCommand.ExecuteReader(CommandBehavior.CloseConnection); dataReader.Read(); result = new TokenCryptoData(dataReader[5].ToString(), dataReader[0].ToString(), new CryptoData((long)dataReader[1], dataReader[2].ToString().Trim(), dataReader[3].ToString().Trim(), (dataReader[6] != DBNull.Value) ? dataReader[6].ToString().Trim() : string.Empty), new TokenParamsDAO().loadTokenBaseParams(((byte)dataReader[4]).ToString())); } catch (Exception ex) { LOGGER.Write(LOGGER.LogCategory.ERROR, string.Concat(new string[] { "SF.Expand.SAF.Core.TokensDAO::loadTokenCryptoData[", tokenID, "]", Environment.NewLine, ex.ToString() }), null); result = new TokenCryptoData(null, null, default(CryptoData), default(TokenTypeBaseParams)); } finally { if (dataReader != null) { dataReader.Dispose(); } if (dbCommand != null) { dbCommand.Dispose(); } base.CloseConnection(); } return(result); }
public TokenInfoCore loadTokenInfoCore(string tokenID) { IDataReader dataReader = null; IDbCommand dbCommand = null; TokenInfoCore result; try { base.ConnectionString = DBConnectionString.ExpandSAFCore(); dbCommand = base.CreateCommand("GetTokenInfoByID", CommandType.StoredProcedure); dbCommand.Parameters.Add(base.AddParameter("@tkID", tokenID)); base.OpenConnection(); dataReader = dbCommand.ExecuteReader(CommandBehavior.CloseConnection); dataReader.Read(); result = TokenInfoCore.loadTokenInfoCore((byte)dataReader[0], (int)dataReader[1], (string)dataReader[2], (string)dataReader[3], (string)dataReader[4], (dataReader[5] != DBNull.Value) ? ((DateTime)dataReader[5]) : DateTime.MinValue, (string)dataReader[7], (TokenStatus)((byte)dataReader[6])); } catch (Exception ex) { LOGGER.Write(LOGGER.LogCategory.ERROR, string.Concat(new string[] { "SF.Expand.SAF.Core.TokensDAO::loadTokenInfo[", tokenID, "]", Environment.NewLine, ex.ToString() }), null); result = new TokenInfoCore(); } finally { if (dataReader != null) { dataReader.Dispose(); } if (dbCommand != null) { dbCommand.Dispose(); } base.CloseConnection(); } return(result); }
public object loadChallengeRequest(string tokenID) { IDbCommand dbCommand = null; IDbCommand dbCommand2 = null; object result; try { base.ConnectionString = DBConnectionString.ExpandSAFCore(); dbCommand2 = base.CreateCommand(TokensChallengeRequestDAO.spVALID_CHALLENGE_REQUEST_BY_TOKENID, CommandType.StoredProcedure); dbCommand2.Parameters.Add(base.AddParameter("@tkID", tokenID)); base.Connection.Open(); if (1 == (int)dbCommand2.ExecuteScalar()) { dbCommand2 = base.CreateCommand(TokensChallengeRequestDAO.spGET_CHALLENGE_REQUEST_BY_TOKENID, CommandType.StoredProcedure); dbCommand2.Parameters.Add(base.AddParameter("@tkID", tokenID)); result = dbCommand2.ExecuteScalar(); } else { result = null; } } catch (Exception ex) { LOGGER.Write(LOGGER.LogCategory.ERROR, "SF.Expand.SAF.Core::loadChallengeRequest[]\r\n" + ex.Message, null); result = null; } finally { if (dbCommand2 != null) { dbCommand2.Dispose(); } if (dbCommand != null) { dbCommand.Dispose(); } base.CloseConnection(); } return(result); }
public OperationResult seedsStatusSublotBySupplierLotID(string supplierLotID, out DataTable dataTable) { DataSet dataSet = new DataSet(); IDbCommand dbCommand = null; OperationResult result; try { base.ConnectionString = DBConnectionString.ExpandSAFCore(); if (supplierLotID != null || supplierLotID.Trim().Length > 1) { dbCommand = base.CreateCommand("TokenSeedsCountBySubLotIDBySupplierLotID", CommandType.StoredProcedure); dbCommand.Parameters.Add(base.AddParameter("@Param0", supplierLotID)); } else { dbCommand = base.CreateCommand("TokenSeedsCountBySupplierLotID", CommandType.StoredProcedure); } base.CreateDataAdapter(dbCommand).Fill(dataSet); dataTable = dataSet.Tables[0]; result = OperationResult.Success; } catch (Exception ex) { dataTable = null; LOGGER.Write(LOGGER.LogCategory.ERROR, "SF.Expand.SAF.Core.TokensDAO::seedsStatusSublotBySupplierLotID[]" + Environment.NewLine + ex.ToString(), null); result = OperationResult.Error; } finally { if (dbCommand != null) { dbCommand.Dispose(); } if (dataSet != null) { dataSet.Dispose(); } base.CloseConnection(); } return(result); }
public OperationResult loadSubLots(string creationLotID, string tokenParamsID, out DataTable dataTable) { DataSet _ds = new DataSet(); IDbCommand _cmd = null; OperationResult result; try { base.ConnectionString = DBConnectionString.ExpandSAFCore(); _cmd = base.CreateCommand("TokenSubLot", CommandType.StoredProcedure); _cmd.Parameters.Add(base.AddParameter("@CreationLotID", creationLotID)); _cmd.Parameters.Add(base.AddParameter("@TokenParamsID", tokenParamsID)); base.CreateDataAdapter(_cmd).Fill(_ds); dataTable = _ds.Tables[0]; result = OperationResult.Success; } catch (Exception ex) { dataTable = null; SAFLOGGER.Write(SAFLOGGER.LOGGEREventID.EXCEPTION, "SAFCORE", new string[] { "http://sfexpand.SAFCore.TokensDAO.softfinanca.com/", Assembly.GetExecutingAssembly().FullName.ToString(), ex.ToString() }); result = OperationResult.Error; } finally { if (_cmd != null) { _cmd.Dispose(); } if (_ds != null) { _ds.Dispose(); } base.CloseConnection(); } return(result); }
public TokenTypeBaseParams loadTokenBaseParams(string tokenParamsID) { IDataReader _rd = null; IDbCommand _cmd = null; TokenTypeBaseParams result; try { base.ConnectionString = DBConnectionString.ExpandSAFCore(); _cmd = base.CreateCommand("GetTokenBaseParams", CommandType.StoredProcedure); _cmd.Parameters.Add(base.AddParameter("@Param1", tokenParamsID)); base.Connection.Open(); _rd = _cmd.ExecuteReader(CommandBehavior.CloseConnection); _rd.Read(); result = new TokenTypeBaseParams((int)((byte)_rd[0]), (int)((byte)_rd[1]), (int)_rd[2], (long)_rd[3], (TokenSeedType)((byte)_rd[4]), (TokenMovingFactorType)((byte)_rd[5]), (long)((int)_rd[6]), tokenParamsID, (int)_rd[7]); } catch (Exception ex) { SAFLOGGER.Write(SAFLOGGER.LOGGEREventID.EXCEPTION, "SAFCORE", new string[] { "http://sfexpand.SAFCore.TokenParamsDAO.softfinanca.com/", Assembly.GetExecutingAssembly().FullName.ToString(), ex.ToString() }); result = default(TokenTypeBaseParams); } finally { if (_rd != null) { _rd.Dispose(); } if (_cmd != null) { _cmd.Dispose(); } base.CloseConnection(); } return(result); }
public TokenCryptoData loadTokenCryptoData(string tokenID) { IDataReader _rd = null; IDbCommand _cmd = null; TokenCryptoData result; try { base.ConnectionString = DBConnectionString.ExpandSAFCore(); _cmd = base.CreateCommand("GetTokenByID", CommandType.StoredProcedure); _cmd.Parameters.Add(base.AddParameter("@tkID", tokenID)); base.Connection.Open(); _rd = _cmd.ExecuteReader(CommandBehavior.CloseConnection); _rd.Read(); result = new TokenCryptoData(_rd[5].ToString(), _rd[0].ToString(), new CryptoData((long)_rd[1], _rd[2].ToString().Trim(), _rd[3].ToString().Trim(), (_rd[6] != DBNull.Value) ? _rd[6].ToString().Trim() : string.Empty), new TokenParamsDAO().loadTokenBaseParams(((byte)_rd[4]).ToString())); } catch (Exception ex) { SAFLOGGER.Write(SAFLOGGER.LOGGEREventID.EXCEPTION, "SAFCORE", new string[] { "http://sfexpand.SAFCore.TokensDAO.softfinanca.com/", Assembly.GetExecutingAssembly().FullName.ToString(), ex.ToString() }); result = new TokenCryptoData(null, null, default(CryptoData), default(TokenTypeBaseParams)); } finally { if (_rd != null) { _rd.Dispose(); } if (_cmd != null) { _cmd.Dispose(); } base.CloseConnection(); } return(result); }
public TokenInfoCore loadTokenInfoCore(string tokenID) { IDataReader _rd = null; IDbCommand _cmd = null; TokenInfoCore result; try { base.ConnectionString = DBConnectionString.ExpandSAFCore(); _cmd = base.CreateCommand("GetTokenInfoByID", CommandType.StoredProcedure); _cmd.Parameters.Add(base.AddParameter("@tkID", tokenID)); base.OpenConnection(); _rd = _cmd.ExecuteReader(CommandBehavior.CloseConnection); _rd.Read(); result = TokenInfoCore.loadTokenInfoCore((byte)_rd[0], (int)_rd[1], (_rd[2] != DBNull.Value) ? ((string)_rd[2]) : "", (_rd[3] != DBNull.Value) ? ((string)_rd[3]) : "", (string)_rd[4], (_rd[5] != DBNull.Value) ? ((DateTime)_rd[5]) : DateTime.MinValue, (_rd[7] == DBNull.Value) ? null : _rd[7].ToString(), (TokenStatus)((byte)_rd[6])); } catch (Exception ex) { SAFLOGGER.Write(SAFLOGGER.LOGGEREventID.EXCEPTION, "SAFCORE", new string[] { "http://sfexpand.SAFCore.TokensDAO.softfinanca.com/", Assembly.GetExecutingAssembly().FullName.ToString(), ex.ToString() }); result = new TokenInfoCore(); } finally { if (_rd != null) { _rd.Dispose(); } if (_cmd != null) { _cmd.Dispose(); } base.CloseConnection(); } return(result); }
public OperationResult updateTokenStatus(string tokenID, TokenStatus tokenStatus) { IDbCommand dbCommand = null; OperationResult result; try { base.ConnectionString = DBConnectionString.ExpandSAFCore(); dbCommand = base.CreateCommand("PersistTokenStatus", CommandType.StoredProcedure); dbCommand.Parameters.Add(base.AddParameter("@Param0", (byte)tokenStatus)); dbCommand.Parameters.Add(base.AddParameter("@tkID", tokenID)); base.Connection.Open(); int num = dbCommand.ExecuteNonQuery(); result = ((num == 1) ? OperationResult.Success : OperationResult.Error); } catch (Exception ex) { LOGGER.Write(LOGGER.LogCategory.ERROR, string.Concat(new string[] { "SF.Expand.SAF.Core.TokensDAO::updateTokenStatus[", tokenID, ";", tokenStatus.ToString(), "]", Environment.NewLine, ex.ToString() }), null); result = OperationResult.Error; } finally { if (dbCommand != null) { dbCommand.Dispose(); } base.CloseConnection(); } return(result); }
private OperationResult _updateTable(string tokenID, string commandText, object[] fieldValue) { IDbCommand _cmd = null; OperationResult result; try { base.ConnectionString = DBConnectionString.ExpandSAFCore(); _cmd = base.CreateCommand(commandText, CommandType.StoredProcedure); _cmd.Parameters.Add(base.AddParameter("@tkID", tokenID)); for (int _idx = 0; _idx < fieldValue.Length; _idx++) { _cmd.Parameters.Add(base.AddParameter("@Param" + _idx.ToString(), fieldValue[_idx])); } base.Connection.Open(); int iRes = _cmd.ExecuteNonQuery(); result = ((iRes == 1) ? OperationResult.Success : OperationResult.Error); } catch (Exception ex) { SAFLOGGER.Write(SAFLOGGER.LOGGEREventID.EXCEPTION, "SAFCORE", new string[] { "http://sfexpand.SAFCore.TokensDAO.softfinanca.com/", Assembly.GetExecutingAssembly().FullName.ToString(), ex.ToString() }); result = OperationResult.Error; } finally { if (_cmd != null) { _cmd.Dispose(); } base.CloseConnection(); } return(result); }
public OperationResult undoUpdateForNewToken(string tokenID) { IDbCommand _cmd = null; OperationResult result; try { base.ConnectionString = DBConnectionString.ExpandSAFCore(); _cmd = base.CreateCommand("UndoUpdateForNewToken", CommandType.StoredProcedure); _cmd.Parameters.Add(base.AddParameter("@Param0", 99)); _cmd.Parameters.Add(base.AddParameter("@Param1", 1)); _cmd.Parameters.Add(base.AddParameter("@Param2", tokenID)); _cmd.Parameters.Add(base.AddParameter("@Param3", tokenID)); base.Connection.Open(); int iRes = _cmd.ExecuteNonQuery(); result = ((iRes == 1) ? OperationResult.Success : OperationResult.Error); } catch (Exception ex) { SAFLOGGER.Write(SAFLOGGER.LOGGEREventID.EXCEPTION, "SAFCORE", new string[] { "http://sfexpand.SAFCore.TokensDAO.softfinanca.com/", Assembly.GetExecutingAssembly().FullName.ToString(), ex.ToString() }); result = OperationResult.Error; } finally { if (_cmd != null) { _cmd.Dispose(); } base.CloseConnection(); } return(result); }
public OperationResult tokenStatus(string tokenID, out TokenStatus tokenStatus) { tokenStatus = TokenStatus.Undefined; IDbCommand dbCommand = null; OperationResult result; try { base.ConnectionString = DBConnectionString.ExpandSAFCore(); dbCommand = base.CreateCommand("TokenGetStatus", CommandType.StoredProcedure); dbCommand.Parameters.Add(base.AddParameter("@tkID", tokenID)); base.Connection.Open(); tokenStatus = (TokenStatus)((byte)dbCommand.ExecuteScalar()); result = OperationResult.Success; } catch (Exception ex) { LOGGER.Write(LOGGER.LogCategory.ERROR, string.Concat(new string[] { "SF.Expand.SAF.Core.TokensDAO::tokenStatus[", tokenID, "]", Environment.NewLine, ex.ToString() }), null); result = OperationResult.Error; } finally { if (dbCommand != null) { dbCommand.Dispose(); } base.CloseConnection(); } return(result); }
public OperationResult persistChallengeRequest(string tokenID, string challengeRequest, DateTime challengeRequestValidThru) { IDbCommand _cmd = null; OperationResult result; try { base.ConnectionString = DBConnectionString.ExpandSAFCore(); _cmd = base.CreateCommand(TokensChallengeRequestDAO.spINSERT_NEW_CHALLENGE_REQUEST, CommandType.StoredProcedure); _cmd.Parameters.Add(base.AddParameter("@tkID", tokenID)); _cmd.Parameters.Add(base.AddParameter("@param1", challengeRequest)); _cmd.Parameters.Add(base.AddParameter("@param2", challengeRequestValidThru)); base.Connection.Open(); result = ((_cmd.ExecuteNonQuery() == 1) ? OperationResult.Success : OperationResult.Error); } catch (Exception ex) { SAFLOGGER.Write(SAFLOGGER.LOGGEREventID.EXCEPTION, "SAFCORE", new string[] { "http://sfexpand.SAFCore.TokensChallengeRequestDAO.softfinanca.com/", ex.ToString() }); result = OperationResult.Error; } finally { if (_cmd != null) { _cmd.Dispose(); } if (base.Connection != null && base.Connection.State == ConnectionState.Open) { base.Connection.Dispose(); } } return(result); }
public OperationResult loadTableWithTokensLot(LoteType loteType, string loteId, string TokenVendorID, TokenMovingFactorType tokenMovingFactorType, out DataTable dataTable) { dataTable = null; DataSet dataSet = new DataSet(); IDbCommand dbCommand = null; OperationResult result; try { base.ConnectionString = DBConnectionString.ExpandSAFCore(); dbCommand = base.CreateCommand((loteType == LoteType.SupplierLot) ? "TokenGetByLot" : "TokenGetBySubLot", CommandType.StoredProcedure); dbCommand.Parameters.Add(base.AddParameter("@Param0", (byte)tokenMovingFactorType)); dbCommand.Parameters.Add(base.AddParameter("@Param1", TokenVendorID)); dbCommand.Parameters.Add(base.AddParameter("@Param2", loteId)); base.CreateDataAdapter(dbCommand).Fill(dataSet); dataTable = dataSet.Tables[0]; result = OperationResult.Success; } catch (Exception ex) { LOGGER.Write(LOGGER.LogCategory.ERROR, "SF.Expand.SAF.Core.TokensDAO::loadTableWithTokensLot[]" + Environment.NewLine + ex.ToString(), null); result = OperationResult.Error; } finally { if (dbCommand != null) { dbCommand.Dispose(); } if (dataSet != null) { dataSet.Dispose(); } base.CloseConnection(); } return(result); }
public long tokensSeedsBulkInsert(string pathFileName, TokenStatus tokenStatus, DateTime tokenExpiration) { IDbCommand dbCommand = null; long result; try { base.ConnectionString = DBConnectionString.ExpandSAFCore(); dbCommand = base.CreateCommand("TokenBulkInsert", CommandType.StoredProcedure); dbCommand.Parameters.Add(base.AddParameter("@param0", pathFileName)); dbCommand.Parameters.Add(base.AddParameter("@param1", (int)tokenStatus)); dbCommand.Parameters.Add(base.AddParameter("@param2", tokenExpiration)); base.Connection.Open(); result = (long)dbCommand.ExecuteNonQuery(); } catch (Exception ex) { LOGGER.Write(LOGGER.LogCategory.ERROR, string.Concat(new string[] { "SF.Expand.SAF.Core.TokensDAO::tokensSeedsBulkInsert[", pathFileName, "]", Environment.NewLine, ex.ToString() }), null); result = -1L; } finally { if (dbCommand != null) { dbCommand.Dispose(); } base.CloseConnection(); } return(result); }
public string tokenKeyByTokenVendorID(string tokenVendorID) { IDbCommand _cmd = null; DataSet _ds = new DataSet(); DataTable dataTable; string tokenCriptoData = null; try { base.ConnectionString = DBConnectionString.ExpandSAFCore(); _cmd = base.CreateCommand("TokenKeyByTokenVendorID", CommandType.StoredProcedure); _cmd.Parameters.Add(base.AddParameter("@TokenVendorID", tokenVendorID)); base.CreateDataAdapter(_cmd).Fill(_ds); dataTable = _ds.Tables[0]; tokenCriptoData = (string)dataTable.Rows[0].ItemArray[0]; } catch (Exception ex) { SAFLOGGER.Write(SAFLOGGER.LOGGEREventID.EXCEPTION, "SAFCORE", new string[] { "http://sfexpand.SAFCore.TokensDAO.softfinanca.com/", Assembly.GetExecutingAssembly().FullName.ToString(), ex.ToString() }); } finally { if (_cmd != null) { _cmd.Dispose(); } base.CloseConnection(); } return(tokenCriptoData); }
public OperationResult tokenSupplierSerialNumbersByLot(LoteType loteType, string loteId, out DataTable dataTable) { dataTable = null; DataSet dataSet = new DataSet(); IDbCommand dbCommand = null; OperationResult result; try { base.ConnectionString = DBConnectionString.ExpandSAFCore(); string commandText = (loteType == LoteType.SupplierLot) ? "GetTokensSupplierSerialnumberBySupplierLot" : "GetTokensSupplierSerialnumberBySubLotID"; dbCommand = base.CreateCommand(commandText, CommandType.StoredProcedure); dbCommand.Parameters.Add(base.AddParameter("@Param0", loteId)); base.CreateDataAdapter(dbCommand).Fill(dataSet); dataTable = dataSet.Tables[0]; result = OperationResult.Success; } catch (Exception ex) { LOGGER.Write(LOGGER.LogCategory.ERROR, "SF.Expand.SAF.Core.TokensDAO::tokenSupplierSerialNumbersByLot[]" + Environment.NewLine + ex.ToString(), null); result = OperationResult.Error; } finally { if (dbCommand != null) { dbCommand.Dispose(); } if (dataSet != null) { dataSet.Dispose(); } base.CloseConnection(); } return(result); }