private void LoadBarChartData(string formatted)
{
//moramo prvo formatirati datum zbog baze
DateTime from = Convert.ToDateTime(formatted + " 00:00");
DateTime to = Convert.ToDateTime(formatted + " 23:59");
using (var context = new InfosDbContext())
{
var query = context.Infos.Where(s => s.Time >= from && s.Time <= to);
Start = query.Select(x => x.Time).Min();
batteryDbValues = (query.Select(x => x.BatteryPower)).ToList();
panelDbValues = (query.Select(x => x.PanelPower)).ToList();
consumersDbValues = (query.Select(x => x.ConsumersPower)).ToList();
utilityDbValues = (query.Select(x => x.UtilityMoney)).ToList();
tempUtilityMoney = (query.Select(x => x.UtilityMoney)).ToList();
}
//da bi bilo optimizovanije saljem true ili false jer se poslednja malo razlikuje,
//ali u sustini koristi isti kod pa da ne bih kucao 2 identicne metode
GetKeyValuePairs(batteryDbValues, listBattery, false);
GetKeyValuePairs(panelDbValues, listPanel, false);
GetKeyValuePairs(consumersDbValues, listConsumers, false);
GetKeyValuePairs(utilityDbValues, listUtility, true);
GetKeyValuePairs(tempUtilityMoney, listUtilityMoney, false);
((LineSeries)sr.Series[0]).ItemsSource = listPanel.ToArray();
((LineSeries)sr.Series[1]).ItemsSource = listBattery.ToArray();
((LineSeries)sr.Series[2]).ItemsSource = listUtility.ToArray();
((LineSeries)sr.Series[3]).ItemsSource = listConsumers.ToArray();
}
public static void PerformDatabaseOperations(double batteryPower, double panelPower, double consumersPower, double utilityMoney)
{
using (var db = new InfosDbContext())
{
var info = new Infos
{
BatteryPower = batteryPower,
PanelPower = panelPower,
ConsumersPower = consumersPower,
UtilityMoney = utilityMoney,
Time = DateTime.Now
};
db.Infos.Add(info);
db.SaveChanges();
}
}