public static void MainMenu()
{
int StackReference = Stack.Add("UI.MainMenu()");
LDGraphicsWindow.ExitButtonMode(GraphicsWindow.Title, "Enabled");
GraphicsWindow.CanResize = true;
LDGraphicsWindow.State = 2;
GraphicsWindow.Title = GlobalStatic.Title + " ";
Primitive Sorts = $"1={Language.Localization["Table"]};2={Language.Localization["View"]};3={Language.Localization["Index"]};4={Language.Localization["Master Table"]};";
if (Engines.CurrentDatabase != null && Engines.CurrentDatabase != null)
{
Engines.GetSchema(Engines.CurrentDatabase);
}
GraphicsWindow.FontSize = GlobalStatic.DefaultFontSize + 8;
int UIx = GlobalStatic.Listview_Width - 380;
string Menu = LDControls.AddMenu(Desktop.Width * 1.5, 30, MenuList, IconList, null);
Shapes.Move(Shapes.AddText(Language.Localization["Sort"] + ":"), UIx, 1);
int TextWidth = LDText.GetHeight(Language.Localization["Sort"] + ":");
GraphicsWindow.FontSize = GlobalStatic.DefaultFontSize;
try
{
GlobalStatic.ComboBox["Table"] = LDControls.AddComboBox(Engines.Tables.ToPrimitiveArray(), 100, 100);
}
catch (Exception ex)
{
Events.LogMessage(ex.ToString(), "System");
}
GlobalStatic.ComboBox["Sorts"] = LDControls.AddComboBox(Sorts, 100, 100);
GlobalStatic.ComboBox["Database"] = LDControls.AddComboBox(Engines.DB_ShortName.ToPrimitiveArray(), 100, 100);
Controls.Move(GlobalStatic.ComboBox["Database"], UIx + TextWidth + 35, 5);
Controls.Move(GlobalStatic.ComboBox["Sorts"], UIx + TextWidth + 150, 5);
Controls.Move(GlobalStatic.ComboBox["Table"], UIx + TextWidth + 260, 5);
//Virtual Call to Handler
Events.MC(Language.Localization["View"]);
Title();
Controls.ButtonClicked += Events.BC;
LDControls.MenuClicked += Events.MC;
LDControls.ComboBoxItemChanged += Events.CB;
LDControls.ContextMenuClicked += Events.MI;
Stack.Exit(StackReference);
}
public static void DisplayResults()
{
int StackPointer = Stack.Add("UI.DisplayResults()");
LDGraphicsWindow.PauseUpdates();
//Clears the Dictionary to prevent errors
_Buttons.Clear();
_TextBox.Clear();
/*
* _CheckBox.Clear();
* _ComboBox.Clear();
*/
LDGraphicsWindow.Width = Desktop.Width;
LDGraphicsWindow.Height = Desktop.Height;
GraphicsWindow.Left = 0;
GraphicsWindow.Top = 0;
GlobalStatic.UIx = GlobalStatic.Listview_Width + 50;
DisplayHelper();
//Sort
GraphicsWindow.FontSize = GlobalStatic.DefaultFontSize + 1;
string AscDesc = "1=" + Language.Localization["Asc"] + ";2=" + Language.Localization["Desc"] + ";3=RANDOM();";
GlobalStatic.ComboBox["Sort"] = LDControls.AddComboBox(Engines.Schema, 100, 100);
GlobalStatic.ComboBox["ASCDESC"] = LDControls.AddComboBox(AscDesc, 110, 100);
_Buttons.AddOrReplace("Sort", Controls.AddButton(Language.Localization["Sort"], GlobalStatic.UIx + 10, 120));
Controls.Move(GlobalStatic.ComboBox["Sort"], GlobalStatic.UIx + 80, 77);
Controls.Move(GlobalStatic.ComboBox["ASCDESC"], GlobalStatic.UIx + 190, 77);
Controls.SetSize(_Buttons["Sort"], 290, 30);
LDDialogs.ToolTip(_Buttons["Sort"], "Iniates a sort based on user set parameters"); //Localize
LDDialogs.ToolTip(GlobalStatic.ComboBox["ASCDESC"], "Sorts Ascending and Decending based on position"); //Localize
//Search
GlobalStatic.ComboBox["Search"] = LDControls.AddComboBox(Engines.Schema, 200, 120);
_TextBox.AddOrReplace("Search", Controls.AddTextBox(GlobalStatic.UIx + 100, 210));
GlobalStatic.CheckBox["StrictSearch"] = LDControls.AddCheckBox(Language.Localization["Strict Search"]);
GlobalStatic.CheckBox["InvertSearch"] = LDControls.AddCheckBox(Language.Localization["Invert"]);
_Buttons.AddOrReplace("Search", Controls.AddButton(Language.Localization["Search"].ToUpper(), GlobalStatic.UIx + 10, 260));
Controls.Move(GlobalStatic.CheckBox["StrictSearch"], GlobalStatic.UIx + 20, 240);
Controls.Move(GlobalStatic.CheckBox["InvertSearch"], GlobalStatic.UIx + 150, 240);
Controls.Move(GlobalStatic.ComboBox["Search"], GlobalStatic.UIx + 100, 180);
Controls.SetSize(_TextBox["Search"], 200, 25);
Controls.SetSize(_Buttons["Search"], 290, 30);
//Functions
GlobalStatic.ComboBox["FunctionList"] = LDControls.AddComboBox(Engines.Functions(Engines.CurrentEngine).ToPrimitiveArray(), 130, 100);
GlobalStatic.ComboBox["ColumnList"] = LDControls.AddComboBox(Engines.Schema, 135, 100);
Controls.Move(GlobalStatic.ComboBox["FunctionList"], GlobalStatic.UIx + 10, 315);
Controls.Move(GlobalStatic.ComboBox["ColumnList"], GlobalStatic.UIx + 160, 315);
_Buttons.AddOrReplace("RunFunction", Controls.AddButton(Language.Localization["Run Function"].ToUpper(), GlobalStatic.UIx + 10, 345));
Controls.SetSize(_Buttons["RunFunction"], 290, 30);
//Custom Query
_TextBox["CustomQuery"] = Controls.AddMultiLineTextBox(GlobalStatic.UIx, 420);
Controls.SetSize(_TextBox["CustomQuery"], 310, 150);
_Buttons.AddOrReplace("Query", Controls.AddButton(Language.Localization["Query"].ToUpper(), GlobalStatic.UIx, 580));
Controls.SetSize(_Buttons["Query"], 310, 30);
_Buttons.AddOrReplace("Command", Controls.AddButton(Language.Localization["Command"].ToUpper(), GlobalStatic.UIx, 615));
Controls.SetSize(_Buttons["Command"], 310, 30);
LDDialogs.ToolTip(_Buttons["Command"], "Executes customized SQL command statements onto the database"); //Localize
string CustomQueryData = "This Textbox allows you to use Custom\nSQL Queries. Remove this and type in an SQL \nstatement. \nYou also use it to export data"; //Localize
Controls.SetTextBoxText(_TextBox["CustomQuery"], CustomQueryData);
//Hide Display Results
_HideDisplay.Clear();
_HideDisplay.Add(GlobalStatic.ComboBox["Sort"]);
_HideDisplay.Add(GlobalStatic.ComboBox["ASCDESC"]);
_HideDisplay.Add(Buttons["Sort"]);
_HideDisplay.Add(GlobalStatic.ComboBox["Search"]);
_HideDisplay.Add(_TextBox["Search"]);
_HideDisplay.Add(GlobalStatic.CheckBox["StrictSearch"]);
_HideDisplay.Add(GlobalStatic.CheckBox["InvertSearch"]);
_HideDisplay.Add(Buttons["Search"]);
_HideDisplay.Add(GlobalStatic.ComboBox["FunctionList"]);
_HideDisplay.Add(GlobalStatic.ComboBox["ColumnList"]);
_HideDisplay.Add(Buttons["RunFunction"]);
_HideDisplay.Add(_TextBox["CustomQuery"]);
_HideDisplay.Add(Buttons["Query"]);
_HideDisplay.Add(Buttons["Command"]);
LDGraphicsWindow.ResumeUpdates();
Stack.Exit(StackPointer);
}
public static void Display()
{
int StackPointer = Stack.Add("UI.Settings.Display()");
ClearWindow();
GraphicsWindow.Title = Language.Localization["Settings"];
GraphicsWindow.CanResize = false;
LDGraphicsWindow.CancelClose = true;
LDGraphicsWindow.ExitOnClose = false;
LDGraphicsWindow.Closing += Events.Closing;
LDGraphicsWindow.ExitButtonMode(Language.Localization["Settings"], "Disabled");
GraphicsWindow.FontSize = GlobalStatic.DefaultFontSize + 8;
GraphicsWindow.DrawText(10, 10, Language.Localization["Listview Width"]);
_TextBox["Settings_Width"] = Controls.AddTextBox(200, 10);
GraphicsWindow.DrawText(10, 50, Language.Localization["Listview Height"]);
_TextBox["Settings_Height"] = Controls.AddTextBox(200, 50);
GraphicsWindow.DrawText(10, 90, Language.Localization["Extensions"]);
_TextBox["Settings_Extensions"] = Controls.AddTextBox(200, 90);
GraphicsWindow.DrawText(10, 130, Language.Localization["Deliminator"]);
_TextBox["Settings_Deliminator"] = Controls.AddTextBox(200, 130);
GraphicsWindow.DrawText(10, 175, Language.Localization["Language"]);
GlobalStatic.ComboBox["Language"] = LDControls.AddComboBox(Language.ISO_Text.ToPrimitiveArray(), 200, 120);
Controls.Move(GlobalStatic.ComboBox["Language"], 200, 175);
GraphicsWindow.DrawText(10, 280, Language.Localization["LOG CSV Path"]);
_Buttons.AddOrReplace("Log_CSV", Controls.AddButton(Language.Localization["Browse"], 320, 280));
GraphicsWindow.DrawText(10, 330, Language.Localization["LOG DB PATH"]);
_Buttons.AddOrReplace("Log_DB", Controls.AddButton(Language.Localization["Browse"], 320, 330));
GraphicsWindow.DrawText(10, 380, Language.Localization["Transaction DB Path"]);
_Buttons.AddOrReplace("Transaction_DB", Controls.AddButton(Language.Localization["Browse"], 320, 380));
for (int i = 0; i < Language.ISO_LangCode.Count; i++)
{
if (Language.ISO_LangCode[i] == GlobalStatic.LanguageCode)
{
int Index = i + 1;
LDControls.ComboBoxSelect(GlobalStatic.ComboBox["Language"], Index);
}
}
_Buttons.AddOrReplace("Settings Save", Controls.AddButton(Language.Localization["Save and Close"], 50, 450));
_Buttons.AddOrReplace("Settings Close", Controls.AddButton(Language.Localization["Close wo saving"], 50, 500));
Controls.SetSize(_Buttons["Settings Save"], 280, 40);
Controls.SetSize(_Buttons["Settings Close"], 280, 40);
Controls.SetTextBoxText(_TextBox["Settings_Width"], GlobalStatic.Listview_Width);
Controls.SetTextBoxText(_TextBox["Settings_Height"], GlobalStatic.Listview_Height);
Controls.SetTextBoxText(_TextBox["Settings_Extensions"], GlobalStatic.Extensions);
Controls.SetTextBoxText(_TextBox["Settings_Deliminator"], GlobalStatic.Deliminator);
GraphicsWindow.FontSize = GlobalStatic.DefaultFontSize;
LDControls.ComboBoxItemChanged -= Events.CB;
Controls.ButtonClicked -= Events.BC;
Controls.ButtonClicked += Handler;
Stack.Exit(StackPointer);
}