예제 #1
0
        protected void btnActivation_Click(object sender, EventArgs e)
        {
            try
            {
                UserBLL user = new UserBLL();
                if (user.varifypin((string)LumexSessionManager.Get("ActiveUserId"), txtbxUserPin.Text))
                {
                    UserAccountBLL userAccount = new UserAccountBLL();
                    StakeInfoBLL stakeInfo = new StakeInfoBLL();
                    MailContactBLL mailContactBll = new MailContactBLL();
                    UserBLL userBll = new UserBLL();
                    bool status = userAccount.UpdateUserAccount((string)LumexSessionManager.Get("ActiveUserId"),
                        ddlStakeList.SelectedValue, txtbxStakeKey.Text.Trim());

                    if (status)
                    {
                        if (hdnfldRefActive.Value == "No")
                        {
                            ReceivePaymentWhenActive();
                            genologyBLL genology = new genologyBLL();
                            genology.GenerateBinaryNodeByChileId((string) LumexSessionManager.Get("ActiveUserId"),userAccount.Amount);
                        }
                        string message = " <span class='actionTopic'> Your Account is Activated successfully. Thanks" + "</span>.";
                        MyAlertBox(
                            "var callbackOk = function () { window.location = \"/a/initialdata/initialDataElement.aspx\"; }; SuccessAlert(\"" +
                            "Process Succeed" + "\", \"" + message + "\", \"\");");
                    }
                    else
                    {

                    }
                    DataTable dt = stakeInfo.GetStakeInfoById(ddlStakeList.SelectedValue);
                    string body = PopulateBody(dt);
                    dt = userBll.GetUserInfoById((string) LumexSessionManager.Get("ActiveUserId"));
                    mailContactBll.SendHtmlFormattedEmail(dt.Rows[0]["Email"].ToString(), "Money Receipt", body);

                }
            }
            catch (Exception)
            {

                //throw;
            }
        }
예제 #2
0
        private void findLeftRight(string UserId, out string Left, out string Right)
        {
            Left  = "";
            Right = "";
            genologyBLL genology = new genologyBLL();

            DataTable dt = genology.find(UserId);


            if (dt.Rows.Count > 1)
            {
                if (dt.Rows[0]["PlacePosition"].ToString().Trim() == "L")
                {
                    Left = dt.Rows[0]["UserId"].ToString();
                }
                else if (dt.Rows[0]["PlacePosition"].ToString().Trim() == "R")
                {
                    Right = dt.Rows[0]["UserId"].ToString();;
                }

                if (dt.Rows[1]["PlacePosition"].ToString().Trim() == "L")
                {
                    Left = dt.Rows[1]["UserId"].ToString();
                }
                else if (dt.Rows[1]["PlacePosition"].ToString().Trim() == "R")
                {
                    Right = dt.Rows[1]["UserId"].ToString();;
                }
            }
            else if (dt.Rows.Count == 1)
            {
                if (dt.Rows[0]["PlacePosition"].ToString() == "L")
                {
                    Left = dt.Rows[0]["UserId"].ToString();
                }
                if (dt.Rows[0]["PlacePosition"].ToString() == "R")
                {
                    Right = dt.Rows[0]["UserId"].ToString();
                }
            }
        }
예제 #3
0
        protected void dailyBonusGenerateButton_Click(object sender, EventArgs e)
        {
            try
            {
                UserAccountBLL accountBll = new UserAccountBLL();
                genologyBLL genology = new genologyBLL();

                bool status = genology.generateBainaryMatchData();
                DataTable dt = genology.getNodeList();

                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    decimal LeftAmount = 0;
                    decimal RightAmount = 0;

                    genology.getNodeLeftRightAmount(dt.Rows[i]["NodeID"].ToString(), out LeftAmount, out RightAmount);
                    if (LeftAmount > 0 || RightAmount > 0)
                    {
                        genology.CalculateMatchingCommission(dt.Rows[i]["NodeID"].ToString(), LeftAmount, RightAmount);
                    }
                }
                string message = "Matching Commission  <span class='actionTopic'>Calculate</span> Successfully Done. Thanks.";
                MyAlertBox("var callbackOk = function () { MyOverlayStart(); window.location = \"/a/account/withdraw.aspx\"; }; SuccessAlert(\"" +
                    "Process Succeed" + "\", \"" + message + "\", \"\");");

            }
            catch (Exception ex)
            {
                string message = ex.Message;
                if (ex.InnerException != null) { message += " --> " + ex.InnerException.Message; }
                MyAlertBox("ErrorAlert(\"" + ex.GetType() + "\", \"" + message + "\", \"\");");
            }
            finally
            {
                MyAlertBox("MyOverlayStop();");
            }
        }
예제 #4
0
        private void findLeftRight(string UserId, out string Left, out string Right)
        {
            Left = "";
            Right = "";
            genologyBLL genology = new genologyBLL();

            DataTable dt = genology.find(UserId);

            if (dt.Rows.Count > 1)
            {
                if (dt.Rows[0]["PlacePosition"].ToString().Trim() == "L")
                {
                    Left = dt.Rows[0]["UserId"].ToString();
                }
                else if (dt.Rows[0]["PlacePosition"].ToString().Trim() == "R")
                {
                    Right = dt.Rows[0]["UserId"].ToString(); ;
                }

                if (dt.Rows[1]["PlacePosition"].ToString().Trim() == "L")
                {
                    Left = dt.Rows[1]["UserId"].ToString();
                }
                else if (dt.Rows[1]["PlacePosition"].ToString().Trim() == "R")
                {
                    Right = dt.Rows[1]["UserId"].ToString(); ;
                }
            }
            else if (dt.Rows.Count == 1)
            {
                if (dt.Rows[0]["PlacePosition"].ToString() == "L")
                {
                    Left = dt.Rows[0]["UserId"].ToString();
                }
                if (dt.Rows[0]["PlacePosition"].ToString() == "R")
                {
                    Right = dt.Rows[0]["UserId"].ToString();
                }
            }
        }
예제 #5
0
        private void searchDownLink(string MainUser, string SearchUser)
        {
            try
            {
                genologyBLL genology = new genologyBLL();
                DataTable dt = genology.getStakeJoiningList();
                viststack.Push(MainUser);
                bool status = getChildNode(dt);
                if (status)
                {
                    DrawTree(txtbxUserId.Text);
                }
                else
                {

                    string message =
                          "Please <span class='actionTopic'>Correct User ID or Your Downlink User ID </span>";
                    MyAlertBox(
                        "var callbackOk = function () { MyOverlayStart(); window.location = \"/a/account/withdraw.aspx\"; }; WarningAlert(\"" +
                        "Warning!!" + "\", \"" + message + "\", \"\");");
                }
                // Current = MainUser;
            }
            catch (Exception)
            {

                throw;
            }
        }
예제 #6
0
        private void DrawTree(string UserId)
        {
            try
            {
                DataTable userD = new DataTable();
                DataTable dt = new DataTable();
                genologyBLL genology = new genologyBLL();
                UserBLL userBll = new UserBLL();
                string UserName = "";
                string UserShowinfo = "";
                userD = userBll.GetUserInfoById(UserId);
                if (userD.Rows.Count != 0)
                {
                    btnlbl1.Text = UserId;
                    UserName = "******" + userD.Rows[0]["FirstName"].ToString() + " " + userD.Rows[0]["LastName"].ToString();
                    UserShowinfo = "Cell:" + userD.Rows[0]["MobileNo"].ToString() + "\n\rEmail: " +
                                             userD.Rows[0]["Email"].ToString() + "\n\rInvest Amount($): " + userD.Rows[0]["Insvest"].ToString() + "\n\rTotal Left($): " + userD.Rows[0]["TotalLeft"].ToString() + "\n\rTotal Right($): " + userD.Rows[0]["TotalRight"].ToString() + "\n\rCarry($): " + userD.Rows[0]["CarryForward"].ToString() + "[" + userD.Rows[0]["CarrySite"].ToString() + "]";

                    lbl1.Attributes.Add("data-content", UserShowinfo);
                    lbl1.Attributes.Add("data-title", UserName);

                    if (userD.Rows[0]["IsActive"].ToString() == "No")
                    {
                        lbl1.Attributes.Add("class", "btn btn-danger popover1");
                    }
                    else if (userD.Rows[0]["IsActive"].ToString() == "Yes")
                    {
                        lbl1.Attributes.Add("class", "btn btn-primary popover1");
                    }

                }

                initializeTree();
                find(btnlbl1.Text, out L, out R);
                string l2 = L.ToString();
                string r3 = R.ToString();
                if (l2 != "")
                {
                    userD = userBll.GetUserInfoById(l2);
                    if (userD.Rows.Count != 0)
                    {
                        btnlbl2L.Text = l2;
                        UserName = "******" + userD.Rows[0]["FirstName"].ToString() + " " + userD.Rows[0]["LastName"].ToString();
                        UserShowinfo = "Cell:" + userD.Rows[0]["MobileNo"].ToString() + "\nEmail: " +
                                            userD.Rows[0]["Email"].ToString() + "\nInvest Amount($): " + userD.Rows[0]["Insvest"].ToString() + "\nTotal Left($): " + userD.Rows[0]["TotalLeft"].ToString() + "\nTotal Right($): " + userD.Rows[0]["TotalRight"].ToString() + "\nCarry($): " + userD.Rows[0]["CarryForward"].ToString() + "[" + userD.Rows[0]["CarrySite"].ToString() + "]";

                        lbl2L.Attributes.Add("data-content", UserShowinfo);
                        lbl2L.Attributes.Add("data-title", UserName);
                        lbl2L.Attributes.Remove("class");
                        if (userD.Rows[0]["IsActive"].ToString() == "No")
                        {
                            lbl2L.Attributes.Add("class", "btn btn-danger popover1");
                        }
                        else if (userD.Rows[0]["IsActive"].ToString() == "Yes")
                        {
                            lbl2L.Attributes.Add("class", "btn btn-primary popover1");
                        }

                        ilbl2L.ImageUrl = "/assets/img/user.png";
                    }

                    find(l2, out L, out R);
                    string l4 = L.ToString();
                    string r5 = R.ToString();

                    if (l4 != "")
                    {
                        userD = userBll.GetUserInfoById(l4);
                        if (userD.Rows.Count != 0)
                        {
                            btnlbl21L.Text = l4;
                            UserName = "******" + userD.Rows[0]["FirstName"].ToString() + " " + userD.Rows[0]["LastName"].ToString();
                            UserShowinfo = "Cell:" + userD.Rows[0]["MobileNo"].ToString() + "\nEmail: " +
                                             userD.Rows[0]["Email"].ToString() + "\nInvest Amount($): " + userD.Rows[0]["Insvest"].ToString() + "\nTotal Left($): " + userD.Rows[0]["TotalLeft"].ToString() + "\nTotal Right($): " + userD.Rows[0]["TotalRight"].ToString() + "\nCarry($): " + userD.Rows[0]["CarryForward"].ToString() + "[" + userD.Rows[0]["CarrySite"].ToString() + "]";

                            lbl21L.Attributes.Add("data-content", UserShowinfo);
                            lbl21L.Attributes.Add("data-title", UserName);
                            lbl21L.Attributes.Remove("class");
                            if (userD.Rows[0]["IsActive"].ToString() == "No")
                            {
                                lbl21L.Attributes.Add("class", "btn btn-danger popover1");
                            }
                            else if (userD.Rows[0]["IsActive"].ToString() == "Yes")
                            {
                                lbl21L.Attributes.Add("class", "btn btn-primary popover1");
                            }
                            ilbl21L.ImageUrl = "/assets/img/user.png";

                        }
                        find(l4, out L, out R);
                        string l8 = L.ToString();
                        string r9 = R.ToString();

                        if (l8 != "")
                        {
                            userD = userBll.GetUserInfoById(l8);
                            if (userD.Rows.Count != 0)
                            {
                                btnlbl211L.Text = l8;
                                UserName = "******" + userD.Rows[0]["FirstName"].ToString() + " " + userD.Rows[0]["LastName"].ToString();
                                UserShowinfo = "Cell:" + userD.Rows[0]["MobileNo"].ToString() + "\nEmail: " +
                                             userD.Rows[0]["Email"].ToString() + "\nInvest Amount($): " + userD.Rows[0]["Insvest"].ToString() + "\nTotal Left($): " + userD.Rows[0]["TotalLeft"].ToString() + "\nTotal Right($): " + userD.Rows[0]["TotalRight"].ToString() + "\nCarry($): " + userD.Rows[0]["CarryForward"].ToString() + "[" + userD.Rows[0]["CarrySite"].ToString() + "]";

                                lbl211L.Attributes.Add("data-content", UserShowinfo);
                                lbl211L.Attributes.Add("data-title", UserName);
                                lbl211L.Attributes.Remove("class");
                                if (userD.Rows[0]["IsActive"].ToString() == "No")
                                {
                                    lbl211L.Attributes.Add("class", "btn btn-danger popover1");
                                }
                                else if (userD.Rows[0]["IsActive"].ToString() == "Yes")
                                {
                                    lbl211L.Attributes.Add("class", "btn btn-primary popover1");
                                }

                                ilbl211L.ImageUrl = "/assets/img/user.png";
                            }
                        }
                        if (r9 != "")
                        {
                            userD = userBll.GetUserInfoById(r9);
                            if (userD.Rows.Count != 0)
                            {
                                btnlbl212R.Text = r9;
                                UserName = "******" + userD.Rows[0]["FirstName"].ToString() + " " + userD.Rows[0]["LastName"].ToString();
                                UserShowinfo = "Cell:" + userD.Rows[0]["MobileNo"].ToString() + "\nEmail: " +
                                          userD.Rows[0]["Email"].ToString() + "\nInvest Amount($): " + userD.Rows[0]["Insvest"].ToString() + "\nTotal Left($): " + userD.Rows[0]["TotalLeft"].ToString() + "\nTotal Right($): " + userD.Rows[0]["TotalRight"].ToString() + "\nCarry($): " + userD.Rows[0]["CarryForward"].ToString() + "[" + userD.Rows[0]["CarrySite"].ToString() + "]";

                                lbl212R.Attributes.Add("data-content", UserShowinfo);
                                lbl212R.Attributes.Add("data-title", UserName);
                                lbl212R.Attributes.Remove("class");
                                if (userD.Rows[0]["IsActive"].ToString() == "No")
                                {
                                    lbl212R.Attributes.Add("class", "btn btn-danger popover1");
                                }
                                else if (userD.Rows[0]["IsActive"].ToString() == "Yes")
                                {
                                    lbl212R.Attributes.Add("class", "btn btn-primary popover1");
                                }

                                ilbl212R.ImageUrl = "/assets/img/user.png";
                            }
                        }
                    }
                    if (r5 != "")
                    {
                        userD = userBll.GetUserInfoById(r5);
                        if (userD.Rows.Count != 0)
                        {
                            btnlbl22R.Text = r5;
                            UserName = "******" + userD.Rows[0]["FirstName"].ToString() + " " + userD.Rows[0]["LastName"].ToString();
                            UserShowinfo = "Cell:" + userD.Rows[0]["MobileNo"].ToString() + "\nEmail: " +
                                          userD.Rows[0]["Email"].ToString() + "\nInvest Amount($): " + userD.Rows[0]["Insvest"].ToString() + "\nTotal Left($): " + userD.Rows[0]["TotalLeft"].ToString() + "\nTotal Right($): " + userD.Rows[0]["TotalRight"].ToString() + "\nCarry($): " + userD.Rows[0]["CarryForward"].ToString() + "[" + userD.Rows[0]["CarrySite"].ToString() + "]";

                            lbl22R.Attributes.Add("data-content", UserShowinfo);
                            lbl22R.Attributes.Add("data-title", UserName);
                            lbl22R.Attributes.Remove("class");
                            if (userD.Rows[0]["IsActive"].ToString() == "No")
                            {
                                lbl22R.Attributes.Add("class", "btn btn-danger popover1");
                            }
                            else if (userD.Rows[0]["IsActive"].ToString() == "Yes")
                            {
                                lbl22R.Attributes.Add("class", "btn btn-primary popover1");
                            }
                            ilbl22R.ImageUrl = "/assets/img/user.png";

                        }
                        find(r5, out L, out R);
                        string l10 = L.ToString();
                        string r11 = R.ToString();

                        if (l10 != "")
                        {
                            userD = userBll.GetUserInfoById(l10);
                            if (userD.Rows.Count != 0)
                            {
                                btnlbl221L.Text = l10;
                                UserName = "******" + userD.Rows[0]["FirstName"].ToString() + " " + userD.Rows[0]["LastName"].ToString();
                                UserShowinfo = "Cell:" + userD.Rows[0]["MobileNo"].ToString() + "\nEmail: " +
                                            userD.Rows[0]["Email"].ToString() + "\nInvest Amount($): " + userD.Rows[0]["Insvest"].ToString() + "\nTotal Left($): " + userD.Rows[0]["TotalLeft"].ToString() + "\nTotal Right($): " + userD.Rows[0]["TotalRight"].ToString() + "\nCarry($): " + userD.Rows[0]["CarryForward"].ToString() + "[" + userD.Rows[0]["CarrySite"].ToString() + "]";

                                lbl221L.Attributes.Add("data-content", UserShowinfo);
                                lbl221L.Attributes.Add("data-title", UserName);
                                lbl221L.Attributes.Remove("class");
                                if (userD.Rows[0]["IsActive"].ToString() == "No")
                                {
                                    lbl221L.Attributes.Add("class", "btn btn-danger popover1");
                                }
                                else if (userD.Rows[0]["IsActive"].ToString() == "Yes")
                                {
                                    lbl221L.Attributes.Add("class", "btn btn-primary popover1");
                                }

                                ilbl221L.ImageUrl = "/assets/img/user.png";
                            }
                        }
                        if (r11 != "")
                        {
                            userD = userBll.GetUserInfoById(r11);
                            if (userD.Rows.Count != 0)
                            {
                                btnlbl222R.Text = r11;
                                UserName = "******" + userD.Rows[0]["FirstName"].ToString() + " " + userD.Rows[0]["LastName"].ToString();
                                UserShowinfo = "Cell:" + userD.Rows[0]["MobileNo"].ToString() + "\nEmail: " +
                                            userD.Rows[0]["Email"].ToString() + "\nInvest Amount($): " + userD.Rows[0]["Insvest"].ToString() + "\nTotal Left($): " + userD.Rows[0]["TotalLeft"].ToString() + "\nTotal Right($): " + userD.Rows[0]["TotalRight"].ToString() + "\nCarry($): " + userD.Rows[0]["CarryForward"].ToString() + "[" + userD.Rows[0]["CarrySite"].ToString() + "]";

                                lbl222R.Attributes.Add("data-content", UserShowinfo);
                                lbl222R.Attributes.Add("data-title", UserName);
                                lbl222R.Attributes.Remove("class");
                                if (userD.Rows[0]["IsActive"].ToString() == "No")
                                {
                                    lbl222R.Attributes.Add("class", "btn btn-danger popover1");
                                }
                                else if (userD.Rows[0]["IsActive"].ToString() == "Yes")
                                {
                                    lbl222R.Attributes.Add("class", "btn btn-primary popover1");
                                }

                                ilbl222R.ImageUrl = "/assets/img/user.png";
                            }
                        }
                    }
                }
                if (r3 != "")
                {
                    userD = userBll.GetUserInfoById(r3);
                    if (userD.Rows.Count != 0)
                    {
                        btnlbl3R.Text = r3;
                        UserName = "******" + userD.Rows[0]["FirstName"].ToString() + " " + userD.Rows[0]["LastName"].ToString();
                        UserShowinfo = "Cell:" + userD.Rows[0]["MobileNo"].ToString() + "\nEmail: " +
                                          userD.Rows[0]["Email"].ToString() + "\nInvest Amount($): " + userD.Rows[0]["Insvest"].ToString() + "\nTotal Left($): " + userD.Rows[0]["TotalLeft"].ToString() + "\nTotal Right($): " + userD.Rows[0]["TotalRight"].ToString() + "\nCarry($): " + userD.Rows[0]["CarryForward"].ToString() + "[" + userD.Rows[0]["CarrySite"].ToString() + "]";

                        lbl3R.Attributes.Add("data-content", UserShowinfo);
                        lbl3R.Attributes.Add("data-title", UserName);
                        lbl3R.Attributes.Remove("class");
                        if (userD.Rows[0]["IsActive"].ToString() == "No")
                        {
                            lbl3R.Attributes.Add("class", "btn btn-danger popover1");
                        }
                        else if (userD.Rows[0]["IsActive"].ToString() == "Yes")
                        {
                            lbl3R.Attributes.Add("class", "btn btn-primary popover1");
                        }
                        ilbl3R.ImageUrl = "/assets/img/user.png";

                    }
                    find(r3, out L, out R);
                    string l6 = L.ToString();
                    string r7 = R.ToString();
                    if (l6 != "")
                    {
                        userD = userBll.GetUserInfoById(l6);
                        if (userD.Rows.Count != 0)
                        {
                            btnlbl31L.Text = l6;
                            UserName = "******" + userD.Rows[0]["FirstName"].ToString() + " " + userD.Rows[0]["LastName"].ToString();
                            UserShowinfo = "Cell:" + userD.Rows[0]["MobileNo"].ToString() + "\nEmail: " +
                                             userD.Rows[0]["Email"].ToString() + "\nInvest Amount($): " + userD.Rows[0]["Insvest"].ToString() + "\nTotal Left($): " + userD.Rows[0]["TotalLeft"].ToString() + "\nTotal Right($): " + userD.Rows[0]["TotalRight"].ToString() + "\nCarry($): " + userD.Rows[0]["CarryForward"].ToString() + "[" + userD.Rows[0]["CarrySite"].ToString() + "]";

                            lbl31L.Attributes.Add("data-content", UserShowinfo);
                            lbl31L.Attributes.Add("data-title", UserName);
                            lbl31L.Attributes.Remove("class");
                            if (userD.Rows[0]["IsActive"].ToString() == "No")
                            {
                                lbl31L.Attributes.Add("class", "btn btn-danger popover1");
                            }
                            else if (userD.Rows[0]["IsActive"].ToString() == "Yes")
                            {
                                lbl31L.Attributes.Add("class", "btn btn-primary popover1");
                            }
                            ilbl31L.ImageUrl = "/assets/img/user.png";

                        }
                        find(l6, out L, out R);
                        string l12 = L.ToString();
                        string r13 = R.ToString();
                        if (l12 != "")
                        {
                            userD = userBll.GetUserInfoById(l12);
                            if (userD.Rows.Count != 0)
                            {
                                btnlbl311L.Text = l12;
                                UserName = "******" + userD.Rows[0]["FirstName"].ToString() + " " + userD.Rows[0]["LastName"].ToString();
                                UserShowinfo = "Cell:" + userD.Rows[0]["MobileNo"].ToString() + "\nEmail: " +
                                          userD.Rows[0]["Email"].ToString() + "\nInvest Amount($): " + userD.Rows[0]["Insvest"].ToString() + "\nTotal Left($): " + userD.Rows[0]["TotalLeft"].ToString() + "\nTotal Right($): " + userD.Rows[0]["TotalRight"].ToString() + "\nCarry($): " + userD.Rows[0]["CarryForward"].ToString() + "[" + userD.Rows[0]["CarrySite"].ToString() + "]";

                                lbl311L.Attributes.Add("data-content", UserShowinfo);
                                lbl311L.Attributes.Add("data-title", UserName);
                                lbl311L.Attributes.Remove("class");
                                if (userD.Rows[0]["IsActive"].ToString() == "No")
                                {
                                    lbl311L.Attributes.Add("class", "btn btn-danger popover1");
                                }
                                else if (userD.Rows[0]["IsActive"].ToString() == "Yes")
                                {
                                    lbl311L.Attributes.Add("class", "btn btn-primary popover1");
                                }
                                ilbl311L.ImageUrl = "/assets/img/user.png";

                            }
                        }
                        if (r13 != "")
                        {
                            userD = userBll.GetUserInfoById(r13);
                            if (userD.Rows.Count != 0)
                            {
                                btnlbl312R.Text = r13;
                                UserName = "******" + userD.Rows[0]["FirstName"].ToString() + " " + userD.Rows[0]["LastName"].ToString();
                                UserShowinfo = "Cell:" + userD.Rows[0]["MobileNo"].ToString() + "\nEmail: " +
                                            userD.Rows[0]["Email"].ToString() + "\nInvest Amount($): " + userD.Rows[0]["Insvest"].ToString() + "\nTotal Left($): " + userD.Rows[0]["TotalLeft"].ToString() + "\nTotal Right($): " + userD.Rows[0]["TotalRight"].ToString() + "\nCarry($): " + userD.Rows[0]["CarryForward"].ToString() + "[" + userD.Rows[0]["CarrySite"].ToString() + "]";

                                lbl312R.Attributes.Add("data-content", UserShowinfo);
                                lbl312R.Attributes.Add("data-title", UserName);
                                lbl312R.Attributes.Remove("class");
                                if (userD.Rows[0]["IsActive"].ToString() == "No")
                                {
                                    lbl312R.Attributes.Add("class", "btn btn-danger popover1");
                                }
                                else if (userD.Rows[0]["IsActive"].ToString() == "Yes")
                                {
                                    lbl312R.Attributes.Add("class", "btn btn-primary popover1");
                                }
                                ilbl312R.ImageUrl = "/assets/img/user.png";

                            }
                        }
                    }
                    if (r7 != "")
                    {
                        userD = userBll.GetUserInfoById(r7);
                        if (userD.Rows.Count != 0)
                        {
                            btnlbl32R.Text = r7;
                            UserName = "******" + userD.Rows[0]["FirstName"].ToString() + " " + userD.Rows[0]["LastName"].ToString();
                            UserShowinfo = "Cell:" + userD.Rows[0]["MobileNo"].ToString() + "\nEmail: " +
                                          userD.Rows[0]["Email"].ToString() + "\nInvest Amount($): " + userD.Rows[0]["Insvest"].ToString() + "\nTotal Left($): " + userD.Rows[0]["TotalLeft"].ToString() + "\nTotal Right($): " + userD.Rows[0]["TotalRight"].ToString() + "\nCarry($): " + userD.Rows[0]["CarryForward"].ToString() + "[" + userD.Rows[0]["CarrySite"].ToString() + "]";

                            lbl32R.Attributes.Add("data-content", UserShowinfo);
                            lbl32R.Attributes.Add("data-title", UserName);
                            lbl32R.Attributes.Remove("class");
                            if (userD.Rows[0]["IsActive"].ToString() == "No")
                            {
                                lbl32R.Attributes.Add("class", "btn btn-danger popover1");
                            }
                            else if (userD.Rows[0]["IsActive"].ToString() == "Yes")
                            {
                                lbl32R.Attributes.Add("class", "btn btn-primary popover1");
                            }
                            ilbl32R.ImageUrl = "/assets/img/user.png";

                        }
                        find(r7, out L, out R);
                        string l14 = L.ToString();
                        string r15 = R.ToString();
                        if (l14 != "")
                        {
                            userD = userBll.GetUserInfoById(l14);
                            if (userD.Rows.Count != 0)
                            {
                                btnlbl321L.Text = l14;
                                UserName = "******" + userD.Rows[0]["FirstName"].ToString() + " " + userD.Rows[0]["LastName"].ToString();
                                UserShowinfo = "Cell:" + userD.Rows[0]["MobileNo"].ToString() + "\nEmail: " +
                                            userD.Rows[0]["Email"].ToString() + "\nInvest Amount($): " + userD.Rows[0]["Insvest"].ToString() + "\nTotal Left($): " + userD.Rows[0]["TotalLeft"].ToString() + "\nTotal Right($): " + userD.Rows[0]["TotalRight"].ToString() + "\nCarry($): " + userD.Rows[0]["CarryForward"].ToString() + "[" + userD.Rows[0]["CarrySite"].ToString() + "]";

                                lbl321L.Attributes.Add("data-content", UserShowinfo);
                                lbl321L.Attributes.Add("data-title", UserName);
                                lbl321L.Attributes.Remove("class");
                                if (userD.Rows[0]["IsActive"].ToString() == "No")
                                {
                                    lbl321L.Attributes.Add("class", "btn btn-danger popover1");
                                }
                                else if (userD.Rows[0]["IsActive"].ToString() == "Yes")
                                {
                                    lbl321L.Attributes.Add("class", "btn btn-primary popover1");
                                }

                                ilbl321L.ImageUrl = "/assets/img/user.png";
                            }
                        }
                        if (r15 != "")
                        {
                            userD = userBll.GetUserInfoById(r15);
                            if (userD.Rows.Count != 0)
                            {
                                btnlbl322R.Text = r15;
                                UserName = "******" + userD.Rows[0]["FirstName"].ToString() + " " + userD.Rows[0]["LastName"].ToString();
                                UserShowinfo = "Cell:" + userD.Rows[0]["MobileNo"].ToString() + "\nEmail: " +
                                            userD.Rows[0]["Email"].ToString() + "\nInvest Amount($): " + userD.Rows[0]["Insvest"].ToString() + "\nTotal Left($): " + userD.Rows[0]["TotalLeft"].ToString() + "\nTotal Right($): " + userD.Rows[0]["TotalRight"].ToString() + "\nCarry($): " + userD.Rows[0]["CarryForward"].ToString() + "[" + userD.Rows[0]["CarrySite"].ToString() + "]";

                                lbl322R.Attributes.Add("data-content", UserShowinfo);
                                lbl322R.Attributes.Add("data-title", UserName);
                                lbl322R.Attributes.Remove("class");
                                if (userD.Rows[0]["IsActive"].ToString() == "No")
                                {
                                    lbl322R.Attributes.Add("class", "btn btn-danger popover1");
                                }
                                else if (userD.Rows[0]["IsActive"].ToString() == "Yes")
                                {
                                    lbl322R.Attributes.Add("class", "btn btn-primary popover1");
                                }

                                ilbl322R.ImageUrl = "/assets/img/user.png";
                            }
                        }
                    }
                }
            }
            catch (Exception)
            {

                //throw;
            }
        }