private void InitializeDynamicFields(Form form)
{
foreach (var section in form.Sections)
{
foreach (var field in section.Fields)
{
if (!string.IsNullOrWhiteSpace(field.OptionListType) && field.OptionListType.Equals(OptionType.SQL))
{
string sql = field.OptionListStatement;
string optionList = _formInstanceHelper.ExecuteSQL(new SQLData
{
Parameters = null,
Query = sql,
ReturnColumn = "_sequenceid"
});
if (!string.IsNullOrWhiteSpace(optionList))
{
field.OptionList = JsonConvert.DeserializeObject <List <Option> >(optionList);
}
else
{
field.OptionList = new List <Option>();
}
field.OptionListType = null;
field.OptionListStatement = null;
}
}
}
}
