public static Transaction getTransaction(string transactionId) { //openConnection(); MySqlCommand command = l_DBConn.CreateCommand(); String query = null; query = "SELECT * FROM transaction WHERE id='" + transactionId + "'"; command.CommandText = query; MySqlDataReader reader = command.ExecuteReader(); Transaction transaction = null; while (reader.Read()) { double money_receive = 0; try { money_receive = Double.Parse(reader.GetValue(1).ToString()); } catch { }; double money_change = 0; try { money_change = Double.Parse(reader.GetValue(2).ToString()); } catch { }; string date = reader.GetValue(3).ToString(); string member_id = reader.GetValue(4).ToString(); double total_price = 0; try { total_price = Double.Parse(reader.GetValue(5).ToString()); } catch { }; transaction = new Transaction(transactionId, date, money_receive, money_change, total_price); } reader.Close(); query = "SELECT * FROM product_transaction_relation WHERE transaction_id='" + transactionId + "'"; command.CommandText = query; reader = command.ExecuteReader(); while (reader.Read()) { string product_id = reader.GetValue(0).ToString(); int amount = (int)Int64.Parse(reader.GetValue(2).ToString()); double total_price = Double.Parse(reader.GetValue(3).ToString()); transaction.insertProductIntoShoppingBag(product_id, amount, total_price); } reader.Close(); //closeConnection(); return transaction; }