public int AddField(string fieldTitle, int before, string helpText, bool required, string fieldType,
string Default, bool visible, bool showOnEdit, bool searchable, bool isPrivateColumn,
bool multipleValues, string inputSettings, string outputSettings, bool normalizeFlag,
string validationRule, string validationMessage, string editStyle)
{
return(FieldController.AddField(ModuleId, fieldTitle, before, helpText, required, fieldType, Default, visible, showOnEdit, searchable, isPrivateColumn, multipleValues, inputSettings, outputSettings, normalizeFlag, validationRule, validationMessage, editStyle));
}
void UpdateField()
{
var fieldOrder = (int)DataSource[FieldsTableColumn.Order];
var newFieldType = cboFieldType.SelectedItem.Value;
var newHelpText = txtHelpText.Text.Trim();
var fieldTitle = GetFieldTitle();
var inputSettings = GetInputSettings();
var formerTitle = DataSource[FieldsTableColumn.Title].AsString();
var formerType = DataType.ByName(DataSource[FieldsTableColumn.Type].AsString());
var id = DataSource[FieldsTableColumn.Id].AsInt();
if (IsAllowedFieldTitle(fieldTitle) && IsUniqueFieldTitle(fieldTitle, formerTitle))
{
if (formerType.IsUserDefinedField)
{
if (IsNewField(id))
{
id = FieldController.AddField(ModuleContext.ModuleId, fieldTitle,
fieldOrder, newHelpText,
chkRequired.Checked, newFieldType, txtDefault.Text,
chkDisplayOnList.Checked, chkShowOnEdit.Checked,
chkSearchable.Checked, chkRestrictedFormField.Checked,
chkMultipleValues.Checked, inputSettings,
txtOutputSettings.Text, chkNormalizeFlag.Checked,
txtValidationRule.Text, txtValidationMessage.Text,
txtEditStyle.Text);
if (txtDefault.Text != "")
{
new UserDefinedTableController(ModuleContext).FillDefaultData(id, txtDefault.Text);
}
}
else
{
FieldController.UpdateField(id, fieldTitle, newHelpText, chkRequired.Checked,
newFieldType, txtDefault.Text, chkDisplayOnList.Checked,
chkShowOnEdit.Checked, chkSearchable.Checked,
chkRestrictedFormField.Checked, chkMultipleValues.Checked,
inputSettings,
txtOutputSettings.Text, chkNormalizeFlag.Checked,
txtValidationRule.Text, txtValidationMessage.Text,
txtEditStyle.Text);
}
}
else
{
FieldController.UpdateField(id,
fieldTitle, newHelpText, true, formerType.Name, string.Empty,
chkDisplayOnList.Checked, chkShowOnEdit.Checked, chkSearchable.Checked,
chkRestrictedFormField.Checked, false,
string.Empty,
txtOutputSettings.Text, chkNormalizeFlag.Checked,
string.Empty, string.Empty, string.Empty);
}
}
ListFieldSettings.Update(id, DataType.ByName(newFieldType));
FormFieldSettings.Update(id, DataType.ByName(newFieldType));
}
DataSet CreateFields(IEnumerable <string> columns, UserDefinedTableController udtController)
{
udtController.ResetModule();
FieldController.GetFieldsTable(ModuleId);
foreach (var column in columns)
{
FieldController.AddField(ModuleId, column);
}
return(udtController.GetRow(-1, false));
}
static void AddFields(int moduleId, DataSet ds)
{
var fieldIndex = ds.Tables[DataSetTableName.Fields].Rows.Count;
var fieldSettings = ds.Tables[DataSetTableName.FieldSettings];
foreach (DataRow row in ds.Tables[DataSetTableName.Fields].Rows)
{
var oldFieldId = row[FieldsTableColumn.Id].AsInt( );
var newFieldId =
FieldController.AddField(moduleId, row[FieldsTableColumn.Title].ToString(),
row.AsString(FieldsTableColumn.Order).AsInt(fieldIndex),
row.AsString((FieldsTableColumn.HelpText)),
row.AsString(FieldsTableColumn.Required).AsBoolean(),
row.AsString((FieldsTableColumn.Type)),
row.AsString((FieldsTableColumn.Default)),
row.AsString(FieldsTableColumn.Visible).AsBoolean(),
row.AsString(FieldsTableColumn.ShowOnEdit).AsBoolean(true),
row.AsString(FieldsTableColumn.Searchable).AsBoolean(),
row.AsString(FieldsTableColumn.IsPrivate).AsBoolean(),
row.AsString(FieldsTableColumn.MultipleValues).AsBoolean(),
row.AsString((FieldsTableColumn.InputSettings)),
row.AsString((FieldsTableColumn.OutputSettings)),
row.AsString(FieldsTableColumn.NormalizeFlag).AsBoolean(),
row.AsString((FieldsTableColumn.ValidationRule)),
row.AsString((FieldsTableColumn.ValidationMessage)),
row.AsString((FieldsTableColumn.EditStyle)));
if (fieldSettings != null)
{
foreach (DataRowView setting in fieldSettings.WithFieldId(oldFieldId))
{
FieldSettingsController.UpdateFieldSetting(
(string)setting["SettingName"],
(string)setting["SettingValue"],
newFieldId);
}
}
row[FieldsTableColumn.Id] = newFieldId;
fieldIndex--;
}
}
public int AddField(string fieldtitle)
{
return(FieldController.AddField(ModuleId, fieldtitle));
}
