private Dictionary<int, double> GetPrepaidSalesSummaryTotalByMonth(SummaryRange startRange, SummaryRange lastRange)
{
const int reportId = 64;
const string columnName = "GrSalesTOT";
const string dateColumName = "date";
var totalsByMonth = new Dictionary<int, double>();
var startDate = Utils.GetFirst_LastDayRange(startRange).StartDate;
var endDate = Utils.GetFirst_LastDayRange(lastRange).EndDate;
var range = new DateRange
{
StartDate = startDate,
EndDate = endDate
};
var data = GetSalesSummaryData(reportId, range).ToList();
var months = GetMonthInits(range).ToList();
foreach(var month in months)
{
var currentData = data.Where(row => DateTime.Parse(row[dateColumName].ToString()).IsBetween(month));
var total = GetSalesSummaryTotal(currentData, columnName);
totalsByMonth.Add(month.Month, total);
}
return totalsByMonth;
}
private string GetRangeForSummary(SummaryRange range)
{
var monthIndex = range.Month -1 ;
var month = Enum.IsDefined(typeof (Month),monthIndex) ? ((Month)monthIndex).ToString() : string.Empty;
return month + "/" + range.Year;
}
private Dictionary<int, double> GetMerchantServicesSalesSummaryTotalByMonth(SummaryRange startRange, SummaryRange lastRange)
{
const int reportId = 49;
const string columnName = "tot_commission";
var totalsByMonth = new Dictionary<int, double>();
var startDate = Utils.GetFirst_LastDayRange(startRange).StartDate;
var endDate = Utils.GetFirst_LastDayRange(lastRange).EndDate;
var range = new DateRange
{
StartDate = startDate,
EndDate = endDate
};
var data = GetSalesSummaryData(reportId, range).ToList();
var months = GetMonthInits(range).ToList();
for (int i = 0; i < Math.Min(data.Count(),months.Count()); i++)
{
var currentData = new List<Dictionary<string, object>> { data[i] };
var total = GetSalesSummaryTotal(currentData, columnName);
totalsByMonth.Add(months[i].Month, total);
}
return totalsByMonth;
}