//Load Installers from DB
    protected void SelectHeadOffice_Click(object sender, EventArgs e)
    {
        //Clear current items
        ddlInstallers.Items.Clear();
        ddlInstallers.DataBind();
        AjaxControlToolkit.ModalPopupExtender mpInstaller = Parent.FindControl("mpInstaller") as AjaxControlToolkit.ModalPopupExtender;
        if (mpInstaller != null)
        {
            mpInstaller.Show();
        }
        string installerName          = installerCompanyName.Text.Trim().ToLower();
        LinqToSqlDataContext dataCtxt = new LinqToSqlDataContext();

        try
        {
            var installerQry = dataCtxt.GetInstallersByNameCode(installerName, installerName, Convert.ToInt32(Session[enumSessions.ARC_Id.ToString()]));
            foreach (var dbInstaller in installerQry)
            {
                ListItem item = new ListItem();
                item.Text  = dbInstaller.CompanyName + " [ " + dbInstaller.Town + ", " + dbInstaller.PostCode + " ]";
                item.Value = dbInstaller.InstallerCompanyID.ToString();
                ddlInstallers.Items.Add(item);
            }
            ddlInstallers.DataBind();

            if (ddlInstallers != null && ddlInstallers.Items.Count > 0)
            {
                ddlInstallers_SelectedIndexChanged(null, null);
            }
            else
            {
                ltrCompanyInfo.Text = "";
            }
        }
        catch (Exception exp)
        {
            ListItem item = new ListItem();
            item.Text = "Error Loading.. ";
            ddlInstallers.Items.Add(item);
            ddlInstallers.DataBind();

            ////Record on to DB
            //CSLLog.RecordException(exp.Message, exp.StackTrace, "", "", "", enumPriority.HIGH.ToString(), "", SiteUtility.GetIPAddress());
        }
    }