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); }
protected void Grid1_OnRowDataBound(object sender, Obout.Grid.GridRowEventArgs e) { iPartRequestClient objService = new iPartRequestClient(); CustomProfile profile = CustomProfile.GetProfile(); try { if (e.Row.RowType == Obout.Grid.GridRowType.DataRow) { //Obout.Grid.GridDataControlFieldCell cell = e.Row.Cells[6] as Obout.Grid.GridDataControlFieldCell; //Obout.Grid.GridDataControlFieldCell cell = e.Row.Cells[7] as Obout.Grid.GridDataControlFieldCell; Obout.Grid.GridDataControlFieldCell cell = e.Row.Cells[8] as Obout.Grid.GridDataControlFieldCell; DropDownList ddl = cell.FindControl("ddlUOM") as DropDownList; HiddenField hdnUOM = cell.FindControl("hdnMyUOM") as HiddenField; //Label rowQtySpn = e.Row.Cells[9].FindControl("rowQtyTotal") as Label; Label rowQtySpn = e.Row.Cells[10].FindControl("rowQtyTotal") as Label; //TextBox txtUsrQty = e.Row.Cells[6].FindControl("txtUsrQty") as TextBox; TextBox txtUsrQty = e.Row.Cells[7].FindControl("txtUsrQty") as TextBox; int ProdID = Convert.ToInt32(e.Row.Cells[0].Text); decimal moq = Convert.ToDecimal(e.Row.Cells[6].Text); TextBox txtUsrPrice = e.Row.Cells[11].FindControl("txtUsrPrice") as TextBox; Label rowPriceTotal = e.Row.Cells[12].FindControl("rowPriceTotal") as Label; DataSet dsUOM = new DataSet(); dsUOM = objService.GetUOMofSelectedProduct(ProdID, profile.DBConnection._constr); ddl.DataSource = dsUOM; ddl.DataTextField = "Description"; ddl.DataValueField = "UMOGroup"; ddl.DataBind(); decimal SelectedQty = 0, SelectedUOM = 0; decimal Price = decimal.Parse(txtUsrPrice.Text.ToString()); //ddl.SelectedValue = e.Row.Cells[6].Text; if (hdnTemplateID.Value != "") { long TemplID = Convert.ToInt64(hdnTemplateID.Value); string selectedUom = objService.GetSelectedUomTemplate(TemplID, ProdID, profile.DBConnection._constr); ddl.SelectedIndex = ddl.Items.IndexOf(ddl.Items.FindByValue(selectedUom.ToString())); rowQtySpn.Text = txtUsrQty.Text; rowPriceTotal.Text = e.Row.Cells[12].Text; } else { ddl.SelectedIndex = 2; SelectedQty = decimal.Parse(dsUOM.Tables[0].Rows[2]["Quantity"].ToString()); SelectedUOM = decimal.Parse(dsUOM.Tables[0].Rows[2]["UOMID"].ToString()); decimal rowQty = decimal.Parse(txtUsrQty.Text.ToString()); decimal UsrQty = SelectedQty * rowQty; hdnSelectedQty.Value = SelectedQty.ToString(); rowQtySpn.Text = UsrQty.ToString(); } ddl.Attributes.Add("onchange", "javascript:GetIndex(this,'" + hdnUOM.ClientID.ToString() + "','" + rowQtySpn.ClientID.ToString() + "','" + txtUsrQty.ClientID.ToString() + "'," + e.Row.RowIndex + "," + Price + ",'" + rowPriceTotal.ClientID.ToString() + "'," + moq + ")"); txtUsrQty.Attributes.Add("onblur", "javascript:GetIndexQty(this," + SelectedQty + "," + SelectedUOM + ",'" + rowQtySpn.ClientID.ToString() + "','" + txtUsrQty.ClientID.ToString() + "'," + e.Row.RowIndex + "," + Price + ",'" + rowPriceTotal.ClientID.ToString() + "'," + moq + ")"); txtUsrPrice.Attributes.Add("onblur", "javascript:GetChangedPrice(this," + SelectedQty + "," + SelectedUOM + ",'" + rowQtySpn.ClientID.ToString() + "','" + txtUsrQty.ClientID.ToString() + "'," + e.Row.RowIndex + ",'" + rowPriceTotal.ClientID.ToString() + "'," + ProdID + ")"); //} } } catch (System.Exception ex) { Login.Profile.ErrorHandling(ex, this, "Request Template", "Grid1_OnRowDataBound"); } finally { objService.Close(); } }