private void AddTC(object obj)
{
if (!String.IsNullOrWhiteSpace(TCPartToAdd))
{
using (OracleConnection connection = new OracleConnection(connectionString))
{
try {
string queryString = string.Format("INSERT INTO TC_LIST (TC_NUMBER) VALUES ('{0}')", TCPartToAdd);
OracleCommand command = new OracleCommand(queryString, connection);
connection.Open();
command.ExecuteNonQuery();
PartsTC.Add(TCPartToAdd);
}
catch (Exception Ex)
{
MessageBox.Show("Failed to Write Data into TC List\n" + Ex.ToString());
}
finally
{
// always call Close when done reading.
connection.Close();
}
}
TCPartToAdd = "";
}
else
{
MessageBox.Show("Please Enter Valid Number");
}
}
private void RemoveTC(object objToRemove)
{
try
{
IList itemToRemove = (IList)objToRemove;
string toRemove = (string)itemToRemove[0];
PartsTC.Remove(toRemove);
using (OracleConnection connection = new OracleConnection(connectionString))
{
try
{
string queryString = string.Format("DELETE FROM TC_LIST WHERE TC_NUMBER='{0}'", toRemove);
OracleCommand command = new OracleCommand(queryString, connection);
connection.Open();
command.ExecuteNonQuery();
PartsTC.Remove(toRemove);
}
catch (Exception Ex)
{
MessageBox.Show("Failed to Write Data into TC List\n" + Ex.ToString());
}
finally
{
connection.Close();
}
}
}
catch (Exception)
{
MessageBox.Show("List is Empty or No Item Selected");
}
}
private void RefreshTC(object obj)
{
PartsTC.Clear();
using (OracleConnection connection = new OracleConnection(connectionString))
{
string queryString = "SELECT * from TC_LIST";
OracleCommand command = new OracleCommand(queryString, connection);
connection.Open();
OracleDataReader reader = command.ExecuteReader();
try
{
while (reader.Read())
{
PartsTC.Add(reader.GetString(1));
//MessageBox.Show(reader.GetInt32(0) + ", " + reader.GetString(1));
}
}
finally
{
// always call Close when done reading.
reader.Close();
}
}
}
