Display data in admin dashboard

Hello Sachin 

I tried your code and did some changes to suit my code but is giving me some errors in the PlotGraph code

Please do I need to create a new table like as you statated in your example because I have table like stockIn, Sales table and sales details table 

create a viewModel

public class GraphModel
{
  public DailySales dailySales {get;set;}
  public Stockdaily stock{get;set;}
  public CriticalStock criticalStock{get;set;}
}

public class DailySales
{
public DateTime date {get;set;}
public decimal SaleAmount{get;set;}
}

public class Stock
{
public string ProductName{get;set;}
public int Qty{get;set;}
}

public class CriticalStock
{
public string ProductName{get;set;}
public int Qty{get;set;}
}

now fill the above view model

public class GraphModel
{
  public List dailySales {get;set;}
  public List stocks{get;set;}
  public List criticalStocks{get;set;}
}



public ActionResult PlotGraph()
{
GraphModel model= new GraphModel();
YourDbContext db= new YourDbContext();
var res1=db.Sales.Group(x=>x.SellDate).select(x=>new DailySales(){
date=x.Key,
SaleAmount= Sum(x.Amount)
}).ToList();
var res2=db.Products.select(x=>new Stock(){
ProductName=x.ProductName,
Qty= x.Qty
}).ToList();
var res3=db.Products.Where(x=>x.Quantity<100 && x.Price>1000).select(x=>new Stock(){
ProductName=x.ProductName,
Qty= x.Qty
}).ToList();
model.dailySales =res1;
model.stocks=res2;
model.criticalStocks=res3;
return Json(model,JsonRequestBehaviour.AllowGet)
}

Now based on json response use ChartJs library and assign x and y axes.

Thank you Tamang, I will check it and revert 

Hi,

Please check this code repository https://github.com/go2ismail/Asp.Net-User-Role-Membership-Example. This will gives you idea about creating admin dashboard. For graph you can check this article https://www.c-sharpcorner.com/article/creating-charts-with-asp-net-core-mvc-using-google-chart-api-part-two/. I hope you will find these helpful.

Regards,
Pasang