///// <summary>
///// Write game settings to INI file.
///// </summary>
///// <param name="game"></param>
//public string GetIniContent(Game game)
//{
// // Get game directory.
// var dir = new FileInfo(game.FullPath).Directory;
// // Get INI file.
// var iniFile = dir.GetFiles(IniFileName).FirstOrDefault();
// var ini = new Ini(iniFile.FullName);
// var optionKeys = new[] { SettingName.PAD1, SettingName.PAD2, SettingName.PAD3, SettingName.PAD4 };
// for (int i = 0; i < optionKeys.Length; i++)
// {
// var optionKey = optionKeys[i];
// var mapTo = (MapTo)(i + 1);
// // Write PADx.
// var mapItem = SettingsMap.FirstOrDefault(x => x.IniSection == OptionsSection && x.IniKey == optionKey);
// WriteSettingsToIni(mapItem);
// var settings = SettingManager.Settings.Items.Where(x => x.MapTo == (int)mapTo).ToArray();
// for (int s = 0; s < settings.Length; s++)
// {
// var setting = settings[i];
// var padSetting = SettingManager.GetPadSetting(setting.PadSettingChecksum);
// var padSectionName = string.Format("IG_{0:N}", setting.InstanceGuid);
// WritePadSettingsToIni(padSectionName, setting, padSetting);
// }
// }
// return null;
//}
/// <summary>
/// Write game settings to INI file.
/// </summary>
/// <param name="game"></param>
public string GetIniContent2(UserGame game)
{
// Get game directory.
var dir = new FileInfo(game.FullPath).Directory;
// Get INI file.
var iniFile = dir.GetFiles(IniFileName).FirstOrDefault();
var ini = new Ini(iniFile.FullName);
var optionKeys = new[] { SettingName.PAD1, SettingName.PAD2, SettingName.PAD3, SettingName.PAD4 };
for (int i = 0; i < optionKeys.Length; i++)
{
var optionKey = optionKeys[i];
var mapTo = (MapTo)(i + 1);
// Write PADx.
var mapItem = SettingsMap.FirstOrDefault(x => x.IniSection == OptionsSection && x.IniKey == optionKey);
WriteSettingsToIni(mapItem);
var settings = SettingsManager.Settings.Items.Where(x => x.MapTo == (int)mapTo).ToArray();
for (int s = 0; s < settings.Length; s++)
{
var setting = settings[i];
var padSetting = SettingsManager.GetPadSetting(setting.PadSettingChecksum);
var padSectionName = string.Format("IG_{0:N}", setting.InstanceGuid);
WritePadSettingsToIni(padSectionName, setting, padSetting);
}
}
return(null);
}
public void SyncFormFromPadSetting(MapTo padIndex, PadSetting ps)
{
// Get setting maps for specified PAD Control.
var maps = SettingsMap.Where(x => x.MapTo == padIndex).ToArray();
PropertyInfo[] properties;
if (!ValidatePropertyNames(maps, out properties))
{
return;
}
// Suspend form events (do not track setting changes on the form).
SuspendEvents();
foreach (var p in properties)
{
var map = maps.FirstOrDefault(x => x.PropertyName == p.Name);
if (map == null)
{
continue;
}
var v = (string)p.GetValue(ps, null) ?? "";
// If value is not set then...
if (string.IsNullOrEmpty(v))
{
// Restore default value.
v = string.Format("{0}", map.DefaultValue ?? "");
}
LoadSetting(map.Control, map.PropertyName, v);
}
// Resume form events (track setting changes on the form).
ResumeEvents();
}
/// <summary>
/// Set/initialize all maps
/// </summary>
private void SetMaps()
{
HomePage = new HomePageMap();
Feed = new FeedMap();
LoginPage = new LoginMap();
Settings = new SettingsMap();
}
public string ConvertToIni(PadSetting ps)
{
var sb = new StringBuilder();
// Get settings related to PAD. Use Controller1 as reference.
var maps = SettingsMap.Where(x => x.MapTo == MapTo.Controller1).ToArray();
PropertyInfo[] properties;
if (!ValidatePropertyNames(maps, out properties))
{
return(null);
}
foreach (var p in properties)
{
var map = maps.First(x => x.PropertyName == p.Name);
var key = map.IniPath.Split('\\')[1];
// Get setting value from the pad setting.
var value = (string)p.GetValue(ps, null) ?? "";
if (!string.IsNullOrEmpty(value))
{
sb.AppendFormat("{0}={1}", key, value);
sb.AppendLine();
}
}
return(sb.ToString());
}
/// <summary>
/// Load PAD settings to form.
/// </summary>
/// <param name="padSetting">Settings to read.</param>
/// <param name="padIndex">Destination pad index.</param>
public void LoadPadSettings(MapTo padIndex, PadSetting padSetting)
{
// Get settings related to PAD.
var maps = SettingsMap.Where(x => x.MapTo == padIndex).ToArray();
PropertyInfo[] properties;
if (!ValidatePropertyNames(maps, out properties))
{
return;
}
// Suspend form events (do not track setting changes on the form).
SuspendEvents();
// If pad settings must be reset then load default.
var ps = padSetting == null ? new PadSetting() : padSetting;
foreach (var p in properties)
{
var map = maps.First(x => x.PropertyName == p.Name);
var key = map.IniPath.Split('\\')[1];
var v = (string)p.GetValue(ps, null) ?? "";
LoadSetting(map.Control, key, v);
}
// Resume form events (track setting changes on the form).
ResumeEvents();
loadCount++;
var ev = ConfigLoaded;
if (ev != null)
{
ev(this, new SettingEventArgs(typeof(PadSetting).Name, loadCount));
}
}
private void HydrateUiFromSettings(string settingsPath)
{
try
{
Settings = EarlyBoundGeneratorConfig.Load(settingsPath);
Settings.CrmSvcUtilRealtiveRootPath = Paths.PluginsPath;
SettingsMap = new SettingsMap(this, Settings)
{
SettingsPath = settingsPath
};
PropertiesGrid.SelectedObject = SettingsMap;
SkipSaveSettings = false;
}
catch (Exception ex)
{
TxtOutput.AppendText($"Unable to Load Settings from Config file: {settingsPath}. {ex}");
var result = MessageBox.Show(@"The Settings File is either empty or malformed. Would you like to reset the file to the default settings?", @"Unable to Load Settings!", MessageBoxButtons.YesNo, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1);
if (result == DialogResult.Yes)
{
Settings = EarlyBoundGeneratorConfig.GetDefault();
Settings.CrmSvcUtilRealtiveRootPath = Paths.PluginsPath;
}
else
{
SkipSaveSettings = true;
}
}
}
/// <summary>
/// Get PadSetting from currently selected device.
/// </summary>
/// <param name="padIndex">Source pad index.</param>
public PadSetting GetCurrentPadSetting(MapTo padIndex)
{
// Get settings related to PAD.
var maps = SettingsMap.Where(x => x.MapTo == padIndex).ToArray();
PropertyInfo[] properties;
if (!ValidatePropertyNames(maps, out properties))
{
return(null);
}
var ps = new PadSetting();
foreach (var p in properties)
{
var map = maps.First(x => x.PropertyName == p.Name);
var key = map.IniPath.Split('\\')[1];
// Get setting value from the form.
var v = GetSettingValue(map.Control);
// If value is default then...
if (v == map.DefaultValue as string)
{
// Remove default value.
v = null;
}
// Set value onto padSetting.
p.SetValue(ps, v ?? "", null);
}
ps.PadSettingChecksum = ps.CleanAndGetCheckSum();
return(ps);
}
/// <summary>
/// Read PAD settings from INI file.
/// </summary>
/// <param name="padSectionName">INI section.</param>
/// <param name="s">Settings.</param>
/// <param name="p">PAD Settings.</param>
/// <remarks>use 'ref' to indicate that objects will be updated inside.</remarks>
void ReadWritePadSettings(string padSectionName, ref Setting s, ref PadSetting p, bool write)
{
s = new Setting();
p = new PadSetting();
// Get PAD1 settings data as a reference.
var items = SettingsMap.Where(x => x.MapTo == MapTo.Controller1).ToArray();
var sProps = s.GetType().GetProperties();
var pProps = p.GetType().GetProperties();
var ini2 = new Ini(IniFileName);
foreach (var item in items)
{
string key = item.IniPath.Split('\\')[1];
// Try to find property inside Settings object.
var sProp = sProps.FirstOrDefault(x => x.Name == item.PropertyName);
if (sProp != null)
{
if (write)
{
var sv = (string)sProp.GetValue(s, null) ?? "";
// Write value to INI file.
ini2.SetValue(padSectionName, key, sv);
}
else
{
// Read value from INI file.
var sv = ini2.GetValue(padSectionName, key) ?? "";
sProp.SetValue(s, sv, null);
}
continue;
}
// Try to find property inside PAD Settings object.
var pProp = pProps.FirstOrDefault(x => x.Name == item.PropertyName);
if (pProp != null)
{
if (write)
{
var pv = (string)pProp.GetValue(p, null) ?? "";
// Write value to INI file.
ini2.SetValue(padSectionName, key, pv);
}
else
{
// Read value from INI file.
var pv = ini2.GetValue(padSectionName, key) ?? "";
sProp.SetValue(s, pv, null);
}
continue;
}
// Property was not found.
var message = string.Format("ReadWritePadSettings: Property '{0}' was not found", item.PropertyName);
// Inform developer with the message.
MessageBoxForm.Show(message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
protected override void OnModelCreating(ModelBuilder modelBuilder)
{
ApplicationSettingMap.Map(modelBuilder.Entity <ApplicationSetting>());
ApplicationEntitiesMap.Map(modelBuilder.Entity <ApplicationEntities>());
ApplicationProcessMap.Map(modelBuilder.Entity <ApplicationProcess>());
ApplicationsMap.Map(modelBuilder.Entity <Applications>());
DataPropertiesMap.Map(modelBuilder.Entity <DataProperties>());
DataTypesMap.Map(modelBuilder.Entity <DataTypes>());
EntitiesMap.Map(modelBuilder.Entity <EF.Entities.Entities>());
EntityPropertiesMap.Map(modelBuilder.Entity <EntityProperties>());
EntityRelationshipsMap.Map(modelBuilder.Entity <EntityRelationships>());
EntityViewMap.Map(modelBuilder.Entity <EntityView>());
EntityViewEntityPropertiesMap.Map(modelBuilder.Entity <EntityViewEntityProperties>());
EntityViewPropertiesMap.Map(modelBuilder.Entity <EntityViewProperties>());
EntityViewPropertyFunctionMap.Map(modelBuilder.Entity <EntityViewPropertyFunction>());
EntityViewPropertyFunctionParameterMap.Map(modelBuilder.Entity <EntityViewPropertyFunctionParameter>());
EntityViewViewPropertiesMap.Map(modelBuilder.Entity <EntityViewViewProperties>());
FunctionBodyMap.Map(modelBuilder.Entity <FunctionBody>());
FunctionParametersMap.Map(modelBuilder.Entity <FunctionParameters>());
FunctionReturnTypeMap.Map(modelBuilder.Entity <FunctionReturnType>());
FunctionsMap.Map(modelBuilder.Entity <Functions>());
FunctionSetFunctionsMap.Map(modelBuilder.Entity <FunctionSetFunctions>());
FunctionSetsMap.Map(modelBuilder.Entity <FunctionSets>());
LayersMap.Map(modelBuilder.Entity <Layers>());
LayoutMap.Map(modelBuilder.Entity <Layout>());
ModelTypesMap.Map(modelBuilder.Entity <ModelTypes>());
OperatorsMap.Map(modelBuilder.Entity <Operators>());
ParametersMap.Map(modelBuilder.Entity <Parameters>());
PartsMap.Map(modelBuilder.Entity <Parts>());
PresentationPropertiesMap.Map(modelBuilder.Entity <PresentationProperties>());
PrimaryKeyOptionsMap.Map(modelBuilder.Entity <PrimaryKeyOptions>());
ProcessMap.Map(modelBuilder.Entity <Process>());
ProcessStepsMap.Map(modelBuilder.Entity <ProcessSteps>());
ProcessStepScreensMap.Map(modelBuilder.Entity <ProcessStepScreens>());
ProjectsMap.Map(modelBuilder.Entity <Projects>());
RelationshipTypesMap.Map(modelBuilder.Entity <RelationshipTypes>());
ScreenLayoutsMap.Map(modelBuilder.Entity <ScreenLayouts>());
ScreenPartsMap.Map(modelBuilder.Entity <ScreenParts>());
ScreensMap.Map(modelBuilder.Entity <Screens>());
ScreenViewsMap.Map(modelBuilder.Entity <ScreenViews>());
SettingsMap.Map(modelBuilder.Entity <Settings>());
SettingsNamesMap.Map(modelBuilder.Entity <SettingsNames>());
StateMachinesMap.Map(modelBuilder.Entity <StateMachines>());
StateMachineStatesMap.Map(modelBuilder.Entity <StateMachineStates>());
StateMachineTriggersMap.Map(modelBuilder.Entity <StateMachineTriggers>());
StatesMap.Map(modelBuilder.Entity <States>());
StepsMap.Map(modelBuilder.Entity <Steps>());
TestValuesMap.Map(modelBuilder.Entity <TestValues>());
TriggersMap.Map(modelBuilder.Entity <Triggers>());
ViewEntityMap.Map(modelBuilder.Entity <ViewEntity>());
ViewsMap.Map(modelBuilder.Entity <Views>());
}
public void RaiseSettingsChanged(Control control)
{
var ev = SettingChanged;
if (ev == null)
{
return;
}
var map = SettingsMap.FirstOrDefault(x => x.Control == control);
var e = new SettingChangedEventArgs(map);
ev(this, e);
}
/// <summary>
/// Write game settings to INI file.
/// </summary>
/// <param name="game"></param>
public string GetIniContent(string sectionName)
{
var items = SettingsMap.Where(x => x.IniSection == sectionName).ToArray();
var sb = new StringBuilder();
sb.AppendFormat("[{0}]", sectionName).AppendLine();
for (int i = 0; i < items.Length; i++)
{
var item = items[i];
var value = GetSettingValue(item.Control);
sb.AppendFormat("{0}={1}\r\n", item.IniKey, value);
}
return(sb.ToString());
}
// .. OPERATIONS
// .. INQUIRIES
public bool TryGetSetting(
string key,
out object value
)
{
bool
result;
result = SettingsMap.TryGetValue(key, out value);
if (!result)
{
Console.WriteLine(key + " this key is not found in settings");
}
return(result);
}
static public void Apply()
{
SettingsMap arrGPP = SettingsMap.GetArray(), arrGridTabs = SettingsMap.GetArray(), arrRPP = SettingsMap.GetArray(), dIndex = null, detailsParam = SettingsMap.GetArray(), edata = SettingsMap.GetArray(), eventsData = SettingsMap.GetArray(), fdata = SettingsMap.GetArray(), fieldLabelsArray = new XVar(), fieldToolTipsArray = new XVar(), hours = null, intervalData = SettingsMap.GetArray(), masterParams = SettingsMap.GetArray(), pageTitlesArray = new XVar(), placeHoldersArray = new XVar(), popupPagesLayoutNames = SettingsMap.GetArray(), query = null, queryData_Array = new XVar(), reportGroupFields = SettingsMap.GetArray(), rgroupField = SettingsMap.GetArray(), strOriginalDetailsTable = null, table = null, tableKeysArray = new XVar(), tdataArray = new XVar(), tstrOrderBy = null, vdata = SettingsMap.GetArray();
tdataArray["dbo_Preferencias"] = SettingsMap.GetArray();
tdataArray["dbo_Preferencias"][".searchableFields"] = SettingsMap.GetArray();
tdataArray["dbo_Preferencias"][".truncateText"] = true;
tdataArray["dbo_Preferencias"][".NumberOfChars"] = 80;
tdataArray["dbo_Preferencias"][".ShortName"] = "dbo_Preferencias";
tdataArray["dbo_Preferencias"][".OwnerID"] = "";
tdataArray["dbo_Preferencias"][".OriginalTable"] = "dbo.Preferencias";
GlobalVars.defaultPages = MVCFunctions.my_json_decode(new XVar("{\"edit\":\"edit\",\"list\":\"list\",\"search\":\"search\"}"));
tdataArray["dbo_Preferencias"][".pages"] = CommonFunctions.types2pages(MVCFunctions.my_json_decode(new XVar("{\"edit\":[\"edit\"],\"list\":[\"list\"],\"search\":[\"search\"]}")));
tdataArray["dbo_Preferencias"][".defaultPages"] = GlobalVars.defaultPages;
fieldLabelsArray["dbo_Preferencias"] = SettingsMap.GetArray();
fieldToolTipsArray["dbo_Preferencias"] = SettingsMap.GetArray();
pageTitlesArray["dbo_Preferencias"] = SettingsMap.GetArray();
placeHoldersArray["dbo_Preferencias"] = SettingsMap.GetArray();
if (CommonFunctions.mlang_getcurrentlang() == "Spanish")
{
fieldLabelsArray["dbo_Preferencias"]["Spanish"] = SettingsMap.GetArray();
fieldToolTipsArray["dbo_Preferencias"]["Spanish"] = SettingsMap.GetArray();
placeHoldersArray["dbo_Preferencias"]["Spanish"] = SettingsMap.GetArray();
pageTitlesArray["dbo_Preferencias"]["Spanish"] = SettingsMap.GetArray();
fieldLabelsArray["dbo_Preferencias"]["Spanish"]["ID"] = "ID";
fieldToolTipsArray["dbo_Preferencias"]["Spanish"]["ID"] = "";
placeHoldersArray["dbo_Preferencias"]["Spanish"]["ID"] = "";
fieldLabelsArray["dbo_Preferencias"]["Spanish"]["nombre_jefe"] = "Nombre Jefe";
fieldToolTipsArray["dbo_Preferencias"]["Spanish"]["nombre_jefe"] = "";
placeHoldersArray["dbo_Preferencias"]["Spanish"]["nombre_jefe"] = "";
fieldLabelsArray["dbo_Preferencias"]["Spanish"]["division"] = "Division";
fieldToolTipsArray["dbo_Preferencias"]["Spanish"]["division"] = "";
placeHoldersArray["dbo_Preferencias"]["Spanish"]["division"] = "";
if (XVar.Pack(MVCFunctions.count(fieldToolTipsArray["dbo_Preferencias"]["Spanish"])))
{
tdataArray["dbo_Preferencias"][".isUseToolTips"] = true;
}
}
tdataArray["dbo_Preferencias"][".NCSearch"] = true;
tdataArray["dbo_Preferencias"][".shortTableName"] = "dbo_Preferencias";
tdataArray["dbo_Preferencias"][".nSecOptions"] = 0;
tdataArray["dbo_Preferencias"][".mainTableOwnerID"] = "";
tdataArray["dbo_Preferencias"][".entityType"] = 0;
tdataArray["dbo_Preferencias"][".strOriginalTableName"] = "dbo.Preferencias";
tdataArray["dbo_Preferencias"][".showAddInPopup"] = false;
tdataArray["dbo_Preferencias"][".showEditInPopup"] = false;
tdataArray["dbo_Preferencias"][".showViewInPopup"] = false;
popupPagesLayoutNames = SettingsMap.GetArray();
tdataArray["dbo_Preferencias"][".popupPagesLayoutNames"] = popupPagesLayoutNames;
tdataArray["dbo_Preferencias"][".listAjax"] = false;
tdataArray["dbo_Preferencias"][".listAjax"] = false;
tdataArray["dbo_Preferencias"][".audit"] = true;
tdataArray["dbo_Preferencias"][".locking"] = false;
GlobalVars.pages = tdataArray["dbo_Preferencias"][".pages"];
if (XVar.Pack(GlobalVars.pages[Constants.PAGE_EDIT]))
{
tdataArray["dbo_Preferencias"][".edit"] = true;
tdataArray["dbo_Preferencias"][".afterEditAction"] = 1;
tdataArray["dbo_Preferencias"][".closePopupAfterEdit"] = 1;
tdataArray["dbo_Preferencias"][".afterEditActionDetTable"] = "";
}
if (XVar.Pack(GlobalVars.pages[Constants.PAGE_ADD]))
{
tdataArray["dbo_Preferencias"][".add"] = true;
tdataArray["dbo_Preferencias"][".afterAddAction"] = 1;
tdataArray["dbo_Preferencias"][".closePopupAfterAdd"] = 1;
tdataArray["dbo_Preferencias"][".afterAddActionDetTable"] = "";
}
if (XVar.Pack(GlobalVars.pages[Constants.PAGE_LIST]))
{
tdataArray["dbo_Preferencias"][".list"] = true;
}
tdataArray["dbo_Preferencias"][".strSortControlSettingsJSON"] = "";
if (XVar.Pack(GlobalVars.pages[Constants.PAGE_VIEW]))
{
tdataArray["dbo_Preferencias"][".view"] = true;
}
if (XVar.Pack(GlobalVars.pages[Constants.PAGE_IMPORT]))
{
tdataArray["dbo_Preferencias"][".import"] = true;
}
if (XVar.Pack(GlobalVars.pages[Constants.PAGE_EXPORT]))
{
tdataArray["dbo_Preferencias"][".exportTo"] = true;
}
if (XVar.Pack(GlobalVars.pages[Constants.PAGE_PRINT]))
{
tdataArray["dbo_Preferencias"][".printFriendly"] = true;
}
tdataArray["dbo_Preferencias"][".showSimpleSearchOptions"] = true;
tdataArray["dbo_Preferencias"][".allowShowHideFields"] = true;
tdataArray["dbo_Preferencias"][".allowFieldsReordering"] = true;
tdataArray["dbo_Preferencias"][".isUseAjaxSuggest"] = true;
tdataArray["dbo_Preferencias"][".rowHighlite"] = true;
tdataArray["dbo_Preferencias"][".ajaxCodeSnippetAdded"] = false;
tdataArray["dbo_Preferencias"][".buttonsAdded"] = false;
tdataArray["dbo_Preferencias"][".addPageEvents"] = false;
tdataArray["dbo_Preferencias"][".isUseTimeForSearch"] = false;
tdataArray["dbo_Preferencias"][".badgeColor"] = "D2691E";
tdataArray["dbo_Preferencias"][".allSearchFields"] = SettingsMap.GetArray();
tdataArray["dbo_Preferencias"][".filterFields"] = SettingsMap.GetArray();
tdataArray["dbo_Preferencias"][".requiredSearchFields"] = SettingsMap.GetArray();
tdataArray["dbo_Preferencias"][".tableType"] = "list";
tdataArray["dbo_Preferencias"][".printerPageOrientation"] = 0;
tdataArray["dbo_Preferencias"][".nPrinterPageScale"] = 100;
tdataArray["dbo_Preferencias"][".nPrinterSplitRecords"] = 40;
tdataArray["dbo_Preferencias"][".nPrinterPDFSplitRecords"] = 40;
tdataArray["dbo_Preferencias"][".geocodingEnabled"] = false;
tdataArray["dbo_Preferencias"][".pageSize"] = 20;
tdataArray["dbo_Preferencias"][".warnLeavingPages"] = true;
tstrOrderBy = "";
if (MVCFunctions.strlen(tstrOrderBy) && MVCFunctions.strtolower(MVCFunctions.substr(tstrOrderBy, new XVar(0), new XVar(8))) != "order by")
{
tstrOrderBy = MVCFunctions.Concat("order by ", tstrOrderBy);
}
tdataArray["dbo_Preferencias"][".strOrderBy"] = tstrOrderBy;
tdataArray["dbo_Preferencias"][".orderindexes"] = SettingsMap.GetArray();
tdataArray["dbo_Preferencias"][".sqlHead"] = "SELECT ID, nombre_jefe, division";
tdataArray["dbo_Preferencias"][".sqlFrom"] = "FROM dbo.Preferencias";
tdataArray["dbo_Preferencias"][".sqlWhereExpr"] = "";
tdataArray["dbo_Preferencias"][".sqlTail"] = "";
arrRPP = SettingsMap.GetArray();
arrRPP.Add(10);
arrRPP.Add(20);
arrRPP.Add(30);
arrRPP.Add(50);
arrRPP.Add(100);
arrRPP.Add(500);
arrRPP.Add(-1);
tdataArray["dbo_Preferencias"][".arrRecsPerPage"] = arrRPP;
arrGPP = SettingsMap.GetArray();
arrGPP.Add(1);
arrGPP.Add(3);
arrGPP.Add(5);
arrGPP.Add(10);
arrGPP.Add(50);
arrGPP.Add(100);
arrGPP.Add(-1);
tdataArray["dbo_Preferencias"][".arrGroupsPerPage"] = arrGPP;
tdataArray["dbo_Preferencias"][".highlightSearchResults"] = true;
tableKeysArray["dbo_Preferencias"] = SettingsMap.GetArray();
tableKeysArray["dbo_Preferencias"].Add("ID");
tdataArray["dbo_Preferencias"][".Keys"] = tableKeysArray["dbo_Preferencias"];
tdataArray["dbo_Preferencias"][".hideMobileList"] = SettingsMap.GetArray();
fdata = SettingsMap.GetArray();
fdata["Index"] = 1;
fdata["strName"] = "ID";
fdata["GoodName"] = "ID";
fdata["ownerTable"] = "dbo.Preferencias";
fdata["Label"] = CommonFunctions.GetFieldLabel("dbo_Preferencias", "ID");
fdata["FieldType"] = 3;
fdata["AutoInc"] = true;
fdata["strField"] = "ID";
fdata["isSQLExpression"] = true;
fdata["FullName"] = "ID";
fdata["UploadFolder"] = "files";
fdata["ViewFormats"] = SettingsMap.GetArray();
vdata = new XVar("ViewFormat", "");
vdata["NeedEncode"] = true;
fdata["ViewFormats"]["view"] = vdata;
fdata["EditFormats"] = SettingsMap.GetArray();
edata = new XVar("EditFormat", "Text field");
edata["IsRequired"] = true;
edata["acceptFileTypes"] = ".+$";
edata["maxNumberOfFiles"] = 1;
edata["HTML5InuptType"] = "text";
edata["EditParams"] = "";
edata["controlWidth"] = 200;
edata["validateAs"] = SettingsMap.GetArray();
edata["validateAs"]["basicValidate"] = SettingsMap.GetArray();
edata["validateAs"]["customMessages"] = SettingsMap.GetArray();
edata["validateAs"]["basicValidate"].Add(CommonFunctions.getJsValidatorName(new XVar("Number")));
edata["validateAs"]["basicValidate"].Add("IsRequired");
fdata["EditFormats"]["edit"] = edata;
fdata["isSeparate"] = false;
fdata["defaultSearchOption"] = "Contains";
fdata["searchOptionsList"] = new XVar(0, "Contains", 1, "Equals", 2, "Starts with", 3, "More than", 4, "Less than", 5, "Between", 6, "Empty", 7, Constants.NOT_EMPTY);
fdata["filterTotals"] = 0;
fdata["filterMultiSelect"] = 0;
fdata["filterFormat"] = "Values list";
fdata["showCollapsed"] = false;
fdata["sortValueType"] = 0;
fdata["numberOfVisibleItems"] = 10;
tdataArray["dbo_Preferencias"]["ID"] = fdata;
tdataArray["dbo_Preferencias"][".searchableFields"].Add("ID");
fdata = SettingsMap.GetArray();
fdata["Index"] = 2;
fdata["strName"] = "nombre_jefe";
fdata["GoodName"] = "nombre_jefe";
fdata["ownerTable"] = "dbo.Preferencias";
fdata["Label"] = CommonFunctions.GetFieldLabel("dbo_Preferencias", "nombre_jefe");
fdata["FieldType"] = 200;
fdata["strField"] = "nombre_jefe";
fdata["isSQLExpression"] = true;
fdata["FullName"] = "nombre_jefe";
fdata["UploadFolder"] = "files";
fdata["ViewFormats"] = SettingsMap.GetArray();
vdata = new XVar("ViewFormat", "");
vdata["NeedEncode"] = true;
fdata["ViewFormats"]["view"] = vdata;
fdata["EditFormats"] = SettingsMap.GetArray();
edata = new XVar("EditFormat", "Text field");
edata["acceptFileTypes"] = ".+$";
edata["maxNumberOfFiles"] = 1;
edata["HTML5InuptType"] = "text";
edata["EditParams"] = "";
edata["EditParams"] = MVCFunctions.Concat(edata["EditParams"], " maxlength=50");
edata["controlWidth"] = 200;
edata["validateAs"] = SettingsMap.GetArray();
edata["validateAs"]["basicValidate"] = SettingsMap.GetArray();
edata["validateAs"]["customMessages"] = SettingsMap.GetArray();
fdata["EditFormats"]["edit"] = edata;
fdata["isSeparate"] = false;
fdata["defaultSearchOption"] = "Contains";
fdata["searchOptionsList"] = new XVar(0, "Contains", 1, "Equals", 2, "Starts with", 3, "More than", 4, "Less than", 5, "Between", 6, "Empty", 7, Constants.NOT_EMPTY);
fdata["filterTotals"] = 0;
fdata["filterMultiSelect"] = 0;
fdata["filterFormat"] = "Values list";
fdata["showCollapsed"] = false;
fdata["sortValueType"] = 0;
fdata["numberOfVisibleItems"] = 10;
tdataArray["dbo_Preferencias"]["nombre_jefe"] = fdata;
tdataArray["dbo_Preferencias"][".searchableFields"].Add("nombre_jefe");
fdata = SettingsMap.GetArray();
fdata["Index"] = 3;
fdata["strName"] = "division";
fdata["GoodName"] = "division";
fdata["ownerTable"] = "dbo.Preferencias";
fdata["Label"] = CommonFunctions.GetFieldLabel("dbo_Preferencias", "division");
fdata["FieldType"] = 200;
fdata["strField"] = "division";
fdata["isSQLExpression"] = true;
fdata["FullName"] = "division";
fdata["UploadFolder"] = "files";
fdata["ViewFormats"] = SettingsMap.GetArray();
vdata = new XVar("ViewFormat", "");
vdata["NeedEncode"] = true;
fdata["ViewFormats"]["view"] = vdata;
fdata["EditFormats"] = SettingsMap.GetArray();
edata = new XVar("EditFormat", "Text field");
edata["acceptFileTypes"] = ".+$";
edata["maxNumberOfFiles"] = 1;
edata["HTML5InuptType"] = "text";
edata["EditParams"] = "";
edata["EditParams"] = MVCFunctions.Concat(edata["EditParams"], " maxlength=100");
edata["controlWidth"] = 200;
edata["validateAs"] = SettingsMap.GetArray();
edata["validateAs"]["basicValidate"] = SettingsMap.GetArray();
edata["validateAs"]["customMessages"] = SettingsMap.GetArray();
fdata["EditFormats"]["edit"] = edata;
fdata["isSeparate"] = false;
fdata["defaultSearchOption"] = "Contains";
fdata["searchOptionsList"] = new XVar(0, "Contains", 1, "Equals", 2, "Starts with", 3, "More than", 4, "Less than", 5, "Between", 6, "Empty", 7, Constants.NOT_EMPTY);
fdata["filterTotals"] = 0;
fdata["filterMultiSelect"] = 0;
fdata["filterFormat"] = "Values list";
fdata["showCollapsed"] = false;
fdata["sortValueType"] = 0;
fdata["numberOfVisibleItems"] = 10;
tdataArray["dbo_Preferencias"]["division"] = fdata;
tdataArray["dbo_Preferencias"][".searchableFields"].Add("division");
GlobalVars.tables_data["dbo.Preferencias"] = tdataArray["dbo_Preferencias"];
GlobalVars.field_labels["dbo_Preferencias"] = fieldLabelsArray["dbo_Preferencias"];
GlobalVars.fieldToolTips["dbo_Preferencias"] = fieldToolTipsArray["dbo_Preferencias"];
GlobalVars.placeHolders["dbo_Preferencias"] = placeHoldersArray["dbo_Preferencias"];
GlobalVars.page_titles["dbo_Preferencias"] = pageTitlesArray["dbo_Preferencias"];
GlobalVars.detailsTablesData["dbo.Preferencias"] = SettingsMap.GetArray();
GlobalVars.masterTablesData["dbo.Preferencias"] = SettingsMap.GetArray();
SQLEntity obj = null;
var protoArray = SettingsMap.GetArray();
protoArray["0"] = SettingsMap.GetArray();
protoArray["0"]["m_strHead"] = "SELECT";
protoArray["0"]["m_strFieldList"] = "ID, nombre_jefe, division";
protoArray["0"]["m_strFrom"] = "FROM dbo.Preferencias";
protoArray["0"]["m_strWhere"] = "";
protoArray["0"]["m_strOrderBy"] = "";
protoArray["0"]["cipherer"] = null;
protoArray["2"] = SettingsMap.GetArray();
protoArray["2"]["m_sql"] = "";
protoArray["2"]["m_uniontype"] = "SQLL_UNKNOWN";
obj = new SQLNonParsed(new XVar("m_sql", ""));
protoArray["2"]["m_column"] = obj;
protoArray["2"]["m_contained"] = SettingsMap.GetArray();
protoArray["2"]["m_strCase"] = "";
protoArray["2"]["m_havingmode"] = false;
protoArray["2"]["m_inBrackets"] = false;
protoArray["2"]["m_useAlias"] = false;
obj = new SQLLogicalExpr(protoArray["2"]);
protoArray["0"]["m_where"] = obj;
protoArray["4"] = SettingsMap.GetArray();
protoArray["4"]["m_sql"] = "";
protoArray["4"]["m_uniontype"] = "SQLL_UNKNOWN";
obj = new SQLNonParsed(new XVar("m_sql", ""));
protoArray["4"]["m_column"] = obj;
protoArray["4"]["m_contained"] = SettingsMap.GetArray();
protoArray["4"]["m_strCase"] = "";
protoArray["4"]["m_havingmode"] = false;
protoArray["4"]["m_inBrackets"] = false;
protoArray["4"]["m_useAlias"] = false;
obj = new SQLLogicalExpr(protoArray["4"]);
protoArray["0"]["m_having"] = obj;
protoArray["0"]["m_fieldlist"] = SettingsMap.GetArray();
protoArray["6"] = SettingsMap.GetArray();
obj = new SQLField(new XVar("m_strName", "ID", "m_strTable", "dbo.Preferencias", "m_srcTableName", "dbo.Preferencias"));
protoArray["6"]["m_sql"] = "ID";
protoArray["6"]["m_srcTableName"] = "dbo.Preferencias";
protoArray["6"]["m_expr"] = obj;
protoArray["6"]["m_alias"] = "";
obj = new SQLFieldListItem(protoArray["6"]);
protoArray["0"]["m_fieldlist"].Add(obj);
protoArray["8"] = SettingsMap.GetArray();
obj = new SQLField(new XVar("m_strName", "nombre_jefe", "m_strTable", "dbo.Preferencias", "m_srcTableName", "dbo.Preferencias"));
protoArray["8"]["m_sql"] = "nombre_jefe";
protoArray["8"]["m_srcTableName"] = "dbo.Preferencias";
protoArray["8"]["m_expr"] = obj;
protoArray["8"]["m_alias"] = "";
obj = new SQLFieldListItem(protoArray["8"]);
protoArray["0"]["m_fieldlist"].Add(obj);
protoArray["10"] = SettingsMap.GetArray();
obj = new SQLField(new XVar("m_strName", "division", "m_strTable", "dbo.Preferencias", "m_srcTableName", "dbo.Preferencias"));
protoArray["10"]["m_sql"] = "division";
protoArray["10"]["m_srcTableName"] = "dbo.Preferencias";
protoArray["10"]["m_expr"] = obj;
protoArray["10"]["m_alias"] = "";
obj = new SQLFieldListItem(protoArray["10"]);
protoArray["0"]["m_fieldlist"].Add(obj);
protoArray["0"]["m_fromlist"] = SettingsMap.GetArray();
protoArray["12"] = SettingsMap.GetArray();
protoArray["12"]["m_link"] = "SQLL_MAIN";
protoArray["13"] = SettingsMap.GetArray();
protoArray["13"]["m_strName"] = "dbo.Preferencias";
protoArray["13"]["m_srcTableName"] = "dbo.Preferencias";
protoArray["13"]["m_columns"] = SettingsMap.GetArray();
protoArray["13"]["m_columns"].Add("nombre_jefe");
protoArray["13"]["m_columns"].Add("division");
protoArray["13"]["m_columns"].Add("ID");
obj = new SQLTable(protoArray["13"]);
protoArray["12"]["m_table"] = obj;
protoArray["12"]["m_sql"] = "dbo.Preferencias";
protoArray["12"]["m_alias"] = "";
protoArray["12"]["m_srcTableName"] = "dbo.Preferencias";
protoArray["14"] = SettingsMap.GetArray();
protoArray["14"]["m_sql"] = "";
protoArray["14"]["m_uniontype"] = "SQLL_UNKNOWN";
obj = new SQLNonParsed(new XVar("m_sql", ""));
protoArray["14"]["m_column"] = obj;
protoArray["14"]["m_contained"] = SettingsMap.GetArray();
protoArray["14"]["m_strCase"] = "";
protoArray["14"]["m_havingmode"] = false;
protoArray["14"]["m_inBrackets"] = false;
protoArray["14"]["m_useAlias"] = false;
obj = new SQLLogicalExpr(protoArray["14"]);
protoArray["12"]["m_joinon"] = obj;
obj = new SQLFromListItem(protoArray["12"]);
protoArray["0"]["m_fromlist"].Add(obj);
protoArray["0"]["m_groupby"] = SettingsMap.GetArray();
protoArray["0"]["m_orderby"] = SettingsMap.GetArray();
protoArray["0"]["m_srcTableName"] = "dbo.Preferencias";
obj = new SQLQuery(protoArray["0"]);
queryData_Array["dbo_Preferencias"] = obj;
tdataArray["dbo_Preferencias"][".sqlquery"] = queryData_Array["dbo_Preferencias"];
GlobalVars.tableEvents["dbo.Preferencias"] = new eventsBase();
tdataArray["dbo_Preferencias"][".hasEvents"] = false;
GlobalVars.tables_data["dbo_Preferencias"] = tdataArray["dbo_Preferencias"];
}
protected override void AwakeInherit()
{
this.settingsMap = this.GetSettings <SettingsMap>();
}
static public void Apply()
{
SettingsMap arrAddTabs = SettingsMap.GetArray(), arrEditTabs = SettingsMap.GetArray(), arrGPP = SettingsMap.GetArray(), arrGridTabs = SettingsMap.GetArray(), arrRPP = SettingsMap.GetArray(), arrRegisterTabs = SettingsMap.GetArray(), arrViewTabs = SettingsMap.GetArray(), dIndex = null, detailsParam = SettingsMap.GetArray(), edata = SettingsMap.GetArray(), eventsData = SettingsMap.GetArray(), fdata = SettingsMap.GetArray(), fieldLabelsArray = new XVar(), fieldToolTipsArray = new XVar(), hours = null, intervalData = SettingsMap.GetArray(), masterParams = SettingsMap.GetArray(), pageTitlesArray = new XVar(), placeHoldersArray = new XVar(), popupPagesLayoutNames = SettingsMap.GetArray(), query = null, queryData_Array = new XVar(), reportGroupFields = SettingsMap.GetArray(), rgroupField = SettingsMap.GetArray(), strOriginalDetailsTable = null, tabFields = SettingsMap.GetArray(), table = null, tableKeysArray = new XVar(), tdataArray = new XVar(), tstrOrderBy = null, vdata = SettingsMap.GetArray();
tdataArray["dbo__ABCSecurity"] = SettingsMap.GetArray();
tdataArray["dbo__ABCSecurity"][".truncateText"] = true;
tdataArray["dbo__ABCSecurity"][".NumberOfChars"] = 80;
tdataArray["dbo__ABCSecurity"][".ShortName"] = "dbo__ABCSecurity";
tdataArray["dbo__ABCSecurity"][".OwnerID"] = "";
tdataArray["dbo__ABCSecurity"][".OriginalTable"] = "dbo._ABCSecurity";
fieldLabelsArray["dbo__ABCSecurity"] = SettingsMap.GetArray();
fieldToolTipsArray["dbo__ABCSecurity"] = SettingsMap.GetArray();
pageTitlesArray["dbo__ABCSecurity"] = SettingsMap.GetArray();
placeHoldersArray["dbo__ABCSecurity"] = SettingsMap.GetArray();
if (CommonFunctions.mlang_getcurrentlang() == "English")
{
fieldLabelsArray["dbo__ABCSecurity"]["English"] = SettingsMap.GetArray();
fieldToolTipsArray["dbo__ABCSecurity"]["English"] = SettingsMap.GetArray();
placeHoldersArray["dbo__ABCSecurity"]["English"] = SettingsMap.GetArray();
pageTitlesArray["dbo__ABCSecurity"]["English"] = SettingsMap.GetArray();
fieldLabelsArray["dbo__ABCSecurity"]["English"]["ID"] = "ID";
fieldToolTipsArray["dbo__ABCSecurity"]["English"]["ID"] = "";
placeHoldersArray["dbo__ABCSecurity"]["English"]["ID"] = "";
fieldLabelsArray["dbo__ABCSecurity"]["English"]["username"] = "******";
fieldToolTipsArray["dbo__ABCSecurity"]["English"]["username"] = "";
placeHoldersArray["dbo__ABCSecurity"]["English"]["username"] = "";
fieldLabelsArray["dbo__ABCSecurity"]["English"]["password"] = "******";
fieldToolTipsArray["dbo__ABCSecurity"]["English"]["password"] = "";
placeHoldersArray["dbo__ABCSecurity"]["English"]["password"] = "";
fieldLabelsArray["dbo__ABCSecurity"]["English"]["admin"] = "Admin";
fieldToolTipsArray["dbo__ABCSecurity"]["English"]["admin"] = "";
placeHoldersArray["dbo__ABCSecurity"]["English"]["admin"] = "";
fieldLabelsArray["dbo__ABCSecurity"]["English"]["byear"] = "Begin Term";
fieldToolTipsArray["dbo__ABCSecurity"]["English"]["byear"] = "";
placeHoldersArray["dbo__ABCSecurity"]["English"]["byear"] = "";
fieldLabelsArray["dbo__ABCSecurity"]["English"]["eyear"] = "End Term";
fieldToolTipsArray["dbo__ABCSecurity"]["English"]["eyear"] = "";
placeHoldersArray["dbo__ABCSecurity"]["English"]["eyear"] = "";
fieldLabelsArray["dbo__ABCSecurity"]["English"]["role"] = "Role";
fieldToolTipsArray["dbo__ABCSecurity"]["English"]["role"] = "";
placeHoldersArray["dbo__ABCSecurity"]["English"]["role"] = "";
if (XVar.Pack(MVCFunctions.count(fieldToolTipsArray["dbo__ABCSecurity"]["English"])))
{
tdataArray["dbo__ABCSecurity"][".isUseToolTips"] = true;
}
}
if (CommonFunctions.mlang_getcurrentlang() == "")
{
fieldLabelsArray["dbo__ABCSecurity"][""] = SettingsMap.GetArray();
fieldToolTipsArray["dbo__ABCSecurity"][""] = SettingsMap.GetArray();
placeHoldersArray["dbo__ABCSecurity"][""] = SettingsMap.GetArray();
pageTitlesArray["dbo__ABCSecurity"][""] = SettingsMap.GetArray();
if (XVar.Pack(MVCFunctions.count(fieldToolTipsArray["dbo__ABCSecurity"][""])))
{
tdataArray["dbo__ABCSecurity"][".isUseToolTips"] = true;
}
}
tdataArray["dbo__ABCSecurity"][".NCSearch"] = true;
tdataArray["dbo__ABCSecurity"][".shortTableName"] = "dbo__ABCSecurity";
tdataArray["dbo__ABCSecurity"][".nSecOptions"] = 0;
tdataArray["dbo__ABCSecurity"][".recsPerRowPrint"] = 1;
tdataArray["dbo__ABCSecurity"][".mainTableOwnerID"] = "";
tdataArray["dbo__ABCSecurity"][".moveNext"] = 1;
tdataArray["dbo__ABCSecurity"][".entityType"] = 0;
tdataArray["dbo__ABCSecurity"][".strOriginalTableName"] = "dbo._ABCSecurity";
tdataArray["dbo__ABCSecurity"][".showAddInPopup"] = false;
tdataArray["dbo__ABCSecurity"][".showEditInPopup"] = false;
tdataArray["dbo__ABCSecurity"][".showViewInPopup"] = false;
popupPagesLayoutNames = SettingsMap.GetArray();
tdataArray["dbo__ABCSecurity"][".popupPagesLayoutNames"] = popupPagesLayoutNames;
tdataArray["dbo__ABCSecurity"][".fieldsForRegister"] = SettingsMap.GetArray();
tdataArray["dbo__ABCSecurity"][".listAjax"] = false;
tdataArray["dbo__ABCSecurity"][".audit"] = false;
tdataArray["dbo__ABCSecurity"][".locking"] = false;
tdataArray["dbo__ABCSecurity"][".edit"] = true;
tdataArray["dbo__ABCSecurity"][".afterEditAction"] = 1;
tdataArray["dbo__ABCSecurity"][".closePopupAfterEdit"] = 1;
tdataArray["dbo__ABCSecurity"][".afterEditActionDetTable"] = "";
tdataArray["dbo__ABCSecurity"][".add"] = true;
tdataArray["dbo__ABCSecurity"][".afterAddAction"] = 1;
tdataArray["dbo__ABCSecurity"][".closePopupAfterAdd"] = 1;
tdataArray["dbo__ABCSecurity"][".afterAddActionDetTable"] = "";
tdataArray["dbo__ABCSecurity"][".list"] = true;
tdataArray["dbo__ABCSecurity"][".inlineEdit"] = true;
tdataArray["dbo__ABCSecurity"][".reorderRecordsByHeader"] = true;
tdataArray["dbo__ABCSecurity"][".exportFormatting"] = 2;
tdataArray["dbo__ABCSecurity"][".exportDelimiter"] = ",";
tdataArray["dbo__ABCSecurity"][".inlineAdd"] = true;
tdataArray["dbo__ABCSecurity"][".view"] = true;
tdataArray["dbo__ABCSecurity"][".import"] = true;
tdataArray["dbo__ABCSecurity"][".exportTo"] = true;
tdataArray["dbo__ABCSecurity"][".printFriendly"] = true;
tdataArray["dbo__ABCSecurity"][".delete"] = true;
tdataArray["dbo__ABCSecurity"][".showSimpleSearchOptions"] = false;
tdataArray["dbo__ABCSecurity"][".allowShowHideFields"] = false;
tdataArray["dbo__ABCSecurity"][".allowFieldsReordering"] = false;
tdataArray["dbo__ABCSecurity"][".searchSaving"] = false;
tdataArray["dbo__ABCSecurity"][".showSearchPanel"] = true;
tdataArray["dbo__ABCSecurity"][".flexibleSearch"] = true;
tdataArray["dbo__ABCSecurity"][".isUseAjaxSuggest"] = true;
tdataArray["dbo__ABCSecurity"][".rowHighlite"] = true;
tdataArray["dbo__ABCSecurity"][".ajaxCodeSnippetAdded"] = false;
tdataArray["dbo__ABCSecurity"][".buttonsAdded"] = false;
tdataArray["dbo__ABCSecurity"][".addPageEvents"] = false;
tdataArray["dbo__ABCSecurity"][".isUseTimeForSearch"] = false;
tdataArray["dbo__ABCSecurity"][".badgeColor"] = "5F9EA0";
tdataArray["dbo__ABCSecurity"][".allSearchFields"] = SettingsMap.GetArray();
tdataArray["dbo__ABCSecurity"][".filterFields"] = SettingsMap.GetArray();
tdataArray["dbo__ABCSecurity"][".requiredSearchFields"] = SettingsMap.GetArray();
tdataArray["dbo__ABCSecurity"][".allSearchFields"].Add("username");
tdataArray["dbo__ABCSecurity"][".allSearchFields"].Add("password");
tdataArray["dbo__ABCSecurity"][".allSearchFields"].Add("byear");
tdataArray["dbo__ABCSecurity"][".allSearchFields"].Add("eyear");
tdataArray["dbo__ABCSecurity"][".allSearchFields"].Add("role");
tdataArray["dbo__ABCSecurity"][".googleLikeFields"] = SettingsMap.GetArray();
tdataArray["dbo__ABCSecurity"][".googleLikeFields"].Add("ID");
tdataArray["dbo__ABCSecurity"][".googleLikeFields"].Add("username");
tdataArray["dbo__ABCSecurity"][".googleLikeFields"].Add("password");
tdataArray["dbo__ABCSecurity"][".googleLikeFields"].Add("admin");
tdataArray["dbo__ABCSecurity"][".googleLikeFields"].Add("byear");
tdataArray["dbo__ABCSecurity"][".googleLikeFields"].Add("eyear");
tdataArray["dbo__ABCSecurity"][".googleLikeFields"].Add("role");
tdataArray["dbo__ABCSecurity"][".advSearchFields"] = SettingsMap.GetArray();
tdataArray["dbo__ABCSecurity"][".advSearchFields"].Add("username");
tdataArray["dbo__ABCSecurity"][".advSearchFields"].Add("password");
tdataArray["dbo__ABCSecurity"][".advSearchFields"].Add("byear");
tdataArray["dbo__ABCSecurity"][".advSearchFields"].Add("eyear");
tdataArray["dbo__ABCSecurity"][".advSearchFields"].Add("role");
tdataArray["dbo__ABCSecurity"][".tableType"] = "list";
tdataArray["dbo__ABCSecurity"][".printerPageOrientation"] = 0;
tdataArray["dbo__ABCSecurity"][".nPrinterPageScale"] = 100;
tdataArray["dbo__ABCSecurity"][".nPrinterSplitRecords"] = 40;
tdataArray["dbo__ABCSecurity"][".nPrinterPDFSplitRecords"] = 40;
tdataArray["dbo__ABCSecurity"][".geocodingEnabled"] = false;
tdataArray["dbo__ABCSecurity"][".listGridLayout"] = 3;
tdataArray["dbo__ABCSecurity"][".pageSize"] = 20;
tdataArray["dbo__ABCSecurity"][".warnLeavingPages"] = true;
tstrOrderBy = "";
if (MVCFunctions.strlen(tstrOrderBy) && MVCFunctions.strtolower(MVCFunctions.substr(tstrOrderBy, new XVar(0), new XVar(8))) != "order by")
{
tstrOrderBy = MVCFunctions.Concat("order by ", tstrOrderBy);
}
tdataArray["dbo__ABCSecurity"][".strOrderBy"] = tstrOrderBy;
tdataArray["dbo__ABCSecurity"][".orderindexes"] = SettingsMap.GetArray();
tdataArray["dbo__ABCSecurity"][".sqlHead"] = "SELECT ID, username, password, [admin], byear, eyear, [role]";
tdataArray["dbo__ABCSecurity"][".sqlFrom"] = "FROM dbo.[_ABCSecurity]";
tdataArray["dbo__ABCSecurity"][".sqlWhereExpr"] = "";
tdataArray["dbo__ABCSecurity"][".sqlTail"] = "";
arrRPP = SettingsMap.GetArray();
arrRPP.Add(10);
arrRPP.Add(20);
arrRPP.Add(30);
arrRPP.Add(50);
arrRPP.Add(100);
arrRPP.Add(500);
arrRPP.Add(-1);
tdataArray["dbo__ABCSecurity"][".arrRecsPerPage"] = arrRPP;
arrGPP = SettingsMap.GetArray();
arrGPP.Add(1);
arrGPP.Add(3);
arrGPP.Add(5);
arrGPP.Add(10);
arrGPP.Add(50);
arrGPP.Add(100);
arrGPP.Add(-1);
tdataArray["dbo__ABCSecurity"][".arrGroupsPerPage"] = arrGPP;
tdataArray["dbo__ABCSecurity"][".highlightSearchResults"] = true;
tableKeysArray["dbo__ABCSecurity"] = SettingsMap.GetArray();
tableKeysArray["dbo__ABCSecurity"].Add("ID");
tdataArray["dbo__ABCSecurity"][".Keys"] = tableKeysArray["dbo__ABCSecurity"];
tdataArray["dbo__ABCSecurity"][".listFields"] = SettingsMap.GetArray();
tdataArray["dbo__ABCSecurity"][".listFields"].Add("username");
tdataArray["dbo__ABCSecurity"][".listFields"].Add("password");
tdataArray["dbo__ABCSecurity"][".listFields"].Add("byear");
tdataArray["dbo__ABCSecurity"][".listFields"].Add("eyear");
tdataArray["dbo__ABCSecurity"][".listFields"].Add("role");
tdataArray["dbo__ABCSecurity"][".hideMobileList"] = SettingsMap.GetArray();
tdataArray["dbo__ABCSecurity"][".viewFields"] = SettingsMap.GetArray();
tdataArray["dbo__ABCSecurity"][".viewFields"].Add("username");
tdataArray["dbo__ABCSecurity"][".viewFields"].Add("password");
tdataArray["dbo__ABCSecurity"][".viewFields"].Add("byear");
tdataArray["dbo__ABCSecurity"][".viewFields"].Add("eyear");
tdataArray["dbo__ABCSecurity"][".viewFields"].Add("role");
tdataArray["dbo__ABCSecurity"][".addFields"] = SettingsMap.GetArray();
tdataArray["dbo__ABCSecurity"][".addFields"].Add("byear");
tdataArray["dbo__ABCSecurity"][".addFields"].Add("eyear");
tdataArray["dbo__ABCSecurity"][".addFields"].Add("username");
tdataArray["dbo__ABCSecurity"][".addFields"].Add("password");
tdataArray["dbo__ABCSecurity"][".addFields"].Add("role");
tdataArray["dbo__ABCSecurity"][".masterListFields"] = SettingsMap.GetArray();
tdataArray["dbo__ABCSecurity"][".masterListFields"].Add("ID");
tdataArray["dbo__ABCSecurity"][".masterListFields"].Add("username");
tdataArray["dbo__ABCSecurity"][".masterListFields"].Add("password");
tdataArray["dbo__ABCSecurity"][".masterListFields"].Add("admin");
tdataArray["dbo__ABCSecurity"][".masterListFields"].Add("byear");
tdataArray["dbo__ABCSecurity"][".masterListFields"].Add("eyear");
tdataArray["dbo__ABCSecurity"][".masterListFields"].Add("role");
tdataArray["dbo__ABCSecurity"][".inlineAddFields"] = SettingsMap.GetArray();
tdataArray["dbo__ABCSecurity"][".inlineAddFields"].Add("username");
tdataArray["dbo__ABCSecurity"][".inlineAddFields"].Add("password");
tdataArray["dbo__ABCSecurity"][".inlineAddFields"].Add("byear");
tdataArray["dbo__ABCSecurity"][".inlineAddFields"].Add("eyear");
tdataArray["dbo__ABCSecurity"][".inlineAddFields"].Add("role");
tdataArray["dbo__ABCSecurity"][".editFields"] = SettingsMap.GetArray();
tdataArray["dbo__ABCSecurity"][".editFields"].Add("username");
tdataArray["dbo__ABCSecurity"][".editFields"].Add("password");
tdataArray["dbo__ABCSecurity"][".editFields"].Add("byear");
tdataArray["dbo__ABCSecurity"][".editFields"].Add("eyear");
tdataArray["dbo__ABCSecurity"][".editFields"].Add("role");
tdataArray["dbo__ABCSecurity"][".inlineEditFields"] = SettingsMap.GetArray();
tdataArray["dbo__ABCSecurity"][".inlineEditFields"].Add("username");
tdataArray["dbo__ABCSecurity"][".inlineEditFields"].Add("password");
tdataArray["dbo__ABCSecurity"][".inlineEditFields"].Add("byear");
tdataArray["dbo__ABCSecurity"][".inlineEditFields"].Add("eyear");
tdataArray["dbo__ABCSecurity"][".inlineEditFields"].Add("role");
tdataArray["dbo__ABCSecurity"][".updateSelectedFields"] = SettingsMap.GetArray();
tdataArray["dbo__ABCSecurity"][".updateSelectedFields"].Add("username");
tdataArray["dbo__ABCSecurity"][".updateSelectedFields"].Add("password");
tdataArray["dbo__ABCSecurity"][".updateSelectedFields"].Add("byear");
tdataArray["dbo__ABCSecurity"][".updateSelectedFields"].Add("eyear");
tdataArray["dbo__ABCSecurity"][".updateSelectedFields"].Add("role");
tdataArray["dbo__ABCSecurity"][".exportFields"] = SettingsMap.GetArray();
tdataArray["dbo__ABCSecurity"][".exportFields"].Add("username");
tdataArray["dbo__ABCSecurity"][".exportFields"].Add("password");
tdataArray["dbo__ABCSecurity"][".exportFields"].Add("byear");
tdataArray["dbo__ABCSecurity"][".exportFields"].Add("eyear");
tdataArray["dbo__ABCSecurity"][".exportFields"].Add("role");
tdataArray["dbo__ABCSecurity"][".importFields"] = SettingsMap.GetArray();
tdataArray["dbo__ABCSecurity"][".importFields"].Add("username");
tdataArray["dbo__ABCSecurity"][".importFields"].Add("password");
tdataArray["dbo__ABCSecurity"][".importFields"].Add("byear");
tdataArray["dbo__ABCSecurity"][".importFields"].Add("eyear");
tdataArray["dbo__ABCSecurity"][".importFields"].Add("role");
tdataArray["dbo__ABCSecurity"][".printFields"] = SettingsMap.GetArray();
tdataArray["dbo__ABCSecurity"][".printFields"].Add("username");
tdataArray["dbo__ABCSecurity"][".printFields"].Add("password");
tdataArray["dbo__ABCSecurity"][".printFields"].Add("byear");
tdataArray["dbo__ABCSecurity"][".printFields"].Add("eyear");
tdataArray["dbo__ABCSecurity"][".printFields"].Add("role");
fdata = SettingsMap.GetArray();
fdata["Index"] = 1;
fdata["strName"] = "ID";
fdata["GoodName"] = "ID";
fdata["ownerTable"] = "dbo._ABCSecurity";
fdata["Label"] = CommonFunctions.GetFieldLabel("dbo__ABCSecurity", "ID");
fdata["FieldType"] = 3;
fdata["strField"] = "ID";
fdata["isSQLExpression"] = true;
fdata["FullName"] = "ID";
fdata["UploadFolder"] = "files";
fdata["ViewFormats"] = SettingsMap.GetArray();
vdata = new XVar("ViewFormat", "");
vdata["NeedEncode"] = true;
fdata["ViewFormats"]["view"] = vdata;
fdata["EditFormats"] = SettingsMap.GetArray();
edata = new XVar("EditFormat", "Text field");
edata["IsRequired"] = true;
edata["acceptFileTypes"] = ".+$";
edata["maxNumberOfFiles"] = 1;
edata["HTML5InuptType"] = "number";
edata["EditParams"] = "";
edata["controlWidth"] = 200;
edata["validateAs"] = SettingsMap.GetArray();
edata["validateAs"]["basicValidate"] = SettingsMap.GetArray();
edata["validateAs"]["customMessages"] = SettingsMap.GetArray();
edata["validateAs"]["basicValidate"].Add(CommonFunctions.getJsValidatorName(new XVar("Number")));
edata["validateAs"]["basicValidate"].Add("IsRequired");
fdata["EditFormats"]["edit"] = edata;
fdata["isSeparate"] = false;
tdataArray["dbo__ABCSecurity"]["ID"] = fdata;
fdata = SettingsMap.GetArray();
fdata["Index"] = 2;
fdata["strName"] = "username";
fdata["GoodName"] = "username";
fdata["ownerTable"] = "dbo._ABCSecurity";
fdata["Label"] = CommonFunctions.GetFieldLabel("dbo__ABCSecurity", "username");
fdata["FieldType"] = 202;
fdata["bListPage"] = true;
fdata["bAddPage"] = true;
fdata["bInlineAdd"] = true;
fdata["bEditPage"] = true;
fdata["bInlineEdit"] = true;
fdata["bUpdateSelected"] = true;
fdata["bViewPage"] = true;
fdata["bAdvancedSearch"] = true;
fdata["bPrinterPage"] = true;
fdata["bExportPage"] = true;
fdata["strField"] = "username";
fdata["isSQLExpression"] = true;
fdata["FullName"] = "username";
fdata["FieldPermissions"] = true;
fdata["UploadFolder"] = "files";
fdata["ViewFormats"] = SettingsMap.GetArray();
vdata = new XVar("ViewFormat", "");
vdata["NeedEncode"] = true;
fdata["ViewFormats"]["view"] = vdata;
fdata["EditFormats"] = SettingsMap.GetArray();
edata = new XVar("EditFormat", "Text field");
edata["acceptFileTypes"] = ".+$";
edata["maxNumberOfFiles"] = 1;
edata["HTML5InuptType"] = "text";
edata["EditParams"] = "";
edata["EditParams"] = MVCFunctions.Concat(edata["EditParams"], " maxlength=255");
edata["controlWidth"] = 200;
edata["validateAs"] = SettingsMap.GetArray();
edata["validateAs"]["basicValidate"] = SettingsMap.GetArray();
edata["validateAs"]["customMessages"] = SettingsMap.GetArray();
fdata["EditFormats"]["edit"] = edata;
fdata["isSeparate"] = false;
fdata["searchOptionsList"] = new XVar(0, "Contains", 1, "Equals", 2, "Starts with", 3, "More than", 4, "Less than", 5, "Between", 6, "Empty", 7, Constants.NOT_EMPTY);
tdataArray["dbo__ABCSecurity"]["username"] = fdata;
fdata = SettingsMap.GetArray();
fdata["Index"] = 3;
fdata["strName"] = "password";
fdata["GoodName"] = "password";
fdata["ownerTable"] = "dbo._ABCSecurity";
fdata["Label"] = CommonFunctions.GetFieldLabel("dbo__ABCSecurity", "password");
fdata["FieldType"] = 202;
fdata["bListPage"] = true;
fdata["bAddPage"] = true;
fdata["bInlineAdd"] = true;
fdata["bEditPage"] = true;
fdata["bInlineEdit"] = true;
fdata["bUpdateSelected"] = true;
fdata["bViewPage"] = true;
fdata["bAdvancedSearch"] = true;
fdata["bPrinterPage"] = true;
fdata["bExportPage"] = true;
fdata["strField"] = "password";
fdata["isSQLExpression"] = true;
fdata["FullName"] = "password";
fdata["FieldPermissions"] = true;
fdata["UploadFolder"] = "files";
fdata["ViewFormats"] = SettingsMap.GetArray();
vdata = new XVar("ViewFormat", "");
vdata["NeedEncode"] = true;
fdata["ViewFormats"]["view"] = vdata;
fdata["EditFormats"] = SettingsMap.GetArray();
edata = new XVar("EditFormat", "Text field");
edata["acceptFileTypes"] = ".+$";
edata["maxNumberOfFiles"] = 1;
edata["HTML5InuptType"] = "text";
edata["EditParams"] = "";
edata["EditParams"] = MVCFunctions.Concat(edata["EditParams"], " maxlength=255");
edata["controlWidth"] = 200;
edata["validateAs"] = SettingsMap.GetArray();
edata["validateAs"]["basicValidate"] = SettingsMap.GetArray();
edata["validateAs"]["customMessages"] = SettingsMap.GetArray();
fdata["EditFormats"]["edit"] = edata;
fdata["isSeparate"] = false;
fdata["searchOptionsList"] = new XVar(0, "Contains", 1, "Equals", 2, "Starts with", 3, "More than", 4, "Less than", 5, "Between", 6, "Empty", 7, Constants.NOT_EMPTY);
tdataArray["dbo__ABCSecurity"]["password"] = fdata;
fdata = SettingsMap.GetArray();
fdata["Index"] = 4;
fdata["strName"] = "admin";
fdata["GoodName"] = "admin";
fdata["ownerTable"] = "dbo._ABCSecurity";
fdata["Label"] = CommonFunctions.GetFieldLabel("dbo__ABCSecurity", "admin");
fdata["FieldType"] = 11;
fdata["strField"] = "admin";
fdata["isSQLExpression"] = true;
fdata["FullName"] = "[admin]";
fdata["UploadFolder"] = "files";
fdata["ViewFormats"] = SettingsMap.GetArray();
vdata = new XVar("ViewFormat", "Checkbox");
fdata["ViewFormats"]["view"] = vdata;
fdata["EditFormats"] = SettingsMap.GetArray();
edata = new XVar("EditFormat", "Checkbox");
edata["acceptFileTypes"] = ".+$";
edata["maxNumberOfFiles"] = 1;
edata["controlWidth"] = 200;
edata["validateAs"] = SettingsMap.GetArray();
edata["validateAs"]["basicValidate"] = SettingsMap.GetArray();
edata["validateAs"]["customMessages"] = SettingsMap.GetArray();
fdata["EditFormats"]["edit"] = edata;
fdata["isSeparate"] = false;
tdataArray["dbo__ABCSecurity"]["admin"] = fdata;
fdata = SettingsMap.GetArray();
fdata["Index"] = 5;
fdata["strName"] = "byear";
fdata["GoodName"] = "byear";
fdata["ownerTable"] = "dbo._ABCSecurity";
fdata["Label"] = CommonFunctions.GetFieldLabel("dbo__ABCSecurity", "byear");
fdata["FieldType"] = 3;
fdata["bListPage"] = true;
fdata["bAddPage"] = true;
fdata["bInlineAdd"] = true;
fdata["bEditPage"] = true;
fdata["bInlineEdit"] = true;
fdata["bUpdateSelected"] = true;
fdata["bViewPage"] = true;
fdata["bAdvancedSearch"] = true;
fdata["bPrinterPage"] = true;
fdata["bExportPage"] = true;
fdata["strField"] = "byear";
fdata["isSQLExpression"] = true;
fdata["FullName"] = "byear";
fdata["FieldPermissions"] = true;
fdata["UploadFolder"] = "files";
fdata["ViewFormats"] = SettingsMap.GetArray();
vdata = new XVar("ViewFormat", "");
vdata["NeedEncode"] = true;
fdata["ViewFormats"]["view"] = vdata;
fdata["EditFormats"] = SettingsMap.GetArray();
edata = new XVar("EditFormat", "Text field");
edata["acceptFileTypes"] = ".+$";
edata["maxNumberOfFiles"] = 1;
edata["HTML5InuptType"] = "number";
edata["EditParams"] = "";
edata["controlWidth"] = 50;
edata["validateAs"] = SettingsMap.GetArray();
edata["validateAs"]["basicValidate"] = SettingsMap.GetArray();
edata["validateAs"]["customMessages"] = SettingsMap.GetArray();
edata["validateAs"]["basicValidate"].Add(CommonFunctions.getJsValidatorName(new XVar("Number")));
fdata["EditFormats"]["edit"] = edata;
fdata["isSeparate"] = false;
fdata["searchOptionsList"] = new XVar(0, "Contains", 1, "Equals", 2, "Starts with", 3, "More than", 4, "Less than", 5, "Between", 6, "Empty", 7, Constants.NOT_EMPTY);
tdataArray["dbo__ABCSecurity"]["byear"] = fdata;
fdata = SettingsMap.GetArray();
fdata["Index"] = 6;
fdata["strName"] = "eyear";
fdata["GoodName"] = "eyear";
fdata["ownerTable"] = "dbo._ABCSecurity";
fdata["Label"] = CommonFunctions.GetFieldLabel("dbo__ABCSecurity", "eyear");
fdata["FieldType"] = 3;
fdata["bListPage"] = true;
fdata["bAddPage"] = true;
fdata["bInlineAdd"] = true;
fdata["bEditPage"] = true;
fdata["bInlineEdit"] = true;
fdata["bUpdateSelected"] = true;
fdata["bViewPage"] = true;
fdata["bAdvancedSearch"] = true;
fdata["bPrinterPage"] = true;
fdata["bExportPage"] = true;
fdata["strField"] = "eyear";
fdata["isSQLExpression"] = true;
fdata["FullName"] = "eyear";
fdata["FieldPermissions"] = true;
fdata["UploadFolder"] = "files";
fdata["ViewFormats"] = SettingsMap.GetArray();
vdata = new XVar("ViewFormat", "");
vdata["NeedEncode"] = true;
fdata["ViewFormats"]["view"] = vdata;
fdata["EditFormats"] = SettingsMap.GetArray();
edata = new XVar("EditFormat", "Text field");
edata["acceptFileTypes"] = ".+$";
edata["maxNumberOfFiles"] = 1;
edata["HTML5InuptType"] = "number";
edata["EditParams"] = "";
edata["controlWidth"] = 50;
edata["validateAs"] = SettingsMap.GetArray();
edata["validateAs"]["basicValidate"] = SettingsMap.GetArray();
edata["validateAs"]["customMessages"] = SettingsMap.GetArray();
edata["validateAs"]["basicValidate"].Add(CommonFunctions.getJsValidatorName(new XVar("Number")));
fdata["EditFormats"]["edit"] = edata;
fdata["isSeparate"] = false;
fdata["searchOptionsList"] = new XVar(0, "Contains", 1, "Equals", 2, "Starts with", 3, "More than", 4, "Less than", 5, "Between", 6, "Empty", 7, Constants.NOT_EMPTY);
tdataArray["dbo__ABCSecurity"]["eyear"] = fdata;
fdata = SettingsMap.GetArray();
fdata["Index"] = 7;
fdata["strName"] = "role";
fdata["GoodName"] = "role";
fdata["ownerTable"] = "dbo._ABCSecurity";
fdata["Label"] = CommonFunctions.GetFieldLabel("dbo__ABCSecurity", "role");
fdata["FieldType"] = 202;
fdata["bListPage"] = true;
fdata["bAddPage"] = true;
fdata["bInlineAdd"] = true;
fdata["bEditPage"] = true;
fdata["bInlineEdit"] = true;
fdata["bUpdateSelected"] = true;
fdata["bViewPage"] = true;
fdata["bAdvancedSearch"] = true;
fdata["bPrinterPage"] = true;
fdata["bExportPage"] = true;
fdata["strField"] = "role";
fdata["isSQLExpression"] = true;
fdata["FullName"] = "[role]";
fdata["FieldPermissions"] = true;
fdata["UploadFolder"] = "files";
fdata["ViewFormats"] = SettingsMap.GetArray();
vdata = new XVar("ViewFormat", "");
vdata["NeedEncode"] = true;
fdata["ViewFormats"]["view"] = vdata;
fdata["EditFormats"] = SettingsMap.GetArray();
edata = new XVar("EditFormat", "Lookup wizard");
edata["LookupType"] = 0;
edata["autoCompleteFieldsOnEdit"] = 0;
edata["autoCompleteFields"] = SettingsMap.GetArray();
edata["LCType"] = 0;
edata["LookupValues"] = SettingsMap.GetArray();
edata["LookupValues"].Add("admin");
edata["LookupValues"].Add("readonly");
edata["LookupValues"].Add("member");
edata["SelectSize"] = 1;
edata["acceptFileTypes"] = ".+$";
edata["maxNumberOfFiles"] = 1;
edata["controlWidth"] = 200;
edata["validateAs"] = SettingsMap.GetArray();
edata["validateAs"]["basicValidate"] = SettingsMap.GetArray();
edata["validateAs"]["customMessages"] = SettingsMap.GetArray();
fdata["EditFormats"]["edit"] = edata;
fdata["isSeparate"] = false;
fdata["defaultSearchOption"] = "Equals";
fdata["searchOptionsList"] = new XVar(0, "Contains", 1, "Equals", 2, "Starts with", 3, "More than", 4, "Less than", 5, "Between", 6, "Empty", 7, Constants.NOT_EMPTY);
tdataArray["dbo__ABCSecurity"]["role"] = fdata;
GlobalVars.tables_data["dbo._ABCSecurity"] = tdataArray["dbo__ABCSecurity"];
GlobalVars.field_labels["dbo__ABCSecurity"] = fieldLabelsArray["dbo__ABCSecurity"];
GlobalVars.fieldToolTips["dbo__ABCSecurity"] = fieldToolTipsArray["dbo__ABCSecurity"];
GlobalVars.placeHolders["dbo__ABCSecurity"] = placeHoldersArray["dbo__ABCSecurity"];
GlobalVars.page_titles["dbo__ABCSecurity"] = pageTitlesArray["dbo__ABCSecurity"];
GlobalVars.detailsTablesData["dbo._ABCSecurity"] = SettingsMap.GetArray();
GlobalVars.masterTablesData["dbo._ABCSecurity"] = SettingsMap.GetArray();
strOriginalDetailsTable = "dbo._ABCVotes";
masterParams = SettingsMap.GetArray();
masterParams["mDataSourceTable"] = "dbo._ABCVotes";
masterParams["mOriginalTable"] = strOriginalDetailsTable;
masterParams["mShortTable"] = "dbo__ABCVotes";
masterParams["masterKeys"] = SettingsMap.GetArray();
masterParams["detailKeys"] = SettingsMap.GetArray();
masterParams["dispChildCount"] = 0;
masterParams["hideChild"] = 0;
masterParams["dispMasterInfo"] = SettingsMap.GetArray();
masterParams["previewOnList"] = 2;
masterParams["previewOnAdd"] = 0;
masterParams["previewOnEdit"] = 0;
masterParams["previewOnView"] = 0;
masterParams["proceedLink"] = 1;
masterParams["type"] = Constants.PAGE_LIST;
GlobalVars.masterTablesData["dbo._ABCSecurity"][0] = masterParams;
GlobalVars.masterTablesData["dbo._ABCSecurity"][0]["masterKeys"] = SettingsMap.GetArray();
GlobalVars.masterTablesData["dbo._ABCSecurity"][0]["masterKeys"].Add("committee_member");
GlobalVars.masterTablesData["dbo._ABCSecurity"][0]["detailKeys"] = SettingsMap.GetArray();
GlobalVars.masterTablesData["dbo._ABCSecurity"][0]["detailKeys"].Add("username");
SQLEntity obj = null;
var protoArray = SettingsMap.GetArray();
protoArray["0"] = SettingsMap.GetArray();
protoArray["0"]["m_strHead"] = "SELECT";
protoArray["0"]["m_strFieldList"] = "ID, username, password, [admin], byear, eyear, [role]";
protoArray["0"]["m_strFrom"] = "FROM dbo.[_ABCSecurity]";
protoArray["0"]["m_strWhere"] = "";
protoArray["0"]["m_strOrderBy"] = "";
protoArray["0"]["cipherer"] = null;
protoArray["2"] = SettingsMap.GetArray();
protoArray["2"]["m_sql"] = "";
protoArray["2"]["m_uniontype"] = "SQLL_UNKNOWN";
obj = new SQLNonParsed(new XVar("m_sql", ""));
protoArray["2"]["m_column"] = obj;
protoArray["2"]["m_contained"] = SettingsMap.GetArray();
protoArray["2"]["m_strCase"] = "";
protoArray["2"]["m_havingmode"] = false;
protoArray["2"]["m_inBrackets"] = false;
protoArray["2"]["m_useAlias"] = false;
obj = new SQLLogicalExpr(protoArray["2"]);
protoArray["0"]["m_where"] = obj;
protoArray["4"] = SettingsMap.GetArray();
protoArray["4"]["m_sql"] = "";
protoArray["4"]["m_uniontype"] = "SQLL_UNKNOWN";
obj = new SQLNonParsed(new XVar("m_sql", ""));
protoArray["4"]["m_column"] = obj;
protoArray["4"]["m_contained"] = SettingsMap.GetArray();
protoArray["4"]["m_strCase"] = "";
protoArray["4"]["m_havingmode"] = false;
protoArray["4"]["m_inBrackets"] = false;
protoArray["4"]["m_useAlias"] = false;
obj = new SQLLogicalExpr(protoArray["4"]);
protoArray["0"]["m_having"] = obj;
protoArray["0"]["m_fieldlist"] = SettingsMap.GetArray();
protoArray["6"] = SettingsMap.GetArray();
obj = new SQLField(new XVar("m_strName", "ID", "m_strTable", "dbo._ABCSecurity", "m_srcTableName", "dbo._ABCSecurity"));
protoArray["6"]["m_sql"] = "ID";
protoArray["6"]["m_srcTableName"] = "dbo._ABCSecurity";
protoArray["6"]["m_expr"] = obj;
protoArray["6"]["m_alias"] = "";
obj = new SQLFieldListItem(protoArray["6"]);
protoArray["0"]["m_fieldlist"].Add(obj);
protoArray["8"] = SettingsMap.GetArray();
obj = new SQLField(new XVar("m_strName", "username", "m_strTable", "dbo._ABCSecurity", "m_srcTableName", "dbo._ABCSecurity"));
protoArray["8"]["m_sql"] = "username";
protoArray["8"]["m_srcTableName"] = "dbo._ABCSecurity";
protoArray["8"]["m_expr"] = obj;
protoArray["8"]["m_alias"] = "";
obj = new SQLFieldListItem(protoArray["8"]);
protoArray["0"]["m_fieldlist"].Add(obj);
protoArray["10"] = SettingsMap.GetArray();
obj = new SQLField(new XVar("m_strName", "password", "m_strTable", "dbo._ABCSecurity", "m_srcTableName", "dbo._ABCSecurity"));
protoArray["10"]["m_sql"] = "password";
protoArray["10"]["m_srcTableName"] = "dbo._ABCSecurity";
protoArray["10"]["m_expr"] = obj;
protoArray["10"]["m_alias"] = "";
obj = new SQLFieldListItem(protoArray["10"]);
protoArray["0"]["m_fieldlist"].Add(obj);
protoArray["12"] = SettingsMap.GetArray();
obj = new SQLField(new XVar("m_strName", "admin", "m_strTable", "dbo._ABCSecurity", "m_srcTableName", "dbo._ABCSecurity"));
protoArray["12"]["m_sql"] = "[admin]";
protoArray["12"]["m_srcTableName"] = "dbo._ABCSecurity";
protoArray["12"]["m_expr"] = obj;
protoArray["12"]["m_alias"] = "";
obj = new SQLFieldListItem(protoArray["12"]);
protoArray["0"]["m_fieldlist"].Add(obj);
protoArray["14"] = SettingsMap.GetArray();
obj = new SQLField(new XVar("m_strName", "byear", "m_strTable", "dbo._ABCSecurity", "m_srcTableName", "dbo._ABCSecurity"));
protoArray["14"]["m_sql"] = "byear";
protoArray["14"]["m_srcTableName"] = "dbo._ABCSecurity";
protoArray["14"]["m_expr"] = obj;
protoArray["14"]["m_alias"] = "";
obj = new SQLFieldListItem(protoArray["14"]);
protoArray["0"]["m_fieldlist"].Add(obj);
protoArray["16"] = SettingsMap.GetArray();
obj = new SQLField(new XVar("m_strName", "eyear", "m_strTable", "dbo._ABCSecurity", "m_srcTableName", "dbo._ABCSecurity"));
protoArray["16"]["m_sql"] = "eyear";
protoArray["16"]["m_srcTableName"] = "dbo._ABCSecurity";
protoArray["16"]["m_expr"] = obj;
protoArray["16"]["m_alias"] = "";
obj = new SQLFieldListItem(protoArray["16"]);
protoArray["0"]["m_fieldlist"].Add(obj);
protoArray["18"] = SettingsMap.GetArray();
obj = new SQLField(new XVar("m_strName", "role", "m_strTable", "dbo._ABCSecurity", "m_srcTableName", "dbo._ABCSecurity"));
protoArray["18"]["m_sql"] = "[role]";
protoArray["18"]["m_srcTableName"] = "dbo._ABCSecurity";
protoArray["18"]["m_expr"] = obj;
protoArray["18"]["m_alias"] = "";
obj = new SQLFieldListItem(protoArray["18"]);
protoArray["0"]["m_fieldlist"].Add(obj);
protoArray["0"]["m_fromlist"] = SettingsMap.GetArray();
protoArray["20"] = SettingsMap.GetArray();
protoArray["20"]["m_link"] = "SQLL_MAIN";
protoArray["21"] = SettingsMap.GetArray();
protoArray["21"]["m_strName"] = "dbo._ABCSecurity";
protoArray["21"]["m_srcTableName"] = "dbo._ABCSecurity";
protoArray["21"]["m_columns"] = SettingsMap.GetArray();
protoArray["21"]["m_columns"].Add("ID");
protoArray["21"]["m_columns"].Add("username");
protoArray["21"]["m_columns"].Add("password");
protoArray["21"]["m_columns"].Add("admin");
protoArray["21"]["m_columns"].Add("byear");
protoArray["21"]["m_columns"].Add("eyear");
protoArray["21"]["m_columns"].Add("role");
obj = new SQLTable(protoArray["21"]);
protoArray["20"]["m_table"] = obj;
protoArray["20"]["m_sql"] = "dbo.[_ABCSecurity]";
protoArray["20"]["m_alias"] = "";
protoArray["20"]["m_srcTableName"] = "dbo._ABCSecurity";
protoArray["22"] = SettingsMap.GetArray();
protoArray["22"]["m_sql"] = "";
protoArray["22"]["m_uniontype"] = "SQLL_UNKNOWN";
obj = new SQLNonParsed(new XVar("m_sql", ""));
protoArray["22"]["m_column"] = obj;
protoArray["22"]["m_contained"] = SettingsMap.GetArray();
protoArray["22"]["m_strCase"] = "";
protoArray["22"]["m_havingmode"] = false;
protoArray["22"]["m_inBrackets"] = false;
protoArray["22"]["m_useAlias"] = false;
obj = new SQLLogicalExpr(protoArray["22"]);
protoArray["20"]["m_joinon"] = obj;
obj = new SQLFromListItem(protoArray["20"]);
protoArray["0"]["m_fromlist"].Add(obj);
protoArray["0"]["m_groupby"] = SettingsMap.GetArray();
protoArray["0"]["m_orderby"] = SettingsMap.GetArray();
protoArray["0"]["m_srcTableName"] = "dbo._ABCSecurity";
obj = new SQLQuery(protoArray["0"]);
queryData_Array["dbo__ABCSecurity"] = obj;
tdataArray["dbo__ABCSecurity"][".sqlquery"] = queryData_Array["dbo__ABCSecurity"];
GlobalVars.tableEvents["dbo._ABCSecurity"] = new eventsBase();
tdataArray["dbo__ABCSecurity"][".hasEvents"] = false;
GlobalVars.tables_data["dbo__ABCSecurity"] = tdataArray["dbo__ABCSecurity"];
}
/// <summary>
/// Write ALL values to INI.
/// </summary>
public bool WriteSettingToIni(Control control)
{
var item = SettingsMap.FirstOrDefault(x => x.Control == control);
return(WriteSettingsToIni(item));
}
/// <summary>
/// Write value to INI file by control.
/// </summary>
public bool WriteAllSettingsToINI()
{
return(WriteSettingsToIni(SettingsMap.ToArray()));
}
public static NotifySettings EnsureSettings(Type t)
{
if (t == null || !t.IsEqualOrChildOf <NotifyGump>())
{
return(null);
}
Type st;
if (SettingsMap.TryGetValue(t, out st) && st != null)
{
var o = Settings.GetValue(st);
if (o != null)
{
return(o);
}
}
const BindingFlags f = BindingFlags.DeclaredOnly | BindingFlags.Static | BindingFlags.NonPublic;
var m = t.GetMethod("InitSettings", f);
if (m == null)
{
foreach (var p in t.EnumerateHierarchy())
{
m = p.GetMethod("InitSettings", f);
if (m != null)
{
st = p;
break;
}
}
}
if (st == null)
{
st = t;
}
var init = false;
NotifySettings settings;
if (!Settings.TryGetValue(st, out settings) || settings == null)
{
Settings[st] = settings = new NotifySettings(st);
init = true;
}
SettingsMap[t] = st;
if (init && m != null)
{
m.Invoke(null, new object[] { settings });
}
return(settings);
}
