public static void CreateTableUI()
{
int StackPointer = Stack.Add("UI.CreateTableUI()");
Controls.HideControl(GlobalStatic.Dataview);
Controls.HideControl(GlobalStatic.ListView);
GlobalStatic.ListView = null;
HideDisplayResults();
ClearWindow();
LDGraphicsWindow.CancelClose = true;
LDGraphicsWindow.ExitOnClose = false;
GlobalStatic.Dataview = LDControls.AddDataView((Desktop.Width - 10), (Desktop.Height - 100), "1=Field;2=Type;3=PK;4=AI;5=Unique;6=Not_Null;");
GraphicsWindow.DrawText(1, 4, "Name: ");
Controls.Move(GlobalStatic.Dataview, 1, 30);
_TextBox["Table_Name"] = Controls.AddTextBox(50, 1);
Controls.SetTextBoxText(_TextBox["Table_Name"], "Table1");
_Buttons.AddOrReplace("Commit", Controls.AddButton("Commit", 250, 1));
_Buttons.AddOrReplace("Exit", Controls.AddButton("Exit", 350, 1));
LDControls.DataViewSetColumnComboBox(GlobalStatic.Dataview, 2, "1=Integer;2=Text;3=Blob;4=Real;5=Numeric;");
for (int i = 3; i <= 6; i++)
{
LDControls.DataViewSetColumnCheckBox(GlobalStatic.Dataview, i);
}
Controls.ButtonClicked -= Events.BC;
Controls.ButtonClicked += CreateTableHandler;
Stack.Exit(StackPointer);
}
public static void Display(Google_Charts.Chart chart)
{
int StackPointer = Stack.Add("UI.Charts.Display()");
Charts.chart = chart;
ClearWindow();
GraphicsWindow.Title = "Charts";
LDGraphicsWindow.CancelClose = true;
LDGraphicsWindow.ExitOnClose = false;
LDGraphicsWindow.Closing += Events.Closing;
LDGraphicsWindow.ExitButtonMode(GraphicsWindow.Title, "Disabled");
XColumns.Clear();
YColumns.Clear();
Schema = Export.GenerateSchemaListFromLastQuery();
//UI Stuff
GraphicsWindow.FontSize = GlobalStatic.DefaultFontSize + 12;
GraphicsWindow.DrawText(5, 10, string.Format("Min Columns {0}", chart.MinColumns));
GraphicsWindow.DrawText(5, 30, string.Format("Max Columns {0}", chart.MaxColumns));
Inequality = Shapes.AddText("Equation");
Shapes.Move(Inequality, 400, 5);
GraphicsWindow.DrawText(5, 70, "X:");
GraphicsWindow.DrawText(300 + 100, 70, "Columns:");
GraphicsWindow.DrawText(600 + 200, 70, "Y:");
GraphicsWindow.DrawText(5, 450, "Title");
GraphicsWindow.DrawText(5, 500, "SubTitle");
GraphicsWindow.DrawText(5, 550, "X axis");
GraphicsWindow.DrawText(5, 600, "Y axis");
GraphicsWindow.FontSize = GlobalStatic.DefaultFontSize;
XListBox = LDControls.AddListBox("", 300, 300);
SchemaListBox = LDControls.AddListBox(Schema.ToPrimitiveArray(), 300, 300);
YListBox = LDControls.AddListBox("", 300, 300);
DataView = LDControls.AddDataView(300, 300, "1=Column;2=Type;");
LDControls.DataViewSetColumnComboBox(DataView, 2, "1=Text;2=Number;");
if (Desktop.Width < 1500)
{
LDScrollBars.Add(1920, 0);
}
Controls.Move(XListBox, 5, 100);
Controls.Move(SchemaListBox, 300 + 100, 100);
Controls.Move(YListBox, 600 + 200, 100);
Controls.Move(DataView, 1200, 100);
Left1 = Controls.AddButton("<", 325, 200);
Right1 = Controls.AddButton(">", 325, 250);
Left2 = Controls.AddButton("<", 725, 200);
Right2 = Controls.AddButton(">", 725, 250);
GenerateChartButton = Controls.AddButton("Generate Chart", 300, 500);
Controls.Move(GenerateChartButton, 800, 550);
Controls.SetSize(GenerateChartButton, 100, 30);
//TODO Add TextBoxes for Title,SubTitle,X axis caption, and y axis caption
TitleTB = Controls.AddTextBox(130, 450);
SubTitleTB = Controls.AddTextBox(130, 500);
XaxisCaptionTB = Controls.AddTextBox(130, 550);
YaxisCaptionTB = Controls.AddTextBox(130, 600);
Controls.SetSize(TitleTB, 200, 30);
Controls.SetSize(SubTitleTB, 200, 30);
Controls.SetSize(XaxisCaptionTB, 200, 30);
Controls.SetSize(YaxisCaptionTB, 200, 30);
Escape = Controls.AddButton("Esc", 50, 500);
Controls.Move(Escape, 800, 500);
Controls.SetSize(Escape, 100, 30);
//TODO Add Region options for GeoCharts
//TODO Allow users to specify data type (Number,string,eventually Datetime etc).
//Otherwise attempt to grab that data from the db?
Controls.SetSize(Left1, 50, 30);
Controls.SetSize(Right1, 50, 30);
Controls.SetSize(Left2, 50, 30);
Controls.SetSize(Right2, 50, 30);
//Event Handler Unhooking
Controls.ButtonClicked -= Events.BC;
//Event Handler Hooking
Controls.ButtonClicked += Handler;
AutoHide();
Stack.Exit(StackPointer);
}
