public async Task <int> UpdateAreaKeyId(AreaEndPointModel model) { using (var _dbContext = new DataBaseContext()) { object[] parameters = new object[] { model.KeyId, model.Area }; return(await _dbContext.ExecuteNonQueryAsync("sp_UpdatekeyIdAreaByName", parameters)); } }
public async Task <AreaEndPointModel> getAreaById(int id) { AreaEndPointModel areaEndPointModel = new AreaEndPointModel(); using (var _context = new DataBaseContext()) { object[] parameters = new object[] { id }; var dReader = await _context.ExecuteReaderAsync("sp_GetKeyIdArea", parameters); while (dReader.Read()) { areaEndPointModel.Area = dReader.GetString(0); areaEndPointModel.KeyId = dReader.GetString(1); } } return(areaEndPointModel); }
public async Task <IHttpActionResult> updateAreaKeyId(AreaEndPointModel model) { var result = await services.UpdateAreaKeyId(model); return(Ok(result)); }