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

            if (!IsPostBack)
            {
                // Security check
                if (!Convert.ToBoolean(Session["sgLFS_RESOURCES_EMPLOYEES_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) || ((string)Request.QueryString["employee_id"] == null))
                {
                    Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in employees_rol.aspx");
                }

                // Tag Page
                hdfEmployeeId.Value = (string)Request.QueryString["employee_id"];
                hdfUpdate.Value = "no";

                // Iniciate variables
                StepBeginIn();

                // Restore dataset
                employeeNavigatorTDS = (EmployeeNavigatorTDS)Session["employeeNavigatorTDS"];
            }
            else
            {
                // Restore dataset
                employeeNavigatorTDS = (EmployeeNavigatorTDS)Session["employeeNavigatorTDS"];
            }
        }
        // ////////////////////////////////////////////////////////////////////////
        // EVENTS
        //
        protected void Page_Load(object sender, EventArgs e)
        {
            // Register client scripts
            this.RegisterClientScripts();

            if (!IsPostBack)
            {
                // Security check
                if (!(Convert.ToBoolean(Session["sgLFS_RESOURCES_EMPLOYEES_VIEW"]) && Convert.ToBoolean(Session["sgLFS_RESOURCES_EMPLOYEES_DELETE"])))
                {
                    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) || ((string)Request.QueryString["employee_id"] == null))
                {
                    Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in employees_delete.aspx");
                }

                // Tag page
                hdfCompanyId.Value = Session["companyID"].ToString();
                hdfCurrentEmployeeId.Value = Request.QueryString["employee_id"];
                hdfActiveTab.Value = Request.QueryString["active_tab"];

                // ... for team member title
                int companyId = Int32.Parse(hdfCompanyId.Value.Trim());
                int employeeId = Int32.Parse(hdfCurrentEmployeeId.Value);

                EmployeeInformationTDS employeeInformationTDS = new EmployeeInformationTDS();

                EmployeeGateway employeeGateway = new EmployeeGateway();
                employeeGateway.LoadByEmployeeId(employeeId);
                lblTitleTeamMember.Text = "Team Member: " + employeeGateway.GetFullName(employeeId);

                // If coming from
                // ... employees_navigator2.aspx
                if (Request.QueryString["source_page"] == "employees_navigator2.aspx")
                {
                    StoreNavigatorState();
                    ViewState["update"] = "no";
                }

                // ... employees_summary.aspx
                if (Request.QueryString["source_page"] == "employees_summary.aspx")
                {
                    StoreNavigatorState();
                    ViewState["update"] = Request.QueryString["update"];
                }

                // Restore dataset
                employeeNavigatorTDS = (EmployeeNavigatorTDS)Session["employeeNavigatorTDS"];
            }
            else
            {
                // Restore dataset
                employeeNavigatorTDS = (EmployeeNavigatorTDS)Session["employeeNavigatorTDS"];
            }
        }
        /// <summary>
        /// GetNextId
        /// </summary>
        /// <param name="employeeNavigatorTDS">employeeNavigatorTDS</param>
        /// <param name="currentEmployeeId">currentEmployeeId</param>
        /// <returns>nextEmployeeId</returns>
        public static int GetNextId(EmployeeNavigatorTDS employeeNavigatorTDS, int currentEmployeeId)
        {
            int nextEmployeeId = currentEmployeeId;

            for (int i = 0; i < employeeNavigatorTDS.EmployeeNavigator.DefaultView.Count; i++)
            {
                if ((int)employeeNavigatorTDS.EmployeeNavigator.DefaultView[i]["EmployeeID"] == currentEmployeeId)
                {
                    if (i == employeeNavigatorTDS.EmployeeNavigator.DefaultView.Count - 1)
                    {
                        nextEmployeeId = currentEmployeeId;
                    }
                    else
                    {
                        nextEmployeeId = (int)employeeNavigatorTDS.EmployeeNavigator.DefaultView[i + 1]["EmployeeID"];
                    }
                    break;
                }
            }

            return nextEmployeeId;
        }
        /// <summary>
        /// GetPreviousId
        /// </summary>
        /// <param name="employeeNavigatorTDS">employeeNavigatorTDS</param>
        /// <param name="currentEmployeeId">currentEmployeeId</param>
        /// <returns>prevEmployeeId</returns>
        public static int GetPreviousId(EmployeeNavigatorTDS employeeNavigatorTDS, int currentEmployeeId)
        {
            int prevEmployeeId = currentEmployeeId;

            for (int i = 0; i < employeeNavigatorTDS.EmployeeNavigator.DefaultView.Count; i++)
            {
                if ((int)employeeNavigatorTDS.EmployeeNavigator.DefaultView[i]["EmployeeID"] == currentEmployeeId)
                {
                    if (i == 0)
                    {
                        prevEmployeeId = currentEmployeeId;
                    }
                    else
                    {
                        prevEmployeeId = (int)employeeNavigatorTDS.EmployeeNavigator.DefaultView[i - 1]["EmployeeID"];
                    }

                    break;
                }
            }

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

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

                // Tag Page
                hdfCompanyId.Value = Session["companyID"].ToString();
                hdfResourceType.Value = "Employee";
                Session.Remove("employeeNavigatorNewDummy");

                // Prepare initial data
                // ... For
                odsViewForConditionList.DataBind();
                ddlCondition1.DataSourceID = "odsViewForConditionList";
                ddlCondition1.DataValueField = "ConditionID";
                ddlCondition1.DataTextField = "Name";
                ddlCondition1.DataBind();

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

                // If coming from
                // ... employees_navigator.aspx or employees_navigator2.aspx
                if ((Request.QueryString["source_page"] == "employees_navigator.aspx") || (Request.QueryString["source_page"] == "employees_navigator2.aspx"))
                {
                    RestoreNavigatorState();
                    employeeNavigatorTDS = (EmployeeNavigatorTDS)Session["employeeNavigatorTDS"];
                }

                // ... employees_edit.aspx, employees_summary.aspx or employees_delete.aspx
                if ((Request.QueryString["source_page"] == "employees_edit.aspx") || (Request.QueryString["source_page"] == "employees_summary.aspx") || (Request.QueryString["source_page"] == "employees_delete.aspx"))
                {
                    RestoreNavigatorState();

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

                        // ... Search data with updates
                        employeeNavigatorTDS = SubmitSearch();

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

                // ... employees_delete.aspx, employee_summary.aspx or employee_edit.aspx
                if ((Request.QueryString["source_page"] == "employee_delete.aspx") || (Request.QueryString["source_page"] == "employee_summary.aspx") || (Request.QueryString["source_page"] == "employee_edit.aspx"))
                {
                    if (employeeNavigatorTDS.EmployeeNavigator.Rows.Count == 0)
                    {
                        string url = "./employees_navigator.aspx?source_page=employees_navigator2.aspx&re_type=" + hdfResourceType.Value + GetNavigatorState() + "&no_results=yes";
                        Response.Redirect(url);
                    }
                }

                Session["employeeNavigatorTDS"] = employeeNavigatorTDS;
                Session["employeeNavigator"] = employeeNavigatorTDS.EmployeeNavigator;

                // ... for the total rows
                if (employeeNavigatorTDS.EmployeeNavigator.Rows.Count > 0)
                {
                    lblTotalRows.Text = "Total Rows: " + employeeNavigatorTDS.EmployeeNavigator.Rows.Count;
                    lblTotalRows.Visible = true;
                }
                else
                {
                    lblTotalRows.Visible = false;
                }
            }
            else
            {
                // Restore searched data (if any)
                employeeNavigatorTDS = (EmployeeNavigatorTDS)Session["employeeNavigatorTDS"];
                employeeNavigator = employeeNavigatorTDS.EmployeeNavigator;

                // ... for the total rows
                if (employeeNavigatorTDS.EmployeeNavigator.Rows.Count > 0)
                {
                    lblTotalRows.Text = "Total Rows: " + employeeNavigatorTDS.EmployeeNavigator.Rows.Count;
                    lblTotalRows.Visible = true;
                }
                else
                {
                    lblTotalRows.Visible = false;
                }
            }
        }
        protected void btnSearch_Click(object sender, EventArgs e)
        {
            if (Page.IsValid)
            {
                // Tag Page
                string url = "";

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

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

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

                    // ... Go to the results page
                    url = "./employees_navigator2.aspx?source_page=employees_navigator2.aspx"+ GetNavigatorState();
                }
                else
                {
                    // ... Go to the search page
                    url = "./employees_navigator.aspx?source_page=employees_navigator2.aspx&resource_type=" + hdfResourceType.Value + GetNavigatorState() + "&no_results=yes";
                }

                Response.Redirect(url);
            }
        }
 /// <summary>
 /// InitData
 /// </summary>
 protected override void InitData()
 {
     _data = new EmployeeNavigatorTDS();
 }