public async Task <OperationResult> Create(SurveyConfigCreateModel createModel)
        {
            try
            {
                var core = await _coreHelper.GetCore();

                await using var sdkContext = core.DbContextHelper.GetDbContext();
                var surveyConfig = new SurveyConfiguration()
                {
                    QuestionSetId = createModel.SurveyId,
                };

                await surveyConfig.Create(sdkContext);

                foreach (var locationsId in createModel.LocationsIds)
                {
                    var siteSurveyConfig = new SiteSurveyConfiguration()
                    {
                        SurveyConfigurationId = surveyConfig.Id,
                        SiteId = locationsId,
                    };

                    await siteSurveyConfig.Create(sdkContext);
                }

                return(new OperationResult(
                           true,
                           _localizationService.GetString("SurveyConfigurationCreatedSuccessfully")));
            }
            catch (Exception e)
            {
                Trace.TraceError(e.Message);
                _logger.LogError(e.Message);
                return(new OperationResult(
                           false,
                           _localizationService.GetString("ErrorWhileCreatingSurveyConfiguration")));
            }
        }
        public async Task <OperationResult> Update(SurveyConfigUpdateModel updateModel)
        {
            try
            {
                var core = await _coreHelper.GetCore();

                await using var sdkContext = core.DbContextHelper.GetDbContext();
                var surveyConfiguration = await sdkContext.SurveyConfigurations
                                          .Include(x => x.SiteSurveyConfigurations)
                                          .Where(x => x.Id == updateModel.Id)
                                          .Where(x => x.WorkflowState != Constants.WorkflowStates.Removed)
                                          .FirstOrDefaultAsync();

                if (surveyConfiguration == null)
                {
                    //transaction.Commit();
                    return(new OperationResult(
                               false,
                               _localizationService.GetString("SurveyConfigurationNotFound")));
                }

                surveyConfiguration.QuestionSetId = updateModel.SurveyId;
                await surveyConfiguration.Update(sdkContext);

                // Locations
                var siteIds = surveyConfiguration.SiteSurveyConfigurations
                              .Where(x => x.WorkflowState != Constants.WorkflowStates.Removed)
                              .Where(x => x.WorkflowState != Constants.WorkflowStates.Removed)
                              .Select(x => x.SiteId)
                              .ToList();

                var forRemove = siteIds
                                .Where(x => !updateModel.LocationsIds.Contains(x))
                                .ToList();

                foreach (var siteIdForRemove in forRemove)
                {
                    var siteSurveyConfigurations = await sdkContext
                                                   .SiteSurveyConfigurations
                                                   .Where(x => x.WorkflowState != Constants.WorkflowStates.Removed)
                                                   .FirstOrDefaultAsync(
                        x => x.SurveyConfigurationId == surveyConfiguration.Id &&
                        x.SiteId == siteIdForRemove);

                    if (siteSurveyConfigurations != null)
                    {
                        await siteSurveyConfigurations.Delete(sdkContext);
                    }
                }

                var forCreate = updateModel.LocationsIds
                                .Where(x => !siteIds.Contains(x))
                                .ToList();

                foreach (var siteIdForCreate in forCreate)
                {
                    var siteSurveyConfigurations = new SiteSurveyConfiguration()
                    {
                        SurveyConfigurationId = surveyConfiguration.Id,
                        SiteId = siteIdForCreate
                    };

                    await siteSurveyConfigurations.Create(sdkContext);
                }

                return(new OperationResult(
                           true,
                           _localizationService.GetString("SurveyConfigurationUpdatedSuccessfully")));
            }
            catch (Exception e)
            {
                Trace.TraceError(e.Message);
                _logger.LogError(e.Message);
                return(new OperationResult(
                           false,
                           _localizationService.GetString("ErrorWhileUpdatingSurveyConfiguration")));
            }
        }