Count Daily sales on dashborad

Question

Hello Team,

Please I want to show daily sales on my mvc application dashboard by date, kindly assist

public JsonResult GetDashboardData()
{
ASPNETMASTERPOSTEntities db = new ASPNETMASTERPOSTEntities();
var currentDate = DateTime.Now.Date.ToString("dd-MMM-yyyy");

return Json(JsonRequestBehavior.AllowGet);
}

Vishal Joshi · Answer

Hello, Please try the below code to get the daily sales amount on the Dashboard. public JsonResult GetDashboardData() { ASPNETMASTERPOSTEntities db = new ASPNETMASTERPOSTEntities(); var currentDate = DateTime.Now.Date.ToString("dd-MMM-yyyy"); var dailyRevenue = db.tblSales.Where(a => a.OrderDate == currentDate).Sum(b=>b.TotalAmount); return Json(new { dailyRevenue = dailyRevenue }, JsonRequestBehavior.AllowGet); } Thanks Vishal Joshi

Jignesh Kumar · Answer

Hello, You can use below query to achieve this one, public JsonResult GetDashboardData() { ASPNETMASTERPOSTEntities db = new ASPNETMASTERPOSTEntities(); DateTime startDateTime = DateTime.Today; //Today at 00:00:00 DateTime endDateTime = DateTime.Today.AddDays(1).AddTicks(-1); //Today at 23:59:59 var dailyRevenue = db.tblSales.Where(a => a.OrderDate >= startDateTime && a.OrderDate b.TotalAmount); return Json(new { dailyRevenue = dailyRevenue }, JsonRequestBehavior.AllowGet); }

Emmmanuel FIADUFE · Answer

Thank you team, is working now

Emmmanuel FIADUFE · Answer

Thank you Lokesh, I did as you said but is not working

Lokesh Varman · Answer

do modify the code as per your need public JsonResult GetDashboardData() { ASPNETMASTERPOSTEntities db = new ASPNETMASTERPOSTEntities(); // Get the current date var currentDate = DateTime.Now.Date; // Query the database to get the sales data for the current date var salesData = db.YourSalesTable .Where(s => s.SaleDate.Date == currentDate) .Select(s => new { Date = s.SaleDate, Amount = s.SaleAmount }) .ToList(); // Return the data as JSON return Json(salesData, JsonRequestBehavior.AllowGet); }