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();
}
}
public void DeleteRow(string tableName)
{
if (mainView.SelectedItem == null)
{
MessageBox.Show("You didn't chose any item to delete!");
return;
}
string sql = "delete " + tableName + DBSingleton.MakeWhereClause(mainView.Columns.Select(x => x.Header.ToString()).ToArray(), ((DataRowView)mainView.SelectedItem).Row.ItemArray.Select(x => x.ToString()).ToArray());
DBSingleton.DeleteSql(sql);
RefreshView();
}
