private void BindPageControls()
    {
        Boolean ChkFlag = false;

        try
        {
            hdnPrPriceIdSer.Value = "";
            DataAccess     objDataAcc = new DataAccess();
            DataSet        ds         = new DataSet();
            SqlParameter[] param      = new SqlParameter[] {
                new SqlParameter("@affiliateId", Convert.ToInt64(AffiliateID)),
                new SqlParameter("@type", "S")
            };
            ds = objDataAcc.getDataSetQuery("Affiliate_IUD", param, CommandType.StoredProcedure);

            if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
            {
                if (ds.Tables[0].Rows[0]["AffActiveFlag"] != null && Convert.ToBoolean(ds.Tables[0].Rows[0]["AffActiveFlag"]))
                {
                    OrderID.SetAffId(AffiliateID);
                    hdnPrPriceIdSer.Value = ds.Tables[0].Rows[0]["prodPricseID"].ToString();
                    ChkFlag = true;
                }
            }
        }
        catch (Exception)
        {
            ChkFlag = false;
        }

        if (!ChkFlag)
        {
            Response.Redirect("~/", true);
            //Response.Redirect("~/BuyProduct/viewcart.aspx", true);
        }
    }