public static OperationResult tokenTANFetchMatrixValues(LoteType loteType, string lotID, string TokenVendorID)
{
DataTable _dt = null;
TokenTypeBaseParams _tkBaseParams = default(TokenTypeBaseParams);
string _masterKey = SAFConfiguration.readMasterKey();
string _exportFilePath = SAFConfiguration.readParameterExternal("ExportFilePath");
SAFLOGGERInMEMORY logger = SAFLOGGERInMEMORY.GetLogString(_exportFilePath + "\\" + lotID.Trim() + ".DAT", false);
logger.Clear();
OperationResult result;
try
{
_tkBaseParams = new TokenParamsDAO().loadTokenBaseParams(TokenVendorID);
if (_tkBaseParams.TokenTypeBaseParamsID == null || _tkBaseParams.MovingFactorType != TokenMovingFactorType.TransactionAuthenticationNumber)
{
result = OperationResult.Error;
}
else
{
if (OperationResult.Error == new TokensDAO().loadTableWithTokensLot(loteType, lotID, TokenVendorID, TokenMovingFactorType.TransactionAuthenticationNumber, out _dt))
{
result = OperationResult.Error;
}
else
{
foreach (DataRow row in _dt.Rows)
{
TokenCryptoData _tkCryptoData = new TokenCryptoData(row[5].ToString(), row[0].ToString(), new CryptoData((long)row[1], row[2].ToString().Trim(), row[3].ToString().Trim(), (row[6] != null) ? row[6].ToString().Trim() : string.Empty), _tkBaseParams);
logger.Add(_tkCryptoData.SupplierSerialNumber + ";" + string.Join(";", TokensBaseFunctions.tokenTANMatrixArrayFetch(_tkCryptoData, _masterKey, null)));
}
logger.Persist();
result = OperationResult.Success;
}
}
}
catch (Exception ex)
{
SAFLOGGER.Write(SAFLOGGER.LOGGEREventID.EXCEPTION, "SAFCORE", new string[]
{
"http://sfexpand.SAFCore.TokensBaseFunctions.softfinanca.com/",
Assembly.GetExecutingAssembly().FullName.ToString(),
ex.ToString()
});
result = OperationResult.Error;
}
finally
{
_dt = null;
//TokenCryptoData _tkCryptoData = default(TokenCryptoData);
_tkBaseParams = default(TokenTypeBaseParams);
}
return(result);
}
public static OperationResult tokenTANFetchSupplierSerialNumber(LoteType loteType, string lotID, string TokenVendorID)
{
DataTable _dt = null;
TokenTypeBaseParams _tkBaseParams = default(TokenTypeBaseParams);
string _exportFilePath = SAFConfiguration.readParameterExternal("ExportFilePath");
SAFLOGGERInMEMORY logger = SAFLOGGERInMEMORY.GetLogString(_exportFilePath + "\\" + lotID.Trim() + "SerialNumbers.TXT", false);
logger.Clear();
OperationResult result;
try
{
_tkBaseParams = new TokenParamsDAO().loadTokenBaseParams(TokenVendorID);
if (_tkBaseParams.TokenTypeBaseParamsID == null || _tkBaseParams.MovingFactorType != TokenMovingFactorType.TransactionAuthenticationNumber)
{
result = OperationResult.Error;
}
else
{
if (OperationResult.Error == new TokensDAO().tokenSupplierSerialNumbersByLot(loteType, lotID, out _dt))
{
result = OperationResult.Error;
}
else
{
foreach (DataRow row in _dt.Rows)
{
logger.Add(row[0].ToString().Trim());
}
logger.Persist();
result = OperationResult.Success;
}
}
}
catch (Exception ex)
{
SAFLOGGER.Write(SAFLOGGER.LOGGEREventID.EXCEPTION, "SAFCORE", new string[]
{
"http://sfexpand.SAFCore.TokensBaseFunctions.softfinanca.com/",
Assembly.GetExecutingAssembly().FullName.ToString(),
ex.ToString()
});
result = OperationResult.Error;
}
finally
{
_dt = null;
logger = null;
_tkBaseParams = default(TokenTypeBaseParams);
}
return(result);
}
public static OperationResult tokenTANFetchMatrixValues(LoteType loteType, string lotID, string TokenVendorID)
{
DataTable _dt = null;
TokenTypeBaseParams _tkBaseParams = default(TokenTypeBaseParams);
string _masterKey = SAFConfiguration.readMasterKey();
string _exportFilePath = SAFConfiguration.readParameterExternal("ExportFilePath");
SAFLOGGERInMEMORY logger = SAFLOGGERInMEMORY.GetLogString(_exportFilePath + "\\" + lotID.Trim() + ".DAT", false);
logger.Clear();
OperationResult result;
try
{
_tkBaseParams = new TokenParamsDAO().loadTokenBaseParams(TokenVendorID);
if (_tkBaseParams.TokenTypeBaseParamsID == null || _tkBaseParams.MovingFactorType != TokenMovingFactorType.TransactionAuthenticationNumber)
{
result = OperationResult.Error;
}
else
{
if (OperationResult.Error == new TokensDAO().loadTableWithTokensLot(loteType, lotID, TokenVendorID, TokenMovingFactorType.TransactionAuthenticationNumber, out _dt))
{
result = OperationResult.Error;
}
else
{
foreach (DataRow row in _dt.Rows)
{
TokenCryptoData _tkCryptoData = new TokenCryptoData(row[5].ToString(), row[0].ToString(), new CryptoData((long)row[1], row[2].ToString().Trim(), row[3].ToString().Trim(), (row[6] != null) ? row[6].ToString().Trim() : string.Empty), _tkBaseParams);
logger.Add(_tkCryptoData.SupplierSerialNumber + ";" + string.Join(";", TokensBaseFunctions.tokenTANMatrixArrayFetch(_tkCryptoData, _masterKey, null)));
}
logger.Persist();
result = OperationResult.Success;
}
}
}
catch (Exception ex)
{
SAFLOGGER.Write(SAFLOGGER.LOGGEREventID.EXCEPTION, "SAFCORE", new string[]
{
"http://sfexpand.SAFCore.TokensBaseFunctions.softfinanca.com/",
Assembly.GetExecutingAssembly().FullName.ToString(),
ex.ToString()
});
result = OperationResult.Error;
}
finally
{
_dt = null;
//TokenCryptoData _tkCryptoData = default(TokenCryptoData);
_tkBaseParams = default(TokenTypeBaseParams);
}
return result;
}
public static OperationResult tokenTANFetchSupplierSerialNumber(LoteType loteType, string lotID, string TokenVendorID)
{
DataTable _dt = null;
TokenTypeBaseParams _tkBaseParams = default(TokenTypeBaseParams);
string _exportFilePath = SAFConfiguration.readParameterExternal("ExportFilePath");
SAFLOGGERInMEMORY logger = SAFLOGGERInMEMORY.GetLogString(_exportFilePath + "\\" + lotID.Trim() + "SerialNumbers.TXT", false);
logger.Clear();
OperationResult result;
try
{
_tkBaseParams = new TokenParamsDAO().loadTokenBaseParams(TokenVendorID);
if (_tkBaseParams.TokenTypeBaseParamsID == null || _tkBaseParams.MovingFactorType != TokenMovingFactorType.TransactionAuthenticationNumber)
{
result = OperationResult.Error;
}
else
{
if (OperationResult.Error == new TokensDAO().tokenSupplierSerialNumbersByLot(loteType, lotID, out _dt))
{
result = OperationResult.Error;
}
else
{
foreach (DataRow row in _dt.Rows)
{
logger.Add(row[0].ToString().Trim());
}
logger.Persist();
result = OperationResult.Success;
}
}
}
catch (Exception ex)
{
SAFLOGGER.Write(SAFLOGGER.LOGGEREventID.EXCEPTION, "SAFCORE", new string[]
{
"http://sfexpand.SAFCore.TokensBaseFunctions.softfinanca.com/",
Assembly.GetExecutingAssembly().FullName.ToString(),
ex.ToString()
});
result = OperationResult.Error;
}
finally
{
_dt = null;
logger = null;
_tkBaseParams = default(TokenTypeBaseParams);
}
return result;
}
public static OperationResult tokenTANFetchMatrixValues(LoteType loteType, string lotID, string TokenVendorID)
{
DataTable dataTable = null;
TokenTypeBaseParams tokenTypeBaseParams = default(TokenTypeBaseParams);
string str = SAFConfiguration.readParameterExternal("ExportFilePath");
InMemoryLogging logString = InMemoryLogging.GetLogString(str + "\\" + lotID.TrimEnd(new char[]
{
' '
}) + ".DAT", false);
string masterKey = SAFConfiguration.readMasterKey();
OperationResult result;
try
{
tokenTypeBaseParams = new TokenParamsDAO().loadTokenBaseParams(TokenVendorID);
if (tokenTypeBaseParams.TokenTypeBaseParamsID == null || tokenTypeBaseParams.MovingFactorType != TokenMovingFactorType.TransactionAuthenticationNumber)
{
result = OperationResult.Error;
}
else
{
if (OperationResult.Error == new TokensDAO().loadTableWithTokensLot(loteType, lotID, TokenVendorID, TokenMovingFactorType.TransactionAuthenticationNumber, out dataTable))
{
result = OperationResult.Error;
}
else
{
foreach (DataRow dataRow in dataTable.Rows)
{
TokenCryptoData tokenCryptoData = new TokenCryptoData(dataRow[5].ToString(), dataRow[0].ToString(), new CryptoData((long)dataRow[1], dataRow[2].ToString().Trim(), dataRow[3].ToString().Trim(), (dataRow[6] != null) ? dataRow[6].ToString().Trim() : string.Empty), tokenTypeBaseParams);
logString.Add(tokenCryptoData.SupplierSerialNumber + ";" + string.Join(";", TokensBaseFunctions.tokenTANMatrixArrayFetch(tokenCryptoData, masterKey, null)));
}
logString.Persist();
result = OperationResult.Success;
}
}
}
catch (Exception logObject)
{
LOGGER.Write(LOGGER.LogCategory.ERROR, "SF.Expand.SAF.Core::tokenTANFetchMatcrixValues[]", logObject);
result = OperationResult.Error;
}
return(result);
}
public static OperationResult tokenTANFetchMatrixValues(LoteType loteType, string lotID, string TokenVendorID)
{
DataTable dataTable = null;
TokenTypeBaseParams tokenTypeBaseParams = default(TokenTypeBaseParams);
string str = SAFConfiguration.readParameterExternal("ExportFilePath");
InMemoryLogging logString = InMemoryLogging.GetLogString(str + "\\" + lotID.TrimEnd(new char[]
{
' '
}) + ".DAT", false);
string masterKey = SAFConfiguration.readMasterKey();
OperationResult result;
try
{
tokenTypeBaseParams = new TokenParamsDAO().loadTokenBaseParams(TokenVendorID);
if (tokenTypeBaseParams.TokenTypeBaseParamsID == null || tokenTypeBaseParams.MovingFactorType != TokenMovingFactorType.TransactionAuthenticationNumber)
{
result = OperationResult.Error;
}
else
{
if (OperationResult.Error == new TokensDAO().loadTableWithTokensLot(loteType, lotID, TokenVendorID, TokenMovingFactorType.TransactionAuthenticationNumber, out dataTable))
{
result = OperationResult.Error;
}
else
{
foreach (DataRow dataRow in dataTable.Rows)
{
TokenCryptoData tokenCryptoData = new TokenCryptoData(dataRow[5].ToString(), dataRow[0].ToString(), new CryptoData((long)dataRow[1], dataRow[2].ToString().Trim(), dataRow[3].ToString().Trim(), (dataRow[6] != null) ? dataRow[6].ToString().Trim() : string.Empty), tokenTypeBaseParams);
logString.Add(tokenCryptoData.SupplierSerialNumber + ";" + string.Join(";", TokensBaseFunctions.tokenTANMatrixArrayFetch(tokenCryptoData, masterKey, null)));
}
logString.Persist();
result = OperationResult.Success;
}
}
}
catch (Exception logObject)
{
LOGGER.Write(LOGGER.LogCategory.ERROR, "SF.Expand.SAF.Core::tokenTANFetchMatcrixValues[]", logObject);
result = OperationResult.Error;
}
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 static OperationResult tokenTANFetchSupplierSerialNumber(LoteType loteType, string lotID, string TokenVendorID)
{
DataTable dataTable = null;
TokenTypeBaseParams tokenTypeBaseParams = default(TokenTypeBaseParams);
InMemoryLogging logString = InMemoryLogging.GetLogString(lotID.Trim() + "SerialNumbers.TXT", false);
OperationResult result;
try
{
tokenTypeBaseParams = new TokenParamsDAO().loadTokenBaseParams(TokenVendorID);
if (tokenTypeBaseParams.TokenTypeBaseParamsID == null || tokenTypeBaseParams.MovingFactorType != TokenMovingFactorType.TransactionAuthenticationNumber)
{
result = OperationResult.Error;
}
else
{
if (OperationResult.Error == new TokensDAO().tokenSupplierSerialNumbersByLot(loteType, lotID, out dataTable))
{
result = OperationResult.Error;
}
else
{
foreach (DataRow dataRow in dataTable.Rows)
{
logString.Add(dataRow[0].ToString().Trim());
}
logString.Persist();
result = OperationResult.Success;
}
}
}
catch
{
LOGGER.Write(LOGGER.LogCategory.ERROR, "SF.Expand.SAF.Core::tokenTANFetchSupplierSerialNumber[]", null);
result = OperationResult.Error;
}
return(result);
}
public static OperationResult tokenTANFetchSupplierSerialNumber(LoteType loteType, string lotID, string TokenVendorID)
{
DataTable dataTable = null;
TokenTypeBaseParams tokenTypeBaseParams = default(TokenTypeBaseParams);
InMemoryLogging logString = InMemoryLogging.GetLogString(lotID.Trim() + "SerialNumbers.TXT", false);
OperationResult result;
try
{
tokenTypeBaseParams = new TokenParamsDAO().loadTokenBaseParams(TokenVendorID);
if (tokenTypeBaseParams.TokenTypeBaseParamsID == null || tokenTypeBaseParams.MovingFactorType != TokenMovingFactorType.TransactionAuthenticationNumber)
{
result = OperationResult.Error;
}
else
{
if (OperationResult.Error == new TokensDAO().tokenSupplierSerialNumbersByLot(loteType, lotID, out dataTable))
{
result = OperationResult.Error;
}
else
{
foreach (DataRow dataRow in dataTable.Rows)
{
logString.Add(dataRow[0].ToString().Trim());
}
logString.Persist();
result = OperationResult.Success;
}
}
}
catch
{
LOGGER.Write(LOGGER.LogCategory.ERROR, "SF.Expand.SAF.Core::tokenTANFetchSupplierSerialNumber[]", null);
result = OperationResult.Error;
}
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 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);
}
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 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 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;
}
