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