private void parmExecute(EHow how)
{
if (allowUpdates == false && how != EHow.DISPLAY)
return;
string where = "", c = "", query = "";
int row = -1;
int field;
DataTable data = null;
int offset = pcTable.offsetFields;
if (tablesDataGrid.CurrentRow != null)
{
where = "WHERE ";
row = tablesDataGrid.CurrentRow.Index;
data = tablesDataGrid.DataSource as DataTable;
for (int k = 0; k < pcTable.noKeyFields; k++)
{
int okfield = k + pcTable.offsetKeyFields;
field = pcKeyFields[okfield].index;
string value = data.Rows[row][field].ToString();
TPCField pcField = pcFields[offset + field];
string ready = sqlReady(pcField, value);
where += c + pcFields[offset + field].name + " = " + ready;
c = " AND ";
}
}
string oldUsId = "";
string oldTmStamp = "";
string newUsId = "";
string newTmStamp = "";
if (row != -1)
{
int no = pcTable.noFields;
oldUsId = data.Rows[row][no].ToString();
oldTmStamp = DateTime.Parse(data.Rows[row][no + 1].ToString()).ToString("yyyyMMddhhmmss");
}
List<EntryItem> edits = new List<EntryItem>(pcTable.noFields);
ScaffoldForm form = scaffoldForm = new ScaffoldForm(this, how, edits);
int comboWidth = form.ClientSize.Width - 132;
int editWidth = comboWidth - 18;
// The next 3 lines are indicative of why properties are at best second class.
Size size = form.MinimumSize;
size.Height = pcTable.noFields * 24 + 66;
form.MinimumSize = size;
Dictionary<int, ComboBox> combos = new Dictionary<int, ComboBox>();
for (field = 0; field < pcTable.noFields; field++)
{
EntryItem edit = new EntryItem();
edits.Add(edit);
TPCField pcField = pcFields[field + offset];
edit.ofType = pcField.type;
edit.isNull = pcField.isNull == 1;
if (how != EHow.ADD && (how == EHow.DELETE || how == EHow.DISPLAY || isKey(pcTable, field))
|| (how == EHow.ADD && pcField.type == DBHandler.PC_SEQUENCE))
edit.isReadOnly = true;
if (pcField.uppercase == 1 || isKey(pcTable, field) == true)
edit.uppercase = true;
Label label = edit.label = new Label();
label.Text = pcField.name;
label.Top = field * 24 + 4;
label.Left = 4;
form.CapturePanel.Controls.Add(label);
if (showSetup.Checked == true)
LogDebug = label.Text + " " + label.Top + " " + label.Left;
string setupWork = pcField.name;
string value = "";
if (how == EHow.ADD || (how == EHow.CHANGE && isKey(pcTable, field) == false))
{
value = row != -1 ? data.Rows[row][field].ToString() : "";
if (clearAdd.Checked == true && how == EHow.ADD) value = "";
int link; int pair;
if (setupLink(pcTable, field, out link, out pair))
{
setupWork += " Is Link Field";
if (sizeIsOk(link) == true)
{
setupWork += " and is not too large";
if (pair == 0)
{
newDropDown(edit, pcTable.index, link, field * 24 + 4, 124, comboWidth, value);
combos.Add(link, edit.combo);
edit.pair = pair;
form.CapturePanel.Controls.Add(edit.combo);
if (showSetup.Checked == true)
LogDebug = setupWork;
}
else
{
setupWork += " is extra link pair field";
edit.isReadOnly = true;
edit.combo = combos[link];
edit.pair = pair;
edit.combo.SelectedIndexChanged += new EventHandler(editComboSelectedIndexChanged);
edit.Text(field * 24 + 4, 124, editWidth, maxLength(pcField), value);
List<EntryItem> list = (List<EntryItem>)edit.combo.Tag;
list.Add(edit);
form.CapturePanel.Controls.Add(edit.text);
}
continue;
}
}
else if (pcField.noEnums > 0)
{
setupWork += " Is Enum Field";
enumDropDown(edit, field + offset, field * 24 + 4, 124, comboWidth, value);
form.CapturePanel.Controls.Add(edit.combo);
if (showSetup.Checked == true)
LogDebug = setupWork;
continue;
}
}
value = row != -1 ? data.Rows[row][field].ToString() : "";
if (clearAdd.Checked == true && how == EHow.ADD) value = "";
switch (pcField.type)
{
case DBHandler.PC_CHAR:
case DBHandler.PC_USERSTAMP:
{
setupWork += " Is Text Field";
edit.Text(field * 24 + 4, 124, editWidth, maxLength(pcField), value);
form.CapturePanel.Controls.Add(edit.text);
}
break;
case DBHandler.PC_DATE:
{
setupWork += " Is Date Field";
edit.Date(field * 24 + 4, 124, comboWidth, value);
form.CapturePanel.Controls.Add(edit.date);
}
break;
case DBHandler.PC_DATETIME:
case DBHandler.PC_TIMESTAMP:
{
setupWork += " Is Date Time Field";
edit.Date(field * 24 + 4, 124, comboWidth * 8 / 14, value);
form.CapturePanel.Controls.Add(edit.date);
edit.Time(field * 24 + 4, 124 + edit.date.Width + 4, comboWidth * 6 / 14 - 4, value);
form.CapturePanel.Controls.Add(edit.time);
}
break;
case DBHandler.PC_TIME:
{
setupWork += " Is Time Field";
edit.Time(field * 24 + 4, 124, comboWidth, value);
form.CapturePanel.Controls.Add(edit.time);
}
break;
case DBHandler.PC_BOOLEAN:
{
setupWork += " Is Boolean";
edit.Combo(field * 24 + 4, 124, comboWidth, value);
form.CapturePanel.Controls.Add(edit.combo);
}
break;
case DBHandler.PC_BYTE:
{
setupWork += " Is Byte";
edit.Text(field * 24 + 4, 124, editWidth, maxLength(pcField), value);
form.CapturePanel.Controls.Add(edit.text);
}
break;
case DBHandler.PC_SHORT:
{
setupWork += " Is Short";
edit.Text(field * 24 + 4, 124, editWidth, maxLength(pcField), value);
form.CapturePanel.Controls.Add(edit.text);
}
break;
case DBHandler.PC_DOUBLE:
{
edit.Text(field * 24 + 4, 124, editWidth, maxLength(pcField), value);
form.CapturePanel.Controls.Add(edit.text);
}
break;
case DBHandler.PC_SEQUENCE:
case DBHandler.PC_INT:
{
edit.Text(field * 24 + 4, 124, editWidth, maxLength(pcField), value);
form.CapturePanel.Controls.Add(edit.text);
}
break;
case DBHandler.PC_LONG:
{
edit.Text(field * 24 + 4, 124, editWidth, maxLength(pcField), value);
form.CapturePanel.Controls.Add(edit.text);
}
break;
}
if (showSetup.Checked == true)
LogDebug = setupWork;
}
switch (how)
{
case EHow.ADD:
form.Text = "Add Record for " + pcTable.name;
form.isAdd = true;
form.isChange = false;
form.isDelete = false;
form.isDisplay = false;
break;
case EHow.CHANGE:
form.Text = "Change Record on " + pcTable.name;
form.isAdd = false;
form.isChange = true;
form.isDelete = false;
form.isDisplay = false;
break;
case EHow.DELETE:
form.Text = "Delete Record in " + pcTable.name;
form.isAdd = false;
form.isChange = false;
form.isDelete = true;
form.isDisplay = false;
break;
case EHow.DISPLAY:
form.Text = "Display Record of " + pcTable.name;
form.isAdd = false;
form.isChange = false;
form.isDelete = false;
form.isDisplay = true;
break;
}
DialogResult rc = form.ShowDialog();
if (rc != DialogResult.OK || how == EHow.DISPLAY)
return;
List<string> cells = new List<string>(pcTable.noFields);
for (field = 0; field < pcTable.noFields; field++)
cells.Add(edits[field].Value);
connect.BeginTransaction();
try
{
DBHandler db = new DBHandler(connect);
string sysdate = DateTime.Now.ToString("yyyyMMddhhmmss");
switch (how)
{
case EHow.ADD:
newUsId = userName;
newTmStamp = sysdate;
query = "INSERT INTO " + pcTable.name;
query += " VALUES ";
c = "( ";
for (field = 0; field < pcTable.noFields; field++)
{
query += c + sqlReady(pcFields[offset + field], cells[field], true, pcTable.name);
c = ", ";
}
query += ", '" + userName + "', Sysdate)";
break;
case EHow.CHANGE:
newUsId = userName;
newTmStamp = sysdate;
query = "UPDATE " + pcTable.name;
query += " SET ";
c = "";
for (field = 0; field < pcTable.noFields; field++)
{
if (isKey(pcTable, field) == true)
continue;
query += c + pcFields[offset + field].name + " = "
+ sqlReady(pcFields[offset + field], cells[field]);
c = ", ";
}
query += ", " + db.UsId + " = '" + userName + "', " + db.TmStamp + " = Sysdate";
query += " " + where;
break;
case EHow.DELETE:
query = "DELETE FROM " + pcTable.name;
query += " " + where;
break;
}
using (AutoCursor.DatabaseCall)
{
try
{
if (showSQL.Checked == true)
LogDebug = query;
db.Execute(query);
if (BinTables.HasValidation() == true)
{
if (validateAuditPython(pcTable, how, edits, oldUsId, newUsId, oldTmStamp, newTmStamp) == false)
{
connect.FlagRollback();
return;
}
showTableGrid();
}
}
catch (Exception ex)
{
connect.FlagRollback();
showException(ex);
}
}
}
finally
{
connect.EndTransaction();
}
}
private bool validatePython(TPCRelation relation, EHow how, string fieldNames, string values)
{
string oldValues = how == EHow.ADD ? "[]" : values;
string newValues = how == EHow.DELETE ? "[]" : values;
string validate = string.Format("result = validate('{0}', {1}, {2}, {3}, {4})", relation.name, (int)how, fieldNames, oldValues, newValues);
if (pcRelation.validate.Length > 0)
{
if (runValidate(pcRelation.validate, validate) == false)
return false;
}
else
{
if (runValidate(pcApplication.validateOther, validate) == false)
return false;
}
if (runValidate(pcApplication.validateAll, validate) == false)
return false;
return true;
}
internal bool validateTablePython(EHow how, List<EntryItem> edits)
{
string oldValues = "[";
string newValues = "[";
string fieldNames = "[";
string comma = "";
foreach (EntryItem plus in edits)
{
fieldNames += string.Format("{0}'{1}'", comma, plus.label.Text);
if (how != EHow.ADD)
oldValues += string.Format("{0}'{1}'", comma, plus.oldValue);
if (how != EHow.DELETE)
newValues += string.Format("{0}'{1}'", comma, plus.Value);
comma = ", ";
}
fieldNames += "]";
oldValues += "]";
newValues += "]";
string validate = string.Format("result = validate('{0}', {1}, {2}, {3}, {4})", pcTable.name, (int)how, fieldNames, oldValues, newValues);
if (pcTable.validate.Length > 0)
{
if (runValidate(pcTable.validate, validate) == false)
return false;
}
else
{
if (runValidate(pcApplication.validateOther, validate) == false)
return false;
}
return true;
}
private bool validateAuditPython(TPCTable table, EHow how, List<EntryItem> edits, string oldUsId, string newUsId, string oldTmStamp, string newTmStamp)
{
string oldValues = "[";
string newValues = "[";
string fieldNames = "[";
string comma = "";
foreach (EntryItem plus in edits)
{
fieldNames += string.Format("{0}'{1}'", comma, plus.label.Text);
if (how != EHow.ADD)
oldValues += string.Format("{0}'{1}'", comma, plus.oldValue);
if (how != EHow.DELETE)
newValues += string.Format("{0}'{1}'", comma, plus.Value);
comma = ", ";
}
fieldNames += ", 'UsId', 'TmStamp']";
if (how != EHow.ADD)
oldValues += string.Format(", '{0}', '{1}'", oldUsId, oldTmStamp);
oldValues += "]";
if (how != EHow.DELETE)
newValues += string.Format(", '{0}', '{1}'", newUsId, newTmStamp);
newValues += "]";
string validate = string.Format("result = validate('{0}', {1}, {2}, {3}, {4})", table.name, (int)how, fieldNames, oldValues, newValues);
if (runValidate(pcApplication.validateAll, validate) == false)
return false;
return true;
}
