/// <summary> /// Purpose: To make search functionality available /// </summary> protected void Search_Worklist() { try { SaveItemsSelection(); 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)); dtStatus.Rows.Add(rblJobStaus.Items[0].Selected == true ? 1 : 0, rblJobStaus.Items[1].Selected == true ? 1 : 0, 0, rblJobStaus.Items[2].Selected == true ? 1 : 0, rblJobStaus.Items[3].Selected == true ? 1 : 0, rblJobStaus.Items[4].Selected == true ? 1 : 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", UDFLib.ConvertIntegerToNull(null) }); dtFilter.Rows.Add(new object[] { "@VESSEL_ID", UDFLib.ConvertIntegerToNull(hdnVesselID.Value) }); 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(txtDescription.Text.Trim()) }); dtFilter.Rows.Add(new object[] { "@JOB_STATUS", UDFLib.ConvertStringToNull(rblJobStaus.SelectedValue) }); dtFilter.Rows.Add(new object[] { "@dtJOB_Status", dtStatus }); 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.INSP_GET_WORKLIST_JOB(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(); DataSet dsCheckListWorklist; dsCheckListWorklist = objBLLIndx.VET_Get_ObservationWorklistJobs(UDFLib.ConvertToInteger(Request.QueryString["Vessel_ID"]), UDFLib.ConvertToInteger(ViewState["Observation_ID"].ToString())); foreach (GridViewRow gr in grdJoblist.Rows) { string WORKLIST_ID = Convert.ToString(grdJoblist.DataKeys[gr.RowIndex]["WORKLIST_ID"]); string OFFICE_ID = Convert.ToString(grdJoblist.DataKeys[gr.RowIndex]["OFFICE_ID"]); if (dsCheckListWorklist.Tables.Count > 0) { DataRow[] drchk = dsCheckListWorklist.Tables[0].Select("WORKLIST_ID=" + WORKLIST_ID + " and OFFICE_ID=" + OFFICE_ID); if (drchk.Length > 0) { if (drchk[0]["Observation_ID"].ToString() != ViewState["Observation_ID"].ToString()) { (gr.FindControl("checkRow") as CheckBox).Checked = false; (gr.FindControl("checkRow") as CheckBox).Enabled = false; } else { if (drchk[0]["Observation_ID"].ToString() != "0" && drchk[0]["Observation_ID"].ToString() != "") { (gr.FindControl("checkRow") as CheckBox).Checked = true; if (Convert.ToInt32(drchk[0]["ISCURRENT"]) == 0) { (gr.FindControl("checkRow") as CheckBox).Enabled = false; } } } } } } SaveItemsSelection(); string js = "GridWorkFlow();"; ScriptManager.RegisterStartupScript(this, this.GetType(), "error1", js, true); } catch (Exception ex) { string js = "alert('Error in loading data!! Error: " + UDFLib.ReplaceSpecialCharacter(ex.Message) + "');"; ScriptManager.RegisterStartupScript(this, this.GetType(), "error2", js, true); } }