public override void GenForm()
{
Button b = ControlGenerator.CreateButton(10, 10, Settings.formWidth - 40, 50, "Insert");
ControlGenerator.BindNavButton(b, new FormInsert());
b = ControlGenerator.CreateButton(10, 70, Settings.formWidth - 40, 50, "Update/Delete");
ControlGenerator.BindNavButton(b, new FormUpdateDelete());
b = ControlGenerator.CreateButton(10, 130, Settings.formWidth - 40, 50, "Search");
ControlGenerator.BindNavButton(b, new FormSearch());
}
private static void CreateFieldLabelsandText(string sql, bool useData = false)
{
using (SqlConnection con = new SqlConnection(connectionString))
{
con.Open();
try
{
using (SqlCommand command = new SqlCommand(sql, con))
{
using (SqlDataReader reader = command.ExecuteReader())
{
for (int i = 0; i < reader.FieldCount; i++)
{
string field = reader.GetName(i);
Label l = ControlGenerator.CreateLabel(0, 0, field);
tableData.Controls.Add(l);
if (useData)
{
TextBox t = ControlGenerator.CreateTextBox(0, 0, Settings.formWidth - 50, 50);
t.Name = "textBox" + field;
tableData.Controls.Add(t);
tableData.SetFlowBreak(t, true);
}
else
{
tableData.SetFlowBreak(l, true);
}
}
}
}
}
catch (SqlException e)
{
HandleError(e);
}
try
{
string f = getPKFromTable.Replace("table", currentTableData);
using (SqlCommand command = new SqlCommand(f, con))
{
using (SqlDataReader reader = command.ExecuteReader())
{
reader.Read();
PKColumnName = reader.GetString(0);
}
}
}
catch (SqlException e)
{
HandleError(e);
}
}
}
public override void GenForm()
{
ControlGenerator.CreateLabel(10, 10, "Insert");
Button b = ControlGenerator.CreateButton(10, 40, 100, 50, "Back");
ControlGenerator.BindNavButton(b, new FormMain());
ControlGenerator.CreateLabel(120, 10, "Select table");
ComboBox c = ControlGenerator.CreateComboBox(120, 40, 100);
ControlGenerator.SetComboBoxToTableList(c);
b = ControlGenerator.CreateButton(250, 40, 100, 50, "Insert");
ControlGenerator.BindInsertButton(b);
ControlGenerator.BindComboBoxLoadTableInfo(c, 10, 100, false);
}
private static void CreateInitialFlowLayout(int x, int y)
{
if (tableData != null)
{
foreach (Control c in tableData.Controls)
{
ControlGenerator.RemoveControl(c);
}
tableData.Controls.Clear();
}
ControlGenerator.RemoveControl(tableData);
tableData = ControlGenerator.CreateFlowLayoutPanel();
tableData.Height = Settings.formHeight - y - 20;
tableData.Width = Settings.formWidth - x - 20;
tableData.Location = new Point(x, y);
}
public override void GenForm()
{
ControlGenerator.CreateLabel(10, 10, "Update/Delete");
Button b = ControlGenerator.CreateButton(10, 40, 100, 50, "Back");
ControlGenerator.BindNavButton(b, new FormMain());
ControlGenerator.CreateLabel(120, 10, "Select table");
ComboBox c = ControlGenerator.CreateComboBox(120, 40, 100);
ControlGenerator.SetComboBoxToTableList(c);
ControlGenerator.BindComboBoxLoadTableInfo(c, 10, 100, true);
b = ControlGenerator.CreateButton(250, 40, 100, 50, "Update");
ControlGenerator.BindUpdateButton(b);
b = ControlGenerator.CreateButton(360, 40, 100, 50, "Delete");
ControlGenerator.BindDeleteButton(b);
b = ControlGenerator.CreateButton(120, 70, 50, 30, "<");
ControlGenerator.BindChangeRecord(b, false);
b = ControlGenerator.CreateButton(190, 70, 50, 30, ">");
ControlGenerator.BindChangeRecord(b, true);
}
public override void GenForm()
{
ControlGenerator.CreateLabel(10, 10, "Search");
Button b = ControlGenerator.CreateButton(10, 40, 100, 50, "Back");
ControlGenerator.BindNavButton(b, new FormMain());
ControlGenerator.CreateLabel(120, 10, "Select table");
ComboBox c = ControlGenerator.CreateComboBox(120, 40, 100);
ControlGenerator.SetComboBoxToTableList(c);
ControlGenerator.CreateLabel(120, 80, "Select Field");
ComboBox c2 = ControlGenerator.CreateComboBox(120, 110, 100);
ControlGenerator.SetComboBoxToFillTableFieldsOfComboBox(c, c2);
ControlGenerator.CreateLabel(120, 160, "Type search parameters");
TextBox t = ControlGenerator.CreateTextBox(120, 190, 120, 100);
b = ControlGenerator.CreateButton(260, 40, 100, 100, "Search");
ControlGenerator.BindSearch(b, 10, 250, c, c2, t);
b = ControlGenerator.CreateButton(370, 70, 50, 30, "<");
ControlGenerator.BindChangeRecord(b, false);
b = ControlGenerator.CreateButton(420, 70, 50, 30, ">");
ControlGenerator.BindChangeRecord(b, true);
}