public string GetAuditInfoUpdate(OleDbDataReader reader)
 {
     return reader.GetValueOrDefault<string>("UserName") + " on " + reader.GetValueOrDefault<DateTime>("UpdatedAt").ToShortDateString();
 }
 private Disease GetDiseaseFromReader(OleDbDataReader reader)
 {
     var d = new Disease
     {
         DisplayNameKey = reader.GetValueOrDefault<string>("DisplayName"),
         DisplayName = TranslationLookup.GetValue(reader.GetValueOrDefault<string>("DisplayName"),
                 reader.GetValueOrDefault<string>("DisplayName")),
         UserDefinedName = reader.GetValueOrDefault<string>("UserDefinedName"),
         DiseaseType = TranslationLookup.GetValue(reader.GetValueOrDefault<string>("DiseaseType"),
                 reader.GetValueOrDefault<string>("DiseaseType")),
         Id = reader.GetValueOrDefault<int>("ID")
     };
     if (!string.IsNullOrEmpty(d.UserDefinedName))
         d.DisplayName = d.UserDefinedName;
     return d;
 }
 public string GetAuditInfo(OleDbDataReader reader)
 {
     return Translations.AuditCreated + ": " + reader.GetValueOrDefault<string>("CreatedBy") + " on " + reader.GetValueOrDefault<DateTime>("CreatedAt").ToShortDateString()
            + ", " + Translations.AuditUpdated + ": " + reader.GetValueOrDefault<string>("UserName") + " on " + reader.GetValueOrDefault<DateTime>("UpdatedAt").ToShortDateString();
 }
        private void AddIndicator(OleDbDataReader reader, Dictionary<int, AdminLevelIndicators> dic, Func<AggregateIndicator, object, object> customAggRule)
        {
            int indicatorId = reader.GetValueOrDefault<int>("iid");
            string key = reader.GetValueOrDefault<string>("iname") + indicatorId;
            int adminLevelId = reader.GetValueOrDefault<int>("aid");
            int indicatorDataType = reader.GetValueOrDefault<int>("DataTypeId");
            int indicatorAggType = reader.GetValueOrDefault<int>("AggTypeId");
            string indicatorValue = reader.GetValueOrDefault<string>("DynamicValue");

            if (dic.ContainsKey(adminLevelId))
            {
                var newIndicator = new AggregateIndicator
                    {
                        IndicatorId = indicatorId,
                        DataType = indicatorDataType,
                        Value = indicatorValue,
                        AggType = indicatorAggType
                    };
                if (dic[adminLevelId].Indicators.ContainsKey(key))
                {
                    // only used in CM JRF doesn't need to aggregate the dropdownlists weighted values
                    dic[adminLevelId].Indicators[key] = IndicatorAggregator.Aggregate(newIndicator, dic[adminLevelId].Indicators[key], new List<IndicatorDropdownValue>());
                }
                else
                    dic[adminLevelId].Indicators.Add(key, newIndicator);
            }
        }