public HausanschlussImport([NotNull] HausanschlussImport hai, [CanBeNull] string standort)
{
ObjectID = hai.ObjectID;
Egid = hai.Egid;
Isn = hai.Isn;
Lon = hai.Lon;
Lat = hai.Lat;
Trafokreis = hai.Trafokreis;
Standort = standort;
Adress = hai.Adress;
}
protected override void RunActualProcess()
{
string csvName = CombineForFlaSettings("EGID_ISN_InExports.xlsx");
var p = new ExcelPackage(new FileInfo(csvName));
var db = Services.SqlConnectionPreparer.GetDatabaseConnection(Stage.Raw, Constants.PresentSlice);
db.RecreateTable <HausanschlussImport>();
db.BeginTransaction();
ExcelWorksheet ws = p.Workbook.Worksheets[1];
int row = 2;
while (ws.Cells[row, 1].Value != null)
{
var filename = ((string)ws.Cells[row, 1].Value).Replace(".xml", "");
var objectid = (string)ws.Cells[row, 2].Value;
var egid = Convert.ToInt32(ws.Cells[row, 3].Value);
var isn = Convert.ToInt32(ws.Cells[row, 4].Value);
var lon = Convert.ToDouble(ws.Cells[row, 5].Value);
var lat = Convert.ToDouble(ws.Cells[row, 6].Value);
var adress = (string)ws.Cells[row, 7].Value;
if (lon > 360)
{
throw new FlaException("Lon über 360°");
}
if (lat > 360)
{
throw new FlaException("lat über 360°");
}
var o = new HausanschlussImport(filename, objectid, egid, isn, lon, lat, adress);
db.Save(o);
row++;
}
p.Dispose();
db.CompleteTransaction();
}
