public int AddConfiguration(int indicatorid, Configuration config)
{
using (ConfigurationDAO.Connection = ConnectionSettings.CreateDBConnection())
{
return ConfigurationDAO.AddConfiguration(indicatorid, config);
}
}
public int AddConfiguration(int indicatorId, Configuration config)
{
return DbTemplateHelper<int>.GetValueByProcedure(
Connection,
"config.addconfiguration",
new DbParameterHelper[]
{
new DbParameterHelper(DbType.String, "p_geolevel", config.GeoLevel),
new DbParameterHelper(DbType.Int32, "p_shapefileid", config.Shapefile.ID),
new DbParameterHelper(DbType.Int32, "p_indicatorid", indicatorId)
});
}
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);
}
}
public void GetConfigurationTest()
{
ConfigurationDAO target = new ConfigurationDAO(connnetion);
int indicatorId = 1;
string geoLevel = "NUTS1";
Configuration expected = new Configuration
{
ID = 1,
GeoLevel = "NUTS1",
Shapefile = new Shapefile
{
ID = 4,
FileName = "nuts1.shp",
Name = "NUTS1",
Path = "D:\\Dropbox\\My Dropbox\\Tese\\shapefiles\\sapo\\GIS\\NUTS1",
Level = 1
}
};
Configuration actual;
actual = target.GetConfiguration(indicatorId, geoLevel);
Assert.AreEqual(expected, actual);
}