public DiseaseDistroPc Create(DiseaseType disease)
 {
     DiseaseDistroPc dd = new DiseaseDistroPc();
     dd.Disease = GetDiseaseById((int)disease);
     GetIndicatorsForDisease(dd.Disease.Id, dd);
     return dd;
 }
 public DiseaseDistroPcVm(AdminLevel a, DiseaseDistroPc s, ICalcIndicators c)
 {
     r = new DiseaseRepository();
     this.model = s;
     adminLevel = a;
     calc = c;
 }
 public DiseaseDistroPcVm(AdminLevel a, int did, ICalcIndicators c)
 {
     adminLevel = a;
     r = new DiseaseRepository();
     model = r.Create((DiseaseType)did);
     model.AdminLevelId = adminLevel.Id;
     calc = c;
 }
 protected override void ReloadDropdownValues()
 {
     if (cmType != null)
     {
         cmType = repo.CreateCm((DiseaseType)cmType.Disease.Id);
         DropDownValues = cmType.IndicatorDropdownValues;
     }
     else
     {
         type = repo.Create((DiseaseType)type.Disease.Id);
         DropDownValues = type.IndicatorDropdownValues;
     }
 }
 protected override void SetSpecificType(int id)
 {
     cmType = null;
     type = null;
     var d = repo.GetDiseaseById(id);
     if (d.DiseaseType == Translations.CM)
     {
         cmType = repo.CreateCm((DiseaseType)d.Id);
         Indicators = cmType.Indicators;
         DropDownValues = cmType.IndicatorDropdownValues;
     }
     else
     {
         type = repo.Create((DiseaseType)d.Id);
         Indicators = type.Indicators;
         DropDownValues = type.IndicatorDropdownValues;
     }
     Calculator = new CalcDistro();
     Validator = new DiseaseDistroCustomValidator();
 }
 protected void AddIndicators(int id, string name, DiseaseDistroPc dd, ReportOptions options)
 {
     options.SelectedIndicators.Add(ReportRepository.CreateReportIndicator(id,
                        new KeyValuePair<string, Indicator>(name, dd.Indicators[name])));
 }
        public void SavePc(DiseaseDistroPc distro, int userId, OleDbConnection connection, OleDbCommand command)
        {
            distro.MapIndicatorsToProperties();
            distro.MapPropertiesToIndicators();
            if (distro.Id > 0)
                command = new OleDbCommand(@"UPDATE DiseaseDistributions SET DiseaseId=@DiseaseId, AdminLevelId=@AdminLevelId,
                           DateReported=@DateReported, Notes=@Notes, UpdatedById=@UpdatedById, UpdatedAt=@UpdatedAt WHERE ID=@id", connection);
            else
                command = new OleDbCommand(@"INSERT INTO DiseaseDistributions (DiseaseId, AdminLevelId, DateReported, Notes, UpdatedById, 
                            UpdatedAt, CreatedById, CreatedAt) values (@DiseaseId, @AdminLevelId, @DateReported, @Notes, @UpdatedById, 
                            @UpdatedAt, @CreatedById, @CreatedAt)", connection);
            command.Parameters.Add(new OleDbParameter("@DiseaseId", distro.Disease.Id));
            command.Parameters.Add(OleDbUtil.CreateNullableParam("@AdminLevelId", distro.AdminLevelId));
            command.Parameters.Add(OleDbUtil.CreateDateTimeOleDbParameter("@DateReported", distro.DateReported.Value));
            command.Parameters.Add(OleDbUtil.CreateNullableParam("@Notes", distro.Notes));
            command.Parameters.Add(new OleDbParameter("@UpdatedById", userId));
            command.Parameters.Add(OleDbUtil.CreateDateTimeOleDbParameter("@UpdatedAt", DateTime.Now));
            if (distro.Id > 0)
                command.Parameters.Add(new OleDbParameter("@id", distro.Id));
            else
            {
                command.Parameters.Add(new OleDbParameter("@CreatedById", userId));
                command.Parameters.Add(OleDbUtil.CreateDateTimeOleDbParameter("@CreatedAt", DateTime.Now));
            }
            command.ExecuteNonQuery();

            if (distro.Id <= 0)
            {
                command = new OleDbCommand(@"SELECT Max(ID) FROM DiseaseDistributions", connection);
                distro.Id = (int)command.ExecuteScalar();
            }

            AddIndicatorValues(connection, distro, distro.Id, userId);
        }
        public void Save(DiseaseDistroPc distro, int userId)
        {
            bool transWasStarted = false;
            OleDbConnection connection = new OleDbConnection(DatabaseData.Instance.AccessConnectionString);
            using (connection)
            {
                connection.Open();
                try
                {
                    // START TRANS
                    OleDbCommand command = new OleDbCommand("BEGIN TRANSACTION", connection);
                    command.ExecuteNonQuery();
                    transWasStarted = true;
                    
                    SavePc(distro, userId, connection, command);

                    // COMMIT TRANS
                    command = new OleDbCommand("COMMIT TRANSACTION", connection);
                    command.ExecuteNonQuery();
                    transWasStarted = false;
                }
                catch (Exception)
                {
                    if (transWasStarted)
                    {
                        try
                        {
                            OleDbCommand cmd = new OleDbCommand("ROLLBACK TRANSACTION", connection);
                            cmd.ExecuteNonQuery();
                        }
                        catch { }
                    }
                    throw;
                }
            }
        }
 protected string GetIndicatorValue(DiseaseDistroPc dd, string indicatorName)
 {
     var indicator = dd.IndicatorValues.FirstOrDefault(i => i.Indicator.DisplayName == indicatorName);
     if (indicator == null)
         return Translations.NA;
     else
         return indicator.DynamicValue;
 }
 private void GetDiseases()
 {
     // Get the Leissh distro
     LeishDd = DiseaseRepo.Create(DiseaseType.Leish);
 }
Exemple #11
0
 //Worksheet 3: Disease Distribution
 //aggregate to the reporting level
 //all Oncho Disease Distribution indicators
 private void AddDdPage(excel.Worksheet xlsWorksheet, excel.Range rng, List<AdminLevel> districts, DateTime start, DateTime end, int month, DiseaseDistroPc dd)
 {
     ReportOptions options = new ReportOptions { MonthYearStarts = month, StartDate = start, EndDate = end, IsCountryAggregation = false, IsByLevelAggregation = true, IsAllLocations = false, IsNoAggregation = false };
     options.SelectedAdminLevels = districts;
     DistributionReportGenerator gen = new DistributionReportGenerator(); 
     AddReportToSheet(xlsWorksheet, dd.Indicators, options, gen, disease.Id, disease.DisplayName, rng);
 }
 private void GetDdForDisease(DateTime start, DateTime end, List<AdminLevel> demography, out DiseaseDistroPc ddType, out Dictionary<int, DataRow> dd, DiseaseType dType)
 {
     ReportOptions options = new ReportOptions
     {
         MonthYearStarts = start.Month,
         StartDate = start,
         EndDate = end,
         IsCountryAggregation = false,
         IsByLevelAggregation = true,
         IsAllLocations = false,
         IsNoAggregation = false
     };
     options.SelectedAdminLevels = demography;
     DistributionReportGenerator gen = new DistributionReportGenerator();
     ddType = diseaseRepo.Create(dType);
     foreach (var indicator in ddType.Indicators.Where(i => i.Value.DataTypeId != (int)IndicatorDataType.Calculated))
         options.SelectedIndicators.Add(ReportRepository.CreateReportIndicator(ddType.Id, indicator));
     ReportResult ddResult = gen.Run(new SavedReport { ReportOptions = options });
     dd = new Dictionary<int, DataRow>();
     foreach (DataRow dr in ddResult.DataTableResults.Rows)
     {
         int id = 0;
         if (int.TryParse(dr["ID"].ToString(), out id))
         {
             if (dd.ContainsKey(id))
                 dd[id] = dr;
             else
                 dd.Add(id, dr);
         }
     }
 }