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 bool TryUpdateQuery(string newSql) { dt = DBSingleton.TrySelectSql(newSql); if (dt == null) { MessageBox.Show("The select sql query wasn't valid!"); return(false); } mainView.ItemsSource = dt.AsDataView(); return(true); }
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(); }
private void SetUpPartyBox( ) { DataTable dt; dt = DBSingleton.TrySelectSql("select party_ID,party_name from party"); foreach (DataRowView item in dt.AsDataView()) { if (item.Row.ItemArray.Length > 1) { partyBox.Items.Add(item.Row.ItemArray[0].ToString() + " - " + item.Row.ItemArray[1].ToString()); } } }
private static OracleCommand getNewCommand(string funcName) { OracleCommand com = new OracleCommand(); var connection = DBSingleton.GetConnection(); if (connection.State != System.Data.ConnectionState.Open) { connection.Open(); } com.Connection = connection; com.CommandType = System.Data.CommandType.StoredProcedure; com.CommandText = funcName; return(com); }
public static DataTable TrySelectSql(string TrySql) { try { OracleDataAdapter dataAdapter = new OracleDataAdapter(); dataAdapter.SelectCommand = new OracleCommand() { Connection = DBSingleton.GetConnection(), CommandText = TrySql }; DataTable dt = new DataTable(); dataAdapter.Fill(dt); return(dt); } catch (Exception e) { return(null); } }
private void SetUpForigenKey(string name) { IsForigenKey = true; comboBox.Visibility = Visibility.Visible; value.Visibility = Visibility.Collapsed; int i = 0; int index = -1; DataTable dt; dt = DBSingleton.TrySelectSql(string.Format("select {0}_ID,{0}_name from {0}", name)); if (dt == null) { dt = DBSingleton.TrySelectSql(string.Format("select {0}_ID,{0}_location from {0}", name)); } if (dt == null) { dt = DBSingleton.SelectSql(string.Format("select {0}_ID,{0}_date from {0}", name)); } foreach (DataRowView item in dt.AsDataView()) { i++; if (IsForigenKey) { if (item.Row.ItemArray[0].ToString() == originalValue) { index = i; } } if (item.Row.ItemArray.Length > 1) { comboBox.Items.Add(item.Row.ItemArray[0].ToString() + " - " + item.Row.ItemArray[1].ToString()); } else { comboBox.Items.Add(item.Row.ItemArray[0].ToString()); } } if (IsForigenKey) { comboBox.SelectedIndex = index; } }
public static DataTable SelectSql(string sql) { try { OracleDataAdapter dataAdapter = new OracleDataAdapter(); dataAdapter.SelectCommand = new OracleCommand() { Connection = DBSingleton.GetConnection(), CommandText = sql }; DataTable dt = new DataTable(); dataAdapter.Fill(dt); return(dt); } catch (Exception e) { MessageBox.Show(e.Message, "SQL Error!"); return(null); } }
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(); } }
public void RefreshView() { dt = DBSingleton.SelectSql(viewSql); mainView.ItemsSource = dt.AsDataView(); }