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