public async Task <Setting> GetSettingsAsync() { using (var db = new CarRentalDatabase()) { return(await db.Settings.FirstOrDefaultAsync()); } }
public async Task <string> GetHealthAsync() { using (var db = new CarRentalDatabase()) { await db.Database.ExecuteSqlCommandAsync("select GETDATE()"); } return("OK"); }
public async Task UpdateSettingsAsync([FromBody] Setting newSetting) { using (var db = new CarRentalDatabase()) { var setting = await db.Settings.FirstOrDefaultAsync(); setting.DayPrice = newSetting.DayPrice; setting.KilometerPrice = newSetting.KilometerPrice; await db.SaveChangesAsync(); } }
public async Task <decimal> CalculateFinalPriceAsync() { if (_carType == null || _settings == null) { using (var db = new CarRentalDatabase()) { _carType = _carType ?? await db.CarTypes.FirstOrDefaultAsync(x => x.Id == CarTypeId); _settings = _settings ?? await db.Settings.FirstOrDefaultAsync(); } } var days = (int)Math.Ceiling(DateTo.Subtract(DateFrom).TotalDays) + 1; var mileage = FinalMileage - InitialMileage; return(_carType.DayMultiplier * days * _settings.DayPrice + _carType.KilometerMultiplier * mileage * _settings.KilometerPrice); }