public ActionResult ResetChart(string pName, string oNumber)
{
VW_ProductSummaryManager objVW_ProductSummaryManager = new VW_ProductSummaryManager(new DataContext());
List <VW_ProductSummary> lst = objVW_ProductSummaryManager.GetProductSummaryList(oNumber, pName);
if (lst.Count() > 0)
{
SeriesData obj1 = new SeriesData();
obj1.name = "ProductQty";
obj1.data = lst.Select(c => c.ProductQty).ToList();
SeriesData obj2 = new SeriesData();
obj2.name = "FinishedQty";
obj2.data = lst.Select(c => c.FinishedQty).ToList();
SeriesData obj3 = new SeriesData();
obj3.name = "BalanceQty";
obj3.data = lst.Select(c => c.BalanceQty).ToList();
List <SeriesData> SeriesData = new List <SeriesData>();
SeriesData.Add(obj1);
SeriesData.Add(obj2);
SeriesData.Add(obj3);
var lstCat = lst.Select(c => c.Buyername + " / " + c.BuyerOrderNumberName + " / " + c.Processname).ToList();
return(Json(new { Error = false, Series = SeriesData, Categories = lstCat }));
}
else
{
return(Json(new { Error = true }));
}
}
// GET: AdminChart
public ActionResult Index()
{
ProcessListManager objProcessListManager = new ProcessListManager(new DataContext());
BuyerListManager objBuyerListManager = new BuyerListManager(new DataContext());
BuyerOrderNumberListManager objBuyerOrderNumberListManager = new BuyerOrderNumberListManager(new DataContext());
VW_ProductSummaryManager objVW_ProductSummaryManager = new VW_ProductSummaryManager(new DataContext());
List <VW_ProductSummary> lst = objVW_ProductSummaryManager.GetProductSummaryList();
SeriesData obj1 = new SeriesData();
obj1.name = "ProductQty";
obj1.data = lst.Select(c => c.ProductQty).ToList();
SeriesData obj2 = new SeriesData();
obj2.name = "FinishedQty";
obj2.data = lst.Select(c => c.FinishedQty).ToList();
SeriesData obj3 = new SeriesData();
obj3.name = "BalanceQty";
obj3.data = lst.Select(c => c.BalanceQty).ToList();
List <SeriesData> SeriesData = new List <SeriesData>();
SeriesData.Add(obj1);
SeriesData.Add(obj2);
SeriesData.Add(obj3);
VW_ProductSummary_Model objModel = new VW_ProductSummary_Model();
objModel.BuyerList = Extens.ToSelectList(objBuyerListManager.GetDtBuyer(), "Buyername", "Buyername");
objModel.BuyerOrderNumberList = Extens.ToSelectList(objBuyerOrderNumberListManager.GetDtBuyerOrderNumber(), "BuyerOrderNumberName", "BuyerOrderNumberName");
objModel.ProcessList = Extens.ToSelectList(objProcessListManager.GetDtProcess(), "Processname", "Processname");
objModel.SeriesList = SeriesData;
objModel.Json = JsonConvert.SerializeObject(SeriesData);
objModel.categories = JsonConvert.SerializeObject(lst.Select(c => c.Buyername + " / " + c.BuyerOrderNumberName + " / " + c.Processname).ToList());
return(View(objModel));
}
