public LearnerPeriodStatsBoxToken GetLearnerPeriodCouponStats(AdminDashboardFiltersToken filter)
{
try
{
var reportPeriod = PeriodSelection2DateRange(filter.period);
var previousPeriod = Period2Previous(filter.period);
using (var context = new lfeAuthorEntities())
{
var totals = context.tvf_FACT_DASH_GetLearnerPeriodCouponStats(filter.currencyId, reportPeriod.from, reportPeriod.to).FirstOrDefault();
var currency = ActiveCurrencies.FirstOrDefault(x => x.CurrencyId == filter.currencyId);
if (totals == null || currency == null)
{
return(new LearnerPeriodStatsBoxToken());
}
var previousTotals = context.tvf_FACT_DASH_GetLearnerPeriodCouponStats(filter.currencyId, previousPeriod.from, previousPeriod.to).FirstOrDefault();
var couponValue = ReportEnums.eStatsTypes.LearnerCouponsClaimedValue.Type2LearnerPeriodStatsBoxToken(1, totals.TotalDiscount.FormatDecimal(2), previousTotals != null ? previousTotals.TotalDiscount.FormatDecimal(2) : 0);
couponValue.DisplayedValue = String.Format("{0}{1}", currency.Symbol, totals.TotalDiscount.FormatDecimal(2));
var box = ReportEnums.eStatsTypes.LearnerCouponsClaimed.Type2LearnerPeriodStatsBoxToken(1, totals.TotalCouponsClaimed, previousTotals != null ? previousTotals.TotalCouponsClaimed : 0, couponValue);
return(box);
}
}
catch (Exception ex)
{
Logger.Error("Get Admin Dashboard learner period coupon stats", ex, CommonEnums.LoggerObjectTypes.Reports);
return(new LearnerPeriodStatsBoxToken());
}
}
public List <SalesTotalsBoxToken> GetSalesTotals(AdminDashboardFiltersToken filter)
{
try
{
var reportPeriod = PeriodSelection2DateRange(filter.period);
var previousPeriod = Period2Previous(filter.period);
using (var context = new lfeAuthorEntities())
{
var totals = context.tvf_FACT_DASH_GetPeriodSalesTotals(filter.currencyId, reportPeriod.from, reportPeriod.to).FirstOrDefault();
if (totals == null)
{
return(new List <SalesTotalsBoxToken>());
}
var rows = context.tvf_FACT_DASH_GetPeriodSalesStats(filter.currencyId, reportPeriod.from, reportPeriod.to).FirstOrDefault();
var previousRows = context.tvf_FACT_DASH_GetPeriodSalesStats(filter.currencyId, previousPeriod.from, previousPeriod.to).FirstOrDefault();
var currency = ActiveCurrencies.FirstOrDefault(x => x.CurrencyId == filter.currencyId);
var list = new List <SalesTotalsBoxToken>
{
ReportEnums.eStatsTypes.OneTimeSales.Type2SalesTotalsBoxToken(currency, 1, totals.total_onetime_sales, rows != null ? rows.total_onetime_qty : 0, previousRows != null ? previousRows.total_onetime_qty : 0),
ReportEnums.eStatsTypes.Subscription.Type2SalesTotalsBoxToken(currency, 2, totals.total_subscription_sales, rows != null ? rows.total_subscription_qty : 0, previousRows != null ? previousRows.total_subscription_qty : 0),
ReportEnums.eStatsTypes.Rental.Type2SalesTotalsBoxToken(currency, 3, totals.total_rental_sales, rows != null ? rows.total_rental_qty : 0, previousRows != null ? previousRows.total_rental_qty : 0),
ReportEnums.eStatsTypes.Free.Type2SalesTotalsBoxToken(currency, 4, 0, rows != null ? rows.total_free_qty : 0, previousRows != null ? previousRows.total_free_qty : 0),
ReportEnums.eStatsTypes.MBG.Type2SalesTotalsBoxToken(currency, 5, 0, rows != null ? rows.total_mbg_qty : 0, previousRows != null ? previousRows.total_mbg_qty : 0)
};
return(list);
}
}
catch (Exception ex)
{
Logger.Error("Get sales totals stats for admin dashboard", ex, CommonEnums.LoggerObjectTypes.Reports);
return(new List <SalesTotalsBoxToken>());
}
}
public ActionResult LoadLearnerPeriodCouponTotals(AdminDashboardFiltersToken filter)
{
var token = _dashboardServices.GetLearnerPeriodCouponStats(filter);
return(PartialView("Dashboard/_LearnerPeriodStatsBox", token));
}
public ActionResult LoadLearnerPeriodTotals(AdminDashboardFiltersToken filter)
{
var list = _dashboardServices.GetLearnerPeriodStats(filter.period);
return(PartialView("Dashboard/_LearnerPeriodStatsRow", list));
}
public ActionResult LoadIntegrationTotals(AdminDashboardFiltersToken filter)
{
var token = _dashboardServices.GetIntegrationStatsToken(filter.period);
return(PartialView("Dashboard/_IntegrationStats", token));
}
public ActionResult LoadSalesTotals(AdminDashboardFiltersToken filter)
{
var list = _dashboardServices.GetSalesTotals(filter);
return(PartialView("Dashboard/_SalesTotals", list));
}
//public ActionResult LoadPeriodStats(ReportEnums.ePeriodSelectionKinds? period = ReportEnums.ePeriodSelectionKinds.lastMonth, short? currencyId = Constants.DEFAULT_CURRENCY_ID)
//{
// return PartialView("Dashboard/_PeriodStats", new AdminDashboardFiltersToken { period = Utils.ParseEnum<ReportEnums.ePeriodSelectionKinds>(period.ToString()), currencyId = currencyId ?? Constants.DEFAULT_CURRENCY_ID });
//}
public ActionResult LoadPlatformStats(AdminDashboardFiltersToken filter)
{
var list = _dashboardServices.GetPlatformStats(filter.period);
return(PartialView("Dashboard/_PlatformStats", list));
}
