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