public void Process(IEnumerable <FinActivity> activityMaps)
{
var sourceObjCount = GetSourceObjectCount();
if (sourceObjCount == 0)
{
return;
}
var sqlUtil = new SqlProcessorUtil(objSpace.Session);
var clauses = CreateSqlParameters();
var parameters = sqlUtil.CreateParameters(clauses);
var commandText = CreateProcessCommandText(activityMaps);
var conn = (SqlConnection)objSpace.Session.Connection;
var command = conn.CreateCommand();
command.CommandTimeout = CashDiscipline.Common.Constants.SqlCommandTimeout;
command.Parameters.AddRange(parameters.ToArray());
command.CommandText = commandText;
try
{
int result = command.ExecuteNonQuery();
}
catch (SqlException ex)
{
throw new InvalidOperationException(ex.Message + "\r\nLine Number " + ex.LineNumber
+ ". \r\n## SQL BEGIN ##\r\n" + command.CommandText + "\r\n## SQL END ##", ex);
}
}
public void Process()
{
var sqlUtil = new SqlProcessorUtil(objSpace.Session);
//var clauses = CreateSqlParameters();
//var parameters = sqlUtil.CreateParameters(clauses);
var commandText = CreateProcessCommandText();
var conn = (SqlConnection)objSpace.Session.Connection;
var command = conn.CreateCommand();
//command.Parameters.AddRange(parameters.ToArray());
command.CommandText = commandText;
int result = command.ExecuteNonQuery();
}
private int GetSourceObjectCount()
{
var sqlUtil = new SqlProcessorUtil(objSpace.Session);
var clauses = CreateSqlParameters();
var parameters = sqlUtil.CreateParameters(clauses);
var commandText = "SELECT COUNT(*) "
+ FilterCommandTextTemplate.Replace("{JG}", JournalGroupsParamText);
var conn = (SqlConnection)objSpace.Session.Connection;
var command = conn.CreateCommand();
command.Parameters.AddRange(parameters.ToArray());
command.CommandText = commandText;
return(Convert.ToInt32(command.ExecuteScalar()));
}
