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