private int PostPageChangesOtherCosts()
        {
            int selectedRows = 0;

            if (pnlOtherGrid.Visible)
            {
                ActualCostsNavigatorOtherCosts actualCostsNavigatorOtherCosts = new ActualCostsNavigatorOtherCosts(actualCostsNavigatorTDS);
                if (actualCostsNavigatorOtherCosts.Table.Rows.Count > 0)
                {
                    foreach (GridViewRow row in grdOtherNavigator.Rows)
                    {
                        if (((CheckBox)row.FindControl("cbxOtherSelected")).Checked)
                        {
                            string category = ((Label)row.FindControl("lblCategory")).Text.Trim();
                            int projectId = Int32.Parse(((Label)row.FindControl("lblOtherProjectID")).Text.Trim());
                            int refId = Int32.Parse(((Label)row.FindControl("lblOtherRefID")).Text.Trim());
                            bool selected = ((CheckBox)row.FindControl("cbxOtherSelected")).Checked;
                            tableCategory = category;
                            selectedRows = selectedRows + 1;

                            actualCostsNavigatorOtherCosts.Update(projectId, refId, selected);
                        }
                    }

                    actualCostsNavigatorOtherCosts.Data.AcceptChanges();

                    // Store datasets
                    Session["actualCostsNavigatorTDS"] = actualCostsNavigatorTDS;
                }
            }

            return selectedRows;
        }
        private void LoadByOther(int projectId, int clientId, string textForSearch, ActualCostsNavigatorTDS actualCostsNavigatorTDSForSearch, string category)
        {
            bool loadAll = false;
            if (category == "LoadAll") loadAll = true;
            string whereClause = GetWhereClauseForOther(category, projectId, clientId, textForSearch, loadAll);
            string orderByClause = GetOrderByClause();

            ActualCostsNavigatorOtherCosts actualCostsNavigatorOtherCosts = new ActualCostsNavigatorOtherCosts(actualCostsNavigatorTDSForSearch);
            actualCostsNavigatorOtherCosts.Load(whereClause, orderByClause);
        }