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