/// <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();
}
