private int PostPageChangesHotels()
        {
            int selectedRows = 0;

            if (pnlHotelGrid.Visible)
            {
                ActualCostsNavigatorHotelCosts actualCostsNavigatorHotelCosts = new ActualCostsNavigatorHotelCosts(actualCostsNavigatorTDS);

                if (actualCostsNavigatorHotelCosts.Table.Rows.Count > 0)
                {
                    foreach (GridViewRow row in grdHotelNavigator.Rows)
                    {
                        if (((CheckBox)row.FindControl("cbxHotelSelected")).Checked)
                        {
                            int hotelId = Int32.Parse(((Label)row.FindControl("lblHotelID")).Text.Trim());
                            int projectId = Int32.Parse(((Label)row.FindControl("lblHotelProjectID")).Text.Trim());
                            int refId = Int32.Parse(((Label)row.FindControl("lblHotelRefID")).Text.Trim());
                            bool selected = ((CheckBox)row.FindControl("cbxHotelSelected")).Checked;
                            tableCategory = "Hotels";
                            selectedRows = selectedRows + 1;

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

                    actualCostsNavigatorHotelCosts.Data.AcceptChanges();

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

            return selectedRows;
        }
        private void LoadByHotel(int projectId, int clientId, string textForSearch, ActualCostsNavigatorTDS actualCostsNavigatorTDSForSearch, int hotelId)
        {
            string whereClause = GetWhereClauseForHotel(hotelId, projectId, clientId, textForSearch);
            string orderByClause = GetOrderByClause();

            ActualCostsNavigatorHotelCosts actualCostsNavigatorHotelCosts = new ActualCostsNavigatorHotelCosts(actualCostsNavigatorTDSForSearch);
            actualCostsNavigatorHotelCosts.Load(whereClause, orderByClause);
        }