protected void BindRequestList() { BLL_TRV_TravelRequest treq = new BLL_TRV_TravelRequest(); int rowcount = ucCustomPagerItems.isCountRecord; string status = ViewState["Status"].ToString(); try { if ((status == "RFQ SENT" || status == "QUOTE RECEIVED") && !chkShowAllPendingApproval.Checked) { Approver_ID = UDFLib.ConvertToInteger(Session["userid"]); } DataSet ds = new DataSet(); ds = treq.GetRequestList(UDFLib.ConvertIntegerToNull(cmbFleet.SelectedValue), UDFLib.ConvertIntegerToNull(cmbVessel.SelectedValue), UDFLib.ConvertIntegerToNull(cmbSupplier.SelectedValue), UDFLib.ConvertStringToNull(txtSectorFrom.Text), UDFLib.ConvertStringToNull(txtSectorTo.Text), UDFLib.ConvertStringToNull(txtTrvDateFrom.Text) , UDFLib.ConvertStringToNull(txtTrvDateTo.Text), UDFLib.ConvertStringToNull(txtPaxName.Text), UDFLib.ConvertStringToNull(status), UDFLib.ConvertIntegerToNull(Approver_ID), ucCustomPagerItems.CurrentPageIndex, ucCustomPagerItems.PageSize, ref rowcount); if (ucCustomPagerItems.isCountRecord == 1) { ucCustomPagerItems.CountTotalRec = rowcount.ToString(); ucCustomPagerItems.BuildPager(); } rptParent.DataSource = ds; rptParent.DataBind(); } catch { } finally { treq = null; } }
public DataSet GetRequestList(int vessel_id, string stage, string request_id, string pax_name, string airport, int agent_id) { try { BLL_TRV_TravelRequest objTrv = new BLL_TRV_TravelRequest(); DataSet ds = new DataSet(); int rowcount = 1; ds = objTrv.GetRequestList(vessel_id, stage, request_id, pax_name, airport, agent_id, ref rowcount); return(ds); } catch (Exception ex) { CustomSoapException(ex.GetType().Name, ex.Message); return(null); } }