public OperationResult updateEventStatus(string tokenEventID, byte tokenStatus)
{
IDbCommand _cmd = null;
OperationResult result;
try
{
base.ConnectionString = DBConnectionString.ExpandSecureBusiness();
_cmd = base.CreateCommand("TokenEventsUpdateStatus", CommandType.StoredProcedure);
_cmd.Parameters.Add(base.AddParameter("@param1", tokenStatus));
_cmd.Parameters.Add(base.AddParameter("@param2", tokenEventID));
base.Connection.Open();
result = ((_cmd.ExecuteNonQuery() != 0) ? OperationResult.Success : 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 insertTokenEventFields(long tokenEventID, string tokenEventFields)
{
IDbCommand _cmd = null;
string[] _arrayEventFields = tokenEventFields.Split(new char[]
{
'|'
});
OperationResult result;
if (_arrayEventFields.Length % 2 != 0 || _arrayEventFields.Length < 4)
{
result = OperationResult.Error;
}
else
{
try
{
base.ConnectionString = DBConnectionString.ExpandSecureBusiness();
_cmd = base.CreateCommand("TokenEventsFieldsInsert", CommandType.StoredProcedure);
_cmd.Parameters.Add(base.AddParameter("@param0", tokenEventID));
_cmd.Parameters.Add(base.AddParameter("@param1", null));
_cmd.Parameters.Add(base.AddParameter("@param2", null));
base.Connection.Open();
for (int i = 0; i < _arrayEventFields.Length; i += 2)
{
((IDataParameter)_cmd.Parameters["@param1"]).Value = _arrayEventFields[i];
((IDataParameter)_cmd.Parameters["@param2"]).Value = _arrayEventFields[i + 1];
_cmd.ExecuteNonQuery();
}
result = OperationResult.Success;
}
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);
}
/// <summary>
/// </summary>
/// <param name="tokenParamsID"></param>
/// <param name="httpUserAgent"></param>
/// <param name="deployProcessor"></param>
/// <returns></returns>
public OperationResult loadDeployProcessorByHttpUserAgent(string tokenParamsID, string httpUserAgent, out string deployProcessor)
{
object _resp = null;
deployProcessor = null;
IDbCommand _cmd = null;
IDbCommand _cmdDefault = null;
try
{
this.ConnectionString = DBConnectionString.ExpandSecureBusiness();
_cmd = base.CreateCommand(cLOAD_CUSTOM_TEMPLATE_BY_USERAGENT, CommandType.Text);
_cmd.Parameters.Add(base.AddParameter("@param0", (object)tokenParamsID));
_cmd.Parameters.Add(base.AddParameter("@param1", (object)httpUserAgent));
this.Connection.Open();
_resp = (object)_cmd.ExecuteScalar();
if (_resp != null)
{
deployProcessor = _resp.ToString().Trim();
return(OperationResult.Success);
}
_cmdDefault = base.CreateCommand(cLOAD_DEFAULT_TEMPLATE_BY_TOKENPARAMSID, CommandType.Text);
_cmdDefault.Parameters.Add(base.AddParameter("@param0", (object)tokenParamsID));
_resp = (object)_cmdDefault.ExecuteScalar();
if (_resp != DBNull.Value)
{
deployProcessor = _resp.ToString().Trim();
return(OperationResult.Success);
}
return(OperationResult.Error);
}
catch (Exception ex)
{
LOGGER.Write(LOGGER.LogCategory.ERROR, _baseName + "loadDeployProcessorByHttpUserAgent[]" + NEW_LINE + ex.Message, null);
return(OperationResult.Error);
}
finally
{
if (_cmd != null)
{
_cmd.Dispose();
}
if (_cmdDefault != null)
{
_cmdDefault.Dispose();
}
this.CloseConnection();
}
}
public TokensEventFields[] loadAllTokenEventFields(long tokenEventID, string firstItem, int pageSize, int pageDirection, out int totRows)
{
totRows = -1;
IDbCommand _cmd = null;
IDataReader _dr = null;
List <TokensEventFields> _tokensEventsFields = new List <TokensEventFields>();
TokensEventFields[] result;
try
{
base.ConnectionString = DBConnectionString.ExpandSecureBusiness();
_cmd = base.CreateCommand("TokenEventsFields", CommandType.StoredProcedure);
_cmd.Parameters.Add(base.AddParameter("@Param0", tokenEventID));
base.Connection.Open();
_dr = _cmd.ExecuteReader(CommandBehavior.CloseConnection);
while (_dr.Read())
{
_tokensEventsFields.Add(TokensEventFields.loadTokensEventFields((long)_dr[0], (DateTime)_dr[1], (string)_dr[2], (string)_dr[3]));
}
result = _tokensEventsFields.ToArray();
}
catch (Exception ex)
{
SAFLOGGER.Write(SAFLOGGER.LOGGEREventID.EXCEPTION, "SAFBUSINESS", new string[]
{
"http://sfexpand.SAFBusiness.TokenBusinessDAO.softfinanca.com/",
Assembly.GetExecutingAssembly().FullName.ToString(),
ex.ToString()
});
result = null;
}
finally
{
if (_dr != null)
{
_dr.Dispose();
}
if (_cmd != null)
{
_cmd.Dispose();
}
base.CloseConnection();
}
return(result);
}
public TokensEvents[] loadAllEvents(DateTime dateInitial, DateTime dateFinal, string tokenParamsID, string operationID, string tokenID, string applicationUser, string eventOperationStatus, string firstItem, int pageSize, int pageDirection, out int totRows)
{
totRows = -1;
IDbCommand _cmd = null;
TokensEvents[] result;
try
{
base.ConnectionString = DBConnectionString.ExpandSecureBusiness();
_cmd = base.CreateCommand("GetTokensEventsPAG", CommandType.StoredProcedure);
_cmd.Parameters.Add(base.AddParameter("@InitialDate", dateInitial));
_cmd.Parameters.Add(base.AddParameter("@FinalDate", dateFinal));
_cmd.Parameters.Add(base.AddParameter("@TokenParamsID", tokenParamsID));
_cmd.Parameters.Add(base.AddParameter("@EventOperationID", operationID));
_cmd.Parameters.Add(base.AddParameter("@TokenID", tokenID));
_cmd.Parameters.Add(base.AddParameter("@ApplicationUser", applicationUser));
_cmd.Parameters.Add(base.AddParameter("@EventOperationStatus", eventOperationStatus));
this._PrepPagination(_cmd, int.Parse(firstItem), pageSize, pageDirection);
result = this._loadBusinessEvents(_cmd, out totRows);
}
catch (Exception ex)
{
SAFLOGGER.Write(SAFLOGGER.LOGGEREventID.EXCEPTION, "SAFBUSINESS", new string[]
{
"http://sfexpand.SAFBusiness.TokenBusinessDAO.softfinanca.com/",
Assembly.GetExecutingAssembly().FullName.ToString(),
ex.ToString()
});
result = null;
}
finally
{
if (_cmd != null)
{
_cmd.Dispose();
}
base.CloseConnection();
}
return(result);
}
public OperationResult loadDeployEventInfo(string deployEventID, out DataTable dataTable)
{
DataSet _ds = new DataSet("EventDeploy");
IDbCommand _cmd = null;
OperationResult result;
try
{
base.ConnectionString = DBConnectionString.ExpandSecureBusiness();
_cmd = base.CreateCommand("GetTokenIdByEventDeploy", CommandType.StoredProcedure);
_cmd.Parameters.Add(base.AddParameter("@param0", deployEventID));
base.CreateDataAdapter(_cmd).Fill(_ds);
dataTable = _ds.Tables[0];
result = OperationResult.Success;
}
catch (Exception ex)
{
SAFLOGGER.Write(SAFLOGGER.LOGGEREventID.EXCEPTION, "SAFBUSINESS", new string[]
{
"http://sfexpand.SAFBusiness.TokenBusinessDAO.softfinanca.com/",
Assembly.GetExecutingAssembly().FullName.ToString(),
ex.ToString()
});
dataTable = null;
result = OperationResult.Error;
}
finally
{
if (_cmd != null)
{
_cmd.Dispose();
}
if (_ds != null)
{
_ds.Dispose();
}
base.CloseConnection();
}
return(result);
}
public OperationResult insertTokenEvent(string tokenID, int eventOperation, int eventOperationStatus, string applicationUser, out long tokenEventID)
{
tokenEventID = -1L;
IDbCommand _cmd = null;
OperationResult result;
try
{
base.ConnectionString = DBConnectionString.ExpandSecureBusiness();
_cmd = base.CreateCommand("TokenEventsInsert", CommandType.StoredProcedure);
_cmd.Parameters.Add(base.AddParameter("@param1", tokenID));
_cmd.Parameters.Add(base.AddParameter("@param2", eventOperation));
_cmd.Parameters.Add(base.AddParameter("@param3", (byte)eventOperationStatus));
_cmd.Parameters.Add(base.AddParameter("@param4", applicationUser));
base.Connection.Open();
tokenEventID = long.Parse(_cmd.ExecuteScalar().ToString());
result = ((0L != tokenEventID) ? OperationResult.Success : 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);
}