public int CreateTransaction(Transaction t)
{
int ret = 0;
using (connect = new MySqlConnection(_connectionString))
{
connect.Open();
using (MySqlTransaction transaction = connect.BeginTransaction())
{
try
{
string query = "NewTransaction";
var cmd = new MySqlCommand(query, connect) { CommandType = CommandType.StoredProcedure };
cmd.Parameters.AddWithValue("DateOfOrder", t.DateOfOrder);
cmd.Parameters.AddWithValue("PurchaceID", t.OrderID);
cmd.Parameters.AddWithValue("CustomerID", t.CustomerID);
cmd.Parameters.AddWithValue("BankingID", t.BankID);
ret = int.Parse(cmd.ExecuteScalar().ToString());
transaction.Commit();
connect.Close();
}
catch (InvalidOperationException ioException)
{
transaction.Rollback();
connect.Close();
}
}
}
return ret;
}
// Create transaction
public int create(int orderID, int custID, int bankID)
{
// Establishes transaction model
TransactionModel transModel = new TransactionModel();
// Holds the new transaction
Transaction newTrans = new Transaction();
// Stored details for the transaction
newTrans.DateOfOrder = DateTime.Now;
newTrans.OrderID = orderID;
newTrans.CustomerID = custID;
newTrans.BankID = bankID;
// Adds object to the database
int transactionID = transModel.CreateTransaction(newTrans);
// Returns the transactionID
return transactionID;
}
public List<Transaction> ListTransactions()
{
var transationList = new List<Transaction>();
using (connect = new MySqlConnection(_connectionString))
{
try
{
string query = "ListTransaction";
var cmd = new MySqlCommand(query, connect) { CommandType = CommandType.StoredProcedure };
connect.Open();
var reader = cmd.ExecuteReader();
while (reader.Read())
{
var transaction = new Transaction();
transaction.ID = int.Parse(reader["Sale_Transaction_ID"].ToString());
transaction.DateOfOrder = DateTime.Parse(reader["Date_Of_Order"].ToString());
transaction.OrderID = int.Parse(reader["Purchase_ID"].ToString());
transaction.CustomerID = int.Parse(reader["Customer_ID"].ToString());
transaction.BankID = int.Parse(reader["Banking_ID"].ToString());
transationList.Add(transaction);
}
connect.Close();
}
catch (InvalidOperationException ioException)
{
connect.Close();
}
return transationList;
}
}
// Calls the main method for getting a transtion.
public Transaction SearchTransaction(Transaction t)
{
return SearchTransaction(t.ID);
}
// Main method for getting an transaction.
public Transaction SearchTransaction(int ID)
{
var transaction = new Transaction();
using (connect = new MySqlConnection(_connectionString))
{
try
{
string query = "GetTransaction";
var cmd = new MySqlCommand(query, connect) { CommandType = CommandType.StoredProcedure };
cmd.Parameters.AddWithValue("SaleTransactionID", ID);
connect.Open();
var reader = cmd.ExecuteReader();
while (reader.Read())
{
transaction.ID = int.Parse(reader["Sale_Transaction_ID"].ToString());
transaction.DateOfOrder = DateTime.Parse(reader["Date_Of_Order"].ToString());
transaction.OrderID = int.Parse(reader["Purchase_ID"].ToString());
transaction.CustomerID = int.Parse(reader["Customer_ID"].ToString());
transaction.BankID = int.Parse(reader["Banking_ID"].ToString());
}
connect.Close();
}
catch (InvalidOperationException ioException)
{
connect.Close();
}
return transaction;
}
}