private static void addIndicators(DbConnection conn, Provider p, IEnumerable<ExtendedSubTheme> subthemes, INEService.Statistics ine) { Console.WriteLine(":::::::::: Adding indicatores :::::::::"); var indicatorDAO = new IndicatorDAO(conn); foreach (var subtheme in subthemes) { INEService.IndicatorPlus indicators = ine.GetIndicatorsByTheme(GEOVERSION, subtheme.SourceThemeCode, LANGUAGE, 2, 1, 10000); foreach (var indicator in indicators.Indicators) { Console.WriteLine("... Adding indicator: {0} ....", subtheme.NameAbbr); Indicator convertedIndicator = new Indicator { Name = indicator.Designation, NameAbbr = indicator.Abbreviation, Provider = p, SourceID = indicator.Code, SubThemeID = subtheme.ID, ThemeID = subtheme.ThemeID }; convertedIndicator.ID = indicatorDAO.AddIndicator(convertedIndicator); addConfiguration(conn, convertedIndicator, indicator.GeoLevelCode); } } }
public int AddProvider(Provider p) { using (ProviderDAO.Connection = ConnectionSettings.CreateDBConnection()) { return ProviderDAO.AddProvider(p); } }
public int AddProvider(Provider p) { return DbTemplateHelper<int>.GetValueByProcedure( Connection, "config.insertprovider", new DbParameterHelper[] { new DbParameterHelper(DbType.String, "p_name", p.Name), new DbParameterHelper(DbType.String, "p_nameAbbr", p.NameAbbr), new DbParameterHelper(DbType.String, "p_serviceUrl", p.ServiceURL), new DbParameterHelper(DbType.String, "p_url", p.URL), }); }
public void GetProvidersTest() { ProviderDAO target = new ProviderDAO(connnetion); Nullable<int> page = new Nullable<int>(1); Nullable<int> recordsPerPage = new Nullable<int>(1); Provider expected = new Provider { ID = 1, Name = "Instituto Nacional de Estatística", NameAbbr = "INE", ServiceURL = "http://localhost:42136/INEStatisticsProvider.svc", URL = "http://www.ine.pt" }; IEnumerable<Provider> actual; actual = target.GetProviders(page, recordsPerPage); Assert.AreEqual(1, actual.Count()); Assert.AreEqual(expected, actual.ElementAt(0)); }
static Provider addProvider(DbConnection conn) { Console.WriteLine(":::::::::: Adding provider :::::::::"); Provider p = new Provider { Name = "Instituto Nacional de Estatística", NameAbbr = "INE", ServiceURL = "http://localhost:42136/INEStatisticsProvider.svc", URL = "http://www.ine.pt" }; ProviderDAO provider = new ProviderDAO(conn); p.ID = provider.AddProvider(p); return p; }
static IEnumerable<ExtendedSubTheme> AddThemes(DbConnection conn, Provider p, INEService.Statistics ine) { Console.WriteLine(":::::::::: Adding themes :::::::::"); var themesDAO = new ThemesDAO(conn); var insertedThemes = new List<ExtendedTheme>(); var insertedSubThemes = new List<ExtendedSubTheme>(); INEService.Theme[] themes = ine.GetThemes(GEOVERSION, 2, LANGUAGE, 1, 100000); var filteredThemes = themes.Where(t => t.ThemeLevel == 2); foreach (var theme in filteredThemes) { Console.WriteLine("... Adding theme: {0} ....", theme.Designation); ExtendedTheme t = new ExtendedTheme { Name = theme.Designation, NameAbbr = theme.Designation, ProviderID = p.ID, SourceThemeCode = theme.Code }; t.ID = themesDAO.AddTheme(t); insertedThemes.Add(t); } // subthemes var filteredSubThemes = themes.Where(t => t.ThemeLevel == 3); foreach (var subtheme in filteredSubThemes) { Console.WriteLine("... Adding subtheme: {0} ....", subtheme.Designation); ExtendedSubTheme sub = new ExtendedSubTheme { Name = subtheme.Designation, NameAbbr = subtheme.Designation, ProviderID = p.ID, ThemeID = insertedThemes.Where(it => it.SourceThemeCode == subtheme.ParentCode).First().ID, SourceThemeCode = subtheme.Code }; sub.ID = themesDAO.AddSubTheme(sub); insertedSubThemes.Add(sub); } return insertedSubThemes; }