private CdsEntity PrepareLoanForExecution(string cr_reference_id, ExecutionBase body, string dateField, string amountField, bool overwriteAmount = true)
{
var loanId = ParseGuid(cr_reference_id, "cr_reference_id");
ValidateCurrencyIsUSD(body.Currency, body.Amount?.Currency);
var loan = new CdsEntity()
{
Id = loanId
};
if (string.IsNullOrEmpty(dateField) == false)
{
SetDatetimeField(loan, body.ValueDate, "ValueDate", dateField);
}
if (string.IsNullOrEmpty(amountField) == false &&
string.IsNullOrEmpty(body?.Amount?.Value) == false)
{
if (decimal.TryParse(body.Amount.Value, out var amount) == false)
{
throw new Exception("Amount must be a valid decimal number.");
}
if (overwriteAmount == false)
{
var existingLoan = _cdsWebApi.Retrieve("msfsi_financialproducts", loanId,
amountField);
if (decimal.TryParse(existingLoan.Attributes[amountField]?.ToString(),
out var currentAmount))
{
amount += currentAmount;
}
}
loan.Attributes[amountField] = amount;
}
return(loan);
}
// public static ExecutionResult ExecRoutineQuery(
// Controllers.ExecController.ExecType type,
// string schemaName,
// string routineName,
// Endpoint endpoint,
// Dictionary<string, string> inputParameters,
// Dictionary<string, string> requestHeaders,
// string remoteIpAddress,
// List<ExecutionPlugin> plugins,
// int commandTimeOutInSeconds,
// out Dictionary<string, dynamic> outputParameterDictionary,
// ExecutionBase execRoutineQueryMetric,
// ref Dictionary<string, string> responseHeaders,
// out int rowsAffected
// )
public static async Task <ExecutionResult> ExecRoutineQueryAsync(
CancellationToken cancellationToken,
Controllers.ExecController.ExecType type,
string schemaName,
string routineName,
Endpoint endpoint,
Dictionary <string, string> inputParameters,
Dictionary <string, string> requestHeaders,
string remoteIpAddress,
List <ExecutionPlugin> plugins,
int commandTimeOutInSeconds,
ExecutionBase execRoutineQueryMetric,
Dictionary <string, string> responseHeaders
)
{
SqlConnection con = null;
SqlCommand cmd = null;
int rowsAffected = 0;
try
{
var s1 = execRoutineQueryMetric.BeginChildStage(string.Intern("Lookup cached routine"));
var cachedRoutine = endpoint.CachedRoutines.FirstOrDefault(r => r.Equals(schemaName, routineName));
if (cachedRoutine == null)
{
// TODO: Return 404 rather?
throw new Exception($"The routine [{schemaName}].[{routineName}] was not found.");
}
s1.End();
//
// jsDAL METADATA
//
{
var s2 = execRoutineQueryMetric.BeginChildStage("Process metadata");
string metaResp = null;
try
{
metaResp = ProcessMetadata(requestHeaders, ref responseHeaders, cachedRoutine);
}
catch (Exception) { /*ignore metadata failures*/ }
if (metaResp != null)
{
return(new ExecutionResult()
{
userError = metaResp
});
}
s2.End();
}
var s3 = execRoutineQueryMetric.BeginChildStage("Open connection");
var cs = endpoint.GetSqlConnection();
if (cs == null)
{
throw new Exception($"Execution connection not found on endpoint '{endpoint.Pedigree}'({endpoint.Id}).");
}
var csb = new SqlConnectionStringBuilder(cs.ConnectionStringDecrypted);
// {schemaName}.{routineName} -- including schema.routine will create too many unique connection pools
csb.ApplicationName = $"jsdal-server EXEC {endpoint.Pedigree}".Left(128);
con = new SqlConnection(csb.ToString());
if (endpoint.CaptureConnectionStats)
{
con.StatisticsEnabled = true;
con.ResetStatistics();
}
else
{
con.StatisticsEnabled = false;
}
await con.OpenAsync();
s3.End();
//
// PLUGINS
//
var s4 = execRoutineQueryMetric.BeginChildStage("Process plugins");
ProcessPlugins(plugins, con);
s4.End();
var prepareCmdMetric = execRoutineQueryMetric.BeginChildStage("Prepare command");
//
// CREATE SQL COMMAND
//
cmd = CreateSqlCommand(con, commandTimeOutInSeconds, cachedRoutine, type);
//
// PARAMETERS
//
SetupSqlCommandParameters(cmd, cachedRoutine, inputParameters, plugins, remoteIpAddress);
prepareCmdMetric.End();
Dictionary <string /*Table0..N*/, ReaderResult> readerResults = null;
//DataSet ds = null;
object scalarVal = null;
if (type == Controllers.ExecController.ExecType.Query)
{
var execStage = execRoutineQueryMetric.BeginChildStage("Execute Query");
readerResults = await ProcessExecQueryAsync(cancellationToken, cmd, inputParameters);
// { Old Dataset-based code
// var da = new SqlDataAdapter(cmd);
// ds = new DataSet();
// var firstTableRowsAffected = da.Fill(ds); // Fill only returns rows affected on first Table
// if (ds.Tables.Count > 0)
// {
// foreach (DataTable t in ds.Tables)
// {
// rowsAffected += t.Rows.Count;
// }
// }
// if (inputParameters.ContainsKey("$select") && ds.Tables.Count > 0)
// {
// string limitToFieldsCsv = inputParameters["$select"];
// if (!string.IsNullOrEmpty(limitToFieldsCsv))
// {
// var listPerTable = limitToFieldsCsv.Split(new char[] { ';' }/*, StringSplitOptions.RemoveEmptyEntries*/);
// for (int tableIx = 0; tableIx < listPerTable.Length; tableIx++)
// {
// var fieldsToKeep = listPerTable[tableIx].Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries).ToLookup(s => s.Trim());
// if (fieldsToKeep.Count > 0)
// {
// var table = ds.Tables[tableIx];
// for (int i = 0; i < table.Columns.Count; i++)
// {
// var match = fieldsToKeep.FirstOrDefault((k) => k.Key.Equals(table.Columns[i].ColumnName, StringComparison.OrdinalIgnoreCase));
// if (match == null)
// {
// table.Columns.Remove(table.Columns[i]);
// i--;
// }
// }
// }
// }
// }
// } // $select
// }
execStage.End();
}
else if (type == Controllers.ExecController.ExecType.NonQuery)
{
var execStage = execRoutineQueryMetric.BeginChildStage("Execute NonQuery");
rowsAffected = await cmd.ExecuteNonQueryAsync(cancellationToken);
execStage.End();
}
else if (type == Controllers.ExecController.ExecType.Scalar)
{
var execStage = execRoutineQueryMetric.BeginChildStage("Execute Scalar");
scalarVal = await cmd.ExecuteScalarAsync(cancellationToken);
execStage.End();
}
else
{
throw new NotSupportedException($"ExecType \"{type.ToString()}\" not supported");
}
long?bytesReceived = null;
long?networkServerTimeMS = null;
if (endpoint.CaptureConnectionStats)
{
RetrieveConnectionStatistics(con, out bytesReceived, out networkServerTimeMS);
}
var outputParameterDictionary = RetrieveOutputParameterValues(cachedRoutine, cmd);
//!executionTrackingEndFunction();
return(new ExecutionResult()
{
ReaderResults = readerResults,
DataSet = null, // deprecated
ScalarValue = scalarVal,
NetworkServerTimeInMS = networkServerTimeMS,
BytesReceived = bytesReceived,
RowsAffected = rowsAffected,
OutputParameterDictionary = outputParameterDictionary,
ResponseHeaders = responseHeaders
});
}
finally
{
cmd?.Dispose();
con?.Close();
con?.Dispose();
}
} // execRoutine
/// <summary>Creates service definition that can be registered with a server</summary>
public static ServerServiceDefinition BindService(ExecutionBase serviceImpl)
{
return(ServerServiceDefinition.CreateBuilder()
.AddMethod(__Method_execute, serviceImpl.execute).Build());
}
public void InitializeProgramArguments(ExecutionBase el, string dir, string serviceName)
{
el.Arguments = ActionName + " " + string.Join(" ", Arguments(serviceName));
el.Program = Program;
el.WorkDir = dir;
}
