public async Task <ZoneAreaUpdateResponse> UpdateZoneAreaAsync(ZoneAreaUpdateRequest req) { var result = new ZoneAreaUpdateResponse(); var validateResult = await ValidateModel(req); if (validateResult != null && validateResult.Any()) { result.HasError = true; result.ErrorMsgs = validateResult; return(result); } req.ZoneArea.UpdatedDate = DateTime.Today; return(await _repos.UpdateZoneAreaAsync(req)); }
public async Task <ZoneAreaUpdateResponse> UpdateZoneAreaAsync(ZoneAreaUpdateRequest req) { using (var conn = new SqlConnection(_connectionSettings.DefaultConnection)) { var result = new ZoneAreaUpdateResponse(); const string storeproc = @"[dbo].[uspAreasUpdate_New]"; await conn.OpenAsync(); var dynParm = new { req.ZoneArea.Id, req.ZoneArea.Zone, req.ZoneArea.Name, req.ZoneArea.UpdatedBy, req.ZoneArea.UpdatedDate }; var rawResult = await conn.QueryAsync <ZoneAreaDTO>(storeproc, dynParm, null, null, CommandType.StoredProcedure); result.Data = rawResult.FirstOrDefault(); return(result); } }