private void btnCustDelete_Click(object sender, EventArgs e)
{
try
{
//delete customer
using (var context = new Classes.CustomerContext())
{
//delete customer contacts
var contactResult = (from a in context.CustomerContacts where a.CustomerID == currentCustomerID select a).ToList();
foreach (var item in contactResult)
{
context.CustomerContacts.Remove(item);
context.SaveChanges();
}
var result = (from a in context.Customers where a.ID == currentCustomerID select a).FirstOrDefault();
context.Customers.Remove(result);
context.SaveChanges();
}
//refresh the combobox
RefreshCustomerDatasource();
}
catch (Exception ex)
{
ShowMessage("Error deleting customer", ex);
}
}
private void btnContDelete_Click(object sender, EventArgs e)
{
try
{
using (var context = new Classes.CustomerContext())
{
Classes.CustomerContact deleted = contactList[currentContactIndex];
var result = (from a in context.CustomerContacts where a.ID ==deleted.ID select a).FirstOrDefault();
context.CustomerContacts.Remove(result);
context.SaveChanges();
}
UpdateContacts(currentCustomerID);
}
catch (Exception ex)
{
ShowMessage("Error deleting customer contact", ex);
}
}
private void UpdateContacts(int customerID)
{
try
{
using (var context = new Classes.CustomerContext())
{
var contactResults = (from b in context.CustomerContacts where b.CustomerID == customerID select b).ToList();
if (contactResults.Count != 0)
{
contactList = contactResults;
currentContactIndex = 0;
lblContactCount.Text = (currentContactIndex + 1).ToString();
lblContactTotal.Text = " of " + contactList.Count().ToString();
txbCustContName.Text = contactList[0].Name;
txbCustContEmail.Text = contactList[0].Email;
txbCustContNum.Text = contactList[0].ContactNumber.ToString();
}
else
{
currentContactIndex = -1;
lblContactCount.Text = "0";
lblContactTotal.Text = " of " + contactList.Count().ToString();
txbCustContName.Text = "";
txbCustContEmail.Text = "";
txbCustContNum.Text = "";
txbCustContName.Focus();
}
}
}
catch (Exception ex)
{
ShowMessage("Error updating contacts", ex);
}
}
private void RefreshCustomerDatasource()
{
try
{
using (var context = new Classes.CustomerContext())
{
List<string> result = (from a in context.Customers orderby a.Name select a.Name).ToList();
cbCustomers.DataSource = result;
cbCustomers.Refresh();
}
}
catch (Exception ex)
{
ShowMessage("Error refreshing customer datasource", ex);
}
}
private void cbCustomers_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
contactList.Clear();
using (var context = new Classes.CustomerContext())
{
var custResult = (from a in context.Customers where a.Name == cbCustomers.SelectedItem.ToString() select a).FirstOrDefault();
if (custResult != null)
{
lblCustID.Text = custResult.ID.ToString();
txbCustName.Text = custResult.Name;
txbLat.Text = custResult.Latitude.ToString();
txbLong.Text = custResult.Longitude.ToString();
currentCustomerID = custResult.ID;
}
UpdateContacts(custResult.ID);
}
}
catch (Exception ex)
{
ShowMessage("Application error", ex);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
//if new button is clicked, set current customer id to -1
//if currentCustomerID != -1 do Update
//else
//Handle as new
if (currentCustomerID == -1)
{
#region NewCustomer
Classes.Customer customer = new Classes.Customer();
if (txbCustName.Text.Trim() == "")
{
//do nothing
}
else
{
customer.Name = txbCustName.Text;
decimal convert = 0;
if (decimal.TryParse(txbLat.Text, out convert))
{
customer.Latitude = convert;
}
else
{
customer.Latitude = 0;
}
if (decimal.TryParse(txbLong.Text, out convert))
{
customer.Longitude = convert;
}
else
{
customer.Longitude = 0;
}
try
{
using (var context = new Classes.CustomerContext())
{
context.Customers.Add(customer);
context.SaveChanges();
lblCustID.Text = customer.ID.ToString();
currentCustomerID = customer.ID;
}
}
catch (Exception ex)
{
ShowMessage("Error saving customer to datasource", ex);
}
}
#endregion
}
else
{
#region UpdateCustomer
if (txbCustName.Text.Trim() == "")
{
}
else
{
try
{
using (var context = new Classes.CustomerContext())
{
var result = (from a in context.Customers where a.ID == currentCustomerID select a).FirstOrDefault();
if (result != null)
{
result.Name = txbCustName.Text;
decimal tempValue;
result.Latitude = decimal.TryParse(txbLat.Text, out tempValue) ? tempValue : 0;
result.Longitude = decimal.TryParse(txbLong.Text, out tempValue) ? tempValue : 0;
context.SaveChanges();
}
}
}
catch (Exception ex)
{
ShowMessage("Error updating customer data", ex);
}
}
#endregion
}
RefreshCustomerDatasource();
}
private void btnSaveContact_Click(object sender, EventArgs e)
{
try
{
if (currentContactIndex == -1) //new button has been clicked
{
if ((txbCustContNum.Text != "") || (txbCustContEmail.Text != ""))
{
Classes.CustomerContact newContact = new Classes.CustomerContact();
newContact.CustomerID = currentCustomerID;
newContact.Name = txbCustContName.Text;
newContact.Email = txbCustContEmail.Text;
newContact.ContactNumber = txbCustContNum.Text;
using (var context = new Classes.CustomerContext())
{
context.CustomerContacts.Add(newContact);
context.SaveChanges();
currentContactIndex = newContact.ID;
}
UpdateContacts(currentCustomerID);
}
else
{
//empty fields. HAndle error and ignore save
}
}
else
{
using (var context = new Classes.CustomerContext())
{
Classes.CustomerContact update = contactList[currentContactIndex];
update.Name = txbCustContName.Text;
update.Email = txbCustContEmail.Text;
update.ContactNumber = txbCustContNum.Text;
}
}
}
catch (Exception ex)
{
ShowMessage("Error saving customer contact", ex);
}
}