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;
            }
        }
        protected void txtbxReferId_TextChanged(object sender, EventArgs e)
        {
            try
            {
                usernote.Attributes.Remove("data-content");
                usernote.Attributes.Remove("data-original-title");
                UserBLL userBll = new UserBLL();
                if (txtbxReferId.Text != "")
                {
                    DataTable dt = userBll.GetUserInfoById(txtbxReferId.Text);
                    if (dt.Rows.Count > 0)
                    {
                        string TransferToName = "Name:" + dt.Rows[0]["FirstName"].ToString() + " " + dt.Rows[0]["LastName"].ToString();
                        string Contactinfo = "Cell:" + dt.Rows[0]["MobileNo"].ToString() + ", Email:" +
                                             dt.Rows[0]["Email"].ToString();
                        usernote.Attributes.Add("data-content", Contactinfo);
                        usernote.Attributes.Add("data-original-title", TransferToName);
                    }
                }
            }
            catch (Exception)
            {

                throw;
            }
        }
        protected void txtbxPlacementId_TextChanged(object sender, EventArgs e)
        {
            try
            {

                Areffer.Attributes.Remove("data-content");
                Areffer.Attributes.Remove("data-original-title");
                UserBLL userBll = new UserBLL();
                if (txtbxPlacementId.Text != "")
                {
                    if (txtbxPlacementId.Text != txtbxUserName.Text)
                    {
                        DataTable dt = userBll.GetUserInfoById(txtbxPlacementId.Text);
                        if (dt.Rows.Count > 0)
                        {
                            if (userBll.checkPlacementIdValidity(dt.Rows[0]["UserId"].ToString(),
                                ddlPosition.SelectedValue))
                            {
                                txtbxPlacementId.Text = "";
                                string message = " <span class='actionTopic'>" +
                                                 " Placement Informarion is not correct!!" +
                                                 ddlPosition.SelectedItem.Text +
                                                 " Is not free of the Placement Id</span>.";
                                MyAlertBox(
                                    "var callbackOk = function () { window.location = \"/page/registration.aspx\"; }; WarningAlert(\"" +
                                    "Process Succeed" + "\", \"" + message + "\", \"\");");
                                hdnvalidplace.Value = "1";
                            }
                            else
                            {
                                string TransferToName = "Name:" + dt.Rows[0]["FirstName"].ToString() + " " +
                                                        dt.Rows[0]["LastName"].ToString();
                                string Contactinfo = "Cell:" + dt.Rows[0]["MobileNo"].ToString() + ", Email:" +
                                                     dt.Rows[0]["Email"].ToString();
                                Areffer.Attributes.Add("data-content", Contactinfo);
                                Areffer.Attributes.Add("data-original-title", TransferToName);
                                hdnvalidplace.Value = "0";

                            }
                        }
                    }
                    else
                    {
                        txtbxPlacementId.Text = "";
                        ddlPosition.SelectedIndex = 0;
                        string message = " <span class='actionTopic'>" +
                                         " Placement Informarion is not correct!!" +
                                         ddlPosition.SelectedItem.Text +
                                         " Is not free of the Placement Id</span>.";
                        MyAlertBox(
                            "var callbackOk = function () { window.location = \"/page/registration.aspx\"; }; WarningAlert(\"" +
                            "Process Succeed" + "\", \"" + message + "\", \"\");");
                        hdnvalidplace.Value = "1";
                    }
                }
            }
            catch (Exception)
            {

                //  throw;
            }
        }
        protected void UpdateUserInfo()
        {
            UserBLL aUser = new UserBLL();

            try
            {

                aUser.UserId = LumexSessionManager.Get("UserIdForUpdate").ToString();
                DataTable dt = new DataTable();
                dt = aUser.GetUserInfoById(aUser.UserId);
                hdnfldduplicate.Value = aUser.UserId;
                if (dt.Rows.Count > 0)
                {
                    txtbxUserName.Text = dt.Rows[0]["UserId"].ToString();
                    txtbxFirstName.Text = dt.Rows[0]["FirstName"].ToString();
                    txtbxLastName.Text = dt.Rows[0]["LastName"].ToString();
                    txtbxPassportNo.Text = dt.Rows[0]["PassportNo"].ToString();
                    txtbxAddress.Text = dt.Rows[0]["Address"].ToString();
                    ddlCountry.SelectedValue = dt.Rows[0]["Country"].ToString();
                    txtbxHouse.Text = dt.Rows[0]["House"].ToString();
                    txtbxStreet.Text = dt.Rows[0]["Street"].ToString();
                    txtbxArea.Text = dt.Rows[0]["Area"].ToString();
                    txtbxCell.Text = dt.Rows[0]["MobileNo"].ToString();
                    txtbxEmail.Text = dt.Rows[0]["Email"].ToString();
                    txtcontactPerson.Text = dt.Rows[0]["EmrName"].ToString();
                    txtbxContactAddress.Text = dt.Rows[0]["EmrAdress"].ToString();
                    ddlContactRelation.SelectedValue = dt.Rows[0]["RelationName"].ToString();
                    txtbxContactMobile.Text = dt.Rows[0]["EmrMobile"].ToString();
                    txtContactEmail.Text = dt.Rows[0]["EmrEmail"].ToString();
                    ddlContactCountry.SelectedValue = dt.Rows[0]["EmarCountryName"].ToString();
                    //aUser.IsActive = dt.Rows[0]["IsActive"].ToString();
                    //aUser.Isvarified = dt.Rows[0]["IsVarified"].ToString();
                    //aUser.Createdby = dt.Rows[0]["CreatedBy"].ToString();
                    //aUser.CreatedFrom = dt.Rows[0]["CreatedFrom"].ToString();
                    //aUser.UserGroupId = dt.Rows[0]["UserGroupId"].ToString();
                    //aUser.PerPhoto = dt.Rows[0]["PerPhoto"].ToString();
                }
            }
            catch (Exception)
            {

                throw;
            }
        }
        protected void btnSave_OnClick_Click(object sender, EventArgs e)
        {
            UserBLL aUser = new UserBLL();
            aUser.UserId = txtbxUserId.Text.Trim();
            aUser.MobileNo = txtbxMobileNo.Text.Trim();
            DataTable dt = new DataTable();
            dt = aUser.GetUserInfoById(aUser.UserId);
            if (dt.Rows.Count > 0)
            {
                if (txtbxMobileNo.Text == dt.Rows[0]["MobileNo"].ToString() && txtbxUserId.Text == dt.Rows[0]["UserId"].ToString())
                {
                    string email = dt.Rows[0]["Email"].ToString();
                    try
                    {
                        UserBLL userBll = new UserBLL();
                        bool status = userBll.CheckUserIdOrMailForResetPass(email);

                        //varificationSection.Visible = true;
                        //userCheckSection.Visible = false;
                        if (status)
                        {
                            Random random = new Random();

                            MailContactBLL mailContactBll = new MailContactBLL();
                            userBll.varifycode = random.Next(100000, 999998) + 1;

                            string key = dataEncryptbll.addforvarifycore;
                            string encrypeteduid = dataEncryptbll.EncryptRijndael(userBll.UserId + "#" + userBll.varifycode, key);
                            string url = HttpContext.Current.Request.Url.AbsoluteUri;
                            string[] Partsofurl = url.Split('/');
                            userBll.ActivationUrl = Server.HtmlEncode("http://" + Partsofurl[2] + "/page/varify.aspx/?uid=" + encrypeteduid);

                            bool mailSend = mailContactBll.SendEmailForPasswordReset(userBll);

                            if (mailSend)
                            {
                                string message = " <span class='actionTopic'>" + "Your mail Send Successfully. Please Cheak your Mail Inbox or Spam" + "</span>.";

                                MyAlertBox("var callbackOk = function () { window.location = \"index.aspx\"; }; SuccessAlert(\"" + "Process Succeed" + "\", \"" + message + "\", callbackOk);");

                            }
                            else
                            {
                                string message = " <span class='actionTopic'>" + "Sorry !! Mail Not Send to this User Please Check User mail or ID is Correct !!!" + "</span>.";
                                MyAlertBox("var callbackOk = function () { window.location = \"recoverpassword.aspx\"; }; SuccessAlert(\"" + "Process Succeed" + "\", \"" + message + "\", callbackOk);");
                            }

                        }
                        else
                        {
                            msgbox.Attributes.Add("Class", "alert alert-warning");
                            msgbox.Visible = true;
                            msgTitleLabel.Text = "Exception";
                            msgDetailLabel.Text = "User Id or Email is Not Correct";
                        }

                    }
                    catch (Exception ex)
                    {
                        string message = ex.Message;
                        if (ex.InnerException != null) { message += " --> " + ex.InnerException.Message; }
                        MyAlertBox("ErrorAlert(\"" + ex.GetType() + "\", \"" + message + "\", \"\");");
                    }
                }
                else
                {
                    string message = " <span class='actionTopic'>" + " Invalid Mobile Number " +
                                          "</span>.";
                    MyAlertBox(
                        "var callbackOk = function () { window.location = \"passwordrecovary.aspx\"; }; SuccessAlert(\"" +
                        "Process Succeed" + "\", \"" + message + "\", \"\");");
                }
            }
            else
            {
                string message = " <span class='actionTopic'>" + " User Id Invalid " +
                                          "</span>.";
                MyAlertBox(
                    "var callbackOk = function () { window.location = \"passwordrecovary.aspx\"; }; SuccessAlert(\"" +
                    "Process Succeed" + "\", \"" + message + "\", \"\");");
            }
        }
        private void GetUserPlacementInfoById(string UserId)
        {
            try
            {
                UserAccountBLL userAccount = new UserAccountBLL();
                DataTable dt = userAccount.GetUserPlacementInfoById(UserId);
                if (dt.Rows.Count > 0)
                {
                    if (dt.Rows[0]["StakeId"].ToString() == "")
                    {
                        txtbxPlacementId.Text = dt.Rows[0]["PleacementId"].ToString();
                        txtbxReferId.Text = dt.Rows[0]["RefferId"].ToString();
                        ddlPosition.SelectedValue = dt.Rows[0]["PlacePosition"].ToString();

                        UserBLL userBll = new UserBLL();
                        dt = userBll.GetUserInfoById(txtbxReferId.Text);
                        if (dt.Rows.Count > 0)
                        {
                            hdnfldRefActive.Value = dt.Rows[0]["IsActive"].ToString();
                        }
                    }
                    else
                    {
                        txtbxStakeKey.Enabled = false;
                        btnActivation.Enabled = false;
                        string message = " <span class='actionTopic'> Your Account is Already Activated successfully. Thanks" + "</span>.";
                        MyAlertBox(
                            "var callbackOk = function () { window.location = \"/a/initialdata/initialDataElement.aspx\"; }; SuccessAlert(\"" +
                            "Process Succeed" + "\", \"" + message + "\", \"\");");

                    }
                }
                else
                {
                    // To do job
                }

            }
            catch (Exception)
            {

                //throw;
            }
        }
        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;
            }
        }