public static bool CheckTheRecord(RecordObj record)
{
MySqlConnection conn = null;
try
{
conn = GetSqlConnection();
MySqlCommand cmd = new MySqlCommand("SELECT * FROM cscalculator WHERE Expression = @Expression", conn);
cmd.Parameters.AddWithValue("@Expression", record.Infix);
MySqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
return(true);
}
return(false);
}
catch (MySqlException mse)
{
if (mse.Source != null)
{
System.Windows.MessageBox.Show("MySqlException source: {0}", mse.Source);
}
throw mse;
}
finally
{
if (conn != null)
{
conn.Close();
}
}
}
private void DeleBtn_click(object sender, RoutedEventArgs e)
{
RecordObj selectedRecord = (RecordObj)RecordsView.SelectedItem;
if (selectedRecord == null)
{
System.Windows.MessageBox.Show("Please select a record");
}
else
{
RecordDao.DeleteTheRecord(selectedRecord);
RefreshTheList();
}
}
public static List <RecordObj> QueryAllRecord()
{
List <RecordObj> records = new List <RecordObj>();
MySqlConnection conn = null;
try
{
conn = GetSqlConnection();
MySqlCommand cmd = new MySqlCommand("SELECT * FROM cscalculator", conn);
MySqlDataReader reader = cmd.ExecuteReader();
RecordObj record;
while (reader.Read())
{
record = new RecordObj(
reader.GetString("Expression"),
reader.GetString("Preorder"),
reader.GetString("Postorder"),
reader.GetString("Decim"),
reader.GetString("Bina")
);
records.Add(record);
}
}
catch (MySqlException mse)
{
if (mse.Source != null)
{
Console.WriteLine("MySqlException source: {0}", mse.Source);
}
throw mse;
}
finally
{
if (conn != null)
{
conn.Close();
}
}
return(records);
}
public static void InsertTheRecord(RecordObj record)
{
MySqlConnection conn = null;
try
{
string insertSql = "INSERT INTO cscalculator (Expression, Preorder, Postorder, Decim, Bina) VALUES (@Expression, @Preorder, @Postorder, @Decim, @Bina)";
conn = GetSqlConnection();
MySqlCommand cmd = new MySqlCommand(insertSql, conn);
cmd.Parameters.AddWithValue("@Expression", record.Infix);
cmd.Parameters.AddWithValue("@Preorder", record.Prefix);
cmd.Parameters.AddWithValue("@Postorder", record.Postfix);
cmd.Parameters.AddWithValue("@Decim", record.Deci);
cmd.Parameters.AddWithValue("@Bina", record.Bin);
int cnt = cmd.ExecuteNonQuery();
if (cnt > 0)
{
System.Windows.MessageBox.Show("Expression inserts successfully");
}
else
{
System.Windows.MessageBox.Show("Fail to insert the expression");
}
}
catch (MySqlException mse)
{
if (mse.Source != null)
{
System.Windows.MessageBox.Show("MySqlException source: {0}", mse.Source);
}
throw;
}
finally
{
if (conn != null)
{
conn.Close();
}
}
}
private void ShowResult()
{
string infixStr = TxtExpre.Text;
if (ConversionAndCalculation.TestExpression(infixStr))
{
string prefixStr = ConversionAndCalculation.DoTransPre(infixStr);
string[] postfixArr = ConversionAndCalculation.DoTransPos(infixStr);
string postfixStr = String.Concat(postfixArr);
int decResult = ConversionAndCalculation.Calculation(postfixArr);
string binResult = Convert.ToString(decResult, 2);
currentRecord = new RecordObj(infixStr, prefixStr, postfixStr, decResult.ToString(), binResult);
TxtPre.Text = currentRecord.Prefix;
TxtPos.Text = currentRecord.Postfix;
TxtDec.Text = currentRecord.Deci;
TxtBin.Text = currentRecord.Bin;
}
else
{
TxtExpre.Text = ErrorMsg;
}
}
