private void GetBalanceQuanity()
        {
            try
            {
                string OCode  = ((SessionUser)Session["SessionUser"]).OCode;
                Guid   userId = ((SessionUser)Session["SessionUser"]).UserId;
                int    PId    = Convert.ToInt32(ddlItemName.SelectedValue.ToString());

                //List<Inv_BuyCentral> _BalanceQty = iChallanBll.Get_ItemBalance_ById_Store(OCode, PId, ddlStore.SelectedValue).ToList();

                List <productsDetails> Details = new List <productsDetails>();
                Details = rpt.Get_StockDetailsByDate_Product_Store(txtDate.Text, txtDate.Text, OCode, ddlItemGroup.SelectedValue.ToString(), ddlItemName.SelectedValue.ToString(), ddlStore.SelectedValue.ToString(), userId);

                if (Details.Count > 0)
                {
                    var BlQty = Details.Last();
                    txtBalanceQty.Text = BlQty.ClosingBalance.ToString();
                }
                else
                {
                    txtBalanceQty.Text = "0";
                }
            }
            catch (Exception ex)
            {
                ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true);
            }
        }