public OperationResult Create(string tokenVendorID, DateTime expirationDate, string supplierSerialNumber, string creationLotID, string pin, out TokenInfoCore tokenInfoCore)
{
string _tokenBlob = null;
OperationResult result;
if (pin == null || (pin ?? "").Length < 2)
{
tokenInfoCore = new TokenInfoCore();
result = OperationResult.Error;
}
else
{
OperationResult _hResult = new TokensDAO().newTokenFromPreInsertedSeed(tokenVendorID, TokenStatus.ReadyToDeploy, out tokenInfoCore);
if (_hResult == OperationResult.Success)
{
IBLOBData _blobProcessor = BLOBDataFactory.LoadAssembly("SF.Expand.SAF.Blobs.BLOBStructInfSrv, SF.Expand.SAF.Blobs");
if (_blobProcessor.Export(pin, "J1", null, new TokensDAO().loadTokenCryptoData(tokenInfoCore.InternalID.ToString()), out _tokenBlob))
{
if (OperationResult.Success != new TokensDAO().updateCryptoData(tokenInfoCore.InternalID.ToString(), _tokenBlob))
{
this.UndoCreate(tokenInfoCore.InternalID.ToString());
_hResult = OperationResult.Error;
}
}
}
result = _hResult;
}
return result;
}
public OperationResult Create(string tokenVendorID, DateTime expirationDate, string supplierSerialNumber, string creationLotID, string pin, out TokenInfoCore tokenInfoCore)
{
//string criptoKey = "";
//long movingFactor = 0;
//string internalSerialNumber = "";
//string supportCriptoData = null;
////SF.Expand.SAF.Core.TokensBaseFunctions.TokensCreateNew(TokenSeedType.Dynamic,"", "", null,,
//return new TokensDAO().createToken(tokenVendorID, movingFactor, expirationDate, criptoKey, supplierSerialNumber, internalSerialNumber, creationLotID, supportCriptoData, out tokenInfoCore);
return new TokensDAO().newTokenFromGivenSupplierSerialNumber(tokenVendorID, supplierSerialNumber, out tokenInfoCore);
}
public OperationResult Create(string tokenVendorID, DateTime expirationDate, string supplierSerialNumber, string creationLotID, string pin, out TokenInfoCore tokenInfoCore)
{
OperationResult result;
try
{
string typeName = new TokensValidatorDAO().DeployAssemblyNameByTokenParamsID(tokenVendorID);
ITokens tokens = TokensFactory.LoadAssembly(typeName);
result = tokens.Create(tokenVendorID, expirationDate, supplierSerialNumber, creationLotID, pin, out tokenInfoCore);
}
catch (Exception innerException)
{
throw new Exception("SF.Expand.SAF.Core.PREProcessorTokens::Create[]", innerException);
}
return result;
}
public static TokenInfo loadTokenInfo(TokenStatus status, byte typeID, int internalID, string typeDescription, string applicationUser, string phoneNumberUser, string emailAddressUser, DateTime registeredTimeStamp, string internalSerialNumber, DateTime lastStatusTimeStamp, TokenInfoCore tokenInfoCore)
{
TokenInfo _newTkInfoBus = new TokenInfo();
_newTkInfoBus.Status = status;
_newTkInfoBus.TypeDescription = ((typeDescription == null) ? null : typeDescription.Trim());
_newTkInfoBus.ApplicationUser = ((applicationUser == null) ? null : applicationUser.Trim());
_newTkInfoBus.PhoneNumberUser = ((phoneNumberUser == null) ? null : phoneNumberUser.Trim());
_newTkInfoBus.EmailAddressUser = ((emailAddressUser == null) ? null : emailAddressUser.Trim());
_newTkInfoBus.RegisteredTimeStamp = registeredTimeStamp;
_newTkInfoBus.LastStatusChangedTimeStamp = lastStatusTimeStamp;
if (tokenInfoCore.InternalID == 0)
{
_newTkInfoBus.tokenInfoCore = TokenInfoCore.loadTokenInfoCore(typeID, internalID, null, null, internalSerialNumber, registeredTimeStamp, null, status);
}
else
{
_newTkInfoBus.tokenInfoCore = tokenInfoCore;
}
return _newTkInfoBus;
}
public static TokenInfo loadTokenInfo(TokenStatus status, byte typeID, int internalID, string typeDescription, string applicationUser, string phoneNumberUser, string emailAddressUser, DateTime registeredTimeStamp, string internalSerialNumber, DateTime lastStatusTimeStamp, TokenInfoCore tokenInfoCore)
{
TokenInfo _newTkInfoBus = new TokenInfo();
_newTkInfoBus.Status = status;
_newTkInfoBus.TypeDescription = ((typeDescription == null) ? null : typeDescription.Trim());
_newTkInfoBus.ApplicationUser = ((applicationUser == null) ? null : applicationUser.Trim());
_newTkInfoBus.PhoneNumberUser = ((phoneNumberUser == null) ? null : phoneNumberUser.Trim());
_newTkInfoBus.EmailAddressUser = ((emailAddressUser == null) ? null : emailAddressUser.Trim());
_newTkInfoBus.RegisteredTimeStamp = registeredTimeStamp;
_newTkInfoBus.LastStatusChangedTimeStamp = lastStatusTimeStamp;
if (tokenInfoCore.InternalID == 0)
{
_newTkInfoBus.tokenInfoCore = TokenInfoCore.loadTokenInfoCore(typeID, internalID, null, null, internalSerialNumber, registeredTimeStamp, null, status);
}
else
{
_newTkInfoBus.tokenInfoCore = tokenInfoCore;
}
return(_newTkInfoBus);
}
public OperationResult Create(string tokenVendorID, DateTime expirationDate, string supplierSerialNumber, string creationLotID, string pin, out TokenInfoCore tokenInfoCore)
{
tokenInfoCore = new TokenInfoCore();
OperationResult result;
try
{
string assemb = new TokensValidatorDAO().DeployAssemblyNameByTokenParamsID(tokenVendorID);
ITokens _tokens = TokensFactory.LoadAssembly(assemb);
if (_tokens == null)
{
SAFLOGGER.Write(SAFLOGGER.LOGGEREventID.ERROR, "SAFCORE", new string[]
{
"http://sfexpand.SAFCore.PREProcessorTokens.softfinanca.com/",
"[ITokens]::" + assemb.Trim(),
"Invalid or null typename!"
});
tokenInfoCore = new TokenInfoCore();
result = OperationResult.Error;
}
else
{
result = _tokens.Create(tokenVendorID, expirationDate, supplierSerialNumber, creationLotID, pin, out tokenInfoCore);
}
}
catch (Exception ex)
{
SAFLOGGER.Write(SAFLOGGER.LOGGEREventID.EXCEPTION, "SAFCORE", new string[]
{
"http://sfexpand.SAFCore.PREProcessorTokens.softfinanca.com/",
Assembly.GetExecutingAssembly().FullName.ToString(),
ex.ToString()
});
tokenInfoCore = new TokenInfoCore();
result = OperationResult.Error;
}
return result;
}
public OperationResult Create(string tokenVendorID, DateTime expirationDate, string supplierSerialNumber, string creationLotID, string pin, out TokenInfoCore tokenInfoCore)
{
return new TokensDAO().newTokenFromGivenSupplierSerialNumber(tokenVendorID, supplierSerialNumber, out tokenInfoCore);
}
public TokenInfo getTokenInfo(string tokenID, TokenInfoCore tokenInfoCore)
{
IDataReader _dr = null;
IDbCommand _cmd = null;
TokenInfo result;
try
{
base.ConnectionString = DBConnectionString.ExpandSecureBusiness();
_cmd = base.CreateCommand("GetTokenInfo", CommandType.StoredProcedure);
_cmd.Parameters.Add(base.AddParameter("@Param1", tokenID));
base.OpenConnection();
(_dr = _cmd.ExecuteReader(CommandBehavior.CloseConnection)).Read();
result = TokenInfo.loadTokenInfo((TokenStatus)((byte)_dr[2]), (byte)_dr[7], (int)_dr[0], (_dr[5] == DBNull.Value) ? "" : ((string)_dr[5]), (string)_dr[1], (_dr[3] == DBNull.Value) ? "" : ((string)_dr[3]), (_dr[6] == DBNull.Value) ? "" : ((string)_dr[6]), (DateTime)_dr[4], (string)_dr[8], (DateTime)_dr[11], tokenInfoCore);
}
catch (Exception ex)
{
SAFLOGGER.Write(SAFLOGGER.LOGGEREventID.EXCEPTION, "SAFBUSINESS", new string[]
{
"http://sfexpand.SAFBusiness.TokenBusinessDAO.softfinanca.com/",
Assembly.GetExecutingAssembly().FullName.ToString(),
ex.ToString()
});
result = new TokenInfo();
}
finally
{
if (_dr != null)
{
_dr.Dispose();
}
if (_cmd != null)
{
_cmd.Dispose();
}
base.CloseConnection();
}
return result;
}
public OperationResult insertTokenUser(TokenInfoCore tokenInfoCore, string applicationUser, string applicationPhoneNumber, string applicationEmail, out TokenInfo tokenInfo, out long tokenEventID)
{
tokenEventID = 0L;
IDbCommand _cmd = null;
tokenInfo = new TokenInfo();
OperationResult result;
try
{
base.ConnectionString = DBConnectionString.ExpandSecureBusiness();
_cmd = base.CreateCommand("TokenUserInsert", CommandType.StoredProcedure);
_cmd.Parameters.Add(base.AddParameter("@param1", tokenInfoCore.InternalID));
_cmd.Parameters.Add(base.AddParameter("@param2", tokenInfoCore.TypeID));
_cmd.Parameters.Add(base.AddParameter("@param3", tokenInfoCore.InternalStatus));
_cmd.Parameters.Add(base.AddParameter("@param4", applicationUser));
_cmd.Parameters.Add(base.AddParameter("@param5", applicationPhoneNumber));
_cmd.Parameters.Add(base.AddParameter("@param6", applicationEmail));
_cmd.Parameters.Add(base.AddParameter("@param7", tokenInfoCore.InternalSerialNumber));
_cmd.Parameters.Add(base.AddParameter("@param8", tokenInfoCore.SupplierSerialNumber));
_cmd.Parameters.Add(base.AddParameter("@param9", tokenInfoCore.SupplierLotID));
base.Connection.Open();
base.TransactionBegin(IsolationLevel.ReadCommitted);
_cmd.Transaction = base.Transaction;
if (1 == _cmd.ExecuteNonQuery())
{
if (OperationResult.Success == this._insertTokenEvent(tokenInfoCore.InternalID.ToString(), 100, 0, applicationUser, out tokenEventID))
{
if (tokenInfoCore.InternalStatus == TokenStatus.ReadyToDeploy)
{
if (OperationResult.Success != this._insertTokenEvent(tokenInfoCore.InternalID.ToString(), 98, 0, applicationUser, out tokenEventID))
{
result = OperationResult.Error;
return result;
}
}
base.TransactionCommit();
tokenInfo = this.getTokenInfo(tokenInfoCore.InternalID.ToString(), tokenInfoCore);
result = OperationResult.Success;
return result;
}
}
result = OperationResult.Error;
}
catch (Exception ex)
{
SAFLOGGER.Write(SAFLOGGER.LOGGEREventID.EXCEPTION, "SAFBUSINESS", new string[]
{
"http://sfexpand.SAFBusiness.TokenBusinessDAO.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 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 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 newTokenFromPreInsertedSeed(string tokenParamsID, TokenStatus newTokenStatus, out TokenInfoCore tokenInfoCore)
{
IDbCommand _cmd = null;
tokenInfoCore = new TokenInfoCore();
OperationResult result;
try
{
base.ConnectionString = DBConnectionString.ExpandSAFCore();
_cmd = base.CreateCommand("FreeSeedUpdateForNewToken", CommandType.StoredProcedure);
_cmd.Parameters.Add(base.AddParameter("@Param0", (byte)newTokenStatus));
_cmd.Parameters.Add(base.AddParameter("@Param1", 99));
_cmd.Parameters.Add(base.AddParameter("@Param2", tokenParamsID));
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/newTokenFromPreInsertedSeed",
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 newTokenFromPreInsertedSeed(string tokenParamsID, out TokenInfoCore tokenInfoCore)
{
return this.newTokenFromPreInsertedSeed(tokenParamsID, TokenStatus.Enabled, out tokenInfoCore);
}
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 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;
}
