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