private void btnSave_Click(object sender, EventArgs e)
{
using (DealershipManagerEntities context = new DealershipManagerEntities())
{
if (currentInsuranceBroker != null)
{
//It exists, find it, and edit it.
InsuranceBroker insuranceBroker = (from insBroker in context.InsuranceBrokers
where insBroker.BrokerId == currentInsuranceBroker.BrokerId
select insBroker).FirstOrDefault();
updateInsuranceBroker(insuranceBroker);
context.SaveChanges();
context.Connection.Close();
}
else
{
InsuranceBroker insuranceBroker = new InsuranceBroker();
updateInsuranceBroker(insuranceBroker);
context.InsuranceBrokers.AddObject(insuranceBroker);
context.SaveChanges();
context.Connection.Close();
}
}
MessageBox.Show("Insurance Broker has been saved");
customerForm.insuranceBrokerTableAdapter.Fill(customerForm.dealershipManagerDataSet.InsuranceBroker);
customerForm.cboInsuranceBroker.SelectedItem = currentInsuranceBroker;
customerForm.currentInsuranceBroker = currentInsuranceBroker;
customerForm.BindInsuranceBrokerToForm();
this.Close();
}
protected void btnEditBroker_Click(object sender, EventArgs e)
{
QCTLinqDataContext db = new QCTLinqDataContext();
int ID = int.Parse(ddBroker.SelectedValue);
InsuranceBroker b = db.InsuranceBrokers.Single(a => a.ID == ID);
b.Name = txtNewBroker.Text;
db.SubmitChanges();
ddBroker.SelectedItem.Text = b.Name;
}
/// <summary>
/// Adds an insurance broker
/// </summary>
/// <param name="name">Name of the insurance broker</param>
public static void AddInsuranceBroker(string name)
{
QCTLinqDataContext db = new QCTLinqDataContext();
InsuranceBroker b = new InsuranceBroker
{
Name = name,
Active = true
};
db.InsuranceBrokers.InsertOnSubmit(b);
db.SubmitChanges();
}
private void updateInsuranceBroker(InsuranceBroker c)
{
c.BrokerName = txtInsuranceBrokerName.Text;
c.BrokerAddress = txtAddress.Text;
c.BrokerCity = txtCity.Text;
c.BrokerEmail = txtEmail.Text;
c.BrokerFax = txtFax.Text;
c.BrokerPhone = txtPhone.Text;
c.BrokerPostal = txtPostal.Text;
if (null != cboCountry.SelectedItem)
{
c.BrokerCountry = cboCountry.SelectedItem.ToString();
}
if (null != cboProvince.SelectedItem)
{
c.BrokerProvince = cboProvince.SelectedItem.ToString();
}
}
public InsuranceBrokerForm(int brokerId)
{
InitializeComponent();
using (DealershipManagerEntities context = new DealershipManagerEntities())
{
InsuranceBroker insuranceBroker = (from insBroker in context.InsuranceBrokers
where insBroker.BrokerId == brokerId
select insBroker).FirstOrDefault();
currentInsuranceBroker = insuranceBroker;
txtAddress.Text = currentInsuranceBroker.BrokerAddress;
txtCity.Text = currentInsuranceBroker.BrokerCity;
txtEmail.Text = currentInsuranceBroker.BrokerEmail;
txtFax.Text = currentInsuranceBroker.BrokerFax;
txtInsuranceBrokerName.Text = currentInsuranceBroker.BrokerName;
txtPhone.Text = currentInsuranceBroker.BrokerPhone;
txtPostal.Text = currentInsuranceBroker.BrokerPostal;
cboCountry.SelectedItem = currentInsuranceBroker.BrokerCountry;
cboProvince.SelectedItem = currentInsuranceBroker.BrokerProvince;
}
}
/// <summary>
/// Add a new broker to be available
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSubmitNewBroker_Click(object sender, EventArgs e)
{
// ensure the user has actually entered something to add
if (txtNewBroker.Text.Length > 0)
{
QCTLinqDataContext db = new QCTLinqDataContext();
// create and populate the broker object
InsuranceBroker b = new InsuranceBroker
{
Name = txtNewBroker.Text,
Active = true
};
// insert...
db.InsuranceBrokers.InsertOnSubmit(b);
db.SubmitChanges();
// repopulate the broker dropdown...
PopulateBrokers();
// select the newly entered broker
ddBroker.SelectedValue = b.ID.ToString();
// clear the broker email list, as there won't be any email associated with a new broker yet
ddBrokerEmail.Items.Clear();
ddBrokerEmail.Items.Add(new ListItem("No email selected", ""));
}
}
