public ActionResult Details(Guid?id)
{
MembershipUser user = Membership.GetUser();
if (id == null)
{
id = ((Guid)(user.ProviderUserKey));
}
else
{
user = Membership.GetUser(id);
}
PublicMemberInfo publicMemberInfo = GetPublicMemberInfo(id, user.UserName, user.Email);
var viewModel = new OrdinaryMemberViewModel
{
PublicMemberInfo = publicMemberInfo,
};
if (IsFromLocalHost())
{
SMCHDBLocalEntities _localEntities = new SMCHDBLocalEntities();
if (_localEntities.OrdinaryMemberInfos.Any(a => a.IMemberID == id))
{
OrdinaryMemberInfo ordinaryMemberInfo = _localEntities.OrdinaryMemberInfos.Single(a => a.IMemberID == id);
viewModel.OrdinaryMemberInfo = ordinaryMemberInfo;
//var viewModel = new OrdinaryMemberViewModel
//{
// OrdinaryMemberInfo = ordinaryMemberInfo,
// PublicMemberInfo = publicMemberInfo,
//};
if (ordinaryMemberInfo.MemberFeePayByID.HasValue)
{
ViewData["PayMethodName"] = _entities.PayMethods.SingleOrDefault(a => a.ID == ordinaryMemberInfo.MemberFeePayByID).Name;
}
}
}
ViewData["IsFromLocalHost"] = IsFromLocalHost();
return(View(viewModel));
}
public ActionResult GetBirthDayFromLocalToServer()
{
//List<MemberInfo> memberInfos = _entities.MemberInfos.Where(a => a.MemberNo.HasValue &&
// a.MemberNo.Value < 999 &&
// a.MemberFeeExpiredDate.HasValue &&
// a.MemberFeeExpiredDate.Value > new DateTime(2011, 6, 1) &&
// a.MemberNo != 481 &&
// a.MemberNo != 339 &&
// a.MemberNo != 308).ToList();
//foreach (MemberInfo mi in memberInfos)
//{
// MemberFeePayment mfp = new MemberFeePayment();
// mfp.IMemberID = mi.MemberID;
// mfp.ToDate = mi.MemberFeeExpiredDate.Value;
// mfp.FromDate = mfp.ToDate.AddMonths(-6);
// mfp.PayMethodID = 1;
//}
SMCHDBLocalEntities _localEntities = new SMCHDBLocalEntities();
List <MemberInfo> memberInfo2s = _entities.MemberInfos.ToList();
List <OrdinaryMemberInfo> ordinaryMembers = _localEntities.OrdinaryMemberInfos.ToList();
foreach (OrdinaryMemberInfo omi in ordinaryMembers)
{
//if (!string.IsNullOrEmpty(omi.NRICOrFINNo) && omi.NRICOrFINNo.Substring(0, 1).ToLower() != "s")
{
MemberInfo mi = _entities.MemberInfos.SingleOrDefault(a => a.MemberID == omi.IMemberID);
//mi.PassportNo = omi.NRICOrFINNo;
mi.Remark = omi.Remark;
_entities.SaveChanges();
}
}
//SMCHSGManager.Helper.PenangAshramJob.ReadExistingExcel();
return(View());
}
