public int CreateAccountType(Account_Type a) { int ret = 0; using (connect = new MySqlConnection(_connectionString)) { connect.Open(); using (MySqlTransaction transaction = connect.BeginTransaction()) { try { string query = "NewAccountType"; var cmd = new MySqlCommand(query, connect) { CommandType = CommandType.StoredProcedure }; cmd.Parameters.AddWithValue("AccountName", a.Name); cmd.Parameters.AddWithValue("PBenifit", a.Benefit); cmd.Parameters.AddWithValue("PCost", a.Cost); 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_Type a) { using (connect = new MySqlConnection(_connectionString)) { connect.Open(); using (MySqlTransaction transaction = connect.BeginTransaction()) { try { string query = "EditAccountType"; var cmd = new MySqlCommand(query, connect) { CommandType = CommandType.StoredProcedure }; cmd.Parameters.AddWithValue("AccountTypeID", a.ID); cmd.Parameters.AddWithValue("AccountName", a.Name); cmd.Parameters.AddWithValue("PBenifit", a.Benefit); cmd.Parameters.AddWithValue("PCost", a.Cost); cmd.ExecuteNonQuery(); transaction.Commit(); connect.Close(); } catch (InvalidOperationException ioException) { transaction.Rollback(); connect.Close(); } } } }
public Account_Type SearchAccountType(Account_Type a) { return SearchAccountType(a.ID); }
// The main method to get a user account. public Account_Type SearchAccountType(int ID) { var accountT = new Account_Type(); using (connect = new MySqlConnection(_connectionString)) { try { string query = "GetAccountType"; var cmd = new MySqlCommand(query, connect) { CommandType = CommandType.StoredProcedure }; cmd.Parameters.AddWithValue("AccountTypeID", ID); connect.Open(); var reader = cmd.ExecuteReader(); while (reader.Read()) { accountT.ID = int.Parse(reader["Account_Type_ID "].ToString()); accountT.Name = reader["Account_Name"].ToString(); accountT.Benefit = reader["Benefit"].ToString(); accountT.Cost = decimal.Parse(reader["Cost "].ToString()); } connect.Close(); } catch (InvalidOperationException ioException) { connect.Close(); } return accountT; } }
public List<Account_Type> ListAccounts() { var accountList = new List<Account_Type>(); using (connect = new MySqlConnection(_connectionString)) { try { string query = "ListAccountType"; var cmd = new MySqlCommand(query, connect) { CommandType = CommandType.StoredProcedure }; connect.Open(); var reader = cmd.ExecuteReader(); while (reader.Read()) { var accountType = new Account_Type(); accountType.ID = int.Parse(reader["Account_Type_ID"].ToString()); accountType.Name = reader["Account_Name"].ToString(); accountType.Benefit = reader["Benefit"].ToString(); accountType.Cost = decimal.Parse(reader["Cost"].ToString()); accountList.Add(accountType); } connect.Close(); } catch (InvalidOperationException ioException) { connect.Close(); } return accountList; } }
// Changes the customer specifed by the customer object account type to the Account_Type object. public void ChangeAccountType(Customer c, Account_Type type) { throw new NotImplementedException(); }
// Gets a list of accounts by the values speicifed in the account_type object. public List<Account> SearchAccounts(Account_Type at) { throw new NotImplementedException(); }