protected void Search_Worklist() { try { DataTable dtStatus = new DataTable(); dtStatus.Columns.Add("All", typeof(int)); dtStatus.Columns.Add("Pending", typeof(int)); dtStatus.Columns.Add("Completed", typeof(int)); dtStatus.Columns.Add("Reworked", typeof(int)); dtStatus.Columns.Add("Verified", typeof(int)); dtStatus.Columns.Add("Overdue", typeof(int)); //string JobStaus =""; dtStatus.Rows.Add(1, 0, 0, 0, 0, 0); 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", null }); dtFilter.Rows.Add(new object[] { "@VESSEL_ID", null }); dtFilter.Rows.Add(new object[] { "@ASSIGNOR", null }); dtFilter.Rows.Add(new object[] { "@DEPT_SHIP", null }); dtFilter.Rows.Add(new object[] { "@DEPT_OFFICE", null }); dtFilter.Rows.Add(new object[] { "@PRIORITY", null }); dtFilter.Rows.Add(new object[] { "@CATEGORY_NATURE", null }); dtFilter.Rows.Add(new object[] { "@CATEGORY_PRIMARY", null }); dtFilter.Rows.Add(new object[] { "@CATEGORY_SECONDARY", null }); dtFilter.Rows.Add(new object[] { "@CATEGORY_MINOR", null, }); dtFilter.Rows.Add(new object[] { "@JOB_DESCRIPTION", null }); dtFilter.Rows.Add(new object[] { "@JOB_STATUS", null }); dtFilter.Rows.Add(new object[] { "@dtJOB_Status", dtStatus }); dtFilter.Rows.Add(new object[] { "@JOB_TYPE", 0 }); dtFilter.Rows.Add(new object[] { "@PIC", null }); dtFilter.Rows.Add(new object[] { "@JOB_MODIFIED_IN", null }); dtFilter.Rows.Add(new object[] { "@DATE_RAISED_FROM", null }); dtFilter.Rows.Add(new object[] { "@DATE_RAISED_TO", null }); dtFilter.Rows.Add(new object[] { "@DATE_CMPLTN_FROM", null }); dtFilter.Rows.Add(new object[] { "@DATE_CMPLTN_TO", 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", null }); dtFilter.Rows.Add(new object[] { "@PAGE_INDEX", null }); dtFilter.Rows.Add(new object[] { "@PAGE_SIZE", null }); dtFilter.Rows.Add(new object[] { "@Company_ID", null }); dtFilter.Rows.Add(new object[] { "@WL_TYPE", null }); dtFilter.Rows.Add(new object[] { "@InspectionID", null }); //if (ViewState["SchDetailId"] != null) //{ // dtFilter.Rows.Add(new object[] { "@InspectionID", Convert.ToInt32(ViewState["SchDetailId"].ToString()) }); //} dtFilter.Rows.Add(new object[] { "@SortBy", null }); dtFilter.Rows.Add(new object[] { "@SORT_DIRECTION", null }); int Record_Count = 0; DataTable taskTable = objBLL.Get_WorkList_Index(dtFilter, ref Record_Count); 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; } 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); } }