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