public async Task <int> DevHub_AmenityRates_Set(AmenityRatesForCreateModel model, string userName) { using (var con = GetDbConnection(_options.Value.DevHubDBConn)) { var result = await con.QueryAsync <int>("dbo.DevHub_AmenityRates_Set", new { @iIntRateID = model.RateId, @iIntAmenityID = model.AmenityId, @iIntFrequencyID = model.FrequencyId, @iDecRateValue = model.RateValue, @iStrCapacity = model.Capacity, @iStrUserName = userName }, commandType : CommandType.StoredProcedure); return(result.FirstOrDefault()); } }
public async Task <IActionResult> AmenityRatesInsert([FromBody] AmenityRatesForCreateModel model) { if (await _service.AmenityRateExists(model.AmenityId, model.FrequencyId, model.Capacity)) { ModelState.AddModelError("AmenityRate", "Rate is already defined."); } // validate request if (!ModelState.IsValid) { return(BadRequest(ModelState)); } var amenityRateToCreate = await _service.DevHub_AmenityRates_Set(model, _baseUserName); if (amenityRateToCreate == 0) { return(BadRequest()); } return(NoContent()); }
public async Task <IActionResult> AmenityRatesUpdate([FromBody] AmenityRatesForCreateModel model) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } var chkRate = await _service.DevHub_AmenityRates_Get(model.AmenityId, model.RateId); if (chkRate == null) { return(NotFound()); } var amenityRateToUpdate = await _service.DevHub_AmenityRates_Set(model, _baseUserName); if (amenityRateToUpdate == 0) { return(BadRequest()); } return(NoContent()); }
public async Task <int> DevHub_AmenityRates_Set(AmenityRatesForCreateModel model, string userName) { return(await _repo.DevHub_AmenityRates_Set(model, userName)); }