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();
}
