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