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