public int CreateContact(Contact c) { int ret = 0; using (connect = new MySqlConnection(_connectionString)) { connect.Open(); using (MySqlTransaction transaction = connect.BeginTransaction()) { try { string query = "NewContact"; var cmd = new MySqlCommand(query, connect) { CommandType = CommandType.StoredProcedure }; cmd.Parameters.AddWithValue("PForename", c.Forename); cmd.Parameters.AddWithValue("PSurname", c.Surname); cmd.Parameters.AddWithValue("JobTitle", c.Position); cmd.Parameters.AddWithValue("TelNumber", c.PhoneNumber); ret = int.Parse(cmd.ExecuteScalar().ToString()); transaction.Commit(); connect.Close(); } catch (InvalidOperationException ioException) { transaction.Rollback(); connect.Close(); } } } return ret; }
// Creates a contact public int create(String forename, String surname, String position, String phoneNumber) { // Establishes contact model ContactModel contactModel = new ContactModel(); // Holds new contact Contact newContact = new Contact(); // Stored details for the contact newContact.Forename = forename; newContact.Surname = surname; newContact.Position = position; newContact.PhoneNumber = phoneNumber; // Acquires contactID int contactID = contactModel.CreateContact(newContact); // Returns contactID return contactID; }
public void EditContact(Contact c) { using (connect = new MySqlConnection(_connectionString)) { connect.Open(); using (MySqlTransaction transaction = connect.BeginTransaction()) { try { string query = "EditContact"; var cmd = new MySqlCommand(query, connect) { CommandType = CommandType.StoredProcedure }; cmd.Parameters.AddWithValue("ContactID", c.ID); cmd.Parameters.AddWithValue("PForename", c.Forename); cmd.Parameters.AddWithValue("PSurname", c.Surname); cmd.Parameters.AddWithValue("JobTitle", c.Position); cmd.Parameters.AddWithValue("TelNumber", c.PhoneNumber); cmd.ExecuteNonQuery(); transaction.Commit(); connect.Close(); } catch (InvalidOperationException ioException) { transaction.Rollback(); connect.Close(); } } } }
// Calls main method for getting a customer public Contact SearchContact(Contact c) { return SearchContact(c.ID); }
// Main method for getting a customer public Contact SearchContact(int ID) { var contact = new Contact(); using (connect = new MySqlConnection(_connectionString)) { try { string query = "GetContact"; var cmd = new MySqlCommand(query, connect) { CommandType = CommandType.StoredProcedure }; cmd.Parameters.AddWithValue("ContactID", ID); connect.Open(); var reader = cmd.ExecuteReader(); while (reader.Read()) { contact.ID = (int)reader["Contact_ID"]; contact.Forename = reader["Forename"].ToString(); contact.Surname = reader["Surname"].ToString(); contact.Position = reader["Job_Title"].ToString(); contact.PhoneNumber = reader["Tel_Number"].ToString(); } connect.Close(); } catch (InvalidOperationException ioException) { connect.Close(); } return contact; } }
// List all customers public List<Contact> ListContacts() { var contactList = new List<Contact>(); using (connect = new MySqlConnection(_connectionString)) { try { string query = "ListContact"; var cmd = new MySqlCommand(query, connect) { CommandType = CommandType.StoredProcedure }; connect.Open(); var reader = cmd.ExecuteReader(); while (reader.Read()) { var contact = new Contact(); contact.ID = (int)reader["Contact_ID"]; contact.Forename = reader["Forename"].ToString(); contact.Surname = reader["Surname"].ToString(); contact.Position = reader["Job_Title"].ToString(); contact.PhoneNumber = reader["Tel_Number"].ToString(); contactList.Add(contact); } connect.Close(); } catch (InvalidOperationException ioException) { connect.Close(); } return contactList; } }
// Gets a list of accounts that have the contact speicifed in the contact object. public List<Account> SearchAccounts(Contact c) { throw new NotImplementedException(); }