public ActionResult ImportRecords(HttpPostedFileBase file) { var filePath = string.Empty; if (file != null && file.ContentLength > 0) { var fileName = Path.GetFileName(file.FileName); filePath = Path.Combine(Server.MapPath("~/App_Data/uploads"), fileName); file.SaveAs(filePath); } var records = new CsvReaderHelper().GetRecordsFromCsv(filePath); foreach (var record in records) { _recordRepository.SaveImportedRecord(record, Session["UserId"].ToString()); } if (System.IO.File.Exists(filePath)) { System.IO.File.Delete(filePath); } return(Redirect("Index")); }
private static IEnumerable <BPostData> GetPreviouslyImportedData() { var importedFiles = Directory.GetFiles(_importPath, "*.csv"); var latestFile = string.Empty; var latestImport = DateTimeOffset.MinValue; foreach (var importedFile in importedFiles) { var fileName = Path.GetFileNameWithoutExtension(importedFile); var timeStamp = DateTimeOffset.ParseExact(fileName, FileDateFormat, CultureInfo.InvariantCulture); // If the file date is smaller than our last import, we skip it if (timeStamp <= latestImport) { continue; } latestImport = timeStamp; latestFile = importedFile; } return(string.IsNullOrEmpty(latestFile) ? new List <BPostData>() : CsvReaderHelper.ReadBPostData(latestFile)); }
private void btnGenerate_Click(object sender, RoutedEventArgs e) { string path = txtFilePath.Text; int startIndex = int.Parse(txtStartFrom.Text); string prefix = txtPrefix.Text; XmlProperty.PropertyPrefix = txtPropertyPrefix.Text.Trim(); CsvReaderHelper.UseTaxonomy = radioUseTaxonomy.IsChecked ?? true; string classContent = CsvReaderHelper.ConvertFileToCode(path, prefix, startIndex); textEditor.Text = classContent; }
public ProfileContextSeed(CsvReaderHelper csvHelper, ILogger logger) { _csvHelper = csvHelper; _logger = logger; }
public ProfileContextSeed(CsvReaderHelper csvHelper) { _csvHelper = csvHelper; }
private static IEnumerable <PostalName> GetPostalNamesWithLanguage() { var filePath = $"{AppDomain.CurrentDomain.BaseDirectory}\\postalNamesLanguage.csv"; return(CsvReaderHelper.ReadPostalNames(filePath)); }