protected void ddlTablet_SelectedIndexChanged(object sender, EventArgs e) { try { List <EntityPrescriptionDetails> lst = null; if (ddlTablet.SelectedIndex > 0) { IssueMaterialBLL mobjDeptBLL = new IssueMaterialBLL(); EntityProduct entProduct = mobjDeptBLL.GetProductPrice(Convert.ToInt32(ddlTablet.SelectedValue)); List <tblStockDetail> lst1 = new CustomerTransactionBLL().GetProductTransByProductId(Convert.ToInt32(ddlTablet.SelectedValue)); if (lst1 != null) { lblBalQty.Text = Convert.ToString(Convert.ToInt32(lst1.Sum(p => p.InwardQty)) - Convert.ToInt32(lst1.Sum(p => p.OutwardQty))); } else { lblBalQty.Text = string.Empty; } } else { lst = new List <EntityPrescriptionDetails>(); } } catch (Exception ex) { lblMsg.Text = ex.Message; } }
public void BindTablet() { try { IssueMaterialBLL mobjDeptBLL = new IssueMaterialBLL(); List <EntityProduct> lstPat = mobjDeptBLL.GetProductList(); ddlTablet.DataSource = lstPat; lstPat.Insert(0, new EntityProduct() { ProductId = 0, ProductName = "--Select--" }); ddlTablet.DataValueField = "ProductId"; ddlTablet.DataTextField = "ProductName"; ddlTablet.DataBind(); } catch (Exception ex) { lblMessage.Text = ex.Message; } }