public OperationResult resetChallengeRequest(string tokenID) { IDbCommand _cmd = null; OperationResult result; try { base.ConnectionString = DBConnectionString.ExpandSAFCore(); _cmd = base.CreateCommand(TokensChallengeRequestDAO.spRESET_CHALLENGE_REQUEST_BY_TOKENID, CommandType.StoredProcedure); _cmd.Parameters.Add(base.AddParameter("@tkID", tokenID)); 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 long clearChallengeRequestOverdue(string tokenID) { IDbCommand _cmd = null; long result; try { base.ConnectionString = DBConnectionString.ExpandSAFCore(); _cmd = base.CreateCommand(TokensChallengeRequestDAO.spCLEAR_OVERDUE_CHALLENGE_REQUEST, CommandType.StoredProcedure); base.Connection.Open(); result = (long)_cmd.ExecuteNonQuery(); } catch (Exception ex) { SAFLOGGER.Write(SAFLOGGER.LOGGEREventID.EXCEPTION, "SAFCORE", new string[] { "http://sfexpand.SAFCore.TokensChallengeRequestDAO.softfinanca.com/", ex.ToString() }); result = -1L; } finally { if (_cmd != null) { _cmd.Dispose(); } if (base.Connection != null && base.Connection.State == ConnectionState.Open) { base.Connection.Dispose(); } } return(result); }
public OperationResult updateTokenStatus(string tokenID, TokenStatus tokenStatus) { IDbCommand _cmd = null; OperationResult result; try { base.ConnectionString = DBConnectionString.ExpandSAFCore(); _cmd = base.CreateCommand("PersistTokenStatus", CommandType.StoredProcedure); _cmd.Parameters.Add(base.AddParameter("@Param0", (byte)tokenStatus)); _cmd.Parameters.Add(base.AddParameter("@tkID", 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 resetChallengeRequest(string tokenID) { IDbCommand dbCommand = null; OperationResult result; try { base.ConnectionString = DBConnectionString.ExpandSAFCore(); dbCommand = base.CreateCommand(TokensChallengeRequestDAO.spRESET_CHALLENGE_REQUEST_BY_TOKENID, CommandType.StoredProcedure); dbCommand.Parameters.Add(base.AddParameter("@tkID", tokenID)); base.Connection.Open(); result = ((dbCommand.ExecuteNonQuery() == 1) ? OperationResult.Success : OperationResult.Error); } catch (Exception ex) { LOGGER.Write(LOGGER.LogCategory.ERROR, "SF.Expand.SAF.Core.TokensChallengeRequest::resetChallengeRequest[]\r\n" + ex.Message, null); result = OperationResult.Error; } finally { if (dbCommand != null) { dbCommand.Dispose(); } if (base.Connection != null && base.Connection.State == ConnectionState.Open) { base.Connection.Dispose(); } } return(result); }
private string _loadFromDB(string value, string sqlExec) { IDbCommand dbCommand = null; string result; try { base.ConnectionString = DBConnectionString.ExpandSAFCore(); dbCommand = base.CreateCommand(sqlExec, CommandType.StoredProcedure); dbCommand.Parameters.Add(base.AddParameter("@Param1", value)); base.Connection.Open(); object obj = dbCommand.ExecuteScalar(); result = (string)obj; } catch (Exception logObject) { LOGGER.Write(LOGGER.LogCategory.EXCEPTION, "SF.Expand.SAF.Core.TokensDAO::_loadFromDB[" + sqlExec + "]", logObject); result = null; } finally { if (dbCommand != null) { dbCommand.Dispose(); } base.CloseConnection(); } return(result); }
public long clearChallengeRequestOverdue(string tokenID) { IDbCommand dbCommand = null; long result; try { base.ConnectionString = DBConnectionString.ExpandSAFCore(); dbCommand = base.CreateCommand(TokensChallengeRequestDAO.spCLEAR_OVERDUE_CHALLENGE_REQUEST, CommandType.StoredProcedure); base.Connection.Open(); result = (long)dbCommand.ExecuteNonQuery(); } catch (Exception ex) { LOGGER.Write(LOGGER.LogCategory.ERROR, "SF.Expand.SAF.Core.TokensChallengeRequest::clearChallengeRequestOverdue[]\r\n" + ex.Message, null); result = -1L; } finally { if (dbCommand != null) { dbCommand.Dispose(); } if (base.Connection != null && base.Connection.State == ConnectionState.Open) { base.Connection.Dispose(); } } return(result); }
public OperationResult tokenStatus(string tokenID, out TokenStatus tokenStatus) { tokenStatus = TokenStatus.Undefined; IDbCommand _cmd = null; OperationResult result; try { base.ConnectionString = DBConnectionString.ExpandSAFCore(); _cmd = base.CreateCommand("TokenGetStatus", CommandType.StoredProcedure); _cmd.Parameters.Add(base.AddParameter("@tkID", tokenID)); base.Connection.Open(); tokenStatus = (TokenStatus)((byte)_cmd.ExecuteScalar()); 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 OperationResult tokenSeedsByParamIDWithNoSubLot(string tokenParamsID, out long numberOfSeeds) { numberOfSeeds = -1L; IDbCommand dbCommand = null; OperationResult result; try { base.ConnectionString = DBConnectionString.ExpandSAFCore(); dbCommand = base.CreateCommand("CheckAvailableSeedsByTokenParamsID", CommandType.StoredProcedure); dbCommand.Parameters.Add(base.AddParameter("@Param0", tokenParamsID)); base.Connection.Open(); numberOfSeeds = (long)dbCommand.ExecuteNonQuery(); result = OperationResult.Success; } catch (Exception ex) { LOGGER.Write(LOGGER.LogCategory.ERROR, "SF.Expand.SAF.Core.TokensDAO::tokenSeedsByParamIDWithNoSubLot[]" + Environment.NewLine + ex.ToString(), null); result = OperationResult.Error; } finally { if (dbCommand != null) { dbCommand.Dispose(); } base.CloseConnection(); } return(result); }
public long tokensSeedsBulkInsert(string pathFileName, TokenStatus tokenStatus, DateTime tokenExpiration) { IDbCommand _cmd = null; long result; try { base.ConnectionString = DBConnectionString.ExpandSAFCore(); _cmd = base.CreateCommand("TokenBulkInsert", CommandType.StoredProcedure); _cmd.Parameters.Add(base.AddParameter("@PathFileName", pathFileName)); _cmd.Parameters.Add(base.AddParameter("@tkStatus", (int)tokenStatus)); _cmd.Parameters.Add(base.AddParameter("@tkExpirationDate", tokenExpiration)); base.Connection.Open(); result = (long)_cmd.ExecuteNonQuery(); } catch (Exception ex) { SAFLOGGER.Write(SAFLOGGER.LOGGEREventID.EXCEPTION, "SAFCORE", new string[] { "http://sfexpand.SAFCore.TokensDAO.softfinanca.com/", Assembly.GetExecutingAssembly().FullName.ToString(), ex.ToString() }); result = -1L; } finally { if (_cmd != null) { _cmd.Dispose(); } base.CloseConnection(); } return(result); }
public OperationResult seedsStatusBySupplierlLotID(out DataTable dataTable) { DataSet dataSet = new DataSet(); IDbCommand dbCommand = null; OperationResult result; try { base.ConnectionString = DBConnectionString.ExpandSAFCore(); dbCommand = base.CreateCommand("TokenSeedsCountBySubLotID", 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::seedsStatusBySupplierlLotID[]" + 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 createSubLotByTokenVendor(long numberOfTokensInLot, string tokenParamsID, string subLotID, DateTime expirationDate, out long numberOfSeeds) { IDbCommand _cmdInfo = null; IDbCommand _cmdBuild = null; numberOfSeeds = -1L; string _lotNumber = BaseFunctions.GenerateSupplierLotNumber(numberOfTokensInLot.ToString(), null); OperationResult result; try { base.ConnectionString = DBConnectionString.ExpandSAFCore(); _cmdInfo = base.CreateCommand("CheckAvailableSeedsByTokenParamsID", CommandType.StoredProcedure); _cmdInfo.Parameters.Add(base.AddParameter("@Param0", tokenParamsID)); base.Connection.Open(); numberOfSeeds = (long)((int)_cmdInfo.ExecuteScalar()); if (numberOfSeeds < numberOfTokensInLot) { SAFLOGGER.Write(SAFLOGGER.LOGGEREventID.WARNING, "SAFCORE", new string[] { "http://sfexpand.SAFCore.TokensDAO.softfinanca.com/createSubLotByTokenVendor", OperationResult.TokenVendorSeedNotAvaliable.ToString() }); result = OperationResult.TokenVendorSeedNotAvaliable; } else { _cmdBuild = base.CreateCommand("CreateSupplierSubLot", CommandType.StoredProcedure); _cmdBuild.Parameters.Add(base.AddParameter("@Param0", _lotNumber)); _cmdBuild.Parameters.Add(base.AddParameter("@Param1", expirationDate)); _cmdBuild.Parameters.Add(base.AddParameter("@Param2", tokenParamsID)); _cmdBuild.Parameters.Add(base.AddParameter("@top", (int)numberOfTokensInLot)); numberOfSeeds = (long)_cmdBuild.ExecuteNonQuery(); 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 (_cmdInfo != null) { _cmdInfo.Dispose(); } if (_cmdBuild != null) { _cmdBuild.Dispose(); } base.CloseConnection(); } return(result); }
public OperationResult tokenSeedsByParamIDWithNoSubLot(string tokenParamsID, out long numberOfSeeds) { numberOfSeeds = -1L; IDbCommand _cmdInfo = null; OperationResult result; try { base.ConnectionString = DBConnectionString.ExpandSAFCore(); _cmdInfo = base.CreateCommand("CheckAvailableSeedsByTokenParamsID", CommandType.StoredProcedure); _cmdInfo.Parameters.Add(base.AddParameter("@Param0", tokenParamsID)); base.Connection.Open(); numberOfSeeds = Convert.ToInt64(_cmdInfo.ExecuteScalar()); 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 (_cmdInfo != null) { _cmdInfo.Dispose(); } base.CloseConnection(); } return(result); }
private OperationResult _updateTable(string tokenID, string commandText, object[] fieldValue) { IDbCommand dbCommand = null; OperationResult result; try { base.ConnectionString = DBConnectionString.ExpandSAFCore(); dbCommand = base.CreateCommand(commandText, CommandType.StoredProcedure); dbCommand.Parameters.Add(base.AddParameter("@tkID", tokenID)); for (int i = 0; i < fieldValue.Length; i++) { dbCommand.Parameters.Add(base.AddParameter("@Param" + i.ToString(), fieldValue[i])); } base.Connection.Open(); int num = dbCommand.ExecuteNonQuery(); result = ((num == 1) ? OperationResult.Success : OperationResult.Error); } catch (Exception) { LOGGER.Write(LOGGER.LogCategory.ERROR, "SF.Expand.SAF.Core.TokensDAO::_updateTable[" + tokenID + "]", null); result = OperationResult.Error; } finally { if (dbCommand != null) { dbCommand.Dispose(); } base.CloseConnection(); } return(result); }
public TokenTypeBaseParams loadTokenBaseParams(string tokenParamsID) { IDataReader dataReader = null; IDbCommand dbCommand = null; TokenTypeBaseParams result; try { base.ConnectionString = DBConnectionString.ExpandSAFCore(); dbCommand = base.CreateCommand("GetTokenBaseParams", CommandType.StoredProcedure); dbCommand.Parameters.Add(base.AddParameter("@Param1", tokenParamsID)); base.Connection.Open(); dataReader = dbCommand.ExecuteReader(CommandBehavior.CloseConnection); dataReader.Read(); result = new TokenTypeBaseParams((int)((byte)dataReader[0]), (int)((byte)dataReader[1]), (int)dataReader[2], (long)dataReader[3], (TokenSeedType)((byte)dataReader[4]), (TokenMovingFactorType)((byte)dataReader[5]), (long)((int)dataReader[6]), tokenParamsID, (int)dataReader[7]); } catch (Exception ex) { LOGGER.Write(LOGGER.LogCategory.ERROR, "SF.Expand.SAF.Core.TokenParamsDAO::loadTokenBaseParams[]\r\n" + ex.Message, null); result = default(TokenTypeBaseParams); } finally { if (dataReader != null) { dataReader.Dispose(); } if (dbCommand != null) { dbCommand.Dispose(); } base.CloseConnection(); } return(result); }
private string _loadFromDB(string value, string sqlExec) { IDbCommand _cmd = null; string result; try { base.ConnectionString = DBConnectionString.ExpandSAFCore(); _cmd = base.CreateCommand(sqlExec, CommandType.StoredProcedure); _cmd.Parameters.Add(base.AddParameter("@Param1", value)); base.Connection.Open(); object res = _cmd.ExecuteScalar(); result = (string)res; } catch (Exception ex) { SAFLOGGER.Write(SAFLOGGER.LOGGEREventID.EXCEPTION, "SAFCORE", new string[] { "http://sfexpand.SAFCore.TokensValidatorDAO.softfinanca.com/", Assembly.GetExecutingAssembly().FullName.ToString(), ex.ToString() }); result = null; } finally { if (_cmd != null) { _cmd.Dispose(); } base.CloseConnection(); } return(result); }
public OperationResult newTokenFromPreInsertedSeed(string tokenParamsID, out TokenInfoCore tokenInfoCore) { IDbCommand dbCommand = null; tokenInfoCore = new TokenInfoCore(); OperationResult result; try { base.ConnectionString = DBConnectionString.ExpandSAFCore(); dbCommand = base.CreateCommand("FreeSeedUpdateForNewToken", CommandType.StoredProcedure); dbCommand.Parameters.Add(base.AddParameter("@Param0", 1)); dbCommand.Parameters.Add(base.AddParameter("@Param1", 99)); dbCommand.Parameters.Add(base.AddParameter("@Param2", tokenParamsID)); base.Connection.Open(); object obj = dbCommand.ExecuteScalar(); if (obj == DBNull.Value) { result = OperationResult.Error; } else { if (obj.ToString() == "0") { 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::newTokenFromPreInsertedSeed[", 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 string tokenID) { tokenID = null; IDbCommand dbCommand = null; OperationResult result; try { base.ConnectionString = DBConnectionString.ExpandSAFCore(); dbCommand = base.CreateCommand("InsertNewToken", CommandType.StoredProcedure); dbCommand.Parameters.Add(base.AddParameter("@tkStatus", 0)); dbCommand.Parameters.Add(base.AddParameter("@tkParamsID", tokenParamsID)); dbCommand.Parameters.Add(base.AddParameter("@tkMovingFactor", movingFactor)); dbCommand.Parameters.Add(base.AddParameter("@tkExpirationDate", expirationDate)); dbCommand.Parameters.Add(base.AddParameter("@tkCryptoKey", cryptoKey)); dbCommand.Parameters.Add(base.AddParameter("@tkCreationLotID", creationLotID)); dbCommand.Parameters.Add(base.AddParameter("@tkSupplierSerialNumber", supplierSerialNumber)); dbCommand.Parameters.Add(base.AddParameter("@tkInternalSerialNumber", internalSerialNumber)); dbCommand.Parameters.Add(base.AddParameter("@tkSupportCriptoData", SupportCryptoData)); dbCommand.Parameters.Add(base.AddParameter("@tokenSubLotID", null)); base.Connection.Open(); long num = long.Parse(dbCommand.ExecuteScalar().ToString()); if (num == 1L) { tokenID = num.ToString(); result = OperationResult.Success; } else { result = OperationResult.Error; } } catch (Exception ex) { LOGGER.Write(LOGGER.LogCategory.ERROR, string.Concat(new string[] { "SF.Expand.SAF.Core.TokensDAO::createToken[", tokenParamsID, "]", Environment.NewLine, ex.ToString() }), null); result = OperationResult.Error; } finally { if (dbCommand != null) { dbCommand.Dispose(); } base.CloseConnection(); } return(result); }
public OperationResult newTokenFromGivenSupplierSerialNumber(string tokenParamsID, string SupplierSerialNumber, out TokenInfoCore tokenInfoCore) { IDbCommand _cmd = null; tokenInfoCore = new TokenInfoCore(); OperationResult result; try { base.ConnectionString = DBConnectionString.ExpandSAFCore(); _cmd = base.CreateCommand("GivenSupplierSerialNumberUpdateForNewToken", CommandType.StoredProcedure); _cmd.Parameters.Add(base.AddParameter("@Param0", 1)); _cmd.Parameters.Add(base.AddParameter("@Param1", 99)); _cmd.Parameters.Add(base.AddParameter("@Param2", tokenParamsID)); _cmd.Parameters.Add(base.AddParameter("@Param3", SupplierSerialNumber)); base.Connection.Open(); object _retID = _cmd.ExecuteScalar(); if (_retID == DBNull.Value || (int)_retID == 0) { SAFLOGGER.Write(SAFLOGGER.LOGGEREventID.WARNING, "SAFCORE", new string[] { "http://sfexpand.SAFCore.TokensDAO.softfinanca.com/newTokenFromGivenSupplierSerialNumber", OperationResult.TokenVendorSeedNotAvaliable.ToString() }); result = OperationResult.TokenVendorSeedNotAvaliable; } else { tokenInfoCore = this.loadTokenInfoCore(_retID.ToString()); 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 OperationResult createToken(string tokenParamsID, long movingFactor, DateTime expirationDate, string cryptoKey, string supplierSerialNumber, string internalSerialNumber, string creationLotID, string SupportCryptoData, out string tokenID) { tokenID = null; IDbCommand _cmd = null; OperationResult result; 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()); if (_hResult == 1L) { tokenID = _hResult.ToString(); result = OperationResult.Success; } else { result = 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 createSubLotByTokenVendor(long numberOfTokensInLot, string tokenParamsID, string subLotID, DateTime expirationDate, out long numberOfSeeds) { IDbCommand dbCommand = null; IDbCommand dbCommand2 = null; numberOfSeeds = -1L; string value = BaseFunctions.GenerateSupplierLotNumber(numberOfTokensInLot.ToString(), null); OperationResult result; try { base.ConnectionString = DBConnectionString.ExpandSAFCore(); base.Connection.Open(); dbCommand = base.CreateCommand("CheckAvailableSeedsByTokenParamsID", CommandType.StoredProcedure); dbCommand.Parameters.Add(base.AddParameter("@Param0", tokenParamsID)); numberOfSeeds = (long)((int)dbCommand.ExecuteScalar()); if (numberOfSeeds < numberOfTokensInLot) { result = OperationResult.TokenVendorSeedNotAvaliable; } else { dbCommand2 = base.CreateCommand("CreateSupplierSubLot", CommandType.StoredProcedure); dbCommand2.Parameters.Add(base.AddParameter("@Param0", value)); dbCommand2.Parameters.Add(base.AddParameter("@Param1", expirationDate)); dbCommand2.Parameters.Add(base.AddParameter("@Param2", tokenParamsID)); dbCommand2.Parameters.Add(base.AddParameter("@top", (int)numberOfTokensInLot)); numberOfSeeds = (long)dbCommand2.ExecuteNonQuery(); result = OperationResult.Success; } } catch (Exception ex) { LOGGER.Write(LOGGER.LogCategory.ERROR, "SF.Expand.SAF.Core.TokensDAO::createNewTokenVendorSubLot[]" + Environment.NewLine + ex.ToString(), null); result = OperationResult.Error; } finally { if (dbCommand != null) { dbCommand.Dispose(); } if (dbCommand2 != null) { dbCommand2.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 OperationResult loadSupplierLots(string tokenParamsID, out DataTable dataTable) { DataSet dataSet = new DataSet(); IDbCommand dbCommand = null; OperationResult result; try { base.ConnectionString = DBConnectionString.ExpandSAFCore(); if (tokenParamsID != null || tokenParamsID.Trim().Length > 1) { dbCommand = base.CreateCommand("TokenSupplierLotCountByTokenParamsID", CommandType.StoredProcedure); dbCommand.Parameters.Add(base.AddParameter("@Param0", tokenParamsID)); } else { dbCommand = base.CreateCommand("TokenSupplierLot", 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::loadSupplierLots[]" + Environment.NewLine + ex.ToString(), null); result = OperationResult.Error; } finally { if (dbCommand != null) { dbCommand.Dispose(); } if (dataSet != null) { dataSet.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 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 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 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 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); }