/// <summary>
/// Grouped Bar Chart Data.
/// </summary>
/// <param name="Headers"></param>
/// <param name="Values"></param>
/// <param name="Domain"></param>
/// <returns name="Data">Grouped Bar Chart Data object</returns>
public static GroupedBarChartData Data(
List <string> Headers,
List <List <object> > Values,
[DefaultArgumentAttribute("Charts.MiscNodes.GetNull()")] Domain Domain)
{
List <DataPoint2> dataPoints = new List <DataPoint2>();
foreach (List <object> subList in Values)
{
DataPoint2 dataPoint = new DataPoint2();
dataPoint.Name = subList[0].ToString();
Dictionary <string, double> values = new Dictionary <string, double>();
for (int i = 1; i < subList.Count(); i++)
{
values.Add(Headers[i], Convert.ToDouble(subList[i]));
}
dataPoint.Values = values;
dataPoints.Add(dataPoint);
}
GroupedBarChartData data = new GroupedBarChartData();
data.Data = dataPoints;
data.Domain = Domain;
return(data);
}
public static List <DataPoint2> Data2FromTree(List <string> headers, GH_Structure <GH_String> values)
{
List <DataPoint2> dataPoints = new List <DataPoint2>();
for (int i = 0; i < values.Branches.Count; i++)
{
DataPoint2 dataPoint = new DataPoint2();
dataPoint.Name = values.Branches[i][0].Value;
Dictionary <string, double> dict = new Dictionary <string, double>();
for (int j = 1; j < values.Branches[i].Count; j++)
{
try
{
dict.Add(headers[j], Convert.ToDouble(values.Branches[i][j].Value));
}
catch
{
dict.Add(headers[j], 0);
}
}
dataPoint.Values = dict;
dataPoints.Add(dataPoint);
}
return(dataPoints);
}
public static List <DataPoint2> Data2FromCSV(string _filePath)
{
List <DataPoint2> dataPoints = new List <DataPoint2>();
using (CsvReader csv = new CsvReader(new StreamReader(_filePath), true))
{
int fieldCount = csv.FieldCount;
string[] headers = csv.GetFieldHeaders();
while (csv.ReadNextRecord())
{
DataPoint2 dataPoint = new DataPoint2();
dataPoint.Name = csv[0];
Dictionary <string, double> dict = new Dictionary <string, double>();
for (int i = 1; i < fieldCount; i++)
{
try
{
dict.Add(headers[i], Convert.ToDouble(csv[i]));
}
catch
{
dict.Add(headers[i], 0);
}
}
dataPoint.Values = dict;
dataPoints.Add(dataPoint);
}
}
return(dataPoints);
}
/// <summary>
/// Create a list of data point 2s from a CSV path.
/// </summary>
/// <param name="filePath"></param>
/// <returns></returns>
public static List <DataPoint2> Data2FromCsv(string filePath)
{
var dataPoints = new List <DataPoint2>();
using (var csv = new CsvReader(new StreamReader(filePath), true))
{
var fieldCount = csv.FieldCount;
var headers = csv.GetFieldHeaders();
while (csv.ReadNextRecord())
{
var dataPoint = new DataPoint2 {
Name = csv[0]
};
var dict = new Dictionary <string, double>();
for (var i = 1; i < fieldCount; i++)
{
try
{
dict.Add(headers[i], Convert.ToDouble(csv[i]));
}
catch
{
dict.Add(headers[i], 0);
}
}
dataPoint.Values = dict;
dataPoints.Add(dataPoint);
}
}
return(dataPoints);
}
public List <DataPoint2> RevenueDay()
{
List <DataPoint2> dataPoints3 = new List <DataPoint2>();
for (int DayCounter = 0; DayCounter > -1000; DayCounter--)
{
var price = _context.History.Where(x => x.DateCreated.ToShortDateString() == DateTime.Now.AddDays(DayCounter).ToShortDateString()).Sum(y => y.Price);
DataPoint2 z = new DataPoint2(price, DateTime.Now.AddDays(DayCounter).ToShortDateString());
dataPoints3.Add(z);
}
return(dataPoints3);
}
public List <DataPoint2> RevenueYear()
{
List <DataPoint2> dataPoints5 = new List <DataPoint2>();
for (int YearCounter = 0; YearCounter > -100; YearCounter--)
{
decimal price = 0;
DateTime time = DateTime.Now.AddYears(YearCounter);
foreach (var item in _context.History.Where(x => x.DateCreated.Year == time.Year).Select(x => x.Price))
{
price += item;
}
DataPoint2 z = new DataPoint2(price, time.Year.ToString());
dataPoints5.Add(z);
}
return(dataPoints5);
}
public List <DataPoint2> RevenueMonth()
{
List <DataPoint2> dataPoints4 = new List <DataPoint2>();
for (int MonthCounter = 0; MonthCounter > -1000; MonthCounter--)
{
decimal price = 0;
DateTime time = DateTime.Now.AddMonths(MonthCounter);
foreach (var item in _context.History.Where(x => x.DateCreated.Month == time.Month && x.DateCreated.Year == time.Year).Select(x => x.Price))
{
price += item;
}
DataPoint2 z = new DataPoint2(price, time.Month.ToString() + "-" + time.Year.ToString());
dataPoints4.Add(z);
}
return(dataPoints4);
}
/// <summary>
/// Create List of DataPoint2 from List of values and headers.
/// </summary>
/// <param name="headers"></param>
/// <param name="values"></param>
/// <returns></returns>
public static List <DataPoint2> Data2FromList(List <string> headers, List <List <object> > values)
{
var dataPoints = new List <DataPoint2>();
foreach (var subList in values)
{
var dataPoint = new DataPoint2 {
Name = subList[0].ToString()
};
var dict = new Dictionary <string, double>();
for (var i = 1; i < subList.Count; i++)
{
dict.Add(headers[i], Convert.ToDouble(subList[i]));
}
dataPoint.Values = dict;
dataPoints.Add(dataPoint);
}
return(dataPoints);
}
/// <summary>
/// Data.
/// </summary>
/// <param name="Headers">Header values.</param>
/// <param name="Values">Data values.</param>
/// <returns name="Data">Data</returns>
public static ScatterPlotMatrixData Data(
List <string> Headers,
List <List <object> > Values)
{
List <DataPoint2> dataPoints = new List <DataPoint2>();
foreach (List <object> subList in Values)
{
DataPoint2 dataPoint = new DataPoint2();
dataPoint.Name = subList[0].ToString();
Dictionary <string, double> values = new Dictionary <string, double>();
for (int i = 1; i < subList.Count(); i++)
{
values.Add(Headers[i], Convert.ToDouble(subList[i]));
}
dataPoint.Values = values;
dataPoints.Add(dataPoint);
}
ScatterPlotMatrixData data = new ScatterPlotMatrixData();
data.Data = dataPoints;
return(data);
}
