public virtual async Task <T> AddAsync(T t) { _context.Set <T>().Add(t); await _context.SaveChangesAsync(); return(t); }
public async Task <IActionResult> Index(double kwh) { var result = kwh; var resultDay = result * 24; if (resultDay < 0) { resultDay = 0; } decimal resultDollars = ((decimal)resultDay * 28.52M) / 100M; var rString = string.Format("{0:0.00}", result); var rStringDay = string.Format("{0:0.00}", resultDay); var rDollars = resultDollars.ToString("C0"); Console.WriteLine($"{rString}kwh -> {rStringDay} kwh per day -> {rDollars} per day @ {DateTime.Now.ToString()}"); await _context.PowerReadings.AddAsync(new PowerReading { KilowattHours = result, DailyKilowattHours = result * 24, MeasureTime = DateTime.Now }); await _context.SaveChangesAsync(); var averageSoFarYesterday = await _databaseService.AverageSoFarYesterday(); var averageSoFarToday = await _databaseService.AverageSoFarToday(); var averageLast24Hours = await _databaseService.AverageLast24Hours(); var averageYesterday = await _databaseService.AverageYesterday(); await PowerBIHelper.Push(result, averageSoFarToday, averageSoFarYesterday, averageLast24Hours, averageYesterday, resultDollars, _powerOptions.Value.PowerBiUrl); return(Ok(result)); }