public ObservableCollection <RefuelingEntry> GetObservableRefuelingHistory()
{
ObservableCollection <RefuelingEntry> refuelinglist = new ObservableCollection <RefuelingEntry>();
var list = _set.Select(x => new { distance = x.Distance, numberofliters = x.Numberofliters, consumption = x.Fuelconsumption, carname = x.Car.Name, refuelingdate = x.RefuelingDate });
foreach (var element in list)
{
RefuelingEntry obj = new RefuelingEntry();
obj.distance = element.distance;
obj.numberofliters = element.numberofliters;
obj.consumption = element.consumption;
obj.carname = element.carname;
obj.date = element.refuelingdate;
if (element.refuelingdate != null)
{
obj.refuelingdate = element.refuelingdate.Value.ToShortDateString();
}
else
{
obj.refuelingdate = "";
}
refuelinglist.Add(obj);
}
return(refuelinglist);
}
public RefuelingEntry GetLowestConsumption()
{
RefuelingEntry refuelingentry = new RefuelingEntry();
using (UnitOfWork uof = new UnitOfWork(new Fuel.DAL.EF6.FuelContext()))
{
refuelingentry = uof.RefuelingRepository.GetRefuelingHistory().Select(x => x).OrderByDescending(x => x.consumption).LastOrDefault();
}
return(refuelingentry);
}
public List <RefuelingEntry> GetRefuelingHistory()
{
List <RefuelingEntry> refuelingentrylist = new List <RefuelingEntry>();
var list = _set.Select(x => new { distance = x.Distance, numberofliters = x.Numberofliters, consumption = x.Fuelconsumption, carname = x.Car.Name });
foreach (var element in list)
{
RefuelingEntry obj = new RefuelingEntry();
obj.distance = element.distance;
obj.numberofliters = element.numberofliters;
obj.consumption = element.consumption;
obj.carname = element.carname;
refuelingentrylist.Add(obj);
}
return(refuelingentrylist);
}
public void DodajElementyDoWykresu()
{
if (IsSelCar())
{
this.Power.Clear();
RefuelingList = GetRefuelingList();
foreach (var item in RefuelingList)
{
RefuelingEntry obj = item;
if (obj.carname == SelCar.Name && obj.date >= DataPocz.Date)
{
this.Power.Add(new Punkt()
{
Date = obj.date, Spalanie = obj.consumption
});
}
}
}
//Power.Add(new Punkt() { Date = new DateTime(2017, 1, 2), Spalanie = 6 });
//Power.Add(new Punkt() { Date = new DateTime(2017, 1, 4), Spalanie = 2 });
//Power.Add(new Punkt() { Date = new DateTime(2017, 1, 10), Spalanie = 4 });
//Power.Add(new Punkt() { Date = new DateTime(2017, 1, 15), Spalanie = 6 });
}
