public void AddSingleStatistic(StatisticDTO item) { using (UsageStatisticsModel db = new UsageStatisticsModel()) { db.UsageStatistics.Add(new UsageStatistics(item)); db.SaveChanges(); } }
public void RemoveLastRow() { using (UsageStatisticsModel db = new UsageStatisticsModel()) { var row = db.UsageStatistics.OrderByDescending(x => x.Time).FirstOrDefault(); if (row != null) { db.UsageStatistics.Remove(row); db.SaveChanges(); } } }
public IEnumerable <StatisticDTO> GetAllStatistics() { using (UsageStatisticsModel db = new UsageStatisticsModel()) { return(db.UsageStatistics.Select(x => new StatisticDTO() { IdUsageStatistics = x.IdUsageStatistics, Time = x.Time, Type = x.Type, BaseUnit = x.BaseUnit, BaseValue = x.BaseValue, ConvertedUnit = x.ConvertedUnit, ConvertedValue = x.ConvertedValue }).ToList()); } }