Monthly Sales Count

Emmmanuel FIADUFE

Hello Team,

Please I want to get sales count by month on my bar graph

// This is to get sales performance by Month on the bar graph

public JsonResult GetSalesPerformanceByType()
{
ASPNETMASTERPOSTEntities db = new ASPNETMASTERPOSTEntities();
var previousYear = (DateTime.Now.Year - 1);
var sales = db.tblSales
.Join(db.tblSalesDetails, s => s.SalesId, sd => sd.SalesId, (s, sd) => new { sale = s, saleDetail = sd })
.Join(db.tblProducts, sd => sd.saleDetail.ProductId, p => p.ProductId, (sd, p) => new { sale = sd, product = p })
.ToList();
var salesBypercentageByProduct = (from s in sales
where DateTime.Parse(s.sale.sale.OrderDate).Year > previousYear
group s by new { s.sale.saleDetail.ProductId, s.product.ProductName } into gs
select new { Name = gs.Key.ProductName }).ToArray();

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

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vishal Joshi2y ago

Accepted answer

Hello Emmanuel,

Please try the below code in you API to get the expected data to bind the chart.

public JsonResult GetSalesPerformanceByType()
{         
	ASPNETMASTERPOSTEntities db = new ASPNETMASTERPOSTEntities();
	var previousYear = (DateTime.Now.Year - 1);


	var salesByMonthAmount = (from a in sales
							  where DateTime.Parse(a.OrderDate).Year > previousYear
							  group a by DateTime.Parse(a.OrderDate).Month into g
							  select g.Sum(c => c.TotalAmount)).ToArray();

	var salesBypercentageByProduct = (from s in sales
									  where DateTime.Parse(s.sale.sale.OrderDate).Year > previousYear
									  group s by new { s.sale.saleDetail.ProductId, s.product.ProductName } into gs
									  select new { Name = gs.Key.ProductName  }).ToArray();


	return Json(new { Names = salesBypercentageByProduct Values = salesByMonthAmount }, JsonRequestBehavior.AllowGet);
}

Thanks

Vishal

Emmmanuel FIADUFE2y ago
Thank Vishal and Amit
+1

Amit Mohanty2y ago

Please try the below code:

public JsonResult GetSalesPerformanceByType(int year)
{
    ASPNETMASTERPOSTEntities db = new ASPNETMASTERPOSTEntities();
    var sales = db.tblSales
        .Join(db.tblSalesDetails, s => s.SalesId, sd => sd.SalesId, (s, sd) => new { sale = s, saleDetail = sd })
        .Join(db.tblProducts, sd => sd.saleDetail.ProductId, p => p.ProductId, (sd, p) => new { sale = sd, product = p })
        .ToList();

    var salesByMonth = sales
        .Where(s => DateTime.Parse(s.sale.sale.OrderDate).Year == year)
        .GroupBy(s => DateTime.Parse(s.sale.sale.OrderDate).Month)
        .Select(g => new
        {
            Month = g.Key,
            SalesCount = g.Count()
        })
        .OrderBy(g => g.Month)
        .ToList();

    var monthNames = CultureInfo.CurrentCulture.DateTimeFormat.MonthNames;
    var salesData = salesByMonth.Select(s => new
    {
        Month = monthNames[s.Month - 1], // Month names start from index 0
        SalesCount = s.SalesCount
    });

    return Json(salesData, JsonRequestBehavior.AllowGet);
}