private static string AddDateRange(string dateRange) { string cmdText = " and tblOrginalTransaction.TransactionDate between #"; DateRangeList dateRangeNew = new DateRangeList(dateRange); cmdText += Convert.ToString(dateRangeNew.StartDate) + "# and #"; cmdText += Convert.ToString(dateRangeNew.EndDate) + "#"; return cmdText; }
public static decimal MonthlyAverage(decimal transactionsTotal, string dateRange) { DateRangeList dateRangeList = new DateRangeList(dateRange); int numberOfDays = dateRangeList.EndDate.Subtract(dateRangeList.StartDate).Days; decimal perDay = transactionsTotal / numberOfDays; decimal perYear = perDay * 365; decimal perMonth = perYear / 12; return Math.Round(perMonth); }