public int CreateAccount(Account a) { int ret = 0; using (connect = new MySqlConnection(_connectionString)) { connect.Open(); using (MySqlTransaction transaction = connect.BeginTransaction()) { try { string query = "NewAccount"; var cmd = new MySqlCommand(query, connect) { CommandType = CommandType.StoredProcedure }; cmd.Parameters.AddWithValue("ContactID", a.ContactID); cmd.Parameters.AddWithValue("CustomerID", a.CustomerID); cmd.Parameters.AddWithValue("AccountTypeID", a.AccountTypeID); cmd.Parameters.AddWithValue("BankingID", a.BankID); ret = int.Parse(cmd.ExecuteScalar().ToString()); transaction.Commit(); connect.Close(); } catch (InvalidOperationException ioException) { transaction.Rollback(); connect.Close(); } } } return ret; }
// Creates an account public int create(int accountTypeID, int bankID, int customerID, int contactID) { // Establishes model AccountModel accountModel = new AccountModel(); // Holds the new account Account newAccount = new Account(); Account_Type accountType = new Account_Type(); Bank newBank = new Bank(); // Stored details for the account newAccount.CustomerID = customerID; newAccount.ContactID = contactID; newAccount.AccountTypeID = accountTypeID; newAccount.BankID = bankID; // Creates the account int accountID = accountModel.CreateAccount(newAccount); // Returns accountID return accountID; }
public void EditAccount(Account a) { using (connect = new MySqlConnection(_connectionString)) { connect.Open(); using (MySqlTransaction transaction = connect.BeginTransaction()) { try { string query = "EditAccount"; var cmd = new MySqlCommand(query, connect) { CommandType = CommandType.StoredProcedure }; cmd.Parameters.AddWithValue("AccountID", a.ID); cmd.Parameters.AddWithValue("ContactID", a.ContactID); cmd.Parameters.AddWithValue("CustomerID", a.CustomerID); cmd.Parameters.AddWithValue("AccountTypeID", a.AccountTypeID); cmd.Parameters.AddWithValue("BankingID", a.BankID); cmd.ExecuteNonQuery(); transaction.Commit(); connect.Close(); } catch (InvalidOperationException ioException) { transaction.Rollback(); connect.Close(); } } } }
// Gets a list of accounts for a customer speicifed in the customer object. public List<Account> SearchAccounts(Customer c) { var accountList = new List<Account>(); using (connect = new MySqlConnection(_connectionString)) { try { string query = "SearchAccount"; var cmd = new MySqlCommand(query, connect) { CommandType = CommandType.StoredProcedure }; cmd.Parameters.AddWithValue("CustomerID", c.ID); cmd.Parameters.AddWithValue("AccountID", null); cmd.Parameters.AddWithValue("ContactID", null); cmd.Parameters.AddWithValue("AccountTypeID", null); cmd.Parameters.AddWithValue("BankingID", null); connect.Open(); var reader = cmd.ExecuteReader(); while (reader.Read()) { var a = new Account(); a.ID = int.Parse(reader["Account_ID"].ToString()); a.ContactID = int.Parse(reader["Contact_ID"].ToString()); a.CustomerID = int.Parse(reader["Customer_ID"].ToString()); a.AccountTypeID = int.Parse(reader["Account_Type_ID"].ToString()); a.BankID = int.Parse(reader["Banking_ID"].ToString()); accountList.Add(a); } connect.Close(); } catch (InvalidOperationException ioException) { connect.Close(); } return accountList; } }
// Gets a list of account on elements specified in the account object. public List<Account> SearchAccounts(Account a) { throw new NotImplementedException(); }
public Account SearchAccount(Account a) { return SearchAccount(a.ID); }