Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- using (_dbContextFactory.CreateReadOnly())
- {
- var surveyShortName = _configRepository.GetByName(AppConfigName.SurveyShortName);
- var sivSurveys = _sivSurveyResponseRepository.GetSivSurveyResponses(surveyShortName).ToList();
- var orderNumbers = sivSurveys.Select(s => long.Parse(s.FkEnhet.OrderNumber));
- var surveyResponses = sivSurveys.Select(sr => new SurveyResponse
- {
- ScbId = long.Parse(sr.FkEnhet.OrderNumber),
- Question1 = GetSivAnswerByRefCode(sr, "Fortr"),
- Question2 = GetSivAnswerByRefCode(sr, "Andvb"),
- Question3 = GetSivAnswerByRefCode(sr, "Serv"),
- Comment = sr.SivSvar.Where(s => s.RefKod == "Forb").Select(s => s.Varde).FirstOrDefault(),
- FkSivBlankettsvarId = sr.Id
- });
- using (var dbContext = _dbContextFactory.Create())
- {
- _surveyRepository.SetSurveysReceivedDate(orderNumbers, DateTime.Now);
- _surveyResponseRepository.SetSurveyResponses(surveyResponses);
- sivSurveys.ForEach(s => s.SentIn = false);
- dbContext.SaveChanges();
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment