protected void Search_Worklist() { try { UpdateWorklistChecklist(); DataTable dtFilter = new DataTable(); dtFilter.Columns.Add("PRM_NAME", typeof(string)); dtFilter.Columns.Add("PRM_VALUE", typeof(object)); dtFilter.Rows.Add(new object[] { "@FLEET_ID", UDFLib.ConvertIntegerToNull(null) }); dtFilter.Rows.Add(new object[] { "@VESSEL_ID", UDFLib.ConvertIntegerToNull(ViewState["VID"]) }); dtFilter.Rows.Add(new object[] { "@ASSIGNOR", UDFLib.ConvertIntegerToNull(null) }); dtFilter.Rows.Add(new object[] { "@DEPT_SHIP", UDFLib.ConvertIntegerToNull(null) }); dtFilter.Rows.Add(new object[] { "@DEPT_OFFICE", UDFLib.ConvertIntegerToNull(null) }); dtFilter.Rows.Add(new object[] { "@PRIORITY", UDFLib.ConvertIntegerToNull(null) }); dtFilter.Rows.Add(new object[] { "@CATEGORY_NATURE", UDFLib.ConvertIntegerToNull(null) }); dtFilter.Rows.Add(new object[] { "@CATEGORY_PRIMARY", UDFLib.ConvertIntegerToNull(null) }); dtFilter.Rows.Add(new object[] { "@CATEGORY_SECONDARY", UDFLib.ConvertIntegerToNull(null) }); dtFilter.Rows.Add(new object[] { "@CATEGORY_MINOR", null, }); dtFilter.Rows.Add(new object[] { "@JOB_DESCRIPTION", UDFLib.ConvertStringToNull(null) }); dtFilter.Rows.Add(new object[] { "@JOB_STATUS", UDFLib.ConvertStringToNull(rblJobStaus.SelectedValue) }); dtFilter.Rows.Add(new object[] { "@JOB_TYPE", UDFLib.ConvertIntegerToNull(null) }); dtFilter.Rows.Add(new object[] { "@PIC", UDFLib.ConvertIntegerToNull(null) }); dtFilter.Rows.Add(new object[] { "@JOB_MODIFIED_IN", UDFLib.ConvertIntegerToNull(null) }); dtFilter.Rows.Add(new object[] { "@DATE_RAISED_FROM", UDFLib.ConvertDateToNull(null) }); dtFilter.Rows.Add(new object[] { "@DATE_RAISED_TO", UDFLib.ConvertDateToNull(null) }); dtFilter.Rows.Add(new object[] { "@DATE_CMPLTN_FROM", UDFLib.ConvertDateToNull(null) }); dtFilter.Rows.Add(new object[] { "@DATE_CMPLTN_TO", UDFLib.ConvertDateToNull(null) }); dtFilter.Rows.Add(new object[] { "@DEFER_TO_DD", (null) }); dtFilter.Rows.Add(new object[] { "@SENT_TO_SHIP", (null) }); dtFilter.Rows.Add(new object[] { "@HAVING_REQ_NO", (null) }); dtFilter.Rows.Add(new object[] { "@FLAGGED_FOR_MEETING", (null) }); dtFilter.Rows.Add(new object[] { "@INSPECTOR", UDFLib.ConvertIntegerToNull(null) }); dtFilter.Rows.Add(new object[] { "@PAGE_INDEX", ucCustomPagerctp.CurrentPageIndex }); dtFilter.Rows.Add(new object[] { "@PAGE_SIZE", ucCustomPagerctp.PageSize }); int Record_Count = 0; DataTable taskTable = objInsp.Get_WorkList_Index(dtFilter, ref Record_Count); grdJoblist.DataSource = taskTable; grdJoblist.DataBind(); ucCustomPagerctp.CountTotalRec = Record_Count.ToString(); ucCustomPagerctp.BuildPager(); DataTable dtPKIDs = taskTable.DefaultView.ToTable(true, new string[] { "WORKLIST_ID", "VESSEL_ID", "OFFICE_ID" }); dtPKIDs.PrimaryKey = new DataColumn[] { dtPKIDs.Columns["WORKLIST_ID"], dtPKIDs.Columns["VESSEL_ID"], dtPKIDs.Columns["OFFICE_ID"] }; Session["WORKLIST_PKID_NAV"] = dtPKIDs; lblRecordCount.Text = Record_Count.ToString(); } catch (Exception ex) { ////.WriteError(this.GetType().Name.ToString(), System.Reflection.MethodBase.GetCurrentMethod().Name.ToString(), ex); string js = "alert('Error in loading data!! Error: " + UDFLib.ReplaceSpecialCharacter(ex.Message) + "');"; ScriptManager.RegisterStartupScript(this, this.GetType(), "error", js, true); } }