//
// GET: /Report/
public ActionResult Index()
{
var rep = new ReportModel();
rep.StartTime = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1);
rep.TimeSpan = DateTime.Now - rep.StartTime;
var orders = db.Orders.Where(o => o.CreateDate.Month == rep.StartTime.Month).ToList();
rep.OrderCount = orders.Count();
rep.Sales = orders.Sum(o => o.TotalPrice);
rep.Count = orders.Sum(o => o.TotalCount);
rep.DigitalSales = orders.Sum(o => o.TotalDigitalPrice);
rep.DigitalCount = orders.Sum(o => o.TotalDigitalCount);
rep.NewAlbum = db.Items.ToList().Where(i => i.IsAlbum && i.AddedDate.Month == rep.StartTime.Month).Count();
rep.UserCount = orders.Select(o => o.UserData).Distinct().Count();
rep.TotalPV = db.GetAllPageViewCount();
return(View(rep));
}
