public ActionResult TopTenSale(int option)
{
var status = "";
if (Authenticated)
{
try
{
// with Sp
var data = db.GetTop10MostSellingItems(option);
//With Methode
//var LastMonth = DateTime.Now.Date.AddMonths(-1);
//var LastWeek = DateTime.Now.Date.AddDays(-7);
//var Todaydate = DateTime.Now.Date;
//var TomorrowDate = DateTime.Now.Date.AddDays(1);
//var ToDate = TomorrowDate;
//var FromDate = TomorrowDate;
//if (option == 0)
//{
// FromDate = Todaydate;
//}
//else if (option == 1)
//{
// FromDate = LastWeek;
//}
//else if (option == 2)
//{
// FromDate = LastMonth;
//}
//else
//{
// status = "Invalid Entry";
//}
//var obj = db.SaleDetails.Where(x => x.CreatedOn > FromDate && x.CreatedOn < ToDate).GroupBy(x => x.ItemId).Select(x => x.Select(s => new { ItemId = s.ItemId, TotalQty = x.Sum(sUm => sUm.Qty) }).FirstOrDefault()).OrderByDescending(x => x.TotalQty).Take(10);
status = JsonConvert.SerializeObject(data);
}
catch (Exception ex)
{
ApplicationExceptionLogging(ex.Message, ex.StackTrace, " AdminDashboard", "TopTenSale");
}
}
return(Content(status));
}
