public string SaveCurriculumDeliveryInformation(CurriculumDeliveryModel curriculumDelivery, List <EducatorResourceModel> teacherResources, List <CoveredGradeFundamentalModel> coveredGradeFundamentals, List <Grade12LevelOfCompletionModel> grade12LevelOfCompletion) { string results = string.Empty; List <string> resultList = new List <string>(); JavaScriptSerializer js = new JavaScriptSerializer(); try { SurveyRepository repo = new SurveyRepository(); bool data = repo.SaveCurriculumDeliveryInformation(curriculumDelivery, teacherResources, coveredGradeFundamentals, grade12LevelOfCompletion); if (data) { resultList.Add("Success"); } else { resultList.Add("Error when saving Curriculum Delivery Information"); } } catch (Exception ex) { resultList.Add(string.Format("Error - {0}", ex.Message)); } results = js.Serialize(resultList); return(results); }
public AddOptionController(ILogger <AddOptionController> logger, UserManager <User> userManager) { _logger = logger; _userManager = userManager; _surveyRepository = new SurveyRepository(); _optionRepository = new OptionRepository(); }
public QuestionQuery(SurveyRepository _surveyRepository, ApplicationDbContextFactory _contextFactory) { Field <QuestionType>( "question", arguments: new QueryArguments(new QueryArgument <NonNullGraphType <IntGraphType> > { Name = "id" }), resolve: context => _surveyRepository.GetQuestion(context.GetArgument <int>("id"))); Field <ListGraphType <QuestionType> >( "questions", resolve: context => _surveyRepository.Questions()); Field <SurveyType>( "survey", arguments: new QueryArguments(new QueryArgument <NonNullGraphType <IntGraphType> > { Name = "id" }), resolve: context => _surveyRepository.GetSurvey(context.GetArgument <int>("id"))); Field <ListGraphType <SurveyType> >( "surveys", resolve: context => _surveyRepository.Surveys()); }
public string GetCurriculumDeliveryInformationBySchoolID(int schoolID) { string results = string.Empty; JavaScriptSerializer js = new JavaScriptSerializer(); try { //CurriculumDeliveryModel curriculumDelivery, List<EducatorResourceModel> teacherResources, List<CoveredGradeFundamentalModel> coveredGradeFundamentals, List<Grade12LevelOfCompletionModel> grade12LevelOfCompletion SurveyRepository _repo = new SurveyRepository(); CurriculumDeliveryModel curriculumDelivery = _repo.GetCurriculumDeliveryBySchoolID(schoolID); IEnumerable <EducatorResourceModel> teacherResources = _repo.GetEducatorResourcesBySchoolID(schoolID); IEnumerable <CoveredGradeFundamentalModel> coveredGradeFundamentals = _repo.GetCoveredGradeFundamentalsBySchoolID(schoolID); IEnumerable <Grade12LevelOfCompletionModel> grade12LevelOfCompletion = _repo.GetGrade12LevelOfCompletionBySchoolID(schoolID); var data = new { CurriculumDelivery = curriculumDelivery, TeacherResources = teacherResources, CoveredGradeFundamentals = coveredGradeFundamentals, Grade12LevelOfCompletion = grade12LevelOfCompletion }; results = js.Serialize(new { Message = "Success", Data = data }); } catch (Exception ex) { results = js.Serialize(new { Message = string.Format("Error - {0}", ex.Message) }); } return(results); }
/// <summary> /// Parses out the survey HTML for use in an email or printing. /// </summary> /// <param name="responseHeaderId">The response header id.</param> /// <param name="title">The title.</param> /// <param name="displayName">The display name.</param> /// <returns> /// A string containing table based html that represents a survey. /// </returns> private string GenerateTableBasedSurvey(int responseHeaderId, string title, string displayName) { var builder = new StringBuilder(); string body = this.Localize("SurveyCompleted_Body.Text"); if (body != null) { body = body.Replace(Utility.UserNameMarker, displayName); body = body.Replace(Utility.SurveyInformationMarker, title); var survey = new SurveyRepository().LoadReadOnlySurvey(responseHeaderId, this.ModuleId); var table = new Table(); var sb = new StringBuilder(); var writer = new HtmlTextWriter(new StringWriter(sb)); survey.Render(table, new DnnLocalizer(this.LocalResourceFile)); table.RenderControl(writer); body = body.Replace(Utility.SurveyTableMarker, sb.ToString()); builder.Append(body); } ////Because the output of the controls are type "input" the disabled, checked and selected properties must be changed ////to just disabled, checked and selected to be recognized by certain email clients i.e. Hotmail. return (builder.ToString().Replace('"', '\'').Replace(Environment.NewLine, string.Empty).Replace("\t", string.Empty).Replace( "='selected'", string.Empty).Replace("='disabled'", string.Empty).Replace("='checked'", string.Empty)); }
public static Vote Convert(VoteInput input) { var optionRepo = new OptionRepository(); var surveyRepo = new SurveyRepository(); return(new Vote(input.Date, surveyRepo.GetById(input.SurveyId), optionRepo.GetById(input.OptionId))); }
public string GetEnablingConditionsInformationBySchoolID(int schoolID) { string results = string.Empty; JavaScriptSerializer js = new JavaScriptSerializer(); try { SurveyRepository _repo = new SurveyRepository(); EnablingConditionModel enablingConditionsInformation = _repo.GetEnablingConditionsBySchoolID(schoolID); SchoolBuildingConditionModel buildingConditions = _repo.GetSchoolBuildingConditionBySchoolID(schoolID); IEnumerable <LTSMModel> noOfTextbooksList = _repo.GetLTSMBySchoolID(schoolID); var data = new { EnablingConditions = enablingConditionsInformation, BuildingConditions = buildingConditions, LTSM = noOfTextbooksList }; results = js.Serialize(new { Message = "Success", Data = data }); } catch (Exception ex) { results = js.Serialize(new { Message = string.Format("Error - {0}", ex.Message) }); } return(results); }
public SurveyBaseVm(AdminLevel a, int typeId, ICalcIndicators c) { adminLevel = a; r = new SurveyRepository(); model = r.CreateSurvey(typeId); calc = c; }
public SurveyBaseVm(AdminLevel a, SurveyDetails s, ICalcIndicators c) { r = new SurveyRepository(); this.model = r.GetById(s.Id); adminLevel = a; calc = c; }
private async void AddSurveyAsync() { if (!string.IsNullOrEmpty(Name) && !string.IsNullOrEmpty(Description) && !string.IsNullOrEmpty(LowUpperBound) && !string.IsNullOrEmpty(MidUpperBound)) { var survey = await SurveyRepository.AddSurvey(new Survey { Name = Name, Description = Description, CreatedOn = DateTime.Now, SurveyStatus = SurveyStatus.Pending, LowUpperBound = double.Parse(LowUpperBound), MidUpperBound = double.Parse(MidUpperBound) }); if (survey != null) { Name = string.Empty; Description = string.Empty; LowUpperBound = string.Empty; MidUpperBound = string.Empty; await SweetAlertMessage.SuccessMessage(); } else { await SweetAlertMessage.ErrorMessage(); } } else { await SweetAlertMessage.ErrorMessage(); } }
public string SubmitSurvey(int schoolID) { string results = string.Empty; List <string> resultList = new List <string>(); JavaScriptSerializer js = new JavaScriptSerializer(); try { SurveyRepository repo = new SurveyRepository(); SchoolModel data = repo.SubmitSurvey(schoolID); if (data != null) { resultList.Add("Success"); } else { resultList.Add("Error when saving Submitting Survey"); } } catch (Exception ex) { resultList.Add(string.Format("Error - {0}", ex.Message)); } results = js.Serialize(resultList); return(results); }
private void InitializeViewModelExecute() { this.BusyCount++; this.IsNoResponses = false; this.IsResponsesVisible = false; Locator.NavigationStatic.NavigateToQuestionsCommand.RaiseCanExecuteChanged(); _surveyInfoLoader = new BackgroundWorker(); this.CurrentSurvey = new Survey(); this.SubmittedResponses = new ObservableCollection <ResponseSet>(); this.InProgressResponses = new ObservableCollection <ResponseSet>(); this.CompletedResponses = new ObservableCollection <ResponseSet>(); this.surveyRepository = new SurveyRepository(); var pageParameters = NavigationProvider.GetNavigationParameters(); if (pageParameters.ContainsKey(SURVEY_ID)) { this.currentSurveyId = int.Parse(pageParameters[SURVEY_ID]); this.CurrentSurvey = surveyRepository.GetSurveyByID(this.currentSurveyId); } _surveyInfoLoader.DoWork += new DoWorkEventHandler(LoadSurveyInformation); this.IsNoResponses = this.CurrentSurvey.ResponseSet.Count == 0; this.IsResponsesVisible = !this.IsNoResponses; _surveyInfoLoader.RunWorkerAsync(); }
public string SaveInfectionsAndMortalityInformation(List <LearnersCovid19StatisticsPerGradeModel> learnersByGradeCovid19Statistics, List <LearnersCovid19StatisticsPerAgeGroupModel> learnersByAgeGroupCovid19Statistics, List <StaffCovid19StatisticsPerAgeGroupModel> staffCovid19Statistics) { string results = string.Empty; List <string> resultList = new List <string>(); JavaScriptSerializer js = new JavaScriptSerializer(); try { SurveyRepository repo = new SurveyRepository(); bool data = repo.SaveInfectionsAndMortalityInformation(learnersByGradeCovid19Statistics, learnersByAgeGroupCovid19Statistics, staffCovid19Statistics); if (data) { resultList.Add("Success"); } else { resultList.Add("Error when saving Infections And Mortality Information"); } } catch (Exception ex) { resultList.Add(string.Format("Error - {0}", ex.Message)); } results = js.Serialize(resultList); return(results); }
public string GetInfectionsAndMortalityInformationBySchoolID(int schoolID) { string results = string.Empty; JavaScriptSerializer js = new JavaScriptSerializer(); try { //learnersByGradeCovid19Statistics, learnersByAgeGroupCovid19Statistics, staffCovid19Statistics SurveyRepository _repo = new SurveyRepository(); IEnumerable <LearnersCovid19StatisticsPerGradeModel> learnersByGradeCovid19Statistics = _repo.GetLearnersCovid19StatisticsPerGradeBySchoolID(schoolID); IEnumerable <LearnersCovid19StatisticsPerAgeGroupModel> learnersByAgeGroupCovid19Statistics = _repo.GetLearnersCovid19StatisticsPerAgeGroupBySchoolID(schoolID); IEnumerable <StaffCovid19StatisticsPerAgeGroupModel> staffCovid19Statistics = _repo.GetStaffCovid19StatisticsPerAgeGroupBySchoolID(schoolID); var data = new { LearnersByGradeCovid19Statistics = learnersByGradeCovid19Statistics, LearnersByAgeGroupCovid19Statistics = learnersByAgeGroupCovid19Statistics, StaffCovid19Statistics = staffCovid19Statistics }; results = js.Serialize(new { Message = "Success", Data = data }); } catch (Exception ex) { results = js.Serialize(new { Message = string.Format("Error - {0}", ex.Message) }); } return(results); }
private void btnAddNew_Click(object sender, EventArgs e) { double d; if (!model.IsValid() || (tbLat.Text.Length > 0 && !double.TryParse(tbLat.Text, out d)) || (tbLng.Text.Length > 0 && !double.TryParse(tbLng.Text, out d))) { MessageBox.Show(Translations.ValidationError, Translations.ValidationErrorTitle); return; } if (model.AdminLevels == null || model.AdminLevels.Count < 1) { MessageBox.Show(Translations.LocationRequired, Translations.ValidationErrorTitle); return; } bsSentinelSite.EndEdit(); SurveyRepository r = new SurveyRepository(); int userid = ApplicationData.Instance.GetUserId(); if (model.Id > 0) model = r.Update(model, userid); else model = r.Insert(model, userid); OnSave(model); this.Close(); }
public void Delete_Normal_Conditions() { var repo = new SurveyRepository(); var survey = repo.GetAll().LastOrDefault(); repo.Delete(survey); }
public string SaveEnablingConditionsInformation(EnablingConditionModel enablingConditionsInformation, SchoolBuildingConditionModel buildingConditions, List <LTSMModel> noOfTextbooksList) { string results = string.Empty; List <string> resultList = new List <string>(); JavaScriptSerializer js = new JavaScriptSerializer(); try { SurveyRepository repo = new SurveyRepository(); bool data = repo.SaveEnablingConditionsInformation(enablingConditionsInformation, buildingConditions, noOfTextbooksList); if (data) { resultList.Add("Success"); } else { resultList.Add("Error when saving Enabling Conditions Information"); } } catch (Exception ex) { resultList.Add(string.Format("Error - {0}", ex.Message)); } results = js.Serialize(resultList); return(results); }
public static string GetUrlSendSurvey(Bookings bookings) { using (var surveyRepository = new SurveyRepository()) { if (bookings != null) { var survey = surveyRepository.GetSurvey(bookings.BookingId); string surveyCode = string.Empty; if (survey != null) { surveyCode = survey.Code; } string url = bookings.BrowsePassUrl; if (Regex.IsMatch(bookings.BrowsePassUrl, ".+(?<ProductId>/\\d+)$")) { url = bookings.BrowsePassUrl.Replace( Regex.Match(bookings.BrowsePassUrl, ".+(?<ProductId>/\\d+)$").Groups["ProductId"].Value, string.Empty); } return(string.Format(AppConfiguration.DefaultImageUrlSendEmail + "{0}/{1}", url, surveyCode)); } return(string.Empty); } }
/// <summary> /// Creates the graphs for each question. /// </summary> private void CreateGraphs() { var questions = new SurveyRepository().LoadAnswerResponseCounts(this.SurveyId); foreach (var questionPair in questions) { var question = questionPair.First; var answers = questionPair.Second.ToArray(); const int TitleHeight = 25; const int AnswerHeight = 16; const int HeaderFooterHeight = 70; var linesOfTitleText = (int)Math.Ceiling(question.Text.Length / (double)35); var chart = new RadChart { ChartTitle = { TextBlock = { Text = this.GetQuestionLabel(question.RelativeOrder, question.Text, false) } }, SeriesOrientation = ChartSeriesOrientation.Horizontal, Skin = TelerikChartsSkin, Height = Unit.Pixel((linesOfTitleText * TitleHeight) + (AnswerHeight * answers.Length) + HeaderFooterHeight), Legend = { Visible = false }, AutoTextWrap = true, AutoLayout = true, HttpHandlerUrl = this.ResolveUrl("~/ChartImage.axd"), EnableHandlerDetection = false, PlotArea = { XAxis = { Appearance = { TextAppearance = { Visible = false } } }, YAxis = { AxisLabel = { TextBlock = { Text = this.Localize("Axis Label.Text") }, Visible = true} } }, }; var chartSeries = new ChartSeries(); foreach (var answerPair in answers) { var answer = answerPair.First; var answerCount = answerPair.Second; chartSeries.Items.Insert(0, new ChartSeriesItem(answerCount, this.GetAnswerLabel(answer.RelativeOrder, answer.Text, false))); } chart.Series.Add(chartSeries); this.ChartsPanel.Controls.Add(chart); } var charts = this.ChartsPanel.Controls.OfType <RadChart>(); if (!charts.Any()) { return; } var maxHeight = charts.Select(c => (int)c.Height.Value).Max(); foreach (var chart in charts) { chart.Height = Unit.Pixel(maxHeight); } }
private void lnkSurvey_ClickOverride() { ReportRepository repo = new ReportRepository(); opts.EntityType = Model.IndicatorEntityType.Survey; opts.AvailableIndicators = repo.GetSurveyIndicators(false); SurveyRepository typeRepo = new SurveyRepository(); var types = typeRepo.GetSurveyTypes(); opts.FormTypes = types.Select(t => t.SurveyTypeName).OrderBy(t => t).ToList(); OnSwitchStep(new IndStepIndicators(opts)); }
public UnitOfWork(EGramContext context) { if (context == null) { throw new Exception("Context cannot be null"); } _context = context; Surveys = new SurveyRepository(_context); Educations = new EducationRepository(_context); }
private void InitializeViewModelExecute() { this._searchProcessor = new SearchProcessor(); this.SearchString = string.Empty; this.SubmittedResponses = new ObservableCollection <ResponseSet>(); this.SavedResponses = new ObservableCollection <ResponseSet>(); this.Surveys = new ObservableCollection <Survey>(); this.surveyRepository = new SurveyRepository(); this.responsesRepository = new ResponseSetRepository(); }
public SurveyType(SurveyRepository _surveyRepository) { Field(x => x.Id); Field(x => x.Name); Field <ListGraphType <QuestionType>, IEnumerable <Question> >() .Name("Questions") .Resolve(ctx => { return(_surveyRepository.GetQuestionsBySurvey(ctx.Source.Id)); }); }
public UnitOfWork(IDbContextFactory <KhaoSatDbContext> dbContextFactory, Microsoft.AspNetCore.Http.IHttpContextAccessor httpContextAccessor) { _dbContext = dbContextFactory.GetContext(); UserAnswersRepository = new UserAnswersRepository(_dbContext); UserRepository = new UserRepository(_dbContext); UserSurveysRepository = new UserSurveysRepository(_dbContext); SurveysRepository = new SurveyRepository(_dbContext); AnswerRepository = new AnswerRepository(_dbContext); QuestionsRepository = new QuestionsRepository(_dbContext); }
public void Add_Normal_Condition() { var repo = new SurveyRepository(); var survey = new Survey("Test Survey", DateTime.Today.AddDays(1), DateTime.Today.AddDays(2), "Description", options, owner); repo.Add(survey); Assert.True(repo.GetAll().Last().Author != null); }
public void Edit_Normal_Conditions() { var repo = new SurveyRepository(); var survey = new Survey("Test Survey", DateTime.Today.AddDays(1), DateTime.Today.AddDays(2), "Description", options, owner); repo.Add(survey); survey.Color = "#800000"; repo.Edit(survey); }
private async void TakeSurvey(string Id) { Surveys = new HashSet <Survey>(); var confirm = await SweetAlertMessage.ConfirmDialogAsync(Title : "Take Survey", Text : "Choose any available survey."); if (confirm == "Yes") { Surveys = await SurveyRepository.GetSurveys(); Open = true; } }
private void SurveyTypeView_Load(object sender, EventArgs e) { if (!DesignMode) { Localizer.TranslateControl(this); repo = new SurveyRepository(); bsSurveyType.DataSource = model; lvIndicators.SetObjects(model.Indicators.Values.Where(i => i.IsEditable)); if (model.Id == 0) pnlName.Visible = true; } }
public RoomController(IConfiguration configuration) { roomRepository = new RoomRepository(configuration); equipmentRepository = new EquipmentRepository(configuration); buildingRepository = new BuildingRepository(configuration); accountRepository = new AccountRepository(configuration); complaintRepository = new ComplaintRepository(configuration); departmentRepository = new DepartmentRepository(configuration); maintenanceRepository = new MaintenanceRepository(configuration); surveyRepository = new SurveyRepository(configuration); historyRepository = new HistoryRepository(configuration); }
internal void Refresh() { this.BusyCount++; this.surveyRepository = new SurveyRepository(); this.CurrentSurvey = surveyRepository.GetSurveyByID(this.currentSurveyId); this.SubmittedResponses = new ObservableCollection <ResponseSet>(this.surveyRepository.GetSubmittedResponseSets(currentSurveyId)); this.CompletedResponses = new ObservableCollection <ResponseSet>(this.surveyRepository.GetCompletedResponseSets(currentSurveyId)); this.InProgressResponses = new ObservableCollection <ResponseSet>(this.surveyRepository.GetInProgressResponseSets(currentSurveyId)); this.IsNoResponses = this.CompletedResponses.Count == 0 && this.SubmittedResponses.Count == 0 && InProgressResponses.Count == 0; this.IsResponsesVisible = !this.IsNoResponses; this.BusyCount--; }
public void GetSurveysCallback(IEnumerable <Survey> surveys) { if (surveys != null) { using (var surveyRepository = new SurveyRepository()) { var existingSurveys = surveyRepository.GetAllUserSurveys(Membership.CurrentUser.ID).Select(s => s.SystemID).ToList(); surveys = surveys.Where(s => !existingSurveys.Contains(s.SystemID)); } } _callback.Invoke(surveys); }
public void DeleteQuestion(int questionId) { var surveyRepository = new SurveyRepository(); var moduleId = surveyRepository.GetModuleIdForQuestion(questionId); if (!this.CanEditModule(moduleId)) { this.DenyAccess(); } surveyRepository.DeleteQuestion(questionId); }
public void DeleteSurvey(int surveyId) { var surveyRepository = new SurveyRepository(); var moduleId = surveyRepository.GetModuleIdForSurvey(surveyId); if (!this.CanEditModule(moduleId)) { this.DenyAccess(); } surveyRepository.DeleteSurvey(surveyId, moduleId); }
public ViewSurveyController(IUnitOfWork unitOfWork, MultichoiceQuestionRepository mr, Survey_MultichoiceQuestionRepository smr, Survey_FreeTextQuestionRepository sfr, FreeTextQuestionRepository ftr, ChapterRepository cr, OptionsRepository or, MultichoiceQuestion_OptionsRepository mor, SurveyRepository sr) { _unitOfWork = unitOfWork; _mr = mr; _smr = smr; _sfr = sfr; _ftr = ftr; _cr = cr; _or = or; _mor = mor; _sr = sr; }
public async Task <Survey> GenerateSurvey(SubmissionData data, List <List <Snapshot> > assignmentSnapshots) { var snapshots = assignmentSnapshots.SelectMany(s => s); var survey = new Survey() { Snapshots = snapshots.ToList(), Student = data.Student, }; await SurveyRepository.Add(survey); return(survey); }
private void SentinelSiteList_Load(object sender, EventArgs e) { if (!DesignMode) { // Translate the UI Localizer.TranslateControl(this); // Make sure there is an AdminlevelId if (AdminLevelId == 0) return; // Update the title AdminLevel adminLevel = Survey.AdminLevels.FirstOrDefault(); if (adminLevel != null && adminLevel.Name != null) headerLabel.Text = String.Format("{0}: {1}", headerLabel.Text, adminLevel.Name); // Get the Survey repo SurveyRepo = new SurveyRepository(); // Get all the SentinelSites for this Admin unit SentinelSites = SurveyRepo.GetSitesForAdminLevel(new List<string>() { AdminLevelId.ToString() }); // Order the sites SentinelSites = SentinelSites.OrderBy(s => s.SiteName).ToList(); // Load the SentinelSites into the ListView sentinelSiteListView.SetObjects(SentinelSites); } }
//Worksheet 4: Mapping Survey //no aggregation - list all //all Oncho Mapping indicators private void Add4(excel.Worksheet xlsWorksheet, excel.Range rng, List<AdminLevel> districts, DateTime start, DateTime end, int month) { ReportOptions options = new ReportOptions { MonthYearStarts = month, StartDate = start, EndDate = end, IsCountryAggregation = false, IsByLevelAggregation = false, IsAllLocations = true, IsNoAggregation = true }; SurveyRepository repo = new SurveyRepository(); SurveyType survey = repo.GetSurveyType((int)StaticSurveyType.OnchoMapping); SurveyReportGenerator gen = new SurveyReportGenerator(); AddReportToSheet(xlsWorksheet, survey.Indicators, options, gen, (int)StaticSurveyType.OnchoMapping, survey.SurveyTypeName, rng); }
public SentinelSitePickerControl() { r = new SurveyRepository(); demo = new DemoRepository(); InitializeComponent(); }
public SurveyBase CreateCopy(int newTypeId, int roundsId, int surveyTimingId, string roundsName, string timingName) { SurveyRepository repo = new SurveyRepository(); SurveyBase copy = new SurveyBase(); copy.TypeOfSurvey = repo.GetSurveyType(newTypeId); copy.AdminLevels = AdminLevels; copy.StartDate = StartDate; copy.EndDate = EndDate; copy.SiteType = Translations.Sentinel; copy.SiteTypeId = SiteTypeId.Sentinel; copy.Notes = Notes; copy.HasSentinelSite = true; copy.IndicatorValues.Add(new IndicatorValue { DynamicValue = "0", IndicatorId = roundsId, Indicator = copy.TypeOfSurvey.Indicators[roundsName] }); copy.IndicatorValues.Add(new IndicatorValue { DynamicValue = Translations.Baseline, IndicatorId = surveyTimingId, Indicator = copy.TypeOfSurvey.Indicators[timingName] }); return copy; }
/// <summary> /// Adds data for the SCH sheet /// </summary> /// <param name="xlsWorksheet"></param> /// <param name="start"></param> /// <param name="end"></param> private void AddSch(excel.Worksheet xlsWorksheet, DateTime start, DateTime end) { SurveyRepository repo = new SurveyRepository(); int rowCount = 0; var surveys = repo.GetByTypeForDistrictsInDateRange(new List<int> { (int)StaticSurveyType.SchistoSentinel, (int)StaticSurveyType.SchMapping }, start, end); int rowNumber = 8; foreach (SurveyBase survey in surveys.OrderBy(s => s.SortOrder)) { if (survey.TypeOfSurvey.Id == (int)StaticSurveyType.SchistoSentinel) { if (survey.SentinelSiteId.HasValue) { var site = repo.GetSiteById(survey.SentinelSiteId.Value); if (site.Lat.HasValue) xlsWorksheet.Cells[rowNumber,4] = Math.Round(site.Lat.Value, 2); if (site.Lng.HasValue) xlsWorksheet.Cells[rowNumber, 5] = Math.Round(site.Lng.Value, 2); xlsWorksheet.Cells[rowNumber, 2] = site.SiteName; } else { if (survey.Lat.HasValue) xlsWorksheet.Cells[rowNumber,4] = Math.Round(survey.Lat.Value, 2); if (survey.Lng.HasValue) xlsWorksheet.Cells[rowNumber, 5] = Math.Round(survey.Lng.Value, 2); xlsWorksheet.Cells[rowNumber, 2] = survey.SpotCheckName; } } foreach (AdminLevel unit in survey.AdminLevels) { xlsWorksheet.Cells[rowNumber, 1] = unit.Name; foreach (IndicatorValue val in survey.IndicatorValues) { if (val.Indicator.DisplayName == "SCHMapSurSiteNames") xlsWorksheet.Cells[rowNumber, 2] = val.DynamicValue; else if (val.Indicator.DisplayName == "SCHSurStartDateOfSurvey" || val.Indicator.DisplayName == "SCHMapSurStartDateOfSurvey") { DateTime date; if (DateTime.TryParse(val.DynamicValue, out date)) xlsWorksheet.Cells[rowNumber, (int)ExcelCol.C] = date.ToString("MMMM"); } else if (val.Indicator.DisplayName == "SCHMapSurLatitude" && !string.IsNullOrEmpty(val.DynamicValue)) xlsWorksheet.Cells[rowNumber, 4] = Math.Round(Convert.ToDouble(val.DynamicValue), 2); else if (val.Indicator.DisplayName == "SCHMapSurLongitude" && !string.IsNullOrEmpty(val.DynamicValue)) xlsWorksheet.Cells[rowNumber, 5] = Math.Round(Convert.ToDouble(val.DynamicValue), 2); else if (val.Indicator.DisplayName == "SCHMapSurTestType" || val.Indicator.DisplayName == "SCHSurTestType") xlsWorksheet.Cells[rowNumber, 6] = val.DynamicValue; else if (val.Indicator.DisplayName == "SCHMapSurAgeGroupSurveyed" || val.Indicator.DisplayName == "SCHSurAgeGroupSurveyed") xlsWorksheet.Cells[rowNumber, 7] = val.DynamicValue; else if (val.Indicator.DisplayName == "SCHSurNumberOfIndividualsExaminedForUrin" || val.Indicator.DisplayName == "SCHMapSurNumberOfIndividualsExaminedForU") xlsWorksheet.Cells[rowNumber, 8] = val.DynamicValue; else if (val.Indicator.DisplayName == "SCHSurNumberOfIndividualsPositiveForHaem" || val.Indicator.DisplayName == "SCHMapSurNumberOfIndividualsPositiveForH") xlsWorksheet.Cells[rowNumber, 9] = val.DynamicValue; else if (val.Indicator.DisplayName == "SCHSurProportionOfHeavyIntensityUrinaryS" || val.Indicator.DisplayName == "SCHMapSurProportionOfHeavyIntensityUrina") xlsWorksheet.Cells[rowNumber, 11] = val.DynamicValue; else if (val.Indicator.DisplayName == "SCHSurProportionOfModerateIntensityUrina" || val.Indicator.DisplayName == "SCHMapSurProportionOfModerateIntensityUr") xlsWorksheet.Cells[rowNumber, 12] = val.DynamicValue; else if (val.Indicator.DisplayName == "SCHSurNumberOfIndividualsExaminedForInte" || val.Indicator.DisplayName == "SCHMapSurNumberOfIndividualsExaminedForI") xlsWorksheet.Cells[rowNumber, 13] = val.DynamicValue; else if (val.Indicator.DisplayName == "SCHSurNumberOfIndividualsPositiveForInte" || val.Indicator.DisplayName == "SCHMapSurNumberOfIndividualsPositiveForI") xlsWorksheet.Cells[rowNumber, 14] = val.DynamicValue; else if (val.Indicator.DisplayName == "SCHSurProportionOfHeavyIntensityIntestin" || val.Indicator.DisplayName == "SCHMapSurProportionOfHeavyIntensityIntes") xlsWorksheet.Cells[rowNumber, 16] = val.DynamicValue; else if (val.Indicator.DisplayName == "SCHSurProportionOfModerateIntensityIntes" || val.Indicator.DisplayName == "SCHMapSurProportionOfModerateIntensityIn") xlsWorksheet.Cells[rowNumber, 17] = val.DynamicValue; } rowNumber++; rowCount++; } } xlsWorksheet.Cells[3, 5] = rowCount; }
/// <summary> /// Adds data for the Oncho sheet /// </summary> /// <param name="xlsWorksheet"></param> /// <param name="start"></param> /// <param name="end"></param> private void AddOncho(excel.Worksheet xlsWorksheet, DateTime start, DateTime end) { SurveyRepository repo = new SurveyRepository(); int rowCount = 0; var surveys = repo.GetByTypeForDistrictsInDateRange(new List<int> { (int)StaticSurveyType.OnchoAssessment, (int)StaticSurveyType.OnchoMapping }, start, end); int rowNumber = 8; foreach (SurveyBase survey in surveys.OrderBy(s => s.SortOrder)) { foreach (AdminLevel unit in survey.AdminLevels) { xlsWorksheet.Cells[rowNumber, 1] = unit.Name; foreach (IndicatorValue val in survey.IndicatorValues) { if (val.Indicator.DisplayName == "OnchoSurSiteName" || val.Indicator.DisplayName == "OnchoMapSiteName") xlsWorksheet.Cells[rowNumber, 2] = val.DynamicValue; else if (val.Indicator.DisplayName == "OnchoSurStartDateOfSurvey" || val.Indicator.DisplayName == "OnchoMapSurStartDateOfSurvey") { DateTime date; if (DateTime.TryParse(val.DynamicValue, out date)) xlsWorksheet.Cells[rowNumber, (int)ExcelCol.C] = date.ToString("MMMM"); } else if ((val.Indicator.DisplayName == "OnchoSurLatitude" || val.Indicator.DisplayName == "OnchoMapSurLatitude") && !string.IsNullOrEmpty(val.DynamicValue)) xlsWorksheet.Cells[rowNumber, 4] = Math.Round(Convert.ToDouble(val.DynamicValue), 2); else if ((val.Indicator.DisplayName == "OnchoSurLongitude" || val.Indicator.DisplayName == "OnchoMapSurLongitude") && !string.IsNullOrEmpty(val.DynamicValue)) xlsWorksheet.Cells[rowNumber, 5] = Math.Round(Convert.ToDouble(val.DynamicValue), 2); else if (val.Indicator.DisplayName == "OnchoSurSurveyType" || val.Indicator.DisplayName == "OnchoMapSurSurveyType") xlsWorksheet.Cells[rowNumber, 6] = TranslationLookup.GetValue(val.DynamicValue, val.DynamicValue); else if (val.Indicator.DisplayName == "OnchoSurAgeRange" || val.Indicator.DisplayName == "OnchoMapSurAgeRange") xlsWorksheet.Cells[rowNumber, 7] = val.DynamicValue; else if (val.Indicator.DisplayName == "OnchoSurTestType" || val.Indicator.DisplayName == "OnchoMapSurTestType") xlsWorksheet.Cells[rowNumber, 8] = TranslationLookup.GetValue(val.DynamicValue, val.DynamicValue); else if (val.Indicator.DisplayName == "OnchoSurNumberOfIndividualsExamined" || val.Indicator.DisplayName == "OnchoMapSurNumberOfIndividualsExamined") xlsWorksheet.Cells[rowNumber, 9] = val.DynamicValue; else if (val.Indicator.DisplayName == "OnchoSurNumberOfIndividualsPositive" || val.Indicator.DisplayName == "OnchoMapSurNumberOfIndividualsPositive") xlsWorksheet.Cells[rowNumber, 10] = val.DynamicValue; else if (val.Indicator.DisplayName == "OnchoSurIfTestTypeIsNpNumDep" || val.Indicator.DisplayName == "OnchoMapSurIfTestTypeIsNpNumDep") xlsWorksheet.Cells[rowNumber, 12] = val.DynamicValue; else if (val.Indicator.DisplayName == "OnchoSurIfTestTypeIsNpNumNod" || val.Indicator.DisplayName == "OnchoMapSurIfTestTypeIsNpNumNod") xlsWorksheet.Cells[rowNumber, 13] = val.DynamicValue; else if (val.Indicator.DisplayName == "OnchoSurIfTestTypeIsNpNumWri" || val.Indicator.DisplayName == "OnchoMapSurIfTestTypeIsNpNumWri") xlsWorksheet.Cells[rowNumber, 14] = val.DynamicValue; } rowNumber++; rowCount++; } } xlsWorksheet.Cells[3, 5] = rowCount; }
/// <summary> /// Adds the LF sheet /// </summary> /// <param name="xlsWorksheet"></param> /// <param name="start"></param> /// <param name="end"></param> private void AddLfMm(excel.Worksheet xlsWorksheet, DateTime start, DateTime end) { ReportOptions options = new ReportOptions { MonthYearStarts = 1, StartDate = start, EndDate = end, IsCountryAggregation = true, IsByLevelAggregation = false, IsAllLocations = false, IsNoAggregation = false }; IntvReportGenerator gen = new IntvReportGenerator(); IntvRepository repo = new IntvRepository(); SurveyRepository surveys = new SurveyRepository(); // Indicator parser IndicatorParser indicatorParser = new IndicatorParser(); indicatorParser.LoadRelatedLists(); int rowCount = 0; IntvType type = repo.GetIntvType((int)StaticIntvType.LfMorbidityManagement); foreach (var indicator in type.Indicators) if (!indicator.Value.IsCalculated) options.SelectedIndicators.Add(ReportRepository.CreateReportIndicator(type.Id, indicator)); ReportResult result = gen.Run(new SavedReport { ReportOptions = options }); // Top horizontal columns foreach (DataRow dr in result.DataTableResults.Rows) { foreach (DataColumn col in result.DataTableResults.Columns) { if (col.ColumnName.Contains(TranslationLookup.GetValue("LFMMDPNumLymphoedemaPatients", "LFMMDPNumLymphoedemaPatients") + " -")) xlsWorksheet.Cells[5, 10] = dr[col]; if (col.ColumnName.Contains(TranslationLookup.GetValue("LFMMDPNumLymphoedemaPatientsTreated", "LFMMDPNumLymphoedemaPatientsTreated") + " -")) xlsWorksheet.Cells[7, 10] = dr[col]; if (col.ColumnName.Contains(TranslationLookup.GetValue("LFMMDPNumHydroceleCases", "LFMMDPNumHydroceleCases") + " -")) xlsWorksheet.Cells[8, 10] = dr[col]; if (col.ColumnName.Contains(TranslationLookup.GetValue("LFMMDPNumHydroceleCasesTreated", "LFMMDPNumHydroceleCasesTreated") + " -")) xlsWorksheet.Cells[9, 10] = dr[col]; } } // Last half of year (J6) options.StartDate = start.AddMonths(6); result = gen.Run(new SavedReport { ReportOptions = options }); foreach (DataRow dr in result.DataTableResults.Rows) { foreach (DataColumn col in result.DataTableResults.Columns) { if (col.ColumnName.Contains(TranslationLookup.GetValue("LFMMDPNumLymphoedemaPatients", "LFMMDPNumLymphoedemaPatients") + " -")) xlsWorksheet.Cells[6, 10] = dr[col]; } } // Get surveys for rows var lfSurveys = surveys.GetByTypeForDistrictsInDateRange(new List<int> { (int)StaticSurveyType.LfMapping, (int)StaticSurveyType.LfSentinel, (int)StaticSurveyType.LfTas }, start, end); int rowNumber = 15; foreach (SurveyBase survey in lfSurveys.OrderBy(s => s.SortOrder)) { foreach (var adminLevel in survey.AdminLevels) { bool isMfTestType = false; // Static indicators xlsWorksheet.Cells[rowNumber, (int)ExcelCol.B] = adminLevel.Name; if (survey.TypeOfSurvey.Id == (int)StaticSurveyType.LfMapping) { var testTypeVal = survey.IndicatorValues.FirstOrDefault(v => v.Indicator.DisplayName == "LFMapSurTestType"); if (testTypeVal != null && testTypeVal.DynamicValue == "Mf") isMfTestType = true; xlsWorksheet.Cells[rowNumber, (int)ExcelCol.D] = TranslationLookup.GetValue("Mapping", "Mapping"); } else if (survey.TypeOfSurvey.Id == (int)StaticSurveyType.LfSentinel) { var testTypeVal = survey.IndicatorValues.FirstOrDefault(v => v.Indicator.DisplayName == "LFSurTestType"); if (testTypeVal != null && testTypeVal.DynamicValue == "Mf") isMfTestType = true; xlsWorksheet.Cells[rowNumber, (int)ExcelCol.D] = survey.SiteType; if (survey.SentinelSiteId.HasValue) { var site = surveys.GetSiteById(survey.SentinelSiteId.Value); if (site.Lat.HasValue) xlsWorksheet.Cells[rowNumber, (int)ExcelCol.F] = Math.Round(site.Lat.Value, 2); if (site.Lng.HasValue) xlsWorksheet.Cells[rowNumber, (int)ExcelCol.G] = Math.Round(site.Lng.Value, 2); // Name of survey site xlsWorksheet.Cells[rowNumber, (int)ExcelCol.C] = site.SiteName; } else { if (survey.Lat.HasValue) xlsWorksheet.Cells[rowNumber, (int)ExcelCol.F] = Math.Round(survey.Lat.Value, 2); if (survey.Lng.HasValue) xlsWorksheet.Cells[rowNumber, (int)ExcelCol.G] = Math.Round(survey.Lng.Value, 2); // Name of survey site xlsWorksheet.Cells[rowNumber, (int)ExcelCol.C] = survey.SpotCheckName; } } else if (survey.TypeOfSurvey.Id == (int)StaticSurveyType.LfTas) { // Year of Start date of MDA of earliest Intervention List<IntvBase> interventions = repo.GetAll(new List<int> { (int)StaticIntvType.Alb, (int)StaticIntvType.Alb2, (int)StaticIntvType.DecAlb, (int)StaticIntvType.Ivm, (int)StaticIntvType.IvmAlb, (int)StaticIntvType.IvmPzq, (int)StaticIntvType.IvmPzqAlb, (int)StaticIntvType.Mbd, (int)StaticIntvType.Pzq, (int)StaticIntvType.PzqAlb, (int)StaticIntvType.PzqMbd, (int)StaticIntvType.ZithroTeo }, new List<int> {adminLevel.Id}); if (interventions.Count > 0) { // Get all the MDA Start date indicators List<string> mdaStarts = interventions.SelectMany(x => x.IndicatorValues).Where(v => v.Indicator.DisplayName == "PcIntvStartDateOfMda") .Select(x => x.DynamicValue).ToList(); if (mdaStarts.Count > 0) { // Get the earliest one DateTime earliestMda = Convert.ToDateTime(mdaStarts.OrderBy(x => Convert.ToDateTime(x)).FirstOrDefault()); // Add it to the worksheet xlsWorksheet.Cells[rowNumber, (int)ExcelCol.H] = earliestMda.Year; } } } // Dynamic indicators foreach (IndicatorValue val in survey.IndicatorValues) { // Eval name if (val.Indicator.DisplayName == "EuName") xlsWorksheet.Cells[rowNumber, (int)ExcelCol.A] = indicatorParser.Parse(val.Indicator.DataTypeId, val.IndicatorId, val.DynamicValue); // Name of survey site else if (val.Indicator.DisplayName == "LFMapSurSiteNames") xlsWorksheet.Cells[rowNumber, (int)ExcelCol.C] = val.DynamicValue; // TAS objective else if (val.Indicator.DisplayName == "TASTasObjective") xlsWorksheet.Cells[rowNumber, (int)ExcelCol.D] = TranslationLookup.GetValue(val.DynamicValue, val.DynamicValue); else if (val.Indicator.DisplayName == "LFMapSurStartDateOfSurvey" || val.Indicator.DisplayName == "LFSurStartDateOfSurvey" || val.Indicator.DisplayName == "TASStartDateOfSurvey") { DateTime date; if (DateTime.TryParse(val.DynamicValue, out date)) xlsWorksheet.Cells[rowNumber, (int)ExcelCol.E] = date.ToString("MMMM"); } else if (val.Indicator.DisplayName == "LFMapSurLatitude" && !string.IsNullOrEmpty(val.DynamicValue)) xlsWorksheet.Cells[rowNumber, (int)ExcelCol.F] = Math.Round(Convert.ToDouble(val.DynamicValue), 2); else if (val.Indicator.DisplayName == "LFMapSurLongitude" && !string.IsNullOrEmpty(val.DynamicValue)) xlsWorksheet.Cells[rowNumber, (int)ExcelCol.G] = Math.Round(Convert.ToDouble(val.DynamicValue), 2); else if (val.Indicator.DisplayName == "LFSurDateOfTheFirstRoundOfPc") xlsWorksheet.Cells[rowNumber, (int)ExcelCol.H] = val.DynamicValue; else if (val.Indicator.DisplayName == "LFSurNumberOfRoundsOfPcCompletedPriorToS" || val.Indicator.DisplayName == "4190984d-f272-4359-8414-6e7ef06fc4bc") xlsWorksheet.Cells[rowNumber, (int)ExcelCol.I] = val.DynamicValue; //else if (val.Indicator.DisplayName == "LFMapSurTestType" || val.Indicator.DisplayName == "LFSurTestType") // xlsWorksheet.Cells[rowNumber, 9] = TranslationLookup.GetValue(val.DynamicValue, val.DynamicValue); // MF: Number of people examined else if (val.Indicator.DisplayName == "LFMapSurNumberOfIndividualsExamined" || val.Indicator.DisplayName == "LFSurNumberOfIndividualsExamined") { if (isMfTestType) // MF: Number of people examined xlsWorksheet.Cells[rowNumber, (int)ExcelCol.J] = val.DynamicValue; else // Ag/Ab: Number of people examined xlsWorksheet.Cells[rowNumber, (int)ExcelCol.S] = val.DynamicValue; } // MF: Number of people positive else if (val.Indicator.DisplayName == "LFSurNumberOfIndividualsPositive" || val.Indicator.DisplayName == "LFMapSurNumberOfIndividualsPositive") { if (isMfTestType) // MF: Number of people positive xlsWorksheet.Cells[rowNumber, (int)ExcelCol.K] = val.DynamicValue; else // Ag/Ab: Number of people positive xlsWorksheet.Cells[rowNumber, (int)ExcelCol.T] = val.DynamicValue; } // mean dens //else if (val.Indicator.DisplayName == "LFMapSurMeanDensity" || val.Indicator.DisplayName == "LFSurMeanDensity") // xlsWorksheet.Cells[rowNumber, 13] = val.DynamicValue; // count //else if (val.Indicator.DisplayName == "LFSurCount" || val.Indicator.DisplayName == "LFMapSurCount") // xlsWorksheet.Cells[rowNumber, 14] = val.DynamicValue; // community load //else if (val.Indicator.DisplayName == "LFMapSurCommunityMfLoad" || val.Indicator.DisplayName == "LFSurCommunityMfLoad") // xlsWorksheet.Cells[rowNumber, 15] = val.DynamicValue; // MF: % Positive else if (val.Indicator.DisplayName == "LFMapSurPositive" || val.Indicator.DisplayName == "LFSurPositive") xlsWorksheet.Cells[rowNumber, (int)ExcelCol.L] = val.DynamicValue; // Test Type else if (val.Indicator.DisplayName == "LFMapSurTestType" || val.Indicator.DisplayName == "LFSurTestType" || val.Indicator.DisplayName == "TASDiagnosticTest") { if (val.Indicator.DisplayName == "TASDiagnosticTest") xlsWorksheet.Cells[rowNumber, (int)ExcelCol.M] = val.DynamicValue; else { if (!isMfTestType) xlsWorksheet.Cells[rowNumber, (int)ExcelCol.M] = val.DynamicValue; } } // Age range else if (val.Indicator.DisplayName == "LFSurAgeRange" || val.Indicator.DisplayName == "LFMapSurAgeRange" || val.Indicator.DisplayName == "TASAgeRange") { if (val.Indicator.DisplayName == "TASAgeRange") xlsWorksheet.Cells[rowNumber, (int)ExcelCol.N] = val.DynamicValue; else { if (!isMfTestType) xlsWorksheet.Cells[rowNumber, (int)ExcelCol.N] = val.DynamicValue; } } // Survey site else if (val.Indicator.DisplayName == "LFMapSurMappingSiteLocation" || val.Indicator.DisplayName == "eab663f6-1eb8-4efc-85da-2844ee720020" || val.Indicator.DisplayName == "TASLocationType") { if (val.Indicator.DisplayName == "TASLocationType") xlsWorksheet.Cells[rowNumber, (int)ExcelCol.O] = val.DynamicValue; else { if (!isMfTestType) xlsWorksheet.Cells[rowNumber, (int)ExcelCol.O] = val.DynamicValue; } } // Ag/Ab: Survey type else if (val.Indicator.DisplayName == "TASSurveyType") xlsWorksheet.Cells[rowNumber, (int)ExcelCol.P] = val.DynamicValue; // Ag/Ab: # schools or EA targeted else if (val.Indicator.DisplayName == "TASTargetNumberOfSchoolsOrEas") xlsWorksheet.Cells[rowNumber, (int)ExcelCol.Q] = val.DynamicValue; // Ag/Ab: Target sample size else if (val.Indicator.DisplayName == "LFMapSurTargetSampleSize" || val.Indicator.DisplayName == "LFSurTargetSampleSize" || val.Indicator.DisplayName == "TASTargetSampleSize") { if (val.Indicator.DisplayName == "TASTargetSampleSize") xlsWorksheet.Cells[rowNumber, (int)ExcelCol.R] = val.DynamicValue; else { if (!isMfTestType) xlsWorksheet.Cells[rowNumber, (int)ExcelCol.R] = val.DynamicValue; } } // Ag/Ab: Number of people examined else if (val.Indicator.DisplayName == "d807913f-b3a1-4948-a2b3-54eb0800a3bc") xlsWorksheet.Cells[rowNumber, (int)ExcelCol.S] = val.DynamicValue; // Ag/Ab: Number of people positive else if (val.Indicator.DisplayName == "TASActualSampleSizePositive") xlsWorksheet.Cells[rowNumber, (int)ExcelCol.T] = val.DynamicValue; // Ag/Ab: Critical cut-off else if (val.Indicator.DisplayName == "TASCriticalCutoffValue") xlsWorksheet.Cells[rowNumber, (int)ExcelCol.V] = val.DynamicValue; // Ag/Ab: Decision else if (val.Indicator.DisplayName == "TASCriticalCutoff") xlsWorksheet.Cells[rowNumber, (int)ExcelCol.W] = TranslationLookup.GetValue(val.DynamicValue, val.DynamicValue); // Lymphoedema: Number of people examined else if (val.Indicator.DisplayName == "LFSurExaminedLympho" || val.Indicator.DisplayName == "LFMapSurExaminedLympho") xlsWorksheet.Cells[rowNumber, (int)ExcelCol.X] = val.DynamicValue; // Lymphoedema: Number of people positive else if (val.Indicator.DisplayName == "LFMapSurNumberOfCasesOfLymphoedema" || val.Indicator.DisplayName == "LFSurPosLympho") xlsWorksheet.Cells[rowNumber, (int)ExcelCol.Y] = val.DynamicValue; // Hydrocele: Number of people examined else if (val.Indicator.DisplayName == "LFSurExaminedHydro" || val.Indicator.DisplayName == "LFMapSurExaminedHydro1") xlsWorksheet.Cells[rowNumber, (int)ExcelCol.AA] = val.DynamicValue; // Hydrocele: Number of people positive else if (val.Indicator.DisplayName == "LFMapSurNumberOfCasesOfHydrocele" || val.Indicator.DisplayName == "LFSurPosHydro") xlsWorksheet.Cells[rowNumber, (int)ExcelCol.AB] = val.DynamicValue; // Notes else if (val.Indicator.DisplayName == "Notes") xlsWorksheet.Cells[rowNumber, (int)ExcelCol.AD] = val.DynamicValue; } rowNumber++; rowCount++; } } // run formula xlsWorksheet.Cells[3, 5] = rowCount; }
void importerWorker_DoWork(object sender, DoWorkEventArgs e) { try { int userId = ApplicationData.Instance.GetUserId(); Nada.UI.View.Wizard.SplitDistro.WorkerPayload payload = (Nada.UI.View.Wizard.SplitDistro.WorkerPayload)e.Argument; ImportResult result = payload.Importer.UpdateData(payload.FileName, userId, payload.Forms); if (result.WasSuccess) { SurveyRepository repo = new SurveyRepository(); repo.Save(result.Forms.Cast<SurveyBase>().ToList(), userId); } e.Result = result; } catch (Exception ex) { Logger log = new Logger(); log.Error("Error updating survey forms during split. SplitSurveys:importerWorker_DoWork. ", ex); throw; } }
public List<ReportIndicator> GetSurveyIndicators(bool addStaticFields) { List<ReportIndicator> indicators = new List<ReportIndicator>(); SurveyRepository repo = new SurveyRepository(); var types = repo.GetSurveyTypes(); var pc = new ReportIndicator { Name = TranslationLookup.GetValue("PcNtds"), IsCategory = true }; var cm = new ReportIndicator { Name = TranslationLookup.GetValue("OtherNtds"), IsCategory = true }; indicators.Add(pc); indicators.Add(cm); foreach (var t in types.Where(i => i.DiseaseType == TranslationLookup.GetValue("PC")).OrderBy(t => t.SurveyTypeName)) { var cat = new ReportIndicator { Name = t.SurveyTypeName, IsCategory = true, ID = t.Id }; var instance = repo.CreateSurvey(t.Id); if (addStaticFields && (t.Id == (int)StaticSurveyType.LfSentinel || t.Id == (int)StaticSurveyType.SchistoSentinel || t.Id == (int)StaticSurveyType.SthSentinel)) { cat.Children.Add(new ReportIndicator { Name = TranslationLookup.GetValue("IndSentinelSiteName"), TypeId = t.Id, Key = "IndSentinelSiteName" }); cat.Children.Add(new ReportIndicator { Name = TranslationLookup.GetValue("IndSentinelSiteLat"), TypeId = t.Id, Key = "IndSentinelSiteLat" }); cat.Children.Add(new ReportIndicator { Name = TranslationLookup.GetValue("IndSentinelSiteLng"), TypeId = t.Id, Key = "IndSentinelSiteLng" }); cat.Children.Add(new ReportIndicator { Name = TranslationLookup.GetValue("IndSpotCheckName"), TypeId = t.Id, Key = "IndSpotCheckName" }); cat.Children.Add(new ReportIndicator { Name = TranslationLookup.GetValue("IndSpotCheckLat"), TypeId = t.Id, Key = "IndSpotCheckLat" }); cat.Children.Add(new ReportIndicator { Name = TranslationLookup.GetValue("IndSpotCheckLng"), TypeId = t.Id, Key = "IndSpotCheckLng" }); cat.Children.Add(new ReportIndicator { Name = TranslationLookup.GetValue("SiteType"), TypeId = t.Id, Key = "SiteType" }); } foreach (var i in instance.TypeOfSurvey.Indicators) if (i.Value.DataTypeId != (int)IndicatorDataType.SentinelSite) cat.Children.Add(CreateReportIndicator(t.Id, i, t.SurveyTypeName, t.DisplayNameKey)); cat.Children = cat.Children.OrderBy(c => c.Name).ToList(); pc.Children.Add(cat); } foreach (var t in types.Where(i => i.DiseaseType == TranslationLookup.GetValue("CM")).OrderBy(t => t.SurveyTypeName)) { var cat = new ReportIndicator { Name = t.SurveyTypeName, IsCategory = true }; var instance = repo.CreateSurvey(t.Id); foreach (var i in instance.TypeOfSurvey.Indicators) cat.Children.Add(CreateReportIndicator(t.Id, i, t.SurveyTypeName, t.DisplayNameKey)); cat.Children = cat.Children.OrderBy(c => c.Name).ToList(); cm.Children.Add(cat); } return indicators; }
private List<KeyValuePair<string, int>> GetFormTypes(DataRow dr) { var result = new List<KeyValuePair<string, int>>(); if (!string.IsNullOrEmpty(dr["Type ID"].ToString())) { var entityType = (IndicatorEntityType)Convert.ToInt32(dr["Type ID"]); switch (entityType) { case IndicatorEntityType.DiseaseDistribution: DiseaseRepository typeRepo = new DiseaseRepository(); result = typeRepo.GetSelectedDiseases().Select(d => new KeyValuePair<string, int>(d.DisplayName, d.Id)).ToList(); break; case IndicatorEntityType.Intervention: IntvRepository intv = new IntvRepository(); result = intv.GetAllTypes().Select(d => new KeyValuePair<string, int>(d.IntvTypeName, d.Id)).ToList(); break; case IndicatorEntityType.Survey: SurveyRepository sRepo = new SurveyRepository(); result = sRepo.GetSurveyTypes().Select(d => new KeyValuePair<string, int>(d.SurveyTypeName, d.Id)).ToList(); break; case IndicatorEntityType.Process: ProcessRepository pRepo = new ProcessRepository(); result = pRepo.GetProcessTypes().Select(d => new KeyValuePair<string, int>(d.TypeName, d.Id)).ToList(); break; } } return result; }
public void CanFetchLfMfPrevalence() { SurveyRepository repo = new SurveyRepository(); }