private void UpdateBtn_Click(object sender, RoutedEventArgs e)
{
string comm = "update " + title.Text + " set ";
bool changed = false;
foreach (getField item in stackFields.Children)
{
if (item.IsChanged())
{
comm += item.getName() + "=" + DBSingleton.AdaptFieldValueToSql(item.getValue()) + ",";
changed = true;
}
}
if (!changed)
{
MessageBox.Show("You didn't updated anything!");
Close();
}
comm = comm.Substring(0, comm.Length - 1);
comm += DBSingleton.MakeWhereClause(field, values);
if (DBSingleton.UpdateSql(comm))
{
Close();
}
}
private void insertBtn_Click(object sender, RoutedEventArgs e)
{
string comm = "insert into " + title.Text + "(";
foreach (getField item in stackFields.Children)
{
comm += item.getName() + ",";
}
comm = comm.Substring(0, comm.Length - 1);
comm += ") values (";
foreach (getField item in stackFields.Children)
{
comm += DBSingleton.AdaptFieldValueToSql(item.getValue()) + ",";
}
comm = comm.Substring(0, comm.Length - 1);
comm += ")";
if (DBSingleton.InsertSql(comm))
{
Close();
}
}
