public List <ReportByDate_Result> ReportByYear(int year)
{
var listMonth = new List <ReportByDate_Result>();
var listYear = new List <ReportByDate_Result>();
for (int i = 1; i < 13; i++)
{
var rp = new ReportByDate_Result();
listMonth = ReportByMonth(i, year);
rp.TOTAL_TICKED = listMonth.Sum(t => t.TOTAL_TICKED);
rp.TOTAL_PRICE = listMonth.Sum(t => t.TOTAL_PRICE);
listYear.Add(rp);
}
return(listYear);
}
public List <ReportByDate_Result> ReportByMonth(int month, int year)
{
ReportByDate_Result rp = new ReportByDate_Result();
var list = new List <ReportByDate_Result>();
int count = DateTime.DaysInMonth(year, month);
string date = "";
for (int i = 1; i <= count; i++)
{
if (month < 10)
{
if (i < 10)
{
date = "0" + i + "/0" + month + "/" + year;
}
else
{
date = i + "/0" + month + "/" + year;
}
rp = _database.ReportByDate(date).SingleOrDefault();
list.Add(rp);
}
else
{
if (i < 10)
{
date = "0" + i + "/" + month + "/" + year;
}
else
{
date = i + "/" + month + "/" + year;
}
rp = _database.ReportByDate(date).SingleOrDefault();
list.Add(rp);
}
}
return(list);
}
