protected void CarrierContactTypeDropDownList_SelectedIndexChanged(object sender, EventArgs e)
{
CarrierContactList.Items.Clear();
ContactTypeID = Int32.Parse(CarrierContactTypeDropDownList.SelectedValue.ToString());
string getcontacts = "SELECT * from CarrierContacts WHERE CarrierID = " + CarrierID + " AND ContactTypeID = " + ContactTypeID;
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["GHMConnectionString"].ConnectionString))
{
SqlCommand cmd = new SqlCommand(getcontacts, conn);
conn.Open();
SqlDataReader rdr = cmd.ExecuteReader();
CarrierContactList.DataSource = rdr;
CarrierContactList.DataTextField = "ContactName";
CarrierContactList.DataValueField = "Id";
CarrierContactList.DataBind();
rdr.Close();
conn.Close();
}
string AddString = "Add New " + CarrierContactTypeDropDownList.SelectedItem.Text + " Contact...";
CarrierContactList.Items.Insert(0, new ListItem(AddString, "0"));
ContactNameTextBox.Text = "";
ContactTitleTextBox.Text = "";
ContactPhoneTextBox.Text = "";
ContactFaxTextBox.Text = "";
ContactEmailTextBox.Text = "";
}
protected void CarrierContactTypeDropDownList_DataBound(object sender, EventArgs e)
{
ContactTypeID = CarrierContactTypeDropDownList.SelectedIndex;
string getcontacts = "SELECT * from CarrierContacts WHERE CarrierID = " + CarrierID + " AND ContactTypeID = " + ContactTypeID;
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["GHMConnectionString"].ConnectionString))
{
SqlCommand cmd = new SqlCommand(getcontacts, conn);
conn.Open();
SqlDataReader rdr = cmd.ExecuteReader();
CarrierContactList.DataSource = rdr;
CarrierContactList.DataTextField = "ContactName";
CarrierContactList.DataValueField = "Id";
CarrierContactList.DataBind();
rdr.Close();
conn.Close();
}
}
protected void Page_PreRenderComplete(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
string ContactTypeID = CarrierContactTypeDropDownList.SelectedValue.ToString();
string getcontacts = "SELECT * from CarrierContacts WHERE CarrierID = " + CarrierID + " AND ContactTypeID = " + ContactTypeID;
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["GHMConnectionString"].ConnectionString))
{
SqlCommand cmd = new SqlCommand(getcontacts, conn);
conn.Open();
SqlDataReader rdr = cmd.ExecuteReader();
CarrierContactList.DataSource = rdr;
CarrierContactList.DataTextField = "ContactName";
CarrierContactList.DataValueField = "Id";
CarrierContactList.DataBind();
rdr.Close();
conn.Close();
}
string AddString = "Add New " + CarrierContactTypeDropDownList.SelectedItem.Text + " Contact...";
CarrierContactList.Items.Insert(0, new ListItem(AddString, "0"));
}
}
