public void Update()
{
LinkedFooter.RemoveOperationMessage();
string err = ValidateInputs();
if (err != "")
{
MessageBox.Show(err, "Could not update " + SQLDB.CurrentTable);
}
else
{
using (var conn = AccessDB.Connect())
{
conn.Open();
using (var transaction = conn.BeginTransaction())
{
OnUpdate(conn);
transaction.Commit();
}
conn.Close();
}
LinkedTableList.SetupTable(true);
LinkedFooter.SetOperationMessage(SQLDB.CurrentTable + " Updated", Colors.SkyBlue);
}
}
public void Clone()
{
LinkedFooter.RemoveOperationMessage();
string err = ValidateInputs();
if (err != "")
{
MessageBox.Show("Could not clone " + SQLDB.CurrentTable + ":\n\n" + err);
}
else
{
SQLDB.CurrentId = SQLDB.MaxIdPlusOne(SQLDB.CurrentTable);
using (var conn = AccessDB.Connect())
{
conn.Open();
using (var transaction = conn.BeginTransaction())
{
OnClone(conn);
OnCreate(conn);
transaction.Commit();
}
conn.Close();
}
LinkedTableList.SetupTable(true);
LinkedFooter.SetOperationMessage(SQLDB.CurrentTable + " Cloned", Colors.DarkTurquoise);
}
}
public void InitializeNew()
{
LinkedTableList.SetupTable(false);
SQLDB.CurrentId = SQLDB.MaxIdPlusOne(SQLDB.CurrentTable);
LinkedFooter.ApplyInitializeNewSettings();
LinkedFooter.RemoveOperationMessage();
LinkedTableList.RemoveButtonHighlight();
SetupTableData();
OnInitializeNew();
}