protected void cboEmployer_SelectedIndexChanged(object sender, System.EventArgs e)
{
if (cboEmployer.SelectedIndex > 0)
{
//StringBuilder strSQL = new StringBuilder();
//if (AppMode)
// clsUtility.Connection = enc.SimpleCrypt(ConfigurationManager.AppSettings["remoteConn"]);
//else
// clsUtility.Connection = enc.SimpleCrypt(ConfigurationManager.AppSettings["infiniConn"]);
//strSQL.AppendFormat("SELECT EmployerPhone, EmployerPhoneExt, EmployerEmail, EmployerAddress, Cities.CityName, States.State, EmployerZip ");
//strSQL.AppendFormat("FROM Employer INNER JOIN ");
//strSQL.AppendFormat(" Cities ON Employer.EmployerCityID = Cities.CityID INNER JOIN ");
//strSQL.AppendFormat(" States ON Cities.StateID = States.State ");
//strSQL.AppendFormat("WHERE Employer.EmployerID = " + cboEmployer.SelectedValue + ";");
DataTool dbTool = new DataTool();
DataTable dtEmployer = dbTool.getEmployerInfo(Int32.Parse(cboEmployer.SelectedValue));
if (dtEmployer.Rows.Count > 0)
{
foreach (DataRow drEmployer in dtEmployer.Rows)
{
txtEmployerPhone.InnerText = Convert.ToString(drEmployer[0].ToString());
txtEmployerPhoneExt.InnerText = Convert.ToString(drEmployer[1].ToString());
txtEmployerEmail.InnerText = Convert.ToString(drEmployer[2].ToString());
txtEmployerAddress.InnerText = Convert.ToString(drEmployer[3].ToString());
txtEmployerCity.InnerText = Convert.ToString(drEmployer[4].ToString());
txtEmployerState.InnerText = Convert.ToString(drEmployer[5].ToString());
txtEmployerZip.InnerText = Convert.ToString(drEmployer[6].ToString());
}
}
//SqlDataReader rEmployerData = clsUtility.GetDataReader(strSQL.ToString());
//if(rEmployerData.HasRows)
//{
// while(rEmployerData.Read())
// {
// txtEmployerPhone.InnerText = Convert.ToString(rEmployerData[0]);
// txtEmployerPhoneExt.InnerText = Convert.ToString(rEmployerData[1]);
// txtEmployerEmail.InnerText = Convert.ToString(rEmployerData[2]);
// txtEmployerAddress.InnerText = Convert.ToString(rEmployerData[3]);
// txtEmployerCity.InnerText = Convert.ToString(rEmployerData[4]);
// txtEmployerState.InnerText = Convert.ToString(rEmployerData[5]);
// txtEmployerZip.InnerText = Convert.ToString(rEmployerData[6]);
// }
//}
else
{
ClearEmployer();
}
//rEmployerData.Close();
}
else
{
ClearEmployer();
}
}