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