public ActionResult Chem6WeekChart()
        {
            int             PId    = 0;
            ChemicalPricing Objdal = new DAL.ChemicalPricing();


            List <SA_Chem6PriceWeekly> obj = null;
            string compare = string.Empty;

            string currentYear  = DateTime.Now.Year.ToString();
            string currentMonth = DateTime.Now.ToMonthName().ToUpper();
            string currentWeek  = ((Convert.ToInt32(DateTime.Now.Day) / 7) + 1).ToString();

            //               Convert.ToInt32(DateTime.Now.Day / 7).ToString();


            obj = Objdal.GetChem6WeekWise(currentYear, currentMonth, currentWeek);
            List <string> Year        = obj.Select(p => p.day).Distinct().ToList();
            List <string> Discription = obj.Select(p => p.Discription).Distinct().ToList();

            var lstModel = new List <StackedViewModel>();

            for (int i = 0; i < Year.Count; i++)
            {
                List <SA_Chem6PriceWeekly> Chartdata = obj.Where(Chart => Chart.day == Year[i]).ToList();
                PId = Chartdata.FirstOrDefault().Product.Value;
                //sales of product sales by quarter
                StackedViewModel Report = new StackedViewModel();
                Report.StackedDimensionOne = Year[i];

                List <SimpleReportViewModel> Data         = new List <SimpleReportViewModel>();
                List <SimpleReportViewModel> QuantityList = new List <ViewModel.SimpleReportViewModel>();


                foreach (var item in obj.Select(p => p.ProductVariant).Distinct().ToList())
                {
                    SimpleReportViewModel Quantity = new SimpleReportViewModel()
                    {
                        DimensionOne = item,// item.Month,
                        Quantity     = Chartdata.Where(x => x.ProductVariant == item).Sum(x => x.count.Value),
                        // MDimensionOne = Chartdata.FirstOrDefault(w=>w.ProductVariant== item).day
                    };
                    QuantityList.Add(Quantity);
                }


                //foreach (var item in Chartdata)
                //{
                //    SimpleReportViewModel Quantity = new SimpleReportViewModel()
                //    {
                //        DimensionOne = item.ProductVariant,
                //        Quantity = item.count.HasValue? item.count.Value:0,
                //        MDimensionOne = item.day
                //};
                //    QuantityList.Add(Quantity);
                //}
                Report.LstData = QuantityList;

                lstModel.Add(Report);

                lstModel[0].ProductName = ObjProduct.GetProductByid(PId).ProductName;
            }



            if (lstModel.Count() > 0)
            {
                return(PartialView("~/Views/PartialView/YearlyChartChemical6.cshtml", lstModel));
            }
            else
            {
                return(PartialView("~/Views/PartialView/YearlyChemical.cshtml", lstModel));
            }
        }
        public ActionResult Chem1WeekChart(string year = "2019")
        {
            ChemAnalystContext _context = new ChemAnalystContext();
            int custid = 0;

            if (year == "")
            {
                year = DateTime.Now.Year.ToString();
            }
            ViewBag.CYear = year;
            ChemicalPricing Objdal = new DAL.ChemicalPricing();
            //ViewBag.QYears = Objdal.GetYear("W");

            List <SA_ChemPriceWeekly> obj = null;



            //var id= _context.SA_Product.OrderBy(x => new { x.Category, x.id }).FirstOrDefault().id;
            var catId = _context.SA_Category.OrderBy(x => x.id).FirstOrDefault().id;


            var product = _context.SA_Product.Where(w => w.Category == catId).OrderBy(x => x.id).FirstOrDefault().id.ToString();

            obj = Objdal.SA_Chem1PriceWeekly(product, year);



            List <string> Day         = obj.Select(p => p.Week).Distinct().ToList();
            List <string> Discription = obj.Select(p => p.Discription).Distinct().ToList();


            var lstModel = new List <StackedViewModel>();


            for (int i = 0; i < Day.Count; i++)
            {
                List <SA_ChemPriceWeekly> Chartdata = obj.Where(Chart => Chart.Week == Day[i]).ToList();;
                //obj.Where(Chart => Chart.year == DateTime.Now.Year.ToString() && Chart.day == Day[i]).ToList();
                //sales of product sales by quarter
                StackedViewModel Report = new StackedViewModel();
                Report.StackedDimensionOne = Day[i];
                Report.Discription         = Discription;
                Report.category            = Objdal.GetctegotyBYproduct(obj[0].Product);
                Report.Product             = (obj[0].Product).ToString();
                Report.Year = year;


                List <SimpleReportViewModel> Data         = new List <SimpleReportViewModel>();
                List <SimpleReportViewModel> QuantityList = new List <ViewModel.SimpleReportViewModel>();


                foreach (var item in obj.Select(p => p.ProductVariant).Distinct().ToList())
                {
                    SimpleReportViewModel Quantity = new SimpleReportViewModel()
                    {
                        DimensionOne = item,// item.Month,
                        Quantity     = Chartdata.Where(x => x.ProductVariant == item).Sum(x => x.count)
                    };
                    QuantityList.Add(Quantity);
                }


                Report.LstData = QuantityList;
                if (product == null)
                {
                    Report.ChartType = "line";
                    Report.range     = "Week";
                }
                else
                {
                    Report.Product   = product;
                    Report.ChartType = "bar";
                    Report.range     = "Weekly";
                }
                lstModel.Add(Report);
            }

            ViewBag.Category = Objdal.GetctegotyBYproduct(int.Parse(product));

            lstModel[0].ProductName = ObjProduct.GetProductByid(Convert.ToInt32(product)).ProductName;
            if (lstModel.Count() > 0)
            {
                return(PartialView("~/Views/PartialView/YearlyChartChemical1.cshtml", lstModel));
            }
            else
            {
                return(PartialView("~/Views/PartialView/YearlyChemical.cshtml", lstModel));
            }
        }