protected override void RunActualProcess() { var arr = ExcelHelper.ExtractDataFromExcel(@"U:\SimZukunft\RawDataForMerging\LeftoverAdressTranslationTable.xlsx", 1, "A1", "B400"); SqlConnection.RecreateTable <AdressTranslationEntry>(Stage.Raw, Constants.PresentSlice); var db = SqlConnection.GetDatabaseConnection(Stage.Raw, Constants.PresentSlice).Database; db.BeginTransaction(); for (var row = 1; row < arr.GetLength(0); row++) { var a = new AdressTranslationEntry(); if (arr[row, 1] == null) { continue; } a.OriginalStandort = (string)arr[row, 1]; if (arr[row, 2] == null) { throw new Exception("dst adress was null"); } a.TranslatedAdress = (string)arr[row, 2]; db.Save(a); } db.CompleteTransaction(); }
protected override void RunActualProcess() { string fn = CombineForRaw("LeftoverAdressTranslationTable.xlsx"); ExcelHelper eh = new ExcelHelper(Services.Logger, MyStage); var arr = eh.ExtractDataFromExcel2(fn, 1, "A1", "B400", out var _); var db = Services.SqlConnectionPreparer.GetDatabaseConnection(Stage.Raw, Constants.PresentSlice); db.RecreateTable <AdressTranslationEntry>(); db.BeginTransaction(); for (var row = 0; row < arr.GetLength(0); row++) { var a = new AdressTranslationEntry(); if (arr[row, 0] == null) { continue; } a.OriginalStandort = (string)arr[row, 0]; if (arr[row, 1] == null) { throw new Exception("dst adress was null"); } a.TranslatedAdress = (string)arr[row, 1]; db.Save(a); } db.CompleteTransaction(); }