Count Daily sales on dashborad

Thank you team, is working now 

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  <= endDateTime).Sum(b=>b.TotalAmount);

  return Json(new { dailyRevenue = dailyRevenue }, JsonRequestBehavior.AllowGet);
}

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

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