private void FillCountryList()
{
var fields = new string[] { "CountryCode", "CountryName" };
var pattern = "{0} - {1}";
var orderby = new string[] { "CountryCode" };
CountryEx.LoadCombo(ref cboCountry, fields, pattern, true, true, "", "", orderby);
}
private void FillCountryName()
{
var sql = (_Filter_CountryId != Guid.Empty) ?
String.Format("CountryId = '{0}'", _Filter_CountryId.ToString()) :
"";
CountryEx.LoadCombo(ref cboCountry, "CountryName", true, true, "", sql);
}
private void FillCountry()
{
var textFields = new string[] { "CountryCode", "CountryName" };
var pattern = "{0} - {1}";
var sql = "";
var orderBy = new string[] { "CountryCode" };
CountryEx.LoadCombo(ref cmbCountry, textFields, pattern, true, true, "", sql, orderBy);
cmbProvince.DataSource = null;
cmbProvince.Items.Clear();
cmbCity.DataSource = null;
cmbCity.Items.Clear();
}
private void LoadData()
{
using (var ctx = new EF6.RT2020Entities())
{
var currency = ctx.Currency.Find(_CurrencyId);
if (currency != null)
{
var countryId = CountryEx.GetCountryIdByCode(currency.CountryName);
txtCurrencyCode.Text = currency.CurrencyCode;
txtCurrencyName.Text = currency.CurrencyName;
cboCountryName.SelectedValue = countryId != Guid.Empty ? countryId : Guid.Empty;
txtUnicodeDecimal.Text = currency.UnicodeDecimal.ToString();
txtExchangeRate.Text = currency.ExchangeRate == null ? "" : currency.ExchangeRate?.ToString("n4");
ShowSymbol();
SetCtrlEditable();
SetToolBar();
}
}
}
private void Save(MemberTemplate member)
{
using (var ctx = new EF6.RT2020Entities())
{
using (var scope = ctx.Database.BeginTransaction())
{
try
{
#region save member core data
var oMember = ctx.Member.Where(x => x.MemberNumber == member.VIPNO).FirstOrDefault();
if (oMember == null)
{
oMember = new EF6.Member();
oMember.MemberId = Guid.NewGuid();
oMember.MemberNumber = member.VIPNO;
oMember.CreatedBy = ConfigHelper.CurrentUserId;
oMember.CreatedOn = DateTime.Now;
ctx.Member.Add(oMember);
}
oMember.WorkplaceId = System.Guid.Empty;
oMember.ClassId = MemberClassEx.GetIdByCode(member.PHONEBOOK);
oMember.GroupId = MemberGroupEx.GetIdByCode(member.GROUP);
oMember.MemberInitial = member.NNAME;
oMember.SalutationId = SalutationEx.GetIdByCode(member.SALUTE);
oMember.FirstName = member.FNAME;
oMember.LastName = member.LNAME;
oMember.FullName = member.LNAME + ", " + member.FNAME;
oMember.FullName_Chs = member.CNAME;
oMember.FullName_Cht = member.CNAME;
oMember.JobTitleId = JobTitleEx.GetJobTitleIdByName(member.TITLE);
oMember.AssignedTo = System.Guid.Empty;
oMember.Remarks = member.REMARKS;
oMember.NormalDiscount = member.NRDISC;
oMember.Status = Convert.ToInt32(EnumHelper.Status.Active.ToString("d"));
oMember.ModifiedBy = ConfigHelper.CurrentUserId;
oMember.ModifiedOn = DateTime.Now;
ctx.SaveChanges();
#endregion
var memberId = oMember.MemberId;
#region SaveSmartTag(oMember.MemberId, member);
var tagId = Guid.Empty;
string sql = "MemberId = '" + memberId.ToString() + "' AND TagId = '{0}'";
#region Grade
tagId = GetSmartTagId("1");
var oGradeTag = ctx.MemberSmartTag.Where(x => x.MemberId == memberId && x.TagId == tagId).FirstOrDefault();
if (oGradeTag == null)
{
oGradeTag = new EF6.MemberSmartTag();
oGradeTag.SmartTagId = Guid.NewGuid();
oGradeTag.MemberId = memberId;
oGradeTag.TagId = tagId;
ctx.MemberSmartTag.Add(oGradeTag);
}
oGradeTag.SmartTagValue = member.GRADE;
#endregion
#region Sex
tagId = GetSmartTagId("2");
var oSexTag = ctx.MemberSmartTag.Where(x => x.MemberId == memberId && x.TagId == tagId).FirstOrDefault();
if (oSexTag == null)
{
oSexTag = new EF6.MemberSmartTag();
oGradeTag.SmartTagId = Guid.NewGuid();
oSexTag.MemberId = memberId;
oSexTag.TagId = tagId;
ctx.MemberSmartTag.Add(oGradeTag);
}
oSexTag.SmartTagValue = member.SEX;
#endregion
#region Race
tagId = GetSmartTagId("3");
var oRaceTag = ctx.MemberSmartTag.Where(x => x.MemberId == memberId && x.TagId == tagId).FirstOrDefault();
if (oRaceTag == null)
{
oRaceTag = new EF6.MemberSmartTag();
oGradeTag.SmartTagId = Guid.NewGuid();
oRaceTag.MemberId = memberId;
oRaceTag.TagId = tagId;
ctx.MemberSmartTag.Add(oGradeTag);
}
oRaceTag.SmartTagValue = member.RACE;
#endregion
#region AgeGroup
tagId = GetSmartTagId("4");
var oAgeGroupTag = ctx.MemberSmartTag.Where(x => x.MemberId == memberId && x.TagId == tagId).FirstOrDefault();
if (oAgeGroupTag == null)
{
oAgeGroupTag = new EF6.MemberSmartTag();
oGradeTag.SmartTagId = Guid.NewGuid();
oAgeGroupTag.MemberId = memberId;
oAgeGroupTag.TagId = tagId;
ctx.MemberSmartTag.Add(oGradeTag);
}
oAgeGroupTag.SmartTagValue = member.AGE_GROUP;
#endregion
#region CodeCardNumber
tagId = GetSmartTagId("5");
var oCodeCardNumberTag = ctx.MemberSmartTag.Where(x => x.MemberId == memberId && x.TagId == tagId).FirstOrDefault();
if (oCodeCardNumberTag == null)
{
oCodeCardNumberTag = new EF6.MemberSmartTag();
oGradeTag.SmartTagId = Guid.NewGuid();
oCodeCardNumberTag.MemberId = memberId;
oCodeCardNumberTag.TagId = tagId;
ctx.MemberSmartTag.Add(oGradeTag);
}
oCodeCardNumberTag.SmartTagValue = member.CODENUM;
#endregion
#region LoyaltyNumber
tagId = GetSmartTagId("6");
var oLoyaltyNumberTag = ctx.MemberSmartTag.Where(x => x.MemberId == memberId && x.TagId == tagId).FirstOrDefault();
if (oLoyaltyNumberTag == null)
{
oLoyaltyNumberTag = new EF6.MemberSmartTag();
oGradeTag.SmartTagId = Guid.NewGuid();
oLoyaltyNumberTag.MemberId = memberId;
oLoyaltyNumberTag.TagId = tagId;
ctx.MemberSmartTag.Add(oGradeTag);
}
oLoyaltyNumberTag.SmartTagValue = member.LOYALTYNUM;
#endregion
#region Profile
tagId = GetSmartTagId("7");
var oProfileTag = ctx.MemberSmartTag.Where(x => x.MemberId == memberId && x.TagId == tagId).FirstOrDefault();
if (oProfileTag == null)
{
oProfileTag = new EF6.MemberSmartTag();
oGradeTag.SmartTagId = Guid.NewGuid();
oProfileTag.MemberId = memberId;
oProfileTag.TagId = tagId;
ctx.MemberSmartTag.Add(oGradeTag);
}
oProfileTag.SmartTagValue = member.PROFILE;
#endregion
#region DateOfBirth
tagId = GetSmartTagId("8");
var oDateOfBirthTag = ctx.MemberSmartTag.Where(x => x.MemberId == memberId && x.TagId == tagId).FirstOrDefault();
if (oDateOfBirthTag == null)
{
oDateOfBirthTag = new EF6.MemberSmartTag();
oGradeTag.SmartTagId = Guid.NewGuid();
oDateOfBirthTag.MemberId = memberId;
oDateOfBirthTag.TagId = tagId;
ctx.MemberSmartTag.Add(oGradeTag);
}
oDateOfBirthTag.SmartTagValue = DateTimeHelper.DateTimeToString(member.DATE_BIRTH, false);
#endregion
#region DateOfRegister
tagId = GetSmartTagId("9");
var oDateOfRegisterTag = ctx.MemberSmartTag.Where(x => x.MemberId == memberId && x.TagId == tagId).FirstOrDefault();
if (oDateOfRegisterTag == null)
{
oDateOfRegisterTag = new EF6.MemberSmartTag();
oGradeTag.SmartTagId = Guid.NewGuid();
oDateOfRegisterTag.MemberId = memberId;
oDateOfRegisterTag.TagId = tagId;
ctx.MemberSmartTag.Add(oGradeTag);
}
oDateOfRegisterTag.SmartTagValue = DateTimeHelper.DateTimeToString(member.DATE_REGIS, false);
#endregion
#region HKID
tagId = GetSmartTagId("10");
var oHKIDTag = ctx.MemberSmartTag.Where(x => x.MemberId == memberId && x.TagId == tagId).FirstOrDefault();
if (oHKIDTag == null)
{
oHKIDTag = new EF6.MemberSmartTag();
oGradeTag.SmartTagId = Guid.NewGuid();
oHKIDTag.MemberId = memberId;
oHKIDTag.TagId = tagId;
ctx.MemberSmartTag.Add(oGradeTag);
}
oHKIDTag.SmartTagValue = member.ID_NO;
#endregion
#region Nationality
tagId = GetSmartTagId("11");
var oNationalityTag = ctx.MemberSmartTag.Where(x => x.MemberId == memberId && x.TagId == tagId).FirstOrDefault();
if (oNationalityTag == null)
{
oNationalityTag = new EF6.MemberSmartTag();
oGradeTag.SmartTagId = Guid.NewGuid();
oNationalityTag.MemberId = memberId;
oNationalityTag.TagId = tagId;
ctx.MemberSmartTag.Add(oGradeTag);
}
oNationalityTag.SmartTagValue = member.NATION;
#endregion
#region Email
tagId = GetSmartTagId("12");
var oEmailTag = ctx.MemberSmartTag.Where(x => x.MemberId == memberId && x.TagId == tagId).FirstOrDefault();
if (oEmailTag == null)
{
oEmailTag = new EF6.MemberSmartTag();
oGradeTag.SmartTagId = Guid.NewGuid();
oEmailTag.MemberId = memberId;
oEmailTag.TagId = tagId;
ctx.MemberSmartTag.Add(oGradeTag);
}
oEmailTag.SmartTagValue = member.EMAIL;
#endregion
#region Company
tagId = GetSmartTagId("13");
var oCompanyTag = ctx.MemberSmartTag.Where(x => x.MemberId == memberId && x.TagId == tagId).FirstOrDefault();
if (oCompanyTag == null)
{
oCompanyTag = new EF6.MemberSmartTag();
oGradeTag.SmartTagId = Guid.NewGuid();
oCompanyTag.MemberId = memberId;
oCompanyTag.TagId = tagId;
ctx.MemberSmartTag.Add(oGradeTag);
}
oCompanyTag.SmartTagValue = member.COMPNAME;
#endregion
#region CompanyName_Ch
tagId = GetSmartTagId("14");
var oCompanyName_ChTag = ctx.MemberSmartTag.Where(x => x.MemberId == memberId && x.TagId == tagId).FirstOrDefault();
if (oCompanyName_ChTag == null)
{
oCompanyName_ChTag = new EF6.MemberSmartTag();
oGradeTag.SmartTagId = Guid.NewGuid();
oCompanyName_ChTag.MemberId = memberId;
oCompanyName_ChTag.TagId = tagId;
ctx.MemberSmartTag.Add(oGradeTag);
}
oCompanyName_ChTag.SmartTagValue = member.COMPNAMEC;
#endregion
ctx.SaveChanges();
#endregion
#region SaveAddress(oMember.MemberId, member);
//string sql = "MemberId = '" + memberId.ToString() + "' AND AddressTypeId = '" + GetAddressTypeId().ToString() + "'";
var addressTypeId = GetAddressTypeId();
var oAddress = ctx.MemberAddress.Where(x => x.MemberId == memberId && x.AddressTypeId == addressTypeId).FirstOrDefault();
if (oAddress == null)
{
oAddress = new EF6.MemberAddress();
oAddress.AddressId = Guid.NewGuid();
oAddress.MemberId = memberId;
oAddress.AddressTypeId = GetAddressTypeId();
ctx.MemberAddress.Add(oAddress);
}
oAddress.Address = member.ADDRESS4;
oAddress.PostalCode = string.Empty;
oAddress.CountryId = CountryEx.GetCountryIdByName(member.ADDRESS1);
oAddress.ProvinceId = ProvinceEx.GetProvinceIdByName(member.ADDRESS2);
oAddress.CityId = GetCityId(member.ADDRESS3);
oAddress.District = string.Empty;
oAddress.Mailing = true;
oAddress.PhoneTag1 = PhoneTagEx.GetPhoneTagIdByPriority(1);
oAddress.PhoneTag1Value = member.TELW;
oAddress.PhoneTag2 = PhoneTagEx.GetPhoneTagIdByPriority(2);
oAddress.PhoneTag2Value = member.TELH;
oAddress.PhoneTag3 = PhoneTagEx.GetPhoneTagIdByPriority(3);
oAddress.PhoneTag3Value = member.FAX;
oAddress.PhoneTag4 = PhoneTagEx.GetPhoneTagIdByPriority(4);
oAddress.PhoneTag4Value = member.TELOTHER;
ctx.SaveChanges();
#endregion
#region SaveVipData(oMember.MemberId, member);
//string sql = "MemberId = '" + memberId.ToString() + "'";
var oVip = ctx.MemberVipData.Where(x => x.MemberId == memberId).FirstOrDefault();
if (oVip == null)
{
oVip = new EF6.MemberVipData();
oVip.MemberVipId = Guid.NewGuid();
oVip.MemberId = memberId;
oVip.VipNumber = member.VIPNO;
ctx.MemberVipData.Add(oVip);
}
oVip.FORMER_PPNO = member.FORMER_PPNO;
oVip.CARD_ACTIVE = (string.IsNullOrEmpty(member.CARD_ACTIVE)) ? false : Convert.ToBoolean(member.CARD_ACTIVE);
oVip.CARD_RECEIVE = (string.IsNullOrEmpty(member.CARD_RECEIVE)) ? false : Convert.ToBoolean(member.CARD_RECEIVE);
oVip.CARD_NAME = member.CARD_NAME;
oVip.CARD_EXPIRE = member.CARD_EXPIRE;
oVip.CARD_ISSUE = member.CARD_ISSUE;
/**
* oVip.SetMetadata("CardInfo_CommencementDate", member.DATE_COMM.ToString("yyyy-MM-dd HH:mm:ss"));
* oVip.SetMetadata("CardInfo_MigrationDate", member.DATE_MIGRATE.ToString("yyyy-MM-dd HH:mm:ss"));
*
* // Others Info
* oVip.SetMetadata("OthersInfo_CreditLimit", member.ACREDIT.ToString());
* oVip.SetMetadata("OthersInfo_CreditTerms", member.TERMS);
* oVip.SetMetadata("OthersInfo_PaymentDiscount", member.PYDISC.ToString());
* oVip.SetMetadata("OthersInfo_CustomerInfo_1", member.CUSTNUM);
* oVip.SetMetadata("OthersInfo_CustomerInfo_2", member.BRANCH);
* oVip.SetMetadata("OthersInfo_PromotionDiscount", member.PRO_DISC.ToString());
* oVip.SetMetadata("OthersInfo_AddOnDiscount", member.BADDONDISC);
* oVip.SetMetadata("OthersInfo_StaffQuota", member.STAFF_QUOTA.ToString());
* oVip.SetMetadata("OthersInfo_Remarks1", member.R1);
* oVip.SetMetadata("OthersInfo_Remarks2", member.R2);
* oVip.SetMetadata("OthersInfo_Remarks3", member.R3);
* oVip.SetMetadata("OthersInfo_Nature", member.NATURE);
*
* oVip.SetMetadata("OthersInfo_Age", member.AGE);
* oVip.SetMetadata("OthersInfo_DL_Flag", member.DLFLAG);
* oVip.SetMetadata("OthersInfo_LOOCode", member.LOOID);
* oVip.SetMetadata("OthersInfo_AmountPurchased", member.ATDAMTPUR.ToString());
* oVip.SetMetadata("OthersInfo_AmountPaied", member.ATDAMTPAY.ToString());
* oVip.SetMetadata("OthersInfo_AmountReturned", member.ATDAMTRET.ToString());
* oVip.SetMetadata("OthersInfo_AmountDiscounted", member.ATDAMTDIS.ToString());
* oVip.SetMetadata("OthersInfo_Memo", member.MEMO);
*
* // Marketing Info
* oVip.SetMetadata("MarketingInfo_MostVisitedMalls_1", member.MALL1);
* oVip.SetMetadata("MarketingInfo_MostVisitedMalls_2", member.MALL2);
* oVip.SetMetadata("MarketingInfo_MostVisitedMalls_3", member.MALL3);
*
* oVip.SetMetadata("MarketingInfo_MostBoughtBrands_1", member.BRAND1);
* oVip.SetMetadata("MarketingInfo_MostBoughtBrands_2", member.BRAND2);
* oVip.SetMetadata("MarketingInfo_MostBoughtBrands_3", member.BRAND3);
*
* oVip.SetMetadata("MarketingInfo_MostReadMagazine_1", member.MAGAZINE1);
* oVip.SetMetadata("MarketingInfo_MostReadMagazine_2", member.MAGAZINE2);
* oVip.SetMetadata("MarketingInfo_MostReadMagazine_3", member.MAGAZINE3);
*
* oVip.SetMetadata("MarketingInfo_MostUsedCreditCards_1", member.CARD1);
* oVip.SetMetadata("MarketingInfo_MostUsedCreditCards_2", member.CARD2);
* oVip.SetMetadata("MarketingInfo_MostUsedCreditCards_3", member.CARD3);
*
* // Photo
* oVip.SetMetadata("MiscInfo_Photo", member.PHOTO);
*
* // Contact
* oVip.SetMetadata("Address_Phone_Pager", member.TELP);
* oVip.SetMetadata("Address_Chinese_1", member.ADDRESS1C);
* oVip.SetMetadata("Address_Chinese_2", member.ADDRESS2C);
* oVip.SetMetadata("Address_Chinese_3", member.ADDRESS3C);
* oVip.SetMetadata("Address_Chinese_4", member.ADDRESS4C);
*/
ctx.SaveChanges();
#endregion
scope.Commit();
}
catch (Exception ex)
{
scope.Rollback();
}
}
}
}
private bool Save()
{
bool result = false;
using (var ctx = new EF6.RT2020Entities())
{
var currency = ctx.Currency.Find(_CurrencyId);
if (currency == null)
{
currency = new EF6.Currency();
currency.CurrencyId = Guid.NewGuid();
currency.CurrencyCode = txtCurrencyCode.Text;
currency.CreatedBy = ConfigHelper.CurrentUserId;
currency.CreatedOn = DateTime.Now;
ctx.Currency.Add(currency);
}
currency.CountryName = (Guid)cboCountryName.SelectedValue != Guid.Empty ? CountryEx.GetCountryCode((Guid)cboCountryName.SelectedValue) : "";
currency.CurrencyName = txtCurrencyName.Text;
currency.UnicodeDecimal = Convert.ToInt32((txtUnicodeDecimal.Text == string.Empty) ? "0" : txtUnicodeDecimal.Text);
currency.ExchangeRate = Convert.ToDecimal((txtExchangeRate.Text == string.Empty) ? "0" : txtExchangeRate.Text);
currency.ModifiedBy = ConfigHelper.CurrentUserId;
currency.ModifiedOn = DateTime.Now;
ctx.SaveChanges();
result = true;
}
return(result);
}
