public JsonResult GetProductSupplier(string ProductSupplierID)
        {
            BL_Purchase db = new BL_Purchase();

            DataSet dsBalance = new DataSet();
            DataSet ds        = new DataSet();

            dsBalance = objbl.GetProductSupplier(ProductSupplierID);
            ds        = objbl.GetProductSupplier(ProductSupplierID);
            List <Purchase> searchlist = new List <Purchase>();


            foreach (DataRow dr in dsBalance.Tables[0].Rows)
            {
                searchlist.Add(new Purchase
                {
                    ProductSupplierID   = Convert.ToString(dr["ProductSupplierID"]),
                    ProductSupplierName = Convert.ToString(dr["ProductSupplierName"]),
                    Address             = Convert.ToString(dr["Address"]),

                    Balance = dsBalance.Tables[1].Rows[0]["Balance"].ToString(),
                });
            }


            return(new JsonResult {
                Data = searchlist, JsonRequestBehavior = JsonRequestBehavior.AllowGet
            });
        }