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