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