public static string GetHtml() { var memberships = Membership.GetAll().Where(m => m.Status == MembershipStatus.Active).OrderBy(x => x.DisplayOrder); var typesWithMembership = memberships.Select(m => GetTypeSet(m)).ToList(); string headers = CreateHeaders(memberships); List <string> rows = GetRows(typesWithMembership); return("<table id=\"AdPackTypeMembershipTable\" class='table table-striped'>" + headers + "<tbody>" + string.Join("", rows) + "</tbody></table>"); }
/// <summary> /// Only for update 5009 /// </summary> public static void UpdateCommissionSystem() { var memberships = Membership.GetAll(); var levels = AppSettings.Referrals.ReferralEarningsUpToTier; foreach (var m in memberships) { for (int i = 1; i <= levels; i++) { decimal tierEarnings = 1; if (i != 1) { var intEarnings = (int)TableHelper.SelectScalar(string.Format("SELECT ReferralEarningsFromTier{0} FROM ApplicationSettings", i)); tierEarnings = ((int)TableHelper.SelectScalar(string.Format("SELECT ReferralEarningsFromTier{0} FROM ApplicationSettings", i))) / 100m; } var commission = TableHelper.GetListFromRawQuery <Commission>( string.Format("SELECT * FROM Commissions WHERE MembershipId = {0} AND RefLevel = {1}" , m.Id, i)).FirstOrDefault(); if (commission == null) { commission = new Commission() { RefLevel = i, MembershipId = m.Id, MembershipPurchasePercent = m.DirectReferralMembershipPurchaseEarnings * tierEarnings, BannerPurchasePercent = m.DirectReferralBannerPurchaseEarnings * tierEarnings, AdPackPurchasePercent = m.DirectReferralAdPackPurchaseEarnings * tierEarnings, OfferwallPercent = m.RefPercentEarningsOfferwalls * tierEarnings, CPAOfferPercent = m.RefPercentEarningsCPA * tierEarnings, TrafficGridPurchasePercent = m.DirectReferralTrafficGridPurchaseEarnings * tierEarnings, PointsForAdPackPurchasePercent = 0, AccountActivationFeePercent = 0, JackpotPvpStageBuyFeePercent = 0 }; commission.Save(); } } } }
protected override object GetDataFromSource() { var membershipsList = Membership.GetAll(); var membershipsDictionary = new Dictionary <int, int>(); foreach (var membership in membershipsList.FindAll(x => x.Status == MembershipStatus.Active)) { var sb = new StringBuilder(); sb.Append(string.Format(@"SELECT COUNT(*) FROM Users WHERE AccountStatusInt = {0} AND ReferrerId = -1 AND UserId != 1005 AND UpgradeId = {1}", (int)MemberStatus.Active, membership.Id)); if (AppSettings.DirectReferrals.DefaultReferrerEnabled) { sb.Append(string.Format(" AND UserId != {0}", AppSettings.DirectReferrals.DefaultReferrerId)); } var count = (int)TableHelper.SelectScalar(sb.ToString()); membershipsDictionary.Add(membership.Id, count); } return(membershipsDictionary); }
/// <summary> /// Should be fired each time user adds a Membership or changes max supported tiers. /// </summary> public static void UpdateCommissions() { var memberships = Membership.GetAll(); var levels = AppSettings.Referrals.ReferralEarningsUpToTier; foreach (var m in memberships) { for (int i = 1; i <= levels; i++) { var commission = TableHelper.GetListFromRawQuery <Commission>( string.Format("SELECT * FROM Commissions WHERE MembershipId = {0} AND RefLevel = {1}" , m.Id, i)).FirstOrDefault(); if (commission == null) { commission = new Commission() { RefLevel = i, MembershipId = m.Id, MembershipPurchasePercent = 0, BannerPurchasePercent = 0, AdPackPurchasePercent = 0, PointsForAdPackPurchasePercent = 0, OfferwallPercent = 0, CPAOfferPercent = 0, TrafficGridPurchasePercent = 0, VideoViewPercent = 0, CashBalanceDepositPercent = 0, InvestmentPlanPurchasePercent = 0, AccountActivationFeePercent = 0, JackpotPvpStageBuyFeePercent = 0 }; commission.Save(); } } } }