private void sbtnIntroduce_Click(object sender, EventArgs e)
        {
            strFreebiz = "";

            List<string> lstMemberID = new List<string>();
            //lstMemberID = null;

            if (ucNonMemberID1.Enabled && ucNonMemberID1.EditValue.ToString().Trim()!="")
                lstMemberID.Add(ucNonMemberID1.ToString());
            if (ucNonMemberID2.Enabled && ucNonMemberID2.EditValue.ToString().Trim() != "")
                lstMemberID.Add(ucNonMemberID2.ToString());
            if (ucNonMemberID3.Enabled && ucNonMemberID3.EditValue.ToString().Trim() != "")
                lstMemberID.Add(ucNonMemberID3.ToString());
            if (ucNonMemberID4.Enabled && ucNonMemberID4.EditValue.ToString().Trim() != "")
                lstMemberID.Add(ucNonMemberID4.ToString());
            if (ucNonMemberID5.Enabled && ucNonMemberID5.EditValue.ToString().Trim() != "")
                lstMemberID.Add(ucNonMemberID5.ToString());
            if (ucNonMemberID6.Enabled && ucNonMemberID6.EditValue.ToString().Trim() != "")
                lstMemberID.Add(ucNonMemberID6.ToString());
            if (ucNonMemberID7.Enabled && ucNonMemberID7.EditValue.ToString().Trim() != "")
                lstMemberID.Add(ucNonMemberID7.ToString());
            if (ucNonMemberID8.Enabled && ucNonMemberID8.EditValue.ToString().Trim() != "")
                lstMemberID.Add(ucNonMemberID8.ToString());
            if (ucNonMemberID9.Enabled && ucNonMemberID9.EditValue.ToString().Trim() != "")
                lstMemberID.Add(ucNonMemberID9.ToString());
            if (ucNonMemberID10.Enabled && ucNonMemberID10.EditValue.ToString().Trim() != "")
                lstMemberID.Add(ucNonMemberID10.ToString());

            TblPromotionIntroFriends IntroFriends = new TblPromotionIntroFriends();
            if (lstMemberID.Count > 0)
            {
                foreach (string s in lstMemberID)
                {
                    if (IntroFriends.CheckFriendExist(s))
                    {
                        UI.ShowErrorMessage(this, "NMC member entered already exists in database!");
                        DialogResult = DialogResult.None;
                        return;
                    }
                }
            }

            // if ((lkFreebie.Text.Length != 0) && (lkFreebie2.Text.Length != 0))
            // {
            //    UI.ShowErrorMessage(this, "Please select only one Freebiz accordingly!");
            //    lkFreebie.Focus();
            //    DialogResult = DialogResult.None;
            //    return;
            //}
            //else

             //if (lkFreebie.Text.Length != 0)
             //           {
             //               if ((ucNonMemberID1.EditValue.ToString().Length != 0) && (ucNonMemberID2.EditValue.ToString().Length != 0) && (ucNonMemberID3.EditValue.ToString().Length != 0) && (ucNonMemberID4.EditValue.ToString().Length != 0) && (ucNonMemberID5.EditValue.ToString().Length != 0))
             //               {
             //                  strFreebiz = lkFreebie.EditValue.ToString();
             //               }
             //               else
             //               {
             //                   UI.ShowErrorMessage(this, "Member has to have 5 friends to entitle 5 friends freebiz!");
             //                   lkFreebie.Focus();
             //                   DialogResult = DialogResult.None;
             //                   return;
             //               }

             //           }
             //else

             //    if (lkFreebie2.Text.Length != 0)
             //    {
             //        if ((ucNonMemberID1.EditValue.ToString().Length != 0) && (ucNonMemberID2.EditValue.ToString().Length != 0) && (ucNonMemberID3.EditValue.ToString().Length != 0) && (ucNonMemberID4.EditValue.ToString().Length != 0) && (ucNonMemberID5.EditValue.ToString().Length != 0) && (ucNonMemberID6.EditValue.ToString().Length != 0) && (ucNonMemberID7.EditValue.ToString().Length != 0) && (ucNonMemberID8.EditValue.ToString().Length != 0) && (ucNonMemberID9.EditValue.ToString().Length != 0) && (ucNonMemberID10.EditValue.ToString().Length != 0))
             //        {
             //            strFreebiz = lkFreebie2.EditValue.ToString();
             //        }
             //        else
             //        {
             //            UI.ShowErrorMessage(this, "Member has to have 10 friends to entitle 10 friends freebiz!");
             //            lkFreebie.Focus();
             //            DialogResult = DialogResult.None;
             //            return;
             //        }

             //    }

             try
            {

                    IntroFriends.StrMembershipID = strMembershipID;
                    IntroFriends.strSerialNo = txtSerialNo.Text;
                    IntroFriends.strFriendID1 = ucNonMemberID1.EditValue.ToString();
                    IntroFriends.strFriendID2 = ucNonMemberID2.EditValue.ToString();
                    IntroFriends.strFriendID3 = ucNonMemberID3.EditValue.ToString();
                    IntroFriends.strFriendID4 = ucNonMemberID4.EditValue.ToString();
                    IntroFriends.strFriendID5 = ucNonMemberID5.EditValue.ToString();
                    IntroFriends.strFriendID6 = ucNonMemberID6.EditValue.ToString();
                    IntroFriends.strFriendID7 = ucNonMemberID7.EditValue.ToString();
                    IntroFriends.strFriendID8 = ucNonMemberID8.EditValue.ToString();
                    IntroFriends.strFriendID9 = ucNonMemberID9.EditValue.ToString();
                    IntroFriends.strFriendID10 = ucNonMemberID10.EditValue.ToString();
                    IntroFriends.StrFreebieCode = strFreebiz;
                    IntroFriends.FIssued = chkIssued.Checked;
                    IntroFriends.strStaffID = employeeID;
                    IntroFriends.DtCreateDate = DateTime.Now;
                    IntroFriends.Insert();

                    MessageBox.Show("IntroFriends save successfully.");
            }
             catch (Exception ex)
             {
                 MessageBox.Show(ex.Message);
             }

             this.Close();
        }
        public frmIntroduceFriendReferral(int aEmployeeID,string CurrentMembershipID,MemberRecord aMemberRecord, ACMSLogic.User oUser, string aStrTerminalBranchCode)
        {
            //
            // Required for Windows Form Designer support
            //
            InitializeComponent();

            //
            // TODO: Add any constructor code after InitializeComponent call
            //
            myEmployeeIDLookupBuilder = new ACMS.XtraUtils.LookupEditBuilder.TherapistForPOSSalesLookupEditBuilder(lkpEdtSalesPersonID.Properties, aStrTerminalBranchCode);

            TblReceiptFreebie Freebie = new TblReceiptFreebie();
            DataTable FreebieTable = Freebie.SelectIntro5FriendFreebie();
            new XtraUtils.LookupEditBuilder.FriendPromotionLookupEditBuilder(FreebieTable, lkFreebie.Properties);

            TblReceiptFreebie Freebie2 = new TblReceiptFreebie();
            DataTable FreebieTable2 = Freebie.SelectIntro10FriendFreebie();
            new XtraUtils.LookupEditBuilder.FriendPromotionLookupEditBuilder(FreebieTable2, lkFreebie2.Properties);

            TblRewards rewards4 = new TblRewards();
            DataTable rewards4Table = rewards4.SelectRewardsForReferral(4, aStrTerminalBranchCode);
            new XtraUtils.LookupEditBuilder.LoyalPointsLookupEditBuilder(rewards4Table, ddl4Friends.Properties);

            TblRewards rewards8 = new TblRewards();
            DataTable rewards8Table = rewards8.SelectRewardsForReferral(8, aStrTerminalBranchCode);
            new XtraUtils.LookupEditBuilder.LoyalPointsLookupEditBuilder(rewards8Table, ddl8Friends.Properties);

            strMembershipID = CurrentMembershipID;
            strTerminalBranchCode = aStrTerminalBranchCode;
            employeeID = aEmployeeID;
            myMemberRecord = aMemberRecord;
            myUser = oUser;
            ucNonMemberID1.StrBranchCode = aStrTerminalBranchCode;
            ucNonMemberID2.StrBranchCode = aStrTerminalBranchCode;
            ucNonMemberID3.StrBranchCode = aStrTerminalBranchCode;
            ucNonMemberID4.StrBranchCode = aStrTerminalBranchCode;
            ucNonMemberID5.StrBranchCode = aStrTerminalBranchCode;
            ucNonMemberID6.StrBranchCode = aStrTerminalBranchCode;
            ucNonMemberID7.StrBranchCode = aStrTerminalBranchCode;
            ucNonMemberID8.StrBranchCode = aStrTerminalBranchCode;
            ucNonMemberID9.StrBranchCode = aStrTerminalBranchCode;
            ucNonMemberID10.StrBranchCode = aStrTerminalBranchCode;

            TblPromotionIntroFriends sqlPromotionIntroFriends = new TblPromotionIntroFriends();
            DataTable PromotionIntroFriends = sqlPromotionIntroFriends.SelectAllPromotionIntroFriends(strMembershipID);
            myContacts = new Contacts();

            if (PromotionIntroFriends.Rows.Count > 0)
            {
                txtSerialNo.Text = PromotionIntroFriends.Rows[0]["strSerialNo"].ToString();
                chkIssued.Checked = (PromotionIntroFriends.Rows[0]["fIssued"] == DBNull.Value || PromotionIntroFriends.Rows[0]["fIssued"].ToString() == "False" ? false : true);
                ucNonMemberID1.EditValue = PromotionIntroFriends.Rows[0]["strFriendID01"].ToString();
                ucNonMemberID1.Enabled = (ucNonMemberID1.EditValue == "");
                ucNonMemberID2.EditValue = PromotionIntroFriends.Rows[0]["strFriendID02"].ToString();
                ucNonMemberID2.Enabled = (ucNonMemberID2.EditValue == "");
                ucNonMemberID3.EditValue = PromotionIntroFriends.Rows[0]["strFriendID03"].ToString();
                ucNonMemberID3.Enabled = (ucNonMemberID3.EditValue == "");
                ucNonMemberID4.EditValue = PromotionIntroFriends.Rows[0]["strFriendID04"].ToString();
                ucNonMemberID4.Enabled = (ucNonMemberID4.EditValue == "");
                ucNonMemberID5.EditValue = PromotionIntroFriends.Rows[0]["strFriendID05"].ToString();
                ucNonMemberID5.Enabled = (ucNonMemberID5.EditValue == "");
                ucNonMemberID6.EditValue = PromotionIntroFriends.Rows[0]["strFriendID05"].ToString();
                ucNonMemberID6.Enabled = (ucNonMemberID6.EditValue == "");
                ucNonMemberID7.EditValue = PromotionIntroFriends.Rows[0]["strFriendID05"].ToString();
                ucNonMemberID7.Enabled = (ucNonMemberID7.EditValue == "");
                ucNonMemberID8.EditValue = PromotionIntroFriends.Rows[0]["strFriendID05"].ToString();
                ucNonMemberID8.Enabled = (ucNonMemberID8.EditValue == "");
                ucNonMemberID9.EditValue = PromotionIntroFriends.Rows[0]["strFriendID05"].ToString();
                ucNonMemberID9.Enabled = (ucNonMemberID9.EditValue == "");
                ucNonMemberID10.EditValue = PromotionIntroFriends.Rows[0]["strFriendID05"].ToString();
                ucNonMemberID10.Enabled = (ucNonMemberID10.EditValue == "");
                lkFreebie.EditValue = PromotionIntroFriends.Rows[0]["strFreebieCode"].ToString();
            }
            //if (ACMS.Convert.ToInt32(PromotionIntroFriends.Rows[0]["nMaxSession"]) == 9999)
              //  needtoAddBackOneDayExpiryDate = true;
            //
            //DataTable attendedClassTable = classAttendance.GetAllClassAttendancesBasePackageID(wantToUpgrade_nPackageID, pos.StrMembershipID, pos.StrBranchCode);

            //txtSerialNo.Text = "A1";
            //ucNonMemberID1.EditValue = "aa";

            ComboboxItem itemFemale = new ComboboxItem();
            itemFemale.Text = "Female";
            itemFemale.Value = "F";
            ComboboxItem itemMale = new ComboboxItem();
            itemMale.Text = "Male";
            itemMale.Value = "M";

            cbGender1.Items.Add(itemFemale);
            cbGender1.Items.Add(itemMale);
            cbGender1.SelectedIndex = 0;
            cbGender2.Items.Add(itemFemale);
            cbGender2.Items.Add(itemMale);
            cbGender2.SelectedIndex = 0;
            cbGender3.Items.Add(itemFemale);
            cbGender3.Items.Add(itemMale);
            cbGender3.SelectedIndex = 0;
            cbGender4.Items.Add(itemFemale);
            cbGender4.Items.Add(itemMale);
            cbGender4.SelectedIndex = 0;
            cbGender5.Items.Add(itemFemale);
            cbGender5.Items.Add(itemMale);
            cbGender5.SelectedIndex = 0;
            cbGender6.Items.Add(itemFemale);
            cbGender6.Items.Add(itemMale);
            cbGender6.SelectedIndex = 0;
            cbGender7.Items.Add(itemFemale);
            cbGender7.Items.Add(itemMale);
            cbGender7.SelectedIndex = 0;
            cbGender8.Items.Add(itemFemale);
            cbGender8.Items.Add(itemMale);
            cbGender8.SelectedIndex = 0;
        }