public async Task <Result> InsertInJobTable(Guid jobId, IFormFile requestFile) { var result = await Result.Try(async() => { using (var ms = new MemoryStream()) { requestFile.CopyTo(ms); var fileBytes = ms.ToArray(); string encodedFile = Convert.ToBase64String(fileBytes); await _context.ImportJobs.AddAsync(new UploadJobsEntity { FileName = requestFile.FileName, Base64File = encodedFile, JobId = jobId.ToString(), JobStatus = JobStatus.NotStarted, // TODO: change here when db supports it // Started = DateTime.Now }); await _context.SaveChangesAsync(); } }, exception => LogException(exception, $"Error in method {nameof(InsertInJobTable)}")); return(result); }
public async Task <Result> CleanPreviouslyImportedData() { var result = await Result.Try(async() => { _context.ImportedPollingStations.RemoveRange(_context.ImportedPollingStations); await _context.SaveChangesAsync(); }, e => LogException(e)); return(result); }
public async Task <Result> RemoveAllPollingStations() { var result = await Result.Try(async() => { _context.PollingStations.RemoveRange(_context.PollingStations); await _context.SaveChangesAsync(); }, e => LogException(e)); return(result); }
public async Task <Result> StoreAddress(string county, string locality, string address, double latitude, double longitude) { return(await Result.Try(async() => { await _context.ResolvedAddresses.AddAsync(new Entities.ResolvedAddressEntity() { County = county, Locality = locality, Address = address, Latitude = latitude, Longitude = longitude }); await _context.SaveChangesAsync(); }, (e) => { _logger.LogError(e, "Error occurred"); return "Error occured"; })); }