protected override List <ChartItemViewModel> GetGraphData() { List <ChartItemViewModel> result = new List <ChartItemViewModel>(); foreach (var item in ItemsShowing.OrderBy(x => - x.Amount)) { ChartItemViewModel scc = new ChartItemViewModel(); scc.X = item.SalesPersonName; scc.TotalSale = item.Amount; result.Add(scc); } return(result); }
protected override List <ChartItemViewModel> GetGraphData() { List <ChartItemViewModel> result = new List <ChartItemViewModel>(); foreach (var item in ItemsShowing.OrderBy(x => x.DayOfWeek == DayOfWeek.Sunday ? 7 : (int)x.DayOfWeek)) { ChartItemViewModel scc = new ChartItemViewModel(); scc.X = ((Dias)item.DayOfWeek).ToString(); scc.TotalSale = Math.Round(item.Amount); result.Add(scc); } return(result); }
protected override List <ChartItemViewModel> GetGraphData() { List <ChartItemViewModel> result = new List <ChartItemViewModel>(); foreach (var group in ItemsShowing.GroupBy(x => x.ProductClass).OrderBy(x => x.Key)) { ChartItemViewModel scc = new ChartItemViewModel(); scc.X = group.Key.ToString(); scc.Count = group.Count(); result.Add(scc); } return(result); }
//PROJECTION PERCENT //public double ProjectionPercent //{ // get { return cro.ProjectionPercent; } // set { cro.ProjectionPercent = value; UpdateProjections(); } //} //void UpdateProjections() //{ // foreach (var item in linesBeforeLiveFilter) // { // double newProjQttyInBase = item.AverageQuantity * item.AverageUnitMeasure.ToBaseConversion // * (1 + ProjectionPercent / 100); // //item.ProjectedQuantity = newProjQtty; // var invSVC = base.GetService<IInventoryService>(); // //quantity // UnitMeasure bestUM = invSVC.GetBestUM(item.Product.UMFamily, newProjQttyInBase); // item.ProjectedUnitMeasure = bestUM; // item.ProjectedQuantity = newProjQttyInBase / bestUM.ToBaseConversion; // } //} //GRAPH DATA protected override List <ChartItemViewModel> GetGraphData() { List <ChartItemViewModel> result = new List <ChartItemViewModel>(); foreach (var item in ItemsShowing) { ChartItemViewModel scvm = new ChartItemViewModel(); int dow = (int)item.Date.DayOfWeek; scvm.X = item.Date.ToString("ddd d");// string.Format("{0} {1}", (Dias)dow, item.Date.Day); //((Dias)dow).ToString() + " " + item.Date.Day.ToString(); scvm.Quantity = item.AverageQuantity; result.Add(scvm); } return(result); }
protected override List <ChartItemViewModel> GetGraphData() { List <ChartItemViewModel> result = new List <ChartItemViewModel>(); foreach (var item in ItemsShowing.Where(x => x.ChildrenProductsTotalSale > 0).OrderBy(x => - x.ChildrenProductsTotalSale)) { ChartItemViewModel scc = new ChartItemViewModel(); scc.X = item.CategoryName; scc.TotalSale = Math.Round(item.ChildrenProductsTotalSale); result.Add(scc); } return(result); }
protected override List <ChartItemViewModel> GetGraphData() { List <ChartItemViewModel> result = new List <ChartItemViewModel>(); foreach (var item in ItemsShowing) { ChartItemViewModel scc = new ChartItemViewModel(); //get month from the first sale scc.Date = item.Date; scc.X = item.DateSpanString; scc.TotalSale = Math.Round(item.Amount); //scc.TotalCost = Math.Round(item.Cost); result.Add(scc); } return(result); }
protected override List <ChartItemViewModel> GetGraphData() { List <ChartItemViewModel> result = new List <ChartItemViewModel>(); var query = from low in ItemsShowing where low.DateCreated.Year > 1 let time = DateTime.Today.AddHours(low.DateCreated.Hour) group low by time; foreach (var group in query.OrderBy(x => x.Key)) { ChartItemViewModel cbh = new ChartItemViewModel(); cbh.X = string.Format("{0:h:mm tt}", group.Key); cbh.Clients = group.Sum(x => x.Clients); result.Add(cbh); } return(result); }
protected override List <ChartItemViewModel> GetGraphData() { List <ChartItemViewModel> result = new List <ChartItemViewModel>(); //service time data var groupQuery = from low in ItemsShowing let span = GetSpanKey(low) where span >= 0 orderby span group low by span; foreach (var group in groupQuery) { ChartItemViewModel stt = new ChartItemViewModel(); int minutes = group.Key * 5; stt.X = minutes > 60 ? "> 60" : minutes.ToString(); stt.Quantity = group.Count(); result.Add(stt); } return(result); }