public void BindProductDetails(long OrderID, int Sequence, long UserID) { CustomProfile profile = CustomProfile.GetProfile(); iPartRequestClient objService = new iPartRequestClient(); int IsPriceEdit = objService.IsPriceEditYN(OrderID, UserID, profile.DBConnection._constr); int IsSkuChange = objService.IsSkuChangeYN(OrderID, UserID, profile.DBConnection._constr); if (IsPriceEdit == 1) { txtPrc.Disabled = false; } else { txtPrc.Disabled = true; } if (IsSkuChange == 1) { txtReqQty.Disabled = false; } else { txtReqQty.Disabled = true; } DataSet ds = new DataSet(); ds = objService.GetProductOfOrder(OrderID, Sequence, profile.DBConnection._constr); txtProductCode.Text = ds.Tables[0].Rows[0]["Prod_Code"].ToString(); txtProductName.Text = ds.Tables[0].Rows[0]["Prod_Name"].ToString(); txtProductDescription.Text = ds.Tables[0].Rows[0]["Prod_Description"].ToString(); txtMOQ.Text = ds.Tables[0].Rows[0]["moq"].ToString(); txtCurrentStock.Text = ds.Tables[0].Rows[0]["AvailableBalance"].ToString(); txtReserveStock.Text = ds.Tables[0].Rows[0]["ResurveQty"].ToString(); // txtReqQty.Value = ds.Tables[0].Rows[0]["OrderQty"].ToString(); txtOrderQty.Text = ds.Tables[0].Rows[0]["OrderQty"].ToString(); txtPrc.Value = ds.Tables[0].Rows[0]["Price"].ToString(); //txtPrice.Text = ds.Tables[0].Rows[0]["Price"].ToString(); txtTotal.Text = ds.Tables[0].Rows[0]["Total"].ToString(); int ProdID = int.Parse(ds.Tables[0].Rows[0]["SkuId"].ToString()); hdnSelectedProduct.Value = ProdID.ToString(); DataSet dsUOM = new DataSet(); dsUOM = objService.GetUOMofSelectedProduct(ProdID, profile.DBConnection._constr); ddlUOM.DataSource = dsUOM; ddlUOM.DataBind(); //ddlUOM.SelectedValue =ds.Tables[0].Rows[0]["UOMID"].ToString(); ddlUOM.SelectedIndex = ddlUOM.Items.IndexOf(ddlUOM.Items.FindByValue(ds.Tables[0].Rows[0]["UOMID"].ToString())); DataSet dsUOMSelPrd = new DataSet(); dsUOMSelPrd = objService.GetUOMofSelectedProduct(ProdID, profile.DBConnection._constr); int SelInd = 0; SelInd = ddlUOM.SelectedIndex; decimal SelectedQty = decimal.Parse(dsUOMSelPrd.Tables[0].Rows[SelInd]["Quantity"].ToString()); decimal UserQty = decimal.Parse(ds.Tables[0].Rows[0]["OrderQty"].ToString()); txtReqQty.Value = Convert.ToString(UserQty / SelectedQty); }