public void GetIndicatorByIdTest()
{
IndicatorDAO target = new IndicatorDAO(connnetion);
int providerId = 1;
int indicatorId = 1;
Indicator expected = new Indicator
{
ID = 1,
Name = "Densidade populacional (N.º/ km²) por Local de residência; Anual",
NameAbbr = "Densidade populacional (N.º/ km²)",
Provider = new Provider
{
ID = 1,
Name = "Instituto Nacional de Estatística",
NameAbbr = "INE",
ServiceURL = "http://localhost:42136/INEStatisticsProvider.svc",
URL = "http://www.ine.pt"
},
SourceID = "0000009",
SubThemeID = 1,
ThemeID = 1
};
Indicator actual;
actual = target.GetIndicatorById(providerId, indicatorId);
Assert.AreEqual(expected, actual);
}
public int AddIndicator(Indicator indicator)
{
using (IndicatorDAO.Connection = ConnectionSettings.CreateDBConnection())
{
return IndicatorDAO.AddIndicator(indicator);
}
}
public int AddIndicator(Indicator indicator)
{
return DbTemplateHelper<int>.GetValueByProcedure(
Connection,
"config.insertindicator",
new DbParameterHelper[]
{
new DbParameterHelper(DbType.String, "p_name", indicator.Name),
new DbParameterHelper(DbType.String, "p_nameAbbr", indicator.NameAbbr),
new DbParameterHelper(DbType.String, "p_sourceid", indicator.SourceID),
new DbParameterHelper(DbType.Int32, "p_themeid", indicator.ThemeID),
new DbParameterHelper(DbType.Int32, "p_subthemeid", indicator.SubThemeID),
new DbParameterHelper(DbType.Int32, "p_providerid", indicator.Provider.ID)
});
}
public static void addConfiguration(DbConnection conn, Indicator indicator, string lowestGeoLevel)
{
var configurationDAO = new ConfigurationDAO(conn);
for (int geoLevel = int.Parse(lowestGeoLevel); geoLevel >= 2; --geoLevel)
{
GEOLevels level = (GEOLevels)geoLevel;
Console.WriteLine("... Adding configuration: {0} ....", level.ToString());
DataStore.Common.Model.Configuration config = new DataStore.Common.Model.Configuration
{
GeoLevel = level.ToString(),
Shapefile = new Shapefile
{
ID = SHAPEFILE_IDS[level]
}
};
configurationDAO.AddConfiguration(indicator.ID, config);
}
}
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);
}
}
}
private static Mock<IIndicatorDAO> GetIndicatorDAOMock()
{
var indicator = new Indicator
{
ID = 1,
Name = "foo",
NameAbbr = "foo",
Provider = new Provider
{
ID = 1,
Name = "provider 1",
ServiceURL = "http://nowhere.com",
URL = "http://nowhere.com"
},
SourceID = "1"
};
var mockIndicatorDAO = new Mock<IIndicatorDAO>();
mockIndicatorDAO.Setup(m => m.GetIndicatorById(It.IsAny<int>(), It.IsAny<int>())).Returns(indicator);
return mockIndicatorDAO;
}
