/// <summary> /// Bind all records of observation index /// </summary> public void Bind_ObservationIndex() { try { BLL_VET_Index objBLLIndx = new BLL_VET_Index(); DataSet ds = new DataSet(); int rowcount = ucCustomPagerItemsObs.isCountRecord; string sortbycoloumn = (ViewState["SORTBYCOLOUMN"] == null) ? null : (ViewState["SORTBYCOLOUMN"].ToString()); int? sortdirection = null; if (ViewState["SORTDIRECTION"] != null) { sortdirection = Int32.Parse(ViewState["SORTDIRECTION"].ToString()); } DataTable dtInspector = new DataTable(); dtInspector.Columns.Add("ID"); DataTable dtEXInspector = new DataTable(); dtEXInspector.Columns.Add("ID"); foreach (DataRow dr in DDLInspectorObs.SelectedValues.Rows) { if (dr[0].ToString().Split('_')[1] == "In") { dtInspector.Rows.Add(dr[0].ToString().Split('_')[0]); } if (dr[0].ToString().Split('_')[1] == "Ex") { dtEXInspector.Rows.Add(dr[0].ToString().Split('_')[0]); } } DateTime?LObsFromDate, LObsToDate; LObsFromDate = txtLObsFromDate.Text.Trim() == "" ? null : UDFLib.ConvertDateToNull(UDFLib.ConvertToDate(txtLObsFromDate.Text)); LObsToDate = txtLObsToDate.Text.Trim() == "" ? null : UDFLib.ConvertDateToNull(UDFLib.ConvertToDate(txtLObsToDate.Text)); ds = objBLLIndx.VET_Get_ObservationIndex(DDLQuestionnaire.SelectedValues, DDLSection.SelectedValues, DDLQuestion.SelectedValues, UDFLib.ConvertToInteger(rbtnType.SelectedValue), ViewState["Status"].ToString(), UDFLib.ConvertToInteger(DDLFleet.SelectedValue), DDLVesselObs.SelectedValues, DDLOilMajorObs.SelectedValues, dtInspector, dtEXInspector, DDLCategories.SelectedValues, DDLRiskLevel.SelectedValues, txtObservationVessel.Text != "" ? txtObservationVessel.Text.Trim() : null, LObsFromDate, LObsToDate, sortbycoloumn, sortdirection, ucCustomPagerItemsObs.CurrentPageIndex, ucCustomPagerItemsObs.PageSize, ref rowcount); if (ds.Tables.Count > 0) { ViewState["dtObsResponse"] = ds.Tables[1]; ViewState["dtObsJobsCount"] = ds.Tables[2]; ViewState["dtObsvationCount"] = ds.Tables[3]; } if (ucCustomPagerItemsObs.isCountRecord == 1) { ucCustomPagerItemsObs.CountTotalRec = rowcount.ToString(); ucCustomPagerItemsObs.BuildPager(); } gvObservationIndex.DataSource = ds.Tables[0]; gvObservationIndex.DataBind(); if (ds.Tables[0].Rows.Count > 0) { btnObsExport.Enabled = true; } else { btnObsExport.Enabled = false; } UpdPnlGridObs.Update(); UpdPnlFilterObs.Update(); } catch (Exception ex) { UDFLib.WriteExceptionLog(ex); string js = "alert('" + UDFLib.GetException("SystemError/ GeneralMessage") + "');"; ScriptManager.RegisterStartupScript(this, this.GetType(), "error", js, true); } }