/// <summary> /// Saves the changes to a modified broker email /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnEditBrokerEmail_Click(object sender, EventArgs e) { QCTLinqDataContext db = new QCTLinqDataContext(); InsuranceBrokerEmail email = db.InsuranceBrokerEmails.Single(u => u.ID == int.Parse(ddBrokerEmail.SelectedValue)); email.Email = txtNewBrokerEmail.Text; db.SubmitChanges(); PopulateBrokerEmails(email.bID); ddBrokerEmail.SelectedValue = email.ID.ToString(); }
/// <summary> /// Adds an email address associated with an insurance broker /// </summary> /// <param name="email">Email address of the broker</param> /// <param name="bID">ID of the related broker</param> public static void AddInsuranceBrokerEmail(string email, int bID) { QCTLinqDataContext db = new QCTLinqDataContext(); InsuranceBrokerEmail e = new InsuranceBrokerEmail { Email = email, bID = bID, Active = true }; db.InsuranceBrokerEmails.InsertOnSubmit(e); db.SubmitChanges(); }
/// <summary> /// Add a new email to a selected broker /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSubmitNewBrokerEmail_Click(object sender, EventArgs e) { QCTLinqDataContext db = new QCTLinqDataContext(); int brokerID = int.Parse(ddBroker.SelectedValue); InsuranceBrokerEmail email = new InsuranceBrokerEmail { bID = brokerID, Email = txtNewBrokerEmail.Text, Active = true }; db.InsuranceBrokerEmails.InsertOnSubmit(email); db.SubmitChanges(); PopulateBrokerEmails(brokerID); ddBrokerEmail.SelectedValue = email.ID.ToString(); }