protected void Load_Crew_Queries() { int FleetCode = UDFLib.ConvertToInteger(ddlFleet.SelectedValue); int Vessel_ID = UDFLib.ConvertToInteger(ddlVessel.SelectedValue); int Query_Type = UDFLib.ConvertToInteger(ddlQueryType.SelectedValue); int Status = UDFLib.ConvertToInteger(rdoStatus.SelectedValue); int PAGE_SIZE = ucCustomPager_CrewQueries.PageSize; int PAGE_INDEX = ucCustomPager_CrewQueries.CurrentPageIndex; int SelectRecordCount = ucCustomPager_CrewQueries.isCountRecord; string SortBy = (ViewState["SORTBY"] == null) ? null : (ViewState["SORTBY"].ToString()); int? SortDirection = null; if (ViewState["SORTDIRECTION"] != null) { SortDirection = Int32.Parse(ViewState["SORTDIRECTION"].ToString()); } DataTable dt = BLL_Crew_Queries.Get_CrewQueries(FleetCode, Vessel_ID, 0, Query_Type, Status, txtFilterText.Text, GetSessionUserID(), PAGE_SIZE, PAGE_INDEX, ref SelectRecordCount, SortBy, SortDirection); ddlQueryType.DataSource = dt; GridView_CrewQueries.DataSource = dt; GridView_CrewQueries.DataBind(); if (ucCustomPager_CrewQueries.isCountRecord == 1) { ucCustomPager_CrewQueries.CountTotalRec = SelectRecordCount.ToString(); ucCustomPager_CrewQueries.BuildPager(); } }
protected void Load_Crew_Queries() { int FleetCode = 0; int Vessel_ID = 0; int CrewID = UDFLib.ConvertToInteger(Request.QueryString["CrewID"]); int Query_Type = 0; int Status = 0; int PAGE_SIZE = 1000; int PAGE_INDEX = 1; int SelectRecordCount = 0; string SortBy = (ViewState["SORTBY"] == null) ? null : (ViewState["SORTBY"].ToString()); int? SortDirection = null; if (ViewState["SORTDIRECTION"] != null) { SortDirection = Int32.Parse(ViewState["SORTDIRECTION"].ToString()); } DataTable dt = BLL_Crew_Queries.Get_CrewQueries(FleetCode, Vessel_ID, CrewID, Query_Type, Status, null, GetSessionUserID(), PAGE_SIZE, PAGE_INDEX, ref SelectRecordCount, SortBy, SortDirection); GridView_CrewQueries.DataSource = dt; GridView_CrewQueries.DataBind(); }