public void DeleteCustomerContacts(CustomerContacts custContacts)
{
SqlConnection databaseConnection = null;
try
{
databaseConnection = new SqlConnection("Server=(local);Database=Customer Contact Manager FiveFriday; Integrated Security=SSPI");
databaseConnection.Open();
SqlCommand commandBuilder = new SqlCommand("dbo.sp_DeleteCustomerContacts", databaseConnection);
commandBuilder.CommandType = System.Data.CommandType.StoredProcedure;
commandBuilder.Parameters.Add(new SqlParameter("@ID", custContacts.ID));
commandBuilder.ExecuteNonQuery();
}
catch (Exception e)
{
MessageBox.Show("DeleteCustomerContacts: Exception occured in the accessing the data.\n\n" + e.Message, "Critical-error", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
finally
{
if (databaseConnection != null)
{
databaseConnection.Close();
}
GC.Collect();
}
}
public void DeleteCustomerContacts(int id, int customerID)
{
CustomerContacts custContacts = new CustomerContacts();
custContacts.ID = id; custContacts.CustomerID = customerID;
acData = AccessData.Instance;
acData.DeleteCustomerContacts(custContacts);
SelectAllCustomerContacts(custContacts.CustomerID);
}
public void UpdateCustomerContacts(int id, string name, string email, string contactNumber, int customerID)
{
CustomerContacts custContacts = new CustomerContacts();
custContacts.ID = id; custContacts.Name = name; custContacts.Email = email; custContacts.ContactNumber = contactNumber; custContacts.CustomerID = customerID;
acData = AccessData.Instance;
acData.UpdateCustomerContacts(custContacts);
SelectAllCustomerContacts(custContacts.CustomerID);
}
public List <CustomerContacts> SelectAllCustomerContacts(int customerID)
{
SqlConnection databaseConnection = null;
SqlDataReader databaseReader = null;
CustomerContacts custContacts = null;
List <CustomerContacts> listOfCustContacts = null;
try
{
databaseConnection = new SqlConnection("Server=(local);Database=Customer Contact Manager FiveFriday; Integrated Security=SSPI");
databaseConnection.Open();
SqlCommand commandBuilder = new SqlCommand("dbo.sp_SelectAllCustomerContacts", databaseConnection);
commandBuilder.CommandType = System.Data.CommandType.StoredProcedure;
commandBuilder.Parameters.Add(new SqlParameter("@CustomerID", customerID));
databaseReader = commandBuilder.ExecuteReader();
listOfCustContacts = new List <CustomerContacts>();
while (databaseReader.Read())
{
custContacts = new CustomerContacts();
custContacts.ID = int.Parse(databaseReader["ID"].ToString());
custContacts.Name = databaseReader["Name"].ToString();
custContacts.Email = databaseReader["Email"].ToString();
custContacts.ContactNumber = databaseReader["ContactNumber"].ToString();
custContacts.CustomerID = int.Parse(databaseReader["CustomerID"].ToString());
listOfCustContacts.Add(custContacts);
}
return(listOfCustContacts);
}
catch (Exception e)
{
listOfCustContacts = null;
MessageBox.Show("SelectAllCustomerContacts: Exception occured in the accessing the data.\n\n" + e.Message, "Critical-error", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
finally
{
if (databaseConnection != null)
{
databaseConnection.Close();
}
if (databaseReader != null)
{
databaseReader.Close();
}
GC.Collect();
}
return(listOfCustContacts);
}
