// ////////////////////////////////////////////////////////////////////////
        // AUXILIAR EVENTS
        //
        protected void btnViewDelete_Click(object sender, EventArgs e)
        {
            int companyId = Int32.Parse(hdfCompanyId.Value.Trim());
            int viewId = Int32.Parse(ddlView.SelectedValue.Trim());

            if (!(Convert.ToBoolean(Session["sgLFS_GLOBALVIEWS_DELETE"])))
            {
                FmViewGateway fmViewGateway = new FmViewGateway();
                fmViewGateway.LoadByViewId(viewId, companyId);
                string viewType = fmViewGateway.GetType(viewId);

                if (viewType == "Global")
                {
                    Response.Redirect("./../../error_page.aspx?error=" + "You are not authorized to view this page. Contact your system administrator.");
                }
            }

            UpdateDatabaseForViews();

            // ... For view ddl
            string fmType = hdfFmType.Value;
            int loginId = Convert.ToInt32(Session["loginID"]);
            string viewTypeGlobal = "";
            string viewTypePersonal = "Personal";

            // Global Views check
            if (Convert.ToBoolean(Session["sgLFS_GLOBALVIEWS_VIEW"]))
            {
                viewTypeGlobal = "Global";
            }

            FmViewList fmViewList = new FmViewList();
            fmViewList.LoadAndAddItem(fmType, viewTypeGlobal, viewTypePersonal, loginId, companyId);
            ddlView.DataSource = fmViewList.Table;
            ddlView.DataValueField = "ViewID";
            ddlView.DataTextField = "Name";
            ddlView.DataBind();
            ddlView.SelectedIndex = 1;
        }
        private void RestoreNavigatorState()
        {
            // Search condition 1
            // Columns To Display
            string columnsToDisplay = Request.QueryString["columns_to_display"];

            // Search condition 1
            // ... For Condition
            odsViewForDisplayList.DataBind();
            ddlCondition1.DataSourceID = "odsViewForDisplayList";
            ddlCondition1.DataValueField = "ConditionID";
            ddlCondition1.DataTextField = "Name";
            ddlCondition1.DataBind();
            ddlCondition1.SelectedValue = Request.QueryString["search_ddlCondition1"];

            // ... For text for search
            tbxCondition1.Text = Request.QueryString["search_tbxCondition1"];

            // ... ForView
            int companyId = Int32.Parse(hdfCompanyId.Value.Trim());
            string fmType = hdfFmType.Value;
            int loginId = Convert.ToInt32(Session["loginID"]);
            string viewTypeGlobal = "";
            string viewTypePersonal = "Personal";

            // Global Views check
            if (Convert.ToBoolean(Session["sgLFS_GLOBALVIEWS_VIEW"]))
            {
                viewTypeGlobal = "Global";
            }

            FmViewList fmViewList = new FmViewList();
            fmViewList.LoadAndAddItem(fmType, viewTypeGlobal, viewTypePersonal, loginId, companyId);
            ddlView.DataSource = fmViewList.Table;
            ddlView.DataValueField = "ViewID";
            ddlView.DataTextField = "Name";
            ddlView.DataBind();
            ddlView.SelectedValue = Request.QueryString["search_ddlView"];

            //Other values
            //... For State
            odsState.DataBind();
            ddlState.DataSourceID = "odsState";
            ddlState.DataValueField = "State";
            ddlState.DataTextField = "State";
            ddlState.DataBind();
            ddlState.SelectedValue = Request.QueryString["search_state"];

            //... For SortBy
            odsSortByList.DataBind();
            ddlSortBy.DataSourceID = "odsSortByList";
            ddlSortBy.DataValueField = "SortID";
            ddlSortBy.DataTextField = "Name";
            ddlSortBy.DataBind();
            ddlSortBy.SelectedValue = Request.QueryString["search_sort_by"];

            // ... For BtnOrigin
            hdfBtnOrigin.Value = Request.QueryString["btn_origin"];
        }
        // ////////////////////////////////////////////////////////////////////////
        // EVENTS
        //
        protected void Page_Load(object sender, EventArgs e)
        {
            // Register client scripts
            this.RegisterClientScripts();

            if (!IsPostBack)
            {
                // Security check
                if (!(Convert.ToBoolean(Session["sgLFS_FLEETMANAGEMENT_SERVICES_VIEW"])))
                {
                    Response.Redirect("./../../error_page.aspx?error=" + "You are not authorized to view this page. Contact your system administrator.");
                }

                // Validate query string
                if ((string)Request.QueryString["source_page"] == null)
                {
                    Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in services_navigator.aspx");
                }

                // Tag Page
                hdfCompanyId.Value = Session["companyID"].ToString();
                hdfFmType.Value = "Services";

                // Prepare initial data
                // ... For sortByList
                odsSortByList.DataBind();
                ddlSortBy.DataSourceID = "odsSortByList";
                ddlSortBy.DataValueField = "SortID";
                ddlSortBy.DataTextField = "Name";
                ddlSortBy.DataBind();

                // ... For
                odsViewForDisplayList.DataBind();
                ddlCondition1.DataSourceID = "odsViewForDisplayList";
                ddlCondition1.DataValueField = "ConditionID";
                ddlCondition1.DataTextField = "Name";
                ddlCondition1.DataBind();

                // ... For view ddl
                int companyId = Int32.Parse(hdfCompanyId.Value.Trim());
                string fmType = hdfFmType.Value;
                int loginId = Convert.ToInt32(Session["loginID"]);
                string viewTypeGlobal = "";
                string viewTypePersonal = "Personal";

                // Global Views check
                if (Convert.ToBoolean(Session["sgLFS_GLOBALVIEWS_VIEW"]))
                {
                    viewTypeGlobal = "Global";
                }

                FmViewList fmViewList = new FmViewList();
                fmViewList.LoadAndAddItem(fmType, viewTypeGlobal, viewTypePersonal, loginId, companyId);
                ddlView.DataSource = fmViewList.Table;
                ddlView.DataValueField = "ViewID";
                ddlView.DataTextField = "Name";
                ddlView.DataBind();
                ddlView.SelectedIndex = 1;

                // If coming from
                // ... Left Menu or out
                if ((Request.QueryString["source_page"] == "lm") || (Request.QueryString["source_page"] == "out"))
                {
                    tdNoResults.Visible = false;
                }

                // ... services_navigator2.aspx
                if (Request.QueryString["source_page"] == "services_navigator2.aspx")
                {
                    RestoreNavigatorState();
                    if ((string)Request.QueryString["no_results"] == "yes")
                    {
                        tdNoResults.Visible = true;
                    }
                    else
                    {
                        tdNoResults.Visible = false;
                    }
                }
            }
            else
            {

            }
        }
        // ////////////////////////////////////////////////////////////////////////
        // EVENTS
        //
        protected void Page_Load(object sender, EventArgs e)
        {
            // Register client scripts
            this.RegisterClientScripts();

            if (!IsPostBack)
            {
                // Security check
                if (!(Convert.ToBoolean(Session["sgLFS_FLEETMANAGEMENT_SERVICES_VIEW"])))
                {
                    Response.Redirect("./../../error_page.aspx?error=" + "You are not authorized to view this page. Contact your system administrator.");
                }

                // Validate query string
                if ((string)Request.QueryString["source_page"] == null)
                {
                    Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in services_navigator2.aspx");
                }

                // Tag Page
                hdfCompanyId.Value = Session["companyID"].ToString();
                hdfFmType.Value = "Services";

                // Prepare initial data
                // ... For sortByList
                odsSortByList.DataBind();
                ddlSortBy.DataSourceID = "odsSortByList";
                ddlSortBy.DataValueField = "SortID";
                ddlSortBy.DataTextField = "Name";
                ddlSortBy.DataBind();

                // ... For
                odsViewForDisplayList.DataBind();
                ddlCondition1.DataSourceID = "odsViewForDisplayList";
                ddlCondition1.DataValueField = "ConditionID";
                ddlCondition1.DataTextField = "Name";
                ddlCondition1.DataBind();

                // ... For view ddl
                int companyId = Int32.Parse(hdfCompanyId.Value.Trim());
                string fmType = hdfFmType.Value;
                int loginId = Convert.ToInt32(Session["loginID"]);
                string viewTypeGlobal = "";
                string viewTypePersonal = "Personal";

                // Global Views check
                if (Convert.ToBoolean(Session["sgLFS_GLOBALVIEWS_VIEW"]))
                {
                    viewTypeGlobal = "Global";
                }

                FmViewList fmViewList = new FmViewList();
                fmViewList.LoadAndAddItem(fmType, viewTypeGlobal, viewTypePersonal, loginId, companyId);
                ddlView.DataSource = fmViewList.Table;
                ddlView.DataValueField = "ViewID";
                ddlView.DataTextField = "Name";
                ddlView.DataBind();
                ddlView.SelectedIndex = 1;

                // If coming from
                // ... services_navigator.aspx or services_navigator2.aspx
                if ((Request.QueryString["source_page"] == "services_navigator.aspx") || (Request.QueryString["source_page"] == "services_navigator2.aspx"))
                {
                    RestoreNavigatorState();

                    servicesNavigatorTDS = (ServicesNavigatorTDS)Session["servicesNavigatorTDS"];
                }

                // ... services_edit.aspx, services_summary.aspx or services_delete.aspx
                if ((Request.QueryString["source_page"] == "services_edit.aspx") || (Request.QueryString["source_page"] == "services_summary.aspx") || (Request.QueryString["source_page"] == "services_delete.aspx"))
                {
                    RestoreNavigatorState();

                    if (Request.QueryString["update"] == "no")
                    {
                        servicesNavigatorTDS = (ServicesNavigatorTDS)Session["servicesNavigatorTDS"];
                    }
                    else
                    {
                        // ... Delete store data
                        Session.Contents.Remove("servicesNavigatorTDS");

                        // ... Search data with updates
                        if (hdfBtnOrigin.Value == "Search")
                        {
                            servicesNavigatorTDS = SubmitSearch();
                        }
                        else
                        {
                            if (hdfBtnOrigin.Value == "Go")
                            {
                                servicesNavigatorTDS = SubmitSearchForViews();
                            }
                        }

                        // ... store datasets
                        Session["servicesNavigatorTDS"] = servicesNavigatorTDS;
                    }
                }

                // ... services_delete.aspx, services_summary.aspx or services_edit.aspx
                if ((Request.QueryString["source_page"] == "services_delete.aspx") || (Request.QueryString["source_page"] == "services_summary.aspx") || (Request.QueryString["source_page"] == "services_edit.aspx"))
                {
                    if (servicesNavigatorTDS.ServicesNavigator.Rows.Count == 0)
                    {
                        string url = "./services_navigator.aspx?source_page=services_navigator2.aspx&fm_type=" + hdfFmType.Value + GetNavigatorState() + "&no_results=yes";
                        Response.Redirect(url);
                    }
                }

                // For the grid
                grdServicesNavigator.DataSource = servicesNavigatorTDS.ServicesNavigator;
                grdServicesNavigator.DataBind();

                //... for the total rows
                if (servicesNavigatorTDS.ServicesNavigator.Rows.Count > 0)
                {
                    lblTotalRows.Text = "Total Rows: " + servicesNavigatorTDS.ServicesNavigator.Rows.Count;
                    lblTotalRows.Visible = true;
                }
                else
                {
                    lblTotalRows.Visible = false;
                }
            }
            else
            {
                // Restore TDS
                servicesNavigatorTDS = (ServicesNavigatorTDS)Session["servicesNavigatorTDS"];

                // ... for the total rows
                if (servicesNavigatorTDS.ServicesNavigator.Rows.Count > 0)
                {
                    lblTotalRows.Text = "Total Rows: " + servicesNavigatorTDS.ServicesNavigator.Rows.Count;
                    lblTotalRows.Visible = true;
                }
                else
                {
                    lblTotalRows.Visible = false;
                }
            }
        }
        private void RestoreNavigatorState()
        {
            // Columns To Display
            string columnsToDisplay = Request.QueryString["columns_to_display"];

            // Search condition 1
            // ... For Condition
            odsViewForDisplayList.DataBind();
            ddlCondition1.DataSourceID = "odsViewForDisplayList";
            ddlCondition1.DataValueField = "ConditionID";
            ddlCondition1.DataTextField = "Name";
            ddlCondition1.DataBind();
            ddlCondition1.SelectedValue = Request.QueryString["search_ddlCondition1"];

            // ... For text for search
            tbxCondition1.Text = Request.QueryString["search_tbxCondition1"];

            // ... ForView
            int companyId = Int32.Parse(hdfCompanyId.Value.Trim());
            string fmType = hdfFmType.Value;
            int loginId = Convert.ToInt32(Session["loginID"]);
            string viewTypeGlobal = "";
            string viewTypePersonal = "Personal";

            // Global Views check
            if (Convert.ToBoolean(Session["sgLFS_GLOBALVIEWS_VIEW"]))
            {
                viewTypeGlobal = "Global";
            }

            FmViewList fmViewList = new FmViewList();
            fmViewList.LoadAndAddItem(fmType, viewTypeGlobal, viewTypePersonal, loginId, companyId);
            ddlView.DataSource = fmViewList.Table;
            ddlView.DataValueField = "ViewID";
            ddlView.DataTextField = "Name";
            ddlView.DataBind();
            ddlView.SelectedValue = Request.QueryString["search_ddlView"];

            //Other values
            //... For State
            odsState.DataBind();
            ddlState.DataSourceID = "odsState";
            ddlState.DataValueField = "State";
            ddlState.DataTextField = "State";
            ddlState.DataBind();
            ddlState.SelectedValue = Request.QueryString["search_state"];

            //... For SortBy
            odsSortByList.DataBind();
            ddlSortBy.DataSourceID = "odsSortByList";
            ddlSortBy.DataValueField = "SortID";
            ddlSortBy.DataTextField = "Name";
            ddlSortBy.DataBind();
            ddlSortBy.SelectedValue = Request.QueryString["search_sort_by"];

            // ... For BtnOrigin
            hdfBtnOrigin.Value = Request.QueryString["btn_origin"];

            // Grid's columns
            grdServicesNavigator.Columns[2].Visible = (columnsToDisplay.IndexOf("Service Number") >= 0 ? true : false);
            grdServicesNavigator.Columns[3].Visible = (columnsToDisplay.IndexOf("Date & Time") >= 0 ? true : false);
            grdServicesNavigator.Columns[4].Visible = (columnsToDisplay.IndexOf("Fixed Date") >= 0 ? true : false);
            grdServicesNavigator.Columns[5].Visible = (columnsToDisplay.Contains("State") ? true : false);
            grdServicesNavigator.Columns[6].Visible = (columnsToDisplay.IndexOf("Problem Description") >= 0 ? true : false);
            grdServicesNavigator.Columns[7].Visible = (columnsToDisplay.IndexOf("Unit Code") >= 0 ? true : false);
            grdServicesNavigator.Columns[8].Visible = (columnsToDisplay.IndexOf("Unit Description") >= 0 ? true : false);
            grdServicesNavigator.Columns[9].Visible = (columnsToDisplay.IndexOf("VIN/SN") >= 0 ? true : false);
            grdServicesNavigator.Columns[10].Visible = (columnsToDisplay.IndexOf("Unit State") >= 0 ? true : false);
            grdServicesNavigator.Columns[11].Visible = (columnsToDisplay.IndexOf("Checklist Rule") >= 0 ? true : false);
            grdServicesNavigator.Columns[12].Visible = (columnsToDisplay.IndexOf("Associated Checklist State") >= 0 ? true : false);
            grdServicesNavigator.Columns[13].Visible = (columnsToDisplay.IndexOf("Created by") >= 0 ? true : false);
            grdServicesNavigator.Columns[14].Visible = (columnsToDisplay.IndexOf("Mileage") >= 0 ? true : false);
            grdServicesNavigator.Columns[15].Visible = (columnsToDisplay.IndexOf("Assignment Date") >= 0 ? true : false);
            grdServicesNavigator.Columns[16].Visible = (columnsToDisplay.IndexOf("Deadline Date") >= 0 ? true : false);
            grdServicesNavigator.Columns[17].Visible = (columnsToDisplay.IndexOf("Assigned to") >= 0 ? true : false);
            grdServicesNavigator.Columns[18].Visible = (columnsToDisplay.IndexOf("Accepted Date") >= 0 ? true : false);
            grdServicesNavigator.Columns[19].Visible = (columnsToDisplay.IndexOf("Start Date") >= 0 ? true : false);
            grdServicesNavigator.Columns[20].Visible = (columnsToDisplay.IndexOf("Unit Out Of Service Date") >= 0 ? true : false);
            grdServicesNavigator.Columns[21].Visible = (columnsToDisplay.IndexOf("Unit Out Of Service Time") >= 0 ? true : false);
            grdServicesNavigator.Columns[22].Visible = (columnsToDisplay.IndexOf("Start Work Mileage") >= 0 ? true : false);
            grdServicesNavigator.Columns[23].Visible = (columnsToDisplay.IndexOf("Complete Date") >= 0 ? true : false);
            grdServicesNavigator.Columns[24].Visible = (columnsToDisplay.IndexOf("Unit Back In Service Date") >= 0 ? true : false);
            grdServicesNavigator.Columns[25].Visible = (columnsToDisplay.IndexOf("Unit Back In Service Time") >= 0 ? true : false);
            grdServicesNavigator.Columns[26].Visible = (columnsToDisplay.IndexOf("Complete Work Mileage") >= 0 ? true : false);
            grdServicesNavigator.Columns[27].Visible = (columnsToDisplay.IndexOf("Work Details") >= 0 ? true : false);
            grdServicesNavigator.Columns[28].Visible = (columnsToDisplay.IndexOf("Preventable") >= 0 ? true : false);
            grdServicesNavigator.Columns[29].Visible = (columnsToDisplay.IndexOf("Labour Hours") >= 0 ? true : false);
            grdServicesNavigator.Columns[30].Visible = (columnsToDisplay.IndexOf("Notes") >= 0 ? true : false);
            grdServicesNavigator.Columns[31].Visible = (columnsToDisplay.IndexOf("Working Location") >= 0 ? true : false);
        }
        private void RestoreNavigatorState()
        {
            try
            {
                // Columns To Display
                string columnsToDisplay = Request.QueryString["columns_to_display"];

                // Search condition 1
                // ... For Condition
                odsViewForDisplayList.DataBind();
                ddlCondition1.DataSourceID = "odsViewForDisplayList";
                ddlCondition1.DataValueField = "ConditionID";
                ddlCondition1.DataTextField = "Name";
                ddlCondition1.DataBind();
                ddlCondition1.SelectedValue = Request.QueryString["search_ddlCondition1"];

                // ... For text for search
                tbxCondition1.Text = Request.QueryString["search_tbxCondition1"];

                // ... ForView
                int companyId = Int32.Parse(hdfCompanyId.Value.Trim());
                string fmType = hdfFmType.Value;
                int loginId = Convert.ToInt32(Session["loginID"]);
                string viewTypeGlobal = "";
                string viewTypePersonal = "Personal";

                // Global Views check
                if (Convert.ToBoolean(Session["sgLFS_GLOBALVIEWS_VIEW"]))
                {
                    viewTypeGlobal = "Global";
                }

                FmViewList fmViewList = new FmViewList();
                fmViewList.LoadAndAddItem(fmType, viewTypeGlobal, viewTypePersonal, loginId, companyId);
                ddlView.DataSource = fmViewList.Table;
                ddlView.DataValueField = "ViewID";
                ddlView.DataTextField = "Name";
                ddlView.DataBind();
                ddlView.SelectedValue = Request.QueryString["search_ddlView"];

                //Other values
                //... For SortBy
                odsSortByList.DataBind();
                ddlSortBy.DataSourceID = "odsSortByList";
                ddlSortBy.DataValueField = "SortID";
                ddlSortBy.DataTextField = "Name";
                ddlSortBy.DataBind();
                ddlSortBy.SelectedValue = Request.QueryString["search_sort_by"];

                // ... For BtnOrigin
                hdfBtnOrigin.Value = Request.QueryString["btn_origin"];

                // Grid's columns
                grdUnitsNavigator.Columns[2].Visible = (columnsToDisplay.IndexOf("Code") >= 0 ? true : false);
                grdUnitsNavigator.Columns[3].Visible = (columnsToDisplay.IndexOf("Description") >= 0 ? true : false);
                grdUnitsNavigator.Columns[4].Visible = (columnsToDisplay.IndexOf("VIN/SN") >= 0 ? true : false);
                grdUnitsNavigator.Columns[5].Visible = (columnsToDisplay.IndexOf(", State") >= 0 ? true : false);
                grdUnitsNavigator.Columns[6].Visible = (columnsToDisplay.IndexOf("Manufacturer") >= 0 ? true : false);
                grdUnitsNavigator.Columns[7].Visible = (columnsToDisplay.IndexOf("Model") >= 0 ? true : false);
                grdUnitsNavigator.Columns[8].Visible = (columnsToDisplay.IndexOf("Is Towable?") >= 0 ? true : false);
                grdUnitsNavigator.Columns[9].Visible = (columnsToDisplay.IndexOf("Insurance Class") >= 0 ? true : false);
                grdUnitsNavigator.Columns[10].Visible = (columnsToDisplay.IndexOf("Ryder Specified") >= 0 ? true : false);

                // before 9 after 11
                grdUnitsNavigator.Columns[11].Visible = (columnsToDisplay.IndexOf("Model Year") >= 0 ? true : false);
                grdUnitsNavigator.Columns[12].Visible = (columnsToDisplay.IndexOf("Category") >= 0 ? true : false);
                grdUnitsNavigator.Columns[13].Visible = (columnsToDisplay.IndexOf("Company Level") >= 0 ? true : false);
                grdUnitsNavigator.Columns[14].Visible = (columnsToDisplay.IndexOf("Acquisition Date") >= 0 ? true : false);
                grdUnitsNavigator.Columns[15].Visible = (columnsToDisplay.IndexOf("Cost (CAD)") >= 0 ? true : false);
                grdUnitsNavigator.Columns[16].Visible = (columnsToDisplay.IndexOf("Cost (USD)") >= 0 ? true : false);
                grdUnitsNavigator.Columns[17].Visible = (columnsToDisplay.IndexOf("License Country") >= 0 ? true : false);
                grdUnitsNavigator.Columns[18].Visible = (columnsToDisplay.IndexOf("License State") >= 0 ? true : false);
                grdUnitsNavigator.Columns[19].Visible = (columnsToDisplay.IndexOf("License Plate Number") >= 0 ? true : false);
                grdUnitsNavigator.Columns[20].Visible = (columnsToDisplay.IndexOf("Apportioned Tag Number") >= 0 ? true : false);
                grdUnitsNavigator.Columns[21].Visible = (columnsToDisplay.IndexOf("Actual Weight") >= 0 ? true : false);
                grdUnitsNavigator.Columns[22].Visible = (columnsToDisplay.IndexOf("Registered Weight") >= 0 ? true : false);
                grdUnitsNavigator.Columns[23].Visible = (columnsToDisplay.IndexOf("Tire Size Front") >= 0 ? true : false);
                grdUnitsNavigator.Columns[24].Visible = (columnsToDisplay.IndexOf("Tire Size Back") >= 0 ? true : false);
                grdUnitsNavigator.Columns[25].Visible = (columnsToDisplay.IndexOf("Number Of Axes") >= 0 ? true : false);
                grdUnitsNavigator.Columns[26].Visible = (columnsToDisplay.IndexOf("Fuel Type") >= 0 ? true : false);
                grdUnitsNavigator.Columns[27].Visible = (columnsToDisplay.IndexOf("Beginning Odometer") >= 0 ? true : false);
                grdUnitsNavigator.Columns[28].Visible = (columnsToDisplay.IndexOf("Is Reefer Equipped?") >= 0 ? true : false);
                grdUnitsNavigator.Columns[29].Visible = (columnsToDisplay.IndexOf("Is PTO Equipped?") >= 0 ? true : false);
                grdUnitsNavigator.Columns[30].Visible = (columnsToDisplay.IndexOf("Owner Type") >= 0 ? true : false);
                grdUnitsNavigator.Columns[31].Visible = (columnsToDisplay.IndexOf("Owner Country") >= 0 ? true : false);
                grdUnitsNavigator.Columns[32].Visible = (columnsToDisplay.IndexOf("Owner State") >= 0 ? true : false);
                grdUnitsNavigator.Columns[33].Visible = (columnsToDisplay.IndexOf("Owner Name") >= 0 ? true : false);
                grdUnitsNavigator.Columns[34].Visible = (columnsToDisplay.IndexOf("Contact Info") >= 0 ? true : false);
                grdUnitsNavigator.Columns[35].Visible = (columnsToDisplay.IndexOf("Qualified Date") >= 0 ? true : false);
                grdUnitsNavigator.Columns[36].Visible = (columnsToDisplay.IndexOf("Not Qualified Date") >= 0 ? true : false);
                grdUnitsNavigator.Columns[37].Visible = (columnsToDisplay.IndexOf("Not Qualified Explain") >= 0 ? true : false);
                grdUnitsNavigator.Columns[38].Visible = (columnsToDisplay.IndexOf("Notes") >= 0 ? true : false);
            }
            catch
            {
                string url = "./units_navigator.aspx?source_page=out";
                Response.Redirect(url);
            }
        }