public void BindRequisitionSummary() { TechnicalBAL objtechBAL = new TechnicalBAL(); DataSet dsReqSumm = new DataSet(); dsReqSumm = objtechBAL.CancelledGetRequisitionSummary(Request.QueryString["REQUISITION_CODE"].ToString(), Request.QueryString["document_code"].ToString(), Request.QueryString["Vessel_Code"].ToString()); lblDepartment.Text = Convert.ToString(dsReqSumm.Tables[0].Rows[0]["DepartmentType"]); lblCatalog.Text = Convert.ToString(dsReqSumm.Tables[0].Rows[0]["Catalog"]); lblReqNo.Text = Convert.ToString(dsReqSumm.Tables[0].Rows[0]["RequistionCode"]); lblTotalItem.Text = Convert.ToString(dsReqSumm.Tables[0].Rows[0]["TotalItems"]); lblToDate.Text = Convert.ToString(dsReqSumm.Tables[0].Rows[0]["ToDate"]); lblVessel.Text = Convert.ToString(dsReqSumm.Tables[0].Rows[0]["VesselName"]); txtComments.Text = Convert.ToString(dsReqSumm.Tables[0].Rows[0]["ReqComents"]); //-------Maker Details------ //lblMarkerAdd.Text = dsReqSumm.Tables[0].Rows[0]["MakerAddress"].ToString(); txtAddress.Text = Convert.ToString(dsReqSumm.Tables[0].Rows[0]["MakerAddress"]); lblMakerPh.Text = Convert.ToString(dsReqSumm.Tables[0].Rows[0]["MakerPhone"]); lblMakerName.Text = Convert.ToString(dsReqSumm.Tables[0].Rows[0]["MakerName"]); lblMakerExtension.Text = Convert.ToString(dsReqSumm.Tables[0].Rows[0]["MakerTELEX"]); lblMakerEmail.Text = Convert.ToString(dsReqSumm.Tables[0].Rows[0]["MakerEmail"]); lblMakerContact.Text = Convert.ToString(dsReqSumm.Tables[0].Rows[0]["MakerCONTACT"]); lblMakerCity.Text = Convert.ToString(dsReqSumm.Tables[0].Rows[0]["MakerCity"]); lblModel.Text = Convert.ToString(dsReqSumm.Tables[0].Rows[0]["Model"]); lblParticulars.Text = Convert.ToString(dsReqSumm.Tables[0].Rows[0]["Particulars"]); if (dsReqSumm.Tables[0].Rows[0]["Reqsn_Type"].ToString() != "0") { ddlReqsnType.Items.FindByValue(dsReqSumm.Tables[0].Rows[0]["Reqsn_Type"].ToString()).Selected = true; } if (dsReqSumm.Tables[0].Rows[0]["REQUISITION_ETA"].ToString() != "")//should be enable untill deliveru update { ddlReqsnType.Enabled = false; } //-------Vessel Details--------- DataTable dtVesselDtl = objtechBAL.Get_VID_VesselDetails(UDFLib.ConvertToInteger(Request.QueryString["Vessel_Code"].ToString())); if (dtVesselDtl.Rows.Count > 0) { lblVesselExName1.Text = Convert.ToString(dtVesselDtl.Rows[0]["VesselExNames"]); //lblVesselExName2.Text = Convert.ToString(dsReqSumm.Tables[0].Rows[0]["Vessel_Ex_Name2"]); lblVesselHullNo.Text = Convert.ToString(dtVesselDtl.Rows[0]["Vessel_Hull_No"]); lblVesselType.Text = Convert.ToString(dtVesselDtl.Rows[0]["Vessel_Type"]); lblVesselYard.Text = Convert.ToString(dtVesselDtl.Rows[0]["Vessel_Yard"]); lblVesselDelvDate.Text = Convert.ToString(dtVesselDtl.Rows[0]["Vessel_Delvry_Date"]); lblIMOno.Text = Convert.ToString(dtVesselDtl.Rows[0]["Vessel_IMO_No"]); } rgdItems.DataSource = dsReqSumm.Tables[1]; rgdItems.DataBind(); rpAttachment.DataSource = dsReqSumm.Tables[2]; rpAttachment.DataBind(); }