/// <summary> /// Gets the draft VIP number. /// </summary> private void GetDraftVIPNumber() { string query = @"LEN(LTRIM(RTRIM(MemberInitial))) = 0 AND LEN(LTRIM(RTRIM(FirstName))) = 0 AND LEN(LTRIM(RTRIM(LastName))) = 0 AND LEN(LTRIM(RTRIM(REPLACE(FullName, ',', '')))) = 0 AND (LEN(LTRIM(RTRIM(FullName_Chs))) = 0 AND LEN(LTRIM(RTRIM(FullName_Cht))) = 0)"; RT2020.DAL.MemberCollection oMemberList = RT2020.DAL.Member.LoadCollection(query, new string[] { "MemberNumber" }, true); foreach (RT2020.DAL.Member oMember in oMemberList) { query = @"MemberId = '" + oMember.MemberId.ToString() + @"' AND LEN(LTRIM(RTRIM(PhoneTag1Value))) = 0 AND LEN(LTRIM(RTRIM(PhoneTag2Value))) = 0 AND LEN(LTRIM(RTRIM(PhoneTag3Value))) = 0 AND LEN(LTRIM(RTRIM(PhoneTag4Value))) = 0 AND LEN(LTRIM(RTRIM(PhoneTag5Value))) = 0"; MemberAddress oAddress = MemberAddress.LoadWhere(query); if (oAddress != null) { txtTempVipNumber.Text = oMember.MemberNumber; txtTempVipNumber.ForeColor = Color.Blue; break; } } }
/// <summary> /// Applies the member address. /// </summary> /// <param name="memberId">The member id.</param> private void ApplyMemberAddress(Guid memberId) { System.Guid addrTypeId = GetAddressTypeId(); string query = "MemberId = '" + memberId.ToString() + "' AND AddressTypeId = '" + addrTypeId.ToString() + "'"; MemberAddress objAddress = MemberAddress.LoadWhere(query); if (objAddress == null) { objAddress = new MemberAddress(); objAddress.MemberId = memberId; objAddress.AddressTypeId = addrTypeId; } objAddress.PhoneTag1 = GetPhoneTag(1); //Work objAddress.PhoneTag1Value = txtPhone1.Text; objAddress.PhoneTag2 = GetPhoneTag(2); //Home objAddress.PhoneTag2Value = txtPhone2.Text; objAddress.Save(); }