/// <summary>
        /// GetPreviousId
        /// </summary>
        /// <param name="unitsNavigatorTDS">unitsNavigatorTDS</param>
        /// <param name="currentUnitId">currentUnitId</param>
        /// <returns>prevUnitId</returns>
        public static int GetPreviousId(UnitsNavigatorTDS unitsNavigatorTDS, int currentUnitId)
        {
            int prevUnitId = currentUnitId;

            for (int i = 0; i < unitsNavigatorTDS.UnitsNavigator.DefaultView.Count; i++)
            {
                if ((int)unitsNavigatorTDS.UnitsNavigator.DefaultView[i]["UnitID"] == currentUnitId)
                {
                    if (i == 0)
                    {
                        prevUnitId = currentUnitId;
                    }
                    else
                    {
                        prevUnitId = (int)unitsNavigatorTDS.UnitsNavigator.DefaultView[i - 1]["UnitID"];
                    }

                    break;
                }
            }

            return prevUnitId;
        }
        /// <summary>
        /// GetNextId
        /// </summary>
        /// <param name="unitsNavigatorTDS">unitsNavigatorTDS</param>
        /// <param name="currentUnitId">currentUnitId</param>
        /// <returns>nextUnitId</returns>
        public static int GetNextId(UnitsNavigatorTDS unitsNavigatorTDS, int currentUnitId)
        {
            int nextUnitId = currentUnitId;

            for (int i = 0; i < unitsNavigatorTDS.UnitsNavigator.DefaultView.Count; i++)
            {
                if ((int)unitsNavigatorTDS.UnitsNavigator.DefaultView[i]["UnitID"] == currentUnitId)
                {
                    if (i == unitsNavigatorTDS.UnitsNavigator.DefaultView.Count - 1)
                    {
                        nextUnitId = currentUnitId;
                    }
                    else
                    {
                        nextUnitId = (int)unitsNavigatorTDS.UnitsNavigator.DefaultView[i + 1]["UnitID"];
                    }

                    break;
                }
            }

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

            if (!IsPostBack)
            {
                // Security check
                if (!(Convert.ToBoolean(Session["sgLFS_FLEETMANAGEMENT_UNITS_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 units_navigator2.aspx");
                }

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

                // 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(new DataSet());
                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
                // ... units_navigator.aspx or units_navigator2.aspx
                if ((Request.QueryString["source_page"] == "units_navigator.aspx") || (Request.QueryString["source_page"] == "units_navigator2.aspx"))
                {
                    RestoreNavigatorState();

                    unitsNavigatorTDS = (UnitsNavigatorTDS)Session["unitsNavigatorTDS"];
                }

                // ... units_edit.aspx, units_summary.aspx or units_delete.aspx
                if ((Request.QueryString["source_page"] == "units_edit.aspx") || (Request.QueryString["source_page"] == "units_summary.aspx") || (Request.QueryString["source_page"] == "units_delete.aspx"))
                {
                    RestoreNavigatorState();

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

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

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

                // ... units_delete.aspx, units_summary.aspx or units_edit.aspx
                if ((Request.QueryString["source_page"] == "units_delete.aspx") || (Request.QueryString["source_page"] == "units_summary.aspx") || (Request.QueryString["source_page"] == "units_edit.aspx"))
                {
                    try
                    {
                        if (unitsNavigatorTDS.UnitsNavigator.Rows.Count == 0)
                        {
                            string url = "./units_navigator.aspx?source_page=units_navigator2.aspx&fm_type=" + hdfFmType.Value + GetNavigatorState() + "&no_results=yes";
                            Response.Redirect(url);
                        }
                    }
                    catch
                    {
                        string url = "./units_navigator.aspx?source_page=out";
                        Response.Redirect(url);
                    }
                }

                // For the grid
                grdUnitsNavigator.DataSource = unitsNavigatorTDS.UnitsNavigator;
                grdUnitsNavigator.DataBind();;

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

                // ... for the total rows
                if (unitsNavigatorTDS.UnitsNavigator.Rows.Count > 0)
                {
                    lblTotalRows.Text = "Total Rows: " + unitsNavigatorTDS.UnitsNavigator.Rows.Count;
                    lblTotalRows.Visible = true;
                }
                else
                {
                    lblTotalRows.Visible = false;
                }
            }
        }
 /// <summary>
 /// InitData
 /// </summary>
 protected override void InitData()
 {
     _data = new UnitsNavigatorTDS();
 }
        protected void btnSearch_Click(object sender, EventArgs e)
        {
            Page.Validate();

            if (Page.IsValid)
            {
                // Tag Page
                hdfBtnOrigin.Value = "Search";

                string url = "";

                // Delete store data
                Session.Contents.Remove("unitsNavigatorTDS");

                // Get data from DA gateway
                unitsNavigatorTDS = SubmitSearch();

                // Show results
                if (unitsNavigatorTDS.UnitsNavigator.Rows.Count > 0)
                {
                    // ... Store data
                    Session["unitsNavigatorTDS"] = unitsNavigatorTDS;

                    // ... Go to the results page
                    url = "./units_navigator2.aspx?source_page=units_navigator2.aspx" + GetNavigatorState();
                }
                else
                {
                    // ... Go to the search page
                    url = "./units_navigator.aspx?source_page=units_navigator2.aspx" + GetNavigatorState() + "&no_results=yes";
                }

                Response.Redirect(url);
            }
        }