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();
}