public async void ImportFrom_GoogleDocs() { var excelImport = RestApiApplication.CreateContainer().Resolve<Repository.Import.ExcelImport>(); var downloader = new GoogleDriveDownloader(); var documentId = Environment.GetEnvironmentVariable("BBR_GoogleDocId", EnvironmentVariableTarget.User); if(string.IsNullOrEmpty(documentId)) Assert.Fail("Cannot import if documentId is not set in environment variable"); var content = await downloader.LastNedSpreadsheetFraGoogleDrive(documentId); excelImport.LesInn(content); }
public async Task<HttpResponseMessage> ConvertMapToExcel(string documentId) { var downloader = new GoogleDriveDownloader(); var content = await downloader.LastNedMapFraGoogleDrive(documentId); var poster = _kmlToExcelPoster.LesInn(content); _excelWriter.SkrivPoster(poster); var bytes = _excelWriter.GetAsByteArray(); var result = new HttpResponseMessage(HttpStatusCode.OK) { Content = new StreamContent(new MemoryStream(bytes)) }; result.Content.Headers.ContentType = new MediaTypeHeaderValue("application/vnd.ms-excel"); result.Content.Headers.ContentDisposition = new ContentDispositionHeaderValue("attachment") {FileName = "kml_poster.xlsx"}; return result; }
public async Task<IHttpActionResult> ConfigureFromGoogleMap(string documentId) { var downloader = new GoogleDriveDownloader(); var content = await downloader.LastNedMapFraGoogleDrive(documentId); var poster = _kmlToExcelPoster.LesInn(content); var matchId = _matchProvider.GetMatchId(); MatchImport.ExcelMatch excelMatch; using (var context = _dataContextFactory.Create()) { var match = context.Matcher.SingleOrDefault(x => x.MatchId == matchId); excelMatch = MatchImport.ExcelMatch.FromMatch(match); excelMatch.DefaultPoengFordeling = "100,90,80,70,60"; // TODO: Lagre default fra import } _excelWriter.SkrivTilExcel(excelMatch, null, poster); var bytes = _excelWriter.GetAsByteArray(); _excelImport.LesInn(bytes); ClearCaching(); return Ok(); }
public async Task<IHttpActionResult> ConfigureFromGoogleDrive(string documentId) { var downloader = new GoogleDriveDownloader(); var content = await downloader.LastNedSpreadsheetFraGoogleDrive(documentId); _excelImport.LesInn(content); ClearCaching(); return Ok(); }