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(); }
protected void BindData() { //Step First //DataSet ds = objtec.GetAuditTrailSummary("BEX-10-00004", "313", "313100510095907", ""); DataSet dsAuditSumry = objtec.GetAuditTrailSummary(Request.QueryString["REQUISITION_CODE"].ToString(), Request.QueryString["Vessel_Code"].ToString(), Request.QueryString["document_code"].ToString(), Request.QueryString["QUOTATION_CODE"].ToString()); DataTable dtVesselDtl = objtec.Get_VID_VesselDetails(UDFLib.ConvertToInteger(Request.QueryString["Vessel_Code"].ToString())); if (dtVesselDtl.Rows.Count > 0) { //lblVessel.Text = Convert.ToString(dtVesselDtl.Rows[0]["VesselName"]); //lblVesselExName1.Text = Convert.ToString(dtVesselDtl.Rows[0]["VesselExNames"]); //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"]); } BLL_PURC_Purchase objhold = new BLL_PURC_Purchase(); rgdHoldLog.DataSource = objhold.GetRequisitionOnHoldLogHistory_ByReqsn(Request.QueryString["REQUISITION_CODE"]); rgdHoldLog.DataBind(); DataTable dtCancel = BLL_PURC_Common.GET_ReqsnPermanentCancelLog_DL(UDFLib.ConvertToInteger(Request.QueryString["Vessel_Code"])); if (dtCancel.Rows.Count > 0) { dtCancel.DefaultView.RowFilter = "REQUISITION_CODE='" + Request.QueryString["REQUISITION_CODE"] + "'"; } gvReqsnCAncel.DataSource = dtCancel.DefaultView; gvReqsnCAncel.DataBind(); if (dsAuditSumry.Tables[0].Rows.Count > 0) { lblReqNo.Text = Convert.ToString(dsAuditSumry.Tables[0].Rows[0]["RequistionCode"]); lblTotalItem.Text = Convert.ToString(dsAuditSumry.Tables[0].Rows[0]["TotalItems"]); lblToDate.Text = Convert.ToString(dsAuditSumry.Tables[0].Rows[0]["ToDate"]); txtComments.Text = Convert.ToString(dsAuditSumry.Tables[0].Rows[0]["ReqComents"]); lblDept.Text = Convert.ToString(dsAuditSumry.Tables[0].Rows[0]["DeptName"]); } //Step 2 ReptrQtnSummry.DataSource = dsAuditSumry.Tables[1]; ReptrQtnSummry.DataBind(); //////Step 3 ReptrQtnEve.DataSource = dsAuditSumry.Tables[2]; ReptrQtnEve.DataBind(); //////Step 4 ReptrPurchaseOrd.DataSource = dsAuditSumry.Tables[3]; ReptrPurchaseOrd.DataBind(); //////Step 5 ReptrPendingSupConfirm.DataSource = dsAuditSumry.Tables[4]; ReptrPendingSupConfirm.DataBind(); //////Step 6 ReptrDeliveryStatus.DataSource = dsAuditSumry.Tables[5]; ReptrDeliveryStatus.DataBind(); //////Step 7 ReptrDeliveredItems.DataSource = dsAuditSumry.Tables[6]; ReptrDeliveredItems.DataBind(); }